OBJECTIVE

• Dedicated IT consultant looking for opportunities to build cost effective Data Warehouses (DW) and Business Intelligence (BI) solutions.

SUMMARY

• Strong experience in Design / Data Modeling, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence using Ralph Kimball and Bill Inmon Methodology.
• 7+ years’ experience implementing Oracle BI solutions
• Considerable knowledge about BI tools and technologies including OBIEE (Formerly Siebel Analytics)
• Oracle Certified Oracle Data Integrator Specialist.
• Demonstrated experience utilizing ETL tools including Informatica suite and Oracle Warehouse Builder.
• Good working knowledge on installation / upgrade of OBI Applications (7.9.6.x, 7.9.5.x).
• Expert in HR, Finance, Supply Chain Management, Manufacturing, Advanced Supply Chain Planning (ASCP) OBIA applications.
• Good knowledge on Peoplesoft and Oracle EBS source systems relevant to OBI Applications.
• Experience in doing the fit gap analysis of the BI Apps requirements to the source systems.
• Specialized in installation, configuration, design and customization across all components of the Oracle BI Applications stack including Informatica, DAC, and OBIEE.
• Specialized in the integration of non Oracle systems (Brass Ring - Kenexa, Taleo, and Success Factors) to the delivered Oracle Business Analytics Warehouse using Universal Adapters.
• Experience in the performance tuning of the BI Apps stack (OBIEE, DAC, Informatica, and Database).

TECHNICAL SKILLS

Business Intelligence: Oracle Business Intelligence(OBI) EE 10g, 11g, Siebel Analytics 7.xOracle BI Applications 7.9.5.x, 7.9.6.x

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, Oracle Data Integrator (ODI)Taleo Connect Client (TCC)

Databases: Oracle 11g, 10g/9i, Teradata, SQL Server 2005, DB2

Applications: Erwin, Oracle SQL Developer Data Modeler, Visual Studio, TOAD, SQL Developer, HP Quality Center, IBM Rational Suite

Platforms: Windows, Solaris, Linux

PROFESSIONAL EXPERIENCE

Confidential

OBIA Consultant / Architect

Environment: Oracle BI Applications (Order Management / SCM / Financial Analytics) 7.9.6.4 for Oracle EBS R12.13, Informatica 9.1 HF4, DAC 10.1.3.4.1 , Oracle 11.1.0.4 database

Responsibilities:

• Did the fit-gap analysis of the requirements to the OOTB model and identified the customizations required.
• Worked with business users in configuring the configuration files required and established a process for the configuration file updates.
• Designed the DAC load strategy for multiple custom tables created.
• Integrated the VCP (Advanced Supply Chain Management (ASCP)) data with EBS data for some of the SCM reports.
• Integrated Order delivery information (Warehouse Shipment Module) to the OOTB star.
• Key customizations include new custom manufacturing star.
• Customizations include changes in DAC, Informatica, data model, OBIEE.
• Multiple custom fields were added from KFF (Key Flex Fields) and DFF (Descriptive Flex Fields).
• Created two new fact tables for work orders and work order resources.
• Developed reports and dashboards in OBIEE
• Worked with the testing team in coming up with a testing strategy.
• Worked with the business users helping them in mapping the fields in Oracle EBS to the fields in data mart.

Confidential

OBIA Consultant

Environment: Oracle BI Applications (HR / Finance / Sales Analytics) 7.9.6.3 for Peoplesoft 9.1, Hyperion 11.1.1.3, Informatica 9.1 HF4, DAC 10.1.3.4.1 , Oracle Data Integrator 11g, WorkDay

Responsibilities:

• Designed, developed and implemented an Oracle Data Mart for the Hyperion team. This Data Mart enabled the Hyperion team to restate financial results on demand for as many years as needed, versus having to rely upon upstream data providers to re-send files.
• Designed, developed and implemented a replacement budgeting system for the IT department.
• This system replaced a People Soft n Vision reporting and Excel-based budgeting system with a Oracle BI Apps solution. The project resulted in IT management and financial planners being able to see consolidated budgets in real-time, versus having to wait for an overnight batch process.
• Designed and supported the complete architecture, installation and configuration of the entire v 11.1.1.3 Hyperion application.
• Oracle Data integrator (ODI) is the tool used to extract data from source systems and load data to all Hyperion cubes.
• Developed multiple custom hierarchies, including Combo Owner, Product hierarchy etc and integrated them to the existing OOTB model.
• Converted all the BSO member formulas and calculation scripts to the appropriate MDX formulas and correct solve - order.
• Solely responsible for architecting OBIEE solution to analyze Oracle Business Intelligence (OBIEE) as the preferred enterprise reporting software.
• Implemented Full implementation Out of box Oracle Financials and HR COTs product s with minimum customization for Financial and HR business users.
• Worked with the project architect and Data Warehouse Administration Console (DAC) and Informatica development team to design, build and Implement a process to automate nightly processes relating to Essbase data loads and Oracle EPMA nightly metadata updates.
• Iterative development of dashboards, Answers requests, charts, pivot table layouts, dashboard prompts.
• Developed 25 Bi Publisher reports and sync the Publisher security model with Answers.
• As an administrator one of the daily key job is to manage OBIEE, OBIA, Informatica and Hyperion applications up and running and monitor the Daily Incremental data loads.
• Used repository variables to dynamically modify conversion values for logical column formulas
• Merged out of Box BI Analytics RPD with Essbase Cubes, dashboard and Answers requests with existing OBIEE content.
• Worked closely and pro-actively with project leadership to identify and resolve key risks with the Hyperion upgrade project.
• Mentored junior programming staff by providing technical support and guidance in critical thinking.

Confidential

OBIA Architect

Environment: Oracle BI Applications (HR / Finance / Sales Analytics) 7.9.6.3 for Oracle EBS R12.1.3, OBIEE 11.1.1.7, Informatica 9.1 HF4, DAC 10.1.3.4.1

Responsibilities:

• Did the fit-gap analysis of the requirements to the OOTB model and identified the customizations required.
• Did POC for HR and finance Analytics to showcase the OBIA package capabilities.
• Worked with business users in configuring the configuration files required and established a process for the configuration file updates.
• Configured DAC on all the environments.
• Designed the DAC load strategy for multiple modules.
• Designed separate execution plans for Common Dimensions, HR and Non HR modules.
• Implemented a strategy to run HR and Non HR loads independently.
• Key customizations include 100 custom fields, 5 new dimensions and 2 new fact tables.
• Customizations include changes in DAC, Informatica, data model, OBIEE.
• Multiple custom fields were added from KFF (Key Flex Fields) and DFF (Descriptive Flex Fields).
• Critical Customization in HR includes changing the “Termination Date” metric to meet client needs.
• Customized the “Transfers In” metric on the W WRKFC EVT MONTH F without changing the grain of the table. Created and changed the corresponding LTSs in the RPD.
• Created two new fact tables for employee earning types and employee warning types.
• Modeled the table W LINKAGE INFORMATION D which maps the ledger to sub-ledger
• Customized product hierarchy to AP and AR fact tables.
• Developed reports and dashboards in OBIEE
• Worked with the testing team in coming up with a testing strategy.
• Worked with the business users helping them in mapping the fields in Oracle EBS to the fields in data mart.

Confidential

HR / Finance Analytics Architect

Environment: Oracle BI Applications (HR / Finance Analytics) 7.9.6.3 for PeopleSoft 8.9/9.1 HRMS system, Taleo Recruiting 12A, Taleo Smart Org 12A, OBIEE 11.1.1.6, Informatica 9.1 HF4, DAC 10.1.3.4.1

Responsibilities:

• Developed the code to extract multiple GL chartfield trees.
• Did POC for recruiting, payroll and workforce data to showcase the tool capabilities.
• Integrated the data from Taleo to the Oracle Business Analytics Warehouse (OBAW) using universal adapters.
• Developed Taleo Connect Client (TCC) specifications to get the data from Taleo Cloud.
• Automated the daily Taleo extract package using autosys.
• Mapped multiple candidate selection workflows (CSW) to the Oracle delivered configuration files.
• Worked with business users in building the configuration files and setting up a process for the configuration file updates.
• Customized the out of-the-box metrics with the Hilton defined business rules.
• Installed DAC on all environments.
• Improved the Informatica resource utilization by installing two DAC instances on the same machine
• Developed Pay Calendar, Pay Group dimensions that connect to the OOTB Payroll fact
• Integrated GL data to the Payroll fact data.
• Integrated the Hilton’s global Property dimension to the fact table.
• Integrated Success Factors data into the Oracle Business Analytics Warehouse (OBAW).
• Customized the Workforce ETL code to integrate Hilton specific function hierarchy.
• Customized the metrics as per the business rules.
• Developed a process to load the Hilton’s function hierarchy.
• Changed the code to adapt the position related changes into the fact table.
• Created aggregate fact tables to improve the performance.
• Developed a BI Publisher report broadcasted to executives.
• Replaced critical configuration files with “Informatica RTM templates” which provides users web-interface to update the files.
• Assisted the testing team in coming up with a comprehensive testing strategy.

Confidential

Oracle BI Applications Lead/Developer

Environment: Oracle BI Applications (HR Analytics) 7.9.6 for PeopleSoft 8.9 HRMS system.

Responsibilities:

• Installed and configured the BI Apps stack (DAC, Informatica, OBIEE).
• Customized Informatica components to accommodate business requirements for additional dimension/fact/dimensional hierarchy attributes not available with vanilla HR Analytics
• Category I changes: Extension of ootb facts and dimension tables to accommodate new dimensional attributes and metrics. Modification of OOTB attributes and metrics as per business requirements.
• Category II customizations: Adding new fact/dimension/dimension tables. Added custom dimensional hierarchy tables for custom Cost Center and Manager Hierarchy in PeopleSoft, enabled SCD Type II changes to various dimensions
• Provided solution to integrate BrassRing (non-Oracle) recruitment system data to existing BAW via universal adaptor (Category III).
• Conducted fit gap analysis of BrassRing data to universal adaptor for HR Anaytics
• Coordinated with BrassRing tech team to determine proper .csv file exteract format
• Worked with the PNC internal team for the file transmission to application boxes.
• Created custom SDEs to extract data from the files and load them into the vanilla staging tables.
• Customized SILOs to accommodate client specific metrics.
• Worked with business closely to understand the metric definitions and documented them.
• Configured and customized DAC components to accommodate business requirements
• Modified containers, subject areas, tasks, task groups, tables, indexes, parameters, and execution plans as needed.
• Created daily execution plans that loads fact fully and dimensions incrementally.
• Customized delivered OBIEE rpd for HR Analytics (physical, BMM, presentation) as per business requirements.
• Developed the security model for the client using external table (PSROLEUSER) and LDAP groups.
• Worked with the Peoplesoft functional team about the row level security defined and defined the same in the RPD.
• Assisted client identify PeopleSoft source system data issues due to PeopleSoft integration that impact downstream HR Analytics totals. Based on this analysis, recommended PeopleSoft process changes to ensure source system is aligned with the HR Analytics effort
• Assisted client with testing and data validation between OBIA DW and PeopleSoft source system
• Assisted business with configuration of required configuration files for HR specific codes, dimensional bands (age, performance, period of work), and event types
• Engaged with business SMEs and functional team to assist with requirements gathering and adoption to OBIA best practices and methodologies
• Conducted training on DAC/Informatica/OBIEE for client internal teams
• Assisted business users with understanding of Oracle delivered attributes and metrics, and overall adoption of HR Analytics toolset

Confidential

BI / OBIEE Consultant

Environment: SQL Developer Data Modeler, Informatica PowerCenter 8.1, Oracle 10gR2 Database, Oracle Business Intelligence (OBI) EE 10.1.3.3, SQL Server 2005, Windows Server 2003 server.

Responsibilities:

• Gathered the requirements from the business.
• Developed the multidimensional data model as per the business requirements following Ralph Kimball Methodology.
• Developed the complex ETL’s that extract data from Oracle EBS and Command Alkon.
• Prepared technical specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Created and validated active/passive transformations, look-up, router, Stored procedure, normalizer, aggregator, filter, joiner, expression, and update strategy.
• Designed and created mappings using Informatica Designer.
• Unit tested Informatica sessions, workflows and the target data.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Implemented Slowly Changing Dimensions Type II update dimension tables
• Developed the reports and dashboards using OBIEE.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Developed Reports, Dashboards with different subject matter Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) .
• Configured and automated iBots to deliver Presentation Services content.
• Involved in unit testing, integration testing of the reports and dashboards.
• Worked in the support team handling production issues.

Confidential

Oracle BI Applications Consultant

Environment: Oracle BI Applications 7.9.3, Financial Analytics for PeopleSoft Financials 8.9, Oracle 10gR2 Database, UNIX

Responsibilities:

• Installed, configured, and maintained OBIA 7.9.3 components including OBIEE 10.1.3.2/10.1.3.3 (Siebel Analytics), DAC, Informatica 7.1.4 servers
• Hardware assessment, install, and configuration of all OBIA 7.9.3 components including Informatica 7.1.4 server and repository server on Red Hat Linux, DAC server/client, OBIA .rpd, and OBIEE 10.1.3.x
• Creation of OBIA warehouse, DAC/Informatica repositories on Oracle 10gr2 database platform
• Track lineage of OBIA Dashboards and reports from OBIA warehouse to OLTP source system for E Business Suite 11.5.10 and PeopleSoft Fin 8.8/8.9 Sources.
• Led technical team in hosted OBIA proof of concept using PeopleSoft Fin 8.8 Informatica adapter against a PeopleSot Fin 8.9 source to populate OBIA warehouse tables for delivered GL dashboards and reports
• Customize source dependent Informatica ETL mappings to accommodate delta betweeen PeopleSoft Fin 8.8 and 8.9 source as per lineage tracking from Dashbards & Reports OBIA .rpd to source OLTP tables (using DAC and Informatica client tools)
• Configuration and customization of delivered DAC execution plan for financial subject areas
• Troubleshoot DAC execution plan and Informatica workflows to populate target warehouse tables
• Customize DAC tasks to improve ETL performance
• Configuration and customization of delivered OBIA .rpd including presentation, logical, and physical layers as well as user security setup

Confidential

Software Developer

Environment: Oracle 9i, TOAD, JSP, Servlets, JDBC

Responsibilities:

• Developed database deployment scripts for migration of project to new architecture.
• Designed and developed many complex PL/SQL (Stored Procedures, Packages & Functions) scripts for data transformation in line with program specifications.
• Written PL/SQL Stored procedures for activating leads and offer related data on some validation rules.
• Assisted the DBA in creating tables, indexes, views, grants and database links.
• Updated the data extracts and reporting packages for performance and efficiency purposes.