HYPERION QUALIFICATIONS EXPERIENCE HISTORY

Comprobase and Hyperion since 2004

HYPERION

│ QUALIFICATIONS │EXPERIENCE │HISTORY

Hyperion Planning

∥

Hyperion Financial Management

∥

Essbase

CapEx Planning

∥

WorkForce Planning

∥

Public Sector Planning

Financial Reporting ∥ Financial Data Quality Management ∥ Data Warehouse

R e c e n t P r o j e c t s & C l i e n t s

Hyperion assets of Comprobase have worked as relied upon contributors with the following companies fulfilling roles as Prime Contractor ⇀ Project Manager ⇀ Technical Lead ⇀ Functional Lead ⇀ Developer

DEPT of LABOR AARP NJVC VERISIGN

AAA PANASONIC QUANTA SERVICES AVON

JDS UNIPHASE LIGHTSQUARED METRO WASHINGTON NEUSTAR

ENVIRONMENTS

*Hyperion implementation performed for the companies above with Comprobase assets or as Comprobase as Prime

U.S. House of Representatives

║

Washington, DC

║May 2014 to Present ║Sr. Project Manager

Scope:

The Hyperion Budget and Planning implementation is an enterprise solution able to provide a tool to support various ongoing US House of Representative (“House”) budget and planning processes. The delivery of the Hyperion Budget and Planning module will seek to eliminate manual processes and improve functionality with a best in class application that eliminates manual data load, forecast worksheet creation, dissemination and collection with effective automated data load tools in a universally designed, connected application and database.

 _{Automation of processes for execution of hundreds of manually liked spreadsheets and}

reports that manually distributed and consolidated by various analysts and business points of contacts.

 _{Automation of data loads from the sources systems so data has to be extracted formatted and}

validated manually in these projection and formulation Excel worksheets.

 _{Replacement of Excel workbook being sent via email between reviewers and approvers with}

notes and supporting documentation for the approval being stored in excel notes and in email etc.

 _{Creation of audit of the communication and approvals in a single system across the entire}

execution and formulation data sets.

 _{Budget Formulation}

o House Budget Justification Document o _{Sub-Committee Print}

o _{Budget Formulation Templates and Exercises}

 _{Budget Execution (Forecasting) Activities}

o _{Monthly Projections Reports}

o _{Monthly and Quarterly Variance Reports} o _{FTE Management Reports}

 _{Budget Execution Reporting}

o _{Fiscal Year to Legislative Year Comparison Reports} o _{Government Contributions Report}

o Various Ad-Hoc Reports back to top ↑

American Red Cross

║

Washington, DC

║Oct 2011 to Apr 2013 ║Sr. Project Manager

Scope:

 _{Provided leadership and direction in all areas of this global multi-phase Hyperion Planning}

implementation.

 _{This included overall project plan creation, scope definition and maintenance, oversight and}

participation in requirements gathering, gap analysis, build development, system testing, systems architecture and integration, training, deployment and post production support.

 _{Responsible for System Integration (SI) vendor resources, independent contractors, as well}

as the client resources to a successful roll out of the system and a smooth transition to internal Red Cross employees

 _{Coordinated the identification, prioritization and resolution of project related issues with all}

participating groups

 _{Conducted steering committee meetings to update executive management on overall project}

status and obtain executive level direction on critical project related issues that could potentially impact timely and budgetary project completion

 _{Project cost budgeting, tracking and reporting to stakeholders and executive management}

with on time and on budget delivery of a full budget solution. back to top ↑

Fannie Mae

║Washington DC ║Oct 2011- Present ║Hyperion Consultant Team Lead

Scope:

 _{Implementation of Hyperion Planning application including Hyperion Reports, SmartView,}

and Essbase v11.1.2.1

 _{Participated in the requirements gathering efforts of the project for expense related}

Planning processes

 _{Drafted requirements documentation for Hyperion Planning applications and used}

Requisite Pro to store and tag requirements for mapping to test cases in Quality Center

 _{Developed test cases that were used in UAT}

 _{Drafted user acceptance test (UAT) plan documentation for Hyperion Planning and FDM}

applications

 _{Created, designed and formatted technical specification documentation, such as}

architecture diagrams, process flows, and other processes needed to describe required system changes for development

 _{Performed user acceptance testing (UAT) for various Hyperion Applications}  _{Updated, maintained and ran tests in Quality Center}

 _{Drafted and compiled final results summary documentation for UAT testing, including Test}

Summary, Requirements Traceability Matrix (RTM) created with BOXI Reports, Defect report from ClearQuest, Incident Report from Remedy, and the test Execution Report generated from Quality Center

 _{Assessed business operations and processes to understand procedures, information flows}

and handoffs, decisions, communications pathways and the like

 _{Managed the defect capture, reporting and resolution process during UAT using IBM}

Rational ClearQuest

 _{Migrated Hyperion Planning artifacts from TEST to PROD using Life Cycle Management}

(LCM) and performed validation and shake out in the PROD instance back to top ↑

Volkswagen Group of America

║

Tysons Corner, VA ║Mar 2011 – Present ║Hyperion Conslt

Scope:

 _{Worked extensively on Planning application for Planning, Budgeting and Forecasting,}

Hyperion Financial Reports, and Webforms for Planning users

 _{Collaborated in technical specification preparation}

 _{Created several web forms depending on the requirement in Hyperion Planning}

SmartView and web using Workspace

 _{Maintained data base for optimum performance for using Calculation Scripts and Business}

Rules

 _{Performed data migration from v9.3 to v11.1.1.3}

 _{Used Essbase to deliver meaningful insights for managing finance}  _{Conducted tests to analyze if the data is behaving as expected}  _{Integrating Hyperion with PeopleSoft Financials}

 _{Installation of Essbase Administration Services, Essbase Integration Services, Hyperion}

Reports, Hyperion Analyzer and Hyperion Application Link in Windows environment

 _{Deploying Hyperion Planning v11.1.1.3 in different environments}

 _{Developed reports for the regulatory purpose in Excel–Add in and Standard Reports in}

Hyperion Reports

 _{Process automation using ESSCMD and MaxL Scripts}  _{Generated different reports using Smart View}

 _{Developed load rules for loading specific type of data files}

 _{Supported users during User Acceptance Test (UAT) by troubleshooting and resolving}

outstanding issues/problems faced by users

 _{Created reports understanding and analyzing the Stored Procedures}

 _{Created reports using SQL Statements for DB2 database back to top ↑}

Department of Labor

║

Washington, DC ║Apr 2013 – Present ║Project Lead

Scope:

 _{Provided leadership and direction in all areas of this Hyperion Essbase Reporting Application}

implementation. This included overall project plan creation, scope definition and maintenance, oversight and participation in requirements gathering, gap analysis, build development, system testing, systems architecture and integration, training, deployment and post production support.

 _{Responsible for project resources, independent contractors, as well as the client resources to}

a successful roll out of the system and a smooth transition to internal Red Cross employees

 _{Coordinated the identification, prioritization and resolution of project related issues with all}

participating groups

 _{Conducted steering committee meetings to update executive management on overall project}

status and obtain executive level direction on critical project related issues that could potentially impact timely and budgetary project completion

 _{Project cost budgeting, tracking and reporting to stakeholders and executive management}

with on time and on budget delivery of a full budget solution.

 _{Responsible for review and finalization of solution architecture with DOL senior management.}  _{Continue to work with senior and executive management to provide guidance on solution}

AARP

║

Washington, DC

║Sep 2011 to Jul 2012 ║Sr. Project Manager

Scope:

 _{Worked as a technical lead for the implementation of Hyperion Planning and Reporting}

application.

 _{Designed and implemented 3 Year Strategic Plan and Annual planning for corporate}

wide budgeting and quarterly forecasting for Expenses, Workforce, CapEx planning.

 _{Organized design sessions to gather requirements from planning users. Created test}

scripts and ran CRP and UAT sessions. Sourced data from JDE General Ledger and Fixed Assets module; PeopleSoft HR module. Created corporate allocation scripts.

 _{Customized Workforce module to accommodate calculations based on specifications}

from different Affiliates within AARP.

 _{Created staging database (Oracle), tables, procedures for ODI interfaces. Ran ETLs to}

populate the staging tables and updated Hyperion Planning through ODI. Developed ODI interfaces, packages and procedures to extract and load data and metadata from Oracle EBS 11g and fed into Planning and Essbase.

 _{Converted manual processes to automated ODI interfaces. Created scenarios to run at}

scheduled time through ODI agent. Created Forms, Calculations, Analytical Metrics, Business Rules, Security and Financial Reports during the course of implementation. Created migration scripts and migration strategy to move application across

environments.

 _{Designed and created FDM interfaces to load to Essbase. Created load scripts and}

validation rules in FDM. Created load locations, control tables, import formats, mapping tables. Created batch loading of files.

 _{Key Objectives of consulting services provided were application design, architecture}

design, business model, backup strategy, and admin document. back to top ↑

NJVC

║ Tysons Corner, VA ║Dec 2011 to Oct 2012 ║Sr. Hyperion Developer

Scope:

 _{Implemented Oracle Hyperion 11.1.2.1; Planning, Public Sector Budgeting, FDM, ODI, and}

Financial Reporting

 _{Integrated to Oracle eBS r12}

 _{Developed drill-thru capabilities with FDM for vendor and project details for expenses and}

revenue

 _{Automated all revenue models to be calculated within Hyperion planning system}

 _{Calculates all the various indirect rates; Fringe, Company Overhead, Customer Overhead,}

G&A, and Material & Purchasing rates

 _{Public Sector Budgeting module facilitates budgeting and forecasting workforce and}

VeriSign

║Herndon, VA ║Feb 2011 – Present ║Technical Hyperion Lead / Administrator

Scope:

 Hyperion Technical Lead responsible for the upgrade from sophisticated environment of v9.3.1 to v11.1.2 for Hyperion Planning and Essbase EIS ASO Reporting cube

 _{Defined the To-Be application architecture needed to support EIS and Planning}

 Installed in DEV and TEST the latest version of Hyperion components: Foundation Services, Planning, EAS, EIS, Financial Reporting Studio, ODI, in a distributed Windows and Linux environment

 _{Exported EIS models and meta-outlines from v9.3.1}

 Imported EIS model and meta-outlines and validated the imports. Updated EIS models with the appropriate custom SQLs used in building the outlines for Balance Sheet, Income Statement, and Trend cubes and loading data

 _{Updated the Meta-outline for all drill through reports connections}

 Updated 20+ shell Scripts used to automate the metadata, data loads and reconciliations between the client enterprise EDW and Essbase ASO cubes for PandL, Balance Sheet and Trended reporting

 Defined and designed the technical upgrade strategy for Hyperion Planning from v9.3.1 to v11.1.2

 _{Converted 60+ HAL to ODI integrations for loading metadata and data into the new} Planning

 Reviewed and cleaned-up metadata in staging table process to clean-up the Hyperion Planning application

 _{Rebuilt all forms in the new version of Hyperion Planning}

 _{Migrated security, Calculation Scripts, business rules, and reports to the new version of} Hyperion Planning

 _{Defined and executed conversion from the old Hyperion environment to v11.1.2 Planning} cubes

 Participated in CRP and UAT for both the EIS/Essbase and Planning upgrade work-streams  Developed migration approaches and assisted the client where needed on the migration

from TEST to Production

 _{Created training material and conducted training for application administrators}

 Provided post production support as needed back to top ↑

AAA Northern California Nevada Utah

║CA ║Dec 2011 to Present ║Sr. Hyperion Developer

Scope:

 _{Support Hyperion production environment 24x7 for Budgeting, Forecast, 10 years budget}  _{Load metadata, data into Planning, Essbase}

 Run ODI interfaces, EPMA profiles to load metadata

 Develop and migrate applications, artifacts across Dev, Test, Prod  _{Backup the applications, artifacts on regular basis}

 _{Installation of Hyperion Application patches} back to top ↑

Panasonic Avionics

║ Lake Forest, CA ║May 2011 – Feb 2012 ║Hyperion Planning / Essbase /

Workforce / CapEx Administrator

Scope:

 _{Plan, Install, Configure, and Administer Hyperion v11.1.2; Hyperion Essbase and Hyperion}

Planning Windows environment with both physical and virtual servers

 _{Lead team through Development, Go-Live, Support and Maintenance tasks}

 _{Create/Maintain automation Scripts, and maintain responsibility for creating and updating}

system documentation

 _{Identify, implement and test patches and upgrades and maintain up-to-date}

documentation of Hyperion-related configuration

 _{Trouble-shoot and resolve process, functional and technical issues}  _{Create, modify and maintain BSO Essbase cubes in Essbase v11}  _{Modify, Maintain and trouble shoot Hyperion Planning Applications}  _{Investigate issues in reports or cubes and provide root cause analysis}

 _{Train end-users on how to use the Workspace to complete their budgeting and forecasting}

tasks

 _{Set up, manage and maintain user security through Shared Services}  _{Migrate Planning and Essbase applications from one environment to other}  _{Develop Interfaces and Packages in ODI to load data into Essbase and Planning}

applications

 _{Recommend corrective actions for technical systems issues, taking into account user}

needs and IT resources

 _{Import and manipulate data from multiple disparate systems Flat files, Essbase, Oracle and}

Excel sheets

 _{Monitor application performance, availability, and utilization}

 _{Maintain Accounting structure and outline metadata for online reporting}

 _{Provide user support, security and other ad hoc requests back to top ↑}

Quanta Services

║Houston, TX ║Jan 2011 – Feb 2011 ║Hyperion Administrator

Scope:

 _{Reverted back to classic Planning application from running v11.1.1.3 of Hyperion Planning} EPMA application

four new ODI packages for metadata and data loads pointing to new classic Planning application

 _{Re-created batch Scripts for automating the overnight application data loads using ODI}  _{Re-created and modified few existing web forms and reports that had longer execution}

times

 _{Fine-tuned the Essbase database for data loads by modifying the cache sizes}  _{Assisted in restructuring the Planning security in shared services for Production and}

Development environment (Group wise security setup)

 Assisted in requirement gathering for a new Test environment that client planned upon having other than existing PROD and DEV

 _{Documented the whole ODI data flow process for the new Planning application that was} seeding data out of an ASO accounting cube back to top ↑

Avon

║Rye, NY ║ Aug 2011 - Nov 2011 ║Sr. Hyperion Developer Project Lead

Scope:

 _{Installation and configuration of HFM, FDM, DRM, Essbase, Planning on multiple servers}  Migration of the FDM, HFM, DRM and Planning Applications from v9 to v11.1.2.1 and testing  _{Configure Shared Services with MSAD}

 _{Migrate the Financial Reports from v9 to v11.1.2.1}

 _{Migrate the security for Hyperion Suite from v9 to v11.1.2.1} back to top ↑

JDS Uniphase

║Milpitas, CA ║May 2010 – Mar 2011 ║Hyperion Consultant

Scope:

 _{Conducted high-level and detailed meetings with the various personnel in the Arrow Asia}

from Senior Management CIO, Senior VP’s, Marketing and Sales Specialists to thoroughly understand their requirements and opinions and arrive at a comprehensive view of the Products and Services of Arrow Asia

 _{Worked on Essbase Integration Services (Metadata workflow/filters/drill through reports}

using Hybrid Analysis)

 _{Developed and maintained Calc Scripts, MaxL Scripts, batch Scripts to automate data}

load/Calculation

 _{Designed and maintained Essbase Cubes, CapEx Planning, Workforce Planning, Planning}  _{Implemented Calculation engine that includes robust mathematical functions for}

computing derived data, used Essbase functions and Calculation commands to develop the Calc Scripts deriving managing costs, increasing revenues and markdowns

 _{Involved in Optimization and Performance tuning of Cubes/Outline/Data load/Calculations}  _{Created Web Analysis reports for the users for those reports where they wanted to use the}

Drill down Functionality effectively and some Ad-hoc reporting

 _{Data Analysis reports generation through Planning for Arrow Asia Executives, Prepared}

Sales Reports which detail Price, Volume, company products and market Trends, and Expense Variances over prior periods in different markets

 _{Support existing Supplier Services cube, Outline and Calc Script updating, scheduling}

batch Scripts, problem identification, resolution and documentation back to top ↑

LightSquared

║Reston, VA ║Oct 2010 - Apr 2011 ║Administrator Planning / FR

Scope:

 Involved in The requirements gathering, and had a role in creating the Design document

and LOE documentation

 The project involved implementing a new budgeting cube for the existing General Ledger  Installed Hyperion Shared Services, Essbase administration services (EAS), Hyperion

Planning, Workspace, Financial Reporting Studio, Web Analysis, for v11.1.1.3 over multiple servers. Also installed ODI and SQL

 Wrote SQL Scripts to bring in data from Oracle EBS for GL and populate SQL staging tables

Used ODI to create dimensions and load data

 Used the Oracle Project costing to bring in the projects data and created a budgeting cube  Created numerous web forms to enter, update, analyze, print, and report on data

 Created Task lists to ease the work of the users when working with the web forms  Developed and maintained Web Forms, Task lists and Planning Units and managed

security for the same

 Initiated, developed workforce Planning cube with metadata and data from oracle HR with

their existing employees

 Created business rules to Add/Remove employees, plan departures, transfers, add/remove

benefits, plan TBH’s and budget the employee expenses

 Created a number of new users in the native directory meeting with their security

standards, setup user and group level securities using shared services and implemented dimension level security

 Created a number of Reports for their existing Application and for the new Planning

application as well

 Created PandL variance reports, Expenses by departments-Activity-product-project in a

monthly-quarterly-yearly, using some complex FR functions, used UDA’s in the reports when needed

 Created numerous Ad-hoc reports with Smart view

 Prepared Training documents for the end-users and was responsible for their training, for

Metropolitan Washington Airports Authority

║Washington, DC ║Sep 2010 - Jul 2011 ║Sr.

Hyperion Developer

Scope:

 _{Optimization of data forms, report Scripts, Calc Scripts, business rules}  _{Development of Financial Reports}

 _{Created the Shell Scripts to automate the build of outline using outline load utility}  _{Created shell Scripts and MaxL Scripts to load Actual and Budget data}

 _{Creating users groups and assign access permissions}

 _{Data reconciliation using Essbase spreadsheet add-in/Smart View}  _{Interacting with users for the enhancements}

 _{Performance Tuning of Database modifying the cache and Essbase.cfg file settings}  _{Installation and configuration of Hyperion Essbase, Planning, Scorecard, Financial Reports}

in new Dev, Training, UAT, Dry Run, Prod environments

 _{Migration of the Planning Application from Dev to different environments}

 _{Migration of Calc Scripts, Business rules, Task lists, Menus, Dataforms, Security using LCM}

back to top ↑

Neustar

║Sterling, VA ║Jun 2010 - Oct 2010 ║Hyperion Planning / FR Reports/ Admin

Scope:

 Requirements gathering, and had a role in creating the Design document

 _{Implementing a new Project Budgeting cube. Worked closely with IT and Business and} Functional consultants to finalize the Project Cube design

 Installed Hyperion Shared Services, Analytic Administration Services (AAS), Hyperion Planning, WorkSpace, Financial Reporting Studio, Web Analysis for v9.2 in all the environments

 Used HAL to create dimensions in the Planning application  Created new dimensions to meet the application demands  Created a Hyperion Planning Application to Forecast the Budget

 _{Created a number of web forms to enter, update, analyze, print, and report on data}  Created Task lists to ease the work of the users when working with the web forms  Developed and maintained Web Forms, Task lists and Planning Units and managed

security for the same

 _{Developed a few complex Business Rules and attached them to the web forms}  Created a several Calculation Scripts

 Created a number of new users in the native directory meeting with their security standards  _{Setup user and group level securities using shared services}

 Created dimension level security for each of these users/Groups

 Created multiple Reports for existing Application and for the new Planning application: PandL variance reports, Expenses by departments-Activity-product-project in a monthly-quarterly-yearly, using some complex FR functions, used UDA’s in the reports when needed

 Created several Ad-hoc reports with SmartView

 Created Web Analysis reports for the users for those reports where they wanted to use the Drill down Functionality effectively and some Ad-hoc reporting

 _{Prepared profitability reports detailing price/volume trends and expense variance over} previous periods by using Financial Reporting and Web Analysis

 Prepared Training documents for the End-users and was responsible for their training, for administration and support

 Created automated backups procedure for the application

 Created an archive cube to save the data every week, from the Planning application to a standalone Essbase application for the reporting needs of the client and automated this

E N V I R O N M E N T S

Performance Management Applications Oracle Hyperion Analytics

Hyperion Planning & Budgeting Hyperion Essbase

11.1.2.2 11.1.2.1 11.1.2 11.1.2.2 11.1.2.1 11.1.1.3 11.1.1.3 11.1 9.3.1 11.1 9.3.1 9.2

9.3 9.2.0.2 7.1 7.1 7 6.5.4

3.5.1 3.3 6.5.1 6.2 6

Hyperion Financial Management Essbase Administration Services

11.1.2.2 11.1.2.1 11.1.1.3 11.1.2.2 11.1.2.1 11.1.1.3

11.1 9.3 11.1 9.3.1 9.3

WorkForce Planning / Public Sector Planning Essbase Integration Services

11.1.2.2 11.1.2.1 9.3.1 11.1.2.2 11.1.2.1 11.1.1.3

9.3 PS P&B 11.1.2.2 11.1 9.3.1 9.3

CapEx Planning Essbase Studio

11.1.2.1 11.1.1.1 9.3

Hyperion Business Rules

11.1.2.2 11.1.2.1 11.1.1.1

9.3.1 9.3 4.x _{ERP Integration Experience}

3.x

PeopleSoft HR - Financials

Essbase Analytics Link for HFM

eBusiness Suite Financials Financial Management Analytics

Lawson Financials Calculation Manager

Data Management Integration Tools

Data Integration Management Fusion Edition Oracle Data Integrator

11.1.2.x 11.1.1.x 9.3.x 11.1.2.2 11.1.2.1 11.1.1.3 10.1.3.5 10.1.3 9.3.3

Financial Data Quality Management

11.1.2.x 11.1.1.x 9.3.x Informatica

8.6 8.5 8.1

Data Relationship Management 7.1.2 6.2 5.1

11.1.2.2 11.1.2.1 11.1.1.1

Analytic Services (Essbase) Data Integration Management

11.1.1.1 9.3.1 9.3 Application Manager

Foundation Analysis and Reporting

Enterprise PMA Hyperion Financial Reports

11.1.2.x 11.1.1.x 9.3.x 11.1.2.x 11.1.1.x 9.3.x

Hyperion Workspace Hyperion Financial Reporting Studio

11.1.2.x 11.1.1.x 9.3.x 11.1.2.x through 3.x

Hyperion Shared Services Hyperion Web Analysis

11.1.2.x 11.1.1.x 9.3.x 11.1.1.x 9.3.x 4.x

9.2.x

Hyperion Interactive Reporting

Hyperion Life Cycle Management 11.1.1.x 9.3.x 9.2.1

11.1.2.x 11.1.1.x 9.3.x

Hyperion Workspace

Hyperion Smart View 11.1.2.x 11.1.1.x 9.3.x

11.1.2.x 11.1.1.x 9.3.x

Database Operating Systems

11g 10g 9i Windows 2008 Windows 2003 XP Pro

8i MS SQL 2008 MS SQL 2005 2000 Pro Linux HP-UX 11.0

MS SQL 2000 IBM DB2 Solaris 9 Solaris 7 Solaris 2.6

AIX

Application Servers

OAS Web Logic 10.x Web Logic 9.x Languages

Web Logic 8.1 WebSphere 7 WebSphere 6.x MaxL ESSCMD SQL

WebSphere 5.x Tomcat Apache PL/SQL Shell Script Batch Script

Calc Script MDX XBRL

Graphic User Interface Tools

TOAD VMWARE MS-VISIO

CONTACT US