Hyperion z

Hai Quan

PO Box ******

Plano, TX *****

tel: 678-***-****

email: *********@*****.***

Experienced and certified Oracle/Hyperion EPM consultant with over 20 years of information technology and financial systems experience

Worked as functional and technical lead on Hyperion projects

Excellent knowledge of most EPM products including Essbase, Planning (PBCS/EPBCS), EPMA, FDM/FDMEE, ODI, Financial Reports, HFM, HPCM and HSF

Experience with the following industries: manufacturing, distribution, healthcare, banking, telecom, insurance, hospitality, government contracting and oil/gas

Working knowledge of ERP systems including SAP, PeopleSoft, EBS, JD Edwards and PRMS.

Educational Cornell University, College of Arts and Sciences

Background Bachelor of Arts; Economics Major

Skills Applications: Hyperion EPM versions 7.x to 11.1.2.4 (EPMA, Calc Manager, Business Rules, LCM, Shared Services, Essbase, EIS, Essbase Studio, Planning, PBCS, Financial Reports, HPCM, HFM, FDM/FDMEE, HAL, ODI, HSF, OBIEE), MS SQL Server, Oracle DB, MS Analysis Services, MS ACCESS, Oracle EBS, PeopleSoft, SAP

Operating Systems: Windows, UNIX (Solaris/Linux), ISeries(OS400)

Languages: Jython, ESSCMD, MAXL, MDX, Unix Shell/Windows Batch Scripts, PL/SQL, Perl, Java Script, VB, HTML, RPG/400 & IV/ILE, CL

Other: Ralph Kimball’s Methodology, Data Modeling

Certification Certified in Hyperion Planning and Essbase

Work Four Seasons, Toronto, CANADA

Experience Hyperion Consultant Feb 2017 - Present

Upgraded EPM Planning, HFM and HSF from 11.1.2.2 to 11.1.2.4 version

Migrated applications and reporting/analysis artifacts

Identified G&A cost reporting issues and worked on initiative to streamline G&A reporting

Harris, Melbourne, Florida

Hyperion Planning/FDMEE Consultant Aug 2014 – Feb 2017

Developed an enterprise balance sheet and cash flow planning application

Developed a divisional planning application to track programs and contracts PL

Optimized workforce, allocation and capex planning applications

Modified and optimized FDM/FDMEE processes and mappings with Jython scripting customization

Upgraded EPM Essbase, Planning, FDM/FDMEE and HFM

Reviewed HSF application

ClubCorp, Dallas, Texas

Hyperion Planning/FDMEE Consultant Aug 2015 – Dec 2015

Developed a new EPM solution encompassing BS, PL, CashFlow and Statistical data utilizing HFM, Essbase, FDMEE and PBCS to replace a legacy consolidation application

Created FDMEE process with drill-through capability to source actuals directly from Oracle EBS

oUsed Jython scripting for mapping and import customization

Developed admin and end user documentation and training

YP, Atlanta, Georgia

Hyperion Essbase Consultant Apr 2014 – Aug 2014

Assessed Essbase environments and provided recommendations for improvements to key infrastructure processes including tuning, troubleshooting, backup, disaster recovery and upgrade procedures

Modified and optimized backup process and Essbase cubes.

Worked on OBIEE reporting

Upgraded EPM versions

MarkWest, Denver, Colorado

Hyperion Essbase/FDMEE Consultant Dec 2013 - Mar 2014

Developed and optimized multiple ASO cubes

Worked with key business user in FP&A on gathering requirements for Essbase reporting

Created FDMEE process for loading flat files from non-ERPi source system with Jython scripting customization

Upgraded FDMEE process for loading Oracle EBS source into Esbase ASO cubes to include additional ledgers

ATT, Atlanta, Georgia

Hyperion Planning Consultant Jan 2013 – April 2014

Developed multiple planning applications which include multiple business unit apps and a consolidated app

oUtilized replicated and transparent partitioning and EPMA

Provided planning infrastructure support

Performed patching, tuning and migration activities across all environments

Newell RubberMaid, Atlanta, Georgia

Hyperion Planning Consultant May 2011 – Dec 2012

Participated in requirements gathering for new planning and reporting applications

Led and implemented EPM 11.1.2.1 Planning and Essbase reporting project

oUtilized partitioning, custom multi-currency translation calc scripts, batch and maxl scripts automation to move planning inputs to ASO reporting cube

Developed FDM automation process for moving data between ERP SAP source files, HFM, Hyperion Enterprise and Essbase/Planning

Provided technical support and end user training.

Intercontinental Hotels Group, Atlanta, Georgia

Senior Hyperion Architect/Developer May 07 – May 2011

Technical lead for Hyperion infrastructure with experience in upgrades

Led and developed various Essbase and Planning projects sourcing from PeopleSoft and DW

oGathered requirements from business for enhancements on existing essbase projects

oDeveloped key application to help worldwide hotels benchmark against their peers for collaboration and improvement of KPIs

oDeveloped complex planning application which included custom workforce plan type

Developed and maintained HSF and its ETL process from Essbase

Provided technical support to Financial Reports and Web Analysis development

Managed and coordinated patch activities and production support issues with data center and production support team

IBM, Atlanta, Georgia

Hyperion Planning Developer May 06 – May 2007

Provided lead support for implementation of System 9.2 planning software installation

Involved in all technical and functional aspects of new planning application development using Hyperion System 9 platform

Developed planning application outline, data load rules, calculation scripts, business rules and web forms and setting up tasks list and security

Scientific-Atlanta, Atlanta, Georgia

Hyperion Essbase Architect/Developer June 04 – May 06

Led new development of analytic applications utilizing Hyperion Essbase, EIS, Analyzer and Hyperion Reports sourcing from SAP

Responsible for business requirements gathering, OLAP/relational data modeling, designing ETL specifications, Essbase development, deployment and QA/Performance tuning

Provided classroom and individual Essbase and Analyzer training to financial analysts

Responsible for maintenance and Hyperion software upgrades

Presented status of Hyperion application development at monthly controller meetings

CMD Systems, Atlanta, Georgia

Hyperion Essbase Developer November 00 – June 04

Implemented full cycle data warehousing and BI projects using SPSS Showcase Essbase, Analyzer and other products on the AS400 platform (V5R1).

Installed and configured Essbase onto Window Server and ISeries platforms.

Designed and implemented reports using Analyzer, Report Writer, Hyperion Reports and Query.

Utilized Warehouse Builder, RPG and CL to perform ETL.

Ensured quality of data warehouse and data mart data.

Performance tuned Essbase data marts.

Trained users on using Analyzer and Excel Add-In functionalities.

Performed version upgrades of Essbase and Showcase environments.

Involved in proof of concept demonstrations for potential engagements.

Cardinal Health, Inc., Columbus, Ohio

Programmer/Analyst April 00 – November 00

Maintained and supported existing purchasing application.

Developed new reporting and interface programs using RPG/ILE, CL, FTP, DDM, Triggers and embedded SQL.

Worked with end users on issues and design of applications. Created test scripts for end users.

marchFirst, Inc., Cleveland, Ohio

Consultant April 98 – April 00

Maintained and enhanced distribution/order entry modules for a manufacturing client.

Developed and implemented RPG/ILE and CL programs with SQL to interact with WEB-based customer inquiry system utilizing Domino and MQSeries on the AS400.

Involved in a PRMS 8.4 upgrade for a medical supplier client.

Involved in several new installs and upgrades of PRMS 8.4 for clients in manufacturing and distribution industries.

Medical Mutual of Ohio, Cleveland, Ohio

Programmer/Analyst October 97 - April 98

Involved in the conversion of a mainframe claims application to a client-server application utilizing Sterling Software CASE tool Composer.

Wrote JCL back-up programs for DB2 database.

Involved in various database maintenance assignments.

New Resources, Inc., Cleveland, Ohio

Consultant January 97 - October 97

Programmed various assignments on the AS400 using CL RPGIII and RPG/ILE.

Upgraded PRMS to V8.4 for a manufacturing company.

References will be available upon request.

Contact this candidate