Experience Summary

• Around 9 years as an ETL Consultant in software analysis, design, development, testing, implementation, maintenance and production Support
• Experienced in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using IBM Infosphere Datastage V8.5/8.1/7.5.3/7.5.1.
• Expertise in Retail and Pharmacy Domain.
• Proven track record in planning, building and managing successful large-scale Data Warehouse and decision support systems, Data Mapping, Data management, Data transportation and Data Staging.
• Proven expertise in Performance Tuning, Performance-Oriented design, Development, Trouble-shooting and coding for optimized functioning.
• Proven experience in Data Warehousing which includes Construction and analysis of Source Systems, Staging area & Target systems.
• Extensive experience in Unix Shell Scripting in different projects.
• Database experience in Oracle 9i, DB2 UDB and PL/SQL (Stored Procedures, Functions, Triggers).
• Thorough knowledge in designing and developing data marts, data warehouse using multi-dimensional models such as Snow Flake Schema and Star Schema.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.

CERTIFICATIONS

• IBM Certified Solution Designer - DB2 Business Intelligence
• IBM DB2 UDB Certified in Family Fundamentals
• Oracle 9i Certified in PL\\SQL Programming

Roles:

• Lead Consultant
• ETL Technical Architect
• ETL Technical Lead
• ETL Designer
• ETL Lead

Tools/Methods:

• DataStage V8.5/8.1/7.5.3/7.5.1
• UNIX
• DB2 UDB
• Micro Strategy
• Oracle 9i
• SQL Server 2008
• SSIS
• IBM CDC Tool
• Microsoft Visio
• Control-M
• Quality Center

Industry Application:

• Retail
• Health Care

Education:

• Master of Science in Software Engineering

TECHNICAL DOCUMENTS:

• Implementing Partitioning and Node allocation in Data Stage
• Standard Changes from ETL to ELT

Work Experience Summary:

Client: Confidential,AZ Apr 2011 to Present
Project: Mail Order Pharmacy
Role: Lead Consultant
Location Worked: Scottsdale , AZ
Technologies used: Fairfax, DataStage v8.5, Shell Scripts, SQL, DB2 UDB
Domain: Health Care

• Development and Support Lead for 7 critical applications which are part of Regional Order Creation Center (ROCC)
• Getting the prescription details via Mail Order, Fax, Faxback, Payment Only from Fairfax Application and e-prescription from Fast Start Application
• Developed Technical Requirement specifications with ETL process design flow, Error Handling, Assumptions, Constraints and Risks.
• Review of Datastage job, Control-M, Shell scripts, SQL’s.
• Review of performance test results.
• Performance tuning in queries and jobs.
• Developed subscriptions using IBM Change Data Capture Tool for capturing real time changes of data.
• Developed UNIX shell scripts for file FTP, Count matching process for data loads between different layers, wrapper scripts.
• Developed SQL scripts for loading of data.
• Maintained and worked the Maestro jobs and crontab for job scheduling
• Analyzed the root cause of several issues encountered in the system and assigned to the respective team
• I have taken the proper knowledge transition from the SME\'s and replaced them in 3 months without any deviation in the plan. We have followed KAP, Secondary and Primary Phase for knowledge transition.
• Had call with the application user every bi-weekly and resolved their issues as needed
• Made sure that the system is available for all times and did pro-active health check on the ROCC\'s and then escalated if we predict any scenario which will affect the system.
• Worked in analyzing the stored procedure and UNIX scripts for delay in the reports for daily basis.
• Performed onshore/offsite/offshore coordination across different time zones.

Client: Confidential,MN Oct 2009 - Mar 2011
Project: Merchandising System
Role: ETL Consultant/Technical Architect
Location Worked: Minneapolis, MN
Technologies used: DataStage v8.1, Shell Scripts, SQL, DB2 UDB, IBM CDC tool
Domain: Retail

• Analyzed Functional and business Requirements.
• Developed Technical Requirement specifications with ETL process design flow, Error Handling, Assumptions, Constraints and Risks.
• Review of Datastage job, Control-M, Shell scripts, SQL’s.
• Review of performance test results.
• Performance tuning in queries and jobs.
• Developed subscriptions using IBM Change Data Capture Tool for capturing real time changes of data.
• Developed UNIX shell scripts for file FTP, Count matching process for data loads between different layers, wrapper scripts.
• Developed SQL scripts for loading of data.
• Designed the process flow for job scheduling using Microsoft Visio.
• Developed Data stage jobs for various code fixes, recovery process.
• Control M scheduling / Monitoring.
• Performed onshore/offshore coordination across different time zones.
• Major complicated and success of this project is on design for the complicated scenario and high volume (around 18 billion)

Client: Confidential,MN Oct 2008 – Oct 2009
Project: Inbound Outbound Interface
Role: ETL Consultant/Technical Lead
Location Worked: Minneapolis, MN
Technologies used: SQL Server Integration Services 2008, SQL Server 2008, Visio
Domain: Pharmacy

• Understanding the Functionality of the entire project
• Validating the design document with the requirement document and come up with the extraction query for each interface
• Guiding the team by discussing my thoughts with them on technical and Functional aspect.
• Planning the work and working with the team effectively.
• Keep track of the entire project.
• For Daily Finance Reconciliation Report out of 5 reports, 2 reports has been delivered by me single handily and supported the other Reports on their deliverables.
• In RxR Interface (Most Complicated Interface) I have played a major role and also supported the other Interface.
• Resource planning, conduct onshore/offshore status meetings.
• Conduct various review meetings, inspection meetings and coordinating with various stake holders of the project.
• Created Source to target mapping document.
• Worked on very tight deadlines and aggressively for the completion of the Project

Client: Confidential,MN Sep 2008 - Oct 2008
Project: Expense management Initiative – Micro Strategy Adhoc Testing
Role: Test Lead
Location Worked: Chennai, India
Technologies used: Micro Strategy, DB2 UDB, UNIX, Quality center
Domain: Retail

For System testing

• Written the test cases based on the understanding of the functionality for each objects.
• Reviewing all the test cases before entering into the QC.
• Testing the objects based on the test cases in QC and loading the result in QC.
• Guiding the entire team to do testing effectively without missing any scenarios, helping them in understanding the functionality, writing queries
• Planning the work and distributing effectively.

Client: Confidential,MN Jun 2008 - Aug 2008
Project: Expense management Initiative – Weekly STL Analytics
Role: Test Lead
Location Worked: Chennai, India
Technologies used: Data stage v7.5.3, Shell Scripts, SQL, DB2 UDB, Quality center
Domain: Retail

For System testing

• Written the test cases based on the understanding of the functionality for each objects.
• Reviewing all the test cases before entering into the QC.
• Testing the objects based on the test cases in QC and loading the result in QC.
• Guiding the entire team to do testing effectively without missing any scenarios, helping them in understanding the functionality, writing queries
• Planning the work and distributing effectively.

Client: Confidential,MN Mar 2008 - May 2008
Project: Expense management Initiative – Development Release 2.0
Role: ETL Designer
Location Worked: Chennai, India
Technologies used: Data stage v7.5.3, Shell Scripts, SQL, DB2 UDB
Domain: Retail

• Analyzed Functional and business requirements
• Created Source to target mapping document.
• Prepared High level design documents for the reviewed requirement.

Client: Confidential,MN Dec 2007 - Feb 2008
Project: Expense management Initiative – HR
Role: ETL Designer
Location Worked: Chennai, India
Technologies used: Data stage v7.5.3, Shell Scripts, Oracle 9i, DB2 UDB
Domain: Retail

• Analyzed Functional and business requirements
• Created Source to target mapping document.
• Prepared High level design documents for the reviewed requirement.
• Since this data is very sensitive environment is made very secured

Client: Confidential,MN Jan 2007 – Dec 2007
Project: Expense management Initiative Phase 1.0
Role: ETL Lead
Location Worked: Chennai, India
Technologies used: Data stage v7.5.1, Shell Scripts, Oracle 9i, DB2 UDB
Domain: Retail

• Analyzed Functional and business Requirements.
• Impact analysis of existing applications.
• Creating traceability Matrix for the impacts across source systems.
• Created Datastage parallel shared containers and used across jobs.
• Handled restart ability logic across all jobs and scripts.
• Created Source to target mapping document.
• Preparation of High level, Low level design documents.
• Developed various parallel Datastage jobs using complex logic.
• Developed data cleansing jobs.
• Developed UNIX wrapper scripts, Shell scripts for validating the data.
• Developed sample test data according to Test cases.
• Developed Unit Test Case, System Testing documents with respective Test cases/Scenarios with expected results.
• Performed unit/Integration and system testing.
• Developed scheduling workflows through Control M scheduler.
• Performed volume testing/Performance testing.

Client: Confidential,MN Oct 2006 – Dec 2006
Project: EDW – Store Controllable Contribution Report
Role: ETL Lead
Location Worked: Chennai, India
Technologies used: Data stage v7.5.1, Shell Scripts, Oracle 9i, DB2 UDB
Domain: Retail

• Analyzed Functional and business Requirements.
• Impact analysis of existing applications.
• Created Source to target mapping document.
• Preparation of High level, Low level design documents.
• Developed various parallel Datastage jobs using complex logic.
• Developed data cleansing jobs.
• Developed UNIX wrapper scripts, Shell scripts for validating the data.
• Developed sample test data according to Test cases.
• Developed Unit Test Case, System Testing documents with respective Test cases/Scenarios with expected results.
• Performed unit/Integration and system testing.
• Developed scheduling workflows through Control M scheduler.
• Performed volume testing /Performance testing.

Client: Confidential,MN Jan 2006 – Sep 2006
Project: EDW – General Ledger
Role: Senior ETL Developer
Location Worked: Chennai, India
Technologies used: Data stage v7.5.1, Shell Scripts, Oracle 9i, DB2 UDB
Domain: Retail

• Involved in High level, Low level design documents.
• Developed various parallel Datastage jobs using complex logic.
• Developed UNIX wrapper scripts, Shell scripts for validating the data.
• Developed sample test data according to Test cases.
• Developed Unit Test Case, System Testing documents with respective Test cases/Scenarios with expected results.
• Performed unit/Integration and system testing.
• Developed scheduling workflows through Control M scheduler.
• Performed volume testing /Performance testing.

Client: Confidential,MN Mar 2003 – Nov 2005
Project: Guest Intelligence R2.0
Role: ETL Developer
Location Worked: Chennai, India
Technologies used: Data stage v7.5.1, Shell Scripts, Oracle 9i, DB2 UDB
Domain: Retail

• Involved in High level, Low level design documents.
• Developed various parallel Datastage jobs using complex logic.
• Developed UNIX wrapper scripts, Shell scripts for validating the data.
• Developed sample test data according to Test cases.
• Developed Unit Test Case, System Testing documents with respective Test cases/Scenarios with expected results.
• Performed unit/Integration and system testing.
• Developed scheduling workflows through Control M scheduler.
• Performed volume testing /Performance testing.
• Involved in full life cycle implementation of Store and Web Purchase GIF