SUMMARY

• Around 6 years of experience in a range of Hyperion products including Hyperion Financial Management, Hyperion Financial Reporting, Essbase, Planning, Smart view, EAS, in Windows environment
• Expertise in creating and deploying HFM applications in classic and EPMA mode used for all consolidation purposes
• Strong experience in Financial management applications, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation of HFM tasks using task flows from workspace
• Extensive knowledge in HFM Classic / EPMA applications, Hyperion FDMEE and Financial reporting
• Experience in creating, maintaining, and supporting all application objects including Outlines, Calculation Scripts, Rules files for dimension builds and data loads, Transparent partitions, and Security objects through both Essbase Administration Services (EAS) and MaxL scripts; also involved in automation of these procedures using Batch scripts
• Strong knowledge of Software Development Life Cycle (SDLC) methodologies and Oracle Hyperion Enterprise Performance Management (EPM) tools
• Experience in Accounting: Balance Sheet, P&L, A/P, A/R, G/L, Fixed Assets, Reconciliations, Journal Entries, Trial Balance, Financial Analysis, Financial Audits, ERP Implementation
• Very good experience in preparation of the metadata for Hyperion Financial Management applications both .xml and .app formats.
• Strong experience in creating data grids and web data forms to load data and Posting, scheduling the journals to adjust data
• Migrating multiple Planning applications, Essbase applications, FDMEE, and Security from one environment to another using the LCM Utility
• Excellent experience in debugging procedures by developing and implementing test cases
• Created documentation for Development applications and provided end user training
• Adapts new systems and environments quickly. Good work ethics, take ownership of all duties, responsibilities in meeting management skills

TECHNICAL SKILLS

OLAP Tools: Hyperion financial management 11.x/9.x, Hyperion planning 11.x/9.x, Essbase 11.x/9.x, Hyperion financial management 11.x/ /9.x, Smart View, Essbase Administration Services, Hyperion workspace, Hyperion shared services, Hyperion Reports 11.x/9.x, Excel Add - in, Essbase Studio, Excel Add-In, Maxl, Hyperion Financial & Interactive Reporting Studio 11.x/9.x

GUI: Visual Basic 6.0/5.0, Application Manager, SQL Developer

Business Intelligence Tools: Hyperion Planning 11.x/9.x, Hyperion Financial Management Suite (HFM) 11.x/9.x

Reporting Tools: Hyperion BI+ (Financial Reporting 11.x/9.x, Interactive Reporting), Hyperion Excel Add-in, Smart View, Hyperion Interactive Reporting Studio.

Scripting Languages: Maxl, ESSCMD, MDX.

Databases: Essbase, Oracle 11i/10g,SQL SQL Server 2008/2012, DB2

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Hyperion Administrator / Financial Systems Analyst

Responsibilities:

• Responsible for Managing and administering for 2 ASO (Report & Projects), 2 BSO cubes (Allocations & Activity) and 2 Hybrid cubes (CapEx & Plan)
• Managed the HFM Metadata updates through EPMA file as part of month end financial close process. Updated Accounts, Entity, and Custom dimensions as per the business needs
• Performed Month end activities that includes loading Fx rates, calculating Depreciation in CapEx cube, Actual Allocation calculations in Allocations cube, Version copies post close, Variable updates, etc.
• Validated and Issued Quality of Earnings reports, Quality Financial summary reports and other monthly Financial reports to the management for their business analysis
• Built multiple financial reports for users using Hyperion Financial Reporting Studio 11.1.2.4
• Designed recurring Journal entry templates, Planning web forms for data inputs as per the business requirements using Hyperion workspace
• Validated artifacts and data between Production and Development environments to keep them in sync after Quarterly Application copy
• Maintained and administered Security permissions for users and groups using Shared services
• Lead end user trainings for SmartView, Hyperion Planning, and Hyperion Reports for users across the Globe
• Resolved multiple Service now helpdesk tickets, supported users on their daily activities for month end close and troubleshot Hyperion connectivity issues

Environment: Hyperion Financial Management v11.x, Hyperion Essbase/Planning v11.x, FDMEE, Smart View, Shared Services, Windows 10.

Confidential, Detroit, MI

Hyperion Planning/Essbase Consultant

Responsibilities:

• Assisted in the build & migration of the eRest Planning application between Dev, Test and Prod environments using Life Cycle Management (LCM)
• Loaded Historical data loads through Essbase and performed data tie outs
• Managed Planning applications (PPR/eRest) with various monthly maintenance tasks that includes Change Management, monthly backups, Batch jobs to push HFM data to Planning using rules.
• Perform Month-End and Year-End activities by changing the environment variables in the batch files and substitution variables in EAS console accordingly
• Created and tested Business Rules & Calc Scripts
• Created and provisioned users & groups and controlled access through roles & security class. Also maintained Planning application access to different groups using Security filters
• Participated in upgrade project from version 11.1.2.3 to 11.1.2.4 for HFM, Planning and Essbase Applications
• Acted as the technical lead for Hyperion Planning/Essbase related issues including providing technical support for users and supervisors
• Created multiple validation templates (Using Hs.getcell formula) that includes comparisons between environments & between different Hyperion suite of products.
• Conducted Workshop Sessions & developed end user training manuals used to train planners both technology and process in the new system
• Created ADMIN playbook that describes activities/collections/processes going on around the year completely from end to end
• Performed post production deployment sanity checks to ensure the integrity of data and artifacts
• Documented road blocks and troubleshooting tips from the non-prod environments and used those findings during the Production environment upgrade process
• Assessed the current state of the client and developed keen understanding of the source system
• Performed data validation through SmartView, Grids and Data Forms
• Resolved multiple user reported issues post production upgrade project

Environment: Hyperion Financial Management v11.x, Hyperion Essbase/Planning v11.x, FDMEE, Smart View, Shared Services, Windows 8.

Confidential, Houston, TX

HFM Consultant

Responsibilities:

• Gathered requirements from business users, created application and technical architecture documents for management based on existing and new requirements
• Designed, created, tested and managed Metadata structure in HFM from existing Enterprise hierarchy for all dimensions including Custom dimensions
• Worked on HFM, FDM, Smart View and Reporting
• Created Data Grids, Data Forms, Task lists, Journals and Member Lists
• Provisioned user roles for different users, groups and assigned Security
• Design data loads of Historical Data to Production using FDMEE
• Loaded data and tied numbers to ERP system (IDEAS) to ensure accuracy
• Data validation of Historical data between HFM and the previous reporting tool COGNOS
• Data Validation through Smartview between development and Production environment
• Reconciled all Historical and Actual data using Smart view
• Identify problem areas in regards to processes and work with the team to generate solutions and escalate to management as appropriate
• Maintained users and security for FDMEE and HFM Applications using Shared Services
• Performed detailed documentation of tasks, processes and optimization requirements based on run times during data load and while data validation
• Extensively used Smart View for data verifications during User Acceptance Testing (UAT) and Standard Maintenance

Environment: Hyperion Financial Management v11.x, FDMEE, Smartview, Workspace, Shared Services, IDEAS, COGNOS, Windows 8.