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.