SUMMARY

• Developing business focused technical solutions using Hyperion Planning, HFM & Essbase.
• Thorough Knowledge of entire life cycle of Hyperion EPM products implementation and Administration.
• Developing and implementing applications for customers based on identified requirements.
• Involved in every aspect of development lifecycle from requirements gathering, design docs to development, implementation and maintenance.
• PBCS Implementation and support.
• Certified Essbase Consultant, Certified Planning Consultant and Oracle Hyperion Financial Management 11 Certified Implementation Specialist
• Specialized in Hyperion Application Development and administration using HFM, FDMEE, DRM, Essbase ASO/BSO, Planning, WebAnalysis, Financial Reporting, Essbase Studio and ODI.
• Hand On experience with HFM consolidations.
• Worked with many ETL tools such as HAL, DIM, SSIS, ODI, SQL interface, FDM, FDMEE etc.
• Very good experience on writing Member Formulas, Calc Scripts, BR’s, MDX for calculations, allocations, aggregations etc.
• Expertise in Automations, Optimizations, Converting BSO to ASO, Database backups, Partitioning, ESSCMD, MAXL, MDX, VBscripting etc.
• Experience in Hyperion Planning, Capital Expense Planning, Workforce Planning, Public Sector, and Financial Reports.
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Experience in installing and maintaining infrastructures. Performed day to day administrative tasks.
• Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups, Scheduling daily batch processes using Autosys.
• Good understanding of data warehousing architecture in terms of Logical model, Physical model, RDBMS, ETL, Reports.
• Expertise in design documentation and testing strategies.
• Involved and handled many client meetings with many diverse teams during development process.
• Hands on experience with Hyperion V 11.x Essbase, Planning.
• Hands on Experience with user training on planning, FR, Smartview etc.

TECHNICAL SKILLS

Domain Expertise & Solutions: Financial Systems, Manufacturing, Health Care, Energy, Public Sector

OLAP Expansion Tools: Hyperion Essbase, Planning, HFM, FCM, HSF, FDM, FDMEE, DRM, Hyperion Shared Services, Public Sector, Essbase studio, EPMA, PBCS, FCCS, Smart View Essbase Excel Add In, ESSCMD, MAXL, MDX, HAL, DIM, ODI, Hyperion Performance Suite

Databases: Oracle,Sybase, SQL Server, MS Access

Reporting Tools: Financial Reporting Studio

Hyperion Reports: Interactive Reporting,Hyperion Intelligence,Hyperion System,Smart View,Hyperion Spreadsheet Add in,Hyperion Analyzer

Web Analysis: Web & Application Servers, Apache Tomcat,Weblogic,Websphere

Languages: C, C++,PL/SQL,SQL, Shell Scripting

Operating Systems: Unix, Linux, Windows 2008/2003/2000

PROFESSIONAL EXPERIENCE

Senior Hyperion Consultant

Confidential, MI

Responsibilities:

• Responsible for most of the phases of the project from requirements gathering to production support.
• Design and implement Financial, Forecasting and Management reporting Cubes for European GMF, using Hyperion Essbase
• Integrates Hyperion Planning application with Essbase Applications using SSIS packages.
• Performed optimization techniques for Essbase and Planning applications.
• 24*7 Support at budgeting time.
• Created Maxl, MDX scripts for automation by exporting, importing data.
• Created Hyperion Classic planning application and EPMA Planning applications and supported.
• Created and executed Web forms and Financial Reports using planning applications.
• Supported Hyperion day to day activities.
• Worked Smart view extensively for data entry, data load, lock and send data.
• Support and providing Provisions in Essbase and Planning application security.
• Support ASO cubes and wrote automation scripts like import and export data.
• Enhanced and trouble shoot Hyperion business rules and calculation scripts in Workforce.
• Created FR Reports and trouble shoot existing reports and build and maintained Smart View ad - hoc reports and templates.
• Supported Hyperion Infrastructure related activities like applying patches, stop and start services.
• Performed all phases of the Systems Development Life Cycle (SDLC) Process and documented
• Conducting end-user training and support testing activities.

Environment: Exalytics X5, Hyperion EPM Suite 11.1.2.4 includes Essbase, Planning, FDMEE,FR Studio, SQL Server 2008, FR reporting, smart view, Visual Studio, MS Office 2013, MS Office 2010, Windows 2008, Linux

Senior Consultant

Confidential

Responsibilities:

• Worked in implementing Public Sector Planning and Budgeting (PSPB) budgeting solutions to Federal Government agencies.
• Worked in implementing ETL/integration solutions using Hyperion Financial Data Quality Management (FDMEE) and Oracle Data integrator (ODI)
• Worked in managing and implementing Corporate Consolidation and Reporting solutions using Oracle's Hyperion Financial Management product.
• Worked in management of production application support for Oracle’s Hyperion suite of BI&EPM products
• Worked in implementing and managing Sarbanes-Oxley audit controls on Financial Management applications
• Worked in managing the processes for enterprise change management and deployment
• Worked in developing backup strategy and scripts for Hyperion applications
• Worked in developing and implementing disaster recovery for Hyperion applications
• Worked in Essbase Integration Services (EIS). Developed OLAP Models and Meta outlines for loading dimensions and data into Essbase cubes.
• Strong knowledge and expertise in Optimization of Dimension Building, Data Loading and Reporting
• Collaborate with other teams in various activities such as Operating system patches, hardware procurement and network related issues

Confidential, OH

HFM Lead

Responsibilities:

• As a Hyperion Administrator, responsible for all Hyperion products within the organization
• Responsible for providing application support for Hyperion business applications (Financial Management) maintained by Genpact.
• Responsible for issues management including, but not limited to, problem evaluation, analysis, resolutions and processing.
• Research and analyze root cause for production issues; provide resolutions and workarounds in a timely manner; escalate to development and/or vendors when applicable.
• Communicate with customers as and when needed on issues and functionality, building a loyal customer relationship.
• Responsible for handling Hyperion Reports, Hyperion HUB, Hyperion UpStream applications.
• Creating Hyperion Reports based on Customer Requirement
• Backup for DRM support.
• Automating all the required tasks for a daily activities
• Implement LEAN & SIX SIGMA with in the project
• Ensure all the major tasks have a check-list for a successful error free task.

Environment: Hyperion Financial management 9.3, FDM, Hyperion Planning 9.3.1, DIM, Financial Reporting Studio 9.3, Oracle 11g, ESSBASE Excel Add-in, Financial Reporting, HP UNIX, Windows 2003.

Confidential, PA

Consultant

Responsibilities:

• Ability to do budgeting and forecasting at the county, entity, business unit and department level with the ability to generate reports at these levels.
• Involved in designing and creating multidimensional database cubes for financial and analytical business queries.
• Worked on building dimension from multi source interfaces.
• Created and developed planning applications to support budgeting process and ASO cube for reporting via Essbase studio.
• Created flexible workflows, task lists that pertains to the budgeting and planning process
• Created and modified rules files for accommodating data format changes and enabling cube loading.
• Developed complex matrix and logic for move data between cubes. Also used many cross ref functionality between the cubes.
• Implemented mathematical functions for computing derived data and worked on optimization of data loads and Calc-scripts.
• Developed batch scripts and MaxL for automating and scheduling month end routines, backups, aggregations etc.
• Leveraged the LCM functionality to create complete artifacts backups by developing automated XML scripts.
• Designed the Security Policy at User, Group, and Entity Levels using Hyperion Shared Services.
• Developed workforce application using Hyperion that captures Labor related expenses and headcounts. This application also provides the additional variance analysis.
• Worked on calculation scripts to optimize the calculation time and also modified the existing ones to meet the end user requirements.
• Responsible for tuning the multidimensional cubs to optimized calculations time by using the calculation scripts using the combination of ESSCMD and MaxL.
• Minimized the data load redundancy by loading rules files object in-terms of performance and optimization data source files.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Worked closely with stakeholder, Steering team and SME’s in project management activities.
• Created statement, Balance Sheet, Cash flow statements and many user specific reports using FR, Web Analysis.
• Involved in loading metadata into planning by using DIM and Oracle Data Integrator (ODI).
• Created numerous templates to generate various reports and for Adhoc reporting.
• Developed end user training documentation and conducted numerous training sessions for end users.
• Developed a procedure for bursting the reports by Dept and Entity.
• Implemented various troubleshooting procedures to recover databases.
• Tested and Cross tested (System testing) all the reports before publishing.
• Provided on call Production support during budgeting and forecasting for Hyperion Applications.

Confidential, MA

Senior Consultant

Responsibilities:

• Database Administration, People Soft Support.
• Normal DBA activities.
• Disk space estimation, extraction data from OLTP databases
• Loading Bulk data from external database for initial loads.
• Design and Develop Data Integration Processes.
• Develop Enterprise Data Warehouse.
• Design star schema and snowflakes schema.
• Populate and validate Data Warehouse and Data Marts.
• Creating and Maintenance of OLAP Services.
• 24 * 7 support for Production Databases.

Confidential, NJ

Responsibilities:

• Creating procedures to cleaning data and loading into DSS Databases.
• Normalization and De-Normalization especially for critical reports.
• Migrating data from one Server to other.
• Writing Complex Stored Procedure of BI Reports.
• Query tuning to achieve the optimum performance.
• Involved in Logical and Physical database design and table space estimation.
• Writing shell scripts to run batch Jobs.