SUMMARY

• 10 years of IT experience in various phases of IT projects following the SDLC process such as analysis, design, coding, testing and deployment.
• 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
• 4 years of experience working with scheduling tools like Autosys & Control-M and Tidal.
• Extensive knowledge on PeopleSoft HRMS System
• Exposure toHRMS, Finance, Learning and Recruitingdomains.
• 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.
• Over 5 years’ extensive experience withETL tool Informatica 5.x/6.x/7.x/8.xin designing and developing complex Mappings, Mapplets, Transformations, Workflows, Work lets, Configuring the Informatica Server and scheduling the Workflows and sessions
• Sound Knowledge withUNIX Operating System and Shell 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 ofReporting 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 inPerformance Tuningof 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
• Involved in 24 / 7 production support

TECHNICAL SKILLS

ETL Tools: Informatica Power enter 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

Environment: s: 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

PROFESSIONAL EXPERIENCE

Confidential, ATLANTA GA

Informatica Developer/Production Support

Responsibilities:

• Design data clean-up/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.
• 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

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

Confidential

Responsibilities:

• 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 lateralized views.
• Performance tuning of existing PL/SQL jobs.
• Analysis on existing PL/SQL\'s and SQR jobs which currently loads datawharehouse.
• Identify the inbound and outbound source systems.

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

Confidential, New York

Informatica Developer

Responsibilities:

• Development of Informatica Mappings and Component Interfaces to convert HRMS data.
• Extensively worked onInformatica toolssuch asSource Analyser, Data Warehouse Designer, Transformation Designer, and Mapping Designerto 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
• Supporting SIT Testing & Co-ordinate with UAT Testers
• Plan Production deployment and coordinate the same
• Extensively used various transformations likeSource 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.
• UsedSQL's tovalidate the data converted to the Database.
• Execute Unit, Functional test cases
• 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

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

Confidential, Port Charlotte, FL

ETL Developer & Production Support

Responsibilities:

• Involved in the review of deliverables and coordinating tasks.
• 24X7 production support forDatawharehouse, Learning & recruitingapplications.
• 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
• Createshell 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
• Support Ag Merger Conversion/Interfaces
• Supported in the database upgrade from 9i to 10g
• Attend various Maintenance requests & Production problems forDatawharehouse, Learning & recruitingapplications.
• Communication with client personnel regarding business requirements and ongoing changes.
• Involved in Migration Request\'s for SIT/UAT/Production environments
• Supporting SIT Testing & Co-ordinate with UAT Testers
• Perform Post Implementation support

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

Confidential, Minneapolis

Informatica Developer

Responsibilities:

• Used Informatica Workflow Manager to create, execute and Monitor Sessions, Batches and Workflows.
• Understand the client requirements fordata transformationfrom source to target
• Involved in the development ofExtraction SpecificationsandRequirement Documents
• Performed Lead Team Lead for Conversion and Interfacing team.
• Involved in co-ordinating offshore resources on development and testing.
• Involved in thedevelopment of Informatica Mappingsfor conversion and interfacing.
• 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 throughControl M.
• Interact with Business Analysts to identify the common interfaces from the previous implementation forre-usabilityin this project
• Test the Informatica mappings using the debugger to check the data flow and rectify the errors if any exist
• Involved in development of complicatedpayroll interfacesusing informatica.
• Upgrading mappings fromversion 6.2 to version 7.1
• Developed Mapplets for the varying requirements for code reusability.
• Involved in development of variousxml targets using informatica.
• Involved in Migration of code to different environments
• Developed shell scriptsfor scheduling/running ETL jobs using pmcmd command
• Usedpager/mail logic in UNIX shell scriptsintimating the production support member immediately upon failure of ETL job(s) in production environment
• Archivethe data files generated after successful completions of ETL jobs usingUNIX shell scripting

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

Confidential, CA

Informatica Developer

Responsibilities:

• 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 scriptsfor scheduling/running ETL jobs using pmcmd command
• Implementedpager/mail logic in UNIX shell scriptsintimating the production support member immediately upon failure of ETL job(s) in production environment
• Involved inproduction supportfor critical interfaces/jobs which runs in production environment
• Archivethe data files generated after successful completions of ETL jobs usingUNIX shell scripting
• Used Informatica Workflow Manager to create, execute and Monitor Sessions, Batches and Workflows.
• Involved in all phases of the project right from analysis, design, development of the project
• Understand the client requirements fordata transformationfrom source to target
• Developed technical specification based on Business requirements
• Involved in thedevelopment of Informatica Mappingsfor conversion and interfacing.

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

Confidential, Fairfield, OH

ETL Developer

Responsibilities:

• Archivethe data files generated after successful completions of ETL jobs usingUNIX shell scripting
• Understand the client requirements fordata transformation
• Developed technical specification based on Business requirements
• Involved inanalysis, design & developmentof the project
• Involved in Migration of code to different environments
• Developed shell scriptsfor scheduling/running ETL jobs using pmcmd command
• Involved in thedevelopment of Informatica Mappingsfor conversion and interfacing.
• Used Informatica Workflow Manager to create, execute and Monitor Sessions, Batches and Workflows.

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

Confidential, Milwaukee, WI

ETL Developer

Responsibilities:

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

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