Peningo Systems, Inc.
Resume of Candidate: PEN-102
Rate: email us at sales@peningo.com for rate information
Hyperion Software Consultant
Title: Experienced HFM/System 9 Consultant
Area of Expertise: Hyperion Financial Management 4.x and System 9.3, Hyperion Financial Data Quality Mgt (Upstream), Shared Services, Hyperion
Reports 7.x and BI+ Studio, Hyperion Retrieve and Smartview.
Project Summary:
(System 9.3 from SAP & Hyperion Enterprise) – 11/08 – present; Lead Consultant
• Metadata design, build from existing Enterprise hierarchy for Historical data, integrate SAP entity and account and full custom dimension build
including smart dimensions.
• Designed rules for Rollforward differences, Variance accounts, Cashflow reporting, Statistical calculations, various data copy rules.
• FDM design, test, migration, import formats, location setup, security, custom scripting for GL integration from SAP R3 and BW, Hyperion Enterprise
and disparate legacy GL’s to development and production environments.
• Complete setup of all Webforms and system reports (Rollforward, IC Matching, Journals).
• Managed client reconciliation of all Historical and Actual data using Smartview excel sheets, and ad-hoc analysis.
• Created all Income Statement, Balance Sheet, Financial Reporting Package templates and reports in System 9 BI+.
(System 9.3 implementation from Outlooksoft) – 4/08 – 10/08 Lead Consultant
• Metadata design, build from existing Outlooksoft hierarchy, Custom dimension design for Products, Services, Data Sources.
• Designed basic rules for Rollforward differences, Variance accounts, Cashflow reporting, Statistical calculations.
• FDM design, import formats, location setup, security, custom scripting for GL integration from HBOC Star, Lawson legacy GL’s to development and
production environments.
• Complete setup of all Webforms and system reports (Rollforward, IC Matching, Journals).
• Managed client reconciliation of all Historical and Actual data using Smartview excel sheets, and ad-hoc analysis.
• Created all Income Statement, Balance Sheet, Financial Reporting Package templates and reports in System 9 BI+.
(Enterprise 5.0 to System 9.3) – 01/08 – 4/08 Senior Consultant
• Design, testing of Metadata Structure, Rules Updates, Member Lists, Security, Provisioning in HFM 9.0.2
• Created Income Statement, Balance Sheet, Financial Reporting Package templates and reports in System 9 BI+.
• Design, data validation, and data loads of Historical Data to Production using FDM.
• Designed and managed > 100 FDM locations, mapping tables, security, import scripts, and logic accounts.
• Reconciled all Historical and Actual data using Smartview.
11/07 – 1/08 Senior Consultant
• Redesign, testing of Metadata Structure, Rules Updates, Member Lists, Security.
• Created Income Statement, Balance Sheet, Financial Reporting Package templates and reports in System 9 BI+.
• Reconciled all Historical and Actual data using Smartview.
(Hyperion System 9.2 – Business Intelligence Reports from HFM) – 03/07 – 10/07 Reporting Lead
• Design, Create, Test and document 350+ reports in Hyperion System 9 BI+ Financial Reporting Studio.
• Created Income Statement, Balance Sheet, Cashflow, Validation, Statistical, and Supplemental reports.
• Performed Smartview knowledge transfer to Client analysts.
• Create technical and design documentation for project status reports.
(Hyperion Financial Management Upgrade from 3.0 to 3.5) – 10/06 – 02/07 Financial Systems Consultant
• Moved Entity, Accounts, and Custom Dimensions from Corporate HFM application to Division HFM application.
• Added and Modified rules to reflect new, calculated, and system accounts.
• Extracted, loaded and tied opening and rollforward balances.
• Updated HAL mapping tables and project files.
• Reconciled data from Essbase loads into HFM and upstream to Corporate HFM applications.
• Created and Tested rules to copy data between scenarios.
(Hyperion Financial Management Upgrade to 4.0) – 6/06 – 09/06 Financial Systems Consultant
• Performed Installation and Configuration of Hyperion Financial Management, Hyperion Reports, Smartview, Hyperion HUB to create the
Development environment on the server for upgrade from HFM 3.5 to HFM 4.0
• Created rules for and loaded Opening Balances and Rollforward differences.
• Created reconciliation spreadsheets to tie data between HFM applications using Excel Add In and Smartview.
• Performed Installation, Configuration, and Integration with Upstream Weblink Datamart (Hyperion System 9 FDM) including Creation of Applications,
Configuration of Servers, and Configuration of Adapters.
• Designed and managed > 100 Upstream locations, mapping tables, security, import scripts, and logic accounts.
• Created custom Upstream Weblink training manuals used in global HFM and Weblink training classes.
(Hyperion Financial Management Implementation) - 10/05- 6/06 Financial Systems Consultant
• Managed Metadata structure in HFM from existing hierarchy for all dimensions.
• Assisted in writing rules to replicate account movements from Enterprise.
• Created various Smartview and Retrieve templates to reconcile historical data.
• Created and managed Upstream Weblink system structure.
• Assisted in the creation of a custom Weblink interface to submit data to parent company for consolidation.
• Created custom Upstream Weblink training manuals used in global HFM and Weblink training classes.
• Designed custom HFM and Weblink technical system documentation.
• Provided go-live support and troubleshooting of all live production systems.
(Enterprise to HFM conversion) - 05/05- 10/05 Financial Systems Consultant
• Created, tested, and managed Metadata structure in HFM from existing Enterprise hierarchy for all dimensions, including Custom and User Defined.
• Assisted in writing rules to replicate account movements from Enterprise.
• Created web data entry forms, and data grids for monthly close process.
• Designed, Created and Tested various Reports used in monthly close.
• Assisted with Upstream Weblink system structure (historical data integration from GL to HFM) including mapping tables, locations for all business
units, invalid intersections, and security.
Previous Employment
04/04 – 05/05
(Hyperion Reports) - 01/05- 05/05 Financial Systems Consultant
• Responsible for Design, Implementation and Testing of over 250 Actual and Budget Reports in Hyperion Reports and Hyperion Analyzer.
• Responsible for System Integration Testing using Test Director to create all Test Plans and Test Management.
• Train and lead a team of 3 junior consultants through SIT Testing process.
• Created user training manuals and technical documentation for all reports used in monthly close process.
Systems: Hyperion Solutions Suite (HFM 4.0, Enterprise 5.5, Reports, Planning, Analyzer, Smartview, Retrieve), SAP R/3 FI-CO, Upstream Weblink,
Mercury Test Director, SQL, VB Script, JAVA, C++, Basic, Visual Basic, HTML, MS Office Suite (Word, Excel, PowerPoint, Outlook)
 | |  | |  | |  | |  | |  | |  |