PROFESSIONAL SUMMARY:

• Around 10 years of experience in design, analysis, development and implementation of various applications in client/server environment by using various versions of Hyperion Essbase, Hyperion planning, Essbase Integration Services, Hyperion Workspace, Hyperion Shared Services and generating numerous ad hoc reports by using Essbase Excel Add - in / Smart View and financial statements using by Financial Reporting.
• Accounting and financial statement knowledge, created Reports for Profit &Loss and Balance Sheet statements and Variance Reporting that are used for GAAP analysis.
• Extensive experience in developing and designing of Essbase Cubes, load Rules, ESSCMD, MAXL, Calculation scripts, Security and Provisioning in Hyperion Shared Services, Hyperion Planning ( Data Forms, Security, Metadata maintenance and Business/calc Rules), Web Analysis, Essbase Excel Add-In, Financial reporting and Hyperion Interactive Reporting Studio (Complex Reports, Reporting Studio, Joins and Data Modeling).
• Extensive experience on the installation, configuration, server settings, backups, client and server installations of Hyperion products such as Hyperion system 11.x, 9.x, 7.x, Hyperion Analytics Services, HFM, Hyperion Planning, Analytic Services Client and Essbase Administrative Service (EAS) Console.
• Extensive experience in creating data models forInteractive Reportingand generate numerous complex queries and reports using drill paths and scheduled interactive reports job on demand.
• Experience in automation using batch scripts and shell scripts, optimization of report queries in Microsoft Excel,
• Developed Essbase applications and related procedures that reduced the user effort in analyzing data, which helped clients, reduce work effort and prevent manual error.
• Created Financial Reports using Hyperion Financial Reporting Studio and Smart-view according to the Client requirements.
• Involved in Hyperion Applications Development and Production Support.
• Involved in creating functional and technical specification, Unit Testing, SIT (System
• Integrating Testing), UAT (User Acceptance Test) and other documents.
• Performed Development to Production environment migration.
• Created schedules, batches and books using Enterprise Performance Management System (EPM).
• Experience in developing Hyperion Planning application for budgeting requirements.
• Worked with business analysts for requirements gathering creation of design documentation.
• Performed infrastructure maintenance, fine-tuning, and Issue Analysis of the Hyperion, app/web server and other related applications for the high availability of the Hyperion environment.
• Designed and developed Essbase applications with excellent balance of retrieval and calculation performance.
• Development experience in Business rules /Calc scripts in Hyperion Planning/Essbase.

TECHNICAL SKILLS:

Enterprise Performance Management (EPM): Hyperion Essbase 11.1.2.2/7. x/6.x, Hyperion Planning 11.1.2.1/9. 3.1/4.0 , Hyperion Shared Services 11.1.2.1/9. 3.1 Hyperion Excel Add-in 11.1.2.2/7. x/6.x, Hyperion Smart view 11.1.2.1, Hyperion Planning 11.x/4.0, Hyperion Reports 11.x/7.x/6.x, Hyperion Financial Management 11.1.2.1/9. x, FDM 9.3.1, Web analysis 11.x and Data Relationship Management 11.x

Operating System: Windows, LINUX and UNIX

Languages: VB, SQL and C

DBMS / OLAP: Oracle 9i/10g/11g, SQL Server 2005 and 2008, Hyperion Essbase 6.x, 7.x, 9.x, 11.x

Special Software: Causal Analysis Tool, Mercury Quality Center, Compuware QA Load and Control M

Project Management Tools: HP Application Life Cycle Management, Clarity, Microsoft Project Planner, Microsoft Office 2007, IPMS, IQMS

PROFESSIONAL WORK EXPERIENCE:

Confidential, Santa Clara, CA

Hyperion Consultant

Responsibilities:

• Installed & configured Oracle EPM (Hyperion) Suite of products Essbase, Reporting& Analysis, on windows and Linux environment.
• Designed and Implemented Essbase cubes for various applications as per business requirements
• Created rule files for data loading in to the cubes and for Dimension building.
• Written Essbase formulas, calculation scripts as per the requirements and created substitution variables for the ease of maintenance of application
• Developed MaxL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes and maintenance for daily backup.
• Trouble shooting the errors which we face in Essbase and Reporting.
• Experience in maintenance activities like verifying the new dimensional members which are coming in actual data load daily and monthly, restoration procedure, security maintenance
• Configured Microsoft Active Directory (MSAD) to the Hyperion Shared services
• Maintained the Essbase objects like, outlines, Calc scripts, MAXL scripts, report scripts, substitution variables, location aliases, business rules, run time prompts, global variables, and security filters.
• Works closely with Business to understand the strategic and financial objectives as per need.
• Assisted in design and development tasks within the context of an ongoing application development.
• Created Essbase outline formulas and calculation scripts using advanced calculation scripts for allocations, two pass calculations and data exports.
• Prepared user documentation for hands on training for different groups within the organization.
• Debugged and optimized data loading by appropriate column ordering within rule files.
• Extensively involved in performing DBA activities like Configuration settings, database tuning, and taking regular Essbase cube backups.
• Extensively worked in Build dimensions by loading metadata into planning applications by using outline load utility.
• Created Web forms to provide ability for users to easily input budget and forecast information using the planning Web Forms.
• Developed numerous calculation scripts and member formulas
• Extensively worked in developing Business Rules to meet functional requirements.
• Developed and modified financial reports using Hyperion Financial Reporting Studio (HFR).
• Collaborated with team lead(s) from various areas within IT and the business to review and recommend technical alternatives and timelines.
• Troubleshoot and provide root cause analysis, run maintenance utilities, create automation scripts, maintain responsibility for creating and updating systemdocumentation, and participate in on-call support and testing.
• Hierarchies maintained in DRM versions and exported to Text files and Databases for downstream applications.
• Also responsible for support, troubleshooting and resolving issues post Implementation.
• Experience and handled in backup and recovery support tasks.
• Helping users in client installations of Smart view and Financial Reporting Client and its associated problems
• Trained End users logging in, running reports and using Smart View.
• Created and republished the Open catalog extension (oce) files.
• Created ODBCs, DAS and OCEs to establish a connection between the Hyperion Interactive Reporting (Brio) and the relational databases.
• Developed administrative Hyperion Dashboards using Hyperion Explorer.
• Scheduled the various reports (Jobs) on Hyperion Foundation and send the output to FTP and Email.

Technical Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2Oracle Hyperion Shared Services, Hyperion Reporting 11.1.2.2, Smart view 11.1.2.2, Hyperion DRM 11.1.2.2, Hyperion Interactive Reporting Studio, Oracle 10g, HP UNIX, Windows Server 2003/2008 and HP ALM.

Confidential, Minneapolis, MN

Hyperion Consultant

Responsibilities:

• Installed, built, configured, and tested various Hyperion 11.1.2.1 components in complex distributed environment including Hyperion Foundation Services, Reporting and Analysis, Hyperion Planning, Essbase, smart view and Financial Reporting
• Served as a technical lead to application support group to include setting standard operating procedures, providing direction, assigning tasks/projects, planning/scheduling work, monitoring progress, and related activities. experienced in collaborate with business unit senior management to identify, analyze, and develop business requirements for operations; define IT specifications for support of business requirements; collaborate with project management teams to define, develop, and deliver IT applications to support business operations.
• Plan, analyze, develop, test, implement, and maintain complex application systems.
• Experienced in monitor application operations; apply proactive/predictive analysis to minimize system risks; resolve operational problems to maximize system availability.
• Serve in project lead/support role on complex application integration projects; collaborate with technical staff, business unit senior management, and project managers to develop, implement, and support integration projects.
• Provided application administration for departmental applications; provide technical support to users; provide technical guidance to business unit senior management; collaborate with departmental application support staff to develop and implement standard operating procedures, change management procedures, disaster recovery, and related activities.
• Supported the Oracle (Hyperion) Enterprise Performance Management infrastructure in a multi-application IT environment.
• Tested support for each of the products, including performance testing, integration testing between interfacing systems, and performance tuning
• Support process of identifying, diagnosing and solving existing process and system issues
• Created and maintained consistent and thorough documentation of all processes and procedures for supported applications
• Maintained applications change/update and software upgrades, software monitor capacity and usage of application and server
• Gathering business requirements for enhancements and create design for new reports/web forms.
• Migrated and took backups of different Hyperion applications across Development, Test and Production environments.
• Maintained the security of users and groups for various Hyperion components using the native Open LDAP and User directories in User Management Console.
• Involved in Creating Data Forms and Folders and Customizing Data Forms.
• Supporting Month End, Quarter End and Year End changes for the actual/budget scenarios.
• Monitoring overall server and load balancing.
• Failover process in case of disaster.
• Used Web Analysis, Financial Reporting and Interactive reporting to prepare quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Developed and Published Daily and weekly reports using Interactive Reporting to the Senior IT Managers.

Technical Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2,1 Hyperion Excel add-in 11.1.2.1, Hyperion Smart View 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion Interactive Reporting, Linux, Unix, Windows XP, MS Sql server 2008, Control M, Citrix and Microsoft Office 2007.

Confidential, Hoffman Estates, IL

Hyperion Developer

Responsibilities:

• Interacted with several users from different departments to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Designed an outline consisting of both user defined and default dimensions, consisting of thousands of members per dimension.
• Loaded the metadata and business rules using Outline Load Utility
• Developed Data forms, Menus, Task Lists, and User Variables based on the functional and technical Requirements requested by the business.
• Developed Calculation Scripts for the communication and integration between the Sales Forecasting and Financial Forecasting application. Used Data export functions to extract data from Financial Forecasting cube and feed (import) the data into the Sales Forecasting application.
• Designed Rules Files by carefully mapping the dimensions from flat files to the dimensions in outline
• Worked with multiple Currencies and changing the currencies of a data cell in the data forms.
• Implemented Member formulas, UDA’s, attributes and MDX formulas for calculations.
• Designed and created a security plan to manage security at the user and group layer, the global access layer and the server level using Shared Services.
• Created security filters and assigned them to users depending on responsibilities and tasks and limiting their access to only particular applications as per the guidelines of their department.
• Used Life Cycle Management Utility for migration purposes from one environment to other.
• Involved in performance tuning to minimize data load and calculation time by optimizing Essbase caches, restructuring, data loads, calculations and reports
• Generated reports such as P&L, Revenue and Expenses using Financial Reporting Studio.
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup

Technical Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion Reports 9.3.1, Hyperion Shared Services 9.3.1, Smart View 9.3.1, UNIX, Windows 2008 Server and Excel add-in

Confidential, Redwood City, CA

Global Planning System Administrator

Responsibilities:

• Developed documentation and training strategy for end-users.
• Serving as a liaison with IT supporting the Hyperion users and troubleshooting issues.
• Assisting with all application upgrades and testing in across environments.
• Work with users to identify inefficiencies in processes and propose solutions, where possible.
• Maintain system compliance from a Sarbanes-Oxley perspective.
• Control system security and users access rights using Shared Services and Active Directory.
• Liaise with several departments in an Organization
• Experienced in maintaining security of the system via shared services that included creation and modification of users, groups and provisioning them.
• Experienced in maintain the security with the planning application i.e. security of objects including web forms, task lists and business rules and security filters (dimension security)
• Performed admin related tasks including data loads, metadata loads, taking data backups and setting up batch processes
• Experienced in identifying and implementing the process for year rollover and supported the budget preparation for the New Year.
• Experienced in identifying and troubleshooting Hyperion planning technical issues and providing resolution for the same
• Involved in two full budget cycles, worked on all the phases from gathering requirements, translating them into design, application development to deployment.
• Created planning application using Hyperion Planning. Designed data forms and task lists. Developed business rules using Calc Manager.
• Created partitions for data transfer between ASO and BSO cubes. Automated the data Transfer using MaxL scripts.
• Created planning application using Hyperion Planning.
• Maintained security for Planning, Business Rules and Essbase
• Performed data validation for the business rules and maintained Web Forms
• Provided Essbase administration and optimization training to resident technical resources
• Developed financial reports such as balance sheet, income statements using Hyperion Financial Reporting. This led to improved frequency and timeliness of reporting.
• Handled administrative tasks of data and artifacts migration using LCM utility.
• Implemented security requirements using Shared Services.
• Maintained outline, Essbase calc scripts, member formulae, rules files, Essbase cube (OLAP) using Essbase Administrative Services.
• Optimized BSO cube by using measures like defragmentation, cache settings and ASO cube by using compression, data load buffers etc.
• Created technical documentation and training material for the applications, processes.
• Proactively communicated with the budget department for gathering requirements and User acceptance.
• Metadata - Added Accounts, Entities, and Custom Dimensions to Hierarchies.
• Created multiple Hierarchical Rollups for both Entities and Accounts including IFRS Account Hierarchies.
• Created and modified Grids, Journals and Journal Templates
• Maintained process management
• Added patches to system 9.3.1
• Run consolidations
• Created and Modified Reports in System 9.3.1 HFM.
• Research fallouts
• Run Access Queries
• Modify Rules in Rules Editor
• Created Smart View files
• Maintained User security in Shared Services
• Copy FDM Applications thru Work Bench
• Re-pointed FDM Applications
• Load files thru FDM Work Bench
• Create modify FDM locations
• Load data thru FDM
• Create FDM Locations
• Researched validation errors
• Trained End users logging in, running reports and using Smart View.
• Designed and Created Drill Down, Pivot, Chart and Tabular reports and Generated Pre-Defined drill paths.
• Customized data by adding calculations, summaries and functions.
• Created dynamic EIS pages and load data from the result set.
• Generated Switch, Pie, Bar, Nested Charts, Line Displays.
• Using Java Script the EIS pages are Processed to get dynamically data from the result and loaded into the Respective Objects
• Using Java Script the Limit values are passed dynamically to the Query and Tables
• Created users and user groups in Foundation and assigned various types of Permissions to User Groups to access the reports.
• Extensive SQL changes were required because of the decision not to use computed items. The data resides in a data warehouse in an Oracle database. Created and/or modified report mock-ups in Visio, author functional specifications in Word, created online report documentation in specified format in Excel, document report input parameters (Brio Limits) in specified format for data warehouse automated load into GUI.

Technical Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, HFM 9.3.1, FDM 9.3.1, Smart View 9.3.1, Hyperion Reports 9.3.1, Hyperion Shared Services 9.3.1, Brio, Clarity, CA tool, UNIX, Windows 2008 Servers and Excel Spreadsheet add-in.

Confidential, Milpitas, CA

Planning and Reporting, Hyperion Administrator

Responsibilities:

• Provide On-Call support
• Preformed troubleshooting, diagnoses, and solve all Essbase and Planning related issues.
• Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations.
• Debugged and optimized data loading by appropriate column ordering within rule files.
• Extensively involved in performing DBA activities like performance tuning the Calculation scripts, database tuning, and taking regular Essbase cube backups.
• Assisted end-users through direct communication and documentation.
• Performed admin related tasks including data loads, metadata loads, taking data backups and setting up batch processes
• Experienced in identifying and implementing the process for year rollover and supported the budget preparation for the New Year.
• Experienced in identifying and troubleshooting Hyperion planning technical issues and providing resolution for the same
• Involved in two full budget cycles, worked on all the phases from gathering requirements, translating them into design, application development to deployment.
• Created planning application using Hyperion Planning.
• Maintained security for Planning, Business Rules and Essbase
• Performed data validation for the business rules and maintained Web Forms
• Provided Essbase administration and optimization training to resident technical resources

Technical Environment: Hyperion Essbase 7.1.2, Hyperion Planning 4.0, Excel add-in, Hyperion Reports 7, Unix, Control M and Oracle 9g

Confidential, Columbus, OH

Hyperion Developer

Responsibilities:

• Extracted the business requirements from the end users keeping in mind their need for the application and prepared business requirement document as per the requirements.
• Involved in backing up the Essbase application on daily basis and restored the Essbase application whenever required.
• Created ASO and BSO applications using EAS Console.
• Build dimensions using rule files through EAS and MAXL.
• Developed Load rules for Dimension build and Rules File for loading the data from Oracle GL into Hyperion Cube.
• Developed Calc Scripts for aggregating the data based on the business requirements.
• Involved in optimization and tuning of the Essbase application to bring down the calc time.
• Automated the monthly loading process using Maxl, Shell Scripts.
• Developed reports required for the business needs using Hyperion Reports and Hyperion Analyzer (ad-hoc).
• Load data using rule files through EAS and MAXL.
• Designed security system like creating users, groups and Filters assigning them to groups and users through EAS and MAXL.
• Worked on Transparent partition and replicated partitions through EAS and MAXL.
• Created planning application using Hyperion Planning.
• Maintained security for Planning, Business Rules and Essbase
• Performed data validation for the business rules and maintained Web Forms
• Provided Essbase administration and optimization training to resident technical resources
• Verifying and validating data through Excel spread sheet add-in.

Technical Environment: Hyperion Essbase 7.1.2, Hyperion Planning 4.0, Excel add-in, Hyperion Reports 7, Unix, WIN XP, VB 6.0 and Oracle 9g