SUMMARY

• 7+ years of strong experience in Data Warehousing and ETL using Informatica PowerCenter 8.6.1/8.1.1/8.0/7.1.1 , Informatica Power Mart 6.2/5.1/4.7, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server), PowerConnect, Power Plug, Power Analyzer, Power Exchange, ETL, Data mart, OLAP, OLTP
• Extensive experience in Business Analysis, Application Design, Data Modeling, Development, Implementation and Testing Data warehouse and Database applications for Health Care, Insurance, Retail, Commercial and Financial Services.
• Experience in various phases of IT projects Software Development Life Cycle (SDLC) such as analysis, design, coding and testing, deployment and production support.
• Extensive Experience on End - To-End implementation of Data warehouse and Strong understanding of Data warehouse concepts, ETL, Star Schema, Data modeling experience using Normalization, Business Process Analysis, Dimensional Data modeling, FACT & Dimensions tables, Physical & Logical data modeling, Erwin 4.5/4.x/3.0.
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3. Implemented the complex business rules by creating reusable transformations and Mappings / Mapplets.
• Experience in debugging and Performance tuning of targets, sources, mappings and Sessions.
• Extensive experience in the implementation of Data warehouse/ Data marts.
• Experience in creating data maps using Power Exchange Navigator version 5.2.2
• Proficient in Unix Shell Scripting
• Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
• Experience in Meta Data Management.
• Strong Database experience in using Oracle 10g/9i/8i/8.x/7.x, DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2005/2000/7.0/6.5 , Sybase 12.x/11.x, MS Access 7.0/2000, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• Strong Experience to TOAD & ODBC interfaces to Oracle.
• Strong modeling normalization, de-normalization, logical and physical database design(ER diagram and fully attributed models), relational models, dimensional star schemas, snowflake schemas skills.
• Experience in Cleansing Data quality tool like Trillium 7.0
• Proficient in estimation and determination of the level of effort required for the implementation and integration testing.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.6.1/8.1/7.1.1/6.2/5.1 , Informatica Power Mart 6.2/5.1/4.7, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server), PowerConnect, Power Plug, Power Analyzer, PowerExchange, ETL, Data mart, OLAP, OLTP

RDBMS: Oracle 10g,9i/8.0/7.x, MSSQL Server 2005, MS Access 7.0, Sybase, Teradata V2R6, DB2, UDB

Reporting Tools: Business Objects 6.0/5.x, Cognos and Crystal Reports, Business Intelligence.

Programming: VB, JavaScript, SQL, PL/SQL, UNIX Shell Scripting, COBOL AWK, XML, PERL, C, C++

Utility Tools: SQL*Loader, Toad 7.x/8.x, PL/SQL Developer 7.03, Erwin, PVCS, DB Artisan 7.2.1/8.0, XML spy 2006 Professional Edition, ControlM GUI 6.2, Autosys,Visio, Rational Rose, Developer 2000 (Forms 4.5/6.0 & Reports 2.5/6.0)

Operating Systems: Win NT, Windows Server 2000/2003/XP Professional, Sun Solaris 8/7/2.7/2.6, HP-UX, IBM AIX 4.2/4.3, UNIX, Linux (Red Hat Enterprise Linux - RHEL 4.1/3.1)

Data Quality/Cleansing: Trillium 7.0

Web: XML, Java, JSP, ASP 2.0/3.0, Dream Weaver 4.0, Visual Interdev 6.0 and HTML.

ERP: Oracle Apps 11 (AR, AP, GL, CM, FA, Sys admin, AOL)

PROFESSIONAL EXPERIENCE

Sr.Informatica Developer

Confidential, Birmingham, AL

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, DB2 & oracle and load them into Oracle & Teradata.
• Implemented Slowly Changing Dimensions (Type 1 &2).
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored procedure transformations.
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, Data warehousing designer, Mapping Designer &Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Development of BO reports and performance tuning of custom programs
• Extensively used Informatica to load data from XML, Flat Files to Oracle.
• Created reusable transformations and Mapplets and used them in mappings.
• Used Informatica Power center work flow manager to create sessions, work flows and work-lets to run with the logic embedded in the mappings.
• Fine-tuned Transformations and mappings for better performance.
• Involved in the process in documentation of source-to-target documentation design documentation of the Data Warehouse Dimensional Upgrades. Extensively used Informatica for loading the historical data from various tables for different departments.
• Created complex mappings and transformations.
• Written UNIX shell Scripts for getting data from all systems to Data Warehousing system.
• Involved in different Team review meetings.
• Did Unit Testing and tuned for better performance.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Created dimensions and facts in the physical data model.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.

Environment: Informatica Power Center 8.6.3, DB2, BOXI3.1, Win 2K, UNIX, Oracle 9i, SQL Navigator, Argent Job Scheduler, AS/400, WINSQL, VISIO, POWER POINT

Informatica/Crystal Reports Developer

Confidential, Rochester, MN

Responsibilities:

• Collected requirements from Business Users, analyzed and prepared the technical specifications
• Used ETL tools Informatica 8.6.3/9.1 to extract data from source systems, cleanse Transform, and Load data into databases.
• Developed mappings using Power Center -Designer for data transformation as per the technical requirements
• Designed mappings for different subject area CLAIMS, DENIED CLAIMS, PROCEUDRE, PROVIDER, REFERENCE, MEMBER,WMS
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Used Update Strategy DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement.
• Implemented slowly changing dimension (SCD) for accessing the full history of Customer and transactions of customer. Implement Type I, II, and III changes in slowly changing dimension tables.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Created mapping using TERADATA, COBOL, DB2 sources
• Used Reusable Transformations and Reusable Mapplets for different validations
• Built PLSQL procedures, functions as a part of custom transformations
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Designed views and materialized views to create accumulated data based on the detail facts the data
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• Experience on Hadoop software, used it for working on different nodes and with huge amount of data
• Designed work flows, that are used to run a set of maps together one after the other, the results such as the execution time, start time, end time and status are stored in a run time repository which can be accessed by other users
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used MS Access to extract the data from different sources and to generate the reports
• Used debugger to test the mapping and fixed the bugs
• Developed UNIX shell scripts to schedule the jobs for running
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Co-ordinate with QA and BI reporting teams for any data related issues.

Environment: Informatica 8.6.3, SQL Server 2008/2005, Oracle 11i, PL/SQL, Crystal Reports, BOXI, TERADATA, UNIX, VIRTUAL WINDOWS XP, WINDOWS 7, IBM Rational Clear Case, SQL Developer 2005,SUN SOLARIS, MS Access

Informatica Developer

Confidential, Michigan

Responsibilities:

• Involved in ETL process from development to testing and production environments.
• Involved in Data Analysis, Requirement gathering.
• Involved in setting standards and Warehouse maintenance
• Created standard templates or patterns to standardize the process.
• Established standard Code migration process.
• Designed Audit mappings.
• Involved in upgrading from Informatica 7.1.4 to 8.6.1.
• Involved in Performance tuning by determining bottlenecks and increased better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in partitioning.
• Involved in development and maintenance of the data warehouse for reporting and consolidations of the operations.
• Extensively used mapping parameters, mapping variables and parameter files.
• Designed load the data by starting the batches using indicator files.
• Wrote batch files for different functionalities to run them as pre and post session scripts. Developed and tested stored procedures, functions and packages in PL/SQL.
• Troubleshoot the loading failure cases, including database problems.
• Prepared Documents like Technical Design Doc, Production Support Doc, and Deployment Document.
• Used Deployment groups for code migration.
• Obtained data from different interface like Relational databases, Flat files and XML.
• Scheduled the jobs using Tivoli Scheduling tool.

Environment: Informatica Power Center 7.1.4/8.6.1 Power Exchange for Web Services 8.6, Oracle 10g/9i, SQL Server 2003, BO XIR2, Tivoli Job Scheduler 8.3, Toad 8.6, Solaris 8/10, Windows XP.

ETL Developer

Confidential, Dover, DE

Responsibilities:

• Created sources using Source analyzer in the Designer and Target using warehouse designer
• Involved in Data Extraction from various branch data sources like Oracle, SQL Server & .CSV files to load the extracts into the target warehouse.
• Involved in creating mappings and mapplets using Transformations such as Source Qualifier, Expression, Filter, Joiner, Router, Sequence Generator, Look up and Update Strategy Transformation.
• Involved in creating Jobs for SCD Type 1 and 2 dimensions
• Created sessions and batches, configuring informatica server in the server manager
• Involved in Unit and system testing
• Involved Migration activities from development and pre-production environments
• Created workflows to support daily, nightly, weekly loading
• Developed and modified Unix shell scripts to reset and run Informatica workflows using pmcmd on Unix Environment.
• Debugged maps using Debugger and Transformation’s verbose data.
• Extensively created Reusable Transformations and mapplets to implement the business logic for loading to the target database
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Developed Procedures and Functions in PL/SQL for Data ETL
• Extensively used all the features of Informatica including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Responsible for Query Optimization, Performance Tuning, SQL tuning, Session Performance
• Involved in logical and physical database design.
• Handled large volume of data, complexity of data relationships.
• Implemented Error handling Mechanisms in Informatica mapping.
• Extensively used Test Director to document test cases and test results.
• Unit testing, System testing and user acceptance testing (UAT).

Environment: Informatica Power Center 7.1, Solaris, Windows NT, MS SQL Server 2000, DB2, Oracle 9i, PL/SQL, XML Files, SQL*PLUS, SQL*Loader, TOAD, Shell Scripts

Informatica Developer

Confidential, NY

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model
• Managing Team, Timelines and Coordinating with the Business Partners
• Worked as part of the architect team to develop complete star schema (Snow Flake)for the Phase I of the Data Warehouse
• Create the naming standards for the DW team
• Worked on developing all the mapping needed to load the staging area of the DW
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica
• Coordinates migration of data during the development effort.
• Performs high-level architectural planning and proof-of-concept.
• Defining and implementing the standards, shared components and approaches as per the Confidential Standards.
• Perform QA and Code review for my code and other developers code
• Worked on various drill through reports, conditional formatting, toggle reports and master detail relationships.
• Created complex reports using calculated data items, multiple lists in a single report.
• Prepared functional and technical documentation of the reports created for future references.

Environment: Informatica Power Center 7.1.2, Oracle 9i, PL/SQL, MS SQL Server, TOAD, Windows NT, Shell Scripting, HP UNIX 10.2

ETL/Informatica Developer

Confidential

Responsibilities:

• Extensively involved to implement customer data mart and also data ware house.
• Analyzed the source data coming from Oracle, SQL server, and flat files.
• Worked with Star Schema and Snow flake schema for the data warehouse.
• Extensively used Informatica Power center for extracting, transforming and loading into different databases.
• Designed, developed and tested the different Mappings according to Requirements.
• Analyzed the load dependencies and scheduled the workflows accordingly to avoid the loading conflict issues.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts as part of the ETL process for scheduling.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Created database objects like Tables, Indexes
• Performed unit testing, knowledge transfer and mentored other team members.

Environment: Informatica PowerCenter 5.1.1, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.

Jr.PL/SQL Developer

Confidential

Responsibilities:

• Wrote PL/SQL stored procedures and triggers to implement business requirements.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Used sqlloader and external tables to load data from text files into the database.
• Involved in creating and maintaining Partitioned Tables and Indexes
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Extensively worked with DML Triggers.
• Involved in writing complex SQL statements.
• Involved in creating stored procedures and packages with DYNAMIC SQL.
• Involved in analyzing the schema, so that the costs can be efficiently utilized by the optimizer.
• Involved in creating user roles.
• Involved in comparing Production data with Test data for identifying and cleaning corrupted data.

Environment: PL/SQL, Oracle 8i, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 11.