SUMMARY

• 14+ years of experience in Data Warehousing, ETL & OLAP with a focus on Hyperion Suite of Technology.
• Proficient in creating Oracle cloud PBCS and EPBCS applications, Hyperion Financial Reports (HFR) to measure financial performance, analyze profitability, and facilitate effective business decision making.
• Hyperion Essbase, Planning, Shared Services, Workspace, Smart View - Strong experience with the design, build, implementation, optimization, automated processing, administration & training of all products. BSO/ASO cubes, Calculation & report scripts, partitions, load rules, web forms, business rules, Esscmd, MaxL.
• Financial Analysis - Operational Planning & Budgeting, Trend, and KPI identification analysis. Operational, statistical, and fiscal reporting with variance explanation. Report design, packaging, and presentation to management.
• Project Management - Technical and business lead experience. Interaction and presentation to all levels of management. Identifying key objectives, scope, risks, drivers, and fostering cooperation between departments to enable success.
• Tableau 10 integration with Hyperion Essbase & planning 11.1.2.4 for management dashboards and adhoc reporting
• Successfully implemented Hyperion planning - Workforce & CAPEX (Capital Expense) planning modules and created custom business rules related to employee benefits calculations, employee transfers, OH allocations, depreciation, amortization etc.
• Strong database development and business intelligence modeling capabilities; database backups, partitioning, Esscmd scripts, MaxL scripts, MDX queries Optimization and tuning cubes etc.

TECHNICAL SKILLS

OLAP: Oracle Planning and Budgeting Cloud Service (PBCS) and Enterprise PBCS (EPBCS), Hyperion Planning 11.1.2.4, Essbase 11.1.2.4/9.3.1 , HFM 11.1.2.2, Hyperion DRM (MDM), FDM

Reporting Tools: Tableau 9.1, Hyperion Financial Reporting (HFR) Studio 11.1.2.4, Hyperion Smartview 11.1.2.4, Cognos Reports, VBA Templates

Data Warehousing: ETL, ODI, Datamart, OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader

Databases: Oracle 12c/10g/9i, MS SQL Server 2000, MS Access

Programming: SQL, PL/SQL, Windows 2003 Server, Visual Basic 6.0/5.0, HTML, DHTML, XML, Websphere, C, C++, Unix Shell Scripting, TOAD.

Environment: HP-UX10.20, Sun Solaris, Windows, Linux

PROFESSIONAL EXPERIENCE

Hyperion SME

Confidential - Sunnyvale, CA

Responsibilities:

• Worked with NetSuite to pull data for EPBCS system and design mapping with data management.
• Improve the performance of an application by re-write all BR and optimized application settings and data load.
• Design long term footprint for EPM Project for frequent merger/acquisitions.
• Design workforce module in EPBCS which calculates employee salary, benefits, taxes, transfer in-out, headcount reconciliation with the workday, and RSU Calculation.
• Migrate and optimized revenue, capital asset planning, long term planning in EPBCS.
• Written custom Jython scripts in Data management for Email notification and transformation of data.
• Used Groovy scripts to accommodate user requirements like masking data, changing colors of the web form, transfer in-out process.
• Excellent skills of LCM (Life Cycle Management - System 11) migration of EPMA master Dimensions/ Custom dimensions/ Application properties/ Application objects and Security.
• Designed security in Hyperion Essbase applications for multiple users/groups and create SSO login for user

Environment: Oracle EPBCS, Hyperion Planning 11.1.2.4, Essbase 11.1.2.4, HFR, Tableau 10, DRM.

Hyperion Planning SME

Confidential - Santa Clara, CA

Responsibilities:

• Technical project lead for Oracle Hyperion Enterprise Performance Management (EPM)/Planning 11.1.2.2 implementation with a team of internal staff and external consultants.
• Extensively used Hyperion Financial Data Quality Management (FDQM) ERPI integrator for loading Oracle e-Business suite 11i (EBS) source data to the planning application.
• Define source accounting entities from Oracle e-business suite 11i source type in ERPI integrator.
• Developed rules to calculate data which are not hierarchical aggregation in HFM.
• Described users the consolidation process and entered currency exchange rates, consolidated data on Entity dimension and set up the organization by the period.
• Created an export from HFM to relation tables, created an OLAP model and then created Essbase Analytics outline and database and transferred data from relational tables to Essbase Analytics database.
• Developed high-visibility and high-priority Financial Management Reporting dashboard solution for operations reporting.
• Excellent skills of LCM (Life Cycle Management - System 11) migration of EPMA master Dimensions/ Custom dimensions/ Application properties/ Application objects and Security.
• Technical subject matter expert for reporting user training.
• Data-access security and user management using filters and Shared Services.
• Developed Calc Scripts, Load Rules and Report scripts.

Environment: Oracle Hyperion Planning 11.1.2.2/9.3.1 , Hyperion Essbase 11.1.2.2, Hyperion Financial Management (HFM) 11.1.2.2, Hyperion Financial Reports Studio, Hyperion Shared Services, DRM 11.1.2.2/ MDM 9.2, Oracle e-Business suite 11i (EBS).

Sr. Hyperion Planning/Forecasting Analyst

Confidential - Manhattan, NY

Responsibilities:

• Involved in the design and development of Forecasting & Planning cubes used for reporting related to quarterly, monthly forecast and annual budget.
• Hyperion Planning 11.1.1/9.3.1 release was used to create web forms, business rule and workflows.
• Excellent skills of performance tuning of Essbase ASO/BSO & Planning applications.
• Installation and configuration of Hyperion Planning and reports on Windows 2000/NT servers.
• Migration of planning web forms and security from Hyperion Planning 9.3.1 to 11.1.1.
• Used ODI adaptor to define the loading of source data from SAP ERP data into target analytical applications.
• Extensively used ODI IKM SQL to Hyperion Planning module to load planning application metadata and data.
• Maintained the topology and logical schema for the ODI environment.
• Scheduled the ODI packages in with help of ODI scheduling utility.
• Migrated MDM 9.3.2 to DRM 11.1.1 and maintained Cost center and account hierarchies in DRM.
• Created validation rules and export books in DRM.

Environment: Oracle Hyperion Planning 11.1.1/9.3.1 , Hyperion Essbase 11.1.1, Hyperion Workspace 11.1.1, Hyperion Financial Reports Studio, Hyperion Shared Services, MDM, DRM 11.1.1 /MDM 9.3.2, Clarity CPM 6.2, SAP ERP.

Sr. Hyperion Systems Analyst

Confidential - Westborough, MA

Responsibilities:

• Requirement gathering for the Essbase ASO Cube design & development.
• Created Web forms, Smart Lists, Business Rules and Menus using Hyperion Planning 11.1.1.
• Implemented star schema and used EIS to interface with the company's existing Oracle 10g data warehouse.
• Designed Meta outlines, alternate and ragged hierarchies, data loading SQL and customized Drill-through reports in Hyperion Essbase Integration Services (EIS) 11.1.1.
• Used DRM 11.1.1/ MDM 9.3.1 for monthly Essbase outline maintenance hierarchy changes.
• Developed Verification and Validation rules in DRM for data integrity.
• Hyperion Web-analysis 11.1.1 for Adhoc reporting on ASO cube.
• Involved in data-access security and user management using filters and Shared Services.
• Process automation and ASO outline build using MaxL Scripts.
• Maintenance of Batch scripts and scheduling through Control - M.

Environment: Oracle Hyperion Essbase 11.1.1, Hyperion EAS 11.1.1, Hyperion EIS 11.1.1, MDM 9.3.1, Hyperion Reports 11.1.1, Hyperion Web-analysis 11.1.1,Workspace 11.1.1, Shared Serives,Excel Add-Ins, Oracle 9i, Toad, Control - M.

Sr. Hyperion Planning/Essbase Consultant

Confidential - Atlanta, GA

Responsibilities:

• Involved in gathering requirements and developing a project plan.
• Worked closely with the Oracle Financial team to extract the metadata and data from the existing Oracle GL setup.
• Used ODI IKM SQL to Hyperion (Data) module for loading data to Essbase application.
• Loaded existing Account, Company & Cost Center hierarchy, attributes and descriptions from existing Oracle Financial - GL into the Master View of Hyperion Enterprise Performance Management Architecture 9.3.1.
• Created and deployed Plan application view from EPMA to planning server.
• Designed and developed web-forms, menus, business rules and task lists.
• Developed quarterly reports on planning cubes using Hyperion Financial reporting studio 9.3.1.

Environment: Hyperion Planning 9.3.1, HFR, Oracle Financial -GL, Hyperion Analytic Services 9.3.1, EPMA, Excel Add-Ins.

Hyperion Planning Consultant

Confidential - Oklahoma City, OK

Responsibilities:

• Involved in the complete Software Development Life Cycle of the Capital Expenditure Planning application and responsible for the design and development of CAPEX planning cube.
• Developed calc scripts and business rules to calculate Depreciation, Accumulated Depreciation, Amortization, hierarchy rollup and allocation as per finance requirements.
• Created Web forms, Smart Lists and Menus to analyze Profit /Loss Impacts, Balance Sheet Impacts and Cash Flow Impacts due to the new assets additions.
• Extensively used HAL for extracting flat files from Essbase and for loading members into Planning web using Planning Adapter.
• Developed different Hyperion reports as per user requirements with substitution variables & run -time prompts.
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.

Environment: Hyperion Planning 9.3.1, CAPEX module, Hyperion Analytic Services 9.3.1,EAS,Business Rules, HAL 9.2, Excel Add-Ins.