David Simpkins Email and Phone Number

• Business Analysis to convert user stories into Business Design Document• Customer data migration from legacy to Siebel customer Hub using ODI• Installation & Deployment of OBIA artifacts (Informatica, RPD, DAC, Webcat)• POC on BI Publisher reports (source as standalone DB & OBIEE reports)• Integration of OBIEE Reports with Web Centre• OBIEE RPD Modeling for Credit Card Payment solution.

• Implemented Oracle Incentive & Compensation Analytics• Installation & Deployment of OBIA artifacts (ODI,RPD, Webcat)• Extracted data from EBS R12.1.3 using ODI• Integrated OBIEE with EBS security• Worked with business to gather requirements and performing gap analysis.• Training Permanent staff on ODI

• Upgraded BI APPS HR from 10g to 11g.• Worked closely with business to gather requirements and convert them into mapping documents.• Converted user requirement document into technical design document.• Worked with QA & UAT team to complete testing & performed unit testing myself.• Development of HR subject areas in RPD, reports & dashboards.• Used various techniques to hide/expose sensitive data for different roles.• Implemented Writeback, Agents & BI Publisher report features via OBIEE.• Assumed OBIEE Admin role to setup external LDAP, Roles, Groups etc. • Development of new Informatica (ETL) Mappings to bring in data from new source.• Update to existing Informatica (ETL) Mappings to fix various bugs.• Used DAC to run ETL jobs.• Project was implemented using Agile methodology.

• Worked with end user to capture requirements, covert them into discussion paper and then finally wrote URS (User Requirement Specification).• Wrote functional specification, testing scripts & performed unit/dimension testing.• EDW/Dimension modeling using Embarcadero.• Used ODI to extract data from /EBS/Planview & Oracle Clinical to EDW & Data-Marts.• Developed HR/Finance/Clinical subject areas in RPD, reports & dashboards.• Deployment of RPD, dashboards, & ODI code from Dev to Test & Production.• Upgraded OBIEE 10g to 11g.• Project was implemented using agile Scrum methodology.

• Worked with functional team members for requirement gathering & converted functional requirements into technical specs.• Worked directly with end user to capture various reports requirement & then converting user requirements into functional & technical specs.• Developed Informatica Interface to extract GL consolidation data for Hyperion Financial Management system.• Developed various custom reports using BI Publisher.• Worked on development & deployment of RPD.• Developed various finance reports and dashboards in OBIEE.

• Worked as a junior Oracle EBS consultant to provide 2nd line support. • Worked as consultant to develop various custom reports using BI Publisher.