SUMMARY

• Certified Oracle Hyperion Planning 11 Implementation Specialist and Certified DRM specialist with over 7 years of Information Technology experience with specialization in Hyperion Essbase, Hyperion Planning, HFM, DRM, FDMEE across industry verticals Financial, Logistics and Manufacturing customers.
• Expertise at Solution Designing, financial modeling, Essbase Implementation for solving reporting requirements, planning requirements and consolidation requirements, Planning and Budgeting Implementation.
• Extensive experience in application designing and development using Oracle EPM system 11.1.2.4, 11.1.2.3, 11.1.1.3 and 9.3.1 versions, Hyperion Planning, Essbase, Hyperion Financial Management (HFM), FDMEE, DRM, DRG, Calculation Manager, Rules Editor.
• Expertise in integrating Hyperion applications with Oracle GL using ODI and FDMEE.
• Expertise in designing/developing Outlines, Calculation scripts, Business Rules, and Rules files.
• Expertise in integrating Hyperion with ETL tools like DataStage and Informatica.
• Proven qualifications in all facets of systems development life cycle, from initial feasibility analysis and conceptual design through testing, implementation, support user training and enhancements
• Expertise in administration and development of reports using Hyperion Financial Reporting Tool and Smart view.
• Expertise in designing Planning model using EPMA and designed many BSO and ASO (reporting) applications.
• Ability to work under pressure and meet stiff targets with time management and leadership skills and excellent analytical and problem - solving skills.

TECHNICAL SKILLS

Oracle EPM/Hyperion: Oracle EPMA, Hyperion Planning, HFM, Essbase, Essbase Studio, FDMEE, DRM, (Versions 11.1.2.3, 11.1.2.2, 11.1.2.1, 11.1.1.3, 9.3.1, 9x)

Databases: Essbase, Oracle11g,10g, SQL Server 2005

Reporting Tools: Financial Reporting, Web Analysis, Smart View, Excel Add-In

Scripting Languages: MAXL, MDX, HTML, Java Script, DOS, Shell, SQL, PL/SQL and C#

ETL Tools: ODI, DataStage, Informatica

Operating Systems: Windows 2008, 2003, Linux, AIX 5.3, Unix

Methodologies: Waterfall, Agile, SCRUM Methodology

Version Control Systems: Team Foundation

Project Management: MS Office Suite, MS Project

Scheduler: Cognos Star Command Center, Windows Task Scheduler

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Hyperion Consultant

Responsibilities:

• Gathering business requirements and translating them into technical build requirements for the supported HFM & planning applications.
• Maintain the HFM system and support the Financial Close with expertise in Hyperion Financial Management (HFM), ODI/FDMEE/DRM, Business Rules, FR Reporting, SmartView.
• Involved in integrating Oracle GL with Hyperion applications using FDMEE and loading the data back and forth from GL.
• Involved in Metadata Maintenance, Task List, Member Lists, Data Loads, and inter-company eliminations, Plug Accounts, Journal Adjustments & running Consolidations, Calculation Manager / Rules Editor for managing the HFM application.
• Working with Oracle Financials (OFSAA) and loading and retrieving the data from OFSAA to Hyperion applications.
• Budgeting & Forecasting: Maintain the Hyperion Planning application at IHC (BNP Paribas & Confidential ), which provides the transparency of data across both the banks using Hyperion Planning, Essbase BSO Cube, Calc Scripts.
• Maintaining the different dimensions (Chart of Accounts, Entity, Product etc.) for the target applications using DRM.
• Creating Validation, properties and maintaining the security in DRM to support the business users.
• Setup the workflow process in DRM using DRG to implement proper data governance for their respective dimensions.
• Created applications, locations, import formats, mapping templates, control tables, Integration scripts and validation rules in FDMEE for data load to HFM and Planning applications.
• Created financial reports such as Balance Sheet, Income Statement, Cash Flow, operating expenses reports by cost center, budget vs. actual variance reports for USGAAP, IFRS and Statutory reporting using financial reporting studio as well as SmartView.
• Created UAT test scripts for testing the System Integration.
• Created test scripts for testing the Business Processes.

Environment: Hyperion Financial Management 11.1.2.4 (HFM), Hyperion Planning, Hyperion Essbase, FDMEE, DRM, Hyperion Financial Reporting

Confidential, Redwood City, CA

Sr. Hyperion Consultant

Responsibilities:

• Designed, developed, and implemented Expense Planning and Reporting System for the Tax Department at Oracle using Hyperion Planning.
• Developed Calculation Scripts, MaxL and Shell scripts for automation of the Tax cube. Worked extensively on data loads, load rules, and UDAs.
• Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance.
• Designed and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Mentor and transfer ODI, DRM technical knowledge and processes to other Client team and department personnel, as requested.
• Worked with the Hyperion Tax Provision (HTP) team to provide the required tax data and metadata from the tax cube.
• Provided technical guidance and support to end-users by developing the documentation required.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions.
• Provided technical guidance and support to end-users during forecast cycle, UAT and BAT sessions.
• Executed test cases as part of UAT for the Hyperion Tax Provisioning (HTP).

Environment: DRM 11.1.2, Hyperion Essbase11.1.2, EAS, Hyperion workspace, HOPS

Confidential, SFO, CA

Sr. Hyperion Consultant

Responsibilities:

• Worked closely with Business and Users to translate the user requirements to technical requirements.
• Provided primary tier of Production support during Forecast cycles.
• Designed and implemented Security for 200+ users, created batch files for loading the secfiles using planning utilities and to sync filter access between planning and reporting applications.
• Maintaining DRM and pushing the metadata into HFM.
• Maintaining the FDMEE applications by changing the mappings.
• Loading the data from FDMEE to HFM and Planning applications.
• Developed several batch automations using Cognos Star Command Center
• Developed several Calculation scripts and Calc Manager Business rules for Allocations, export/import of data, aggregations, drivers and other calculations.
• Designed many Planning web forms, Financial reports and Smart view templates for different functional group of users.
• Developed several Menus, Smart lists, Task lists for better User experience
• Expertise in migrating objects or applications between environments/servers using LCM utility and documented the steps in case of any compatibility issues during migrations.
• Administered application testing, while monitoring the system performance, thereby reporting any anomalies in the application
• Performed unit testing and user acceptance testing (UAT) the final step before Rolling out of the Application.
• Analyzed, planned and coordinated the process to upgrade Hyperion Planning, Essbase from 11.1.1.3 to 11.1.2.2

Environment: Environment: Hyperion Essbase11.1.2, Hyperion Financial Management 11.1.2 (HFM), DRM 11.1.2, EAS, Hyperion Planning 11.1.2, Hyperion Financial Reporting 11.1.2, Teradata, Cognos Star Command Center

Confidential, Irvine, CA

Hyperion Consultant

Responsibilities:

• Involved in technical requirements gathering and identifying dimensions for the application.
• Designed functional and technical specifications.
• Development and ownership of Projects.
• Designed and developed BSO and ASO cubes for the commercial department.
• Developed the outlines using Dynamic dimension build method.
• Created Rule files for Data Loading using SQL.
• Created Numerous Complex Hyperion Financial Reports to achieve Executive User Requirements.
• Coordinated with the Technical architect team in migration of HFM and FDM.
• Designed and setup security for HFM, FDM.
• Created and Trained users on Smart View Reports.
• Created Customized Financial Reports using Hyperion Financial Reporting Tool.
• Implemented/Installed the EPM applications Essbase 11.1.2 and Planning 11.1.2 in Windows server.
• Developed Web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
• Written Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
• Written MAXL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes.
• Wrote Batch Scripts and Shell Scripts to automate the process.
• Assigned data form entry, execution of business rule tasks to end users.
• Used LCM to Migrate the Applications and its Objects from one environment to another.
• Set up users and groups according to the department and maintained security to users and groups from Hyperion shared services and assigned security to web forms.
• Installed and configured Hyperion financial reporting studio, web analysis and Hyperion spread sheet add-in in the client systems.

Environment: Hyperion Essbase 11.1.2/ 9.3.2 , EAS, EIS, Hyperion Planning 11.1.2/9.3.2 , Hyperion Financial Reporting 11.1.2, MAXL, SQL server 2005.

Confidential, LA, CA

Hyperion Essbase Developer

Responsibilities:

• Member of Hyperion Essbase development team, duties involve creating, redesigning, testing, documenting, reporting, protecting, supporting and administering the full life cycle of multidimensional database development using the Hyperion EPM suite.
• Designed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual and other variance explanations data.
• Created Financial Reports using Hyperion Financial Reporting based on the business requirement.
• Involved in maintaining users and groups in Hyperion Essbase applications and provided 24/7 technical support.
• Developed automation scripts (batch scripts) and involved in performance monitoring and troubleshooting
• Managed BSO and ASO cubes and improved their performance through tuning: recognizing design issues, eliminated fragmentation, sizing caches, grouped sparse dimensions together, optimized Essbase caches, fine tuning of cache settings usage of filters
• Automated data loads by build rule files and using MaxL in both interactive and batch modes, and also generated several MDX queries for ASO cubes.
• Involved in BSO to ASO conversions and created transparent partitions for the ASO cubes as target for BSO source cubes to enhance reporting
• Migrated Essbase Applications from development to production environment
• Detailed documentation for everyday easy to use maintenance guide for DBAs and Financial Controllers

Environment: Hyperion Essbase, Hyperion Planning 11.1.2, EAS, Essbase Excel-Add-in, MS SQL Server, Oracle 9i, Windows 2003, UNIX

Confidential, Kansas City, MO

Intern

Responsibilities:

• Supported existing cubes, problem identification, resolution and documentation
• Developed Load Rules to automatically validate the data and feed into Essbase
• Provided Production support to existing cubes
• Created users and user groups and applied security in Essbase
• Developed and implemented Dimensions and member Attributes
• Creating documentation of Essbase for the business users.

Environment: Hyperion Essbase 9.3.1/6.5, Essbase Administration Services7.1.2, MS SQL Server, Windows 2003, UNIX