TECHNICAL SKILLS:

• OBIEE 7.89/10G/11G/12c 20 Years
• EBS 11.5 and r12 as a source system 10 years
• Oracle 5/6/7/8/9/10G/11G Databases 25 Years
• ODI 11/12c 5 Years
• SQL 25 Years
• Confidential 3 Years
• Golden Gate 1 Year
• Create Test Scripts 5 Years
• Team Lead/SME 15 Years

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Senior Oracle Developer

Responsibilities:

• Install and configure OBIA 11.7/12c Financials, Supply Chain, Delivery, Manufacturing, EAM and other custom EBS specific applications.
• Expand each of the applications to include custom fields from highly customized EBS applications. Identify security issues and update weblogic to include custom Active Directory groups.
• Establish and document application migration standards for moving new code from Development to QA to Test to Production.
• Install OBIEE/ODI 12c in a POC environment with Golden Gate SDS schema as the database that OBI/ODI applications uses instead of EBS.
• Test all processes in multiple environments.
• Work with business to create new reports in the 12c environment that replace existing Business Object Universe queries.
• Create an application using Confidential that gathers survey data from an application called Go Spot Check. Replace a UNIX process that communicates with Confidential and gathers information input by Mystery Shoppers into a Confidential application running on their iPhones.
• Confidential ’s query Confidential with XML and loads the data gathered into an Oracle database.
• Custom executive and other Score Card type reports display scoring data of each of the chains that sell this companies products.
• Support Production OBIEE applications and other DAC and Unix processes. Perform data loads for all the new custom applications.
• Perform upgrades and other standard support tasks.
• Write test scripts using SQL for testing of all new releases and reports using SDS and standard databases.
• Use Confidential to write and read data from Salesforce.com.
• Create custom functionality to gather information from multiple systems and analyze the data to determine when an outage of a specific system is eminent.
• Create tickets based on business determines responses to outage messages.

Confidential, San Clemente, California

Oracle SME and Team Lead

Responsibilities:

• Define Roadmap for upgrade of 7.9.6.4 to Version 11 OBIEE after upgrade to EBS r12
• Install and test new versions of OBIEE into a Development environment.
• Review all the businesses 7.9.6.4 Obi reports and create design documentation for duplication of the existing reports into the POC environment.
• Work with business to identify new reports and reports that can be created in the new version that will reduce the need for many of their existing custom EBS r12/11.5 reports.
• Team Lead for 3 developers.
• Work with customer to create a Cloud based environment.
• Install and test OBIA applications into a development environment.
• Create new test plans and document all required changes.
• Work with Supply Chain user to create new reports that can be used to identify production issues.

Confidential

OBIEE SME and Installation Team Lead and Training Supervisor

Responsibilities:

• Lead development, developers and other support personnel for multiple global projects. Install and configure OBIEE/OBIA/Fusion applications.
• Install on UNIX/Linux and Windows operating systems in Confidential Cloud virtual environments.
• Install Oracle and other databases for each of the different customer configurations on the Cloud. Implement best practices for architecture, data loading, installation and performance. Install and Configure OBI, Fusion, OBIA Apps and databases for all global customers.
• Review each implementation after installation.
• Install and maintain Fusion, ODI, Informatica, DAC and all OBIEE customer applications.
• Monitor initial data loads and identify any issues.
• Correct then document all identified issues.
• Resolve assigned Service Requests.
• Creation of best practices documentation for installation, configuration and maintenance of all the installed OBI applications for pre and post installation support and maintenance.

Confidential

Senior OBIEE SME/Senior Architect/Senior Business Analyst

Responsibilities:

• Develop POC using OBIA Financials and Supply Chain for Confidential . POC took 6 months to develop for Pharmaceutical company.
• Company wanted to determine if Confidential model was feasible for use with existing Supply Chain OBIA application.
• Confidential included delivery of initial design and gap analysis documentation along with other custom dashboard design recommendations.
• Present findings and POC to management.
• Review Out - of - Confidential OBIA Supply Chain functionality. Identify road map that details possible development paths and timelines for delivery of full blown application to their existing OBIEE/EBS production environment.
• Customer currently uses OBIA Financials, Supply Chain, Noetix, Materialized Views and Human Resources.
• Identify reports that would require changes due to the new customizations that would be implemented.
• Apply and test new changes requested by customer to Security Model and determine how these changes would affect the existing customized Security Model.
• Review all recommendations with upper management and super users so that they could determine if they wanted to move forward with project.
• Define and document all business processes then present to upper to upper management the effort required to meet their reporting requirement.

Confidential, Richmond, VA

OBIEE SME and Senior Analyst

Responsibilities:

• Gather customer reporting requirements then design and create data mart to hold data migrated from multiple data sources.
• Work with business users to identify business processes that requirement enhancement by creating data islands that will be used to resolve those data issues.
• Create custom subject areas that contains customer information migrated from Teradata data warehouse database.
• Create custom star schemas to support custom subject areas to mine data collected from each of their car dealerships.
• Create custom repository metadata in support of reporting requirements.
• Create custom reports as required to support mining existing customer data for reporting purposes.
• Integrate credit data into the data warehouse.
• Create custom SQL to move data from existing data sources into the custom designed data mart.
• Creating installation and configuration best practices document to help team understand what is required to complete a successful installation.

Confidential, Richmond, VA

OBIEE Analyst SME, Business Liaison and Development Team Lead

Responsibilities:

• Head team of developers to create new and custom reports for 10g and 11g HR and Financial users.
• Meet with Senior Management and Business users to gather requirements, document business processes and identify all reporting issues and create solutions.
• Responsible for overall hardware and software configuration documentation and testing of newly created reports.
• Create training documentation then train users or developers as required.
• Compile all business with report designs and architect custom reporting solutions both internal and external to OBIEE.
• Review Fusion views and determine integration path for integration with OBIEE.
• Create test plans then provide testing support for business users.
• Customize Fusion and OBIEE views/reports and enhance performance as required.
• Responsible for developing new reports, Confidential development, Fusion enhancements, repository metadata and other OBIEE processes.
• Train super and business users as required.

Confidential, Newport Beach, CA

Oracle OBIEE SME and Senior Analyst/Developer

Responsibilities:

• Responsible for development and delivery of all new reporting functionality.
• Gather requirements and meet with business users.
• Train all users by chairing training sessions.
• Provide design and product expertise for Peoplesoft/OBIEE 11g.
• Review existing reports and design new reports that utilize Confidential ’s Insurance data warehouse model.
• Develop new reports using answers.
• Review all existing Peoplesoft reports and identify whether they will be created using BI Publisher or Answers.
• Develop new repository metadata as required to meet reporting requirements.
• Install and configure new instance of OBIEE 11g.
• Design and Develop Reporting Security Structure using Weblogic Security model.
• Configure initialization blocks that utilize the new security structure.
• Create new data model in support of new reporting.

Confidential, Atlanta, GA

OBIEE SME and Senior Analyst

Responsibilities:

• Review 3000 reports and identify then build a common set of unique reports.
• Many reports were redundant due to the experience level of the users who created the reports.
• Review existing custom PeopleSoft OBIEE 10g Answers Reports.
• Work with business users to identify slow performing and duplicate reports.
• Tune all reports as required. Combine duplicate reports into single reports.
• Work with business to identify issues with existing subject areas that do not meet business user requirements.
• Review customer developed repositories and identify then correct any identified issues.
• Train Business Users how to accurately create reports using the existing subject area available to them.
• Meet with design review board as new reports are identified and supporting design documents are created.

Confidential, New York City, NY

OBIEE SME and Senior Analyst and Developer

Responsibilities:

• Create project plan in support of installation of OBIEE 10g installation Resource planning tasks in support of the new installation.
• Manage weekly status meetings. Development Tasks: Install and configure OBIEE in a Linux/Windows environment.
• Configure OBIEE to migrate all EBS data into Vanilla installation of 10.1.3.4 into Linux.
• Change all configuration files to meet EBS configuration then migrate all data into the Oracle data warehouse.
• Configure DAC for EBS 11.5 then run custom execution plan and debug any errors.
• Customize account hierarchies to match the customizations performed in EBS.
• Gather requirements and translate into supporting documentation.
• Debugged all issues encountered during run of execution plans.
• Correct issues with slow performing reports and make sure they accurately display the information that was migrated into the data warehouse.
• Write SQL test scripts.
• Create test cases.
• Create custom reports and Confidential ’s for new budget reporting requirements.

Confidential, Valley Forge, PA

Oracle SME, Senior Analyst and Team Lead

Responsibilities:

• Meet with business user to identify new reporting requirements.
• Install and configure OBIEE with financial applications.
• Development of custom Confidential 's to support new reporting requirements.
• Meet with customer and identify performance issues.
• Correct all customer identified issues and slow performing reports.
• Develop metadata for repository as required. Run both full and incremental data load.
• Correct and resolve issues as they occur during the initial data loads.
• Identify and correct database performance issues.
• Write SQL test scripts and test cases.
• The customer used out-of-the- Confidential GL, AP, and AR reports and customized some of those reports to meet reporting requirements.
• Performance tune all reports. Develop new reports using answers to meet those reporting requirements.
• Develop new BI Publisher Reports in support of external reporting requirements.
• Create Certification documents that contain details about each of the newly created reports.
• Details include screen shots of each of the steps that were taken to create the reports that were required by the business.

Confidential, Chantilly, Virginia

Oracle SME/Senior Analyst

Responsibilities:

• Upgrade existing 7.8 Call Center to latest version 8.0.1.
• Project included custom Heroix functionality.
• Install, configure and customize upgrade Call Center to meet Confidential business Requirements.
• Identify and document in detail all configuration and installation steps so Confidential can install product in very secure network.
• Install and configure Oracle Secure Enterprise Search with custom Siebel 8/0 Business Component search indices available from the Siebel Call Center screens.
• Develop custom email notification functionality per specification.
• Create custom BI Publisher Reports using highly sensitive data gathered from multiple remote data sources.
• Identify, design and configure custom Organization hierarchy per Confidential specifications so that multiple organizations can run on one OLTP database.

Confidential, Brooklyn, New York

OBIEE SME/Senior Analyst

Responsibilities:

• Install and configure OBIEE with out-of-the- Confidential reports.
• Create new reports as required to meet business reporting requirements.
• Run Informatica loads and correct issues as they occur.
• Configure product and work with customer to identify all new required reports.
• Turn those requirements into actual reports by developing new metadata in the repository, new subject areas for answers.
• Use Answers to develop then test all new reports.
• Development new Confidential 's in support of all custom reports.
• Train development team how to create new reports using Answers.
• Create new Dashboards for upper management.
• Document all enhancements.