We provide IT Staff Augmentation Services!

Etl Resume

Scottsdale, AZ

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

Hire Now