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 wif source systems using GL and DRM.
• Able to create HFM Application from Scratch and designed exports using DRM for teh HFM app build
• Good communication skills and problem solving skills.

SKILL:

• 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 wif Hyperion Financial Management (HFM) 11.1.2.x in order to support corporate consolidation team activities as needed.
• Provided halp 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.
• Started and stopped EPM services and managed teh applications on teh EPM servers.

Confidential

Oracle EPM Consultant

Responsibilities:

• Assisted in HFM and FDM administration tasks for a manufacturing construction materials company.
• Assisted in FR reports development.

Confidential ; Greater Los Angeles, CA

Oracle EPM Consultant

Responsibilities:

• Assisted in DRM 11 implementation and support for a large bank, including adding new hierarchy groups, and hierarchies. Assist wif developing teh DRM administrative documents.
• Assisted in FR reports development, including teh 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 teh development of teh 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 wif creating teh 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 teh modification of balance sheet, income statement, and cash flow reports.
• Assisted in executing FDM data loads from teh 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 wif creating teh HFM design and application documents.
• Assisted in DRM metadata hierarchy management and HFR report development for a major door and window company. Assisted in teh development of teh HFM and DRM administrative documents.
• Headed teh 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 teh modification process of teh 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.

Confidential, Denver, CO

Senior Accountant

Responsibilities:

• Performed Hyperion Financial Management Report Writer administrator duties, including develop, maintaining and troubleshooting financial reports for teh 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 teh functionality of teh 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.
• Reviewed monthly and ad hoc journal entries for posting.

Confidential, Denver, CO

Senior Accountant

Responsibilities:

• Developed Essbase and Excel reports for teh Minority Interest process, fluctuation analysis and financial reporting.
• Utilized Essbase to develop ad hoc reports for variance analysis.
• Assisted other end users on teh functionality of Essbase.
• Mapped out current processes on flowcharts for teh corporate process improvement project and SOX requirement via interviews wif various corporate departments.
• Identified control objectives for teh SOX processes and documented teh associated risks and key controls in narrative form.
• Completed control matrix and walkthrough document for SOX processes, including gathering backup for each control in teh walkthrough.
• Communicated wif internal and external auditors regarding questions on SOX documents.
• Performed walkthroughs wif external and internal auditors.
• Maintained TEMPeffective work relationships through strong communication skills wif 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 teh IT audit requirement for teh Sarbanes-Oxley Act.
• Designed and implemented teh evaluation processes and procedures for testing spreadsheets for compliance.
• Evaluated teh 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 teh use and review of external auditors.
• Documented all key control processes of teh 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 teh 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 teh 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 teh 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.