SUMMARY

• Ten plus years of experience in design, analysis, development and administration of various applications in Hyperion Suite of Technologies.
• Experience in full cycle implementation of Hyperion Essbase, Planning applications, extensive experience in Administration of production applications.
• Expert in a full lifecycle development in a Hyperion Planning(EPM) environment from initial conception through implementation including Requirement gathering, design, development, testing, implementation, maintenance and administration of planning cubes with substantial knowledge on various planning components like Web forms, Security, Meta data maintenance, Business rules, Workflow, Task lists and Smart view for Office.
• Extensive experience in designing/developing applications in client/server OLAP environment using Hyperion Essbase, EAS, MaxL, Hyperion Financial Reporting.
• Robust knowledge and experience in Essbase cube designing, Data Load Rules, developed numerous complex calc scripts, involved in application tuning and optimization, MaxL Scripting, Report Scripts, Automation using Batch scripts.
• Troubleshoot, diagnose, and solve Hyperion Planning/ Essbase related issues - Proactive tuning, optimizing, and maintenance of the Hyperion applications.
• Excellent analytical and research skills along with conceptual skills and demonstrated experience on documentation & presentation. Demonstrated ability to adapt to changing tools and technologies as well as changing business needs.
• Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Ability to learn new tools, concepts and environments. Self-starter and Adaptive to new technologies.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities. Have subsequent experience as Technical Lead in managing a team and work closely with multiple teams, developers and users.
• Solid communication abilities; able to articulate and document technical solutions to clients, executives, vendors, and team members at all proficiency levels.
• Maintain keen awareness of new development technologies and industry trends. Expertise in knowledge transfer, and Project Documentation.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Oracle/Hyperion Tools: Oracle EPM 11.x/Oracle Hyperion 9.x/Hyperion 7.x/6.x, Oracle Hyperion Shared Services, Essbase, Planning, Calc Manager, Workspace, EAS, MAXL, ESSCMD, MDX Scripting

Operating Systems: Windows 9x/2000/XP,2003 Server

Other Skills: Expert Level skill in MS Excel, MS Word and MS Powerpoint

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Hyperion Administrator

Responsibilities:

• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies
• Involved in gathering/analyzing new requirements for Essbase and planning application
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds
• Automated the data load process by using ESSCMD and Maxl Scripts
• Developed batch scripts for automating the dynamic dimension builds and data loads.
• Assured optimal match between cube design and report specifications
• Developed partition scripts between source and target cubes
• Maintained cubes and took regular backups
• Involved in performance tuning, backup and recovery of cubes
• Optimized dense and sparse database settings for improving retrieval times
• Involved in creating the security filters, creating new users and updating the groups using Hyperion Shared Services (HSS)
• Designed and involved in development of two cubes, for budgeting and planning
• Involved in creating the workflows for the planning and budgeting versions
• Created Data forms, business rules and task lists in Hyperion Planning application(EPM)
• Created reports using financial reporting and involved in decision making for future fiscal years by forecasting and budgeting
• Involved in scheduling the batches for FR reporting using Hyperion workspace
• Coordinated with the team for migrating Essbase cubes and reports from Development environment to Functional and UAT environment
• Assisted on system upgrades and client installations based on user’s requirements
• Arranged meetings with the users and assisted/guided them regarding the web forms built for planning and budgeting applications and also provided them the required documents for the workflows

Environment: Oracle Hyperion Planning 11.1.1/9.3.1 , Hyperion Essbase 11.1.1.3, Hyperion Workspace 11.1.1, Hyperion Shared Services

Confidential, Morristown, NJ

Hyperion Essbase Developer

Responsibilities:

• Involved in gathering/analyzing new requirements for Essbase and planning application
• Created BSO applications and automated the process for data load using Maxl scripts and batch scripts
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds
• Was responsible for assigning work for the DBAs related to Hyperion suite products, and conduct meetings with the business units to gather new user requirements, build road-map and the plan targets/deadlines
• Created web forms, business rule and workflows in Hyperion Planning application(EPM)
• Created reports using financial reporting and involved in decision making for future fiscal years by forecasting and budgeting
• Designed several custom reports using Hyperion System 9 Interactive Reporting for Corporate reporting processes (Monthly, Quarterly and Annual)
• Worked with Hyperion workspace to schedule the batches for FR reporting
• Involved in installation of Hyperion Planning on Windows environment
• Involved in database and security refreshes in Hyperion Planning
• Creating financial reports on planning application
• Involved in the Essbase migration of 9.3 applications to 11.1
• Validated, tested all the 9x applications from development before migrating to 11x production environment
• Tested all the scripts, rules, and Meta data’s in 9.3 development before migrating to 11 x production.
• Migrated Essbase cubes, web forms, reporting scripts, calculation scripts, business rules, Meta data from 9.3 to 11.1

Environment: Oracle General Ledger, Hyperion System 11.x/9.x BI+Analytic Services, Oracle EPM 11.1.2.1(Smart view/Work space/planning/reporting). Hyperion Administration Services 11.1.1.2, Hyperion Workspace 11.

Confidential

Hyperion Essbase Developer

Responsibilities:

• Responsible for end-to-end implementation activities such as design, development, testing and user training
• Worked on Hyperion system 9 BI+ to create various BSO applications for budgeting, planning and forecasting
• Created and modified load rules, Dimension building and Business Rules
• Performed data loading from external sources to populate the database by free form data load method or rules file to plot values to the outline
• Created and maintained Essbase financial application objects including outline, Calc scripts and data load rules and user security objects
• Examined all standard and attribute dimensions and members in the Essbase outline editor for optimization and performance
• Used MaxL and Esscmd scripts to create batch files for database optimization
• Responsible for tuning the multidimensional cubes to optimize calculations time by using the calculation scripts using the combination of ESSCMD and Maxl
• Worked on performance tuning to minimize data load time that was feeding Essbase Cubes using various external database systems
• Optimized dense and sparse database settings for improving retrieval times
• Involved in performance tuning, backup and recovery of cubes

Environment: Windows NT, Hyperion Essbase 11.1.1.2, Essbase Spreadsheet Add-In, Essbase Integration Services 11.1.1.2, Web Analysis, MS Excel, SQL, Oracle log