SQL / ETL Developer Resume

SUMMARY:

BI/SQL Developer with 5 years of experience building complex ETL packages, Database models and Reporting. Worked in Agile environments specifically Scrum.
Over 5 years professional experience in the IT Industry as a Business Intelligence Developer.
Proficient in SQL Server 2016/2014/2012/2008/2005 .
Excellent communication skills within team as well as working cross departments.
Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Design, Development and Implementation.
Expert in troubleshooting job failures in a timely manner to minimize system delays or downtime.
Specializes in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts and data marts.
Specializes Experience in creating Ad Hoc T-SQL scripts, SSIS packages.
Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
Highly proficient in the use of T-SQL for developing complex stored procedures, tally tables, triggers, functions, and merges.
Experienced in Power BI creating dashboards and reporting using Live Connection and Direct Query.
Proficient in identifying predecessors and successors for job scheduling.
Skilled in performance monitor/SQL profiler to solve dead locks/long running queries.
Expert using data analytic tool Alteryx designer and connect multiple data.

TECHNICAL SKILLS:

Languages: T-SQL

Web Technologies: XML; JSON

Databases: SQL Server 2016/2014/2012/2008/2005 , MS Access, MongoDB, GCP - Google Big-Query

Data Modeling Tools: Microsoft Visio 2003/2007/2010/2013 , ER Studio

Reporting Tools: Power BI

ETL Tools: SQL Server Integration Services (SSIS)

Analytic Tools: Alteryx

Database Tools: SQL Server Management Studio, SQL Server Query Editor, SQL Query Analyzer

Operating Systems: Windows / 98/2000/2003/ XP/Vista/Windows 7/Windows 10

PROFESSIONAL EXPERIENCE:

Confidential

SQL / ETL Developer

Design, develop, and implement SSIS packages and projects to efficiently process high-volumes of data from multiple sources and meet nightly processing windows requirements.
Utilized SSIS Project Configuration to enable ease of deploying between dev, test, stage, and prod servers, by configuring environment variables to assign project parameters.
Added additional error handling for low priority jobs to archive bad data to a shared folder where on call developer would review and fix the file during normal business hours to avoid midnight or early morning calls between developers and DBA’s.
Upgraded 2008R2 SSIS packages to 2013 SSIS and converted to project configuration.
Responsible for the development and management of Enterprise Data Warehouse processes and policies, following strategic direction on best practices for holistic Data Architecture.
Conduct analysis and design of data models for the development and maintenance of existing Enterprise systems.
Create and maintain comprehensive documentation describing the structure, configuration, and functionality of data management systems and data structures.
Review and create logical and physical design and stored procedures.
Work with IT and Business users to help implement solid, extensible warehouse models that support new analytic requirements using the most relevant techniques.
Provided Unit Testing and QA where needed.

Confidential

Consultant SQL / ETL Developer

Developed SSIS packages using best practices for performance, as well as event error handling and dataflow error handling.
Utilized SSIS Project Configuration to enable ease of deploying between dev, test, stage, and prod servers, by configuring environment variables to assign project parameters.
Replaced all existing C# ETL feeds that were running long and iterating row by row with SSIS packages to ensure nightly batch processing would complete on time.
Utilized SQL Compare to compare data between existing C# feeds and new replacement SSIS feeds for data validation.
Utilized multiple data sources including SQL, Oracle, CSV, and XML
Wrote technical documentation for all feeds, reports, and stored procedures.
Developed hierarchal reporting utilizing recursive CTE’s.
Optimized existing long running stored procedures that utilized inner and outer cursors by rewriting the script using joins and tally tables to eliminate the need for cursors and loops.
Implemented indexing on tables to aide in system performance.
Met with clients to gather project requirements.
Hosted meetings to demo the packages and UI alongside the technical documentation for final client approval
Utilizing a Business Requirements Document, created Power BI models for the Dashboard for well data.
Created Feed Testing Documentation
Cross tested and QA coworkers SSIS packages, Stored Procedures, and Reports.