PROFESSIONAL SUMMARY:

• Over 10 years of IT experience in Analysis, Design, Development, Implementation and Testing of Data warehousing and Data Integration technologies and Applications.
• 9 years of technical experience with strong knowledge base in Extraction Transformation Loading(ETL) applications for Datawarehouse using DataStage 11.3/9.1/8.7/8.1/7.5 (Parallel Extender & Server), Quality Stage and Unix Shell Scripting, including 1 year of PL/SQL experience
• 2 years of technical experience in web service development and BizTalk development
• 2 years of technical experience in SOA environment
• IBM Certified Solution Developer, InfoSphere DataStage v8.0
• Oracle Certified PL/SQL Developer Associate, Oracle 9i
• Hands on experience in writing, testing and implementation of Oracle SQL queries, PL/SQL Triggers, Procedures and Functions
• Good knowledge and understanding of Data Warehousing concepts and Unix.
• Experience in dealing with Business Analysts and Subject Matter Experts to gather requirements and understand Business needs
• Played significant role in various phases of Software Development Life cycle(SDLC)
• Team Player and quick learner with excellent Analytical and Problem solving skills
• Good Communication and Interpersonal Skills, resulting in excellent rapport with employees and executive management.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere DataStage 11.3,9.1,8.7,8.1,7.5

Business Intelligence Tools: Cognos

Programming Languages: SQL, PL/SQL

Databases: Oracle 9i/10g/11i, MS SQL Server 2000

Version Control Systems: Microsoft VSS, IBM Rational Clearcase, Solution Manager, Subversion

Platforms: UNIX AIX, Red Hat Linux, Win 9x/NT/XP

Engineering Tools: Eclipse, MS - Office, Notepad++

Database Tools: PL/SQL Developer, Oracle SQL Developer, SQL Plus, Toad

Operating Systems: Windows NT/2K/XP, AIX UNIX, Sun Solaris, REDHAT LINUX

Scheduling tools: Autosys, Unix Cron, Control M

PROFESSIONAL EXPERIENCE:

ETL/Datastage Senior Consultant

Confidential, Chicago, IL

Responsibilities:

• Lead and manage the team by assigning action items as per requirements.
• Convert Functional requirements to Technical requirements by developing mapping specifications for building the Datawarehouse for Europe supply chain
• Design Technology solution to cater to client requirements
• Lead and manage the team in all phases of SDLC starting from Build, System Integration Testing to Deployment.
• Analyze the Change Requests and update the Technical Specifications documents
• Coordinate and resolve technical and functional queries of the team during development and testing.
• Communicate effectively in meetings with onsite and offshore.
• Perform Code and System Integration Testing reviews.
• Prepare ETL Run Book for the Support team
• Prepare Deployment document and ensure successful deployment of the project.

Environment: IBM Information Server 8.7/11.3, Datastage, Oracle, Ctrl M, UNIX AIX.

Confidential

Responsibilities:

• Convert Functional requirements to Technical requirements
• Design Technology solution to cater to client requirements
• Drive technical Activities at each phase of project
• Manage work of the team and send out action items
• Coordinate with onsite on requirement gathering and status updates
• Resolve technical issues in daily run of jobs in the project
• Analyze the Change Requests and update the Technical Specifications documents
• Enhance ETL Datastage Jobs to implement the business logic of the Change Request
• Unit Test the Code in Development Environment
• Migrate the code to SIT environment and perform the System Integration Testing
• Communicate effectively in meetings with onsite and offshore.
• Perform Code reviews to ensure that the code follows Datastage Coding standards
• Involved in end to end SDLC phases until the code moves to production

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX.

Confidential

Responsibilities:

• Convert Functional requirements to Technical requirements
• Design Technology solution to cater to client requirements
• Drive technical Activities at each phase of project
• Manage work of the team and send out action items
• Coordinate with onsite on requirement gathering and status updates
• Analyze the Change Requests and update the Technical Specifications documents
• Enhance ETL Datastage Jobs to implement the business logic of the Change Request
• Unit Test the Code in Development Environment
• Migrate the code to SIT environment and perform the System Integration Testing
• Communicate effectively in meetings with onsite and offshore.
• Perform Code reviews to ensure that the code follows Datastage Coding standards
• Involved in end to end SDLC phases until the code moves to production

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX

Confidential

Responsibilities:

• Analyze the Change Requests and update the Technical Specifications documents
• Update the Data Mapping documents as per the requirement
• Enhance ETL Datastage Jobs to implement the business logic of the Change Request
• Unit Test the Code in Development Environment
• Migrate the code to SIT environment and perform the System Integration Testing
• Coordinate with onsite on requirement gathering and status updates
• Communicate effectively in meetings with onsite and offshore.
• Perform Code reviews to ensure that the code follows Datastage Coding standards
• Involved in end to end SDLC phases until the code moves to production

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX

ETL/DataStage Consultant

Confidential

Responsibilities:

• Develop ETL Jobs to extract data from JDE source systems and load into Staging database
• Develop ETL Jobs to extract data from Staging source systems and load into RDW database
• Developed Job Sequencers to load data
• Developed Ctrl M Code for scheduling the load
• Implemented reusability in design by using generic jobs and multiple instance
• Performed Code reviews to ensure that the code follows Datastage Coding standards
• Interacted effectively in meetings to discuss business requirements
• Worked on enhancements of ETL code as per the Change Requests
• Involved in end to end SDLC phases until the code moves to production
• Effectively done the System Integration testing of all the Change Requests

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX

ETL/DataStage Consultant

Confidential

Responsibilities:

• Develop ETL Jobs to extract data from SQL Server source systems and load into DB2 database
• Developed Shell scripts and Job Sequencers to load data
• Developed Autosys Code for scheduling the load
• Suggested Performance Enhancements to reduce loading times
• Implemented reusability in design by using generic jobs and multiple instance
• Performed Code reviews to ensure that the code follows Datastage Coding standards
• Handled Support issues and solved within SLA
• Performed Migration of IIS code for UAT and Production Environments
• Implemented the IIS code in Disaster Recovery Environment
• Interacted effectively in meetings to discuss business requirements
• Effectively Planned the Migration activity and implemented successfully
• Received Appreciation for dedication and commitment towards the deliverables

Environment: IBM Information Server 8.1, DB2, Datastage, Autosys, UNIX AIX, SSH Tectia Client.

Confidential

Responsibilities:

• Migrate the code from Informatica to DataStage 8.1 by designing reusable jobs in DataStage
• Develop ETL Jobs to extract data from Oracle source systems and load into DB2 database
• Developed Shell scripts and Job Sequencers to load data
• Developed Autosys Code for scheduling the load
• Suggested Performance Enhancements to reduce loading times
• Implemented reusability in design by using generic jobs and multiple instance
• Performed Code reviews to ensure that the code follows Datastage Coding standards
• Handled Support issues and solved within SLA
• Interacted effectively in meetings to discuss business requirements

Environment: IBM Information Server 8.1, DB2, Datastage, Autosys, UNIX AIX, SSH Tectia Client

DataStage Consultant

Confidential

Responsibilities:

• Develop ETL Jobs to extract data from DB2 source systems and load data into Marketing and Sales Data Marts based on business logic
• Develop ETL jobs to load rejected data into tables
• Design & Develop Sequencers for loading data
• Executed Control M scripts to run the Sequencers
• Transported ETL Jobs into QA environment
• Perform Code reviews to ensure that the code follows Datastage Coding standards
• Implemented Best practices in Job Design and Development
• Interacted with Onsite to gather requirements

Environment: SunOS 5.10, IBM Information Server 8.0, Datastage, DB2, Control M

Confidential

Responsibilities:

• Develop ETL Jobs to extract data from SAP systems and load into SAP Business Information Warehouse using the Data Mapping Specifications
• Develop Jobs to load data into XML Flat Files using the XML output Stage
• Design and implement logic for converting Full loads into Delta for reducing the loading times of Master Data Objects
• Interacted with the Master Data Management Team to gather Business Requirements
• Design & Develop Sequencers for loading Master & Transaction Data Objects
• Written and Executed Unix Shell Scripts for use in Before Job routines in the DataStage Jobs
• Transported ETL Jobs and ABAP Programs into QA environment
• Provide on call support to Production system to resolve issues
• Perform Code reviews to ensure that the code follows Datastage Coding standards
• Reviewed Technical Specifications for Restart & Manual Run Procedures
• Implemented Best practices in Job Design and Development
• Trained an employee in DataStage
• Earned Certification in SAP ABAP Transports

Environment: SunOS 5.10, IBM Information Server 8.0(SAP BW Pack), Datastage, Oracle 10g, SQL Plus, SAP Solution Manager, SAP BW 7.0, SAP Redwood

PL/SQL Developer

Confidential

Responsibilities:

• Understand the functionality of various Modules in the Coordcom Application
• Design and Develop PL/SQL Procedures and Triggers as per the Requirements
• Implemented XML Functions and worked with CLOB data types in Procedures
• Ported Database components from SQL Server to Oracle 11g
• Preparation of Unit Test Case Document and Unit Testing of Database components
• Coordinated with the C# team for Integration testing of the Procedures
• Integration Testing from the Coordcom Application to ensure successful functionality
• Document Control using IBM Rational Clearcase
• User Acceptance Testing (UAT) to ensure successful move to production
• Ensured Team Work to meet the deadlines for all releases

Environment: SQL Server 2000, C#, Oracle SQL Developer, Rational Clearcase, Oracle 11g

DataStage Consultant

Confidential

Responsibilities:

• Developed ETL Jobs to extract data from the Electronic invoices in the form of flat files namely CABS and SECABS and load into an Oracle Database
• Used Filter stage to split the files and applied Business Logic to load data
• Implemented Merging logic to load a set of split files into a single Oracle Table
• Designed sequencers for each format for the daily run
• Implemented Error handling to reject bad records in the files
• Developed Quality Stage Jobs in order to perform Data cleansing using Investigate, Standardize Stage, Match Frequency, Survive Stage
• Implemented Reconciliation logic in SQL and PL/SQL Procedures for reconciling the electronic invoices for the daily load
• Prepared Operational Guide for Restart and Recovery Procedure in case of Failure
• Used Row generator stage for generating test data for the files
• Trained and Managed six associates in DataStage
• Conducted code walkthroughs and reviewed peer code and documentation
• Worked with developers, DBAs and systems support personnel in elevating and automating successful move to production.

Environment: Red Hat Linux, IBM Information Server 8.0.1, Datastage, SQL Plus, PL/SQL

Confidential, New York

Responsibilities:

• Analyzed the Batch Jobs involved in loading of the Data Marts in the SAIL Data warehouse to implement restart and recovery solutions
• Analyzed the loading dependencies between various data marts in the server jobs
• Recovery of the load ensuring integrity and consistency of the Data warehouse
• Understand Business logic and enhance jobs to load tables in SAIL Data warehouse
• Understanding the functionality and supporting the Operational Reference Store
• Understanding the complex coding related to PPN DataMart and reporting bugs
• Provide inputs for feasibility of coding in Pl/SQL using PL/SQL Developer
• Optimized complex SQL queries to improve the performance and reduce loading times
• Preparing Impact Analysis documents for Enhancements.
• Preparation of Unit Test cases document.

Environment: UNIX AIX, Ascential DataStage 7.5, PL SQL Developer, Toad, Cognos

Confidential, New York

Responsibilities:

• Understand the loading and design of SAIL MARS Data Mart
• Prepare design documents for Development
• Development of Server jobs for loading the Data Mart
• Preparation of Unit Test cases document.
• Unit Testing of Datastage Jobs.
• Integration Testing from the MARS Application

Environment : UNIX AIX, Ascential DataStage 7.5, PL SQL Developer, Toad, Cognos

Confidential, New York

Responsibilities:

• Understand the Business Logic and ETL Design for the PPN and Engagements Data Marts
• Reverse Engineering the loading of SCD Type 2 Dimension called DPerson
• Interacting with the Business Analysts and Customers in understanding the logic
• Preparing technical documents on the logic
• Understanding design of batch jobs involved in the loading and document the same
• Received Client Appreciation Certificate for exceptional performance in the Project

Environment : UNIX AIX, Ascential DataStage 7.5, PL SQL Developer, Toad, Cognos.