SUMMARY

• 7+ years of comprehensive experience in Data Warehouse technologies helping clients align IT strategies with corporate strategic objectives across departments.
• Good experience in analysis, design, development, and implementation and troubleshooting, in the area of Data Warehousing.
• Experience working with Informatica Power Center 9.x,8.x/7.1/6.1.
• Responsible for all activities related to the development, implementation, administration and support of (Data Extraction, Data Transformation and Data Loading) ETL processes for large - scale data warehouses using PowerCenter and PowerExchange.
• Significant experience in ETL tool Informatica Power Center/ Power Mart in analyzing, designing and developing ETL processes for Data Warehousing and Data Migration projects.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Designed and Developed Data Marts by Following Star Schema and Snowflake Schema Methodology.
• Involved in writing scripts for loading data to target data warehouse for BTEQ, FastLoad and MultiLoad.
• Very good knowledge in data warehouse designs using Star Schema and Snow Flake Schema Architectures, Fact and Dimension Tables, OLTP and OLAP applications Good Experience in Configuring Data ware Administration Console (DAC).
• Good command in Designing/Developing complex mappings using transformations like Connected/Unconnected Lookups, Router, Filter, Expression, Aggregator, Normalizer, Joiner and Update Strategy.
• Good knowledge in interacting with Informatica Data Explorer(IDE) and Informatica Data Quality(IDQ)
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos, and SSRS.
• Good Experience in backup and recovery in informatica and oracle.
• Involved in the installation and configuring the Informatica Power Center server and client.
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using PowerCenter.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Experience with Informatica Server Manager to create Sessions and Workflows to run with the logic embedded in the mappings.
• Responsible for all activities related to the development, implementation, administration and support of (Data Extraction, Data Transformation and Data Loading) ETL processes for large-scale data warehouses using PowerCenter and PowerExchange.
• Very good command on Database such as Oracle 11g/10g, DB2, SQL Server 2000, MS Access.
• Worked with different source systems like Flat Files and Databases.
• Good experience developing SQL, PL/SQL Stored Procedures, Packages, Functions, Cursors and Triggers.
• Good working skills in optimizing the SQL to improve performance.
• Actively participated and contributed in continuous process improvement within systems development areas of application design, development, and implementation.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating System: WINDOWS (98, 2000, NT, XP,7), UNIX and Linux

Programming Languages: C, C++, SQL, PL SQL, UNIX Shell Scripting

Application Development: Informatica Power Center 9.x,8.x/7.x/6.x, IDQ, OLAP, OLTP, SQL*Loader, Informatica Power Connect for DB2, Informatica. Metadata Reporter, Power Exchange 8.x, SQL*Plus,Oracle Warehouse Builder, Data Integrator, IBM DB2, Toad, SSIS, Oracle and SQL server, Putty., Informatica Data Quality

Reporting Tools: Business Objects XI R2, IBM Cognos 8, SSRS

Databases / DB Tools: Oracle, IBM DB2, SQL Server, Teradata

Methodologies/Techniques: Relational and Dimensional (Star Schema) Data Modeling, Data Warehouse and Data Mart Design, Extract, Transform, and Load (ETL) / Data Staging Design

Utilities/Command Languages: IBM DB2 Load Utility, IBM DB2 Export

Scheduling Tools: AUTOSYS, CRON

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

Sr. ETL Developer

Responsibilities:

• Involved with Business Analysts in requirements gathering, business analysis testing and project coordination.
• Involved in Dimensional modeling to design and develop STAR Schema, using Erwin.
• Analyzed the source data coming from different sources(Oracle, DB2) and also worked with business users and developers to design the Model.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions and heterogeneous sources.
• Extensively worked on Informatica 9.5 to extract data from flat files and Oracle, and to load the data into the target Teradata database.
• Developed mappings using Informatica Power Center to load data from various source systems totarget database and using B2B Data Transformation Studio.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy,Stored Procedures.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Extracted and transformed data with business rules, and built reusable mappings, known as Mapplets using Informatica Designer.
• Wrote PL/SQLstored Procedures and Functions for Stored Procedure Transformations.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Extensively worked on MLoad, BTEQ, Fast Export andFast Loadto design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Extensively used Informatica tool to extract, transform and load the data from Flat Files, Oracle to Oracle.
• Worked with Oracle, SQL Server and flat file sources.
• Used Information data quality (IDQ) and developed Profiles and Scorecards for analyzing the data.
• Tunedperformance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval and Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Used PMCMD command mode to schedule and run workflows. Developed UNIX Shell scripts to archive files after extracting and loading data to Warehouse.Written UNIX shell scripts to automate manual tasks.
• Provided End User training and support.

Environment: Informatica Power Center 9.5, Teradata, Power Exchange, Workflow Manager, Workflow Monitor, Erwin 8.2, PL/SQL, DB2, Oracle, COBOL, SQL Loader, Business Objects, Cognos,UNIX, Win 2000.

Confidential, St. Louis MO

Sr. ETL Analyst/Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed logical and physical data models that capture current state/future state data elements and data flows.
• Designed Logical and Physical Database (Star Schema) using Reverse Engineering principle with Erwin 4.0 Tool.
• Designed Sources to Targets mapping from primarily Flat files to Oracle using Informatica Power Center.
• Used transformations like Normalizer, Expression, Filter, Aggregator, Update Strategy, Lookup, Stored Procedure, Sequence Generator and Joiner extensively to create complex mappings and Mapplets.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Used different Cache properties, such as dynamic cache session property to perform the Update and Insert into the relational table simultaneously using Lookup transformation.
• Extensively worked in performance tuning of programs, ETL procedures and processes. Also used debugger to troubleshoot logical errors.
• Developed and invoked PL/SQL stored procedures and functions for data processes used in the Informatica mappings.
• Extensively dealt with the performance issues and made necessary coding changes for improving the system Performance.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.

Environment: Informatica Power Center 9.1, Windows Server 2003, Erwin4.0, Oracle, SQL server 2008, XML, Flat Files, Windows NT

Confidential, Franklin TN

Sr. Informatica Developer

Responsibilities:

• Involved in acquiring business & technical requirements, customizations aspects to meet the warehouse requirements.
• Extensively used connected/unconnected Lookups, Filter, Router, Aggregator, Expression, Update strategy and Rank Transformation
• Configured session properties and target options for better performance
• Developed mappings that incorporated logic needed to handle inserts and updates to the existing targets
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Created batches and sessions and optimizing the loading process with partitioning and caching.
• Involved in Writing Shell scripts to automate Pre-Session and Post-Sessions Processes.
• Performance Tuning of sources, targets, mappings and SQL queries in Transformation.
• 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.
• Involved in different Team review meetings.
• Involved in Unit Testing and tuned for better performance.
• Used SQL*Loader for loading bulk data from flat files.
• Worked extensively on SQL, PL/SQL, UNIX shell scripting.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the forms.
• Implemented CDC processes for the large tables.
• Involved in developing and modifying Business Objects reports using Business objects 6.5&XIR2.

Environment: Informatica 8.6(Power Connect, Power Mart, Power Center, Designer, Workflow Manager, Administrator and Repository Manager), Oracle 9i, PL/SQL, DB2, TOAD, Business Objects 6.5, UNIX

Confidential, Atlanta GA

Informatica/ETL Developer

Responsibilities:

• Developed the Dimensional modeling of the Data warehouse and used ERWIN tool to design the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Designed and created mappings using tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Involved in various phases of the project from design to development to integration and acceptance testing.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Debugged maps using Debugger and Transformation’s verbose data.
• Performance tuningof mappings, transformations and sessions to optimize session performance.
• Tuned performance of Informatica session for large data files by increasing block size, datacache size, sequence buffer length and target based commit interval.
• Created shared folders, local and global shortcuts to reuse metadata.
• Resolved the performance issues for huge volume of data and increased the performance significantly.
• Created various sessions, tasks like event raise and event wait.
• Scheduled and monitored workflows by use of Workflow Manager and Workflow Monitor.
• Defined parameters, variables and parameter files for flexible mappings/sessions.
• Prepared various kinds of documents like Test case document, mapping design document.
• Involved in the performance tuning of the mappings to tune the data load, and worked with DBAs to tune SQLs for better performance.
• Involved in the migration ofcode from development to QA environment and then to production.

Environment: Informatica Power Center 8.6, SQL, MS SQL, Windows NT, SQL Server, SQL * Loader, UNIX shell scripting, Toad

Confidential

Software Engineer

Responsibilities:

• Responsible for Design and Development of ETL and the reporting application.
• Communicated with the users to observe various business rules in implementing the data warehouse.
• Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
• Involved in the requirements definition and analysis in support of datawarehousing efforts.
• Involved in developing Data warehouse using StarSchemas.
• Analyze the source data structure and perform the Logicalmappings.
• Applied various Transformations on the source data to populate the data marts.
• Most of the transformations were used like the Sourcequalifier, Aggregators, Connected&Unconnectedlookups, Filters&SequenceGenerator.
• Developed mappings using Informatica Designer to load data from various source systems to target database.
• Responsible to tune ETL mappings to optimize load and query Performance.
• Wrote SQL Queries, Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain Business Rules.
• Used BusinessObjects for report creation.
• Developed UnixShell scripts.

Environment: Oracle 9i/8i, Informatica PowerCenter7.1 Business Objects5.X, Windows 2000, SQL, PL/SQL, TOAD, MS Excel.