SUMMARY

• 5+years of Professional experience as an ETL Developer working on SQL server, Business Intelligence tools, Database Design, Data Modeling and Data warehousing projects.Worked extensively on SQL server management studio, SQL server 2017/2016/2014/2012/2008 R2 and BI tools such as SSIS, SSRS, SSAS, Power BI and tabular data modeling including MS solutions like MS EXCEL., DB2, and MS Access Database.
• Designed ETL package using teh methods for slowly changing dimensions type 1, 2, and 6.
• Designed and developed ETL and Data Quality mappings to load and transform data from source to DWH using PowerCenter.
• Worked on all aspects of teh ETL pipeline, as well as aggregated and reported on operational system metrics, using Microsoft BI stack like SQL Server, SSIS, SSRS and SSAS.
• Expertise in building complex ETL packages using varied and complex data sources and merging them into a single data model.
• Skilled in project management using teh Jira Ticketing tool.
• Complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Experience in Optimizing Cubes using SQL Server Analysis Services (SSAS).
• Strong in database creation, maintenance, monitoring, backups and recoveries usingSQLServer Agent, Import/Export Wizard and Maintenance Plans.
• Advanced reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross - Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Transform data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Proficient in gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining.
• Exceptional leader with excellent interpersonal skill, communication finesse and Team management skill with strong expertise in analyzing teh requirements and preparing teh specifications document based on teh requirements.

TECHNICAL SKILLS

BI Tools: SQL Server, SSIS, SSAS, SSRS,Tableau 9.0/10.3

Data Warehousing: Kimball Dimensional modeling technique includes Star-Schema and Snowflake-schema concepts

Unit Testing (TSQL): TSQLT

Concepts: Object Oriented Design/Principles/Patterns, UML, Refactoring

Quality Assurance: Test Plan Development and Execution, Issue Tracking, Test Automation, Support/Incident Management, Release Management

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer/Enterprise Data Warehouse Developer

Responsibilities:

• Developed and modified ETL processes and workflows that load data for teh data warehouse using ETL tools (transitioning from SSIS to Azure integration technologies) and SQL code.
• Built robust and scalable data integration (ETL) pipelines using SSIS, T-SQL, and C#
• Built and delivered high quality data architecture to support business analyst, data scientists, and customer reporting needs.
• Interfaced with other technology teams to extract, transform, and load data from a wide variety of data sources.
• Performed database testing on data warehouse by using complex SQL queries in SQL Server to validate data.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Performed loading and transforming of large sets of structured, semi structuredand unstructured data
• Created data modeling (ER Diagrams), designed mockups and object class modeling to develop business architecture for rapid and controlled application development.
• Built / supported Health Claims Data Warehouse
• Participated in designing and development of software using agile development practices
• Implemented code check-in/check-out and managed multiple versions of complicated code within GIT.
• Created technical documentation and code comments based on industry standards.
• Used different transformations like SFTP Task, Script task, Fuzzy Lookup, Derived column, File System Task, Conditional split, Multicast transformation, pivot etc., using SSIS.

Environment: SQLServer 2017,SSIS, Visual Studio 2017/2015, GIT.

Confidential

ETL Developer

Responsibilities:

• Worked on creating dimensional models using star schema and snowflake schema.
• Designed Facts and Dimensions that supports teh business requirements and reporting needs.
• Created ETL packages with different data sources (SQL Server, Oracle Source, Flat Files, Excel source files) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS packages
• Worked on Creating SSIS Packages to load teh files from SFTP Path on daily basis.
• Created SSRS inventory management reports, focused on findings to save company millions of dollars in Client members Performance Health management by providing Incentive, Claims, Biometrics file feeds.
• Created a job to send teh HL7 files to teh clients as per teh changing requirements.
• Worked on Creating, Modifying and updating teh Views and Functions.
• Modified teh existing stored procedures to get teh new functionality depending on teh client requirement.
• Extensively worked on Views, CTE's, schemas, permissions issues with client/server database design.
• Worked on creating Power BI Dashboards using tabular model.
• Data Visualization development using Tableau to create complex, and innovative dashboards. Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports.
• Wrote Calculated Columns, Measures, and Queries inPowerBIdesktop and also Tabular model to show good data analysis techniques.
• Migrated SSRS Reports from Reporting Server
• Created and Deployed reports using SSRS and configuring teh SQL Server Reporting Server

Environment: SQLServer 2017,SSIS, SSRS, Visual Studio 2017/2015, TFS (2015).

Confidential

ETL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment for SQL Server 2008R2.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs.
• Defined relationship between tables and enforced referential integrity.
• Involved in Implementation of Database design and Administration of SQL based database.
• Established connectivity to database and monitored systems performances.
• Performance tuning and monitored both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform teh Data & worked extensively in T-SQL for various needs of teh transformations while loading teh data.
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

Environment: SQL Server 2008R2, Windows server, Enterprise Manager, SQL Profiler, SQL Query Analyzer, DTS, T-SQL.