SUMMARY

• Solid 7 years of Professional Experience in implementation, development, and support of Oracle Hyperion EPM product suite: HFM, FDM, DRM, ODI, Enterprise, Financial Reporting, Planning, and Essbase. (Versions 11g, 9.3.1, 7.1.x, 6.5.x)
• Expertise in EPM support tools: EPMA, Calc Manager, Shared Services, Web Forms, MaxL, LCM Utility, Excel Add - In, and SmartView.
• Extensive experience in developing reports using Hyperion Financial Reports and Hyperion Web Analysis tools.
• Expert in managing metadata using EPMA and HFM Desktop Client and developing business rules for complex consolidations and intercompany eliminations.
• Experience in administration support tasks such as loading data, updating metadata to match general ledger and consolidating.
• Deep comprehension of EPM security features. Ability to create profiles for user/group privileges in Essbase and HFM.
• Experience in creating both ASO and BSO applications with excellent balance of dense/sparse dimensions within cubes.
• Capable of creating intricate calculation scripts for Essbase dimension members.
• Adept in automation, optimization, and performance tuning of Essbase application data as well as migrating cubes to different environments (Q.A. to Production).
• Industry experience includes Finance, Consumer Products and Insurance.
• Solid understanding of basic accounting principles, corporate consolidation, and closing process.
• Face to face experience with financial users and controllers to gather requirements, manage deliverables, prepare technical documentation (UAT and User-Guide), and solve day-to-day issues.
• Polished techno-functional abilities that allow fluid transparency between developers and users.
• Strong communication, organizational and interpersonal skills.
• Ability to adapt to critical changes in environment and succeed in high-pressure situations.

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

HFM Administrator

Responsibilities:

• Gathered requirements from newly designated “Financial Transformation” group to design and execute business solutions for successful consolidation using HFM.
• Worked with financial users on a daily basis to fine-tune HFM design.
• Comprehensive overhaul of existing HFM Metadata and Rules.
• Redesigned dimensionality for Account and Entity dimensions based on clients General Ledger.
• Daily metadata maintenance including loading and consolidating to coincide with client’s GL changes.
• Mapped and configured FDM to fetch quarterly data from GL
• Built reports for previous closed quarters and years using both Smartview and Hyperion Financial Reports
• Utilized knowledge of accounting principles to successfully consolidate using intercompany elimination protocols.
• Successfully executed Equity Pickup to show the current value in corresponding shares in the equity of the subsidiaries.
• Managed and revised existing Data Forms based on business needs.
• Maintained security, adding users and updating users security profiles.
• Added new entities and accounts and updated rules in HFM as part of monthly maintenance.
• As part of maintenance took backup for metadata, formulas, Reports, journals and security files.
• Drilled down using SmartView for data reconciliation and ad-hoc analysis.
• Assisted with Sarbanes-Oxley compliance testing, procedures and documentation.
• Performed Set up of Journal Entries and working with Journals.
• Created various Data Grids to analyze data and to test HFM rules performance.

Environment: Hyperion Financial Management 11.1.2, Enterprise Performance Management Architect (EPMA), HFM Desktop Client, SmartView, Windows Server 2003

Confidential - Chicago, IL

Hyperion Essbase Developer/HFM Administrator

Responsibilities:

• Designed and developed numerous complex Essbase applications with great balance of dense and sparse dimensions.
• Developed and maintained Calc Scripts (BSO), Rule files, Maxl Scripts, MDX member formulas (ASO).
• Participated in Requirement analysis phase and gathered reports in several formats, analyzed the reports to design a Hyperion Essbase Cube.
• Involved in defining data mart to support Hyperion Essbase and created reports Financial reports and Web Analysis.
• Advanced comprehension of different storage in Essbase and their usage.
• Created large cubes using ASO option as well as creating subsequent BSO application to support Financial Budgeting and Forecasting Application.
• Tested Data load rules, fixed errors from error logs, resolved issues of data transfer from Excel, Developed Excel reports using the best-practice member selection techniques.
• Worked directly with forecasters, planners and financial users and assisted in analysis.
• Created Planning Application which includes web forms, business rules, smart list. Also provided access to users based upon their role.
• Loaded information into Planning Application and consolidated actuals, forecasts and budgets to provide a comprehensive financial analysis.
• Used advanced techniques to optimize data calculation time.
• Created and Loaded Metadata for HFM consolidation Actuals and Budget (for Variance).
• Configured the source and target adapters in HFM from FDM.
• Provided technical support for HFM and related hyperion products like Shared Services, Workspace and Financial Reporting.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load monthly data in HFM Application.
• Modified business rules to perform various functions such as Intercompany Eliminations and Currency Translations.
• Worked with Financial Analysts to customize application for generating Financial Statements.
• As part of maintenance took backup for metadata, business rules, journals and security files.
• Created Users, Groups, Filters and assigned different levels of Security Access to users.
• Built reports using FR Studio as well as Excel reports using private SmartView connections and complex macros.

Environment: Hyperion Essbase 11.1.1.3, Essbase Administration Services, Excel Add-In, Web Analysis, Hyperion Financial Management 11.1.1.3, HFM Desktop Client, SmartView, Windows server 2003.

Confidential, Baltimore, MD

Hyperion Essbase Developer/Administrator

Responsibilities:

• Organized and Implemented full system upgrade from Hyperion Essbase 9.3.1 to 11.1.1.3
• Involved in maintaining requirements and creating a complete project plan.
• Created Rule files for multi-dimensional databases.
• Developed Data Loads Rule Files and Member Formulas.
• Optimized Data Loads and Calc Scripts.
• Designed and developed sales Cubes based for weekly, monthly, quarterly and yearly reporting.
• Created Batch files and Rules files to upload data from financial system’s database to Essbase cube.
• Supervised and edited existing Calc Scripts to implement new data.
• Worked directly with forecasters and planners and assisted in analysis.
• Created Planning Application, which includes web forms, business rules, smart list. Also provided access to users based upon their role.
• Loaded information into Planning Application and consolidated actuals, forecasts and budgets to provide a comprehensive financial analysis.
• Used advanced techniques to optimize data calculation time.

Environment: Hyperion Essbase 9.3.1, 11.1.1.3 Essbase Administration Services, Excel Add-In, Planning, Shared Services, Workspace, Windows server 2003.

Confidential, Morrisville, NC

Hyperion Essbase Developer

Responsibilities:

• Developed Full Essbase Database. Created Outline and Data Load Rule Files, Calculation scripts, and Maxl Scripts for automation of outline and data loading.
• Optimized Outline, Data load rules and Calculation Scripts.
• Created Maxl Scripts and Batch processes to automate data in cubes.
• Developed a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial and marketing data and performed the loading and manipulation of data into the database using Load Rules files.
• Consistently exercised best practices in Performance Tuning and Cube Optimization.
• Sustained cubes and constantly created backups.
• Participated in Requirement Analysis Phase and Obtained Reports in several formats.
• Manipulated data columns to suit Dimension builds, Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel.
• Created Planning Application, which includes web forms, business rules, smart list. Also provided access to users based upon their role.
• Provided technical support to new users given access.
• Worked directly with forecasters and planners and assisted in analysis.
• Loaded information into Planning Application and consolidated actuals, forecasts and budgets to provide a comprehensive financial analysis.
• Used advanced techniques to optimize data calculation time.

Environment: Hyperion Essbase 7.1.2, Essbase Administration Services, Essbase Integration Services, Excel Add-In, Windows server 2003.

Confidential, San Francisco, CA

Essbase Developer

Responsibilities:

• Developed Essbase cubes for sales and marketing group at Confidential .
• Created Rule files to support new data.
• Loaded data from SQL interface to Rule files.
• Implemented new Calculation Scripts to process database.
• Created Maxl scripts to automate data into cubes daily and weekly.
• Created Planning Application which includes web forms, business rules, smart list. Also provided access to users based upon their role.
• Loaded information into Planning Application and consolidated actuals, forecasts and budgets to provide a comprehensive financial analysis.
• Worked directly with forecasters and planners and assisted in analysis.
• Used advanced techniques to optimize data calculation time.

Environment: Essbase 6.5, Essbase Administration Services, Essbase Integration Services, Excel Add-In, Windows server 2003.