SUMMARY

• Over 8+ years of experience with Database Analysis, System design, Application Development, Testing support and Production support for Data Warehousing which involves ETL, Reporting and Data modeling experience. Expertise in development of Data warehousing solutions using Informatica Power Center 9.x/8.x
• Experience in data modeling, data warehouse, and Ralph Kimball models with Star/Snowflake Schema Designs with analysis - definition, database design, testing, and implementation and Quality process.
• Professional Experience in ETL Architecture using Informatica Power Center, 7.x/8.x/9.x
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager. Experience working in Oracle 9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, indexes.
• Strong experience in designing and developing business intelligence solutions in Data warehouse/Decision Support Systems using ETL tools Informatica Power Center 9.1/8.6.1/8.1/7.1/6.2/6.1 , OLTP, OLAP.
• Experience in Oracle 11i/10g/9i/8i/7.x, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, MS SQL Server 2000/2005/2008.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation.
• Data modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling and Oracle Designer.
• Experience with reading from Mainframe datasets and Cobol Sources using Informatica Power Exchange.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 9.x/8.x/7.x/6.x, Power exchange 8.1 and Power Mart 5.x/6.x Client, Server.
• Extensively worked on Data Warehouse Administrative Console (DAC).
• Experience in OBIEE10x / Siebel Analytics including Designing and Configuring Repository, Creating/managing Dashboards, Answers, and Interactive dashboards.
• Extracted data from various sources like Oracle, DB2, Flat file, SQL SERVER, XML files, Teradata and loaded into Oracle database. Also worked as PL/SQL developer
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files, COBOL and XML files. Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Implemented Dimensional Hierarchies, Level based Measures, Aggregations, Cache Management.
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on both Windows (Batch and Power shell) and Unix Scripting.
• Experience in creation and customization of ETL extracts and load process using Informatica.
• Experience in Business Objects, Crystal Reports specifications document for monitoring performance of Business Objects using BAC Monitoring System.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Worked on data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Innovative team player possessing good communication & presentation skills and support to onshore and offshore clients.

TECHNICAL SKILLS

Data Warehousing/ETL Tools: Informatica PowerCenter 9.x/8.x/7.x (Mapping Designer, Mapplet, Transformation, Sessions, Workflow Manager-Workflow, Task, Commands, Worklet, Transactional Control, Constraint Based Loading, SCD I, II, Web Services and XML transformations), PowerExchange, BODI, Metadata, Informatica Data Quality (IDQ) 7.3, Informatica Datamart

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005, DB2, Sybase, Teradata, MS Access 7.0/2000, SQL Server (DTS/SSIS/SSRS)

Reporting Tools: OBIEE 10g/11g, Cognos

Tools: MS Office 2010,07 Professional, SQL*Plus 3.3/8.0, TOAD, Server Management Studio Express, Microsoft Visio, Putty, Text Pad, .vsd files, .csv files, Erwin, ER Model, Siebel, Salesforce Integration, DAC,RPD, SAP

Programming Languages: Unix Shell Scripting and Perl Scripting, Batch Scripting, VB.NET 05/08, XML, HTML, C, C++, UML (Rational Rose), Java, Oracle PL/SQL (Stored Procedures, triggers, Indexes).

Environment: Windows 98/2000/2003/ XP/NT and Windows NT, UNIX, SOLARIS.

Data Modeling: Star Schema and Snow-Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling, ER Studio, Erwin 4.5/4.2/3.5/3. x,Oracle Designer/2000.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. ETL Informatica Consultant

Responsibilities:

• Designed and Developed Mappings, sessions and workflows in Informatica.
• Used Informatica and the Data Warehouse Administration Console (DAC) to configure ETL metadata and run an execution plan to load Oracle E-Business Suite (EBS) data into the OBAW.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Customized SDE and SIL mappings using Informatica PowerCenter Designer in order to add new columns to the Dimension/Fact table in Oracle Business Analytics Warehouse from Oracle EBS Source.
• Designed the Data model and Load strategy to get data from different systems and use it for the Online Registration database.
• Prepared the Technical Specs, Reverse Engineered Logical designs using Erwin, Flow diagrams and Timeline sheets to facilitate development of Informatica Flows.
• Implemented Star Schema for denormalizing data for faster data retrieval for Online Systems.
• Extracted, transformed data from various sources such as Flat files, Oracle 11g and transferred data to the target data warehouse Oracle 11g and XLS files.
• Explore prebuilt ETL metadata, including Informatica workflows and mappings and DAC metadata.
• Designed and developed Informatica Mapping for data load and data cleansing.
• Integrated the developed Data Warehouse into OBIEE administration tool for reporting purpose.
• Responsible for Pre and Post migration planning for optimizing Data load performance capacity planning and user support.
• Involved in building the Physical, Business and Presentation Layer through OBIEE Administration tool.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Partitioned sources and used persistent cache for Lookup’s to improve session performance.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Worked with Data / Data Warehouse Architect on logical and physical model designs.
• Performed impact analysis for systems and database modifications.

Environment: Informatica Power Center 9.5/9.1/8.6.1 , Oracle 11g/10g, OBIEE 10g, SQL Server, XML, Flat Files, Toad, DAC 10g/11g (Data Warehouse Administration Console), Shell Scripting.

Confidential, Addison, IL

Sr. ETL/Informatica Developer

Responsibilities:

• Designed the Data model and Load strategy to get data from different systems and use it for the Online Registration database.
• Prepared the Technical Specs, Reverse Engineered Logical designs using Erwin, Flow diagrams and Timeline sheets to facilitate development of Informatica Flows.
• Extensive experience in ETL development and maintenance using Oracle SQL, PL/SQL and written Store procedure for the Data Dimensions table to insert 10 years’ worth of data and also used the Informatica Store Procedure Transformation to update the columns in the same table
• Implemented Star Schema for De-normalizing data for faster data retrieval for Online Systems.
• Developed Procedures and Functions in PL/SQL for Data ETL.
• Designed and Developed Mappings, sessions and workflows in Informatica.
• Extracted, transformed data from various sources such as Flat files, Oracle 11g and transferred data to the target data warehouse Oracle 11g and Flat files.
• Customized Project, HR, Procurement and Finance inbuilt mappings.
• Involved in installation and configuration of Informatica and DAC.
• Designed and Deployed UNIX Shell Scripts.
• Integrated the developed Data Warehouse into OBIEE administration tool for reporting purpose.
• Used Conversion process for VSAM to ASCII source files usingInformaticaPowerExchange.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Responsible for Pre and Post migration planning for optimizing Data load performance, capacity planning and user support.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Involved in creating STAR Schema for OLAP cubes.
• Involved in building the Physical, Business and Presentation Layer through OBIEE Administration tool.
• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Partitioned sources and used persistent cache for Lookup’s to improve session performance
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Worked with Data / Data Warehouse Architect on logical and physical model designs.
• Involved in developing of stored procedure for Change Data Capture (CDC), Auditing etc.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Extracted data from Sales department to flat files and load the data to the target database.

Environment: Informatica Power Center 9.1/8.6.1, Power Exchange8.1.1, Oracle 11g/10g, OBIEE, DAC, SQL Server, Teradata, XML, Flat Files, Toad, Sql Developer, Shell Scripting.

Confidential - Bloomington, IL

ETL/Informatica Developer

Responsibilities:

• Developed ETL for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 8.6.0
• Informatica Power Center is used to extract the base tables in the data warehouse and the source databases include Oracle, Flat files and SQL Server.
• Extensive BI and Data warehousing experience using Siebel Analytics 7.x/OBIEE and Informatica 9.x/8.x/7.x/6.x.
• Setup the batches, configured the sessions and scheduled the loads as per requirement using UNIX scripts.
• Worked on Informatica Data Quality (IDQ) to resolve customers address related issues.
• Worked onPowerExchangefor change data capture (CDC).
• Extensively worked in fixing poorly designed mappings and developed schedules to automate the Informatica workflows
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Used Informatica and the Data Warehouse Administration Console (DAC) to configure
• Developed oracle PL/SQL, DDLs, and Stored Procedures and worked on performance and fine Tuning of SQL & PL/SQL stored procedures. Involved in creation of multiple data integration schemas for tuning and purging of data
• Troubleshooting and debugging of defects and production issues in the areas of SQL, Informatica and OBIEE 11g/10g.
• Involved in SQL tuning while creation of various different sql procedures.
• Developed Informatica mappings using transformations like Lookup, Stored Procedure, Filter, Expression, and Aggregator.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Customized Informatica and DAC metadata.
• Created test plans and did unit testing for the Informatica mappings and stored procedures
• Extensively involved in writing ETL Specs for Development and conversion projects.
• Extensively used PVCS and Serena.
• Worked on various data issues in Production environment.
• Uploaded data from operational source system (Oracle 8i) toTeradata.
• Data is Staged, integrated, Validated and finally loaded the data into Teradata Warehouse using Informatica.
• Recommended temporary fixes and workarounds for production issues and also proposed permanent fixes.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, OBIEE, DAC, SQL, PL/SQL, Teradata, TOAD, SQL*Plus, Windows 2000, SQL Server, UNIX, Cognos.

Confidential, Boston, MA

ETL/Informatica Developer

Responsibilities:

• Interacting with business representatives for requirement analysis and to define business and functional specifications.
• Designing and building data marts for Disability, Life, Accident, and underwriting divisions.
• Loading Data to the Interface tables from multiple data sources such as SQL server, Text files and Excel Spreadsheets using SQL Loader, Informatica and ODBC connections.
• Creating necessary repositories to handle the metadata in the ETL process.
• Designing the target warehouse using Star Schema.
• Even involved in some tasks like Development and setting up the new environments and Generating Microsoft Sql server Reports (SSIS).
• Involved in installation and configuration of Informatica and DAC.
• Designing and introducing new FACT or Dimension Tables to the existing Model and deciding the granularity of Fact Tables.
• Helped the team in analyzing the data to be able to identify the data quality issues.
• Installed and configured Informatica Power Center and Server 8.6.
• Designing different regional data marts and loaded subset of warehouse data.
• Writing Unix Shell Scripts to load data from different sources.
• Implementing Aggregate, Filter, Join, and Expression, Lookup, Sequence generator and Update Strategy transformations.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Implementing Variables and Parameters in Transformations to calculate billing data in billing Domain.
• Used Java Transformations to invoke web services and Java Servlets.
• Tuning performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Creating sessions, sequential and concurrent batches for proper execution of mappings using workflow manager.
• Optimizing Query Performance, Session Performance and Reliability.
• Designing Database schemas using Erwin Design Tool.
• Using Informatica Designer designed and developed Source Entities and Target warehouse Entity for Oracle.
• Involving in versioning the whole process and retiring the old records using the built-in’s DD UPDATE, DD DELETE, and DD INSERT.
• Developing Mapplets using corresponding Source, Targets and Transformations.
• Testing all the applications and transport the data to target Warehouse Oracle tables on the server, Schedule and Run Extraction and Load process and monitor sessions by using Informatica Workflow Manager.

Environment: Informatica 8.6/8.1, Oracle 9i (TOAD), OBIEE, DAC, MS SQL SERVER 2005, MS SQL Reporting Services (SSIS), MS ACCESS, MS EXCEL 2007(PIVOT tables), Autosys.

Confidential, NM

Informatica Developer

Responsibilities:

• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling and using Erwin.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Actively involved in gathering requirements from the end users.
• Used ETL (Informatica) to load data from sources like Oracle database and Flat Files.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables..
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Involved in creating and management of global and local repositories and assigning permissions using
• Repository Manager. Also migrated repositories between development, testing and production systems.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
• Extensively used Stored Procedures, Functions and PL/ SQL Programming.
• Extensively used Normalizer transformation while loading the data from the COBOL copybooks to the staging area.
• Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Checked and tuned the performance of application.
• Developed data Mappings between source systems and warehouse components.
• Created and defined DDL’s for the tables at staging area.
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Analyzed systems, met with end users and business units, in order to define and meet the requirements.
• Automated mappings to run using UNIX shell scripts, which included Pre and Post-session jobs.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.
• Installed and configured Informatica Tools on client machine on Windows NT environment.
• Used Informatica Power Analyzer and Informatica Analytics for developing Dashboards, Alerts, Reports,
• Indicators and Adhoc Query Reporting.
• Training the users how to access and run the jobs Using Informatica workflow Manager

Environment: Informatica Power Center 8.1/7.1.3, Oracle 10g, Toad 7.5, Erwin, SQL, PL/SQL, SQL plus, MS SQL Server 2005, UNIX.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Interacted with different teams across different line of business on standardization and protocols to be followed when integrating data across different systems.
• Involved in designing the Data Warehouse structure and all its components like Dimensions, Facts, and Aggregations etc. by backtracking from Reports Specifications.
• Created Technical Specifications for source to target mapping of data to implement the business rules and logic
• Wrote complex SQL scripts to avoid Informatica Joiners and Look-ups to improve the performance as the volume of the data was heavy
• Designed the complex mappings, used Aggregator, Filter, Router, and Expression, Connected and Unconnected lookup, Sorter, Normalizer, Joiner transformations and Update Strategy transformation
• Created mappings to extract and de-normalize(flatten) data from XML(XSD) files using multiple joiners with Power Center
• Implemented slowly changing dimension (SCD) Type 1 and Type 2 mappings for changed data capture.
• Developed and scheduled Workflows using Workflow designer in Workflow Manager and monitored the results in Workflow monitor Worked with many existing Mappings to produce correct output.
• Created events and tasks in the work flows using workflow manager.
• Used shell scripts to load data from flat files to Oracle tables using Informatica and also to cleanse data
• Tried to implement best practices following proper naming convention, directory structure, access mechanism, reusability of code etc.
• Involved in Performance Tuning of sources, targets, mappings, transformations and sessions to optimize session performance
• Performed the Unit Testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables

Environment: Informatica Power Center 7.1, Toad, Power Exchange 5.1, Oracle10g, PL/SQL, SQL Server.