KEY STRENGTHS:

• Oracle PBCS Oracle EPBCS Oracle Hyperion Planning Financial Reporting Studio
• DRM Oracle Essbase FDM & FDMEE Smart View for Office
• Program & Project Mgmt Business Development Fusion Financials OTBI and FRS reporting

CORE COMPETENCIES:

• Oracle Hyperion Planning and Essbase Senior Architect.
• Oracle Enterprise Planning and Budgeting Architect (PBCS, EPBCS).
• Oracle DRM Architect.
• Oracle ARCS, FCCS, FDMEE and Data Management.
• Business Intelligence and Data Warehousing consultant.

ENABLING TECHNOLOGIES:

• Oracle EPM Technologies (Versions 11.x)
• Hyperion Planning
• FDM (Classic and EE)
• DRM
• Essbase
• Essbase Studio
• Planning Budgeting Cloud Service (PBCS)
• Oracle BI Technologies
• Essbase Analytics (BSO)
• Essbase Integration Services (EIS)
• Hyperion BI+ (Financial Reports, Web Analysis, Interactive Reporting, Production Reporting)
• Fusion Financials Reporting
• BI Publisher Reports
• FR Studio Reporting
• Database Technologies
• SQL Server
• MS Access
• Oracle
• Teradata
• Scripting & Automation Languages
• ESSCMD
• MDX
• DOS Batch Scripting
• MaxL
• EXCEL VBA
• Microsoft Office (Excel, Project, Word, PowerPoint, Visio, Access)

PROFESSIONAL EXPERIENCE:

Confidential

Workforce Planning PBCS Architect

Responsibilities:

• Design and Build custom Workforce planning application for public sector state Agency in Virginia
• Headcount and named employee plan
• Data integration with payroll system and Oracle Financials
• Support of P/L, Balance Sheet and CAPEX implementations
• Custom reports in Web Studio and Smart View

Confidential

PBCS Financials Architect

Responsibilities:

• Design of custom PBCS solution to store and report Actual results
• Integration with NetSuite financials
• Smart View reporting

Confidential

DRM, EPBCS and ARCS Architect

Responsibilities:

• Architect for DRM system managing metadata for 4 target systems (EBS, GL, EPBCS and FCCS)
• Integration with data management for all EPM products; EPM Automate for all interfaces
• Design of hierarchies to maintain old to new chart of account structures with exports to DM to map values for all systems
• Use of Cloud DM for bi - directional integration with Cloud Financials and DRM
• Implementation of Budgeting process in EPBCS
• Implementation of ARCS reconciliation process for multiple company segments

Confidential

Enterprise Budgeting and Planning Cloud Lead

Responsibilities:

• Design, Build and Test customizations for EPBCS Financials and Workforce modules
• Customization of all metadata, webform processes, trend and driver inputs, manual inputs, webform modifications and customization of data loads in FDMEE as well as data transfer between cubes.
• Dashboard implementation and customization, security on 4 dimensions and workflow implementation.
• Financial Reporting Studio reports.

Confidential

Hyperion Planning and Essbase Advisory Consultant

Responsibilities:

• Perform architecture assessment and create roadmap for key performance and stability improvements
• Hyperion system 11.1.2.4 Planning and Essbase, EPMA with FR Studio
• Implementation of architecture improvements and application tuning
• Provided technical assessment of CXO Cockpit tool versus OBIEE and assisted with product selection
• Delivered on key initiatives to improve performance and stability of application including dimensionality changes, business rule optimization, backup and restore procedures as well as security improvements.
• Provided administrator training and best practices to improve usability; provided long term
• Advisory work supporting proposal to move Planning to the Oracle Cloud PBCS service

Confidential

Fusion Financials Reporting Consultant

Responsibilities:

• FR Studio and OTBI reporting for Fusion Financials implementation
• Detailed Financial Statement reporting in FRS
• Operational transaction level reporting in OTBI

Confidential

PBCS Consultant

Responsibilities:

• PBCS implementation of P/L, Balance Sheet, Cash Flow, CAPEX and Workforce modules
• Revenue build of subscription and non-subscription revenue across multiple channels and customer segments
• BI Publisher and FR Studio reporting out of Oracle Fusion Financials
• Provided Smart View and FR Studio training for all Confidential resources

Confidential

PBCS Consultant

Responsibilities:

• Build and support Budget and forecasting process
• PBCS with integration to on premise HFM consolidation application
• FDMEE integration for data loads
• Complex weekly subscription revenue model build for consumer service and franchise product lines
• Product level weekly and monthly forecasting of all revenue and expenses with allocation methodology to drive total P/L budget
• Complex allocation logic for COGS and overhead across multiple plan types
• Developed and delivered functional training for FP&A group as well as technical training for all administrators.

Confidential

DRM Architect

Responsibilities:

• Source 12 hierarchies in DRM for new HFM tax consolidation application
• Export ADS file format for EPMA integration, plus two exports with FDM mappings
• Design DRM system for future integration with other HFM applications and EBS
• Responsible for DRM design, implementation, testing, transition and training
• DRM property setup, exports, validations scripts and formulas

Confidential

DRM Consultant

Responsibilities:

• Source 16 hierarchies and reference data sets in DRM
• Integration with SQL Server staging area for consumption by downstream reporting apps
• Full property definition and implementation, security, exports and validations

Confidential

Essbase and Planning Consultant

Responsibilities:

• Development and support of multiple Planning applications and Essbase cubes
• Budget Cost Allocation cube development with SmartView input forms to allocate overhead cost for all business units
• Budget data seeding calculation scripts (3 versions)
• Planning (v11.1.2.3), Essbase, FR Studio, Excel VBA

Confidential

Lead Architect and Delivery Consultant

Responsibilities:

• Essbase 11.1.2.3 Financial Reporting cube
• Direct integration with 4 sources; production of 3 standard financial statement
• Rolling 12 month actual data view for AD HOC analysis and reporting
• FR Studio, Essbase, EBS integration

Confidential

Director of IT Development and Service Desk, Hyperion Project Lead

Responsibilities:

• Financial Reporting and Planning Application build (11.1.2.3 PBCS).
• Operational data reporting through multiple Essbase cubes.
• FDM integration with Microsoft Dynamics and OBIEE reporting.
• FR Generation of Financial Reporting package.

Confidential

Planning Application Consultant

Responsibilities:

• North America Retail Planning Application design and build, including Manufacturing operational analytics application (v 11.1.2.2) - Planning / Analytics Lead
• Design and Build for 3 multi-currency Planning applications.