Sql / Etl Developer Resume
5.00/5 (Submit Your Rating)
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.