Summary:

• Around 10 years of IT experience in the Design, Development, Implementation and Testing of Enterprise Data warehouse and Data mart applications for Sales, Logistics, Costumer support, Finance, Pharma, Manufacturing using Oracle Data Integrator ODI and Informatica Power Center.
• Extensive experience in migration of data from legacy systems and also involved in Data Warehouse Development and Data Mart Life Cycle development.
• Strong experience in ETL Extraction, Transformation and Loading process using different tools like Oracle Data Integrator 10.1.3.5 , Informatica Power Center 8.5/8.1.1/7.1 .
• Involved in Data profiling, Data cleansing and legacy Data translation using Oracle AMB and IDQ.
• Extensively used ODI Oracle Data Integrator to extract data from different sources using Oracle Data Integrator tools - Security Manger, Topology Manager, Designer and Operator.
• Performed ETL process to load data from different sources into data warehouse using Oracle Data Integrator ODI and Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor .
• Experience in integration of various data sources databases like Oracle, SQL Server, Flat Files, Access, Hyperion, Sybase and DB2 into staging area. And also involved in migration of data from Informix 2.4, Teradata 7.1 to oracle database.
• Extracted client information data and history from JD Ewards, SQL server, Oracle E-Biz ERP applications to OBIEE which is OLAP tool.
• Designed and developed complex mappings and varied transformation logics using transformations like connected and unconnected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more. Experience in execution of Sessions, workflows and worklets.
• Strong Oracle skills that include build/maintain tables and indexes, PL/SQL scripts, Stored Procedures, Triggers, Packages, Functions and performance tuning of SQL queries and Good knowledge in XML, HTML.
• Experience in Performance tuning, Backup/Recovery of Informatica Repositories. Good knowledge in latest Domain, Node and services concepts in Informatica 8.1.1. And experience in creating web service providers and consumers in Informatica 8.1.1.
• Worked in product based company and involved in installation and maintaining of Oracle Data Integrator ODI and PowerCenter 8.5 on different platforms like Solaris, Linux, AIX and upgraded from different versions latest versions.
• Possess excellent communication, interpersonal skills and ability to work in a team as well as individually.

Professional Experience

Confidential

Sr.ODI Consultant.

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
• Involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources of Oracle 11g to DWH
• Migrated and converted the flat source files from multiple sources to ORACLE staging tables.
• Using ODI Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH.
• Built transformations, configured servers and established connections to various sources and targets
• Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements
• Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
• Involved in troubleshooting of ODI objects, Optimized Query Performance, improved Workflow Performance and Reliability bases on statistics from logs
• Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
• Handled error through exception handling and configured the event-based scenarios to send the alert emails.
• Involved in writing complex SQL's and modified database structures including tables, triggers and user-defined functions to support application enhancements.
• Used I-series, SQL developer for Unit testing of data loaded after execution of interfaces.
• Understanding and discussing the new requirements from Business analysts through regular interaction.
• Involved in Installation, configuration and administration of development, execution repositories in ODI.

Environment: Oracle Data Integrator 10.1.3.5, Oracle11i, Jd Edwards, DB2, I-series, sql developer, Windows NT.

Confidential

Sr.ODI Consultant.

Responsibilities:

• Involved in gathering business requirements, translating them into technical specifications and in writing mapping documents.
• Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
• Created specification documentation for ODI mappings based on extraction rules.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the target database.
• Created ODI Interfaces using different transformation logics and migrated data from legacy to oracle data base.
• Utilized different knowledge modules as per mapping rules to load data from legacy systems
• Extensively used ODI designer to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• Extensively created procedures and variables to execute pre and post interfaces in a package.
• Used ODI operator to debugger after execution of interface.
• Strong data migration knowledge in Oracle E-Business Suite 12.1.1 modules like AR, AP, INV, CSI, QP etc.
• Created packages in designer and executed packages, interfaces, procedures, variables.
• Involved in Installation, configuration and administration of development, execution repositories in ODI.

Environment: Oracle Data Integrator 10.1.3.5, Oracle11i, Oracle E-Business Suite 12.1.1, DB2, I-series, sql developer, Windows NT.

Confidential

ODI Developer.

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
• Involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources of Oracle 11g to DWH
• Extensively used ODI designer to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• Built transformations, configured servers and established connections to various sources and targets.
• Used ODI operator to debugger after execution of interface.
• Involved in writing complex SQL's and modified database structures including tables, triggers and user-defined functions to support application enhancements.
• Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
• Handled error through exception handling and configured the event-based scenarios to send the alert emails.

Environment: Oracle Data Integrator 10.1.3.4, DB2, SQL Server 2003, Toad, Erwin 3.5, Oracle SOA Suite.

Confidential

ODI Developer.

Responsibilities:

• Involved in gathering business requirements, translating them into technical specifications and in writing mapping documents.
• Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
• Created specification documentation for ODI mappings based on extraction rules.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the target database.
• Created ODI Interfaces using different transformation logics and migrated data from legacy to oracle data base.
• Utilized different knowledge modules as per mapping rules to load data from legacy systems
• Extensively used ODI designer to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• Extensively created procedures and variables to execute pre and post interfaces in a package.
• Used ODI operator to debugger after execution of interface
• Created packages in designer and executed packages, interfaces, procedures, variables.
• Involved in writing complex SQL's and modified database structures including tables, triggers and user-defined functions to support application enhancements.
• Used I-series, SQL developer for Unit testing of data loaded after execution of interfaces.
• Understanding and discussing the new requirements from functional team through regular interaction.

Environment: Oracle Data Integrator 10.1.3.4, Oracle11i, DB2, I-series, sql developer, Windows NT.

Confidential

Informatica ETL developer.

Responsibilities:

• Used Informatica Power Center for Extraction, Transformation and Loading to Target.
• Extracted client information data and history from JD Ewards, SQL server,DB2 transformed and loaded into oracle database.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Developer.
• Used various Transformations like Expression, Filter, Joiner and Lookups for better data scrubbing and to cleansing and consistent data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, Look up.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Reusable Transformations, Mapplets and Mappings using Designer.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Worked closely with DBA and System testing teams in designing and testing of the application.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Created specification documentation for each ETL process based on client requirements.

Environment: Informatica 8.1.1, Oracle10g, DB2, SQL Server, PL/SQL, Flat files, Windows NT.

Confidential

Informatica ETL Developer.

Responsibilities:

• Extensively used All Fusion-Erwin for Logical / Physical data modeling and Dimensional data modeling.
• Configured different services like SAP BW connector and Siebel application connector and web services hub.
• Created Web service provider and consumer mappings using different transformation logics, which helps to technical support teams to retrieve data from data ware house.
• Utilized a lookup and update strategy to lookup values from different tables and to update slowly changing dimensions.
• Developed reusable mapplets and Transformations. Extracted, transformed data from fixed width and delimited flat files and loaded the data into staging tables using Informatica.
• Extensively used Informatica designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations.
• Worked on various transformations such as Aggregator, update strategy, Router, Rank, Sorter, Source Qualifier, Filter, Expression, Lookup, Stored procedure, Sequence generator etc.
• Extensively created stored procedure transformation to execute pre and post session SQL statements.
• Used Informatica debugger for Unit Testing of business logics of mappings, normal database sessions as well as real time sessions.
• Involved in performance tuning by optimizing the sources, Targets, Mappings and Sessions.
• Created Workflows in the workflow designer and Executed Tasks such as Sessions, Commands etc using Informatica workflow manager 8.1.1.
• Involved actively in the production support: monitoring for optimal performance and responsible for taking necessary timely corrections whenever any production issue is notified.

Environment: Informatica 8.1.1,Informatica Data Analyzer, Oracle 10g, Flat files, Informix 2.4, DB2 8.1, SQL Server 2005, PL/SQL, shell script, Perl 5.1, TOAD 7.3, Windows NT Server, Erwin 4.1, AIX UNIX, Linux.

Confidential

ETL Developer

Responsibilities:

• Conducted client system surveys, analyzed business requirements and processes. Assisted in Creating Logical and Physical Data Modeling by using Erwin data modeling tool.
• Translated user requirements to configure and implement the clarify Data mart.
• Creating the Design and Technical specifications for the ETL process of the project.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Designed and developed Informatica Mappings and sessions based on Business rules.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Written UNIX shell scripts for scheduling the sessions and workflows.
• Creating the catalogs and Folders and Prompts and analyzing the joins.
• Extensively used Cognos for Cube building and report generation. Scheduling and monitoring the Cubes.
• Created Reusable Transformations, Mapplets and Mappings using Designer.
• Used the Workflow Manager, to create the session, workflows. Monitoring the cubes and workflows.

Environment: Informatica Power Center 6.1, ORACLE 9i, UNIX, Windows 2000, Erwin 3.5, SQL PLUS, MS Access, SQL, PL/SQL, Congos7.

Confidential

ETL Developer.

Responsibilities:

• Created Views for the Dimensions and Fact Tables.
• Used Informatica Power Center for Extraction, Transformation and Loading to Target.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Developer.
• Used various Transformations like Expression, Filter, Joiner and Lookups for better data scrubbing and to cleansing and consistent data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, Look up.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Reusable Transformations, Mapplets and Mappings using Designer.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Development of Stored Procedures, Functions and packages in oracle for various modules.
• Worked closely with Data modelers in creating Entity Relationship diagrams using Erwin.
• Worked closely with DBA and System testing teams in designing and testing of the application.
• Understanding and discussing the new requirements from user through regular interaction.

Environment: Informatica Power Center 6.1, Windows 2003 Server, Oracle 9i, SQL, PL/SQL, Erwin, Java, Toad.

Confidential

Oracle Developer.

Responsibilities:

• Understanding existing business model and customer requirements.
• Preparation of Detailed Functional Specifications and Detailed Implementation Specification.
• Enforcing Business Rules using Database Triggers. Development of Pl/SQL Procedures, Functions and Packages.
• Development of various master data entry screens using Developer 2000 Forms 6i .
• Development of various reports using Report Builder Tabular Reports, Group Reports, and Matrix Reports.
• Development of backend process in pl/sql for data retrieval.
• Worked with the Data processing team in creating the database tables and objects.

Environment: Oracle 8i SQL Plus PL/SQL , Forms 6i, Reports 6i.