SUMMARY

• 8+ years of proficiency and experience in a range of Hyperion products including Essbase, Hyperion Financial Management, Hyperion Planning, Integration Services, Smart view, DRM, FDM and Spreadsheet Add - In, in both Windows and UNIX environments.
• Expertise in architect tasks of Essbase: managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, MaxL, MDX Querying, Report Scripting, Performance tuning, thorough understanding of Essbase data mining framework.
• Experience in design, development and implementation of various applications using Hyperion Essbase 11.1.2.1/11. x/9.x/7.x, Hyperion Planning, Hyperion Reporting and Analysis, ESSCMD, Maxl, Essbase Excel Add-In, on both Windows and Unix environment.
• Practical experience in installing and configuring complete Hyperion suite in a distributed environment.
• Strong experience in creating Jobs on Automate BPA Server (BPA).
• Strong experience wif handling production incidents and resolve those before breaching SLA.
• Experience in OLAP Budgeting and Forecasting Application wif Hyperion Planning.
• Working as Hyperion Consultant, Supporting Hyperion Financial Management, Hyperion Reports, Essbase and FDQM data loading.
• Strong experience in creating Jobs on Automate BPA Server (BPA) tool.
• Experience in creating controlled reports on Automate BPA Server (BPA) tool.
• Involved in writing complex Essbase calculations scripts, automation of Essbase Cubes using MaxL, ESSCMD, and MDX.
• Involved in development of ETL jobs for Hyperion Essbase, Hyperion Planning metadata and data loading using Oracle Data Integrator.
• Strong hands on experience in Hyperion Financial Reporting(FR) Studio.
• Experience in working wif Aggregate Storage Outline (ASO) and Block Storage Outline (BSO).
• Involved in Setting up application instances required to create all the different logical environments in the system development life cycle (DEV, TEST, UAT, and PROD) helped in assisting clients and provided remote assistance in implementation.
• Responsible to install Essbase client, Excel Add-In and Smart-view on client's machine and on the CITRIX server.
• Strong experience on creating Security Filter for groups and users using MaxL Script and setting their privileges by utilizing Hyperion Essbase Security component
• Created and developed the Data Flows and Process Flows for the Essbase Applications.
• Worked on PBCS (Financial Statement Planning) to assist client to plan and forecast revenue and expenses for Income statement, Balance sheet and cash flow.
• Creation and optimization of Calculation Scripts/Business Rules based on the business requirements in PBCS
• Designed custom substitution variable Excel template using Visual Basic scripts. Those templates are used for updating the variables.
• Designed Essbase applications for day to day end user reporting and planning applications as per client requirements for budgeting and forecasting.
• Created complex and simple reports from relational/ Multi-dimensional databases using OBIEE
• Created OLAP Models and Meta Outlines using Essbase Integration Services (EIS) for dimension building and data loading.
• Automated data loading and dimension building using EPMA Batch client.
• Designed and Developed complete Essbase, Planning automation of metadata and data load using server rules files, maxl scripts and Oracle Data Integrator.
• Good hands-on working experience on various features (Journal, Reports, Application, Load, Extract, Data and Security).
• Experience in designing and developing reports using Cognos Report studio.
• Involved in administration of Cognos packages and reports.
• Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Experienced in automating application building process, loading data and metadata and attributes using MaxL, ESSCMD, scripts, and BPA tool.
• Migrated applications from one environment to other using LCM process and copy application utilities.
• Experience on Validating the Essbase applications.
• Expert in creating the documentation.
• Good Knowledge on Java, .Net programming skills.

TECHNICAL SKILLS

BI Tools: Essbase 11.1.x/9.x, Planning 11.1.x/9.x/, Smart View, Hyperion Analyzer 11.1.x/9.x, Hyperion Reports 9.x/7.x, Essbase Excel Add-in, Crystal Reports, Cognos, BPA

ETL Tools: Informatica 8.x/9.x, Data Stage 8.0/7.0, ODI 10/11G

Databases: Oracle 9i/10g/11g, DB2 8.0, MS SQL Server 2000/2005

Tools: Erwin 3.5.2, PVCS, Rational Clear Case

Middleware: Web Logic, IBM’s Web Sphere, Java Web Server

Others: MS Project, Visio, MS Office, MS Excel

Automation Tools: IBM Cognos Command Center 10.2.1, Automate BPA 10.0

Operating Systems: Windows XP, Window 7/8, Windows Server 2008/2012, Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Senior Hyperion Consultant

Responsibilities:

• Design and develop new ASO cubes to support new analytical requirements related to Funds Transfer Pricing and Account Reconciliation.
• Create and Automate daily reconciliation report
• Build automation using Cognos Command Center.
• Maintenance and Enhancements to existing cubes for the ALM team
• Responsible to install Essbase client, Excel Add-In and Smart-view on client's machine and on the CITRIX server.
• Created and managed Essbase users, user groups, and setting their privileges by utilizing Hyperion Essbase Security component.
• Solid understanding of Multidimensional and Relational database architecture; Extensive knowledge of planning, budgeting, and forecasting procedures.
• Involved in defining data mart to support Hyperion Essbase and created reports Financial reports and web Analysis.
• Maintenance of previous Essbase cubes along wif the newly designed cube.
• Optimization of data storage which increased the performance of existing cubes.
• Designed load rules for Dimension build and data loads.
• Designed new CALC scripts and Report Scripts.
• Created and made changes to the existing MaxL scripts and scheduled the batch script.
• Created automation jobs on BPA tool.
• Developing ASO and BSO cubes using Hyperion Essbase dat contained financial data dat was retrieved using FR reports
• Involved in Setting up application instances required to create all the different logical environments in the system development life cycle (DEV, TEST, UAT, and PROD) helped in assisting clients and provided remote assistance in implementation
• Automated running new Calc Scripts.
• Developed and modified Report Scripts and Rules files.
• Involved in Performance Tuning to minimize data load time.
• Maintain outline, metadata and member formulas as business requirements change.
• Created custom reports using Hyperion Reports.
• Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense variances over prior periods using Hyperion Reports/Analyzer.
• Involved in automation of all operations using MaxL scripts.
• Created Security access to different users in both Essbase and Hyperion Planning.
• Designed Filters using Essbase Administrative Services (EAS) and assigned them for different users.

Environment: Hyperion planning 11.1.2, Essbase 11.1.2, EIS-Integration services 11.1.2, Essbase Studio 11.1.2, Hyperion Financial Reports Studio V9.3, Hyperion Data Integration management 11.1.2, Hyperion smart view, BPA, Cognos, Citrix Oracle 11g, Oracle Applications, MS Excel Add-in, VB Scripting, ODI 11g

Confidential, Baltimore, MD

Senior Hyperion Consultant

Responsibilities:

• Experience in creating and maintaining the Hyperion Planning application, Data Forms, Business Rules, Menus, Task Lists & loading the data from flat files and interface tables.
• Experience in migrating the planning applications from one environment to another.
• Created Block Storage Application (BSO) and Aggregate Storage Application (ASO) cubes.
• Strong understanding of Dense and Sparse strategy dimension allocation performed dynamic calculations.
• Experience in developing OLAP models and metadata outlines for loading dimensions and data into Essbase Cubes.
• Developed Batch Scripts and Rules files for dynamically uploading dimensions and data to Essbase Cubes.
• Responsible for security groups and access for the users in Hyperion Reports Planning and Essbase.
• Expert in user provisioning and setting up groups wif Roles and Privileges.
• Built new Calc scripts and developed MaxL scripts for automation process.
• Very proficient in writing Calculation Scripts and automating the Essbase cubes using MaxL, ESSCMD, MDX and Batch Scripts.
• Experience in creation and maintenance of numerous applications and Multi-Dimensional Database (MDDB) using BSO and ASO.
• Created Hyperion Business Rules (HBR), Calc Scripts, Report Scripts, Security for HBR’s—Global Security Filters and Web forms. Salary script based on Headcounts, Rundown unit’s calculation, cost of sales was few of HBR’s.

Environment: Hyperion planning 11.1.2, Essbase 11.1.2, EIS-Integration services 11.1.2, Essbase Studio 11.1.2, Hyperion Data Integration management 11.1.2, Hyperion smart view, Oracle 11g, Oracle Applications, MS Excel Add-in, VB Scripting, ODI 11g, BPA, Cognos, Citrix

Confidential, Nashville, TN

Hyperion Essbase/Planning

Responsibilities:

• Design, develop, and implement enterprise-wide budgeting, forecasting, and financial reporting cubes.
• Installed and configured entire Hyperion infrastructure for test and production instances
• Involved in Installation, configuration and validation of all 11.1.2.1 Hyperion components
• Involved wif customers and data analysts in design of data flow, integration and transformation of data into data marts.
• Configured Hyperion system wif multiple application and web servers to provide continuous availability of Hyperion services.
• Configured load balancer to manage the load on the Hyperion services.
• Developing ASO and BSO cubes using Hyperion Essbase dat contained financial data dat was retrieved using FR reports
• Involved in creating, redesigning, testing, documenting, reporting, protecting, supporting and administrating the full life cycle of multidimensional database using the Hyperion software family.
• Created applications on Hyperion as per the user requirements.
• Designed application as per end user requirements and fulfilled all the customizations as required.
• Developed Batch Scripts to load data into cubes and schedule to run on a periodic basis.
• Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision, restructuring cubes for defragmentation.
• Created Hyperion planning web forms to enter, update, analyze, print, and report on data.
• Created transparent partition for the ASO cubes as target for BSO source cubes to enhance reporting.
• Created SQL scripts for sourcing data from Teradata, including creating tables, views, stored procedures, loading data into the tables.
• Created the Planning applications wif the plan type for Revenue, expenses, capex and workforce modules.
• Involved in data tie-out for performing OLAP cubes using a simple variable substitution mechanism, to ensure dat data is the same in both system.
• Strong experience in writing the VBA scripts in Excel to refresh excels templates.
• Implemented the Dense/Sparse dimensional architecture wif Attribute dimensions, Smart lists based on the requirement and easy to use and update in future.
• Designed detailed level of security for Hyperion applications using shared services.
• Experience wif complex IT and Finance environments wif multi-tiered reporting systems.
• Worked on day to day production supports for Essbase and Planning applications.
• Worked on day to day production tickets related to Hyperion applications. Supported products are Hyperion planning, Essbase, HFM, FDQM, Smart View and Excel Add in.

Environment: Environment: Hyperion Essbase 11.1.1, Hyperion Planning, Hyperion Financial Reports Studio V9.3, Web Analysis, Hyperion Integration Services, WebLogic 8.1, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, Windows NT/2003, Unix / AIX Shell scripts.

Confidential, Detroit, MI

Hyperion Consultant

Responsibilities:

• Involved in requirement analysis and documentation leading to an TEMPeffective Hyperion solution incorporating user needs of converting the requirement from the previous implementation partner to new implementation partner
• Developed and enhance Web forms for various users.
• Created business rules dat replicate the functionality of complex formulas existing in excel.
• Worked on implementing a rolling forecast solution to facilitate Allocation Reporting and Scenario Planning through driver - based forecasting models.
• Written, maintained and enhanced calculation scripts to optimize Hyperion performance including currency conversions, data uploads, data exports and data transfers to various scenarios and versions.
• Written reporting scripts for data exports and load rules to load the data from one planning application to another.
• Worked directly wif Finance Planners in modifying Planning Web Forms and enhanced business rules.
• Maintain, update and automate the business logic into data load and calculation processes for all Planning and Reporting Applications.
• Maintained and supported Hyperion Planning applications also implemented application security process, created users/groups, security profiles and application access to different Groups using filters.

Environment: Environment: Hyperion Essbase 9.3.1, Hyperion Planning, Hyperion Financial Reports Studio V9.3, Interactive Reporting, Web Analysis, Hyperion Integration Services, WebLogic, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, UNIX Shell scripts.

Confidential

Hyperion Developer

Responsibilities:

• Developed outlines using design document.
• Involved in all aspects of Essbase Design, Development: Calc scripts, load rules, dimension builds in Essbase 6.5 and migrate them to newer versions.
• Installing Essbase Analytic Services of versions 6.x, 7.x and 9.x along wif server and clients.
• Responsible for defining and implementing Security issues like creating users, groups and filters and migrate them.
• Implemented security filters.
• Involved in creating and maintaining analytical and planning applications.
• Developed rules files for data loading using Essbase Administration services.
• Automated the entire build, load, calc using MAXL.
• Involved in changing the Metadata whenever needed.
• Developed Analytical reports using Web Analysis

Environment: Hyperion Essbase 9.x, Hyperion Planning 9.x, Hyperion Excel Add-in, Web Analysis