SUMMARY:

• 7+ years of experience in Analysis, Design, Development, Administration, Testing, Support and user training of Data Warehousing and Business Intelligence applications using ODI,OBIEE and Oracle Applications.
• Expertise in Installing and Configuring Oracle Data Integrator (ODI) software tool in a three - tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning and developing ETL.
• Extensively used Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).
• Well-versed in Data Transformations and Data Migrations using Oracle Data Integrator 10g/11g from heterogeneous sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files to perform ETL operations.
• Proficient in working with ODI features like Topology, Security Manager, Designer and Operator.
• Expertise in ODI setup, Master Repository, Work Repository, Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked on ODI knowledge modules (LKM, IKM, CKM, RKM and JKM).
• Thorough understanding of Change Data Capture (CDC), Slowly Changing Dimensions (SCD) and implementing them using ODI.
• Proficient in developing complex ODI interfaces, yellow interfaces, packages and scenarios by using global/local variables.
• Experience in setting up Dynamic, System and Non-System Variables in ODI.
• Expertise in Designing and developing Star, Snow flake and multi-dimensional Schemas.
• Experience in DAC with Importing Subject Areas, building Execution plans, registering the Informatica Work flows, Metadata management and Scheduling.
• Experience in Installation and configuration of Informatica Power Center, creating Mappings, Mapplets, Sessions and Workflows.
• Knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, Reporting processes in developing Data marts and Enterprise Data Warehouse.
• Expertise in installation, configuration, troubleshooting, performance tuning and administration of OBIEE.
• Expertise in OBIEE Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series and Cache Management.
• Worked on HR Analytics, Financial Analytics, Sales & Marketing Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics.
• Experience in BI Publisher (XML Publisher) and Oracle Business Intelligence Discoverer.
• Very strong experience in writing SQL queries/reports, PL/SQL Stored Procedures, Functions, Packages, triggers for Oracle 11g/10g and tuning of SQL queries/scripts.

TECHNICAL SKILLS:

BI TOOLS: OBIEE 11g/10g, BI Publisher, Oracle Business Intelligence Applications (OBIA)/BI Apps: 11g/7.9.6.X

ETL TOOLS: ODI 11g/12cInformatica Power Center 9.x/8.x.

DATABASES: Oracle 11g/10g, Teradata, IBM DB2.

OPERATING SYSTEMS: Windows, Unix/Linux.

WEB TECHNOLOGIES: HTML, XML.

LANGUAGES: SQL, PL/SQL, C, C++

PROFESSIONAL EXPERIENCE:

Confidential, Seattle WA

OBIEE/ODI Consultant

Responsibilities:

• Implemented BIAPPS for Financial Applications according to client requirements which can help them to analyze the business
• Participated in requirements analysis, by helping to capture, document and prioritize the custom business and technical needs
• Developed prototypes for demonstration to business users
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Created the normalized logical and the physical model with transactional facts, aggregated fact tables and the dimensions.
• Developed ODI interfaces for loading the dimensions and facts.
• Developed ODI variables and Packages for creating monthly snapshots.
• Developed ODI Procedures and Packages an implemented the data integrity rules for the load.
• Created ODI Agent and configured it for automating the jobs through the ODI Studio and Weblog Application Server.
• Developed new ODI Package, interfaces, procedures and variables for Policy Monthly Snapshot.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP system.
• Set up the Topology including physical architecture, logical architecture and context.
• Implemented Change Data Capture (CDC) feature of ODI to refresh the data in Enterprise Data Warehouse (EDW).
• Monitored Incremental and Full load of Data through ODI studio and console
• Developed the OBIEE Metadata repository (.rpd) with the necessary logic that involved creating Physical Layer with additional Facts and Dimensions created hierarchies, variables, and created new presentation catalogs in Presentation Layer using Oracle BI Administration tool.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Utilized Variables and Initialization blocks in the Repository.
• Developed Dashboards / Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), created new Interactive Dashboards with drill down capabilities, charts, tabular and gauges.
• Migrated Analytics RPD and Webcat from one environment to another.
• Upgraded BI publisher reports from 10g to 11g
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level
• Implemented Row level security in repository using filters and object level security and assigned privileges according to the business groups

Environment: ODI11g, BI Apps 11.1.1.8.1 , OBIEE 11.1.1.7, Oracle 11g, Oracle EBS R12, Windows 7, UNIX/Linux, SQL Developer

Confidential, New Jersey

OBIEE/ODIDeveloper

Responsibilities:

• Installed and configured BI Apps financial, Sales & Marketing Analytics, Procurement& Spend analytics.
• Used BIAPPS configuration manager (BIACM) and Functional Setup Manager (FSM) to configure and manage BI Apps offerings.
• Managed and monitored OBIA load plans using ODI Studio and console.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and production support.
• Created the custom fact data stores and tasks for Oracle Business Analytics Warehouse.
• Customized Out of the Box (OOTB) ODI interfaces to add additional fields to existing Fact and Dimension tables.
• Built new ODI interfaces, variables, procedure, packages, and scenarios.
• Customized OBIA RPD for easy drills between procurement spend and financial analytics subject areas.
• Set up the Topology including physical architecture, logical architecture and context.
• Worked closely with the Project Manager, Data Architect, Users. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Created and customized the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Repository using Administration Tool.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE.
• Created dimension hierarchies, aggregates and keys in the BMM layer.
• Created ragged hierarchies for the organizational structure to enable the drill down feature.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Restricted query access to specific objects, including rows and columns, or time periods.
• Implemented Data Level and Object Level Security using External Table Authentication, as well as Presentation Services.
• Implemented single sign on (SSO) of OBIEE with EBS.
• Extensive experience working on MUD Environment.
• Documentation of every step involved in the process, making it easy for the client.

Environment: Oracle Data Integrator 11g, BI Apps11.1.1.8, OBIEE 11.1.1.7, Oracle 11g, MS SQL Server, Windows 7, UNIX/Linux, Shell scripting, TOAD

Confidential, Boston MA

OBIEE/ODI Consultant

Responsibilities:

• Implemented BIAPPS for Financial, Supply chain and order management, HRAnalytics Applications according to client requirements which can help them to analyze the business.
• Created Mock ups, Business Requirements Documents, test case documents with business user inputs.
• Creation of Dimensions, Facts for the Star schema design.
• Requirements Gathering, Business Analysis, and End User meetings
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Developed Mappings which loads the data in to Teradata tables with SAP definitions as Sources
• Did reverse engineering for the data sources and targets.
• Designed the ETL flow existing system to reuse the existing logic of to meet tight schedules.
• Written many database triggers for automatic updating the tables and views.
• Translating business requirements into technical specifications to build
• Responsible for developing, support and maintenance of ETL processes using ODI
• Responsible for developing PL/SQL Procedures/Functions and called from ODI
• Responsible for handling CR's (Change Requests) and enhancements for existing application following change management process
• Assisting DBA with installation and configuration of Oracle Data Integrator (ODI)
• Assisted Client testing team with test data preparation for all releases
• Participated in code reviews. Did code promotions from DEV to TEST, staging and production environment using ODI.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Helped QA team in writing the appropriate test scenarios.
• Experience in Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).
• Created security settings in OBIEE Administration Tool and Set up groups, access privileges, query privileges and also managed security for groups in analytics.
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher and published the reports using bursting technique.
• Developed test cases, Performed Unit Testing, Integration Testingfor Repository and Web Catalogs.
• Migrated RPD from development to production environment using patch merge technique.

Environment: ODI 11g, OBIEE 11.1.1.7, BI Apps 11.1.1.8,PL/SQL, SQL, Toad, Flat files, Oracle 11g/10g, MS SQL server, UNIX/Linux, Shell scripting, Windows 7

Confidential, Cleveland OH

OBIEE/ETL Consultant

Responsibilities:

• Implementedfinancial, supply chain and order management Analytics Applications according to client requirements.
• Used Metadata Design Principles to design Repository based on business requirements and followed best practices.
• Localized Oracle BI for business users to support globalization for deployment (Development/QA/Production)
• Set up LDAP Authentication, used Row-Wise Initialization Blocks, and set up Web Groups.
• Set up Analytics Multi-User Development environment for developers.
• Installed and Deployed Oracle BI on separate Multi Servers.
• Built the Physical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Configured Facts, Dimensions and Hierarchies.
• Implemented Aggregate Tables for better analytics performance.
• Implemented reporting cache to faster response time.
• Assisted in creating Reusable and Non-Reusable Mappings and Mapplets using Filters, Aggregator, Lookups, Expression Aggregator, Sequence Generator, Sorter, Joiner and Update Strategy Transformation.
• Involved in developing tasks, created sessions and worklets in Workflow Designer, ran and monitored sessions using Informatica Server Manager
• Performance and fine tuning of PL/SQL stored procedures.

Environment: OBIEE 1Og, BI Apps 7.9.6.2, Informatica 8.6.1, BI Publisher, Oracle EBS R12, DAC 11g, TOAD, UNIX, Windows XP.

Confidential, Cleveland OH

OBIEE/ETL Consultant

Responsibilities:

• Involved in GAP Analysis and requirements gathering of the various work streams by meeting with the Business Analyst and Business Users and base lining the details.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Worked on configuring the metadata along with their own Data Warehouse tables.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Used different filter conditions both in the repository and in front end based on business rules provided by the business users.
• Extensive experience in Production Support. Involved in all the Migration process.
• Worked on creating repository and session variables such as static and dynamic along with initialization blocks.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Worked with DBAs to create materialized views and aggregates to improve performance.
• Created the prompts of OBIEE as to navigate in a Map.
• Created reports which are used to analyze the Performance and Response of the Campaigns held by the Marketing Team.
• Created an init.block to retrieve allowable values.
• Involved in setting up the environments for Development, Unit Testing, System Testing and Production for the developers and testing teams.
• Interacted with the ETL Team to modify the existing Data warehouse (OLAP) tables to enhance report performance.
• Involved in creating Complex mappings using Unconnected Lookup.
• Performed unit testing and system testing of all components of OBIEE Analytics.
• Started Installing and working with OBIEE 11g for the coming up year projects.
• Coordinated with offshore team and handled the situations very well.

Environment: OBIEE 10.1.3.4.1 , BI Apps 7.9.6, Informatica 8.1, DAC 10.1.3.4, Oracle10g, TOAD, UNIX, Windows XP.

Confidential, Irvine CA

OBIEE/ETL Consultant

Responsibilities:

• Developed business models conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Created custom mappings to accommodate customized fields. Utilized Intelligent Dashboards for reporting requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Support existing systems, ensuring issues are recorded, address and resolve in a timely manner.
• Worked with end-users to collect, analyze and document Business, Technical and Functional system requirements.
• Worked on repository and session variables.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Designed, developed, tested and prepared detailed specifications of new and existing requirements in Oracle Financials.
• Worked on Security management for users, groups and web-groups using the various authentication systems such as LDAP, using Session Variable features. .
• Created Analytics Reports including Charts, Pivot tables and Compound layouts using Answers.
• Implemented ETL process to load data into target Oracle tables.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance
• Customized prompts appropriately to avoid excessive data showing up in Reports and Graphs.
• Configured Intelligence dashboards by adding embedded content such as links/images, HTML objects and folders.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created reports using BI Publisher on MS Word.
• Successfully implemented OBIEE delivers/Created Proactive agents (iBots) and configured Interactive dashboards to alert the Business/Field users as per the requirements.

Environment: OBIEE 10G, Informatica 8.1, BI Apps 7.9.6, Oracle Applications 11.5.10.2, Toad, Windows 2003 Server, DAC, Unix, Oracle SQL Loader.

Confidential, Arden Hills, MN

OBIEE/ETL Consultant

Responsibilities:

• Modified the OBIEE RPD at 3 layers i.e., Physical Layer- connecting Data sources and import schema, Business Model and mapping- create Logical tables and data source mapping and Presentation Layer level-create presentation catalogs., test and validate the model depending on the changing Business requirements.
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using Basic RPD Authentication to setup groups, access and query privileges.
• Developed reports and Dashboards in OBIEE Answers, Dashboards.
• Used the Catalog Manager and maintained the Analytics Web Catalog to manage Dashboards, Answers.
• Developed different kinds of Reports with different views like Pivots, View Selectors, and Column Selectors.
• Developed Interactive Dashboards with drill-down capabilities using global and local Filters and Page/Dashboard Prompts.
• Involved in providing user based security for viewing reports.
• Extensively used Oracle BI Delivers to create iBots and to deliver the reports in a scheduled manner.
• Used BI Publisher to generate customized rtf templates.
• Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes, Oracle materialized views.
• Used ETL processes to accommodate changes in source systems and new requirements.
• Interacted with ETL team and contributed my role in developing reusable and non-reusable mappings, source and target definitions using informatica power center.
• Used various tasks like Sessions, commands, Decisions, Timer, Control, Email, Event wait and Event Raise etc to arrange the tasks in the order and to satisfy business criteria etc.

Environment: OBIEE 10.1.3.2, Informatica Power Center 8.1, Oracle 10g, PL/SQL, Windows 2003 server, UNIX.