SUMMARY:

• Over 12 years of Experience in analysis, design, development, testing and deployment of Informatica 9.6.1/9.0.1/8. x/7.x, Oracle, UNIX, Cognos.
• About 4 year of Dimensional Data Modeling experience using Erwin, Ralph Kimball Approach, Star/Snowflake Modeling, Data mart, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• 12 years of strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Source Systems Analysis and Reporting Analysis.
• 12 years’ experience in ETL design and development using various data sources Oracle, Teradata, DB2, SQL Server and flat - files, CCF files, XML, etc.
• Has performed variety of roles including Informatica Architect, Admin, Developer and ETL Analyst.
• Involved in functional and technical system analysis & Design, System Architectural design, Presentation and documentation.
• 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 databases.
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views.
• Interact with BO Analyst to assist him in Understanding the Source and Target System.
• Debugging the BO reporting problems and providing the solutions.
• Experience in working with BODI tool for data unification, data profiling, data auditing and data cleansing activities.
• Experience in the migration of mappings fromBODIto Informatica Confidential new ways to manage health insurance information.
• Expert-level mastery in designing and developing complex Informatica mappings to extract data from diverse sources including flat files (fixed width, delimited), XML, RDBMS tables, legacy system files and proficient in creating workflows/ worklets and Mappings/Mapplets.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Business Intelligence experience using Cognos and OBIEE and experienced in coordinating with cross-functional teams.
• Automation and scheduling of Informatica sessions and batches using Tivoli Scheduling tool.
• Experience reviewing Test plans, Test cases and Test case execution. Understanding business requirement documents and functional specs and then writing test cases using Quality Center. Also played an active role in User Acceptance Testing (UAT) and unit, system & integration testing.
• Has very good analytical, communication and inter-personnel skill.

TECHNICAL SKILLS:

Operating System: UNIX, Linux, Windows 98/NT/2000/XP/VISTA

Languages: PL/SQL, SQL, C, C++, XML and Korn shell scripting

RDBMS: Oracle 11g/10g/9i/8i, Teradata, DB2, SQL Server, BODI.

GUI: Toad, SQL Developer, Teradata SQL Assistant, Erwin

Scheduler: ESP Scheduler, Tivoli Scheduler.

ETL Tools: Informatica 9.6.1/8.x/7.x

Reporting Tools: Cognos 10.2/8.4, Cognos TM1, Business objects.

PROFESSIONAL EXPERIENCE:

Sr. Informatica Developer/Architect

Confidential, Pleasanton, CA

Responsibilities:

• Involved in the Design, Development, Testing phases of the Data warehouse and in Software Development Life Cycle (SDLC).
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Created various reports using business objects
• Modified the ETL code as per the changed business requirements.
• Used Oracle’s Explain Plan utility to tune the SQL queries for reducing the running time of the queries.
• Experience in the migration of mappings from toolBODIto Informatica Confidential new ways to manage health insurance information.
• Interact with BO Analyst to assist him in Understanding the Source and Target System.
• Debugging the BO reporting problems and providing the solutions.
• Created Informatica mappings for initial load and daily updates.
• Extensively used Transformations like SQL Transformation, connected/unconnected Lookup and Stored Procedure transformations, Java, Transaction Control, Union, Normalizer, Joiner, Update Strategy, and Application Source Qualifier etc.
• Created Stored Procedure transformations to drop and recreate the indexes, truncate the data, to disable and enable the constraints and to analyze the tables after loading the data.
• Created Dynamic files and Implemented Error handling strategy.
• Designed reusable transformations and shortcuts to share different mappings. Created mapping variable and parameters.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Implemented ETL Automation process for ETL code Integrity testing.
• Used aggregate calculations in source qualifier by SQL override.
• Experience in creating reports and universe by using Business Objects.
• Used various Mapplets and Worklets for repeated business logic.
• Root Cause Analysis and Fixing mapping problems.
• Created various Shell scripts for manipulating flat files and used in command task.
• Extensively involved in Unit testing, System testing and troubleshoot defects.

Environment: Informatica 9.6.1, 9.x, Oracle 11g, Business Objects, BODI 6.5 UNIX.

Sr.Informatica Developer

Confidential, NY

Responsibilities:

• Involved in development of Logical and Physical data models that capture current state/future state data elements and data flow using Erwin Modeling Tool.
• Followed Star schema to organize the data in the Data Mart.
• Extracted the data from different sources like Flat files, Oracle and transformed the data based on the business rules and loaded in to Oracle target database.
• Extensively used various types of transformations such as Expression, Connected Lookup (both static and dynamic), unconnected Lookup, Filter, Router, Normalizer, Update Strategy to transform the data.
• Implemented Slowly Changing dimensions Type 1, Type 2 methodology for accessing the full history of accounts and transaction information.
• Involved in hitting the various performance issues. Optimized the mappings, targets, sources and sessions wherever applicable to improve the performance.
• Used debugger to debug the mappings and to troubleshoot the information.
• Involved in production support during the vital stages of loading the Data Mart.
• Responsible for monitoring loads and tackled performance challenges whenever issues are observed during the production load.
• Experience in working with BODI tool for data unification, data profiling, data auditing and data cleansing activities.
• Developed mapplets and worklets.
• Designed reusable transformations and shortcuts to share different mappings
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• Identifying Performance bottlenecks and fine-tuning ETL mappings and workflows to improve performance.
• Day-to-Day Production support.
• Recovering failed jobs.
• Tuning of Informatica mappings.
• Created various reports using business objects

Environment: Informatica 8.6.1, Oracle 10g, IDQ, Business Objects, BODI, Windows, HP, UNIX.

ETL Designer

Confidential

Responsibilities:

• Involved in the Design, Development, Testing, Analysis, Requirements gathering, function/technical specification, deploying.
• Responsible for defining, documenting and publishing Functional Specifications. Non Functional Specifications and BRD-Business Requirements Documents.
• Involved in Design and Data Modeling using the Star schema.
• Logical & Physical Database Layout Design. Created Informatica mappings for initial load and daily updates.
• Modified mappings as per the changed business requirements.
• Extensively used various types of transformations such as Expression, Connected Lookup (both static and dynamic), unconnected Lookup, Filter, Router, Normalizer, Update Strategy to transform the data.
• Extracted the data from different sources like Flat files, XML, Oracle and transformed the data based on the business rules and loaded in to target database.
• Extensively worked with Oracle E-Business Suite (OEBS), FAH, AP, GL modules.
• Implemented Balance and Control and Restart and recovery.
• Created Dynamic parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Used debugger to debug the mappings and to troubleshoot the information.
• Responsible for monitoring loads and tackled performance challenges whenever issues are observed during the production load.
• Created various reports using business objects
• Identifying and tracking slowly changing dimensions and implemented in complex Mappings.
• Designed reusable transformations and shortcuts to share different mappings.
• Interact with BO Analyst to assist him in Understanding the Source and Target System.
• Debugging the BO reporting problems and providing the solutions.
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• Used ESP Tool to schedule shell scripts and Informatica Jobs.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for determining the Performance bottlenecks and fixing the bottlenecks.
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Involved in troubleshooting the load failure cases, including database problems.
• Involved in Production Deployment and Support.

Environment: Informatica 8.6.1, Oracle ERP, MS SQL Server, Business Objects XIR2, Teradata V12, DB2, HP UNIX.

ETL Analyst

Confidential

Responsibilities:

• Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
• Involved in Design and Data Modeling using the Star schema.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Logical & Physical Database Layout Design.
• Involved in Developing ETL and Aggregate Strategy
• Worked with slowly changing dimension Type1, Type2, and Type3
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Involved in Performance tuning activity in different levels.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Used parameters and variables for Incremental load/Full load of data in target table
• Identifying and tracking slowly changing dimensions and implemented in complex Mappings.
• Developing, scheduling and monitoring sessions.
• Created Informatica mappings for initial load and daily updates.
• Involved in fixing invalid mappings, testing of store procedures and functions, unit and integration testing of Informatica Mappings, Sessions, Workflows and the target data.
• Extensively involved in Unit testing, System testing and troubleshoot defects.
• Identifying Performance bottlenecks and fine-tuning ETL mappings and workflows to improve performance and used Data Quality.
• Involved in writing Shell Scripting for ETL JOBS to run.
• Production /Maintenance of the Data mart.
• Involved in Development of Repository using OBIEE. Expertise in Creating Physical/Business/Presentation layer of the repository.
• Interact with OBIEE Analyst to assist him in Understanding the Source and Target System.

Environment: Informatica 8.1/7.4, Oracle 10g, OBIEE 10.1.3.4.1, Windows, HP UNIX, TOAD.

ETL Developer

Confidential

Responsibilities:

• Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
• Involved in the Design, Development, Testing phases of Data warehouse
• Logical & Physical Database Layout Design using ERwin.
• Involved in Design and Data Modeling using Star schema.
• Created Informatica mappings for initial load and daily updates.
• Involved in fixing invalid mappings, testing of store procedures and functions, unit and integration testing of Informatica Mappings, Sessions, Workflows and the target data.
• Developed several mappings to load data from multiple sources to data warehouse.
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL
• Performed Data conversions.
• Extensively used mapping parameters, mapping variables and parameter files.
• Generated Reports using Metadata Reporter

Environment: Informatica 5.1, Cognos Report Net, Mainframes, Oracle, PL/SQL, Erwin, TOAD 6.X