SUMMARY:

• Over 15 years of total experience.
• 10 years of experience in Hyperion Financial Management.
• Experienced working as a HFM Developer and HFM Administrator.
• Good in end - to-end implementation project in HFM.
• Experienced in managing integration with source systems using GL and DRM.
• Able to create HFM Application from Scratch and designed exports using DRM for the HFM app build
• Good communication skills and problem solving skills.

TECHNICAL SKILLS:

Skills: Hyperion Financial Management {HFM) 11.1.2.x; Smart View; Financial Data Quality Management (FDM); FDMEE; Essbase; Data Relationship Management (DRM); PeopleSoft; Hyperion; General Ledger (GL); Business Objects; MS Office Suite (including PowerPoint)

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

HFM Developer

Responsibilities:

• Leveraged functional & technical experience with Hyperion Financial Management (HFM) 11.1.2.x in order to support corporate consolidation team activities as needed.
• Provided help desk end-user support for HFM, Smart View, Financial Reporting and Financial Data Quality Management (FDM) issues.
• Supported HFM and FDM apps including maintaining metadata changes, data uploads, mapping tables, security and provisioning, troubleshooting and development of reports.
• Ensured SOX controls compliance.

Confidential, Boca Raton, FL

HFM Administrator

Responsibilities:

• Implemented HFM 11.1.2.1 application metadata, rules, and security changes.
• Provided help desk end-user support for HFM, Smart View, Financial Reporting and FDM issues.
• Created and updated maps, loaded and validated data, and fixed validation errors in FDM.
• Created security classes and groups within Shared Services.

Confidential

Consultant

Responsibilities:

• Assisted in historical data validations and HFM rules writing for car parts manufacturing company.
• Assisted in creating the HFM admin guide, and system integration/unit testing for an agriculture company.

Confidential, CA

Oracle EPM Consultant

Responsibilities:

• Assisted in DRM 11 implementation and support for a large bank, including adding new hierarchy groups, and hierarchies. Assist with developing the DRM administrative documents.
• Assisted in creating the HFM admin guide for a transportation company.
• Assisted in HFM and FDM administration tasks for a manufacturing construction materials company.
• Assisted in FR reports development.

Confidential

Oracle EPM Consultant

Responsibilities:

• Assisted in DRM 11 implementation and support for a large bank, including adding new hierarchy groups, and hierarchies. Assist with developing the DRM administrative documents.
• Assisted in FR reports development, including the modification of several key reports.

Confidential ; Denver, CO

Oracle EPM Consultant

Responsibilities:

• Assisted in DRM metadata hierarchy management and HFM FR report development for a major door and window company. Assisted in the development of the HFM and DRM administrative documents.
• Assisted in building HFM metadata, reports, member lists, rules, web forms and grids, and FDM import formats and mappings for a major transportation and logistics company. Led HFM FR reports and assisted with creating the HFM design and application documents.

Confidential, Denver, CO

HFM Consultant

Responsibilities:

• Performed data conversion validation for a large car seat manufacturing company using Smart View and Essbase.
• Developed unit testing and user acceptance testing scripts for a large agriculture company.
• Assisted in HFM development and support for a construction and paving company, including rules writing, web form development, security maintenance, and consolidations.
• Assisted in FR reports development, including the modification of balance sheet, income statement, and cash flow reports.
• Assisted in executing FDM data loads from the source General Ledger (GL) to HFM.
• Assisted in Data Relationship Management (DRM) 11 implementation and support for a large bank, including adding new hierarchy groups, and hierarchies.
• Assisted in building an HFM 11 application for a major transportation company, including metadata, reports, member lists, forms, grids, rules and FDM import formats and mappings.
• Led Hyperion Financial Reporting (HFR) reports, and assisted with creating the HFM design and application documents.
• Assisted in DRM metadata hierarchy management and HFR report development for a major door and window company. Assisted in the development of the HFM and DRM administrative documents.
• Headed the HFM 11.1.2.x report modification process of a system re-engineering project for a major flow equipment products and services company, resulting in improved efficiencies to 188 key financial reports.
• Led the modification process of the cash flow reports in Excel using Smart View in an HFM 11.1.2.x upgrade project for a major health care company, creating ease of use and better future maintenance.

  Performed Hyperion Financial Management Report Writer administrator duties, including develop, maintaining and troubleshooting financial reports for the corporate accounting department, and acted as liaison between HFM IT developers and end users.

• Developed Smart View reports in Excel for financial and SEC reporting, and trained end users on the functionality of the reports.
• Utilized Essbase to input annual budgets for corporate accounting department.
• Performed monthly and quarterly flux analysis of corporate financial statements.
• Executed monthly and quarterly analysis of affiliate transactions for financial reporting.
• Prepared monthly and quarterly cash flow statements utilizing roll forward data for financial and SEC reporting.

Confidential, Denver, CO

Senior Accountant

Responsibilities:

• Developed Essbase and Excel reports for the Minority Interest process, fluctuation analysis and financial reporting.
• Utilized Essbase to develop ad hoc reports for variance analysis.
• Assisted other end users on the functionality of Essbase.
• Mapped out current processes on flowcharts for the corporate process improvement project and SOX requirement via interviews with various corporate departments.
• Identified control objectives for the SOX processes and documented the associated risks and key controls in narrative form.
• Completed control matrix and walkthrough document for SOX processes, including gathering backup for each control in the walkthrough.
• Communicated with internal and external auditors regarding questions on SOX documents.
• Performed walkthroughs with external and internal auditors.
• Maintained effective work relationships through strong communication skills with co-workers and other departments.
• Completed all routine and ad hoc projects in a timely and efficient manner.
• Prepared monthly and quarterly financial documents for internal and external financial reporting.

Confidential

Freelance Consultant

Responsibilities:

• Managed and executed the IT audit requirement for the Sarbanes-Oxley Act.
• Designed and implemented the evaluation processes and procedures for testing spreadsheets for compliance.
• Evaluated the mechanical soundness of spreadsheets used in key internal controls over financial reporting.
• Validated formulas, functioning of macros, traced dependent cell information, and recreation of formulas.
• Documented test results, including work papers for the use and review of external auditors.
• Documented all key control processes of the IT department via narratives and flowcharts.
• Enhanced inadequate IT audit processes through implementation of additional controls.
• Performed financial needs analysis for individuals to determine their insurance and financial amounts.
• Serviced existing clients to meet their life insurance and financial needs.
• Marketed to obtain new clients for the company.

Confidential, Denver, CO

Consultant

Responsibilities:

• Team lead for a cash and accounts payable general ledger account reconciliation project for a major high tech firm, resulting in the identifying and re-classing of approximately $300,000.
• Completed complex account reconciliations for two large insurance companies in their effort to bring their accounts up to date and in compliance.
• Prepared a process improvement document outlining specific procedures to streamline the account reconciliation process for a large insurance company.
• Assisted in documenting and constructing a major proposal for cost minimization efforts for a large pharmaceutical company.