SUMMARY

• 7+ years of experiences in Hyperion Essbase, Hyperion Planning, Smart View, Excel Add - in.
• Excellent experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase 11x, hyperion Planning 11x, ESSCMD, Maxl, Essbase spreadsheet add-in, Oracle Smart view.
• Strong understanding of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes.
• Expertise in optimizing Data loads, indexing, MDX formulas, calculation scripts and Cache Management.
• Experience in design and development of Business Rules, Web Forms, Hyperion Financial Reports, Workflows, Task Lists, Menus and Smart Lists.
• Hands-On experiences in designing Essbase Internal Architecture, Aggregate Storage Option (ASO), Block Storage Options (BSO), MAXL for Batch scripting.
• Meet with clients to understand business processes and to gather system requirements with subsequent application design and implementation using best practice implementation techniques.
• Highly talented professional, strong technical and some functional experience with Hyperion products. Skilled in converting Business requirements into equivalent technical solutions. Worked often with Finance team.
• Possess Ability and Willingness to learn new applications and technology as needed.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in work/project environment. Versatile team player with excellent analytical, presentation and inter-personal skills.
• Change management tool used EasyVista and HP Service Manager
• Familiarity with PeopleSoft and SQL

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase & Hyperion Planning 11.1.2.4

Reporting Tools: Hyperion Financial Reporting Studio, SmartView

Application Tools: MS Office (MS Excel, MS Word, MS PowerPoint)

OS System: Oracle Solaris on SPARC (64-bit)

PROFESSIONAL EXPERIENCE

Confidential, Midtown, NY

Hyperion Administration

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning, 11.1.2.4, Essbase Administration Services, SmartView, Hyperion Financial Reports

Responsibilities:

• Administer Hyperion ASO: Managed daily load of P&L and BS from PeopleSoft via SQL. Maintaining/tracking of hierarchy/system updates, regular database maintenance, validation and reconciliation, backups and recovery, and troubleshooting system issues
• Planning BSO: Create or modify calculation scripts or business rules. Manage the development and maintenance of web forms, data grids, task lists and other templates.
• Research and coordinate resolution of system-related issues with the internal IT application support, outside 3rd party vendor as well as Oracle support. Assist to perform month-end closing data loads /help to reconcile data accuracy after automated data loading and facilitate of the manual data loading
• Creating new reports in Hyperion on an as needed basis
• Identify opportunities for improvement in efficiency and effectiveness of business operations
• Perform ad hoc requests, including some financial analysis
• Assist the Financial Analysts and management with other FP&A projects or tasks as requested, including investigations
• Execute set up and minimal training for new users
• Work with security team and financial to provide proper provision to users.
• Reconfigure Dev environment on Unix due to lost/corruption of database. LCM prod to UTA and DEV. Configure password and port number change due to audit request.
• Change management tool used to create incident, SR and CR: EasyVista and HP Service Manager

Confidential, NY

Senior Planning/Essbase Developer

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning, 11.1.2.3, Essbase Administration Services, SmartView, Hyperion Financial Reports

Responsibilities:

• Participated in requirement analysis phase and gathering
• Closely working with Finance team
• Weekly meetings on project status, any requirement gathering
• Developed Planning Revenue/Workforce application with excellent understanding of Hyperion planning implementation
• Build application metadata (Dimensions) and created variance reporting members
• Designed and developed Calculation manager scripts, including Global variables & application variables
• Designed and Developed Data load rules, calculation scripts, and Maxl Scripts for automated utline and data loading. Optimized Outline, Data load rules and Calculation Scripts
• Designed and developed planning web forms to input data and reporting purposes
• Designed Task list for budgeting and forecasting process
• Designed and implemented User security at dimensional level and object level (Web forms, Calc Manager Rules, Task list.)

Confidential, Canton, MA

Project Manager

Environment: Hyperion Essbase 11.1.2.1, Smart view, Essbase Administration Services.

Responsibilities:

• Involved in gathering requirements and developing a plan on batch jobs.
• Gather month to month job’s list that are critical for business.
• Strictly monitor nightly batch jobs using GDC support.
• Under the job dependency to avoid over collapsing of jobs.
• Submit daily status update on overnight jobs.
• Contact right person on job failures.
• During the month end reconcile the number between Hyperion & ODS.
• Involved in creating core documents on procedure’s & environment related.

Confidential, Virginia Beach, VA

Senior Planning/Essbase Developer

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning Essbase Administration Services, SmartView.

Responsibilities:

• Conducted needs analysis and documented requirements from business users to develop the project plan to design, develop and maintain various Essbase cubes.
• Developed outlines using load rules to load dimensions and members, load data into Essbase cubes.
• Optimized the database with reconfigured outline structure, updated data loads and calculations through appropriate dense and sparse settings of dimensions, modified data storage and consolidation properties and deployed dynamic calculations.
• Constructed calc scripts for allocations, eliminations, moving data, calculating formulas.
• Designed reports using Hyperion Financial reports illustrating performance categorized by service, client, and region.
• Implemented Shared Services for managing users/group access privileges and provided access to users based upon their role in the organization.
• Assisted in the support of various Planning applications, which included web forms, smart lists.
• Provided technical assistance and support to end users and was involved in developing documentation.
• Involved in testing and migration of cubes under different environments to insure security. Established linkages with Excel add-in tool and developed reports as per user requirements.
• Assisted in the support of various Planning applications, which included web forms, smart lists.
• Provided technical assistance

Confidential, Bridgewater, NJ

Senior Planning/Essbase Developer

Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning, 11.1.2.1, Essbase AdministrationServices, SmartView, Hyperion Financial Report

Responsibilities:

• Over time have acquire good understanding of Hyperion Architecture and design.
• Worked closely with Finance team
• Created Planning Applications (P&L and Project) based on clients need.
• Build dimension using Import and export Metadata Loading and Actual data loading.
• Experience in design and development of Web Forms, Hyperion Financial Reports, Workflows,
• Task Lists, Menus and Smart Lists.
• Loaded data manually and set up Automation techniques using MaxL Scripts into the outline - developed for data cube.
• BR and calc Script for Datacopy, Aggregation, Xref, Allocation and others with RTP and Substitution variables.
• Created many report in HFR with based on client request.
• Maintain outline, metadata, and member formulas as business requirement changes
• Security using Shared Services to create Users & giving Provisions and restricting permissions.

Hyperion Consultant

Confidential, NY

Environment: Hyperion 9.3.1 to Hyperion Essbase 11.1.1.3, Hyperion EPMA, Essbase Administration Services, SmartView.

Responsibilities:

• Involved in Migration from 9.3.1.to 11.1.1.3.
• Provide day-to-day administration and end user support of the Hyperion environment including troubleshooting both system as well as data issues. This includes questions and issues related to Hyperion Planning, Essbase, SmartView and Excel Add-in.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Maintain of Essbase application (BSO and ASO)
• Metadata Loading and Actual data loading using Outline Load Utility
• Optimization of Cubes while loading, retrieving and calculating using different techniques (Hourglass method, Cache Settings and others).
• Develop all reporting needs using Hyperion Financial Reporting.
• Provide end user support for training, questions and issues related to Hyperion Planning, Essbase, Smartview and Excel Add·In
• Analyze and implement best practices. Recommend and support system enhancements.