We provide IT Staff Augmentation Services!

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.

Hire Now