Professional Summary

• More than 8 years of IT experience in various phases of IT projects following the SDLC process such as analysis, design, coding, testing and deployment.
• Over 5 years extensive experience with ETL tool Informatica 5.x/6.x/7.x/8.x in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions
• Sound Knowledge with UNIX Operating System andShell scripting
• Over 7 years of Database experience using Oracle 10g/9i/, DB2 8.0/7.0,Sybase, MS Access 7.0/2000, PL/SQL, SQL Plus, SQL Loader, SQL Server. Strong Experience on database interfaces like PL/SQL Developer, SQL Plus, TOAD, Quest Central & AQT
• Over 2 years of Reporting experience using SAS.
• Knowledge on Peoplesoft 8.3, People Tools 8.19/8.4.x, Data Mover, Component Interface, SQR's 6.2
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Extensive experience in Workflow Manager and Workflow Monitor
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files
• Extensive experience in Performance Tuning of targets, sources, mappings and sessions, Co-coordinating with DBAs and UNIX Administrator for ETL tuning.
• Solid experience in writing SQL queries , PL/SQL, Stored Procedures, Cursors and optimization
• 4 years of experience working with scheduling tools like Autosys & Control-M and Tidal.
• Extensive knowledge on Peoplesoft HRMS System
• Exposure to HRMS, Finance, Learning and Recruiting domains.
• Expertise in converting HRMS data from legacy system to a new Peoplesoft environment.
• Excellent Administration experience, have handled a lot of conversion projects using Informatica.
• Knowledge on Data Processing, Data Cleansing, Data Validation and Data Archiving Process.
• Involved in 24 / 7 production support
• Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed
• Extensive experience is leading team, offshore co-ordination, task allocation, client reporting
• A Team Player with excellent communication, analytical, verbal and writing skills
• Excellent Communication and interpersonal skills

ETL Tools Informatica PowerCenter 8x 7x 6x 5x
Languages SQR, SQL, PL/SQL, COBAL, SAS, Shell Scripting
RDBMS Oracle 10g/9i/, DB2 8.0/7.0, Sybase, SQL Server , MS Access
Environments WINDOWS NT/98/95/2000/XP, UNIX
Scheduling Autosys, Control M, Tidal
ERP Application Designer, Data mover, Component Interface, SQR's
Tools Quest Central, Toad, Secure FX, Secure CRT, PL/SQL developer, ISPF, PVCS, STAT
Reporting SAS
Domain HRMS, Finance, Learning and Recruiting

Bachelor of Engineering (B.E)

Confidential, Mar 2009 - Till Date
Informatica Developer/Production Support
HP is Technology solution provider to consumers, businesses, and institutions.

1. HPFS Datawharehousing & Portfolio Management Reporting
The HPFS project is a production support and enhancement project which deals with HPFS
data warehouse. The Portfolio Management reporting project mainly deals designing new datawharehouse for better reporting environment.

• Understand the data structure in both the source systems and the target Business Warehouse
• Develop ETL's to source data extraction, transformation and population processes
• Design data cleanup/recovery processes to account for process failures
• Coordinates and works with the Technical Lead
• Works closely with the Data Architect to understand the source and target data elements
• Preparation of Test Plans, support SIT & UAT testing.
• Scheduling Informatica jobs using Tidal.
• Production support for HPFS Datawharehousing.

Environment: Informatica 8.6, PL/SQL, Unix, Tidal, Oracle 10g,SQL server 2008 Toad 9.7.2

2. HRMS Project
The project integrates the applications and data of both the companies as part of HP-EDS merger in the HR IT area. Current team mainly focuses on remodeling existing datawharehouse which was built using PL/SQL & sqr\'s to Informatica. The Peoplesoft system 8.8 was upgraded to Peoplesoft 9.0 as part of this integration.

• Analysis on existing PL/SQL\'s and SQR jobs which currently loads datawharehouse.
• Identify the inbound and outbound source systems.
• Design mapping documents from Source to datamart.
• Co-ordinate offshore development.
• Development and Testing of Informatica Mappings to load data from Source system to load, stage, core and datamart areas.
• Implemented Change Data capture and Type 2 dimension logic.
• Development of Stored procedures to load History Data.
• Preparation of Test Plans.
• Support SIT & UAT testing of Informatica mappings.
• Scheduling Informatica jobs using Tidal
• Development of materliazed views.
• Performance tuning of existing PL/SQL jobs.

Environment: Informatica 8.6, PL/SQL, SQR, Unix, Tidal, Oracle 10g, Toad 9.7.2,Peoplesoft

Confidential, Sep 2008 - Feb 2009
Informatica Developer
Confidential, is a leading financial organization in US that provides deliver critical information to leading decision makers in the financial, legal, tax and accounting, scientific, healthcare and media markets. Thomson has acquired Reuters.

This project mainly focuses on converting Reuters HRMS and Payroll data into Thompson Peoplesoft system using Informatica and component interfaces

• Responsible for Converting HRMS and Payroll Data.
• Communication with client personnel regarding business requirements for converting data.
• Develop technical specification based on Business requirements and obtain sign-off
• Development of Informatica Mappings and Component Interfaces to convert HRMS data.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS
• Design the mappings between sources (external files and databases) to operational targets
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Normalizer, and Update Strategy & Sequence Generator
• Used Informatica to migrate data from Prod to Test environments.
• Used SQL's to validate the data converted to the Database.
• Execute Unit, Functional test cases
• Supporting SIT Testing & Co-ordinate with UAT Testers
• Plan Production deployment and coordinate the same

Environment: Informatica 8.1.1, Oracle 9.2, PeopleSoft 8.19, SQL server, UNIX, Secure
FX, Secure CRT, AQT, STAT

Confidential, Jan 2007-Aug 2008
ETL Developer & Production Support

Confidential, is a leading financial/banking organization in USA that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. Wachovia has a Peoplesoft HRMS 8.0/ Tools 8.2 system to manage its Payroll and to maintain HR data. This is an Application maintenance and support project. Wachovia ASM project is to support and maintain their PeopleSoft Payroll in Unix-oracle environment.The Datawharehouse is loaded using Informatica.

Responsibilities:

• Attend various Maintenance requests & Production problems for Datawharehouse,Learning & recruiting applications.
• Communication with client personnel regarding business requirements and ongoing changes.
• Prepare impact analysis
• Develop technical specification based on Business requirements and obtain sign-off
• Involved in development (Informatica ,Sqr ,Unix, Proc C, SQL loader) and unit testing
• Create shell scripts for Autosys jobs.
• Coordinating and get required approval from Process Owners and LOB
• Team Lead in allocating and co-ordinating offshore development, testing effort
• Involved in Migration Request\'s for SIT/UAT/Production environments
• Supporting SIT Testing & Co-ordinate with UAT Testers
• Perform Post Implementation support
• Involved in the review of deliverables and coordinating tasks.
• 24X7 production support for Datawharehouse,Learning & recruiting applications.
• Support Ag Merger Conversion/Interfaces
• Supported in the database upgrade from 9i to 10g

Environment: Informatica, Oracle 9.x/10g, PL/SQL Developer, Autosys, Pro *C,
SQR, PeopleSoft 8.4,SQL loader, UNIX, Siebel

Confidential, Nov 2005 to Jan 2007
Informatica Developer
State Street is leading provider of financial services to institutional investors. They provide
broad and integrated range of services spans the entire investment spectrum, including
research, investment management, trading services and investment servicing. This project
was to develop and implement a HRMS module for State Street Corporation as part of
Workforce Management Technology at Hewitt Associates. As a member of Interface and
Conversion Team, my work involved development of new ETL Processes for moving data
from the Legacy systems to PeopleSoft HRMS database

Responsibilities:

• Interact with Business Analysts to identify the common interfaces from the previous implementation for re-usability in this project
• Understand the client requirements for data transformation from source to target
• Involved in the development of Extraction Specifications and Requirement Documents
• Performed Lead Team Lead for Conversion and Interfacing team.
• Involved in co-ordinating offshore resources on development and testing.
• Involved in the development of Informatica Mappings for conversion and interfacing.
• Test the Informatica mappings using the debugger to check the data flow and rectify the errors if any exist
• Involved in development of complicated payroll interfaces using informatica.
• Upgrading mappings from version 6.2 to version 7.1
• Developed Mapplets for the varying requirements for code reusability.
• Involved in development of various xml targets using informatica.
• Involved in Migration of code to different environments
• Developed shell scripts for scheduling/running ETL jobs using pmcmd command
• Used pager/mail logic in UNIX shell scripts intimating the production support member immediately upon failure of ETL job(s) in production environment
• Archive the data files generated after successful completions of ETL jobs using UNIX shell scripting
• Used Informatica Workflow Manager to create, execute and Monitor Sessions, Batches and Workflows.
• Executed sessions, sequential and concurrent batches for proper execution of mappings
• Implemented error-handling methods.
• Assisted in the deployment of ETL jobs to the production environment. This includes working with the operations staff to deploy code and provide inputs for scheduling and/or the running of the jobs through Control M.

Environment: Informatica Power Center 6.2/7.1, PeopleSoft 8.4, IBM DB2 UDB 7,
Quest Central 3.0, UNIX (Solaris 8), SecureFX, SecureCRT

Confidential, Apr 2004 - Oct 2005
Informatica Developer
Confidential, is leading global investment banking, securities and investment
management firm that provides a wide range of services worldwide to a substantial and
diversified client base that includes corporations, financial institutions, governments and high
Net-worth individuals. This project was to develop and implement a HRMS module for
Goldman Sachs as part of Workforce Management Technology.

Data from this product is exchanged across other systems using dedicated interfaces
developed in Informatica. As a member of Interface and Conversion Team, my work involved
development of new interfaces across these systems and maintain them.

Responsibilities:

• Involved in all phases of the project right from analysis, design, development of the project
• Understand the client requirements for data transformation from source to target
• Developed technical specification based on Business requirements
• Involved in the development of Informatica Mappings for conversion and interfacing.
• Involved and co-ordinating offshore Team.
• Involved in data movement to different environments using informatica.
• Developed Meta Data reports.
• Involved in Migration of code to different environments
• Developed shell scripts for scheduling/running ETL jobs using pmcmd command
• Implemented pager/mail logic in UNIX shell scripts intimating the production support member immediately upon failure of ETL job(s) in production environment
• Archive the data files generated after successful completions of ETL jobs using UNIX shell scripting
• Used Informatica Workflow Manager to create, execute and Monitor Sessions, Batches and Workflows.
• Involved in production support for critical interfaces/jobs which runs in production environment

Environment Informatica Power Center 6.2, PeopleSoft, IBM DB2 UDB 7,
Quest Central 3.0, UNIX (Solaris 8), SecureFX, SecureCRT

Confidential, July 2003 - Mar 2004
ETL Developer
Confidential, is a global outsourcing and consulting firm delivering a complete range of human capital management services to companies, including HR and Benefits Outsourcing, HR Strategy and Technology, Health Care, Organizational Change, Retirement and Financial Management and Talent and Reward Strategies This project was to implement Work Force Management technology by Hewitt Associates for Confidential

Responsibilities:

• Involved in analysis, design & development of the project
• Understand the client requirements for data transformation
• Developed technical specification based on Business requirements
• Involved in the development of Informatica Mappings for conversion and interfacing.
• Used Informatica Workflow Manager to create, execute and Monitor Sessions, Batches and Workflows.
• Involved in Migration of code to different environments
• Developed shell scripts for scheduling/running ETL jobs using pmcmd command
• Archive the data files generated after successful completions of ETL jobs using UNIX shell scripting

Environment: Informatica Power Center 5.1/6.2, PeopleSoft, IBM DB2 UDB 7,
Quest Central 3.0, UNIX (Solaris 8), SecureFX, SecureCRT

Confidential, May 2001 - June 2003
Developer
Confidential, is a diversified commercial finance company specializing
in aircraft finance, golf finance, time share finance; asset based lending, capital marketing,
commercial finance, floor plan finance, resort financing, vendor/manufacturer arrangements
and SBA loans. TFC originates and also syndicates a wide variety of secured loan and lease
transactions, selectively invests in leveraged lease transactions and provides third party
portfolio servicing.

Responsibilities:

• Handling maintenance tasks and ISO projects.
• Understanding the business requirements
• Design technical design documents based on requirements
• Development of various types of reports using SAS
• Development of new scripts to invoke SAS program
• Documentation of Unix Shell Scripts, COBOL and SAS Programs
• Unit and System testing
• Attending to Maintenance requests & Production problems.
• Involved in review of deliverables
• Participate in technical meetings
• Plan Production deployment and coordinate the same

Environment: SAS, Unix Shell Scripts, MF-COBOL, Sybase