VICTORIA WARD, CPA (inactive)

Sr. Certified Hyperion Applications Consultant / Project Manager Professional

www.linkedin.com/in/victoria-ward-830633b

adtsu0@r.postjobfree.com

Highlights of Qualifications:

Academic background in accounting; professional technical background in technology with 19 years combined experience

Technically proficient with Classic/EPMA HFM, Hyperion Planning, Essbase, FDMEE, Shared Services, FRS, Smart View

Education

BS Degree Accounting from Alcorn State University Lorman, MS 1991

Certifications:

Certified Scrum Professional

Hyperion Certified Professional

oHFM versions 7.0, 9.0, 9.3.3, 11.1.1.3, 11.1.2.4

oHFM Reports versions 4.2, 7.2, 8.3, 9.3.3, 11.1.1.3, 11.1.2.4

oEssbase versions 6.5, 7.1.5, 9.3, 9.3.3, 11.1.1.3

oFDQM version 9.0, 9.3.1, 9.3.3, 11.1.1.3

oHyperion Enterprise versions 3.0, 4.0, 5.0, 6.3, 6.4, 6.5

CPA Certification (inactive) 1993

Proficient with:

HFM,

SAP,

FDQM/FDMEE

OBIEE,

MDM,

DRM,

Hyperion Shared Services,

Hyperion Planning,

HFCM,

HAL,

Hyperion Ledger Link,

Oracle Financials

GEAC,

ADP Payroll,

Peachtree,

QuicksBooks Pro,

Lawson,

Mapics,

Movex,

SalesForce

PeopleSoft,

JD Edwards,

Great Plains,

Crystal Reports

CorpTax,

Excel,

MSProject

MSVisio

MSPowerpoint

Legacy

MerlinXL,

Maestro,

Web Symphony,

Smartsheet

Employment History

Estée Lauder, NYC, NY 09/17 – current

Consultant Project Manager, Hyperion Applications

Served as Project Manager for implementation of OneStream, Hyperion Workforce Planning, FDM, ODI, Essbase 11.1.2.4 with integration to Hyperion Planning

Served as Project Manager for OneStream vs. Hyperion Proof of Concept process

Served as Project Manager for the lift and shift process to migrate the entire Hyperion suite of applications into the cloud

Led the development, design, and implementation of information applications, upgrades, interfaces, and other enhancements from a functional/technical perspective to meet business requirements.

Reviewed and approved requirements, gap-fit analysis, and design documents

Developed Quality management plans (acceptance criteria), Risk management plan (risk register), Issue management plan (issue tracker)

Wrote and optimized HFM business rules, Essbase calc scripts, and developed metadata for Workforce Planning

Coordinated workforce team; and performs budget allocation, financial planning, end-to-end project delivery, project planning, analysis, and vendor management

Developed FDMEE and created FDM batch processing, import format scripts, interface design, and data conversion

Designed analytical reports in Smart View for troubleshooting

Created and maintained consistent and thorough documentation of all processes and procedures for supported applications

Monitored implementation deliverables both functional and technical. Provided feedback to key stakeholders, and system implementers

Reviewed and coordinated service change orders, statements of work, service level agreements, etc. with business

Developed user training materials and conducted user training sessions

Led the development, design, and implementation of information applications, upgrades, interfaces, and other enhancements from a functional/technical perspective to meet business requirements.

Managed requirements related to project and resource deliverables

Created project deliverables using MS Project

Conducted weekly project status meetings with budget updates

Provided leadership to teams (employees, consultants)

Managed post-implementation support teams

Utilized Scrum and Agile Methodologies, MS Project, MS Visio, MS SharePoint, Smartsheet, Jira

Strafford Technology, Londonderry, NH 07/12 – 09/17

HFM, FDQM, HP, Essbase Project Manager/Lead Applications Developer Consultant

Served as Project Manager/Sr. Developer for implementation of HFM/FDM 11.1.2.4 with integration to Hyperion Planning and Essbase

Led the development, design, and implementation of information applications, upgrades, interfaces, and other enhancements from a functional/technical perspective to meet business requirements.

Reviewed and approved requirements, gap-fit analysis, and design documents

Developed Quality management plans (acceptance criteria), Risk management plan (risk register), Issue management plan (issue tracker)

Developed, tests, and runs export routines for data transfer to other systems

Wrote and optimized HFM business rules, Essbase calc scripts, and developed metadata for both HFM and Planning apps

Developed FDM/FDMEE and created FDM batch processing, import format scripts, interface design, and data conversion

Defined Security Groups, set up end user security in Shared Services for HFM and Planning applications

Designed FRS analytical reports and support Smart View users through troubleshooting

Created and maintained consistent and thorough documentation of all processes and procedures for supported applications

Monitored implementation deliverables both functional and technical. Provided feedback to key stakeholders, and system implementers

Reviewed and coordinated service change orders, statements of work, service level agreements, etc. with business

Developed user training materials and conducted user training sessions, as needed

Conducted weekly project status meetings with budget updates

Managed post-implementation production support

Utilized Scrum and Agile Methodologies, HFM, HP, HEssbase, FDM/EE, FRS, OBIEE, Masterpac, HEnterprise, MSProject, MSVisio

IBM Global Business Services/Sara Lee Corp, Downers Grove, IL 01/09 – 08/12

HFM, FDQM, Sr. Applications Consultant

Provided technical administrative support to client SaraLee

Performed Hyperion Financial Management (HFM), and FDQM Administrator duties including maintenance of metadata and rules

Created, configured, designed, and implemented new Hyperion applications (ie. FDQM, HFM, MerlinXL)

Kept development and conversion, environment in sync with production environment

Implemented HFM at the business unit level, including required data integrations, as needed

Developed and updated Business rules and metadata

Applied HFM and FDM software applications patches and enhancements

Created and maintained consistent and thorough documentation of all processes and procedures for supported applications

Leveraged skills, experience, and HFM functional knowledge to various business segments to effectively execute change orders

Served as primary communicator of all functional HFM and FDM changes to key stakeholders and end users

Provisioned and maintained security in Shared Services

Designed financial and analytical reports via Financial Reporting Studio

Supported SmartView users through troubleshooting

Maintained Sox compliant controls for changes initiated in the application

Assisted in defining standards, managing risks, and support process governance around financial business intelligence issues and enhancements opportunities

Monitored system performance, availability and utilization

Worked with SaraLee internal audit team to execute risk mitigation and compliance activities

Created and maintained webforms, tasklists, templates, data grids etc.

Troubleshooted database issues

Interfaced with domain architects, project team, vendor and development team to scope technical requirements

Utilized HFM, FRS, FDQM, SmartView, Maestro, MerlinXL, MS VISIO, and MicroSoft Office

Amcol International, Arlington Heights IL 11/06 - 12/08

HFM, FDQM Financial Systems Manager

Supported financial staff in performing monthly close processes, including extraction and validation of data transfer from/to the SAP, Navision, and Infinium general ledger systems for actuals, forecast and budget reporting thru FDQM or HAL

Loaded monthly actual and supplemental data via Hyperion Smart View for foreign entities

Mapped the core general ledger data from source system into the respective accounts in HFM, FDQM, as new entities are formed

Created new FDM reporting scripts for new acquisitions

Maintained Hyperion Metadata and business rules and Hyperion Essbase Outlines.

Developed user training materials and conduct new user training sessions, as needed

Perform detailed analysis as needed, including gap analysis to develop both high-level and detail business requirements/specification documentation for all application upgrades, enhancements, and add-ons.

Coordinated with Finance and IT to guarantee accuracy of data feeds and inclusion of all relevant information in population of Hyperion Financial, Hyperion Planning and Reporting modules.

Created and maintained documentation on processes and procedures related to Hyperion applications and Reporting in conjunction with organizational policies, guidelines, and standards.

Developed and sustained planning, forecasting, and reporting tools necessary for users to analyze and present relevant financial data to senior management as necessary.

Set-up and maintained Hyperion Data Entry Forms and related security/calculation settings.

Wrote, modified, and maintained Essbase Calculation scripts, Essbase Outline member formulas, Essbase Data load rules, Essbase Dimension build rules, and Essbase reporting scripts.

Wrote, modified, and maintained Hyperion Financial Reports, Hyperion Web Analysis Views, Dashboards, SmartView Reports, and Hyperion Planning smart lists.

Supported company-wide consolidation and financial reporting application from problem diagnosis and analysis through problem resolution and will analyze and design solutions to ensure that Hyperion system functionality aligns with business processes.

Organized and leads requirement meetings with business sponsors/users.

Executed testing of developed solution, ensuring business requirements are implemented accurately.

Utilized HFM, Hyperion Planning, Essbase, FDM, Navision, SAP, Lawson, Maestro

AutoNation USA, Lincolnshire, IL 12/97 – 11/06

District Financial Manager

Managed implementation of Hyperion Enterprise, Analyser, Essbase, and ADP Payroll at AutoNation USA

Hired, supervised, & trained staff of thirty-three controllers

Consolidated, reviewed, reconciled and analyzed 33 entities financial statements monthly

Maintain a documented system of accounting policies and procedures

Oversight of the accounting office personnel along with all aspects of the general ledger and financial statements

Partner with the General Manager to manage the financial results of the dealership

Responsible for adherence to dealership policies and internal control structure

Proactively manage and safeguard company assets

Actively manage expense structure and vendors

Prepare the daily, weekly, and monthly reports.

Work with the management staff of the dealership to review the data and prepare reports/analysis as necessary

Designed divisional Hyperion reports for budgeting, forecasting, consolidations, Process Improvements, Cash flow analysis, costs, sales and metrics

Maintained the consolidated organization, accounts, and reporting structure in Hyperion to ensure proper recording and reporting of financial data

Led the development, design, and implementation of information applications, upgrades, interfaces, and other enhancements from a functional/technical perspective to meet business requirements.

Provided support and training to district end-users as required ensuring productive and efficient utilization of the Hyperion application

Supervised annual audit reviews, audits records and evaluates internal controls

Supervised audits for Internal controls and to determine accuracy

Ensure compliance monitoring is in place, including implementing, documenting, and maintaining processes for regulatory reporting, in accordance with Company and regulatory standards

Developed and implemented audit programs for compliance based on audit findings

Created budget/forecast for 33 entities & presented findings to management for budget variance analysis

3-year financial forecast and explanation of budget variances

Established policies and procedures to ensure internal controls for all financial transactions

Utilized Best FAS, CorpTax, Hyperion Enterprise, Hyperion Retrieve, Hyperion Application Link (HAL), ADP Payroll, Automatic Dealer Services, Essbase, Citrix, Reynolds & Reynolds, and Microsoft Office Suite

Optima Electronic Packaging Systems, Tucker, GA 04/95 - 10/97

Plant Controller

Hired/Supervised staff of nine professionals

Prepared perpetual, obsolete, and slow-moving inventory reports and supervised physical inventory counts

Ensured accurate valuation of inventory costs and balance sheet inventory values

Calculated manufacture ABC cost accounting, job costing & analysis

Reviewed, reconciled, and correct bills of material including work standards

Performed monthly financial close variance analysis, cost roll-up and reconciliation’s

Created and closed job orders on a monthly basis

Analyzed and reconciled overhead absorption and work order variance

Monitored budgets, communicated significant variances to department heads for investigated causes

Maintained the integrity and accuracy of all cost related functions

Utilized ADP Payroll, Peachtree, CorpTax, PointMan, implementation of SAP, Excel, and Access

Grand Gulf Nuclear Station, Port Gibson, MS 06/93 - 03/95

Mgr. General Accounting

Promoted from Sr. Staff Accountant to Mgr. General Accounting after thirteen months with company

Supervised seven staff accountants and administrated staffing needs

Maintained and balanced general ledger

Established/documented policies and procedures for internal controls

Forecasting (Collection, Payment, and Cash)

Prepared annual budgets and analyzed budget variances

Reconciled and analyzed financial statements (profit and loss/comparative)

Utilized AS400 system, WinFas, Microsoft Word, Excel, cc: Mail, Access, and PowerPoint

Arthur Andersen Jackson, MS 01/91 - 05/93

Auditor

Performed, evaluated, documented and communicated results of operational and control related audits at corporate and regional offices

Created work products such as audit analysis, correspondence, reports and working papers that documented audit procedures performed, findings and recommendations.

Assisted with audit reviews

Assisted with designing and developing audit programs to test the operating effectiveness of controls.

Assisted with implementing new policies and procedures.

Interacted with all levels of employees and management during the course of audit reviews

Utilized various accounting systems, Microsoft Word, and Excel

Contact this candidate