SUMMARY

• Over 7 years experience in Information Technology in various phases of IT projects following the SDLC process such as analysis, design, development, testing, deployment and post deployment support.
• Strong experience (6+years) in developing strategies for Extraction, Transformation and Loading (ETL) using Informatica Power Center 6.x/7.x/8.x.
• Working experiences with all Business Object components, including but not limited to Business Objects Universe Designer XI R2, R3, Web Intelligence andDesktop Intelligence.
• Have been involved in Data Modeling using ERWin and Power Designer.
• Handled onsite production support of mission critical DW ETL applications across multiple clients.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement.
• Extensive experience in gathering the requirements, converting the requirements into functional and technical specifications.
• Ability to translate the technical issues into the terms and communicate the same to the business users as part of the support lead activities.
• Extensive Knowledge in Dimensional Data modeling, Star Schema modeling, Snow - Flake modeling, Fact and Dimensions tables, Slowly Changing Dimensions, and OLAP systems.
• Working experience with the Integration of various data sources like Oracle, SQL Server, Flat Files, Excel spreadsheets, MS-Access databases and csv files.
• Have good experience working on Informatica Designer components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Good experience in using Informatica Workflow Manager to create and schedule workflows and worklets.
• Worked with Session Parameterization using global Variables and implemented SCD type 1 and Type 2 Logic as per business requirements.
• Hands on experience in performance tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experienced in developing database objects using PL/SQL Stored Procedures, Triggers, Functions and Packages.
• Good experience in UNIX and writing shell scripts for file handling, pre & post session operations and also to perform job scheduling activities.
• Strong technical background with excellent Problem Solving & Communication skills in interacting with clients and business partners.
• Ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x/7.x/6.x (Designer, Repository Manager, Workflow Manager, Workflow Monitor)

Dimensional Modeling: Star & Snow Flake Schema

Database/Tools: Oracle 11g/10g/9i/8i/8, MS SQL Server 2000/2005, PL/SQL, TOAD

Languages: SQL, PL/SQL, C, C++, Unix Shell Scripting and HTML

Operating Systems: Microsoft Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Informatica Developer/ Analyst

Responsibilities:

• Participated in requirement gathering, business analysis, user meetings, discussing the issues to be resolved
• Extensively worked with PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Designer to manipulate source definitions, create Mappings, reusable mapplets and transformations.
• Created various mappings extracting data from different sources such as Oracle, SAP, computron and Flat files to load into Operational Data Store (staging area) and then load into Enterprise Data Warehouse.
• Altered a lot of existing mappings to accommodate new business requirements.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Updated downstream views, used for reporting, using PL/SQL and SQL according to the changing business requirements.
• Involved in data analysis and identified the bottlenecks in the sources, targets, mappings, sessions and resolved the issues.
• Prepared code migration document and worked with support team in migration of mappings and workflows from Development to Test, Stage and Production Servers.
• Involved in defect fixing as a result of integration testing and system testing.

Environment: Informatica Power Center 8.1, Oracle 10g, TOAD 9.0, UNIX, Windows

Confidential

Sr. Informatica Developer

Responsibilities:

• Extracted data from sources like XML files and transformed the data according to the business requirement and then loaded into the Oracle database.
• Extensively worked with PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Supported in setting up repositories for different environments and UNIX service account set up.
• Extensively used Designer to manipulate source definitions, create Mappings, reusable mapplets and transformations.
• Converted procedures into mappings using various transformations like Source Qualifier, Stored procedure Expression, Sorter, Update Strategy, Filter, Lookup, and Aggregator etc.
• Created stored procedures using PL/SQL and SQL to update the target database tables according to the business rules.
• Created workflows using Session, Command, and Email tasks
• Involved in trouble shooting of long running sessions and identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems
• Created various documents like Source to target mapping document, Design specification document, unit testing document and Preliminary deployment plan document

Environment: Informatica Power Center 8.6, Oracle 11g, TOAD 9.0, UNIX, Windows

Confidential

Production Support Lead

Responsibilities:

• Acted as the on-site support lead after production deployment and worked with the offshore support teams.
• Ensured the application SLA’s for all the ETL batch streams are met
• Responsible for system break/fix and troubleshooting production failures.
• Worked with the data stewards to ensure the reference data availability prior to the loads.
• Perform first level of analysis on data errors by looking into data load reports.
• Developed project calendar for data loads and dependencies being followed by ETL team to load data into the EDW.
• Developed Operations Support Manual, Bug fix plan and data load process documents
• Working experiences with all Business Object components, including but not limited to Business Objects 6.x, XI R2, R3, Web Intelligence andDesktop Intelligence.
• Worked with the business to understand the reporting requirements/changes.
• Analyzed the report change requests and worked with offshore team to implement the changes.

Environment: Informatica Power Center 8.6, Oracle 11g, TOAD 9.0, UNIX, Window, Business Objects XI 3.1

Confidential, Rochester, NY

Lead Support Consultant

Responsibilities:

• Acting as the single point contact for the entire EDW ETL/BI solution.
• Creating and maintaining the monthly and weekly load schedule for data load.
• Working with the data stewards and ensuring the right reference data is available prior to the load.
• Worked with the operations/support team to make sure the hardware resources are available to support the load.
• Analyze the load reports and identify areas of improvements in the existing ETL Load window to meet the monthly / weekly SLA.
• Analyze data load reports and perform first level of analysis on the data errors.
• Work with the business in reconciling the data load reports with the source data.
• Perform ETL and Data impact assessment on the ongoing change requests.
• Maintain and monitor the incident log with the business on support questions and regularly track them to closure.
• Work with the DBAs to monitor system usage and identifies database tuning opportunities.
• Writing UNIX Shell Scripts for processing/cleansing incoming text files and automating certain manual file handling tasks.
• Developed the Technical Specifications based on the Functional Specification understanding the business rules and requirements.

Environment: Informatica Power Center 8.6/8.5, Oracle 10g, TOAD 9.0, UNIX, Windows

Confidential, MN

Sr. ETL Developer/Analyst

Responsibilities:

• Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
• Involved in production support for the data warehouse informatica jobs after go live.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
• Automated Reports and generated documents using Scheduler.
• Created robust and complex workflow and worklets using Informatica workflow manager and trouble shoot data load problems
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/workflows
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Developed Mappings that extract data from ODS to Data mart and monitored the Daily, Weekly and Monthly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Developed the web-intelligence reports, provided a supporting role in building the universes.
• Responsible for synchronizing the data between database and BO reports.

Environment: Informatica PowerCenter7.1/8.1, Universe, Business Objects XI R2, WebI, DESKI, Oracle, Windows, UNIX

Confidential, GA

ETL/Informatica Developer

Responsibilities:

• Involved in ETL processes to load data from Flat files, SQL Server, Access and Excel spreadsheet into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Involved in standardizing the data being stored from various Business Units into the warehouse tables.
• Created complex and robust mappings and mapplets using Mapping designer and Mapplets to generate different mappings for different loads.
• Fine-tuned existing Informatica mappings for performance optimization.
• Used Power Center Server Manager to schedule and monitor different sessions for loading.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Involved in writing UNIX shell scripts using pmcmd command to run batch jobs and automating their schedules.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Involved in writing the PL/SQL procedures and PL/SQL program units for data extraction, transformation and loading.

Environment: Oracle 8i, PL/SQL, SQL Server, Windows, UNIX, Informatica 6.1 (Power Center)

Confidential

Database/ETL Developer

Responsibilities:

• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Extracted data from sources like Oracle, Fixed width and Delimited Flat files, transformed the data according to the business requirement and then loaded into Oracle database.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Produced a Unit test Document, which captures the test conditions and scripts, expected/actual results.
• Maintained existing mappings by resolving performance issues.
• Imported and Created Source Definitions using Source Analyzer.
• Imported and Created Target Definitions using Warehouse Designer.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created mapping parameters and variables.
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Created and Scheduled Sessions and Batch Processes based on demand using Informatica Server Manager.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.

Environment: Oracle 8i, SQL, PL/SQL, Windows, UNIX, Informatica Power center 6.1