Financial Systems Analyst Hyperion / EPM Administrator Resume Example Dex Media

FINANCIAL SYSTEMS ANALYST - HYPERION / EPM ADMINISTRATOR

Summary

Over a decade of experience as financial analyst in a corporate finance environment successfully holding positions in General Ledger Accounting, Accounts Payable , Revenue and Financial Reporting. provide a basis for systems administration success. The past six plus years have been in a systems role developing, implementing and administrating the Oracle Hyperion Enterprise Performance Management suite version 11.1.2.1 and the A3 Solutions -A3 Modeling planning platform in support of FP&A forecasting, budgeting and strategic planning cycles. Implemented Hyperion Shared Services, Essbase Administration Services, WorkSpace, Studio, Calculation scripts, Filters, Load Rules , RDB Configuration and Essbase, Essbase Excel Add-in and Smart View. Functional Knowledge of Income Statement, Balance Sheet and Cash Flow Statements, Forecast and Budget Planning Cycles. Recognized for innovation , customer focused ,excellent communication and interpersonal skills., amazing ability to manage under pressure and dedicated to completing the job with a positive attitude and happy. Yep, Happy!

Highlights

Oracle EPM / Hyperion v11.1.2.1
Essbase
A3 modeling
Implementing new business systems
PeopleSoft knowledge
Oracle eBusiness suite
Active Directory (LDAP, MSAD)

Financial Reporting - IS, BS & CF Monthly, 10Q & 10K, Actuals,
Outlook & Budget Planning
Accounts Payable - Interfaces, Analysis, & Reporting
Revenue - Interfaces, Analysis, Reporting
New technology and product research
IT security policies
SOX Compliance

Accomplishments

Negotiated a reduced Enablement Fee with Oracle savings of $150k.

Selected to be on integration "away" team to develop merger systems integration strategy.

Experience

Dex MediaOctober 2009 to February 2015Financial Systems Analyst - Hyperion / EPM Administrator
Dallas, TX

Upgrade FP&A systems to Oracle EPM / Hyperion 11.1.2.1 from Enterprise 6.5. All Aspects including Infrastructure configuration ( WindowsServer2008R, 64bit, Oracle DB 10), Migration of Data, Outlines, Calculation.Scripts, Business Rules , Security, Filters, (150 users, Externalized, Filters)
Negotiated Reduced Oracle Enablement fee. Saving $150k
Oracle EPM Suite administration - Shared Services (LDAP, MSAD), Hyperion Workspace, Hyperion Studio, Hyperion Essbase, Hyperion Calculation Manager , Infrastructure, Calculation Scripts, Business Rules, Esscmd, Maxl, Essbase Addin, Smart View, A3 Modeling Addin.
FP&A Planning Cycles Systems Support - Forecasts, Budget and Strategic Planning
A3 Solutions -A3 Modeling Platform upgrade to v2011 & Administrator
Integrated Multiple Hyperion/ EPM Environments for Merger Synergies.
Hyperion Strategic Finance(HSF) Integration, planning and development and Integration.
PeopleSoft GL, A/P , Interfaces, GLOuterfaces, Release Planning, SOX Documentation
Oracle ebusiness suite - Admin/User Access
Responsibilities:
Hyperion 11.1.2.1Administration / Oracle EPM 11.1.2.1, A3Modeling, Essbase (addin&Smart View) ,
Outlook and Budget Planning Cycle support
Financial Data import from ERP (PeopleSoft) - Load Rules
HR Data import from HRDW ( Ultipro) - Load Rules
Reporting - Template maintenance & development - A3 Modeling
Security/End user - 150 User, Database Access, Provisioning (SS), Filters (EAS).

SuperMedia April 2004 to September 2009Financial Analyst - Revenue
Dfw Airport, TX

On time Reporting - Revenue Revenue Amortization - Analysis, Journaling, Reporting Sales Allowance & Bad Debt - Analysis , Journaling and Reconciliations.
Board Report - Cash Collections, AR Walk Forward, Billing and Collections, Unbilled Revenue Analysis of eCom - PayPerClick/PayPerCall., Sales Promotions Revenue Interfaces to PeopleSoft via RAPID - VBS (Billing), MBS (Misc.Billing), RAPID (Amortization) Revenue Recognition / Amortization - Analysis& Journals Billing Systems Interfaces - MBS, VBS, RAPID Pay for Call(PFC)/Pay Per Click (PPC) data import Revenue Journals - Bad Debt, Cash Collections, Amortized Revenue.
Reporting - Cash Collections, Accounts Receivables Walk Billing System maintenance.

Verizon Information ServicesFebruary 2002 to March 2004Financial Analyst - Financial Services A/P
Dfw Airport, TX

A/P transition project lead.
Transitioned $1.3M budget, 190k A/P Dept. from Middleton, Mass to Dallas, TX. Three months to transition, staff, and begin operations
Transition responsibilities: Planning the system transition, Developing project deliverables, job function transition, IT requirements, and staffing, training, supervision. Completed on time and on budget.
Accounting Supervisor A/P: Domestic and International processing, Purchasing card, administration, Employee expense reimbursement administration, Expenditure policy training and research.
Security investigations.
Supervise 7 Accountants: Objective devedevelop, training, and evaluations.
Implemented Web-Base reimbursement application: Three thousand users, two hundred trained via live web classes. Remaining completed self study training.
Completed implementation with minimal costs and on schedule.
development of A/P Outlook, submit via Essbase powered application.
Annual development of A/P budget, submit via Essbase powered application.
Five year Strategic plan development.
Supervised four AP associates and three AP accountants
Purchasing Card administration and interfaces with Chase & American Express.
Employee Expense reimbursement processing and application admin and support.
Expenditure policy training
Security Investigations.

GTE Directories / Verizon Information ServicesJune 1997 to February 2002Financial Analyst
Dallas, TX

Reporting & Hyperion Enterprise Administration Hyperion Database Administrator for business segment.
Responsible for actual, outlook and budgets applications.
Responsible for all: Report building, Report Packages, consolidation of domestic and international entities, logic maintenance, user support, conversion tables, VB conversion programming, account maintenance, end user Training, Y2K adviser, all admin duties.
Monthly, quarterly 10q and annual 10k reporting coordinator.
Financial statement variance analysis to Budget, Outlook and Industry.
Essbase engine budgeting system testing.
Compatibility with Enterprise, Peoplesoft, and IT environment.
YPPA Benchmarking reporting (Essbase).
1998 PUC Rate Case reporting (Essbase).

Education

University of TexasMay 1994Bachelor of Business Administration: AccountingArlington, Tx

S.M.U - School of Engineering & Applied Sciences2000Information Technology Program - MSCEDallas, Tx

Skills

Hyperion 11, Oracle EPM, , Planning, Financial Management, , Strategic Finance, Essbase, Smart View, Shared Services(SS), WorkSpace, Studio, Administration Services(EAS), A3 Modeling, Interfaces, Accounting, Accounts Payable, Accounts Receivables, AP, A/P, AR, Benchmarking, Billing, Billing System, Billing Systems, Budget analysis, Budget Planning, budgeting, budgets, Budget, conversion, Database, Documentation, eBusiness, ERP, Essbase, Finance, Financial, Financial Analysis, Financial Reporting, GL, HR, Hyperion, Information Systems, LDAP, logic, Access, MCSE, Outlook, Modeling, Enterprise 6.5, Enterprise, Oracle, Oracle DB, PeopleSoft, plan development, programming, project lead, Purchasing, Express, reporting, research, Sales, Scripts, staffing, Strategic, Strategic Planning, Supervisor, supervision, tables, user support, Systems Support, user Training, upgrade, View, VB, Y2K

Resume Overview

Companies Worked For:

Dex Media
SuperMedia
Verizon Information Services
GTE Directories / Verizon Information Services

School Attended

University of Texas
S.M.U - School of Engineering & Applied Sciences

Job Titles Held:

Financial Systems Analyst - Hyperion / EPM Administrator
Financial Analyst - Revenue
Financial Analyst - Financial Services A/P
Financial Analyst

Degrees

Bachelor of Business Administration : Accounting
Information Technology Program - MSCE

Financial Systems Analyst - Hyperion / EPM Administrator Resume Example

Resume Score: 90%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes