SUMMARY:

• More than 14+ years of experience in Application Development and System Design on various platforms of which, the last 10+ years has been on Data warehousing using ETL tools such as Informatica and Datastage.
• Well versed in all vital phases of the Software Development Life Cycle, including preparing development strategies, analysis, design, development, program specifications, coding, test plans & testing, coordinating the implementation of the application software with the customer support groups.
• Handled large volumes of data and loaded 100 million for records.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• About 8+ years of experience in architecture, analysis, design, development and implementation of Data Warehousing using Informatica 9.0,1/8.5.6 and IBM Datastage 7.5.
• Extensively worked in Informatica Web Service using XML Generator, XML Parser.
• Well versed with various Informatica transformations and implemented number of complex mappings.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Work lets and performance tuning.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, Oracle and SQL Server.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong experience on Workflow Manager Tools - Task Developer, Workflow & Work lets Designer.
• Experience in integration of various data sources like Oracle and Flat files into staging area.
• Expertise in design and development of Decision Support Systems (DSS).
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables.
• Good in configuration management using PVCS and VSS.
• Worked with views, materialized views, UTIL File and SQL Loader.
• Worked on Designer, Director, Manager, and Administrator of Datastage 7.5. Well versed in various stages of Datastage, worked with Parallel and Server jobs.
• Worked in tools such as Designer, Manager, Director and Administrator of IBM Datastage.
• Worked with integrated financial accounting software BALANCE (FINANCIAL ACCOUNTING, SALES, PURCHASE, and MATERIAL MANAGEMENT ETC).
• Knowledge in Master Data management
• Responsible for some of the DBA activities

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.5.1/8.6/8.1, 7.1, 7.3, IBM Datastage Enterprise Edition 7.5

OLAP/DSS Tools: COGNOS 7.3 (Impromptu 7.3 Power Play 7.3, Visualiser7.3/COGNOS 8.0, Business

Databases: Oracle 11G/10G/8i/9i, SQL, PL/SQL, SQL Server 6.5/7.0, Essbase, DB2

GUI: PowerBuilder, Appworx scheduler, Power exchange 9.6.1

Case Tools/Others: LOGIC WORKS - ER/WIN - MS Project Autosys

Languages: SQL, PL/SQL, C, UNIX

DB Tools: TOAD, SQL* Plus, SQL* Loader

PROFESSIONAL EXPERIENCE:

Confidential

Data Integration Lead Developer

Responsibilities:

• Co-ordination with BA to understand the scope and Mapping docs.
• Involved in the in the ETL Mapping development
• Responsible for Migration of the etls till production.
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines.
• Developed the mappings, sessions and workflows
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, normalize and sequence generEator
• Tuning of ETLs.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• Worked with SQL and PL/SQL
• Loaded data for staging tables for Master data Management.
• Responsible for Unit Testing & QA support and Prod Migration
• Involved in data modeling for the application and created ER diagram using Erwin.
• Experience in delivering the business intelligence solutions.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and functions.
• Implemented database standards and naming convention for the database objects.
• Responsible for Backing up of tables.

Environment: Informatica PowerCenter 9.6.1 Oracle 11G, UNIX, SQL, Power exchange 9.6.1, DB2

Confidential, Detroit, MI

Senior ETL Developer/Lead

Responsibilities:

• ETL development using Informatica PowerCenter.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• Worked with informatica designer, workflow manager etc.
• Developed the mappings, sessions and workflows
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, normalize and sequence generator
• Tuning of ETLs.
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines
• Worked with SQL and PL/SQL
• Responsible for Unit Testing & QA support and Prod Migration
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and functions.
• Implemented database standards and naming convention for the database objects.
• Responsible for Backing up of tables.
• Experience in delivering the business intelligence solutions

Environment: Informatica PowerCenter 9.1.0 SQL server 2008 R2, SQL, PL/SQL, db2

Confidential, Chicago, IL

Senior ETL developer/Lead

Responsibilities:

• ETL development using Informatica PowerCenter.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• Worked with Informatica designer, workflow manager etc.
• Developed the mappings, sessions and workflows and tuned ETLs
• Worked in networking environment, databases, systems and web operations
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalize, and sequence generator
• Worked with SQL and PL/SQL.
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines.
• Responsible or Unit Testing and delivery
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and functions.
• Implemented database standards and naming convention for the database objects.
• Experience in delivering the business intelligence solutions.
• Responsible for Backing up of tables.

Environment: Informatica PowerCenter 9.1.0 SQL Server 2008 R2, SQL, PL/SQL, db2

Confidential, Madison, WI

ETL Lead

Responsibilities:

• Co-ordination with client side IT Team and business users
• Scope identification/requirement gathering
• Lead the team
• Worked in UNIX environment, Networked DB and in Web environment
• Bo report /Universe modification.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• ETL development using Informatica PowerCenter
• Worked with informatica designer, workflow manager etc.
• Developed the mappings, sessions and workflows and tuned ETLs
• Worked with XML/XSLT/Parser/generator
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalize, and sequence generator
• Worked with SQL and PL/SQL.
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines.
• Co-ordination for unit testing and integration
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and functions.
• Implemented database standards and naming convention for the database objects.
• Experience in delivering the business intelligence solutions.
• Responsible for Backing up of tables.

Environment: Informatica PowerCenter 9.0.1/ 8.6, Business object XIR2 Oracle 10G/11G SQL, PL/SQL DB2

Confidential, San Jose, CA

ETL Lead

Responsibilities:

• Coordination with client side IT Team
• Involved in requirement gathering
• Worked in ETL development/coordination
• Worked with Informatica designer, workflow manager etc.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• Report enhancement in Business Object
• Coordination with offshore in Monthly releases .
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines.
• Developed the mappings, sessions and workflows
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalize, and sequence generator
• Worked with Oracle SQL and PL /SQL
• Tuning of ETL .
• Experience in delivering the business intelligence solutions.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and functions.
• Implemented database standards and naming convention for the database objects.
• Responsible for Backing up of tables.

Environment: Informatica PowerCenter 8.6, Business object XIR2 Oracle 10G SQL, PL/SQL, DB2

Confidential, Mclean, VA

ETL Analyst

Responsibilities:

• Created workflow and provided them as Web Service
• Used XML Generator and Parser to develop the web service mapping
• Configured workflows using Web Service Hub
• Development activities and tuning the jobs
• Adapted dimensional modeling techniques
• Worked in XML data loading using Parser and XML generator.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• Developed the mappings, sessions and workflows.
• Strong working experience in Data warehouse DBA.
• Worked with informatica designer, workflow manager etc.
• Worked with views and Index
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines.
• Worked extensively on different types of transformations like Source qualifier, expression, aggregator, router, filter, update strategy, lookup, sorter, normalize, and sequence generator
• Created PL/SQL procedures, function and packages
• Logical modeling.
• Experience in delivering the business intelligence solutions.
• Involved in execution of unit test plans and prepare the unit logs
• Involved in migrating the mappings, sessions, workflows from Test environment to Production environment
• Involved in QA testing

Environment: Informatica PowerCenter 8.6/8.1/7.3, Hyperion, Essbase Oracle 9i, PeopleSoft/ObIEE, PL/SQL UNIX, Autosys

Confidential, Warren, NJ

ETL Onsite Project Lead

Responsibilities:

• Coordination with client side IT Team and business users, including require gathering.
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines.
• Creating the technical design specifications based on client functional specs
• Development activities.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• Strong experience in Development of DBA.
• Strong working experience in Data warehouse DBA.
• Modeling of dashboard tables.
• Experience in delivering the business intelligence solutions.
• Worked with Informatica designer, workflow manager etc.
• Worked with SQL, PL/SQL
• Coordination with offshore in development activities

Environment: Informatica PowerCenter 8.1/7.3, Hyperion, oracle 9i, DB2, MS project, UNIX, Erwin, SQL, PeopleSoft, PL/SQL

Confidential, Auburn Hills, MI

ETL Analyst/Onsite Coordinator

Responsibilities:

• Involved in design review activities
• Monitored/ensuring of daily load (with the help of team)
• Coordination with offshore team. Worked in all tools of Data stage such as designer, director, manager and administrator.
• Worked on Informatica Power Center 9.5.1 8.6/8.1 7.1/7.3. OLTP, OLAP tools such as Cognos, Business Object XIR2, Oracle, and DB2 on Windows/UNIX.
• Strong experience in Oracle DBA administrating databases on Oracle 11g RAC on Unix/Linux machines.
• Extensively worked with Facts and Dimension tables to produce source - target mappings based upon business specifications.
• Creation of shell scripts.
• Strong experience in Development of DBA.
• Strong working experience in Data warehouse DBA.
• Worked on Oracle PL/SQL procedures, functions and logical modeling
• Created views and materialize views.
• Experience in delivering the business intelligence solutions.
• Worked in COGNOS 7.3, Impromptu & Power play reports. Developed new reports, Power Play Cubes and Catalog design and ETL code migration

Environment: IBM Datastage 7.5 Server & Parallel DB2, COGNOS Impromptu, Power Play 7.3 and UNIX COGNOS 8.0, Erwin