SUMMARY

• Solid 7 years experience in design, analysis, development and implementation of Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Hyperion Financial Reporting, Web Analysis, Smart View for Office, FDM, FDMEE, ESSCMD, MaxL, MDX, Essbase Excel Add - in on Windows environment.
• Experience in Calc scripts, MaxL, ESSCMD, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
• Experienced in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis, Business Process Modeling, Project planning and creation of user cases.
• Skilled in automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
• Involved in maintenance, automation, backups, Performance tuning and Optimization of both ASO and BSO databases, calc scripts/business rules to facilitate effective business decision making.
• Capable of managing organization’s data, assess and fulfill its reporting needs and develop powerful BI solutions that have true impact on the performance of a company.
• Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
• Scheduling loading of data, and writing scripts to perform loads and calculations, Essbase Partition database models and Essbase Block Storage database models.
• Database optimization and performance-tuning expertise with Essbase.
• Creating innovative solutions to automate processes.
• Monitoring and support of Hyperion Essbase Business Intelligence applications and batch load processes to ensure the highest level of system availability.
• Support user training, documentation, and rollout of new projects. Expert in Diagraming Processes using Microsoft Vizio
• Excellent communication and interpersonal skills with ability to be a team player and team leader.
• Thorough understanding of multidimensional and relational database architecture and their applications for effective planning, budgeting, strategizing and forecasting procedures.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

• Hyperion Essbase 11.1.2.3
• Hyperion Planning 11.2.3
• Hyperion FDMEE 11.1.2.3
• EPMA 11.1.2.3
• Hyperion Shared Services 11.1.2.3
• Workspace
• Hyperion SmartView
• Hyperion Financial Reports
• Windows XP

PROFESSIONAL EXPERIENCE

Confidential - MELVILLE, NEW YORK

FINANCIAL SYSTEMS CONSULTANT

RESPONSIBILITIES:

• Participated in regression testing of the application and documents test results
• Involved in project plan upgrade from Hyperion 11.1.2.3 to Version 11.1.2.4 environment
• Participated in historical data verification, build and documentation of month-end validations
• Participated in monthly load and verification of subsidiary month-end financial reporting results where appropriate
• Assisted in the management of end-user relations, including training needs, troubleshoot installations, administer security access, and system outages for a world - wide user community
• Administered security rights for system access
• Participated in reviewing, performing, testing, documenting, implementing and communication approved changes
• Worked in redesigning, testing, documenting and implement FDM, FDMEE, and Essbase script changes
• Participated in alignment of HFM and Essbase applications with data provided by Planning for purposes of loading reiterations of budget and RO data
• Documented existing system process and updates for approve process change
• Worked with user community and 3rd party contract help, by providing system enhancement solution options, for design, build, test and implementation
• Worked with IT in terms of application and Development, QA, and Production environment support and ongoing server/environment health
• Participated in fulfilling of audit requests
• Participated in special projects and performed other duties as required

ENVIRONMENT: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.2.3, Hyperion FDMEE 11.1.2.3, EPMA 11.1.2.3, Hyperion Shared Services 11.1.2.3, Workspace, Hyperion SmartView, Hyperion Financial Reports, Windows XP

Confidential - NEW YORK

HYPERION CONSULTANT

RESPONSIBILITIES:

• Assisted the manager in creating and managing project schedules and plans (Cube build and calc script development, General Expense/Allocation model, Balance Sheet budgeting, P&L Budgeting, Workforce Planning and CapEx Planning)
• 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.
• Used experience in Automation using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications.
• Worked Extensively on Shared Services, Essbase applications 11.1.1.3.
• Involved in administrative activities such as setting up users, security groups and access filters to set the security policy and to ensure maximum security.
• Acted as the technical lead for Hyperion Essbase related issues including providing technical support for users and supervisors.
• Technical support for existing cubes, problem identification, resolution and documentation.
• Developed Batch and Rules files to load data from financial system’s database to Essbase cube. Created and scheduled batch jobs for complete automation processes for nights and weekends application backup.
• Involved in unit test plans / system test plans, UAT plans, quality assurance test plans and test strategies.

ENVIRONMENT: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, EPMA 11.1.1.3, Hyperion Shared Services 11.1.1.3, Workspace, Hyperion SmartView, Hyperion Financial Reports, Windows XP

Confidential - NORWALK, CONNETICUT

HYPERION CONSULTANT

RESPONSIBILITIES:

• Rebuilt the dev environment, patched both prod and dev.
• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Consolidated business rules and calc scripts
• Developed process to Load Actual data into Planning to provide consolidated Actual, Forecast and Budget data to support variance reporting
• Update the member formulas, calculation scripts and business rules as per the new Teams, Departments and Company dimension in application in 11.1.2.3 environment.
• Worked on the modification of business rules, calc scripts and member formulas to calculate data as per the new combination of data
• System testing of the new combination of data mapping and data calculation.
• Worked on creating the Maxl scripts to execute the calculation scripts.
• Designed, developed and supported financial and management cubes and reports
• Develop Rules file and perform Monthly loading of metadata and data
• Developed and implemented Dimensions and member Attributes
• Involved in budgeting application using Hyperion Planning
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube; develop MDX queries.
• Built several custom reports using Hyperion Financial Report V 11.2.3 for corporate reporting processes (Monthly, Quarterly and annual) as well as for each business units.

ENVIRONMENT: Hyperion Essbase 11.1.2.3, Essbase Administration Services, Excel Add-In, Web Analysis, Windows Server 2003.

Confidential - BASKING RIDGE, NJ

HYPERION ESSBASE DEVELOPER

RESPONSIBILITIES:

• Production support for the existing planning application in 11.1.2.3 environment.
• Migration of Essbase applications from 9.3.1 to 11.1.1
• Involved in development, maintenance and support of Essbase cubes
• Coordinated with business analysts / clients to understand and develop an optimized Essbase cube.
• Created users, user groups and administered security for multiple applications
• Wrote batch commands and scripts in EssCmd and MaxL
• Worked extensively on security and access settings for the reports and cubes in Workspace and Shared Services
• Worked closely with the users during the pre and post implementation phases to make sure there are no bugs in the application and that the application meets the requirements specified.
• Formulated different design and support documents for the applications.
• Maintain Documentation for installation and troubleshooting procedures of the application.
• Written and executed unit test plans / system test plans, quality assurance test plans and test strategies.
• Migrated Financial Data Quality Management Application from one environment to another
• Built simple and complex views of data; created spreadsheet reports, and graph displays

ENVIRONMENT: Hyperion Essbase 11.1.2.3, Essbase Administration Services, Excel Add-In, Web Analysis, Windows Server 2003.

Confidential - PITTSBURGH PA

HYPERION ESSBASE DEVELOPER

RESPONSIBILITIES:

• Performed requirement analysis which included compiling an inventory of existing reports in several formats and analyzing the reports to define the dimensional requirements for a new Hyperion Essbase Sales Analysis Cube
• Involved in defining requirements and specifications for a relational data mart to support the Essbase databases
• Designed and developed numerous complex Essbase applications and developed an excellent understanding of appropriate use of the different storage options in Essbase
• Created large, high volume cubes using ASO option
• Created BSO application to support Financial Budgeting and Forecasting
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).
• Created end user reports using Financial Reports and Web Analysis
• Developed Excel reports using the advanced member selection techniques
• Performed structured unit and integration testing of data load rules, member formulas, calc scripts and other system components
• Researched, identified and fixed data errors using Essbase log files, data load error files, ad-hoc retrieves from Excel
• Developed Hyperion Planning application including dimensions, web forms, business rules and smart lists
• Developed process to Load Actual data into Planning to provide consolidated Actual, Forecast and Budget data to support variance reporting
• Worked directly with forecasters and planners and assisted them with data analysis
• Setup and maintained user access and security
• Used best practices to optimize calculation and query times

ENVIRONMENT: Hyperion Essbase 11.1.1.3, Essbase Administration Services, Excel Add-In, Web Analysis, Windows Server 2003.

Confidential - ATLANTA GA

HYPERION ESSBASE DEVELOPER

RESPONSIBILITIES:

• Participated in all aspects of the project lifecycle to develop a Sales Reporting platform that included detailed monthly, quarterly and yearly sales cubes
• Gathered requirements and developed detailed project plan
• Designed and developed the application including development of the Essbase outline, data load rules, calc scripts and outline member formulas
• Developed system automation scripts for batch loading of data from source financial systems
• Involved in weekly meetings, to discuss current project status with stakeholders
• Provide post-production support of the Sales reporting cubes as well as other Planning and Essbase applications
• Monitored Data Loads and system performance
• Optimized Data Loads and Calc Scripts as necessary
• Modified member formulas, load rules per monthly change control process
• Supported Planning Application, which includes web forms, business rules, smart list. Also provided access to users based upon their role
• Worked directly with end-users to provide support, analysis and reporting

ENVIRONMENT: Hyperion Essbase 9.3.1, Essbase Administration Services, Excel Add-In, Planning, Shared Services, Workspace, Windows Server 2003.

Confidential - MORRISVILLE NC

HYPERION ESSBASE DEVELOPER

RESPONSIBILITIES:

• Performed requirement analysis for the creation of a new Essbase database to store and reporting company financial information
• Designed, built and deployed an Essbase database including the outline, data load rules, calculation scripts and Maxl Scripts for automated outline maintenance and data loading
• Optimized Outline, data load rules and calculation scripts
• Created fully automated processes for loading data and maintaining the Essbase databases using Maxl and batch scripts including routine backups and cube optimization
• Performed system testing and debugging. Identified data errors and traced back to source systems
• Supported existing Planning Application which included making enhancements and changes to web forms, business rules, smart lists and security filters based upon user roles
• Provided end-user application support
• Developed end-user documentation

ENVIRONMENT: Hyperion Essbase 7.2.1, Hyperion Essbase 9.3.1, Essbase Administration Services, Essbase Integrations Services, Excel Add-In, Windows Server 2003.