PROFESSIONAL SUMMARY

• Over 8 years of professional IT experience in Analysis Design Development Testing and Implementation of various Data Warehousing and Software Applications.
• Design implement data quality business rules using Powercenter workflows Mappings Mapplets Exception tables ad-hoc reporting.
• Experienced in logical and physical data modeling of staging and warehouse environments using Datamodeling tools like Erwin Rational Rose and Oracle Designer.
• Extensively involved in ETL Data warehousing using Informatica Power Center 7.x/8.x/9 Designer tools like Source Analyzer Target Designer Mapping Designer Mapplet Designer Transformation Developer Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier Joiner Filter Router Expression Lookup Aggregator Sorter Normalizer Update Strategy Sequence Generator and Stored Procedure transformations.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.
• Very strong in writing SQL Joins Nested Queries Unions Multi-table joins.
• Experience in scheduling the batch jobs using workflow monitor Control m and FTP methods.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas created slowly changing dimensions SCD Type1/2/3 dimension mappings.
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL SQL Plus PL/SQL Procedures/Functions Triggers and Packages.
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading pushing and pulling data from different servers.
• Good experience in performing and supporting Unit testing System Integration testing SIT UAT and production support for issues raised by application users.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

ETL/InformaticaDeveloper

Confidential is one of the leading internet service providers in the US. The project was to build a Data Warehouse which would integrate all insurance data for accounting purposes. Data was coming in from different sources and types which include type of contracts premium plans home office or large scale usage. The extracted data was analyzed and passed into the ODS using Informatica as an ETL tool. Flat Files Oracle tables and Excel spreadsheets were part of the source data which came in on a daily weekly and monthly basis. The warehouse was sitting on Oracle database.

Responsibilities

• Worked with the business analysts and DBA to gather business requirements to be translated into design considerations.
• This also gave some good expertise with some of the tool migration techniques.
• Identified and tracked the slowly changing dimensions to capture the changes in heterogeneous sources and determined the hierarchies in dimensions.
• Speeding up of work by using re-usable transformations and work-lets for further lowering of errors and enhancing work flow performance. Developed schedules to automate the update process and Informatica Batches/Sessions.
• Extracted data from Oracle MS SQL Server and loaded them into Oracle.
• Worked with team that was focused on capturing mainly changes in customer plans.
• Also generate notices to customers where the contracts would expire in a span of less than 3 months and give them more advantage over choosing rate plans depending on there using. This was achieved through an extensive of LOOK-UP s and analysis of Data.
• Worked with Source Analyzer Warehouse Designer Transformation designer Mapping designer and Workflow Manager
• Developed data Mappings between source systems and warehouse components.
• Created various Transformations like Joiner Aggregator Expression Lookup Filter Update Strategy Stored Procedures and Router etc.
• Organized data in order to capture the basic nature of the business environment providing a stable view of the data associated with the core business processes.
• Monitored sessions that were scheduled running completed or failed
• To retrieve the data from various Tables and to test the database wrote SQL Queries.
• Worked on Documentation to describe program development logic coding testing changes and corrections
• Participated in Enhancements meeting to distinguish between bugs and enhancements.

Environment InformaticaPowerCenter Windows Oracle 10g Flat Files TOAD SQL Developer UNIX My SQL Mac MS-Office.

Confidential

ETL Developer

Bayer Confidential Pharmaceuticals is one of the leading pharmaceutical companies in USA manufactures markets and/or distributes more than 56 drugs in the United States. Bayer seeks to contribute to people s health across the globe by developing innovative new pharmaceuticals to treat many diseases. The Company has a lot of data from various PBMs for rebate payments. The project involves development of Commercial Rebates Payment Processing System.

Responsibilities

• Analysis involved in acquiring Requirements from Business Requirement Document BRD function/technical specification development deploying and testing by Business Analysts UAT TQA and Developers.
• Converted the business requirements into technical specifications for ETL process by populating the fact and dimension tables of data warehouse.
• Created and executed SQL scripts in oracle to test the data flow from OLTP systems to data warehouse.
• Designed assisted Informatica ETL developer to create new Aggregate.
• Created Informatica mappings for initial load and daily updates.
• Developed several mappings Source Qualifier Lookup Filter Joiner Aggregate Sequence Generator Expression Lookup Router Normalizer and Update Strategy to load data from multiple sources to data warehouse.
• Created sessions workflows and database connections using Informatica Workflow Manager.
• Worked with pre and post session SQL commands to drop and recreate the indexes on data warehouse using source qualifier transformation of Informatica Power center.
• Involved in troubleshooting the load failure cases including database problems.
• Developed different kinds of Reports pivots charts tabular using global and local Filters.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Configured environments for full ETL and incremental data loads from OLTP to OLAP data sources using DAC and Informatica routines.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Configured new customized mappings and work flows in DAC for new customized subject area.
• Configured DAC to run nightly data loads on daily basis.

Environment Informatica 7.1.4 Oracle My SQL UNIX Windows XP Mac TOAD.

Confidential

Informatica Developer

Fannie mae is leading source of residential mortgage credit in the U.S. secondary market Fannie Mae is supporting today s economic recovery and helping to build a sustainable housing finance system. We exist to provide reliable large-scale access to affordable mortgage credit in all communities across the country at all times so people can buy refinance or rent homes.

Responsibilities

• Design and developed Oracle PL/SQL Scripts for Data Import/Export Data Conversions and Data cleansing.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Created Mapplet and used them in different Mappings.
• Provide Knowledge Transfer to the end users and created extensive documentation on the design development implementation daily loads and process flow of the mapping.
• Developed Complex mappings and workflows using Power Center designer and Workflow manager for loading data into Data warehouse from staging.
• Developed and maintained custom PL/SQL packages and procedures for analysis of source system data and also for data validation
• Extensively involved in creating design documents for loading data into Data warehouse and worked with the data modeler to change/update the Data warehouse model when needed.
• Reporting based on Slowly Changing Dimension of SCD1 and SCD2.
• Responsible for Performance Tuning at the Source Target level Mapping Level and Session Level.
• Implemented various loads like Daily Loads Weekly Loads and Quarterly Loads using Incremental Loading Strategy using the concepts of Change Data Capture CDC .

Environment Visual Studio Manual SQL Server Windows Unix All the Ms-Office tools Adobe Illustrator Graphing tools like PRISM SIGMAPLOT ORIGIN.

Confidential

Programmer analyst

This is eQUOTE and SSQ Data warehouse provides data of surgical support systems infection prevention systems and contamination prevention technologies. eQUOTE is the main system and its basically a system for sending quotes to a potential customer prospect or current customer. This application has Informatica Power Center is the ETL tool on UNIX Oracle RDBMS and Business Objects for analytical reporting.

RESPONSIBILITIES

• Collaborated with Business Analysts and the DBA to gather requirements business analysis and designing of data marts.
• Analyzed the logical model of the databases and normalizing it when necessary.
• Involved in identification of the fact and dimension tables.
• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Extensively used Router Joiner Lookup Aggregator Expression and Update Strategy Transformations.
• Extensively used ETL to load data from wide range of source such as flat files csv fixed length Oracle and XML to ORACLE.
• Extensively worked in the performance tuning of the mappings ETL Procedures and processes.
• Developed re-usable transformations mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Performed Unit Testing on the developed Mappings.
• Supported QA Testing and Production Testing by identifying the bugs and also helped to resolve various Data issues.
• Involved in the Migration process from Development Test and Production Environment
• Wrote stored procedures and triggers in Oracle 9i for managing consistency and referential integrity across data mart.
• Unix shell scripts are used for scheduling to automate the load process.
• Developed Reports for the clients using business objects.

Environment Informatica PowerCenter 6.1 Sun Solaris 8 Oracle 9i SQL Loader Erwin 3.7 TOAD 7.6 Windows 2000 SQL PL/SQL Business Objects.