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, Confidential Express Technology 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 Confidential representatives to collect the requirements and then design to deliver the ETL work products
• Interact with Confidential Express Business 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:

• Confidentials 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 Blue Harmony project success. Blue Harmony, tackles some of IBM'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 IBM enterprise 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:

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:

Confidential Management application used by StateStreet bank for reconciliation and exception management for trade order management systems. GL reconciliation is one aspect of overall reconciliation. StateStreet bank maintains trade information i.e., position and cash securities in two mode of accounts - 'ourside' and 'their side' accounts. These two kinds of accountings are reconciled by providing the source data feeds to the Confidentialapplication. Confidential accepts the data in certain fashion only. StateStreet has many custodians with which it is having regular trading. Datastage provides the required data to Confidential by extracting data feeds from different custodians. As part of datastage development, we have developed a number of jobs. The output of the jobs would be fed into Confidential for reconciliation.

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

Description:

The goal of Confidential is to provide a globally consistent and locally effective Risk Control Self assessment RCSA platform that shall improve the reliability, efficiency and consistency of the RCSA process across Citigroup. The underlying evidence to validate SOX assertions must be embedded in the configuration of the RCSA workflow within Catalyst. Alignment to the Event Data Capture System EDCS and the capital estimation process shall be achieved by including Confidential's Event Type classification framework into the Catalyst tool. Catalyst will be the only RCSA data capture and reporting solution replacing both existing tools and spreadsheets currently in use in various areas of Confidential. Catalyst should also support single sign-on and data access control, aggregation of information by defined hierarchies such as Sector, Function, Geography, etc. With Catalyst system, Confidential adopts a sound operational risk management practice which in turn compliance with various regulations such as SOX, FDICIA and Basel II mandate. It's a structured process to assess operational risk and address the results appropriately.

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

Description:

Confidential is the largest Bank in terms of capital both in Confidential and in the Middle East. The Bank operates the largest dealing room in foreign exchange and money market in the Middle East. The Bank was the first Confidential to launch Credit Cards for settlement of online purchases. As part of Basel-II implementation for any bank, the Basel Committee focuses on securing international convergence of supervisory regulations governing the capital adequacy requirements of international banks and also possibility of loss. NCB has got different systems like BANCS, BANKTRADE, FRS, VISION PLUS, DEVON, Collateral RMD. The ETL Team assigned with the project to extract the data from all the disparate source systems using Datastage tool. Using Datastage tool, we can extract transform the data as per Reveleus Product BASEL-II engine requirements load into Flat files. Reveleus product BASEL calculator finds out the total risk that BANK is having at a particular point of time by considering the Credit, Market Operational risks. Based on the RWA computation, according to Basel II norms, for proper functioning of Banks, the value of RC/RWA Should be always greater than 8

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

Confidential. This Bank is currently using Decision support system using Datawarehouse, but it is limited to only few Lines of Business which they have. They are looking to expand the Datawarehouse to include all the Lines of Business for better analysis of Business, cost and expenses analysis for better utilization of resources. The project mainly focuses on their capital market division of the Bank.

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

Description:

Confidential Marketing and Sales Department has recently purchased Siebel, a Customer Relationship Management CRM application. The purpose of Siebel is to bring as many of applications together under one unifying platform which will improve the productivity and satisfaction of the Marketing and Sales force and allow them to spend more time selling beer. The first application to be moved to Siebel CRM is the Customer Development Tool CDT . Siebel CRM will replace and improve the underlying engine in CDT to improve the productivity and satisfaction of the field personnel. As part of this we need to test all the present Data stage Jobs and in parallel change requests also needs to be implemented.

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

Description:

Confidential is an internal branded entity within PepsiCo, which handles all IT related work including development of new solutions, maintenance of current applications, IT outsourcing and off-shoring. The scope of this project is to primarily provide Baseline Support to the Food Service Reporting Equipment Service Reporting, EPM Reporting, Remit Reporting, Parts Reporting, SIPS reporting applications. The re-engineering of the Parts application renamed as Service on the web and the involvement is purely development. Service on the web reporting system is replaced the existing PARTS application reporting system. To fulfill the requirements, worked on the existing reports and create new reports as per the customer needs.

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

Description:

Confidential's operations and resources are focused on beer, adventure park entertainment and packaging. Efficient Order Writing EOW is a process that provides suggested order quantities based on a sophisticated sales forecast and current inventory levels. The forecast is based upon past performance and causal data, such as events in the retailer area and weather. These projects supports the Supply Chain Program's major goal of maximizing the precision, and accuracy of retailer orders, so that A-B can optimize production and inventory levels and make cost-efficient use of transportation resources. The EOW Data Collection project, takes data from the retailers, wholesalers, and AccuWeather, edits and validates the data, and loads it into an Oracle database. EOW DC is the operational data model which resides in ORACLE and is the source for the Analytical EDW DW model implemented in TERADATA.

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

Description:

The scope of this project is to primarily provide Baseline Support to the Food Service applications. The re-engineering of the Parts application renamed as Service on the web and the involvement is purely development. Service on the Web ETL Processing is replaced the existing PARTS application ETL Processing system. To fulfill the requirements, worked on the existing mappings and create new mappings as per the project requirement and customer needs.

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