SUMMARY

• Six plus years of experience in Information Technology in Data Warehousing, Custom OLAP, ETL tools and product development.
• Interpret written business requirements and technical specifications to create and maintain mapping design document.
• Expertise in Extract Transform Load (ETL) process Design, Development using Informatica Power center 9.5/9.0.1/8.5/7.1 in Data warehouse environments.
• Strong troubleshooting skills, strong experience of working with complex ETL in a data warehouse environment.
• Extensively Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet/Mapping Designer and Repository manager.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema which are used in relational, dimensional and multidimensional modeling.
• Experience in Integration of various data sources like Oracle, SQL Server 2000, DB2, and Ms Access into a staging area.
• Involved in Performance Tuning of Informatica mappings and sessions.
• Create, document, and implement test plans and scripts.
• Extensive knowledge of software development life cycle methodologies.
• Strong technical skills in Oracle, SQL and PL/SQL.
• Expertise in development of the SQL Scripts, Stored Procedures, Functions and Database Triggers.
• Excellent Team player and can work on both development and maintenance phases of the project.
• 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/2000/XP, UNIX

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

PeopleSoft: People Soft 9.1 HR and Finance

ETL Tools: Informatica Power Center 9.5/9.1/8.x/7.1

BI Tools: OBIEE 10.1.3.4, Siebel Analytics 7.5

Languages: SQL, PL/SQL, UNIX Shell Scripting

Web Technologies: HTML

Scheduling Tools: DAC (Data Warehouse Administration Console)

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Run out of the box mapping to load HR, Finance data.
• Integrate Prism and PeopleSoft Employees data and load into OBAW.
• Customize mappings to extract data from PeopleSoft 9.0(Finance) and PeopleSoft 8.9 (HR) sources to load into custom common dimensions.
• Create custom execution plans in DAC.
• Created mappings using various transformations such as Source Qualifies, Aggregator, Expression, Lookup, Filter, Router and Update Strategy Transformations.
• Customized out of the box mapping to suffice business requirements.
• Created workflows and sessions using workflow manager.
• Create custom Actual Budget aggregate mappings/workflows to load into aggregate tables.
• Debug the issues during data load.
• Created migration document to move files, Informatica and DAC objects from Dev to Test and Prod environments.
• Verify Finance, HR Informatica and DAC execution plans migrated properly .

Environment: Informatica Power Center 9.0.1, OBIA 7.9.6.3, People Soft 9.1, OBIEE 11.1.1.5.0 , Citrix, SQL, Oracle 11.2.0, DAC 10.1.3.4.1 and Oracle SQL Developer 1.5.5, Citrix

Confidential, GA

ETL Developer

Responsibilities:

• Worked on Source Analyzer, Data warehousing 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 for creating, validating and running the workflows, sessions and scheduling them to run at specified times.
• Extensively worked on Stored Procedures, Functions and Database Constraints.
• Performed Unit testing, 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 at source, target, mapping and session level.
• Created KT documentation.

Environment: Windows XP, OBIEE 10.1.3.2, OBIA 7.9.6, Informatica Power Center 8.5, Oracle 10g, Mercury Quality Center, PeopleSoft 8.9 Scripting, SQL, PL/SQL, DAC 10.1.3

Confidential, GA

Informatica Developer

Responsibilities:

• Extracted data from PeopleSoft database and csv files.
• Customizing mapping/workflows.
• Added extension columns to Product, GL Other, Group Account mappings.
• Created aggregated view tables.
• Comparative Income statement, Trended Income statement, Cost of Sales Mappings/Workflows are created.
• Created 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 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 the issues during data load.
• 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 792, Siebel Analytics 782, Siebel Sales 8.0, Informatica 7.1.2, MS SQL 2005, Oracle 10g, MS Project 2003, Mercury Quality Center, VISIO 2000.

Confidential, San Jose, GA

Software Engineer

Responsibilities:

• Worked on various kinds of transformations like Expression, Aggregator, Lookup, Filter, Joiner, Router and Update Strategy.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges.
• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and source tables to target tables.
• Developed reusable Mapplets and Transformations.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in monitoring the workflows and in optimizing the load times.
• Writing Informatica routines, transformations and loading the data into staging tables and EIM tables.
• Implemented unit testing on mappings, Mapplets and validated the data.

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