SUMMARY:

• Certified Oracle Hyperionand EPM suite implementation professional with 10+ years of experience in HFM, Essbase, Planning, ETL, reporting, and strong knowledge in accounting principles.
• Standard project management methodologies from project inception to finish tailored for Hyperion EPM technology, through project life cycles.
• EPM infrastructure install, patching, on Linux, Windows, Solaris, and Exalytics machines.
• Applications builds from user requirements, including calculation rules and scripting. metadata, and data feeds. Application migrations, optimizations, and developments. Security set up.
• Recommendation, integration of Hyperion EPM products for Corporate environment and governess, based on reporting, planning/forecasting needs and cycles.
• Worked through various versions 6, 7, 9, 11, to latest 11.1.2.4 for EPM products.
• Member of Oracle documentation partner.

TECHNICAL SKILLS:

Expertise: Oracle Hyperion EPM Consulting SME/Architect on EPM financial consolidation suite of products HFM, Essbase, Planning, FDMEE, FRS, SS, to 11.1.2.4, with exposure to dependent products.

Knowledge of: upstream (source) data - feed systems, general ledgers, backend SQL databases, batch (Windows), shell (Linux) scripting.

Competencies: Oracle Hyperion EPM Foundation Services 11 versions, infrastructure installation and upgrade, Web Server, HFM/FDM/FDMEE, Essbase/Planning to 11.1.2.4 versions.

Project Management: PMBOK Project Management Methodologies. Windows, Linux, Solaris server environments and network topology.

General: accounting principles, SOX compliance, system mergers, migrations, re-states.

GL/HRIS: Systems, RDBMS, SQL, Transactional and Teradata concepts.

EXPERIENCE:

Confidential

EPM Consultant

Responsibilities:

• Inter-company setup diagnosis with HFM.
• Error troubleshoot.
• Training to client on Reporting.

Hyperion Solution Architect

Confidential, TX

Responsibilities:

• Provide implementation go-live support for Planning/HFM 11.1.2.4 version.
• Templates, application metadata updates, error fixing as necessary.
• Made recommendations for Infrastructure, application tuning Suggest new opportunities.

Techstar, Hyperion Architect

Confidential, Co Springs, CO

Responsibilities:

• Provided EPM product, processes discussions to wireless and wireline support/config management team of 11 on EPM upgrade, configuration, migration, and environment merger.
• Migrated applications and infrastructure artifacts to Exalytics machines on Linux and Solaris. Refined, fixed, revamped artifacts as needed in migration process.
• Worked with ODBC, shell/maxl scripts, Ess config files, custom authentication, LDAP, Java heap artifacts.
• Applied 11.1.2.3.5 patches as needed for all EPM products.
• Wrote diagnostic shell scripts for simulation testings. Gave training presentation on Planning for team.
• Concurrent tools with EPM include OBIEE/Dashboards, SOA, VSII, ESPx, DRM, ODI.

Hyperion Architect

Confidential, Short Hills, NJ

Responsibilities:

• Developed HFM upgrade Project Plan and paths for stakeholders review.
• Specified server requirements for HFM/FDMEE load balanced installation. Prepared checklists for installs.
• Identified/reviewed FDM requirements including scripts, maps, and logic rules for translation to FDMEE.

Sr.Hyperion Architect

Confidential, Fairfield, CT

Responsibilities:

• Led Confidential team along Hackett implementation of EPM ARM/FDMEE implementation v11.1.2.3 for GE.
• Provided design solutions for FDMEE mapping with like rules for ARM profile generation.
• Implemented design and led Confidential data integration resources during implementation.
• Provided other technical troubleshooting for ARM as required.

Hyperion Lead

Confidential, San Jose, CA

Responsibilities:

• Supported EPM Planning 11.1.2.1 on Linux through close cycles.
• Closed gap on management of role.
• Worked with testing activities and cube feeds of four Planning applications for close.
• Led design meetings and was primary contact between the client and support team.
• Led an offshore team of 3 developers to complete project tasks and technicals. Wrote documentation for each phase.
• Developed seven customized archived Essbase ASO cubes from existing Planning applications 11.1.2.2.
• Converted BSO outlines to ASO, translated member formulas to MDX, and developed data load rules.
• Completed project with zero defects.

Confidential, New York, NY

Senior HFM Staff

Responsibilities:

• Worked on EPM conversion project from Enterprise 6.5 to HFM/FDM 11.1.2.2. Guided setup to establish over 50 locations.
• Recommended project management process; set up mappings of Enterprise to HFM check templates.
• Reviewed metadata, rules, and setup for HFM. Tracked and reviewed task-flows.

Hyperion Consultant

Confidential, Virginia

Responsibilities:

• Oversaw EPM Planning/HFM environment and Financial Report upgrade from 11.1.2.1 to 11.1.2.2.
• Hands-on implementation of HFM application.
• Served as primary client contact, established requirements and implemented metadata, cash flow rule cleanups, inter-company setup, task list, and processes.
• Ran install tool, patch tool, and configured tools.
• Expanded the number of custom dimensions in the new HFM application and transferred hierarchies to new dimensions.
• Converted HFM rules from script to Calculation Manager formats for each subroutine.

Sr Hyperion Consultant

Confidential, Arkansas

Responsibilities:

• Managed Hyperion Planning, HFM support projects with Confidential for Confidential division.
• Delivered a presentation on a Hyperion utility to client’s software review committee for approval prior to implementation.
• Interfaced with various other ISD teams.
• Identified critical HFM infrastructure clustering issues for resolution and stabilized application.
• Assisted Confidential ’s HFM and Planning Administration to resolve technical issues.
• Worked with offshore resources.
• Corrected FDM workflow issue and conducted a technical training.
• Successfully transitioned Planning applications from Development to Support.
• Certificate of Appreciation from client.

Sr Hyperion Consultant

Confidential, New York, NY

Responsibilities:

• Hyperion Planning, FDM, EPMA installation project v.11.1.1.3.
• Project included scripting and WFP. Rectified FDM installation errors and mappings.
• Provided administration and user support for Essbase, Planning, HFM/FDM, SQL, Lawson GL, Salesforce.com, Databasics, Reports, and Microsoft Office suites.
• Hands-on maintenance of: .bat, MaxL automation scripts, 100+ SQL DTSs for scheduled data refreshes, BSO calculation scripts, and formulas.
• Installed and configured software, add-ins, and patches for users.
• Identified optimization processes for implementation. Maintained Shared Services securities with LDAP.
• Fulfilled state government reporting requirements via generating and submitting xml files.
• Customized ad hoc queries for data pull via cross joint SQL queries, Access, and ODBC connections.

HFM Technical Project Manager

Confidential, New York

Responsibilities:

• Managed technical functions pertaining to HFM, FDM, Financial Reporting Studio, WebAnalysis, Shared Services, and Smartview for data conversion project.
• Diagnosed and corrected infrastructure configuration errors in HFM and FDM for install implementation.
• Reviewed and administered HFM security, performed local backups of metadata, rules, member list, data, security files. Maintained structural changes and rules in metadata including overrides.
• Recommended process improvements and best practices.
• Identified Bairnco data conversion project parameters and reviewed progress with management.
• Built new applications and test environments in HFM. Maintain interface between HFM/FDM.

Confidential, NY

Financial Systems Analyst

Responsibilities:

• Had oversight of scripts, consolidation infrastructure and data synchronization on Hyperion and GL systems.
• Maintained Lawson GL and Hyperion consolidation suites via updating cubes/structures, variables, filters, scripts for month-end, quarter-end, year-end rollovers, and environmental variables.
• Handled client upgrades of office suite, Hyperion environment: Essbase 7, Hyperion Enterprise Reporting 6.4.1. Tracked project status with MS Project.
• Maintained user securities on all financial systems, prepared summary of changes monthly.
• Diagnosed and rectified configurations, systems error messages, systems optimization.
• Performed system backups on different systems at varied schedules.