Summary:

• IT: Over 7 years of IT experience in development and Implementation of various projects using ETL tools and client server applications. Worked extensively with clients like Telecom, banking and Retail.
• Informatica/ODI/Sunopsis: 4+ years of extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Data Modeling: 2 years of Data Modeling experience using Dimensional Data modeling, Star Join Schema modeling, Snow-Flake modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling

Technical Skills:

ETL tools

Oracle Data Integrator 11g (ODI), Informatica 4.0

Data Modeling

Oracle SQL Developer Data modeling, Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases

Oracle 11g/10g/9i/8i/8.0/7.0, MS SQL Server 2000/2005, Sybase IQ 15.2, DB2.

BI & OLAP Tools

Oracle Business Intelligence Enterprise Edition 11g(OBIEE), DRM 11g, Knowledge of Essbase and Planning

Programming

SQL, PL/SQL, HTML, XML.

Professional Summary

Client: Confidential, Feb 11 - Present
ODI/DRM Consultant

In September 2009, the Fiscal Assistant Secretary asked FRB Saint Louis to lead a project to define the high-level business requirements for a Treasury Future Forecasting System. The Office of Fiscal Projections (OFP), Financial Management Service (FMS), Federal Program Agency (FPA), FRB NY Open Market Desk (OMD), Federal Reserve Board of Governors (BOG) and FRB Saint Louis will employ the new Treasury Forecasting Program.

Responsibilities: -

• Served as a subject matter expert for the FRB STL development/implementation team for the Oracle Data Integrator (ODI), and DRM.
• Designed the detailed ETL architecture, including agents, scenarios, packages, data mapping, data extractions, transformations and validations. ETL design and implementation include stand-alone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools.
• Assist infrastructure personnel to define and document the technical architecture that includes ODI, DRM.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
• Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintaining account and entity hierarchies.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Assisted application development team in defining and documenting configuration management processes and procedures, which include maintaining ODI configurable artifacts in IBM Rational Team Concert (RTC).
• Develop operational process and procedures for monitoring ODI scenarios & agents for production troubleshooting and analysis.
• Develop the migration process required to migrate the ODI configuration through various test environments including the production and contingency environments.
• Provide accurate time and effort estimates for the completion of milestones for data loads and extracts.
• Loaded data files via SQL Loader and Bulk load techniques.
• Upgraded ODI Studio (Patch) from 11.1.1.3 to 11.1.1.5
• Assisted requirements verification test team, as requested, in isolating problems and working with implementation/integration team in resolving identified technical issues and problems.
• Mentor and transfer ODI, DRM technical knowledge and processes to other Client team and department personnel, as requested.

Environment: Oracle 11g, OBIEE 11g, ODI 11.1.1.5, RTC, Linux, Hyperion DRM 11.1.2.1, Essbase, Planning.

Client: Confidential, Jan 11 - Oct 11
ODI Consultant/Support

Diversified Maintenance Systems, LLC provides janitorial and facility maintenance services to retail, education, industry, managed services, transportation, commercial, and medical facilities. The company is headquartered in Tampa, Florida.

Responsibilities: -

• Created the workflows for the interfaces.
• Export/Import interfaces across different environments.
• Implemented error handling and error notification process.
• Extracted data from JD Edwards, SQL Server tables and loaded to staging and Target.
• Validated the JD Edwards data and applied business rules.
• Converted data types in JD Edwards and SQL Server and populated the target system.
• Scheduled batch jobs using ODI scheduler.
• Created versions for interfaces using Version control.
• Monitored sessions using Metadata Navigator.
• Supporting the existing application.

Environment: Oracle 11g, JD Edwards, OBIEE 10g, ODI 10.1.3.6, UNIX.

Client: Confidential, Aug 10 - Jan 11
ODI Consultant

Confidential, based in Victor, New York, is the leading producer of premium wines inthe world, with a portfolio that includes many well-known and highly regarded wine brands, complemented by spirits, imported beers and other select beverage alcohol products.

Responsibilities: -

• Analyze and design of ETL processes.
• Configured and setup ODI, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.
• Implemented CDC (Change Data Capture) to capture the changes on the source.
• Worked in the implementation of DW Incremental (pull and load)
• Interacted with business analysts and modelers for better understanding of individual subject areas and modified specifications to reflect accurate user requirements.
• Worked closely with team leads in process of standardizing job parameters, job flows, audit process and rollback strategies that hold major attention for the successful implementation of DW Incremental.
• Used the CFD (Common Format Designer) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Responsible for Metadata Administration and managed models and reverse engineering.
• Used different Knowledge Modules (KM) to load and transform the data from different data sources
• Automated the export/import of scenarios across the environments (Development, Test and production)
• Automated the process of generating scenarios for interfaces, packages.
• Coordinating with the higher management officials of their own as well as other departments, in order to report the progress and changes if any.
• Captured the ODI metadata and generated reports for audit.

Environment: Oracle 11g, ODI 10.1.3.6, Windows, UML, SVN, Tidal

Client: Confidential, Feb'10 - Aug10
ODI Consultant
Confidential, is one of the fastest growing telecom organizations. The project was a migration from BODI to ODI to develop the billing system for the organization.
Responsibilities: -

• Analysis and design of current ETL implementation.
• Worked on the newly developed internal billing system called IRB.
• As per the business requirement created source to target mappings using filters, joins and different SQL expressions.
• Worked with Data modeler on logical and physical model designs
• Worked closely with developers in process of standardizing job parameters, job flows, audit process and rollback strategies that hold major attention for the successful implementation of DW Incremental.
• Used Topology Manager module to manage the data describing the information systems physical and logical architecture.
• Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Responsible in configuring Data Servers used in the project using Topology Manager.
• Played a crucial role in assigning USER PROFILES to developers.
• Interacted with SME's to gather subject area specific requirements and developed Packages using the developed interfaces, procedures and variables.
• Used pl/sql functions to perform control logic.
• Debug the sessions by utilizing the logs of the sessions.
• Responsible for Metadata Administration and managed models and reverse engineering.
• Responsible for Topology Administration and performed actions through the topology manager module.
• Performance Tuning of ETL jobs by providing appropriate knowledge modules.
• Creating backups for the interface and also exporting and importing the interfaces from one project to another.
• Worked on error handling for complex interfaces.

Environment: Oracle 11g, ODI 10.1.3.5, Unix, BODI, OBIEE 10g

Client: Confidential, Apr'09 - Feb'10
ODI Consultant

Confidential, the nation's largest and most reliable wireless voice and 3G networks. Verizon Wireless is the largest wireless carrier in the U.S. with 89 million customers. Verizon Wireless network engineers work year-round to improve service, increase coverage and capacity of Verizon Wireless' national network, and add new services.

Confidential, Irving, TX Jul 2009 to Feb 2010

ODI Consultant

Description: The current Verizon focus on ETL Migration of Informatica to ODI. The main focus are in the following functional areas: Best View, CABS Aging, Force, FTTP, GTEDS, Hours, LI, LOB, Organization, Revenue and Expense, RW, TCM, Time, Utility, Volume.

Environment: Oracle Data Integrator 10.1.3.5, OBIEE 10.1.3, Answers and Dashboards, OBIEE Administrator, Informatica 4.0, Oracle 10g, SAP, PeopleSoft, Unix

Responsibilities: -

• Prepared the SOA Designed document for end-to-end ODI & OBIEE process.
• Prepared Canonical, Staging, and Aggregate table for SAP & PeopleSoft Source System.
• Created Designed Documents with Data Preparation, Data Procession and Data Completion Stage.
• Installed and configured ODI 10.1.3.5, Informatica 8.1.1, Oracle 10g & Oracle BIEE in the Window environment.
• Topology Manager is used to create database connection, physical and logical schema in order to achieve the whole infrastructure.
• ODI Designer is used for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Created ODI various interfaces for loading the data from SAP & PeopleSoft to Data mart.
• Used Knowledge Modules to achieve client requirements such as connecting to specific technology, extracting data from SAP & PeopleSoft Source System, transforming the data, checking it, integrating it, etc.
• Used Topology Manager to schedule scenario-using Agent.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.

Confidential, Irving, TX Jan 2009 to Jul 2009

ODI Developer

Description: The main objective of the project is to streamline all the systems of VSO to Oracle platform.
Extracting the data from different heterogeneous sources and streamlines the processes through a single user interface.

Responsibilities: -

• Analysis and design of ETL processes.
• Worked in the implementation of DW Incremental (pull and load) that constitutes different subject areas like (Payroll, Financial Transaction, Compensation Request, Agreement, Party, Contact Point) for different source systems.
• Interacted with business analysts and modelers for better understanding of individual subject areas and modified specifications to reflect accurate user needs.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Worked with Data modeler on logical and physical model designs
• Worked closely with team leads in process of standardizing job parameters, job flows, audit process and rollback strategies that hold major attention for the successful implementation of DW Incremental.
• Used Topology Manager module to manage the data describing the information systems physical and logical architecture.
• Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Configured and setup ODI, , master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.
• Responsible for Metadata Administration and managed models and reverse engineering.
• Responsible for Topology Administration and performed actions through the topology manager module.
• Used Knowledge Modules (KM) to load and transform the data from different data sources
• Used surrogate key assignment and change data capture

Environment: Oracle 10g R2, ODI 10.1.3.x, PeopleSoft, OBIEE 10.1.3.4 (BI Server, Presentation Services, BI Publisher, BI Scheduler, BI client)

Confidential, Irving, TX Apr 2009 to Dec 2009

ODI Developer

Description: The Verizon Services Infrastructure Integration (VSII) is a framework, which allows all the applications of Verizon Services Organizations to be accessed by a single user interface and have the ability to generate the financial reports through BAM. VSII is an integration of BPEL, ODI and BAM.

Responsibilities: -

• Implement Synchronous and Asynchronous Change Data Capture (CDC) techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it, etc.
• Used Operator to monitor sessions.
• Developing of complex Interfaces and packages using ODI tool.
• Analysis and designing of Interfaces pipelines in ODI.
• Used Topology Manager to schedule scenario-using Agent.
• Worked on Physical Layer, Business Layer and Presentation Layer (.RPD) to get new column as per BU.
• Creating or Modifying Answers and Dashboards as per user requirement.
• Created Views, wrote functions, Procedures, Packages.
• Testing data and comparing data with prototype data mart
• Developed BAM repository by creating Physical, Business and Mapping and Presentation layers using BAM Administration tool.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Used Oracle Meta link support for product issue.

Confidential, Jun'06-Mar'07
Informatica/Production Support/ODI Developer

Confidential, is an American, telecom company based in Schaumburg, Illinois. It is a manufacturer of wireless telephone handsets, and also designs and sells wireless network infrastructure equipment such as cellular transmission base stations and signal amplifiers.

Responsibilities: -

• Designed Mapping documents ETL and technical specifications.
• Analyzed the Source Data and designed the source system documentation.
• Demonstrated capabilities in developing an auditable data load process
• Creating mappings in Informatica and migrating to different environments.
• Development of detailed specifications for data management scripts.
• Designed Documents for performing unit testing and string testing of developed code.
• Used the ODI Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Used ODI for Reverse engineering to retrieve metadata from data storage and load it to the repository
• Developed mapping templates for Type1, Type2, Type3 and Facts, mapping documents, process flows and coordinated with the users to complete the tasks for various data marts.
• Used Knowledge Modules (KM) to load and transform the data from different data sources
• Used surrogate key assignment and change data capture
• Followed Star Schema to develop data marts.
• Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
• Worked with Metadata Definitions, Import and Export.
• Production support for the existing Legacy system

Environment: Informatica 4.0, Oracle Data Integrator 10.1.1.1, Web sphere, SQL, db2, UDB 7.0/8.0, Oracle 9.2, PL/SQL, Erwin 4.0, OBIEE, Rational Clear Quest.

Education:

• Bachelors In Engineering
• Masters in Software Engineering