Data Engineer Resume

SUMMARY

Experience in data modeling, dimensional modeling, SQL programming, data analysis and reporting
Over 5 years developing databases and building warehouses/ data marts for transactional and analytical purposes
Knowledge and experience in building data and business intelligence solutions at an enterprise level
Multiple years of experience designing and maintaining ETL solutions using S.S.I.S
Knowledge and experience in building robust and scalable data models for transactional / reporting purposes
Proficient in Structured Query Language (SQL) and Data Analytic Expressions (DAX)
5 years of experience building analytical solutions using MS PowerBI and Excel.
Familiar with various development tools such as SQL Server Management Studio (SSMS), Visual Studio and Git

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer

Responsibilities:

Architected and designed multiple data marts and data warehouses to support operational and analytical reporting purposes; Created Bus matrix, dimensional models, and physical models
Developed and maintained customized Extract - Transform-Load (ETL) processes using S.S.I.S to refresh organization’s data marts and data warehouse from transactional data sources
Participated in all phases of the development lifecycle for new subject areas; gathered requirements, analyzed data quality and business rules, dimensional modeling and database architecture, developed Extract-Transform-Load (ETL) processes, and data presentation to the end-user.
Created numerous simple to complex queries involving joins, CTE, cross and outer apply Pivot, correlated sub-queries, cursors and JSON to accomplish various business requirements.
Created stored procedures, triggers, functions and table types to support enhancements to existing transactional and OLAP systems.
Implemented change tracking mechanism using CDC (Change data capture) on transactional databases
Created business and technical documentation for knowledge transfer and provide understanding into reports artifacts and data sources
As part of a team, refactored parts of the enterprise data warehouse for scalability and performance purposes
Designed and implemented appropriate indexes on dimensions and facts tables for performance purposes
Performed query optimization of slowly running queries using indexing strategies and code re writes.
Re Architected the data extraction and delivery process to external clients; Data is retrieved from disparate sources, transformed and sent via secured FTP processes to internal and external clients
Provided production support for mission critical transactional databases.

Confidential

Associate Data Engineer

Responsibilities:

Designed and implemented data warehouse architecture using dimensional modelling techniques
Participated in all phases of the development lifecycle for a new subject area; gathered requirements, analyzed data quality and business rules, dimensional modeling and database architecture, developed Extract-Transform-Load (ETL) processes, and data presentation to the end-user.
Performed data mapping, data validation and migration of data from a legacy system to Microsoft SQL Server
Created numerous simple to complex queries involving joins, CTE, cross and outer apply Pivot, correlated sub-queries, cursors and JSON to accomplish various business requirements.
Extracted, transformed and aggregated data from multiple data sources into data marts using SSIS
As part of a team, created SSIS package templates with customized logging and error handling options.
Refactored multiple manual report generation processes by automating data retrieval, transformation and delivery using SSIS and Excel
Developed stored procedures, triggers, user defined functions and views to implement business logic in transactional databases.

Confidential

Data Analyst

Responsibilities:

Built Pivot tables and charts using Excel to showcase behavioral activities over time for residents .
Created advanced Excel formulas to extract pertinent data from worksheets and to transform data (Data Cleansing) prior to loading into models for reporting purposes.
Performed root cause analysis using SQL to uncover underlying data issues in Excel reports and dashboards.
Leveraged data visualization tools (Excel) to support data analysis in the development of standard and Ad hoc report.
Maintained documentation related to reporting platform guidelines, methods and standards.
Created and maintained highly visible Excel based reports and dashboards for analytical purposes.
Created multiple T-SQL queries to analyze, troubleshoot, and cleanse data used for reporting purposes.
Collaborated with business units to design custom reporting solutions that matched their needs with current business objectives.
Followed proper procedures in emergency situations and responds promptly and positively to resident requests for assistance-including emergency pull cords, telephone calls, and requests from family and friends.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship