SUMMARY

• Mr. Mastrosimone is a Hyperion Planning Professional who has worked with Hyperion Planning since the early 1.x versions.
• He has over 25+ years’ experience in fields of Public Sector, Entertainment, Internet, Banking, Pharmaceuticals, Communications, Confidential, Technology and Manufacturing.
• He has extensive knowledge of Hyperion Planning, Hyperion Essbase, FDMEE and Hyperion Reports.
• Mr. Mastrosimone is a certified Hyperion Planning/Essbase Professional and his consulting experience covers the complete project cycle from project management, requirements gathering, design, installation, implementation, deployment and .
• Mr. Mastrosimone implementations focus on applying best practices to meet the needs of each client, in an environment of teamwork and knowledge transfer.

TECHNICAL SKILLS

Confidential Hyperion Planning 9.x to 11.x, Public Sector Planning and Budgeting (PSPB) 11.x, Essbase 6.x to 9.x, Planning and Budgeting Cloud Service (PBCS/ EPBCS), Financial Data Quality Management (FDM), Enterprise Performance Management Architecture (EPMA), Lifecycle Management (LCM), Human Capital Planning / Workforce Planning (HCP)

Workspace, MaxL, Hyperion Smart View, Confidential Data Integrator (ODI), MS Excel, Business Rules, Calc Scripts, Member Formulas, Migrations/ ETL, SQL, MSAD, VB Script

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Responsibilities:

• Implemented EPBCS Financials
• Assisted in Data Integrations between Confidential GL to EPBCS
• Created 12 Allocation Business Rules
• Created Account Receivables Aging calculations
• Created Cash Flow calculations

Confidential, San Luis Obispo, CA

Responsibilities:

• Built revenue and EPBCS expense application, creating forms, menus and business rules with Planning
• Led design/build of Work Force Planning EPBCS application for the City; solution enabled client to quickly apply what - if scenarios to for Unions negotiations
• Created data management budgetary control connections to Confidential Fusion GL; solution enabled for budget adjustment, encumbrances, commitments, and obligations

Confidential, San Francisco, CA

Responsibilities:

• Updated/Tested DRM metadata
• Updated/Created FDMEE Batch automations
• Updated/Created Confidential Sql Developer tables and views
• Created BSO and ASO Hyperion Applications
• Created Data Integrations between EBS and Hyperion
• Created Detailed
• Project Plan
• Design document
• Requirements document
• User Acceptance Test (UAT)
• Unit Testing
• Migration Plans

Confidential, San Francisco, CA

Responsibilities:

• Updated/Created Confidential Data Integrator (ODI) packages
• Procedures
• Interfaces
• Updated/Created Essbase Studio Modeling, deployment and drill-through
• Updated/Created ODI/Maxl/Batch automations
• Updated/Created Confidential Sql Developer tables and views
• Created BSO and ASO Hyperion Applications
• Created Data Integrations between EBS and Hyperion
• Created Detailed
• Project Plan
• Design document
• Requirements document
• User Acceptance Test (UAT)
• Unit Testing

Confidential, Irvine, CA

Responsibilities:

• Created EPBCS for Line Item
• Created integrations between Confidential and EPBCS using flat files
• Created allocation business rules
• Created Data Management data loads and mappings using text files
• Migrated artifacts to EPBCS

Confidential, Irvine, CA

Responsibilities:

• Upgraded to Hyperion Planning System 11.1.2.4
• Migrated using LCM from Development, Test and Production
• Updated Business Rules and Rule sets
• Automated data loads
• Redesigned Workforce
• Performance tuning of all databases and calculation
• Yearly budget enhancements
• Received data from Confidential 10g
• Created integration with Confidential using flat files
• Created data source connection to Confidential ’s SQL views

Confidential, Santa Monica, CA

Responsibilities:

• Assisted in software selection
• Evaluated 8 vendors
• Created demo scripts
• Created vendor score cards
• Negotiated the software contract and implementation costs
• Client selected Adaptive Insights
• Implemented Adaptive Insights for 30 users and 2 administrators
• Created data loads and mappings from Workday to Adaptive Insights using MS Access
• Created account mappings from Confidential ’s Financial Statement Generator (FSG)

Confidential, Newport Beach, CA

Responsibilities:

• Implemented Hyperion Planning System 11.1.2.4
• Held Requirement and Design session with the client
• Created Design Documents
• Created a detailed Project Plan
• Created three applications
• Workforce Application
• Management Reporting Application
• Forecast Application
• Developed applications using EPMA
• Administered and maintain a multi-layered security at a user group level
• Created Data Syncs to move Planning data
• Created and executed UAT scripts
• Assisted in ERPI integrations
• Production Support
• Created allocation scripts
• Migrated using LCM from Development, Test and Production
• Received HR data from Confidential ’s Confidential
• Created drill back to Confidential ’s data

Confidential, Westlake Village, CA

Responsibilities:

• Implemented Hyperion Planning System 11.1.2.1
• Held Requirement and Design session with the client
• Created a detailed Project Plan
• Created Workforce Planning Application
• Created Design Documents
• Created Planning Application with three databases
• BalSht
• FinPlan
• Revenue
• Developed Business Rules using Calculation Manager
• Created and Implemented User for 18 controllers
• Created Essbase ASO databases and partitions
• Created integrations with Confidential for compensation and benefits data loads
• Created and executed UAT scripts
• Administered and maintain a multi-layered security at a user group level
• Created Currency Conversion Scripts

Confidential, Philadelphia, PA

Responsibilities:

• Upgraded Hyperion Planning System 11.1.2.1
• Updated calculation scripts
• Created Essbase ASO databases and partitions
• Production Support
• Migrated using LCM from Development, Test and Production

Confidential, Phoenix, AZ

Responsibilities:

• Implemented Hyperion Planning System 11.1.2.1
• Created a detailed Project Plan
• Created Allocation Calculation/Macro Scripts
• Created ODI automation packages

Confidential, Phoenix, AZ

Responsibilities:

• Implemented Hyperion Planning System 11.1.2.1
• Held Requirement and Design session with the client
• Created Design Documents
• Created and executed UAT scripts
• Created and implemented programs
• Presented two Conference Room Pilots

Confidential, Phoenix, AZ

Responsibilities:

• Upgraded to Hyperion Planning System 11.1.2.1
• Created a detailed Project Plan
• Developed Outline loader automation
• Created and executed UAT scripts
• Created Life Cycle Management automation

Confidential, Santa Fe Springs, CA

Responsibilities:

• Implemented Hyperion Planning System 11.1.2.1
• Held Requirement and Design session with the client
• Created ODI automation
• Optimized Essbase database

Confidential, Seattle, WA

Responsibilities:

• Implemented Hyperion Planning System 11.1.1.3.
• Created two Hyperion Planning Applications
• Workforce Planning Application
• FinPlan Application
• Updated and tested Confidential Eliminations, Currency Conversion and Balance Sheet movement schedules

Confidential, Golden Valley, MN

Responsibilities:

• Planning System 11.1.1.3 migration
• Created Lifecycle Management automation
• Developed Outline loader automation

Confidential, Torrance, CA

Responsibilities:

• Planning Implementation
• Held Requirement and Design session with the client
• Created a detailed Project Plan

Confidential, Costa Mesa, CA

Responsibilities:

• System 11.1.1.3 support
• Created Partitions from ASO to BSO using Maxl
• Optimized calculations and business rules

Confidential, Carlsbad, CA

Responsibilities:

• Implemented Hyperion Planning System 9.3
• Created a pricing system using 8 business algorithms for sixty thousand sku’s
• Created 8 impact analysis reports
• Provided a secured and automated tool to facilitate the annual price adjustment process

Confidential, Newport Beach, CA

Responsibilities:

• Implemented Hyperion Planning System 9.3
• Management Reporting Application
• Workforce Planning Application
• Developed Maxl automation scripts
• Developed ASO database
• Migrated from Planning System 7.0 to 9.3

Confidential, Vancouver, BC

Responsibilities:

• Implemented Hyperion Planning System 9.3
• Management Reporting Application
• Workforce Planning Application
• Created Hyperion Planning Application including Workforce
• Developed Maxl automation scripts
• Updated and tested Confidential Allocation Business Rules
• Created automatic backup scripts using Esscmd
• Uploaded workforce data from Confidential
• Administered and maintain a multi-layered security at a user group level
• Migrated from DEV to Prod on a regular basis before going Live

Confidential, Broomfield, CO

Responsibilities:

• Implemented Hyperion Planning System 9.3 multi-application implementation
• Created Hyperion Planning Application including Workforce
• Built two ASO database for External Reporting
• Developed and executed Level 3 Communication Plan
• Client upgraded from Essbase 6.5.4 to System 9.3

Confidential, San Diego, CA

Responsibilities:

• Created and executed Hyperion Planning System 9.2 Design Documentation
• Built Confidential ’s Budgeting Application, which includes 3 currency databases
• Created 46 Allocation Scripts
• Created Workforce Database, calc script and member formulas
• Developed and executed Confidential ’s Plan

Confidential, Nashville, TN

Responsibilities:

• Assisted in Planning Installation
• Development Servers
• QA Servers
• Production Servers
• Migrated Planning and Essbase Application from Development to QA
• Updated design documents for Confidential, Audit and Global Applications
• Created Hyperion application links for outline updates
• Held Requirement and Design session with the client
• Developed currency calculation scripts based on UDA for Local, Reporting and Functional currencies
• Developed Requirement Docs and Design Documents for Integration
• Created User Acceptance Test Scripts (UAT) for New Essbase Cubes
• Developed and maintained a Reporting Package for 1600 cost center using Hyperion Reports 7.1.3
• Developed seven Planning Applications, which includes a Balance Sheet and Income Statement database
• Developed two BSO databases with Local and Global Views
• Developed one ASO database that reconciled the Local and Global Views
• Installed and Configured JExport extraction tool
• Developed JExport Scripts to extract data from 14 BSO databases

Confidential, Santa Fe Springs, CA

Responsibilities:

• Created Design Documentation
• Created a detailed Project Plan using MS Project
• Installed Hyperion Planning and components on two servers
• Created DCOM users and granted rights also configured the UDL’s and DSN
• Developed multi tiered planning application with multiple servers
• Configured the Hyperion Planning Web Server (Web Logic)
• Installed and Configured MS SQL and Essbase server
• Installed Hyperion Hub, Reports and EAS
• Customized Accounts Dimension for 15 different Charts of Accounts
• Developed Plan
• Created Documents
• Trained Admin users
• Trained End Users
• Trained Report Users
• Created Development environment for Hyperion Essbase

Confidential, Pasadena, CA

Responsibilities:

• Automated security updated and extractions for Hyperion Planning using SQL server
• Transferred data from Essbase 6.5.4 to Essbase 7.1 via Jexport
• Created back up process and procedures for Disaster Recovery
• Upgraded Hyperion servers to 650 gigs and Ram to 4 gigs
• Relocated Hyperion’s production boxes from Pasadena to Burbank and rebuilt all applications
• Launched Remedy for Hyperion to document and track issues and requests
• Trained International and Domestic Users on Budgeting and Forecast systems and processes
• Developed and created Hyperion Revenue cube for Confidential ’s Integration and workflow
• Developed forecasting process consisting of calc scripts and batch files for monthly forecasting
• Developed and maintain Hyperion reports for 80 cost center managers
• Created Essbase Application for the Commissionaire Structure which includes adding Region and Products
• Created a development environment for Hyperion Essbase
• Developed standard process for headcount load into the employee cube between Int’l and Domestic
• Implemented multi tier architecture for Hyperion

Confidential, Culver City, CA

Responsibilities:

• Created, maintained and documented nine multidimensional databases for Motion Pictures and Television
• Produced 24 financial packages using ESSBASE, MS Access and MS Excel with VBA API
• Created 10 DTS packages in SQL Server for ESSBASE data loads using Esscmd
• Created customized functions and procedures in Excel, Access and SQL Servers
• Created and maintained outlines and load rules in ESSBASE along with backing up and recovering databases
• Optimized ESSBASE databases using Application Manager and Esscmd

Confidential, Irvine, CA

Responsibilities:

• Implemented budgeting model to analyze $244m in revenues by channel and product brand for Managed Care profit and loss statements.
• Generated reports on a quarterly basis for Director of Finance and Vice President of Eye Care marketing
• Devised formula for calculating quarterly non-FAM pricing for Defense Personnel Service contracts
• Performed price-setting strategies of Skin Care Rx products by analyzing 36 SKU’s by contract and market. Summarized findings and presented strategy to save over $800,000 in contract prices
• Authored and produced sales presentation model using ESSBASE, Excel and Visual Basic Trained three managed care executives on application of model to increase sales
• Developed Excel Utilities with VBA