SUMMARY

• 8+ years of focused experience in Information Technology with a strong background in Data warehousing and almost 5 years of ETL experience using Informatica PowerCenter 8.6.1/8.1.1/8.0/7.1.2/7.1/6.2
• Extensive experience in developing strategies for ETL process using Informatica in large Warehouse environments.
• Worked on complete SDLC including requirements gathering, functional design, development, testing, deployment and support.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica PowerCenter in Extraction/Transformation/Loading of data and develop Worklets, Workflows and Mappings.
• Experience in Repository Configuration and processing tasks using Workflow Manager & Workflow Monitor to move data from multiple sources into targets
• Developed complex Mappings, used transformations such as Lookup, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure and Update Strategy.
• Working Experience in E - R modeling-FACT & Dimensions tables, Physical & logical data modeling.
• Strong experience in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies used in relational, dimensional and multidimensional modeling, Data Profiling and Data cleansing.
• Expertise in developing SQL, SQL*Plus and PL/SQL codes through various Procedures/Functions, Packages, Cursors and Triggers to implement the business logics of database.
• Strong understanding of Performance tuning in Informatica and loading data into Data Warehouse/Data Marts.
• Strong in developing data models including Logical, Physical, Conceptual and additionally dimensional modeling using star schema for data warehousing projects.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

TECHNICAL SKILLS

Data Warehousing: Informatica (PowerCenter 8.6.1/8.5/8.1/7.1/6.1/5.1.2, Informatica PowerMart 5.1.2/5.0/4.7.2, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Power Exchange 8.6.1/8.5/8.1.1, Datamart, OLAP, OLTP, SQL*Plus, SQL*Loader, MMIS, EBS Adapters for oracle, Partition Exchange Oracle 11g feature, Load Balancer in Integration service for grids feature

Databases: Oracle11g/10g/9i/8i/8.0/7,RAC Clusters MS SQL Server 2008/2005/ 2000/7.0/6.5/6.0, Sybase 12.5/11.x/10,Sql Advantage, Sybase Central, DB2, MS Access 7.0/’97/2000, MS Excel VBA,COBOL(sequential files)

Reporting Tools: BO Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Business Objects Universe Developer - Business Objects 6.5/5.1

Data Modeling: Dimensional Data Modeling, Star Schema, Snowflake Schema, Physical and Logical Data Modeling in ERwin 7.2/4.0/3.5.2. Embarcadero DT/Studio 8.6.2

GUI: Rapid SQL 7.3.0, WS FTP Pro 8.02, Microsoft Visio, TOAD, Microsoft Visual, Sourcesafe 6.0, Visual Basic 5.0/6.0

Programming: SQL, PL/SQL, HTML, DHTML, C, C++, UNIX Shell Scripting

Environment: SAP R/3, IBM OS390, IBM AIX 5.0/5.1/5.3, SunSolaris 9/8/5.8/2.6/2.5, HP UX, AIX, LINUX, Windows95/98/2000/XP, WinNT4.0,MSDOS6.22

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

DW/ETL Informatica Developer

Responsibilities:

• Involved in the full systems life cycle and responsible for all part of designing, developing, testing and implementing.
• Experience in coordinating with offshore team (Deloitte) for day-to-day ETL Progress monitoring.
• Interacted with Data Stewards and Subject Matter Experts to efficiently Transform, Extract and Load data sets to interpret business requirement specifications into data mapping.
• Evaluated ETL coding specifications accurately and built the same into highly optimized Informatica mappings and migrated code to the staging area.
• Prepared and Verified the High Level Design (HLD) and Detail Level Design (DLD) documents for Armor Build Datawarehouse.
• Interface with the Database Administration Group to ensure proper configuration of database objects in Support of ETL code
• Extracted difference sources from like Staging area, CDMA, Flat Files, XML, Siebel, Metavance
• Created complex mappings for Staging area to EDW and from EDW to DataMart using different transformations like Joiner, Expression, Aggregator, Lookup, Update Strategy, Filter and Router Transformation.
• Implemented SCD1 and SCD2 logic in the mappings whenever required.
• Created Stored Procedure to load the Calendar Date table and then Calendar Month table.
• Used the PMCMD command to run the workflows through UNIX shell scripts and job automation using ClearQuest scheduling tool
• Reviewed performance issues in the datamart like analyzing and optimizing query by involving the DBA’s for the SQL override lookups.
• Implemented performance tuning of the Informatica mapping using various components like parameter files, variables and various caches like Static, Dynamic, Shared, Persistent
• Implemented Email, Command task and Decision tasks and shell scripts in the Post session and Pre session commands
• Performed Data Profiling and Code migrations from DEV to QA, and then PROD repositories and monitoring all the environments.
• Used HP-Quality Center for creating and maintaining the history of defects during Integration Testing.
• Reviewed HLD/DLD/Code/VISIOs/Unit Test Plans to ensure code is of the highest quality and confirms to standards for implementation of Metavance System.
• Successfully developed and delivered Test data for implementation of Metavance System (Armor - Build 2 warehouse) for Unit Testing.
• Worked with Production support team and successfully delivered the Claims data for Audit.

Environment: Informatica Power Center 8.6.1, Oracle 10g/11g, Siebel, SQL*Plus, PL/SQL, Rapid SQL 7.3.0, MS Visual Sourcesafe 6.0, MS Visio, HP-CDMA (Access Application), WS FTP Pro 8.02, HP- Quality Center 9.2, ClearQuest 7.0, SQL Server 2005, Win-XP, AIX 5.3 (Korn shell)

Confidential, VA

ETL Informatica/Data Analyst

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model and Participated in the Design team and user requirement gathering.
• Involved in Designing ER models (Logical/Physical) for Oracle database to store data retrieved from other sources including legacy systems.
• Extensively used Informatica Power Center 8.6.1 to extract data from various sources and load in to staging database.
• Participated in the detailed level and high-level design documentation of the ETL system and mapping of business rules.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications.
• Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run.
• Implemented Slowly Changing Dimension methodology for accessing the full history.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Developed Workflows and session to load data into targets.
• Extensive use of Command tasks, Decision tasks, email tasks in the workflow design.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Used DT/designer to validate the physical model of data warehouse or data mart
• Extensively used DT/Studio to define the mapping process and identify about the data flow from source to target by using Data Flow Designer.
• Used DT/Studio Designer to extract multiple sources such as XML files, flat files, Oracle tables and SQL Server tables for the target.
• Used Power Exchange interface to get the data from mainframe files.
• Used batch process CDC (change data capture) mechanism in Power Exchange to get the recent data.
• Created IDQ Algorithm and Identified duplicate records from the source data by using IDQ.
• Standardize and configure the mappings with data quality transformations to compare the values on a field-field basis by using IDQ Workbench.
• Used Standardize transformation to identify the customer information such as spelling in the columns, address, number format of SSN and telephone area code etc.
• Used Address Validator transformation to format the data by analyzing input/output ports.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Scheduled sessions and work flows using Autosys / Informatica scheduler.
• Worked with pre and post sessions and Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Successful code migration from DEV to Testing & Production environment

Environment: Informatica Power Center / Informtica PowerExchange 8.6.1, Embarcadero DT Studio 8.6.1, Embarcadero Rapid SQL, IDQ (Workbench) 9.0.1, Oracle 10g, DB2, PL/SQL, Erwin 7.2, MS Visio, Autosys 4.5.0, SQL Server 2005, Win-XP, AIX 5.1

Confidential, Brea, CA

Datawarehouse Developer

Responsibilities:

• Involved in the design and development of Data Warehousing project for the improvement of Account Management System
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Designed and developed Batch Mappings to load data from different sources into Oracle Staging tables
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Performed realize coordination tasks by making use of Informatica Deployment Group & Labels to migrate objects from one environment to the next environment.
• Widely used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used Transformations like look up, Router, Filter, Joiner, Stored procedure, Source Qualifier, Aggregator and Update strategy extensively.
• Extracted data from Oracle, DB2, Teradata and SAP R/3 database into staging area.
• Tuned performance of Informatica session for large data files by increasing block size, data cache sizes.
• Created Mapplets and used them in different Mappings.
• Created Schema objects like Indexes, Views, and Sequences.
• Developed stored procedure to check source data with Warehouse data and if not present, write the records to spool table and used spool table as Lookup in Transformation.
• Done extensive bulk loading into the target using Oracle SQL Loader
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in writing Korn shell scripts for Informatica ETL tool to automate sessions and cleansing source data.
• Written Korn shell scripts to automate and migrate data from ODS to Data warehouse
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Created Sessions and batches to move data at specific intervals & on demand using Workflow Manager.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Used Load Order and Constraint based loading.
• Provided immediate production support to client when needed
• Used PMCMD to run workflows and used autosys to automate their schedules
• Involved with the Business objects team to review and generating reports using Business Objects Report Designer.

Environment: Informatica Power Center 8.1.1, Informatica Power Exchange 8.1.1, Oracle 10g, DB2 UDB 8.0 (Batch), Teradata, SAP R/3, Autosys (Scheduling tool), Business Objects 6.5, SQL*Plus, PL/SQL, SQL* Loader, SQL Server 2005, Toad, UNIX/AIX 5.0(Korn shell), Win2000.

Confidential, NY

ETL Informatica Developer

Responsibilities:

• Prepared the Detail Design Document from the requirements specification document.
• Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects.
• Created (or edited existing) Informatica mappings and sessions to accomplish data migrations. Sources were Oracle, Sybase and flat files and load into target.
• Created Complex mappings using transformation like Connected/Unconnected Lookup, Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Re-designed ETL mappings to improve data quality.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Provided production support by monitoring the processes running daily.
• Performance tuned the Mappings by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Recommended tuning options to source/target database DBA team to gain optimum performance.

Environment: Informatica PowerCenter 7.1, Oracle 9i/8i, Siebel, DB2, UNIX Shell Scripting, SQL, PL/SQL, TOAD, Sun Solaris 2.6 UNIX HP-UX, Windows 2000.

Confidential, MA

ETL Informatica Developer/Admin

Responsibilities:

• Involved in Designing ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin 4.0.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalizer, Filter).
• Extracted data from various sources like Oracle8i, Sieble, and DB2.
• Wrote validations using PL/SQL Stored Procedures before transferring data from temporary table to Interface tables.
• Created Informatica Relational Database Connections, FTP Connections in Workflow Manager.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Migrated objects like mappings and workflows to different environments.
• Created Autosys Jobs for Scheduling.

Environment: Informatica PowerCenter 6.2, Autosys, COBOL, Oracle8i, Siebel, Teradata, DB2, Toad, Erwin 4.0, PL/SQL, UNIX Shell Scripting, Windows NT, UNIX.

Confidential, Bentonville, AR

DW/ Informatica Developer

Responsibilities:

• Importing various Sources, Targets, and Transformations using Informatica Power Center 5.1
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Developing various Mappings with multiple Sources, Targets, Transformations and Mapplets using Power Center.
• Using heterogeneous data from Oracle, Flat Files SQL server as source and importing stored procedures from oracle.
• Designing and coding maps, which extracted data from existing, source systems into the data warehouse.
• Created complex joiners, transformations of all types to smoothly pass data through ETL maps.
• Created equal partitions to ensure the smooth flow of data concurrently for better performance.
• Using Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Creating and Executing sessions & Batches using Server Manager to load the data into the Target Database.
• Scheduling Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Tuning ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively worked on prompts based on the user needs and data relevancy.
• Generating reports using Business Objects.

Environment: Informatica Power Center 5.1, Business Objects 5.1, Oracle 8i, SQL Server, PL/SQL, IBM OS 390, and Windows NT 4.0.

Confidential

Oracle Developer

Responsibilities:

• Worked with DBA in installing Oracle 8i on Solaris UNIX Box and Windows.
• Reviewed application requirements and recommended Database configuration.
• Designed various data entry forms, Query screen and Output Reports
• Created primary Database storage structures (Table Spaces) and objects (Tables, Views, and Indexes).
• Managed the Table Spaces, rollback segments and indexes for applications.
• Run the Database in Cost Based mode for better performance.
• Coded the Procedures and Triggers.
• For connectivity configured the Sqlnet.ora, tnsnames.ora and listener.ora at server side.
• Coded the scripts for loading the data into Oracle Database from flat files using SQL Loader.

Environment: SQL, PL/SQL, Shell scripting, Oracle 8i, Sun Solaris, Win NT.