| Candidate Information | | Title | Data Engineer Sql Server | | Target Location | US-FL-Miami Gardens |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateJARVISWILSONPhoneEmailLinkedIn ProfileOBJECTIVEInnovative, result driven Data Engineer with 5 plus years of work experience in SQL, database design, database modeling, big data, analysis and reporting across many industries to include:healthcare, transportation, real-estate banking etc. Knowledge of SDLC to provide end-to-end business intelligence solutions to ensure companies better return on investment.Recognized throughout my career for demonstrating the ability to organize and complete complex projects and tasks while meeting deadlines in high volume workload environments. I am a goal-oriented team player with strong problem solving, analytical, and communication skills.EDUCATIONBA Florida International UniversitySKILLSETL/Data warehousingSQL ServerData Analysis & VisualizationData MiningData QualityData ArchitectMS SQL Server Mgmt. StudioSSISSSRSSSAS.NetAzure Dev OpsSnowFlakeDatabase AdministrationMicrosoft Office ToolsSharePointData ModelingAgile/Waterfall MethodologiesPerformance TuningEXPERIENCESr. Developer Norwegian Cruise LineNOVEMBER 2022 CURRENTPROJECT: NATIONAL INSTITUTION OF HEALTH (NIH)Data Delivery creating pipelines, schemas, database modeling, stored Procedure and SQL for client projects.Performance tuning and Query Optimization to improve business processes for existing and new projectsBuild complex stored procedures and write advanced SQL queries to improve and maintain daily operationsDevelop Complex ETL packages to include logging, error handling, and notificationsCreated database diagrams, data mapping diagrams, and database models including OLTP, OLAPAssisted with business requirement gathering and documentation for projectsManage and configure data in Staging, ODP, PROD, and QA environmentsData Warehousing, Data analysis, data modeling and database designManage SQL Server agent jobs and schedulesProvide project transparency and details through Jira ticketing systemPackage Deployment and SQL Automation processesManipulate and manage data from multiple databases including sql server, oracle, and snowflakeDemonstrated core leadership abilities by assisting team in redesigning existing reports proc todevelop and distribute reports to top management and various stakeholders more efficiently.Oversee database development as well as gathering, specification and data mapping document for development of SSIS ETL projectsSr. Consultant DeloitteJUNE 2021 NOVEMBER 2022PROJECT: NATIONAL INSTITUTION OF HEALTH (NIH)Head client projects and delivery high end solutionsImplementation of SDLC including gathering, analysis, Implementation, testing and deploymentUtilize Azure Dev ops for source control to update and load project pipelines and code.Query Optimization, and performance tuning for current and new processesCreated database diagrams, data mapping diagrams, and database modelsAssisted with data gathering, design, documentation, and implementation for client projectsData Warehousing, Data analysis, data modeling and database designPackage Deployment and SQL Automation processesFacilitate distribution of reports to management and stake holdersETL architecture development and design for SSIS packages and other existing pipelinesPROJECT: FIRM INITIATIVE (NHLBI)Constructed a ETL process to extract and load data for reporting and analysisWorked with client for requirement gathering, warehouse design and modelingDelivered detailed analytics on client project and delivered descriptive reports of trends and measurementsDeployed Solution to client in a timely matter ahead of deadlineETL Data Warehouse Developer/Data Engineer Colaberry Inc.2015- JULY 2021Designed, implemented, and maintained Database Schemas, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.Performance Tuning and Query Optimization to improve business applications.Used SSIS to create ETL packages to validate, extract, transform and load data to the data warehouse database from various sources like json, csv, Text Files, XML, Excel, and compatible databases across the network.Analyzing the data to implement incremental/data load using a merge statement. Utilized Slowly changing dimensions type one, two, three, four as needed.Held accountable for designing SSIS packages using several transformations to perform data profiling, data cleansing and data transformation.Orchestrating process to create parameterized reports, drill down, and drill through reports using SSRS.Held accountable for creating dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirement using SSRS.Rendering report in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscription.Monitored SSIS packages validation, errors handling, optimization and deployment.Achieved goals by actively working on all processes related to the development, implementation, administration, and support of the SSIS ETL.Served as a collaborative team member within both project management and software development life cycles (SDLC) including analysis of business functions, design, development, testing and documentation as required by end-users.Utilized SSIS to create ETL packages (.dtsx files) that validated, extracted, transformed, and loaded data to data warehouse database and processed SSAS cubes that stored the data in aggregated format for analysis.ACTIVITIESNCAA Division I College Football Player at Florida International UniversityFIU Big Brother Big Sister Community ServiceFIU Take Back the Night Community ServiceHugh O Brien Leadership AmbassadorAWARDSDeloitte Applause Award from NIAD AVID for contribution on Uganda project as back-end developer |
