SUMMARY

• About 8 years of experience in development, analysis, implementation, Administration in a client - server environment using different Hyperion Products like Hyperion ESSBASE, Planning, ESSCMD, MAXL, MDX, ESSBASE Excel Add-In, Hyperion Smart View Add-In, Hyperion Reports,Financial Data Quality Management, Hyperion Analyzer, Financial Reporting Studio, HAL in Windows server 2000/2003/2008 and UNIX Environment.
• Played different roles like Essbase developer, Planning Developer, Reports Developer, FDM Developer, and Administrator
• Thorough Knowledge of entire life cycle of Data Warehouse Design, development and implementation.
• Involved in upgrading several Hyperion Systems from one version to another by applying patches or by new installations. Involved in Migrating applications between different environments using LCM utility (Life Cycle Management).
• Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups, Scheduling daily batch processes using CONTROL-M workload automation software, migrating fact data between different Hyperion applications.
• Expertise in Star Schema Modeling in Essbase Integration Services (EIS), E-R modeling for RDBMS Data Sources, and various tools for automation of OLAP.
• Worked with third party consultants on upgrade from Hyperion 11.1.1.4 to 11.1.2.1
• Developed ESSBASE cubes using Block/Aggregate storage technologies (BSO/ASO).
• Proficient in dynamically building Dimensions, Attributes using rule files and loading Fact data in an ESSBASE Applications by means of several build methods such as generation, level and parent-child references.
• Performed regular Database backups, Dense/Sparse settings, Partitioning (using Transparent, Replication and Linked Techniques) and ESSCMD scripts, MAXL scripts, MDX scripts.
• Good Experience in application creation using both Hyperion EPMA and Classic Administration
• Involved in Data imports to Hyperion Planning using Hyperion Financial Data Quality Management
• Developed Mapping files and check reports to validate the data loads in Hyperion FDQM.
• Developed scripts in Hyperion FDQM to automate the process using VB Scripting.
• Hands on Experience in calculation scripts(creation, Manipulation and maintenance)
• Experience in Hyperion System 9 & 11 modules (Planning, Workforce Planning, Interactive Reporting, Financial Reports, and Dashboards)
• Good Experience in application creation using both EPMA and Classic Administration.
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Widespread experience in Hyperion Planning Forms, Security, Metadata Maintenance, Business Rules and ESSBASE Excel Add-In.
• Created Several Customized Financial reports using different reporting tools like Financial Reporting studio, Web-Analysis, and Interactive Reporting Studio according to Client Requirements.
• Good understanding of data warehousing architecture in terms of Logical model, Physical model, RDBMS, ETL, Reports.
• Involved in Several Meetings with both SAP, PeopleSoft team regarding Data Mapping.
• Proficient in writing Stored Procedures and Triggers using SQL and PL/SQL on Oracle, SQL Server, DB2 databases.
• Experience in Object-oriented programming using JAVA, C++.

TECHNICAL SKILLS

OLAP Expansion Tools: Hyperion Essbase 9.3.1/11.1.1.3/11.1.2.1/11.1.2.3 Hyperion Planning 9.3.1/11.1.1.3/11.1.2.1/11.1.2.3 Hyperion Shared Services 9.3.1/11.1.1.3/11.1.2.1/11.1.2.3 E IS 7.X/6.X (Essbase Integration Services)Hyperion System 9,11 Smart View Essbase Excel Add In,ESSCMD, MAXL, MDX, HAL 7.3/7.1, ODI, Hyperion Performance Suite

Databases: Oracle 9i/10g/11g My SQL Microsoft SQL Server IBM DB2 SQL Server 2000 MS Access

Reporting Tools: Financial Reporting Studio 9.3, 11.1.1.3,11.1.2.1,11.1.2.3 Hyperion Reports Interactive Reporting 9.3 Hyperion Intelligence Hyperion System 11 Smart ViewHyperion Spreadsheet Add in Hyperion Analyzer Web Analysis 11.1.1.3

Web & Application Servers: Apache Tomcat Web logic 8.1.2 Web sphere 6.0,6.1

Languages: C++ JAVA PL/SQLHTMLSQL

Operating Systems: MVS Unix Windows 2000/XP/NT

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Hyperion Consultant

Responsibilities:

• Designed BSO application for the purpose of Gross Margin and Commissions planning and a separate ASO application for regulatory reporting, variance analysis and archiving process. These applications supports annual budget.
• Designed dimension and outline using Outline Load Utility and Oracle Data Integrator.
• Configured master and work repositories, defined the physical & logical architectures and contexts in ODI.
• Designed metadata and data automations through ODI and scheduling scenarios
• Established a workflow process to keep track of the plan, review the plan, and change the ownership and status of the planning unit.
• Designed Data forms/Web forms, Menus and Smartlists to allow users to key in the data for the drivers that business requires, Also attached business rules with these data forms to calculate several accounts
• Automated Task Lists to guide the planning users through a several sets of webforms, calculations, business rules, etc. required to complete the plan cycle.
• Designed a Replicated partition to transfer a portion of data from one cube to another, which significantly increase the performance for the excel-retrievals.
• Assisted users in using Hyperion Smartview and Excel-Addin to perform the drill-downs and ad-hoc reporting.
• Implementedvarious types of calculations such asDynamic & Two-Pass,Member formulas, UDA’s, attributes and XREF functions for calculations.
• Designed Rules Files for the purpose of loading data from flat files to the dimensions in outline using several build/load methods such as generation, level and parent-child references.
• Created MaxL and batch scripts to automate process of updating cubes on a daily basis.
• Performed regular Backups of the cube and archiving it.
• Performed daily and monthly refresh processes, which involve opening and closing of the monthly forecast, loading actuals, updating variables, archiving, data validation etc.
• Created Dataexport calcs and Report Scripts for the purpose of exporting specific set of data from the cubes.
• Created customized Financial Reports using Hyperion Financial Reporting Studio according to the finance users’ requirements.These reports included Budget vs. Actual, Budget vs Forecast and Forecast vs. Actual reporting capabilities. Also, automated the entire process of pushing reports by sending them automatically on a particular business day.
• Supported existing P&L application (consisting of Balance Sheet, Consolidated and Workforce databases) to plan several employee related expenses like salaries, bonuses, vacation days, vacant and filled positions, report Net income, Net Sales, Profit and Loss, etc.
• Resolved tickets that are opened by the end-users to support the Hyperion products.
• Performed migration tasks from one environment to another using LCM (Lifecycle Management) utility and Relational backup and restore.
• Creating documentation for functional requirements of the project which included entire end-to-end development, testing and go-live.

Environment: Oracle EPM 11.1.2.2, ODI 11.x, Hyperion Essbase, Hyperion Planning, Financial reporting studio, Hyperion smart view, Essbase excel add in, Oracle 11g, PL/SQL, TOAD, Windows

Confidential, Santa Clara, CA

Hyperion Consultant

Responsibilities:

• Involved in gathering business and functional requirements from detailed business meetings and converted them into design specification documents.
• Worked with financial users to understand the functionality and to identify the outline structure to build a cube.
• Designed, developed, tested and deployed Hyperion planning applications in Hyperion Workspace.
• Used EPMA environment to create planning cubes with dimension library, application library.
• Created Web Forms/Data Forms in Hyperion Planning for users to input forecast, budget, actual, accounting changes and other data.
• Developed Task Lists, Work Flows, Menus and Business Rules with an option for Run-time Prompts.
• Build several Smart view templates based on requirement from financial users
• Involved in requirement gathering and created weekly, monthly and quarterly reports using Financial Reporting Studio from Planning application.
• Build reports using Financial Reporting Studio for different end-users, including Financial Users, Sales Managers, Actuarial, and Cost-Center Administrators
• Applied Security to Essbase and Planning Applications by creating users, user groups and filters to control the access of data to specific members.
• Involved in creating application profiles and metadata from HFM applications. Scrutinized metadata and corrected the errors before extracting into HFM applications.
• Extensively involved in designing and modifying the outlines for BSO cubes in Essbase.
• Developed and maintained Rule Files, Calc Scripts, MaxL Scripts and Reports
• Optimized the performance data loads and calculations of Essbase cubes.
• Automated the process of Essbase cube building through MaxL/Shell scripts and automate scheduler.
• Provided Database optimization with Dimension Building and data Loading.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting using Financial Reporting studio.
• Performed Knowledge Transfer (KT) to the financial users regarding how to use data forms for the budgeting and Workflow process.
• Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO).
• Maintained security by creating, managing, and assigning provisions to the users and Groups in the shared services.
• Maintained Dimension Level Security by creating filters based on End-user position levels.

Environment: Hyperion System 11.1.2.1, Oracle Hyperion System 11, Hyperion Administrative Services, Hyperion Web Analysis, Hyperion Planning 11.1.2.1, Financial Reporting Studio 11.1.2.1, Oracle 10g, Hyperion Smart View 11.1.2.1, Hyperion Workspace, Financial Reporting, UNIX.

Confidential, Webster, MA

Senior Hyperion Consultant

Responsibilities:

• As a Hyperion Administrator involved in Installation and Configuration of Hyperion products such as Planning, Essbase and reporting tools.
• Fully involved in upgrade and client installations of Hyperion System 11.1.1.3 from 9.3.3 throughout the organization.
• Developed Essbase Outlines, Member Formulas and Data Load Rules for the Planning Application
• Developed and maintained Rule Files, Calc Scripts, MaxL Scripts and Reports.
• Used MAXL in an interactive and Batch Mode to load data files and automate Essbase Operations
• Involved in Performance tuning to minimize data load and calculation time using the dense/sparse settings and developed the required alternate rollups for reports
• Created security filters and assigned them to users depending on responsibilities and tasks
• Created a new planning application which will overtake the present budget application.
• Worked with financial users to understand the functionality and to identify the outline structure to build a cube.
• Loaded monthly actuals and forecast data into FinPlan application and loaded FTE’S, and pay grades into Workforce application.
• Built reports using Financial Reporting Studio for different end-users, including Financial Users, Sales Managers, Actuarial, and Cost-Center Administrators.
• Created different data forms like input forms, what-if forms, and composite forms required for budgeting and forecasting.
• Implemented Workflow Process for Budget and Forecast approvals throughout company.
• Wrote Calculation scripts or Business rules in EAS (Essbase Administration Console) to perform Cost Allocation based on different drivers.
• Performed Knowledge Transfer (KT) to the financial users regarding how to use data forms for the budgeting and Workflow process.
• Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO).
• Created various partitions in Essbase (BSO/ASO) cubes.
• Maintained security by creating, managing, and assigning provisions to the users and Groups in the shared services.
• Maintained Dimension Level Security by creating filters based on End-user position levels.
• Wrote several MAXL Scripts to perform automation of load data, export data, and execute calculations as necessary.
• Helped IT team with database backups, migrate applications from test to production server Using LCM Utility and synchronize both environments.
• Implemented Drill through Functionality Using Web Analysis reporting tool.
• Redesign workforce planning applications according to CIP functionality.
• Worked on the 3-Year Projection Model.
• Participated in meetings with financial users and IT Department if any issues arise regarding Hyperion.

Environment: Hyperion System 9.3.3, Oracle Hyperion System 11, Hyperion Administrative Services, Hyperion Web Analysis, Hyperion Planning 11.1.1.3, Financial Reporting Studio 11.1.1.3, Oracle 10g, Hyperion Smart View 11.1.1.3, Hyperion Workspace, Web Analysis 9.3.3, Financial Reporting, UNIX.

Confidential, CA

Hyperion Administrator

Responsibilities:

• Highly Involved in Administrative Tasks like troubleshooting, Batch Processing, Automation (MAXL) and Security.
• Installation and Configuration of Hyperion System 9 BI+ (EAS, Essbase Server, Hyperion Planning, Hyperion Shared Services, Workspace, Hyperion Finance Reporting Studio)
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Writing MAXL scripts to automate the calculation scripts.
• Performance optimization by tuning the caches.
• Worked on Essbase ASO, BSO cubes. Created linked partitions using ASO cubes.
• Created complex transparent partitions for the ASO cubes as target for BSO source cubes to enhance reporting.
• Develop calculation scripts and member formulas using XREF.
• Ability to do budgeting and forecasting at the country, entity, business unit, multiple currency and department level with the ability to generate reports at these levels.
• Ability for users to easily input budget and forecast information using the planning Web Forms.
• Ability to create and manage flexible workflows as it pertains to the budgeting and planning process
• To automate “REFRESH” from planning application to ESSBASE application using the appscheduler.
• Involved in assigning security for Hyperion Planning application using Hyperion Shared Services.
• Strong understanding of the Hyperion System 9 relational repositories which support front end applications.
• Develop Reports to enable the users to analyze the data at a level of detail incorporated into the Hyperion planning application using Financial Reports and Web Analysis.
• Migration of the Planning Application from Development to Production.
• Migration of Financial Reports and Web Analysis Reports from Production to Development.
• Develop Business Rules to copy data from one version to another using Run-time prompts.
• Automatic consolidation of data is done using Business Rules.
• Writing MaxL scripts to automate data load into ESSBASE database using Rules files.
• Involved in loading metadata into planning by using Oracle Data Integrator (ODI).
• Involved in upgrading Hyperion System 9.3.1 to 9.3.3 (Applying patch to 9.3.1 in different environments)
• ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL API, Backup, Outline, Load rules).
• Providing support to the Hyperion user community.

Environment: Hyperion System 9 BI+, Hyperion Analytic Administrative Services, Hyperion Web Analysis, Hyperion Planning 9.3.x,Oracle Data Integrator(ODI), Financial Reporting Studio 9.3.x, Oracle 10g, ESSBASE Excel Add-in, Financial Reporting, Windows 2000.

Confidential, St.Louis, MO

Hyperion Developer

Responsibilities:

• Involved in developing design specifications of ESSBASE cube with Customers.
• Developed Aggregate Storage Cubes (A.S.O) cubes using ESSBASE.
• Extensively involved in designing and modifying the outlines for ESSBASE Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to ESSBASE cube.
• Full life-cycle development of Hyperion Essbase (Using ASO and BSO technologies and complex partitions) applications.
• Created both Block storage applications(BSO) and Aggregate storage applications(ASO).
• Developed OLAP Models and Meta outlines using ESSBASE Integration Services from star schema in relational databases like Oracle 10g.
• Involved in installation of Hyperion Planning on Windows environment.
• Create Data Source Configuration through Hyperion Configuration Utility 9.3 in Hyperion System 9 Foundation. Created and registered Planning applications in Hyperion System 9 Workspace.
• Designed and developed several ad-hoc and financial reports using Hyperion Analyzer and Hyperion Interactive Reports.
• Created Complex and Dashboard Reports using Interactive Reporting.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Worked extensively on Budget process and Budget Administrative tasks
• Involved in Structure changes and creating Alternate Roll up’s in Web Forms
• Developed Calc scripts to consolidate and to calculate values like Hourly Wages, Depreciation, Benefits and Revenue.
• Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Used ESSBASE Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Presented detailed analytical reports to higher administrative people using Hyperion Planning induced collaborative decision making.
• Optimized the applications to bring down the runtime and database size considerably.
• Error Handling, Trouble shooting, Handling restructuring and server problems.
• Involved in production support and maintenance of existing cubes.
• Worked as a team member in Hyperion ESSBASE & Planning Implementation.
• Involved in database and security refreshes in Hyperion Planning.

Environment: Hyperion System 9, Hyperion System 9 BI+, Hyperion ESSBASE 9.3.1, Hyperion Planning 9.3.1, Hyperion Analyzer, Excel Spreadsheet Add-in, Hyperion Application Link, Hyperion Reports, Workspace, Windows 2003 Server, Oracle 10g.