SUMMARY

• Over 7 years of rich IT experience delivering proven track record in Hyperion Planning, Hyperion Essbase, Consulting, Hyperion Financial Management (HFM), Financial Modeling/Analysis, Budgeting, and Client Management.
• Experienced in leading teams of varied types/sizes and possesses excellent analytical, problem solving, communication and interpersonal skills.
• Extensive experience in Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Web Analysis, Smartview for Office, ESSCMD, MaxL, MDX, Essbase Excel Add - in. on Windows and UNIX environment.
• Hands on experience in Oracle Enterprise Management Architect (EPMA) technology.
• Involved in complete Software Development Life Cycle (SDLC) for various Essbase and Planning projects.
• Skilled in the optimization, automation and performance tuning of Essbase application data/metadata processing and migration.
• Extensively involved in maintenance, automation, backups, Performance tuning and Optimization of cubes and calc scripts to facilitate effective business decision making.
• Capable of managing organization’s data, assess and fulfill its reporting needs and develop powerful BI solutions that have true impact on the performance of a company.
• Key strength in optimization and tuning of Essbase cubes across Block Storage (BSO) and Aggregate Storage (ASO) Essbase kernels.
• Expertise in gathering and analyzing the requirements of users and translating them into specifics cube definitions and design.
• Maintained database optimization while performing Data Loading, making Business Rules, Calculation Scripts, and Report Scripts.
• Proficient in dynamically building Dimensions, Attributes using Rules files and loading Fact data in Essbase applications by means of several build methods such as generation, level and parent-child references.
• Adept in using Hyperion Essbase Application Manager modules; Outline Editor, Report Editor, Calc Script Editor, and Data Prep Editor.
• Outstanding communication, interpersonal, written, analytical and problem solving skills.
• Excellent ability to understand complex scenarios and business problems, and transfer the knowledge to other users/developers in the most comprehensible manner.
• Worked on installing, configuring, upgrade and documentation of Hyperion System 9.x and 11.x, including Workspace.
• Extensive knowledge on setting up reporting cube ASO from scratch optimizing it and handling of incremental loads.
• Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating and assigning filters.
• Extensive involvement in maintenance, automation, backups, Performance tuning and Optimization of Essbase cubes both ASO and BSO, Calc scripts, reports and applications to facilitate effective business decision making.
• Provided user training, documentation and rollout of new projects.

TECHNICAL SKILLS

OLAP and BI Tools: Oracle Hyperion Planning 11.x/9.x, Oracle Hyperion Essbase 11.x/9.x/7.x, Essbase Administration Services (EAS), Hyperion Shared Service(HSS), Analytic Integration Services (AIS/EIS),Workspace, SmartView for Office, MS Excel Add-in, Essbase query designer, OBIEE, Oracle Data Integrator, Essbase Studio

Reporting Tools: Financial Reporting, Web Analysis, Spreadsheet Add-In, Smart View, Teradata SQL assistant

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL, C, C++, Shell Script.

Client Tools: MS Office Suite 2010, 2007, 2003, 2000.

Modeling Tool: Star Schema, Dimension and Fact tables, Logical and Physical Modeling.

Databases: Oracle 10g/9i, MS SQL Server (2003, 2005, 2008), MS Access, Toad, Teradata.

O.S.: Windows N.T /2000/XP/Server 2003, 2008, UNIX/LINUX

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Hyperion Consultant

Responsibilities:

• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Upgraded the EPM system form 11.1.2.2 to 11.1.2.3
• Performed metadata building using outline load utility for different dimension and various applications.
• Create Planning application through EPMA.
• Maintain the dimensions through dimension library in EPMA
• Developed Dynamic Web forms for various applications with POVs, menus, run time prompts and Pages.
• Analyzed, designed, updated, tested and migrated Essbase Cubes in different environments and also performed tuning and optimization of ASO applications.
• Developed Rules files for data Metadata and Data loading in Essbase for BSO applications.
• Extensively designed and developed monthly/quarterly financial reports (balance sheet statement, cash flow statement) usingHyperion reports scripts.
• Build various business rules for to perform various calculations for different application. Build admin rules and user rules.
• Worked on building rule files for data load and metadata loading for ASO applications.
• Worked on financial reporting. Build various reports using Prompts, User POV, Grid POV, Conditional Suppression, and Conditional Formatting and used formula in it according to the recipe provided by users.
• Worked on migration of applications form one environment to other. Migrated application from development server to Pre-Production and Production server.
• Worked on security in shared services. Build various security filters and granted access to the application and its dimensionality according to the requirement provided. For various users/groups.
• Worked withEssbase Integration Services(Meta Outline Workflow/Filters/Drill through Reports) & Essbase Studio.
• Designed Labor application using workforce database and implemented & modified the workforce business planning using Business rules.
• Worked on MAXL scripting for automation. Used MAXL scripts in batch files for performing data and metadata
• Worked on Design Documentation for various applications. Explained from starting to end about the description of application. Its dimensionality, various data forms, menus associated and business rules. The Various financial reports associated with it.
• Worked on providing User training documents. Build excel files describing the data forms, how they work and business rules association with them and what rule is doing.
• Worked on Replicated partition which transferred data from 3 BSO cubes to a single ASO cube.
• Worked on designing filters for the entire reporting cube giving user read access to Essbase.
• Modified Essbase filter for planning applications giving users write back capabilities in smart view for their specific security allotment.
• Extensively worked on Lifecycle Management to migrate security, Essbase application and its components from DEV to PROD environment.
• Responsible to create Planning Unit Hierarchy (Workflow) by gathering requirements from business users and assign users to their respected cost center.
• Also assigned different users to different roles like Owner, Reviewer to plan their respective cost center.
• Extensively worked with Hyperion Shared Services to give access and provision to users and groups.
• Configured various LDAP active directories with Hyperion Shared Services.
• Worked on designing batch scripts for monthly process and scheduler for running the refreshing of partition script every 4 minutes.

Environment: Hyperion Planning 11.1.2.3/11.1.2.2 , Hyperion Essbase 11.1.2.3/11.1.2.2 , Essbase Administration Services (EAS),Essbase Studio, Shared Services, EPMA, Hyperion Financial reporting 11.1.2.3/11.1.2.2 , DRM, OBIEE, Hyperion Financial Management (HFM), Smart View, Microsoft SQL Server, Excel Add-in, MS Excel 2010, Linux 5.6.

Confidential, Anaheim, CA

Hyperion Consultant

Responsibilities:

• Requirement analysis and documentation leading to an effective Hyperion solution incorporating user needs of converting Excel based Budgeting and Forecasting Process to Hyperion Planning in-order to increase efficiency
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• Configured ODI agent and leveraged Knowledge Modules to define workflow and task automation
• Designed Outline layout, forms to facilitate Revenue budgeting at a quarterly level and Costs at a monthly level
• Created business rules that replicate the functionality of complex formulas existing in excel
• Developed Dynamic Web forms for various users with POVs and Pages
• Designed the overall workflow of the budgeting and forecasting process with kick-off, reviews and approval states
• Maintenance and support of the Hyperion Planning applications created
• Implemented application security process, created users/groups, security profiles and application access to different groups using filters
• Created Calc scripts for various purposes for example if the company paid the policy holder more than certain period of time was that customer still with the company or not.
• Performed allocation for different departments to increase the business performance.
• Created Aggregate Storage (ASO) application from the Block Storage (BSO) applications for executive level reporting
• Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting
• Developed Reports to compare against different months & years, entities and scenarios using Smart view.
• Extended the functionality of the planning system to include workforce estimation planning
• Provided user Documentation, Training and Production support as part of the Implementation
• Generated reports, Table, Queries in Interactive reporting Studio.
• Redesigned currency conversion scripts to facilitate reporting in more than one currency.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Maintaining and updating Essbase and planning applications as per user and business requirements.
• Extensively working on Database optimization and performance tuning of Essbase cubes for fast retrieval and calculation performance.
• Providing training to end users in MS Excel spreadsheet add-in and Web forms to enter data.

Environment: Hyperion Planning 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion interactive reporting, EPMA, Essbase Administration Services (EAS), DRM, Hyperion Financial Management (HFM), Shared Services, Oracle Data Integrator (ODI) 10.1.3.4, OBIEE, Oracle Database 10g, Windows Server 2008, Linux, Windows XP, MS Excel 2007.

Confidential, Los Angeles, CA

Hyperion Consultant

Responsibilities:

• Participated in business requirements gathering & determining the project scope.
• Developed & support appropriate programs & system documentation according to the established IT standards.
• Developed complex formulas and Calc scripts reflecting the business users requirements on the Cube
• Created Rule Files for loading the data and for building the Dimensions dynamically.
• Used various types of Calculations such as Dynamic Calc, Two-Pass Calc, Intelligent Calc for Application outlines.
• In EPMA loaded all dimensions from Ads files, built the App & deployed it to planning.
• Used ODI as a data integration (ETL) tool, integrating Hyperion planning with flat files & Oracle DB.
• Migrated planning applications from development to production environment.
• Created the workflow in Accounts with smart list “Approved”, “Rejected”
• Developed Webforms, Menus, Task lists, Financial reports in ROI project.
• Created Daily Reports by looking at the existing Excel reports using Hyperion IR studio.
• Created various reports for Credit, Debit and Liability.
• Used various functions like Conditional, Date, Numeric, String Functions and If Then to build reports.
• Developed various scripts like Date for the reports to run automatically in the specified time period like Monthly, Weekly, and Daily.
• Created various Scripts for Dashboards.
• Created alternate hierarchies in EPMA for reporting & deployed the applications.
• Developed Books from the Financial Reports

Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion interactive reporting, EPMA, Hyperion Financial Reporting 11.1.1.3, Essbase Administration Services (EAS),Shared Services, Oracle Data Integrator (ODI) 10.1.3.4, Oracle Database 10g, Windows Server 2003, Linux, Windows XP, MS Excel 2003.

Confidential, Bridgewater, NJ

Hyperion Consultant

Responsibilities:

• Responsible for development and maintenance of Hyperion Essbase applications to help in the analysis of Verizon’s business performance and provide insights into various customer segments.
• Gathered user requirements and then transformed them into Dimensions and members.
• Optimized Aggregate Storage Option and Block Storage Option outline.
• Developed Rules file for Dimension Building and Data Loading.
• Created reports using Hyperion Financial Reports & Hyperion Smartview.
• Designed and developed web forms as per the business requirements using Hyperion Planning.
• Extracted data manually from different sources to combine different sources into one business report.
• Developed Calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Performed performance tuning and database optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of Calc scripts and tuning of Calc cache.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Developed web forms using Hyperion Planning for users to input data.
• Designed Task lists for planning applications.
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports.

Environment: Hyperion Planning 9.3.3/11.1.1.3 , Hyperion Essbase 9.3.3/11.1.1.3 , HyperionFinancialReports 9.3.3/11.1.1.3 , Hyperion Smart View, Workspace, Hyperion Shared Services 9.3.3/11.1.1.3 , Windows NT, Oracle 10g.

Confidential, Cincinnati, OH

Hyperion Consultant

Responsibilities:

• Coordinated with Client and Business Analyst to understand and develop an Optimized Cube.
• Designed the environment and flow of the business for the company setting up the overall architecture.
• Developed Block Storage Cubes (B.S.O) cubes
• Developed load rules for dimension build and data load.
• Created various filters as per user requirements in EAS
• Retrieve reports using Excel add-in and generate reports in Hyperion Reports.
• Involved in dynamic dimension building and modifying outlines.
• Developed batch scripts for automating the dynamic dimension builds and data loads.
• Assured optimal match between cube design and report specifications.
• Optimized dense and sparse database settings for improving retrieval times.
• Responsible for granting users access based on their specific needs and assigned them to specific groups.

Environment: Hyperion Planning 9.2, Hyperion Essbase 9.2, Hyperion Financial Reporting 9.2, Hyperion Shared Services 9.2, Hyperion Smart View, Workspace, Windows NT, Oracle 10g.

Confidential

Hyperion Consultant

Responsibilities:

• Installed Hyperion Planning Desktop and Planning Web.
• Defined Exchange rate tables and Generating Currency conversion calc scripts for Multi currencies.
• Developed customized web forms for all cube along with the business rules.
• Interacted with end users and developed numerous Business Rules using HBR in Planning.
• Assigned security access to the Users, Groups, dimension members and web forms through Hyperion Planning.
• Developed automation scripts for back up and Refresh of all Production Cubes.
• Created new MaxL Scripts and scheduled the batch script to automate the running of the new Calc Scripts.
• Analyzed financial results and prepared trend reports using Hyperion Reports 7.0 & Hyperion Analyzer 7.x to support business managers make profitable decisions.
• Involved in Migrations of databases from development servers to QA/Production servers. (Load Rules, Calc Scripts, Report Scripts, DB Settings from DEV to PROD)
• Developed the ESSCMD scripts and MAXL scripts to take backup of the database and to recover from the failure
• Involved in designing and developing the corporate financial charts (Look and Feel) and other Adhoc management financial reports using the Hyperion Analyzer 7.0
• Implemented application security process, created users/groups, security profiles and application access to different groups using filters.
• Performed optimization on the applications and cubes to increase the performance of data load, calculation time and retrieval of the reports using the Dense/Sparse settings, Cache settings, making changes in Outline formulae, changing the Data Storage properties and by optimizing calc scripts.
• Developed documentation required for knowledge transfer to users for application administration and support.

Environment: Hyperion Essbase 7.1.2, Hyperion Planning 3.5.1, HBR Designer 3.5.1, Hyperion Reports 7.0, Hyperion Analyzer 7.x, MaxL, ESSCMD, Excel Add-in, Oracle 9i, SQL Server 2000, Windows 2000 Professional