SUMMARY

• Over 10+ years of professional IT experience in Data Warehousing using Oracle Data Integrator and designing, development and implementation of OBIEE
• Expertise in Data Warehousing (ETL/ELT) program routines using tools like Informatica and Oracle Data Integrator (ODI) for data warehouse tasks such as data extraction, cleansing, transforming and loading
• Extensive experience in ODI 12c,11g & 10g Configurations, Design, Development and Testing
• Expert in the functional and technical aspects of Oracle E - Business Suite (EBS)/ Applications 9i, 10g and 11i deployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training.
• Proficient in RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion.
• Experienced in to Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, 11g, Oracle BI Applications which include building/configuring repository, creating/managing oracle Intelligent Dashboards, oracle Answers, oracle Delivers and oracle iBots (ETL Informatics, Oracle Data Integrator, Oracle Essbase, Scheduling-DAC), Using Noetix Views. Proven Business Intelligence experience in development, design and implementation of various pieces of business intelligence like Data Warehousing, Data mart, Reporting Tools (Administration and End-User Tool), developing dashboards, security design and implementation
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports. Experienced in Installing and Configuring OBIA Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.
• Experienced in Data Modeling and Analysis using Dimensional Data Modelling, Logical Star Schema modelling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool
• Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access/query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle Answers
• Integrated Noetix views wif various reporting tools and customized these reports based on Noetix Views on various reporting tools like Oracle Reports, OBIEE, Noetix Platform, BRIO, Hyperion, Cognos, Oracle Discoverer and Business Objects. Has experience working in various domains like Pension, Health Care, Capital Markets; Insurance, Retail, Customer Service
• Highly experienced in data integration (ETL) processes to transform disparate source data i.e. Oracle, Microsoft SQL Server, MySQL, PostgreSQL and flat files into the target Operational Data Store/Data Warehouse/Data Mart. Having good noledge on Oracle Applications like SCM (Order Management) and Oracle Financials (Receivables). Experience in Project Management and coordination wif offshore team on passing requirements, guidance, trouble shooting and project management
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer
• Experienced in writing, testing and implementation of complex Stored Procedures and Packages at database level using PL/SQL, Database design Methodologies
• Participated in many successful Business Intelligence and Data Analytics projects, each of which wif a budget of at least $1 million. Excellent track record demonstrating strong analytical and problem-solving skills, computer proficiency and ability to follow through wif projects from inception to completion
• Experienced in full Software Development Lifecycle starting from Requirements Analysis, Design, and Development, Testing, Maintenance and Production support of business applications
• Major strengths include ability to quickly adapt to modern technologies and pristine environment
• Self-motivated team player wif good interpersonal and communication skills

TECHNICAL SKILLS

ETL Tools: Oracle Data Integrator (ODI) 12c, 11g, Informatica 8.x and 9.1, DAC

Oracle ERP Applications: Oracle E-Business Suite (EBS) - Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA), SCM - Oracle Purchase Order (PO), Oracle Order Management (OM)

Reporting Tools: Oracle Reports, OBIEE 12c, 11g/10g, BI Publisher, OBI Analytics, Noetix Platform - Noetix Query Server, Noetix Web Query, BRIO, Hyperion, Cognos, Oracle Discoverer and Business Objects

Languages: Oracle D2K, Oracle Forms, Oracle Reports, SQL, PLSQL, C, C++, Java

Web Technologies: HTML, XHTML, XML, JavaScript

Database: Oracle 11g/10g, MS-Access, MS SQL Server 2005/2008

Software Applications: MS Office, Dreamweaver, Adobe Photoshop, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Sr. ODI/OBIEE Consultant

Responsibilities:

• Involved in creating whole infrastructure of Data Warehouse and populating facts and dimensions
• Gatheird Business requirements by interacting wif the business users and created requirement specification document
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from disparate Sources (My Confidential ) to target systems ( Confidential Business Intelligence Data warehouse schemas) using Oracle Data Integrator
• Developed Data Lake/Operational Data Store (ODS), Enterprise Data Warehouse (Kimball) & various Data Marts
• Developed ODI models to import data from different sources like Oracle ERP application EBS Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL) to Data Warehouse & Data Marts.
• Experience modifying and creating Oracle EBS workflows and underlying source data and processes.
• Loaded and optimized data from Oracle E-Business Suite source data into a centralized data warehouse.
• Used various ODI EBS Knowledge Modules such as RKM E-Business Suite - to reverse-engineer E-Business Suite data structures, Standard Oracle or SQL LKMs - to extract data from E-Business suite using objects such as Tables, Views, and Key Flex fields & IKM E-Business Suite - to integrate data to E-Business Suite using Open Interface tables by ensuring data integrity.
• Worked on populating various subject areas like Audit, Participant Compensation, Participant Contribution, Participant health account, Participant Retirement Account, Participant Health Event & Health Eligibility, Participant Payroll, Participant training, Participant Retirement Warrant, and Workflow
• Created various data marts for subject areas like Workflow, Participant Service Credit Years, Participant Payroll, Participant Training, active/inactive Member database, Pension Warrant Aging & Employer Reported Payroll
• Involved in developing Investment Finance Cost Management Project which consists of six major components - collect data from various sources, load the data into the data lake, perform data quality checks and fixes on the data in the lake, transform the data into a dimensional model and store it in the data warehouse and, finally, publish the data via reports and dashboards
• Worked on populating various Investment subject areas like Asset, Budget, Expense and Adjustment
• Developed Employee Names Master Data Management (MDM) system to match employee names across multiple source systems (My Confidential, Enterprise Data Warehouse, PeopleSoft HCM, PeopleSoft Financials, Genesys-Call Centre, State Controller’s Office CCR-payroll ... etc.) to provide a complete view of each employee using Jaro-Winkler similarity scoring in ODI
• Extensively involved in 24 X 7 Production Data Warehouse support and monitor to ensure that data, reports and dashboards are ready for end users
• Worked in migration of solution to new Virtual Machine (VM) hardware
• Loaded data from various sources involving Oracle, Microsoft SQL Server, MySQL, PostgreSQL, flat files, CSV files using Oracle Data Integrator
• Use of Gloden Gate and Journalizing interfaces to populate data from OLTP system to data warehouse schemas
• Improving performance of existing ODI Interfaces that were taking long time to load data
• Preparing execution plans and dependency sequence among the interfaces, Knowledge Modules using ODI Designer tool. Created variables, sequences, user functions, procedures, interfaces, packages, scenarios, load plans & schedules in ODI
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI
• Developed slowly changing dimension SCD Type 1 & Type 2 techniques
• Implemented complex ETL code to handle late arriving dimension issue in Data Warehouse
• Did error analysis for continued improvement of the Enterprise Data Warehouse by catching data anomalies and code issues
• Developed complex PL/SQL database objects like Stored Procedures, Functions, Packages and Triggers
• Performed SQL and PL/SQL performance tuning using various tools and techniques like Explain Plan, Auto Trace, Hints, Indexes, Views, Materialized Views & Partitioned the tables
• Provide ad hoc ability in the OBIEE system for query and build reports
• Configured the OBIEE repository (Physical, BMM and Presentation layer)
• Worked in migration of solution to new Oracle EXADATA hardware
• Created dimension hierarchies and aggregates in the BMM layer
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements. Performed Data Validation of data in the reports and dashboards
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results

Environment: Oracle Data Integrator 11g, OBIEE 11g, Oracle Gloden Gate, Exadata, Oracle SQL, PLSQL, Toad, SQL Developer, IBM ClearCase, IBM ClearQuest, DB2, HP Service Manager, Service Now, Windows XP

Confidential

Sr. ETL/OBIEE Consultant

Responsibilities:

• Gatheird Business requirements by interacting wif the business users and created requirement specification document. Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Oracle Data Integrator. Developing Interfaces
• Preparing execution plans and dependency sequence among the interfaces, Knowledge Modules using ODI Designer tool. Created Packages, Scenarios and Load Plan Components, Load Plans using ODI
• Generated Load Plans and Executed Integrated Testing over Procurement Subject Area using ODI
• Also involved in coordination wif offshore team by passing the requirements, guidance, trouble shooting and project management. Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database design Methodologies
• Provide ad hoc ability in the OBIEE system for query and build reports
• Configured the OBIEE repository (Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements. Generated reports using OBIEE features like pivot tables, charts and view selector
• Performed tasks related to Oracle Business Intelligence Enterprise Edition (OBIEE) Functional/System Administration
• Implemented multiple fact tables along wif conformed and non-conformed dimensions in OBIEE
• Implemented user-friendly attributes, joins, calculations, dimensions, measures and data dictionary definitions in the OBIEE repository and reports. Performed Data Validation of data in the reports and dashboards
• Extensively used SQL Tuning to improve performance. Created iBots to send pre-processed reports using OBIEE Delivers. Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results
• Worked wif project management to provide estimates of project costs and timelines Understand business change requests and manage business expectations

Environment: Oracle Data Integrator 11g, OBIEE 11g, Oracle SQL, PL/SQL, Windows Server 2008 R2, Windows XP

Confidential

Sr ETL/OBIA Developer

Responsibilities:

• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Oracle Data Integrator
• Performed Administration Activities like Installation and Configuration of Informatica, ODI, and OBIEE
• Implemented ODI Knowledge Modules LKM BIAPPS SQL to Oracle & IKM BIAPPS SQL Control Append
• Identifying and implementing methods to create and manage ODI repository using ODI API’s
• Creating the Interfaces, Packages and procedures using Oracle Data Integrator
• Created Snowflakes and Star Schema to perform data modeling for proposed architecture
• Installing Oracle BI Analytics and configuring the connection parameters wif SQL Server, Oracle 10g
• Create/Modify Metadata repository (.rpd) as per the data requirements by using Oracle BI Analytics Server Admin tool. Independently Designed and developed subject areas in the RPD
• Configured the Data Warehouse Administration Console (DAC) according to the OBIA Financial analytics
• Modified the Source system parameters in the DAC according to the Business requirements wif their respective currencies and exchange rates. Scheduled the Custom Execution plan for a weekly run in the DAC scheduler
• Included the custom mappings in DAC Execution plan
• Automated ETL process is set up using Informatica and DAC scheduling tool to gather all the required data
• Defined appropriate user-friendly attributes, joins, calculations, dimensions, measures and data dictionary definitions in the OBIEE repository and reports. Created Repository Users/Groups and Web Groups and assigned permissions to the user groups to define security in the repository
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates)
• Implemented conformed and non-conformed dimensions in ETL and reporting layers
• Developed and scheduled iBots for delivering personalized reports to users on time
• Extensively involved in writing complex PL\SQL programs to load the data into target systems
• Participated in the implementation of any OBIEE product upgrades. Performance tuning ETL mappings and Reports. Implemented OBIEE security at the data and object levels. Creating and assigning appropriate roles and privileges to users depending on the user activity
• Manage/modify database security and database schema. Created report templates using BI Publisher. Developed prototypes for helping business understand concepts and direction
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables
• Create/design functional and technical documentation for ODI objects, Reports, RPD and Informatica mappings

Environment: OBIEE 11g, Oracle Data Integrator, Oracle Financial Analytics, DAC, Informatica, PL/SQL, SQL

Confidential

ETL/OBIEE Consultant

Responsibilities:

• Gatheird Business requirements by interacting wif the Business Analysts and the business users
• Responsible for Analysis, Design, Build, Test and Implement ETL Solutions in ODI
• Installation of Noetix Views as per Multi-Org set up
• Created BI repository from Noetix views by generating. rpd files containing the physical layer, business model layer and mappings, and the presentation layer
• Configuration/Generation of Noetix Views and used Noetix Generator to populate Noetix Views into OBIEE metadata. Customization of Noetix Views and OBIEE Metadata layers as per business requirements
• Implemented data and object levels security in OBIEE
• Creating and assigning appropriate roles and privileges to users depending on the user activity
• Created subject areas for different functional areas for financial views as per Organization set up. Created top-level folders in the presentation layer of OBIEE based on the views
• Designed Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model/data mapping (create Logical tables & data source mapping) and Presentation Layer as per the Universes in Business Objects and followed best practices
• Developed ODI complex Transformations using heterogeneous sources like flat files and different relational databases, Mapplets, Mappings using Oracle Data Integrator
• Created dimension hierarchies, aggregates, and logical sources in BMM layer
• Extensively used repository variables, session variables and presentation variables
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges
• Created views and aggregated tables to improve performance in rpd. Created dynamic Dashboards wif Dashboard prompts, Charts, Pivot Tables, Guided Navigation Links and Sections
• Used Column Filter prompts and various views such as Pivots Table, Charts, Narrative Views and View Selector
• 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. Modified the InstanceConfig.xml in order to configure the maximum number of rows, columns, sections, records required on the reports
• Created user level security for Intelligence dashboards based on Business Requirement and Business Objects
• Replicated the Reports, Dashboard, and Functionality in Business Objects to OBIEE (nearly 500 reports)
• Created Mock up Reports for the new business requirements. Created iBots to send pre-processed reports using delivers. Integrated BI Publisher wif OBIEE
• Created Templates, Reports, Prompts in BI Publisher
• Experienced in writing, testing and implementation of complex Stored Procedures and Packages at database level using PL/SQL, Database design Methodologies
• Performed Data Validation of data in the reports
• Extensively used SQL Tuning and Indexes to improve performance
• Used SQL Developer to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution
• Provided to Training to the business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures wif OBIEE Best Practices
• Performed Unit Testing by comparing the data in OBIEE and Business Objects
• Documented the conversion process from Business Objects to OBIEE for future reference
• Involved and Migrated repositories and catalog to Development to UAT to Production environment

Environment: OBIEE 11g, PL/SQL, SQL, Oracle Data Integrator, BI Publisher, Noetix Views, Noetix Workbench, Noetix Generator for OBIEE, Oracle 10g/11g, SQL Developer