SUMMARY:

• Management Post Graduate with overall 7yrs of IT work experience.
• Extensive hands on expe rience in Hyperion Suite of applications - Design, analysis, development and implementation of various applications utilizing Hyperion Planning, Essbase.
• Involved in analysis, design, testing, implementation, maintenance, production support and knowledge transfer with good analytical and problem solving skills.
• Good understanding of development in Hyperion Planning and Essbase artifacts.
• Experience in Shared Services, LCM; Artifacts level security, backup processes.
• Working knowledge on Hyperion components installation.
• Involved in complete Software Development Life Cycle (SDLC) for Essbase and planning projects.
• Functional background about Gathering and Analyzing the Requirements of users and translating them into specifics cube definitions and Design.
• Functional knowledge of Budgeting and forecasting process.
• Experience in driver based budgeting and forecasting.
• Worked in close relationship with Project manager and finance planning analyst’s teams.
• A thorough professional with proactive attitude, capable of thinking in and out of the box, generating new design solutions and ideas.
• Excellent interpersonal, communication and organizational skills with proven abilities in team and customer management.

PROFESSIONAL EXPERIENCE:

Confidential, Sunrise, FL

Hyperion Planning Consultant

• Worked on driver based estimate planning application development. It’s a target based forecasting tool used to derive estimates from the actuals.
• Worked on building and provisioning interactive data forms and complex business rules.
• Part of continuous process of providing status updates and customer discussion on weekly basis.
• Provide end user support to assist with application training.
• Writing Essbase Calculation Scripts, Hyperion Planning Business Rules using Calc Manager
• Validate Hyperion systems after patches are installed and after environment refreshes are performed
• Use Hyperion Shared Services to maintain Planning and Essbase security
• Used LCM for migrating Hyperion artifacts across different server instances.
• Involved in preparing the documentation of the processes and provided it to the required team.
• Summarize the changes to support team by scheduling knowledge sessions.
• Involved in analysis, design and development as per the change request discussions.
• Held responsible for few changes in production support for existing Hyperion Essbase and Planning Applications.
• Involved in day-to-day operations of Hyperion EPM tools as well as cross-functional applications and systems for Essbase.
• Loading actual budget execution data into Planning Applications using data load rules.
• Created MaxL scripts to import and export data and ensure proper Backups are maintained which can be restored in case of complex issues.
• Involved in Preparing the Knowledge entries of the processes and provided it to the required team.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• SPOC for SOX and KPMG Audit.
• Created Aggregate Storage (ASO) application from the Block Storage (BSO) applications for executive level reporting.

Confidential

Hyperion Essbase Planning Consultant

• Involved in the discussions with Business Analysts to determine design process requirements and definitions.
• Involved in the Business requirements and Technical design documents review and updating meetings to meet the current requirements.
• Created Classic Planning applications for multi currencies, and loaded the metadata into Planning application using Outline Load Utility.
• Developed and customized Data Forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache.
• Developed Rules file and perform Monthly loading of metadata and data.

Confidential

Senior Associate

• Developed the Member Formulas and Complex Business rules to perform allocations based on different drivers.
• Participated in Optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Involved in database and security refreshes in Hyperion Planning
• Expertise in Essbase security features and ability to create user and group profiles for assigning proper privileges using both Native security and Shared services modes.
• Worked with the Planning Unit and Process management reviewing process.

Confidential

Incident management Support

• Manage incident management bridge calls with support teams, on-call support application teams and maintain SLA’s for the issues.
• Manager Escalations - provide first point of escalation within the P1M team
• Monitors the effectiveness of incident management and Service Request fulfillment and makes recommendations for improvement.
• Assist with the development of processes and procedures to improve incident response times, analysis of incidents.
• Trained new hires created and provided documentation to help assist them in performing the job.
• Understand and Implement ITIL standards in the day to day support tasks.
• Ensured that all IM team members followed the incident management process, SLA’s for every incident.
• Motivate the IM team members to perform their tasks.
• Maintaining information about Known Errors and Workarounds.

TECHNICAL SKILLS:

OLAP Tools: Oracle Hyperion Essbase 11.1.2.X, Planning 11.1.2.X

Reporting Tools: Hyperion Financial Reporting, Smart View & Excel Add-ins

Languages: MDX, MaxL, ESSCMD, SQL

Operating Systems: MS Windows XP/ 2000/03/08/10

Databases: Oracle 11g

Incident Management: BMC Remedy, Service-Now