SUMMARY

• 7+ years of Information Technology experience in Data Warehousing, Custom OLAP, ETL tools and product development.
• Interpret written business requirements and technical specifications to create and maintain mapping design document.
• Experience in Integration of various data sources like Oracle, PeopleSoft 9.1 and Flat files into a staging area, and target data warehouse.
• Expertise in Extract Transform Load (ETL) process Design, Development using Informatica Power center 9.5/9.0.1/8.5/7.1 , IBM Infosphere Datastage and Qualitystage 9.1 in Data warehouse environments.
• Strong troubleshooting skills and experience of working with complex ETL in a data warehouse environment.
• Extensively Worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet/Mapping Designer and Repository manager and Workflow Manager Tools.
• Worked on IBM Infosphere Data stage and Quality stage designer, and Run Director Tool.
• Involved in performance tuning of data loads.
• Automation of ETL process and workflow scheduling using DAC.
• Create test plans, scripts and execute them.
• Create deployment documents.
• Extensive knowledge of software development life cycle methodologies.
• Strong Knowledge in development of the SQL Scripts, Stored Procedures, Functions and Database Triggers.
• Excellent Team player.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

O/S: Microsoft Windows 98/NT/XP/2000/2006, UNIX

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2005/2000

PeopleSoft: PeopleSoft 9.1

ETL Tools: Informatica Power Center 9.5/9.1/8.0/7.1 , IBM Infosphere Datastage and Qualitystage 9.1

BI Tools: OBIEE 10.1.3.4/ 11.1.1.5.0 , OBIA 7.9.6.3, Siebel Analytics 7.8.2/7.5

Languages: SQL, PL/SQL

Web Technologies: HTML

Scheduling Tools: DAC (Data Warehouse Administration Console)

PROFESSIONAL EXPERIENCE

Confidential, San antonio,TX

Datastage Developer

Responsibilities:

• Developed ETL jobs based on the requirements.
• Built datastage jobs to load data into data warehouse using various stages like merge, lookup, Pivot, join and Transformer stage
• Created E3 Frame work for running batches and used Control-M for Scheduling.
• Used Director for monitoring the jobs.
• Performed reconciliation of the data by matching row counts, hash totals, data Integration, unit testing, integration.
• Prepared source to target data Flow diagram, ETL Job Scheduling, deployment, maintenance documents.
• Deployed datastage jobs to various environments like Test, UAT.
• Worked on projects that are based on dimensional modeling.
• Worked on Agile methodology project.

Environment: IBM Infosphere DataStage v9.5, Oracle 11.2.0, Flat files, UNIX and Windows Server 2006

Confidential, Dallas,TX

Datastage Developer

Responsibilities:

• Developed ETL jobs based on ETL specifications.
• Build Datastage jobs to Transforming, integrating, and loading data into data warehouse database using various stages which has available in datastage like merge, lookup, change capture and transformer stage
• Created Data Stage Sequence job to run batches and Scheduling.
• Used the Run Director for monitoring the jobs.
• Perform reconciliation of the data by matching Row counts, Hash Totals, Data Integration, Unit testing,Integration.
• Prepare Source to Target mapping document, ETL Job Scheduling,deployment,maintenance documents.
• Performed import and export of Data Stage Jobs.
• Worked on projects that are based on dimensional modeling.
• Worked on Agile methodology project.

Environment: IBM Infosphere DataStage v9.1, Oracle 11.2.0, Flat files, UNIX and Windows Server 2006

Confidential, Memphis TN

ETL Developer

Responsibilities:

• Worked in System for Award Management ( Confidential ) Registration project. It is a US Federal Contractor Registration firm. Confidential consolidated the capabilities of CCR/FedReg. Confidential services includes a dedicated case manager to physically process the Confidential paperwork on the client’s behalf.
• Extracting data from flat files and load to the staging table with using SQLloader.
• Created Confidential Load Process File to load Government data into INTDS and QADW Environment.
• Customize Packages, Store Procedures, functions, Conditions, Loops, Synonyms Run Store procedure for loading data into the Fact, Dimension tables and Reporting purpose.
• Created and executed unit and integration test scripts.
• Created manifest to move code toTest and Prod environment.
• Involved in production support.

Environment: Oracle 11.2.0, Team Track, Erwin data Modeler 9.0.

Confidential, Memphis,TN

ETL Developer

Responsibilities:

• Implemented customization changes required for deployment of BVR reporting for Confidential Office, FTN and Express U.S. operations.
• Customized out of the box mapping to suffice business requirements such as extract data from PeopleSoft 9.1(Finance) source to load into custom common dimensions.
• Created Informatica mappings using various transformations such as Source Qualifies, Aggregator, Expression, Lookup, Filter, Router and Update Strategy Transformations.
• Created workflows and sessions using workflow manager.
• Created custom Actual Budget aggregate mappings/workflows to load into aggregate tables.
• Monitor and debug data loads.
• Create and run custom execution plans in DAC.
• Created deployment document to move files, Informatica and DAC objects from Dev to Test and Prod environments.
• Verify Finance and HR DAC execution plans migrated properly.
• Execute DAC execution plans and load data into data warehouse.

Environment: InformaticaPowerCenter9.0.1, PeopleSoft 9.1,OBIA 7.9.6.3, OBIEE 11.1.1.5.0 , DAC 10.1.3.4.1 , Citrix, Oracle 11.2.0, and SQL Developer 1.5.5.

Confidential, Atlanta,GA

ETL Developer

Responsibilities:

• Confidential implemented Oracle Business Intelligence (OBIEE) HR using ETL source adaptors for PeopleSoft 8.9.
• Integrate Prism and PeopleSoft Employees data and load into OBAW.
• Worked on Source Analyzer, Target designer, Mapping Designer, Mapplet Designer and Transformations.
• Created mappings, mapplets using various transformations such as Source qualifier, Aggregator, Expression, Lookup, Filter, Sorter, Router, and Update Strategy.
• Used the Workflow Manager to create, validate, run the sessions and workflows.
• Performed Unit, Integration Testing, and User Acceptance testing to identify the inaccuracies.
• Used debugger for error handling and to test the data flow.
• Involved in performance tuning.
• Created KT documentation.

Environment: Windows XP,OBIEE 10.1.3.2, OBIA 7.9.6,InformaticaPowerCenter 8.5, Oracle 10g, Mercury Quality Center, PeopleSoft 8.9, and DAC 10.1.3.

Confidential, GA

Informatica Developer

Responsibilities:

• Extracted data from Siebel sales and csv files.
• Customizing mapping/workflows.
• Created aggregate tables.
• Created mappings using various transformations such as Source Qualifies, Aggregator, Expression, Lookup, Filter, Router and Update Strategy Transformations.
• Created sessions and workflows using workflow manager.
• Created new tasks, subject area, generate parameters and Execution plan using DAC.
• Ran the mappings using DAC.
• Involved in performance improvement of data load and data validation.
• Debug data load issues.
• Created migration document to move files, Informatica and DAC objects from Dev to Test and Prod environments.

Environment: Windows XP, Oracle BI platform 10.1.3.2, Oracle BI Application 7.9.2, Siebel Analytics 7.8.2, Siebel Sales 8.0, Informatica 7.1.2, MS SQL 2005, Oracle 10g, Mercury Quality Center and VISIO 2000.

Confidential, San Jose, CA

Software Engineer

Responsibilities:

• Administered the repository by creating folders and logins for the group members and assigning necessary privileges.
• Designed and developed Informatica Mappings and Sessions based on business requirements to load data from flat files and source tables to target data warehouse.
• Worked on various transformations like Expression, Aggregator, Lookup, Filter, Joiner, Router and Update Strategy.
• Developed reusable Mapplets and Transformations.
• Used debugger to troubleshoot data flow and transformation errors.
• Involved in monitoring the workflows and performance tuning of data loads.
• Created deployment document to move files, Informatica objects from Dev to Test and Prod environments.

Environment: Windows XP, Siebel Sales 7.5.2, Informatica 7.1.2, Oracle 10G