PROFESSIONAL SUMMARY

• Over 7 years of experience in design, analysis, development and implementation of various applications environment using Hyperion Planning, HFM, FDM, DRM, ODI, Hyperion Essbase, Essbase Administration Services, Hyperion EPM, Hyperion Reporting and Analysis 11.1.2.1, Analytic Provider Services, Hyperion Planning, Smart View for Office, ESSCMD, MaxL, Essbase Excel Add-in, on Windows 2000/NT4.0 and Unix environment.
• Extensive experience in designing and developing OLAP cubes from a conceptual level and possesses outstanding skills in Essbase related technologies (system 9.3 and 11).
• 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.
• Hands on experience in maintaining and administering Hyperion Planning HFM, FDM and Essbase applications, including administration of security in Shared Services and Planning, hierarchy maintenance, user support and analysis of system issues and root cause identification.
• Extensively involved in DW restructuring, maintenance, automation, backups, Performance tuning and Optimization of cubes and calc scripts to facilitate effective business decision making.
• Hands on development experience with Hyperion Planning and Essbase, Business Rules, Shared Services, Essbase and Planning Security Administration.
• Extensive knowledge on Hyperion System 9 and Oracle Hyperion EPM 11 Components
• Extensive experience in Calc scripts, MaxL, ESSCMD, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
• Good Experience on migrating applications & reports from 9.3 to 11.
• General functional knowledge or understanding of Budgeting, Forecasting and Financial analysis processes
• Installed Hyperion Applications 9.3.1/11.1.1.1/11.1.1.3/11.1.2.1
• Hyperion Essbase 7.x/9.3.0/9.3.1/11.1.1.3/11.1.2.1
• Hyperion Workspace/EPMA 9.3.1/11.1.1.3/11.1.2.1
• Hyperion Planning 9.3.1/11.1.1.3/11.1.2.1
• Hyperion Shared Services 9.3.1/11.1.1.3/11.1.2.1
• Hyperion Calculation Manager
• Oracle Internet Directory (LDAP)
• Managing / administration: security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
• Good understanding on the architecture of the Oracle Hyperion Products.
• Extensive knowledge on Hyperion Metadata storage information.
• Hands on experience in administering Hyperion reporting and analysis and Essbase
• Installing, Configuring and maintaining Application servers like WebLogic, Tomcat
• Scheduling loading of data, and writing scripts to perform loads and calculations, models and Essbase Block Storage database models.

Technical Skills:

Hyperion System 11/9 BI+ Analytic Administration Services, Hyperion Planning System 11.3.1/9.x/4.0/3.5.1, Hyperion Shared Services11.x/ 9.x, Web Forms, Hyperion Essbase 11.3.1/9.X/7.X/6.X, Essbase Integration Services 7.X/6.X (EIS), Hyperion System 11.x/ 9.x Smart View, Essbase Excel Add In, ESSCMD, MAXL, MDX, Hyperion Reports 7.2/7.0, Hyperion Financial Reporting Studio 9.3, HAL 7.3/7.1, Hyperion Analyzer 7.2/7.0, Hyperion Performance Suite.

Reporting Tools:

Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Hyperion System 9/11 Smart View.

Databases:

ESSBASE11.x/ 9 BI+, Oracle 9i/10g, DB2, SQL Server 2000, MS Access

Web &Application Servers

Apache Tomcat, WebLogic 8.1.2 , Web Sphere 6.1

Languages:

C++, SQL, PL/SQL, Java and HTML

Operation Systems:

Windows 9x/NT 4.0/XP/2000/2003/2008, UNIX (HP/AIX)

PROFESSIONAL EXPERIENCE

Confidential,Warsaw, IN Sep 12 – Till Date
Hyperion Systems Administrator
Confidential,develops, manufactures and markets orthopedic reconstructive, spinal and trauma devices, dental implants, and related orthopedic surgical products. Zimmer has operations in more than 25 countries around the world and sells products in more than 100 countries. The firm is headquartered in Warsaw, Indiana,. Zimmer\'s 2009 sales were approximately $4.095 billion. The company is supported by the efforts of approximately 8,200 employees worldwide, 4,900 of whom reside in the United States and 3,300 of whom are outside the U.S., primarily in Europe and Japan.
Responsibilities:

• Administration and maintenance of Hyperion Planning & HFM, FDM, DRM, ODI and Essbase v. 11.1.2.1
• Maintain metadata in EPMA (including extracting, loading and updating the metadata structure)
• Ensure monthly close process runs smoothly in Hyperion Planning & HFM, FDM, DRM, ODI and Essbase applications
• Coordinate issue resolution with internal and external technical support providers
• Support corporate, field and remote users with Hyperion applications and Smart View
• Build, maintain and run financial reports in Hyperion Financial Reporting Studio
• Load data to HFM as needed during monthly close process
• Work with end users to develop and enhance the application process in a manner that will result in a stable productive environment
• Monitor application performance; identification and communication of resolution of issues
• Participate in the analysis of the efficiency and effectiveness of current departmental processes and procedures and ultimately help to implement identified improvements
• Special projects and process improvements as determined necessary by management
• Loading the actual monthly close files into HFM thru FDM
• Support end users’ needs by providing assistance with report creation/implementation, user training and functionality guidance as needed
• Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
• Creation and Maintain of Planning, Essbase, HFM and FDM application.
• Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS as well as Hyperion Patches.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Monitoring the current Production environment servers for performance and stability
• Ensure Hyperion related processes meet business requirements and deadlines
• Scheduling the ODI jobs using ODI scheduler.
• Developed Scripts for routine administration tasks like backup, purging app/server logs.
• Performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas.
• Responsible for Migrations.
• Applying Hyperion security patches.
• Migration of planning applications from Test to Production.
• Preparation of startup and other maintenance scripts.
• Production migration and support
• Coordinated monthly accounting close process managed administration of the Hyperion system (Essbase, Planning, HFM) infrastructure to ensure a stable, optimized financial planning and reporting environment.
• Managing applications, databases, backups and restore; managing user security in shared services.
• Provide training for system users as needed domestically and internationally
• Creating and maintaining Essbase/Planning applications, Planning data entry forms, reports, security, scripts, calculations, business rules, and batch processes
• Monitor application performance, availability and utilization
• Load required data into Hyperion with appropriate checks and controls
• Create and maintain system documentation and internal controls
• Develop training materials and provide formal/informal training
• Perform Hyperion administration duties related to the operations of Hyperion
• Attend the regular review calls and provide an update to client
• Work with Functional users to understand issues and provide the specifics to the Offshore team
• Provide solutions related to users issues on Hyperion Essbase / Planning, HFM, FDM, DRM & ODI
• Support existing applications and process

Environment: Hyperion Essbase 11.1.2.1 EAS 11.1.2.1 , AOS, BOS, EIS 11.1.2.1, Excel Smart view Add-In, Hyperion WebAnalysis 11.1.2.1, Hyperion Planning 11.1.2.1, Smartview, Hyperion Financial Reporting 11.1.2.1, HFM, FDM, DRM, ODI 11.1.2.1 Windows 2003,AIX/UNIX(5.x,6.x), ESSCMD, MaxL, Microsoft Excel 2000, Microsoft Access, Oracle 10g,Weblogic,Oracle application server, SQL server.

Confidential,Boston, MA May 12 – Jul 12
Sr Hyperion Consultant

Confidential,is a diversified global insurer and the third largest property and casualty insurer in the United States. It employs over 45,000 people in more than 900 locations throughout the world. Liberty Mutual Group had $112.35 billion in consolidated assets, $95.4 billion in consolidated liabilities, $17 billion in policyholders\' equity, and $33.2 billion in annual consolidated revenue. The company offers a wide range of insurance products and services, including personal automobile, homeowners, workers’ compensation, commercial multiple peril, commercial automobile, general liability, global specialty, group disability, fire and surety.
Responsibilities:

• Interact regularly and communicate effectively with users, business owners, upper management, vendors, and outside consultants during project scoping, requirements gathering, solutions design, implementation, project management, UAT, and production support
• Study the Essbase cube design and suggest improvements for reporting purposes.
• Coordinate UAT and fix any bugs/issues reported by the users.
• Create folder security for different user groups in Workspace.
• Working with Hyperion Essbase super users and developers.
• Set up Workspace security and manage folder structure.
• Optimized Data Loads, calc scripts & applications to bring down the runtime considerably.
• Performed tuning by using the Dense/Sparse settings & developed the required alternate rollups for reports.
• Retrieved reports using Excel add-in & generated reports out of batch Financial Reporting.
• Loading Sales, Revenue, and Head Count Data to Essbase cubes and creating current Forecast/Budget members
• Used ESSBASE functions like @IDESCENDANTS and @UDA in creating the Calc Scripts.
• Extensively used MaxL, ESSCMDS to run calculation scripts and report scripts.
• Used various types of Calculations such as Dynamic calc, Two-Pass Calculations, Intelligent calculations for Outline Calculations.
• Performed optimization for various data load rules and calc scripts • Responsible for Migrations.
• Applying Hyperion security patches.
• Migration of planning applications from Test to Production.
• Preparation of startup and other maintenance scripts.
• Production migration and support
• Coordinated monthly accounting close process managed administration of the Hyperion system (Essbase, Planning, HFM) infrastructure to ensure a stable, optimized financial planning and reporting environment.
• Performed database tuning by setting appropriate index, data and calc cache
• Implemented batch jobs and scheduled the batch files for complete automation process for nights and weekends backups /reboots, calculations and backups.
• Involved in the performance tuning and optimization of data load calc scripts.
• Essbase outline changes for optimization.
• Migrated application from DEV to Production using LCM (Life cycle management)
• Developed Batch files using MAXL, PERL and ESSCMD’s and Rules files to upload data from financial system’s database to Essbase cubes.
• Manage Hyperion EPM Product Suite (11.1.1.3) (Hyperion Planning and Hyperion Essbase, Shared Services) and Hyperion BI+ Suite
• Support an integrated metadata environment consisting of both operational and business metadata ensuring the quality and integrity of the data within Hyperion Environment
• Build Hyperion Financial reports for Planning and Batch distribution from Workspace
• Manage User and Group Security utilizing Share services
• Maintain Essbase BSO/ASO Applications Meta Data, Outlines, Calc scripts, report scripts, Substitution Variables and Load rules, Planning Meta Data, Outlines, Task lists, Workflow and Forms
• Identify opportunities to optimize performance of existing systems and data structures
• Coordinate and perform technical and user acceptance testing for upgrades and new system software
• Work with users in defining business requirements for new analytical applications and databases
• Translate business requirements into configuration changes

Environment: Hyperion System 11, Hyperion Planning 11.x, Hyperion Essbase 11.x, EAS 11.x, Hyperion Reports 11.x, Hyperion Workspace, Hyperion Financial Management 11.1.2.1/11.1.2.0, ODI 10.1.3.5, HFM, Smart View, Oracle 10g, Solaris, Windows 2000 Advanced Server, Windows 2003, Veritas Cluster Manager, IBM Websphere, Eclipse, and Apache Tomcat.

Confidential,Burbank, CA
Sr Hyperion Administrator/ Developer Nov 11 – April 12

Confidential,is a leader in professional services, providing award-winning food services, facilities management, and uniform and career apparel to health care institutions, universities and school districts, stadiums and arenas, and businesses around the world. ARAMARK seeks to responsibly address issues that matter to its clients, customers, employees and communities by focusing on employee advocacy, environmental stewardship, health and wellness, and community involvement. Headquartered in Philadelphia, ARAMARK has approximately 255,000 employees serving clients in 22 countries.
Responsibilities:

• Interact regularly and communicate effectively with users, business owners, upper management, vendors, and outside consultants during project scoping, requirements gathering, solutions design, implementation, project management, UAT, and production support
• Gathered business requirements from financial team
• Installed, setup, and configured Hyperion 11.1.2.1 (Foundation, Essbase, Planning, ODI, ERPi, EPMA) in newly built distributed four-servers environments
• Supported Reporting Environment.
• Study the Essbase cube design and suggest improvements for reporting purposes.
• Create books and schedule Batches in workspace.
• Coordinate UAT and fix any bugs/issues reported by the users.
• Create folder security for different user groups in Workspace.
• Working with Hyperion Essbase super users and developers.
• Set up Workspace security and manage folder structure.
• Troubleshoot all reporting issues.
• Created FR to FR drill through in FR reports.
• Loading Sales, Revenue, and Head Count Data to Essbase cubes and creating current Forecast/Budget members
• Perform module specific testing and cross module integration testing on patches, modifications and enhancements.
• Provide operational support to one or more ofKey Performance Ideasclients simultaneously. • Responsible for Migrations.
• Applying Hyperion security patches.
• Migration of planning applications from Test to Production.
• Preparation of startup and other maintenance scripts.
• Production migration and support
• Coordinated monthly accounting close process managed administration of the Hyperion system (Essbase, Planning, HFM) infrastructure to ensure a stable, optimized financial planning and reporting environment.
• Utilize various remote administration technologies to assist various levels of individuals at the customer site, including Budgeting and Planning Managers and Financial Analysts.
• Generate monthly metrics package to client summarizing activity.
• Used various types of Calculations such as Dynamic calc, Two-Pass Calculations, Intelligent calculations for Outline Calculations.
• Performed optimization for various data load rules and calc scripts
• Performed database tuning by setting appropriate index, data and calc cache
• Implemented batch jobs and scheduled the batch files for complete automation process for nights and weekends backups /reboots, calculations and backups.
• Involved in the performance tuning and optimization of data load calc scripts.
• Migrated applications from Hyperion 11.1.2.0 to Hyperion 11.1.2.1
• Essbase outline changes for optimization.
• Migrated application from DEV to Production using LCM (Life cycle management)
• Managed system upgrades and client installations based on users’ requirements.

Environment: Hyperion Essbase 11.1.2.1/11.1.2.0, EAS 11.1.2.1/11.1.2.0 ,AOS,BOS, EIS 11.1.2.1/11.1.2.0, Excel Smart view Add-In, Hyperion WebAnalysis 11.1.2.1/11.1.2.0, Hyperion Financial Management 11.1.2.1/11.1.2.0, Hyperion Planning 11.1.2.1/11.1.2.0,Smartview, Hyperion Financial Reporting 11.1.2.1/11.1.2.0, Windows 2003,AIX/UNIX(5.x,6.x), ESSCMD, MaxL, Microsoft Excel 2000, Microsoft Access, Oracle 10g,Weblogic,Oracle application server, SQL server.

Confidential, Jan 10-Sep 11
Palo Alto, CA
Hyperion Administrator
This is the one of the biggest Hyperion implementations using almost all the Hyperion EPM suite products like Hyperion Planning, Hyperion Essbase, Financial Reports, Web Analysis, ODI, HAL & EIS. These applications were built using latest industry technologies and standards. The actual data from OLTP systems was collected, cleansed, transformed into Data warehouse build using Oracle Apps (GDW). Hyperion Planning applications were developed at BU level for department level planning and one at global level which consists of all the BU data at certain high level. Actual data was fed to these Planning applications from GDW through HAL. Again once Planning or forecasting is complete in BU applications, they push forecast data into GDW at certain high level. This is loaded into Global Planning application for corporation planning and reporting needs.
Roles and Responsibilities

• Closely worked with the functional and the business analyst team during the pre-implementation phase of the applications.
• Developed Planning dimensions and Essbase outline
• Analyzed all the dimensions and members in the Essbase database using Essbase Administration Services
• Developed Planning Web Forms. Upgrading a 9.2.1 installation of Hyperion to Hyperion 11.1.1.3.Installing and Configuring Oracle Hyperion EPM 11.1.1.3 products(Foundation Services, Reporting and Analysis, Essbase, Planning)
• Developed several Business rules for Allocations, eliminations, drivers and other calculations.
• Developed Planning Workflow and task flows.
• Developed Essbase calc scripts and partitions.
• Develop Essbase reporting cube on top of planning cube.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase and Essbase Integration Services.
• Interact with users to understand their reporting needs.
• Gathered business requirements from financial team
• Analyze present reporting environment.
• Supported Reporting Environment.
• Study the Essbase cube design and suggest improvements for reporting purposes.
• Convert Smartview/excel reports into Hyperion financial reports.
• Create B/S, Income statement, TB, Flash and other reports in FR.
• Create books and schedule Batches in workspace.
• Coordinate UAT and fix any bugs/issues reported by the users.
• Create folder security for different user groups in Workspace.
• Working with HFM and Hyperion essbase super users and developers.
• Set up Workspace security and manage folder structure.
• Troubleshoot all reporting issues.
• Creating mock reports for user.
• Created FR to FR drill through in FR reports.
• Loading Sales, Revenue, and Head Count Data to Essbase cubes and creating current Forecast/Budget members
• Building complex HFR and Smartview and also visualize it in MS Wordreports.
• Created and automated aggregation scripts in ESSCMD and MaxL to run at the specific times that the business required.
• Provided 24/7 support for the application during key financial submission periods as requested by the business, thereby keeping the system-downtime to a minimum.
• Closely worked with business users across the globe to troubleshoot and resolve issues as and when they surfaced.
• Supporting various applications on UNIX environment
• Production migration and support
• Developed Financial Reports and Web Analysis Reports as per the requirement of user
• Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
• Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final step before Rolling out of the Application.
• Defined and documented the steps to migrating applications in the Hyperion Planning, Essbase environments in Prod, QA, and Dev.
• Worked with Hyperion Support on a number of issue resolutions.
• Documented all the application and user issues and the corresponding resolutions in order to facilitate easy knowledge transfer.

Environment: Hyperion System 9/11, Hyperion Planning 9/11.x, Hyperion Essbase 9/11.x, EAS 9/11.x, Hyperion Reports 9/11.x, Hyperion Workspace, ODI 10.1.3.5, HFM, Smart View, Oracle 9i/10g, Solaris, Windows 2000 Advanced Server, Windows 2003, Veritas Cluster Manager, IBM Websphere, Eclipse, and Apache Tomcat.
Confidential, Sep’ 08 - Nov’ 09
Philadelphia
Hyperion Planning Developer/Administrator
Confidential,is an American multinational pharmaceutical corporation. The company is headquartered in Midtown Manhattan, New York City with its research headquarters in Groton, Connecticut, United States. is a major pharmaceutical firm with a significant presence around the globe. Hyperion Suite of Financial and Business Intelligence Tools are utilized by the finance department for planning and forecast purposes. I was an integral part of the development team, building the application and assisting in various test phases as well as training the in-house personnel.
Responsibilities

• Production migration and supportUpgrading a 9.2.1 installation of Hyperion to Hyperion 11.1.1.3. Installing and Configuring Oracle Hyperion EPM 11.1.1.3 products(Foundation Services, Reporting and Analysis, Essbase, Planning)
• Training end users
• Development of planning application and its components:
• Dimension development for Accounts, Entities, Departments and other standard dimensions through Hal and manual.
• Web forms for data input for income statement accounts, balance sheet accounts, drivers, stats accounts, and actual adjustments.
• Development of task lists by each planning group.
• Development of calc scripts for final administration tasks such as Full aggregations, full currency conversion, and data copy from one scenario to another.
• Development of Business Rules with Run Time prompts for end user calculations by Entity for driver calculations, currency conversion at their entity, aggregation for their entity etc.
• Development of Essbase components Load rules for actual and other data loads, setting up substitution variables.
• Used various types of Calculations such as Dynamic calc, Two-Pass Calculations, Intelligent calculations for Outline Calculations.
• Performed optimization for various data load rules and calc scripts
• Performed database tuning by setting appropriate index, data and calc cache
• Developed Financial Reports and Web Analysis Reports as per the requirement of user
• Developed Drill through reports using Web Analysis.
• Maintenance and Support for other Planning Applications.
• Involved, planned and coordinated the process to upgrade Hyperion Planning, Essbase from 7.x to 9.x and applied patches to Websphere and BIPlus.
• Development Planning Administration manual with check list for monthly and quarterly processes.
• Planning administration for particular planning cycle

Environment: Hyperion System 9/11, Hyperion Planning 9/11.x, Hyperion Essbase 9/11.x, EAS 9/11.x, Hyperion Reports 9/11.x, Financial Reporting, Web Analysis Reporting, Oracle 9i/10g, HP UNIX, Windows 2003, Bea Web Logic, HAL, EIS.

Confidential, Sep 07 - \' Aug ‘08
Pittsburg, PA
Hyperion Essbase Developer/Administrator
Confidential,is one of the world’s largest producers of aluminum with its headquarters located in Pittsburg, PA. As part of the Global Business Information Services (GBIS), The Leveraged Information Services (LIS) represents a core component of the company by providing Information Services and support to 19 Business Units and over 38,700 employees worldwide. Hyperion Essbase is used by many business and finance users throughout the company. With the need of more support, the Essbase environment required maintenance and more supervision to assure reliability and availability.
Role & Responsibilities:

• Designed, developed, and implemented Expense Planning and Reporting System for the Financial Department at Alcoa using Essbase.
• Involved in gathering requirements and developing a project plan.
• Analyzed all the dimensions and members in the Essbase database using Essbase Administration Services.
• Developed EIS Meta-outline for various cubes and created various filters as per user requirements.
• Responsible for maintaining users and security.
• Worked as an Essbase DBA, which involved predefining data mapping from Hyperion Essbase to the relational source, and running ad-hoc queries for providing optimized reports.
• Involved in reviewing the cube design, Performance Monitoring and Performance Tuning of the Essbase server.
• Designed and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Provided technical guidance and support to end-users by developing the documentation required.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions.
• Designed and developed all the reports using Hyperion Analyzer.
• Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final step before Rolling out of the Application.
• Developed the documentation required to transfer knowledge for the users and for the administration and support.
• Created and managed login restrictions for the OLAP Server.

Environment: Hyperion Essbase 6.0/7.1.2, Microsoft Excel 2000/2003, MS SQL Server 2000, Windows 2000 Advanced Server.

Confidential,Mar\' 06 - Aug\' 07
Carlstadt, NJ
Hyperion Essbase Developer/Analyst
This project is to provide reports based on their businesses, their corporations, projects and lines of businesses to the managerial and decision-makers to help them to analyze the business trends, company P/L\'s and other budget analyses. Project includes building of 5 cubes; put them for automation and to design reports in Hyperion Reports, Analyzer, Planning and Excel Add-In.
Role & Responsibilities:

• Involved in the complete Software Development Life Cycle of both the applications and solely responsible for the design and development of two cubes used for reporting related to strategy and business collection respectively.
• Involved in gathering requirements and developing a project plan.
• Involved in gathering data and supervising data load.
• Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
• Involved in creating Rule files and batch files to automate the data load process.
• Optimized Data Loads and Calc Scripts.
• Implemented robust data-access security and user management.
• Used ESSBASE functions like @IDESCENDANTS and @UDA in creating the Calc Scripts.
• Extensively used MaxL, ESSCMDS to run calculation scripts and report scripts.
• Designed and developed optimized Essbase applications.
• Developed Excel Templates for user interface in Essbase database.
• Hyperion Planning was used to maintain data access to the cube.
• Used Hyperion Planning environment to build interfaces.

Environment: Hyperion Essbase 6.5.2, Excel Add in, Hyperion Planning, Hyperion Reports 2.0