Design and Development of ETL Resume

EXPERIENCE SUMMARY

9+ years of IT industry experience wif Microsoft SQL Server 2005/2008 R2/2012/2014, SSIS, Power Pivot, SSRS and Power BI.
Extensive experience in BI Solutions (ETL & Reporting) using SSIS, Power pivot, SSRS, Power BI, Netezza and T - SQL Programming using DDL, DML, and DCL commands for various business applications.
Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
Experience in Error handling and debugging coding issues and troubleshoot production problems.
Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
Experience in SQL Optimizing by using SQL Profiler, Database Tuning Advisor, and Query Execution Plans.
Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities.
Hands on experience wif performing various SSIS data transformation tasks like Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
Good understanding of Normalization /De-normalization and database design methodology.
Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views,
Indexed Views, Stored Procedures, and Cursors on Microsoft SQL Server.
Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers
To facilitate efficient data manipulation and data consistency as well as to support the existing Applications.
Expertise includes FACT & Dimension Tables
Knowledge of SSAS.
Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.
Worked in United States as onsite coordinator, ETL and Report developer.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008 R2/2012/2014, Netezza and MS- Access

Tools: SSMS 2008 R2/2014, SSIS 2005 / 2008, Power pivot, SSRS and Power BI

O.S.: Windows XP/7/8, Windows Server 2008

PROFESSIONAL EXPERIENCE

Confidential

Design and Development of ETL

Responsibilities:

Requirement Analysis, Design and Development of ETL and reports
SSIS ETL Package Development, Testing and Bug Fixing.
Worked on Power pivot, SSRS and Power BI report development.
Database: Microsoft SQL Server 2008 and Netezza.
Preparing Technical Documentation, Application Designing.
Status Reporting as well as resolve business ad-hoc queries.
T-SQL Development - Mainly worked on Procedures, functions, triggers, constraints, tables and Index creation and exception handling in SQL Server.
Code reviews and Issue management.

COnfidential

Responsibilities:

Worked as Associate-Projects in the onshore team
Responsibilities include Interaction wif client for Requirement Analysis, Design and Development
Status Reporting as well as resolve business ad-hoc queries.
SSIS Package Development, Testing and Bug Fixing.
Worked on SSIS, SSRS 2008 R2 and Microsoft SQL Server 2008.
T-SQL Development - Mainly worked on Procedures, functions, triggers, constraints, tables and Index creation and exception handling in SQL Server.
Review of the SSIS and SQL server code.

Confidential

Responsibilities:

Worked to understand the requirement and implemented the same.
SSIS Package Development, Testing and Bug Fixing.
T-SQL Development - Mainly worked on Procedures, functions, triggers, constraints, tables and Index creation and exception handling in SQL Server.
Worked on SVN -used for version controlling.
Review of the SSIS and SQL server code.

COnfidential

Associate

Responsibilities:

SSIS Package Development to migrate data from excel files, Testing and Bug Fixing.
T-SQL Development - Mainly worked on Search Procedures, functions, constraints, tables and Index creation and exception handling in SQL Server.
Worked on Microsoft VSS for version controlling.
Worked on requirement analysis and implemented the same.

Confidential

Database Developer

Responsibilities:

Mainly worked on Stored Procedures which were used as source for reporting.
Creating triggers to audit data, functions, constraints, tables and Index creation and exception handling in SQL Server.
Worked on SQL jobs for daily management reporting.
Maintaining database - backup, restore and SQL jobs.
Worked on Microsoft VSS for version controlling.
Worked on requirement analysis and implemented the same.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship