SUMMARY:

• Hyperion Essbase/Planning Developer with solid 12 years of experience in Implementing Hyperion Essbase and Planning applications
• Met with clients to understand business processes and to gather system requirements with subsequent application design and implementation using best practice implementation techniques
• Work well with offshore/onsite models team members and orchestrate the efforts of the project team to map out planned tasks and ensure that work efforts are optimized
• Hands - On experience in design, Development and tuning Essbase database and also well versed in Essbase Architecture, Calculation Scripts, Business Rules, Aggregate Storage Option (ASO), Block Storage Options (BSO), MDX Member calculations, ESSCMD, MAXL for Batch scripting
• Involved in multiple Hyperion System 11.x implementations
• Familiar with Relational Databases, SQL Server and Oracle.
• Experienced in all phases of the project, Requirement Analysis, Design & Development, UAT and Production Maintenance
• Extensively used Essbase Shared Services as centralized framework to create and maintain users for managing user security across all Oracle Essbase modules including external authentication using Lightweight Directory Access Protocol (LDAP), NTLM (NT LAN Manager), Oracle Internet Directory (OID) and Microsoft Active Directory (MSAD)
• Hands on experience in Creation and Maintenance of Hyperion Planning applications, Business Rules, Web forms, Security Groups and Users etc.
• Well-versed in Business Problem analysis and design/development/implementation of analytical solutions
• Good inter-person skills and a very friendly in nature

PROFESSIONAL EXPERIENCE:

Confidential, White plains, NY

Senior Consultant

Responsibilities:

• Participated in Requirement analysis phase and gathered reports in several formats, analysed the reports to design a Hyperion Essbase Cube (ASO & BSO) for sales Analysis
• Developed Hyperion Essbase application for Global sales system
• Served as a solution delivery expert for the design and implementation of Hyperion Planning Tools and Reporting
• Designed and conducted User Acceptance Testing
• Ensured all deliverables were completed within budget and on time
• Engaged with stakeholders and subject matter experts to capture feedback via regular User Experience Testing sessions
• Ensured all user stories were tested and moved into accepted status after review
• Coordinated the development and simulation of new process/operational flows
• Created complete database outline which included Developing Outline & Data load rules, calculation scripts, and Maxl Scripts for automated outline and data loading
• Optimized Outline, Data load rules and Calculation Scripts, created alternate hierarchies, manipulated data columns to suite Dimension builds, Tested Data load rules, fixed errors from the error log files
• Resolved issues of data retrieve from Excel; Developed Excel reports using the advanced member selection techniques, for performance improvements tried several Sparse/Dense combinations to reduce the block size.
• Performed tuning on existing Essbase cubes, sorted data by sparse dimension which reduces the data load time significantly.
• Executed database and security refreshes in Hyperion Planning. Created web forms, Business Rules and provided access to appropriate users.

Environment: Hyperion Planning, Hyperion Essbase Version 11.1.2.4, SmartView 11.1.2.5, Hyperion Financial Reporting Studio 11.1.2.4

Confidential, NY, NY

Hyperion Planning Developer/Admin

Responsibilities:

• Involved in Installation and Configuration of Hyperion Tools on different environments.
• Responsible for gathering requirements and developing a project plan.
• Involved in installation of Planning, EAS, Workspace, Shared Services, and configuration of these products.
• Implemented Hyperion Planning and Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
• Involved in system installation, configuration and software upgrades of Hyperion Product Suite.
• Created batch scripts and scheduled them using windows scheduler, automating the process to run ESSCMD/Maxl to take regular backups, used windows scheduler to schedule these backup tasks.
• Participated in outlining requirements and development of a project plan with business personnel.
• Involved in building dimensions in ASO.
• Responsible for creating users, groups and filters.
• Involved in making the Essbase backups and restores of Essbase application. Implemented robust data-access security and user management.
• Performed Optimization using Hour glass design technique, during Data Loads and while calculating.
• Performed Performance tuning by using the dense/spares settings and developed the required alternate rollups for reports.
• Responsible for developing Financial & Internal Reports using Hyperion Financial Reporting Studio Version 11.1.2.4.
• Created various reports for Credit, Debit and Liability.
• Created Monthly Inventory Reports, Fulfillment Reports for different clients
• Developed various scripts like Date for the reports to run automatically in the specified time period like Monthly, Weekly, and Daily.
• Involved in the System Testing and Unit Testing of the Reports Using Toad.
• Involved in Automation of the Reports to run in PDF, HTML and MHTML formats and send as attachments to people across the business.

Environment: Hyperion Planning, Hyperion Essbase Version 11.1.2.4, SmartView 11.1.2.5, Hyperion Financial Reporting Studio 11.1.2.4, Oracle Toad Express.

Confidential, Melville, NY

Sr. Hyperion Essbase Developer

Responsibilities:

• Made Meta data changes in EPMA prod environment before deployment to ESSBASE.
• Exported and imported the database in EAS in order to push the new added Meta data into ESSBASE.
• In EPMA added new cost centers and made sure that the new ACQ entities are tagged.
• End of the month updated the substitution variables in EAS for current period, Current year to date, current quarter to date, and current year.
• From EPMA Validated month end start dates to ensure task automation triggers are in sync for Essbase applications.
• Updated the filter period for the data sync.
• Loaded currency rates to Essbase applications.
• Performed Life Cycle Management process when required.
• Added security when required for new users.
• Updated the system for the next R+O submission for Essbase and HFM.
• Updated year budget via FDM.
• In HFM did consolidation when required

Environment: HFM, JDE, Smart View 11.1.2.4, FDM, Essbase Administration Services, Microsoft Active Directory.

Confidential, Pittsburgh, PA

Sr. Hyperion Essbase/Planning Developer

Responsibilities:

• Installed and configured Hyperion Essbase, Hyperion Planning and Hyperion Balance Sheet Planning on Linux Servers
• Configured Hyperion Balance Sheet Planning application in Development, Test, QA and Production environments
• Taking Hyperion Essbase, Planning and Balance sheet Planning applications and data backup
• Installed Hyperion patches on servers, started and stopped services as required
• 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 Planning 11.1.2.3, MS SQL Server 2005, Smart View 11.1.2.5, Red Hat Linux 5.6, Essbase Administration Services, Microsoft Active Directory, Siteminder, WebLogic, OHS, Harvest, Informatica, Balance sheet Planning, Financial Reporting Studio 11.1.2.3.

Confidential, Philadelphia, PA

Hyperion Essbase Developer

Responsibilities:

• Developed Hyperion Essbase applications for Confidential ’s Analysis Information management group for sales planning and budgeting
• Developed Outline & Data load rules, calculation scripts, Created alternate hierarchies, Manipulated data columns to suit Dimension builds
• Used Essbase Administration services to assign filters and wrote Maxl and esscmd scripts to perform Automation of cube building process which includes Building Outline, running load rule, running calculations scripts and partitioning
• For tuning and Optimization purpose created partition and changed to dense and sparse configuration

Environment: Hyperion Essbase 11.1.1.3, MS SQL Server 2005, Essbase Spreadsheet Add-In, Windows 2003, Essbase Administration Services, Microsoft Active Directory, Hyperion Planning, Workspace and smart View.

Confidential, Morrisville, NC

Hyperion Admin

Responsibilities:

• In a Sales, Planning and Forecasting application, created complete database outline which included Developing Outline & Data load rules, calculation scripts, and Maxl Scripts for automated outline and data loading
• Optimized Outline, Data load rules and Calculation Scripts, Created alternate hierarchies, Manipulated data columns to suite Dimension builds, Tested Data load rules, fixed errors from the error log files
• Resolved issues of data retrieve from Excel; Developed Excel reports using the advanced member selection techniques, for performance improvements tried several Sparse/Dense combinations to reduce the block size.
• Performed tuning on existing Essbase cubes, sorted data by sparse dimension which reduces the data load time significantly.
• Also, for Planning, performed database and security refreshes in Hyperion Planning. Created web forms, Business Rules and provided access to appropriate users.

Environment: Hyperion system 9.3.1, MS SQL Server 2005, Essbase Spreadsheet Add-In, Windows 2003, Hyperion Financial Reports.

Confidential, New York City, NY

Hyperion Essbase Developer

Responsibilities:

• Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube (ASO & BSO) for sales Analysis
• Developed Hyperion Essbase application for Global sales system, created complete Essbase database which included Developing Outline & Data load rules, calculation scripts, and Maxl Scripts for automated outline and data loading
• Optimized Outline, Data load rules and Calculation Scripts, Manipulated data columns to suite Dimension builds, Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel.

Environment: Hyperion System 9, MS SQL Server 2005, Essbase Spreadsheet Add-InWindows2000. Hyperion Web Analysis

Confidential, Hartford, CT

Hyperion Essbase developer/Admin

Responsibilities:

• As a team member of Essbase development, participate in gathering requirement and performing requirements analysis.
• Worked closely with DBA to create Star schemas to support Essbase Multidimensional database, defined the business dimension and created outline for the analysis.
• Created design documentations and perform Essbase development, which includes creating outline for the Essbase, creating load rules and using Gen, Level and Parent/Child methods
• Created data load rules to load data and write calculation script to perform calculations.
• Used best practices to choose Dense/Sparse configuration in Essbase and also order of the dimension for accurate results.
• I Utilized partitions to tune existing Essbase cubes, partitioned historical data into transparent partition to reduce maintenance time.