Financial Analyst Data

Michael D. Walter

919-***-**** ***********@*****.*** LinkedIn Profile

SR. APPLICATIONS ADMINISTRATOR

Detailed-oriented professional with over 20 years of software application experience and support from both a user and as a systems application administrator perspective. Supported Corporate and Entity finance groups’ analysis in key functional business areas.

Skills & Abilities

Project Management Software Implementation Technical Issue Resolution Teamwork Database Design & Management Calc Scripts / Load Rules Training FR Report Writing & Maintenance EPMA / Metadata Maintenance PROFESSIONAL EXPERIENCE

Duke University Health System (DUHS) – Durham, NC

Financial Reporting System Manager

Oracle Hyperion EPM System Administrator (HFM, Essbase, FR, Smartview) July 2010 – July 2018

• DUHS IT required a switch to a virtual server environment for the Oracle Hyperion EPM applications in 2014 o Effectively implemented & managed DUHS IT and Sierra-Cedar consultants in the migration & upgrade of Oracle Hyperion EPM 11.1.1.2 to version 11.1.2.3.5 in a virtual server environment o Completed the project 14 days ahead of schedule and under budget by over 20%

• DHTS required validation of a new service-based cost allocations methodology for Actual & Budget in SAP o Designed & Developed an Essbase cube to model Actual & Budget service-based Allocations using statistical data & a sophisticated Calc script to perform the layered Allocations o Saved over 60 FTE hours each period due to ending manual data modeling allowing in-depth analysis & improved reporting

• Duke Primary Care struggled to collect & analyze Physician data for performance and grant funding qualifications o Designed an Essbase database to collect DPC Physician data each Period and made available to management via Hyperion Reports – a more streamlined and efficient process o Eliminated a manual process by a DPC Analyst of data mining, managing a MS Access database & formatting Excel reports. Saved 3 days each period now invested in analyzing & providing information to management within hours instead of days.

Financial Management Analyst III – Hyperion HFM & Essbase Administrator July 2006 – June 2010

• Upgraded Hyperion System 9 to Oracle Fusion 11.1.1.2 due to support and Oracle purchase of Hyperion o Managed & worked with Oracle and Analytic Vision (AV) consultants throughout the upgrade to Oracle Fusion o Completed the upgrade under budget by 15% & ahead of schedule in addition to learning new software technology for application administration – HFM, EPMA & LCM

• DUHS FP&A acquired Hyperion Planning requiring a total upgrade of Hyperion 7 to Hyperion System 9 BI o Installed new servers and worked with AV consultants on the upgrade under a tight 2-month deadline o Completed the project before the Sept. 2008 deadline for FP&A and under budget by 10% o Reduced the reporting cycle by 8 days due to skills & abilities acquired and learned plus the capabilities of Hyperion System 9 BI Analytic Services (Metadata Integrity, Data Loads with ODI & Data Load Rules)

• DUH Finance required operational Excel Dashboards for Hospital Management o Designed multiple Excel data pulls using the Essbase Excel Add-In to automate & streamline the process o Saved dozens of FTE hours as a result of improved time and process management Financial Management Analyst III – Hyperion Enterprise, Essbase & FR Administrator June 2000 – June 2006

• DUHS required a Consolidation & Corporate Reporting System with the formation of Duke University Health System in late 1999 to be functional by end of September 2000 o Implemented Hyperion Enterprise and created DUHS Corporate Consolidated & Entity Financial Statements using Hyperion Reports

o Built the consolidation & reporting system 25 days ahead of schedule without any consulting expense resulting in huge cost savings and allowing KPMG to audit complete and accurate DUHS Financials.

• DUHS needed to progress in its ability to report consolidated financials as well analyze related Hospital utilization stats and various Health System statistical data

o Researched & consulted Hyperion Support to learn and educate myself on Hyperion Essbase to design a MDBMS/RDBMS OLAP database

o Moved DUHS Corporate Finance & Entity Finance groups to an OLAP Database & Reporting Solution with BI Analytics sooner than anticipated and saving thousands in consulting expense

• DUHS PRMO needed a streamlined & robust Management Reporting solution using Hyperion Reports o Designed multiple P&L and Statistical reports organized in multiple Departmental Report Books o Decreased PRMO’s monthly reporting cycle by 8 business days resulting in significant time and cost savings and improved departmental performance

Tricon Global Restaurants, Inc. – Dallas, Texas

Tricon Restaurants International Division (Pizza Hut, Taco Bell, KFC) Senior Financial Analyst – Hyperion Enterprise & FR Admin June 1998 – May 2000

• Prepared P&L, Balance Sheet, FOREX Gains & Losses, Intercompany Balance, Cash-Flow and Joint Venture Equity reports & schedules each period

• Re-Engineered the quarterly reporting schedules and reports using Hyperion Enterprise and Excel retrieves & macros Hoechst Celanese – Dallas, Texas

Global Chemicals Division & BPI Division

Senior & Staff Accountant July 1993 – May 1998

• GL Accounting including JVs, financial statement prep and account reconciliations for BHC joint venture

• Designed new GL Account structure for testing and move to SAP and Hyperion Enterprise

• Managed month-end close, analysis of special projects and S&A data prep for Annual Budget process EDUCATION

Abilene Christian University – Abilene, Texas

Bachelor of Business Administration in Accounting

Duke University Health System – Corporate Finance

Financial Management Program June 2007

*References available upon request

Contact this candidate