SUMMARY

• With around 10 years of experience as data warehouse specialist, have solid skills in analysis, business intelligence, system design, process flow, workflow, development, Test Cases, software development life Cycle, system testing, integration testing, experience on Informatica data quality tools for cleansing the data, implementation and Integration of various data sources such as Oracle, Fixed Width / Delimited flat files sources using Informatica Power Center 9.6/9.1/8.6, on Windows and UNIX.
• Experience with SQL server data tools like SSIS for creating ETL flows and also worked with SSRS for creation of reports based on analysis of data.
• Worked on IBM Info sphere Datastage to implement jobs for major American banking client and currently working for Confidential . Also have strong knowledge of RDBMS concepts, with hands on experience in the development of relational database environment using SQL, PL/SQL, Stored Procedures, Packages and UNIX shell scripting.
• A team player, quick learner and adaptive to new and challenging technological environments

TECHNICAL SKILLS

Operating System: - Windows XP/7, HP-UX, AIX, Mainframe

Database: - Netezza, Oracle 9i/10g/11g, Microsoft Syl server 2008/2012, DB2

Languages: -SQL, PL/SQL, Shell scripting

Tools: -Informatica Power Centre 8.6/9.1/9.5, Informatica Data quality IDQ 9.xSSIS and SSRS: 2012, IBM Info sphere Data Stage 8.x/11.x, SQL Developer, TOAD, Harvest(Version Control),Message queues, Microsoft Visual StudioESP: scheduler, Tableau, MS Office Access, Excel, Word, and PowerPoint

PROFESSIONAL EXPERIENCE

ETL developer

Confidential

Responsibilities:

• Analysis, designing and creating data stage jobs.
• Extract, transform and load data from variety of data sources.
• Analyse and execute test cases for various phases of testing - integration, regression and user.
• Prepare and execute implementation plan.
• Collaborate with Project Managers, Database Administrators and Business analysts.
• Perform analysis to support development process.

Environment: Data stage, IBM Netezza, DB2, Unix, Mainframe

ETL developer

Confidential

Responsibilities:

• Involved with designing and creating Informatica mappings.
• Collect and integrate data from new data sources.
• Evaluate existing BI system for prospective improvements.
• Worked on data flow process modelling.
• Involved in data preparation for the data mining team that help data miners to identify the gaming patterns of the users.

Environment: -Informatica Power Centre 9.6.1, Microsoft SQL server, Agile methodology

Data Specialist ETL

Confidential

Responsibilities:

• Profiled and tested Data Quality.
• Worked to resolve source data issues and refine transformation rules.
• Modifying already developed ETLs to handle change requests from client.
• Understand the data quality rules defined by the business / functional teams, and propose the optimization of these rules if applicable. And, then design and develop these rules, including unit test planning and performing.
• Implemented changes in the Production applications to handle exceptional data.
• Worked as lead to direct the team to handle the requirements and support the production applications.
• Created unix scripts for managing files coming from source.

Environment: -Informatica Power Centre 9.5, Informatica Data Quality IDQ 9.x, TOAD, ESP scheduler, Unix, Agile methodology

Data Specialist ETL

Confidential

Responsibilities:

• Development of packages as per the requirements from the client.
• Modifying already developed ETLs to handle change requests from client.
• Worked on creating reports and dashboards based on the statistical analysis of the data from various time frame and division using SSRS.
• Involved in query optimization to increase the performance.

Environment: -SQL server data tools - SSIS, SSRS Reporting, SQL server 2012, Microsoft Visual Studio

Senior Developer

Confidential

Responsibilities:

• Used SSIS to create ETL packages.
• Developed and optimized stored procedures and views for the application.
• Involved in creation of data for SSRS reports.
• Developed ETL scripts with C#, VB.NET.

Environment: -SSIS and SSRS 2012, SQL server, ESP scheduler, Agile methodology

Senior Developer

Confidential

Responsibilities:

• Analyzed client’s requirements and prepared technical solutions for the same.
• Deployed ETL jobs to address the business requirements, worked on unit testing and support post go live of the system.
• Preparing test cases and performed end to end testing of the processes.
• Involved in preparation of High Level Design Document (HLD), Low Level Design Documents (LLD).
• Participate in design and development reviews.
• Worked extensively on unix scripting to monitor workflows.

Environment: -Informatica Power Center 9.1, SQL Developer, IBM message queues, Harvest ( Version Control), Unix, Agile methodology

Assistant Systems

Confidential

Responsibilities:

• Understanding Business requirements.
• Understanding the functionality changes in existing systems.
• Developing new & modifying existing components.
• Preparing Specifications documents.
• Integration testing and performance testing.
• Pre-production implementation reviews of deliverables.
• Defect prevention and causal analysis activities.

Environment: -IBM Infosphere Data stage 8.7, SQL, Agile methodology

Assistant Systems

Confidential

Responsibilities:

• Requirements gathering and requirement analysis.
• Extensively used Informatica Power center for loading the data from various sources involving flat files and oracle tables to Data warehouse.
• Involved in preparation of High Level Design Document (HLD), Low Level Design Documents (LLD).
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
• Worked on various transformations used in Informatica.
• Involved in unit testing.

Environment: - Informatica Power center 8.6, TOAD, Harvest, Unix, Oracle