SUMMARY:

• 7 plus years of professional IT experience in OLAP, Business Analysis, Requirements gathering, Designing, Developing and Testing of Hyperion Enterprise Performance Management EPM applications.
• Have strong experience in installing Hyperion 11.1.2.1, Hyperion foundation services, EPMA, Essbase server, EAS, APS, Hyperion Financial Reporting and Analysis, Planning, HFM, FDM.
• Strong experience in Hyperion Planning 11.1.2/11.1.1.3/9.3.1/4. x,Hyperion Essbase 11.1.1/9.3.1/7. x, Hyperion Financial Reporting, Hyperion Web Analysis (Web Analyzer).
• Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of financial applications
• Experience and proficiency in functional and technical development for Hyperion Planning 9 application involving budgeting, strategic planning, forecasting and workforce planning. Experience in application implementation in different industry sectors. Solid understanding of Planning architecture and solutions expected by client.
• Well experienced in Planning Application implementation from end to end includes architecting, designing the metadata, building, loading data. Worked with Business unit, Process unit, Review process, Rules.
• Extensive experience on the configuration, server settings, backups, client installations of Hyperion products such as Hyperion Essbase, Hyperion Web Analysis/Analyzer, Hyperion Financial Reporting/Reports on Windows.
• Extensive experience in creating reports using Financial Reports, Essbase Excel Add - In, Hyperion Analyzer, Smart view, EIS, MDM or DRM, ODI, EPMA.
• Hands-on expertise in Dynamic dimension building, Data Loading using Rule files, creating Ad-hoc reports using Excel Add-In, Hyperion smart view.
• Expertise in writing Calc Scripts, Report Scripts and Load rules.
• Implemented/Installed the EPM applications Essbase 11.1.1(1, 3)/9.3.1/, Planning 11.1.1(1, 3)/9.3.1 in Windows Server 2003.
• Extensive Knowledge of ESSCMD, MAXL scripts, Member Formulas and Essbase Analytic services.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Up gradations, Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.
• Involved in developing Web forms using Hyperion planning web client for the users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Possess skills in managing, developing and implementing the project. Possess excellent analytical, interpersonal, logical, communication skills, reliable and great team player.
• Experienced in knowledge transfer, preparing the required documentation and the clients.
• Substantial experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading,
• Highly organized with proven ability to prioritize, manage multiple tasks, and meet deadlines with deliverables.
• Excellent communication and interpersonal skills and outstanding team player with an aptitude to learn.

TECHNICAL EXPERTISE:

OLAP Development Tools: Hyperion Planning 11.1.1/9.3.1/4. x, Hyperion Essbase 11.1/9X/7.x/6.5/6.2 Hyperion System 9.3.1 BI+, Hyperion System 9.3.1 BI+ Analytic Administration Services, Hyperion System 9 Application Link (HAL), Hyperion System 9 BI+ Financial Reporting, Hyperion Planning, Hyperion Web Analyzer, Esscmd, MaxL, Hyperion Reports, Hyperion Enterprise and Hyperion Essbase Administration Services console (EAS), ASO/BSO, Hyperion Data Integration Management (DIM).

Dimension Modeling: Star-Schema Modeling, Snowflake Modeling, Fact and Dimension Tables.

Databases: Hyperion Essbase 11.x / 9.x / 7.x, SQL Server 7.0, Hyperion Planning, Oracle 8i9i,10g, MS Access..

Languages: MDX, MaxL, ESSCMD, SQL, PL/SQL Scripting.

Operating Systems: Windows NT 4.0/XP/2000/2003 and UNIX.

Computer Software: Microsoft Word, Excel, PowerPoint, Access, Outlook, Stat graphics, SPSS.

Reporting Tools: Hyperion Analyzer 7.x/6.x/5.x, Hyperion Financial Reports 9.x/7.x/2.x,Smart View, Essbase Excel Add-in

PROFESSIONAL EXPERIENCE:

Confidential, Confidential, St. Louis, MO

Hyperion Admin/Consultant

Roles and Responsibilities:

• Managed the Enterprise and Essbase servers
• Created reports for management purposes using Hyperion Enterprise.
• Managed and maintained the daily automated feeds to the Essbase cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Troubleshoot the failed jobs.
• Setting up new users for Essbase using EAS and Enterprise using the Security module and external authentication. Maintained application security and added/deleted users per management requests.
• Developed filters to restrict uses from accessing restricted dimensions and assigned substitution variables
• Loaded oracle extracts into the database.
• Help users with installing the Essbase Client, Enterprise Client and help them run the reports.
• Troubleshoot any requests from users.
• Validate data quality between sources (Info cube) and target (Essbase cube).
• Maintain the database to match the revenues and also upload the data to merge with existing Financial data.
• Working on optimization of ASO cubes.
• Assisted end-users with developing complex reports to meet requirements.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Excellent technical, oral, communicational and analytical skills. Admirable interpersonal abilities and an efficient team player.
• Demonstrated ability to work as part of a team to analyze complex business requirements and translate them into business intelligence solutions.

Environment: Hyperion Planning v.11.1/v.9.3.1/3, Shared services, Workspace, Hyperion Essbase v. 9.3.1/3/11.1.2, Essbase Integration Services(EIS), Essbase Studio, Hyperion Interactive Reporting Studio, Hyperion Web Analyzer, Smart view, Essbase Spread sheet add-in, Oracle 10g, Toad v.9, MS SQL Server, Windows server.

Confidential, Erie, PA

Hyperion Essbase/Planning Consultant

Roles and Responsibilities:

• Developed Multi-Currency Hyperion Planning Applications 11.1.2 for Planning and Forecasting.
• Involved in Requirement gathering.
• Involved in implementation of decided budgeting process involving planning units, starting review process, and entity hierarchy and workflow notifications.
• Loaded the Metadata Using Outline Load Utility.
• Created and managed data forms, involved in implementation of decided budgeting process involving planning units, starting review process, and entity hierarchy and workflow notifications.
• Utilized validation Rule in Data form to Validate Balance Sheet.
• Created Menus and attached to Data form where users can open excel and Input data into excel and submit Data using VBA. Automated the Process to save and load data from this excel into the Planning application with wrapper that checks the update every 2 minutes.
• Optimized the Designs of Data forms.
• Created Business Rule with Run time prompts for Web Forms using Global variables.
• Managed Exchange Rate Tables, Tailored Currency Conversion Calculation Script per the Business requirement to achieve Currency Conversion in Asian Currencies and USD and also based on Plan rate, forecast rate, with Balance Sheet accounts using the EOM Rate while others using Average Rate.
• Extracted Actual Data from HFM using Extended Analytics into SQL and then loading data in Hyperion Planning application using Rules files.
• Involved in Data Mapping and Validation for Actuals.
• Automated the Actual data load process including Scheduling the Extended Analytics jobs.
• Created Task Lists and User Instructions for the easy Workflow.
• Setup User security according to business requirements, restricting the views by dimensions, Entities. Creating Security Groups in Shared Services, assigning access.
• Wrote MAXL scripts to automate these cubes in Development, Testing and Production environments.
• Involved in Partitioning with another BSO cube for Reporting.
• Responsible for end to end build and testing of all the applications.
• Created Design Documents, User Documents, and Knowledge Transfer document.
• Assisted User in Testing, Troubleshooting.
• Created Reports, Books for Financial Statements including Income Statement, Balance Sheet, Variance, KPIs, Summary Reports, allowing users to select the Currency they want to see the data in, with custom formulas for calculations
• Extensive usage of substitution variables and setting appropriate values in them using MAXL/EAS.
• Created/Modified Calculation Script for Existing Application in Production.
• Responsible for all the scripts migrations and their validations in all the environments.

Environment: /Tools: Hyperion Workspace, Hyperion Planning, Hyperion Essbase,11.1.2, HFM, Extended Analytics, Windows Server 2008 R2 Enterprise, Smart view, Hyperion Financial Reporting, Outline Load Utility, SQL Server 2008, VBA, MAXL Scripts.

Confidential, New Haven, CT

Essbase Developer/Planning Consultant

Responsibilities:

• Created dimension building load rule and data load Rule for dynamic dimension building, attribute dimension building and data loading in Essbase.
• Used Essbase Administration activities such as filter creation, creation of users and creation of groups and maintenance of Essbase Servers.
• Was involved in the installation of Hyperion Essbase 9.3.0
• Involved in performing DBA activities like create users, password setting, group and filters. Involved in making the Essbase backups and restores of Essbase application.
• Customize of the planning process, to meet the needs of global enterprises
• Integrated with Hyperion Planning System 9 data for reconciliation, forecasting, and reporting
• Integrated with other systems to load information: with flat files for Enterprise Performance Management Architect applications, and typically with Hyperion Data Integration Management Adapter for Planning or Hyperion Application Link Adapter for Hyperion Planning for Classic applications
• Implemented robust data-access security and user management.
• Developed the project plan for the implementation that identifies the schedule, task, milestones and requirement.
• Implemented star schema and used EIS to interface with the company’s existing Oracle 10g data warehouse.
• Implemented Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
• Provided budgeting and forecasting solutions that integrates financial and operational planning processes using Hyperion Planning - System 9.
• Involved in the designing of Essbase Applications like financial budgeting, forecasting with HFM (Hyperion Financial Management).
• Created Dashboard layout to identify trends and organize critical data.
• Developed GUI screens by using VBA to provide the substitute variable for calculation scripts to help users to substitute different values to the calculation scripts and analyze the data accordingly.
• Used Essbase calc script tuning and debugging as well as enhancements.
• Designed and created various filters according to user requirement in EIS.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass manner.
• Partitioned some existing cubes to increase the performance of cubes.
• Involved in migration of Security and reports from 7.1.6 to System 9.3.0
• Developed transparent partitioning to optimize the calc time on the cube.
• Developed ASO cubes and converted BSO applications to ASO applications to increase performance and speed.
• Developed SQL and PL/SQL scripts to extract and transform data into the data warehouse system and manage DM activities
• Created Dashboard layout to identify trends and organize critical data. Graphically, users may see the high level processes and then drill down into low level data. Designed dashboard layout for populate report specific data points.
• Regularly monitored performance and carried out optimization and fine-tuning tasks, provided troubleshooting services and assistance to end-users in resolving errors

Environment: Oracle/Hyperion System 9.3.1., EAS 9.3.1, Excel Spreadsheet Add-In, Hyperion Planning 9.x, EIS 9.x, Web Analysis, Workspace, Shared Services, Windows NT Essbase, VB/VBA, Informatica, SQLSERVER.

Confidential- Blue Bell, PA

Hyperion Essbase Developer

Roles & Responsibilities:

• Coordinated with business analysts / clients to understand and develop an optimized Essbase cube.
• Gathered requirements and developed a project plan.
• Prepared an optimized data source.
• Developed aggregate storage cubes (ASO) using Essbase 7.1.
• Developed a transparent partition with ASO / BSO cubes to leverage advantages of both technologies.
• Developed rule files for loading data and for dimension build.
• Implemented robust data-access security and user management.
• Automating of cube refresh through MaxL and UNIX Scripts.
• Optimized data loads and calculation scripts and maintained existing Essbase cubes.
• Optimized the applications to reduce runtime.
• Retrieved reports using Excel Add-in and generated batch reports using Hyperion reports.
• Maintained the OLAP application and took regular backups.
• Provided technical guidance and support to end-users by developing appropriate documentation.

Environment: Hyperion Essbase 7.1.5, Hyperion Reports 7.0, Hyperion SQR, Hyperion Planning, PL/SQL, SQL Server, Excel Add-in, Windows NT 4.0, Oracle 8i

Confidential - Marysville, OH

Hyperion Developer/Designer

Roles & Responsibilities:

• Gathered business requirements, defined, designed, developed, tested and deployed the Hyperion applications.
• Built outline and security using Hyperion planning.
• Developed web forms using Hyperion planning web client for the users to input forecast, budget, actual, accounting changes and other variance explanations data.
• GL data is loaded into cube from Data Mart using data load rule.
• Worked on financial reports using Hyperion reports tool.
• Developed numerous financial reports like contribution margin, cost of sales, total structural cost detailed and summary, operating profit, budget, business plan and variance reports by pulling the GL data from the cube using Hyperion reports.
• Developed business rules and attached to the input forms to calculate data on save option.
• Designed and developed load rules using the Prep Editor.
• Hands on experience in backup and recovery for database.
• Designed and developed corporate financial charts (Look and Feel) and other ad-hoc management financial reports using the Hyperion Analyzer.

Environment: Hyperion Essbase V6.2/6.5.1, Hyperion Reporting V/1.7/2.0/2.1, Oracle, Hyperion Analyzer, Windows NT, Hyperion Planning 4.0, HAL, Unix, Web logic server, Excel Add-in

Confidential

Jr. Essbase Developer

Responsibilities:

• Installation of Essbase family products in both Windows 2000/NT and UNIX (Sun-Solaris) environments
• Responsible for producing the functional design documents and specification for the Essbase modules
• Maintenance of two pre-existing Essbase cubes
• Involved in script writing for dynamic dimension builds and data loads
• Worked on performance tuning of data loads and calculation times
• Design and development of calculation scripts
• ESSCMD is extensively used to run these calc scripts
• Developed the Load Rules to automatically validate the data and feed into Essbase new structure
• Developed report scripts to populate data, which was fed into the other cube
• Created batch files to run calc scripts, data load and data calculations
• Extensively worked with Hyperion Reports and Hyperion Analyzer

Environment: Hyperion Essbase 6.1/6.0, ESSCMD, Hyperion Analyzer, Excel Add-In, Oracle, Windows NT/2000, Hyperion Reports, Sun-Solaris UNIX

Confidential

Jr. SQL Developer (Intern)

• Involved in entire project life cycle including database design, development, testing, optimizing, deploying on development and production servers
• Actively involved in Normalization of database
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures, Clusters, Triggers and maintaining referential integrity
• Involved in performance tuning of TSQL queries and Stored Procedures
• Wrote T-SQL statements for retrieval of data
• Involved in writing SQL batch scripts.
• Created joins and sub-queries for complex queries involving multiple tables
• Used DDL and DML for writing triggers, stored procedures, and data manipulation
• Performed daily database backup & restoration and monitored the performance of Database Server
• Optimized query performance by creating indexes.
• Trouble shooting problems by using SQL server profiler
• Pro actively identified the problems before user complaints

Environment: MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler