Summary:

• 12 years of IT experience encompassing a wide range of skill set, roles and industry verticals. Currently, working as a Tech Lead handling the project right from the development activities to onshore and offshore Coordination
• 8 years of experience in Analyzing, Designing, Development, implementation and Support using IBM Datastage 8.5/8.1/7.x Information Server, WebSphere, Ascential DataStage , Oracle, DB2, SQL, Unix shell scripts, and multiple testing scheduling tools.
• 3 years of experience on Informatica Power Center and Business Objects BO . 4 years of simultaneous experience in SAP ECC6.0 FICO while working in ETL-SAP data integration and migration project
• Strong foundation and knowledge base in Data warehousing, Data Integration and Data Migration projects. Extensive experience in implementation of ETL methodologies. Thorough understanding of DW principles Fact Tables, Dimensional Tables, Dimensional Data Modeling - Star Schema and Snow Flake Schema
• Excellent knowledge and experience in datawarehouse development life cycle, dimensional modeling, repository management and administration, implementation of slowly changing dimensions SCD and change data capture CDC .
• Proficient in analyzing and translating business requirements to technical requirements specific to ETL Extraction Transformation and Loading architecture. Primary ETL technical expertise includes hands on Datastage code design, development, testing and administration activities.
• Good knowledge on PMP tool MS-Project Plan, Scheduling tools like Autosys Control-M, testing tools like Test Director, IBM Rational Robot and IBM Rational Quality management viz. Rational Clear Quest Clear Case. Involved in automation of migration activities using version control tool Subversion SVN .
• Advantage of having exposure to various tools and technologies by means of internal trainings like AbInitio, SAS, Cognos, Microstrategy, Reveleus/OFSAA Basel Risk management Tool , NCR Teradata
• Involved in development, testing and production support activities of various ETL and OLAP-Reporting projects. Handled multiple roles in Datawarehousing, Data Migration Integration projects as Developer, Senior Developer, Module Lead, Team Lead, Onsite and Offshore Coordinator
• Executed software projects for Banking Finance Retail, CPG Distribution and IT Operational Risk management, Enterprise Resource planning SAP domain base.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team leader /offshore onsite Coordinator/team player.

Skill Set - Tools Technologies:

• ETL/BI Tools: IBM Infosphere Datastage QualityStage V8.5/8.1/7.x, IBM Infosphere Business Glossary, IBM Infosphere Metadata Workbench, IBM Infosphere Information Server Web Console, IBM Infosphere Information Server Manager, IBM Import Export Manager, IBM Infosphere Information Analyzer, Informatica Power Center, Business Objects
• RDBMS: Oracle, DB2
• ERP/CRM: SAP ECC6.0 FICO
• Testing/Version Control Tools: Test Director, IBM Rational Robot, IBM ClearQuest, IBM Clear Case, Autosys, Tivoli Workload Scheduler TWS , Control-M, HP Quality Center, Subversion SVN
• PMP tool: MS- Project 2003

Project Summary:

Confidential

Role: Team Lead Onsite Coordinator

Description:

Confidential - Data management Services project, ConfidentialTechnology 4 work stream is responsible for the development of a capability and architecture to support the automated capture and consolidation of data from the various business warehouses/systems into a central Basel data warehouse for use within the RWA Risk Weighted Assets calculator and other RWA pre-processing as needed. This also includes the implementation of the reconciliation process between the finance data/General Ledger and the risk data stored in the various warehouses, as well as any remediation needed to risk data prior to its use within the BASEL calculator i.e., OFSAA Oracle Financial Services Analytics Application

Responsibilities:

• Work with IBM and Confidential representatives to collect the requirements and then design to deliver the ETL work products
• Interact with ConfidentialBusiness partners and Business Analysts kick off sessions/workshops in translating business requirements into Functional Requirements Document
• Develop Detailed Design Documents based on the Functional Requirements Document
• Being Technical Teams Lead, I have to interact with the Solution Architects, Business Analysts and Project Managers from American Express to discuss about the source to target mapping.
• Develop the transformation logic for loading of the data from multiple sources in to one single repository
• Involve in the development, testing and migration of the Informatica mappings during onshore hours and handover to offshore development team.
• Being a Team Lead, ensure that part of the development processes are implemented by the offshore team, perform code reviews and unit testing throughout the lifecycle of the project
• Provide the support to the Testing team in the Test case preparation and execution during System Integration User Acceptance Tests

Environment: Informatica Power Center V9.1, Oracle 11g, PL/SQL developer, OFSAA Oracle BASEL calculator, Flat files, Unix Shell Scripts, HP Quality Center

Confidential

Role: Team Lead Onsite Coordinator

Confidential

Role: Team Lead Onsite Coordinator

Confidential

Role: Module Lead

Confidential

Role: Sr. Developer

Description:

Confidential major transformation program to radically simplify the design and operation of three Globally Integrated Support Processes - Finance, Opportunity To Order, and Order To Cash is going to fulfilled by Confidential project success. Confidential's more persistent problems and sets the stage for Globally Integrate Enterprise by: Improving the ease of doing business for clients, especially Business Partners, by simplifying and standardizing processes Optimizing operations across the Confidentialenterprise while addressing the unique needs of Business Units BUs and countries Reducing operation costs, not only though simplification, but also through retirement of legacy applications and introducing one common single platform i.e., SAP

• I have involved in multiple implementations / sub-projects during the entire Blue Harmony project tenure and below are the various implementation details:
• Release 0.5 -> China country roll out
• Release 1.0 -> Germany country roll out
• Business Glossary -> Sub-project to maintain the complete Blue Harmony project dictionary
• Wave 1 -> Multi country roll out covering Asia Pacific, Europe and Americas regions

Responsibilities:

• As a Technical Team Lead, involved in different activities like System understanding, Requirements gathering regular client interactions over calls
• As a Module lead for some of the modules in SAP FICO like GL and AP/AR , involved in mapping sheet requirements and assigning the tasks to the team members eventually guide the resources in the success path
• Being Senior developer, Involved in ETL Code development from the scratch with the help of source to target mapping sheets and also implementing the change requests CRs as per user requirements
• Coordinate with various Technical teams in order to prepare various design documents specific to each assigned object. Technical Design Documents TDD , Unit Test Review Documents UTR , Code Migration document and Knowledge Transfer Documents are the key documents.
• Supporting the testing efforts and providing technical assistance. Testing and Support efforts includes identifying the issues and raising the defects through Clear Quest Defect Management tool and to follow up on these issues to make sure they will get resolved on a timely basis.
• Coordinate with the Global teams and offshore IBM India to resolve any issues or showstoppers in different phases of software life cycle like analyze, design, development, testing and support areas
• Involved in ETL Code development and change requests as per user requirements. Implemented IBM's best practices in all possible phases of delivery.
• Worked extensively on SAP packs for loading data into the SAP target environment
• Involved in Development and Testing activities Code migration from DEV to QA to PROD environments
• Using IBM Information Server Import Export Manager read the Cognos reports backend files and imports corresponding metadata directly from the report URL

Environment: IBM Infosphere Datastage QualityStage V8.5, Infosphere Information Analyzer, Infosphere Information Server, Business Glossary, Metadata workbench, Fast Track, Import Export Manager, SAP ECC6.0 FI module, Cognos, DB2, Flat Files, RQM

Confidential

Role: Sr. Developer

Description:

Responsibilities:

• Involved in different activities like System understanding, Requirements gathering frequent client interactions
• Involved in ETL Code development and change requests as per user requirements
• Understanding the Source to Target mappings and implementing the logic accordingly
• Worked on Datastage Designer tool to create/modify the jobs Job sequencers
• Worked extensively on XML documents
• Migrating the code from DEV to UAT environment
• Testing the Jobs by loading the output data into TLM application

Environment: Datastage parallel V 7.5.1A, Oracle 10g, Files, XML docs

Confidential

Role: Sr. Developer

Responsibilities:

• Worked at client-site and Involved in different activities like System understanding, Requirements gathering Client interaction
• Analyzing the data adequacy and highlighting the data issues, structural issues across the 11 different source systems in Citigroup BANAMAX, RCSA, ORCA etc.
• ETL Code Development as per user requirements using different sets of jobs and sequencers
• Understanding the Data Model Functional Requirements and hence creating the Source to Target mappings
• Worked on Datastage Designer tool to create/modify the jobs Job sequencers
• Creating the Test Scripts, Test cases Tested the Jobs
• Involved in different phases of the project DEV, PAT UAT
• Worked primarily on resolving the production issues and the development activity for production fixes
• Handling the change requests and performing the necessary tests on code to reinstate the production environment

Environment: IBM Websphere Datastage EE V8.1, Oracle 10 g, SQL Server 2005, MS-Excel, Flat Files, Autosys

Confidential

Role: ETL Onsite Coordinator

Responsibilities:

• Involved in System understanding, Requirements gathering Client interaction
• Worked as an Onsite team Coordinator involved in Onsite Team and Offshore management coordination
• Assigned with the responsibility of Work allocation and arranging meetings among the team
• ETL Code Development and its modification as per user requirements
• Preparing File/Table definitions and importing and exporting the definitions using Datastage Manager
• Worked on Datastage Designer tool to create/modify the Server jobs Job sequencers
• Prepared the Test cases Tested the Jobs

Environment: Ascential Datastage V7.5 Server, Oracle 10 g, SQL Server 2005, Flat Files, SQL Loader

Confidential

Role: Developer/Production Support

Responsibilities:

• Responsible for Production support, development and modification of ETL Code
• Working on the change requests as part of production support
• Preparing Table definitions and importing exporting into/from the Repository
• Creating /modification of jobs according to user requirements
• Working on Datastage Designer tools for creating/modification Server jobs, job sequencers
• Preparing Test cases Testing the Job with respect to database
• Executing the jobs successfully through Datastage Director

Environment: Ascential Datastage V7.5, DB2, Flat Files

Confidential

Role: Developer

Responsibilities:

• System - System interface Testing is basically to test the replaced legacy application i.e. CDT Replacement by Chain Net application integrated with Siebel CRM.
• System System Interface Testing involves end to end system testing for different environments with respect to ETL process and Data Loading. Testing environments are Oracle to Teradata Oracle/Teradata to Siebel Starting point EIM Staging area and from Siebel-EIM to final Siebel base tables.
• Responsible for developing and modification of ETL Code
• Developed/Modified the jobs according to user requirements
• Worked on Datastage Designer tools for creating/modification Server jobs, shared containers, job sequencers
• Developed the Test cases and Test scripts and executed test scripts
• Tested the Source and Target of each environment with respect to the database Oracle/Teradata prepared the Test case plan document based on Source to Target mapping sheet
• Used automated Testing of Test cases using Test Director Rational Robot
• Synchronized the Test Director and Defects raising and closing of fixed bugs

Environment: Ascential Datastage V7.5, NCR Teradata V2R5, Oracle 9i, Siebel CRM, Toad V8.0, Flat Files, Test Director V8.0, Rational Robot, Tivoli Workload Scheduler TWS

Confidential

Role: Developer

Responsibilities:

• Updating the BO Universe according to the new or change in the business and reporting requirements
• Modifying the Informatica mappings as per the change in the existing business requirements
• Modified existing reports with respect to the enhanced functionalities of existing front end and backend applications.
• Created New Reports based on the Business Requirements and Program specification information gathering
• Testing the new reports enriching the quality of existing reports as per the client's requirement.

Environment: Business Objects 5.1.7, Informatica 6.1, Oracle 9i, PL/SQL Developer

Confidential

Role Developer

Responsibilities:

• The Current ETL Process involves in Extraction of Data from the Operational Data Store ODS and populating the Data into the Enterprise Data Warehouse EDW . The scope of the work is broadly divided into three basic components as ETL Development, ETL Testing and ETL Documentation.
• Involved in ETL Development. The ETL Development Component basically consists of Datastage Jobs , Shell Scripts , . Sql Files and Sync-Sort Files .
• Involved in Datastage upgrade from Version 7.0 to Version 7.5
• Involved in ETL Testing. The ETL Testing Component consists of Unit Testing , Regression Testing and System Acceptance Testing SAT .
• Involved in ETL Documentation. The ETL Documentation Component consists of System Delivery Specification SDS , Technical System Design TSD , Test Plan Document TPD and System Acceptance Test SAT .

Environment: Ascential Datastage V7.0/7.5, NCR Teradata V2R5, Oracle9i, Flat Files, TOAD V8.0, TWS

Confidential

Role: Developer

Responsibilities:

• Involved in Informatica code development following the Source to Target mappings
• Modifying existing mappings with respect to enhanced functionalities of existing application and Database
• Created mappings, reusable mapplets in Designer
• Worked with Different sources such as Flat files, Oracle db
• Extensively used transformations such as Source Qualifier, Expression, look up, update strategy, Router in different Mappings
• Created the Test cases and validated against different environments by testing.
• Scheduled Sessions Workflows to upload the Target data Using Workflow Manager
• Monitoring of sessions using Workflow Monitor tool of Informatica
• Coordinating with reporting team. Modifying the informatica mappings and if required developing the new mappings specific to providing the inputs to Business object reporting

Environment: Informatica 6.1, Business Objects 5.1.7, Oracle 9i, PL/SQL Developer