SUMMARY

• 10+ years of experience in IT industry.
• Experience in Hyperion system analytics services such as Hyperion Planning 11.x/9.x, Essbase 11.x/9.x, HFM client and server tools (Hyperion Essbase, excel add - in and smart view) Hyperion system BI+ tools Hyperion Financial Reporting (HFR) and Shared Services.
• Experience into Administration and Infrastructure where actively involved in installation and configuration of Hyperion Products (Hyperion Essbase, Planning, Hyperion Financial Management, FDMEE, ODI, HFR, Data Relationship Management), User provisioning, Assigning access to users, Security updates etc.
• Experience into Development, Production support where actively involved in providing support to the Hyperion applications, performing data loads, resolved the user issues etc.
• As Technical Lead always helped team members and Confidential them to perform assigned task on a day to day basis.
• Set up locations, control tables and import formats for FDMEE.
• Configured users and access rights in FDMEE.Experience in Integrated Oracle EBS to the HFM/Planning/Essbase applications using FDMEE as the ETL tool.
• Designing and Implementing complex application to support Budget and forecast depreciation and amortization requirement.
• Provide 24/7 support to the Hypeiron applications during month end and quarter end close periods.
• Strong understanding of business requirements in the Hyperion Planning & Essbase environment, dense and sparse strategy dimension allocation, performed dynamic calculations, developed, reviewed, and optimized report queries.
• Generated monthly/quarterly financial reports using Hyperion Financial Reports and Hyperion Essbase Spreadsheet Add-in.
• Extensively involved in modifying the outlines as per the requirement.
• Managed numerous Data entry forms, Business Rules for several applications.
• Migrated the applications between the environments by using LCM.
• Strong experience in all phases of developing plans/scripts, testing including defining user acceptance criteria, documenting the excepted results, execution of scripts, validation actual scripts.
• Strong understanding in Essbase Cube Analysis, Design and Maintenance, familiar with Essbase BSO/ASO, optimizing dimension building and data loading.
• Experience in multi dimensional modeling, calc scripts, report scripts, MaxL scripts.
• Excellent team player with good interpersonal, multitasking and Communication skills along with hardworking, fast learning and prioritizing capabilities.
• Flexibility to change/leverage with any new technology.

TECHNICAL SKILLS

OLAP Tools: Hyperion System 11.x/9.x, Hyperion Essbase 11.x/9.x, Excel Add-In, Hyperion Planning 11.x/9.x, Smart view for office, Hyperion Financial Management, DRM, EPM, FDMEE

RDBMS: Oracle 10g/9i/8x, SQL Server 2005/2000, Toad 8.0, SQL Loader, MS Access.

Operating Systems: Windows Server, Windows 2012 R2, 2003, Unix

Dimensional Modeling: Star schema, Snow Flake Schema, Fact and Dimensional tables, Logical and Physical Data Modeling

ETL Tools: IBM Data stage 8.0/Ascential Data Stage 7.5x, Informatica 9.1

PROFESSIONAL EXPERIENCE

Confidential, Dodgeville, WI

Hyperion Developer/Administrator

Responsibilities:

• Developed calc scripts and business rules.
• Developed web forms including composite web forms.
• Developed Informatica Mapping, Session and Workflows to load the data to Hypeiron Planning.
• Create task lists and planning unit hierarchy for Process management.
• Actively participate in weekly status meeting during development phase and daily standup meeting during UAT phase.
• Developed BSO cubes based upon the requirement.
• Involved with business users and database team for extracting, transforming and loading the dimensions and data into planning application through the help of Informatica 8.1
• Performed Installation and configuration of Hyperion components (Essbase, Planning, HFM, FDMEE, ODI, EPMA, ESSBASE STUDIO, EAS, HFR) on Windows server 2012 R2.
• Build new Hyperion environments (DEV, TST, UAT, PROD, PSDEV, PSQA,SIT) on Windows server 2012 R2
• Migration of Artifacts between the environments performed by using Life Cycle Management.
• Applied maintenance release patches on all the environments.
• Configure Web logic servers.
• Integrated DRM with downstream systems like Essbase, EPMA.
• Designed objects in DRM as per functional team requirements.
• Defined security profiles and node access groups for DRM
• As per business requirement design DRM objects like Properties, Exports, Books, Validations, Node types, External connections, etc.
• Configure ODI for connections to ERP source via ODI console in FDMEE.
• Assign groups and roles to users to access HFM application based upon the requirement.
• Performed Sanity check on each and every component installed on server and make sure that everything is operational.
• Initialization of source EBS to target HFM via FDMEE.
• Functioning as single point of contact for client on production related support and maintenance issues.
• Involved in resolving the issues related to Infrastructure.

Environment: - Hyperion Essbase, Planning, HFM, FDMEE, DRM,ODI, HFR, Windows 2012 R2, SQL Server, Smart view, Informatica.

Confidential, Boston, MA

Sr. Hyperion Consultant

Responsibilities:

• Responsible for migration of Hyperion Essbase, Planning, Hyperion Financial Management to 11.1.2.4.
• Migrate the Hyperion applications from 11.1.2.1 to 11.1.2.4 via Life cycle management between the environments.
• Applied maintenance release Patches on the new servers of 11.1.2.4.
• Worked closely with other teams in fixing the issues.
• Installation of Hyperion products (Hyperion Essbase, planning, Hyperion Financial Management) on new servers of 11.1.2.4
• Upgrade from on premise Hyperion to Oracle cloud.
• Supporting the end users on client install issues, tracking the issues with Incident management tickets.
• Strong knowledge of working on FDMEE components like ODI, ERP Integrator.
• Integrated ERP Systems ( Oracle EBS) in order to extract and load the data in to the target HFM applications using FDMEE.
• Set up locations, category mapping, periodic mapping and import formats for FDMEE.
• Monitoring the current production environment servers for performance and stability.
• Performed Sanity check once the applications were migrated.
• Interact with the client on weekly status calls.
• Functioning as single point of contact for client on all production related support and maintenance issues.
• Prepared documents for future reference.

Environment: - Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, HFM,FDMEE, Windows 2012 R2, SQL Server, Smart view.

Confidential, Chicago, IL

Hyperion Developer/Administrator

Responsibilities:

• Migrate the Hyperion applications from 11.1.2.1 to 11.1.2.4 via Life cycle management between the environments.
• Built Hyperion Planning applications to support yearly budgeting and Forecasting process.
• Developed member formulas and Calc Scripts computing input values into actual scenario results and projecting these values using Smart view.
• Created Hyperion Financial reports using FR Studio and Smart View.
• Worked on planning applications for Revenue/Expense Budgeting and Forecasting.
• Applied maintenance release Patches on the new servers of 11.1.2.4.
• Installation of Hyperion products on new servers of 11.1.2.4
• Performed Sanity check once the applications were migrated.
• Designing and Implementing complex application to support Budget and forecast depreciation and amortization requirement.
• Created Planning web forms to capture budget/forecast from Finance users
• Interact with the client on weekly status calls.
• Loaded level 0 data and performed data testing.
• Migration of Essbase cubes, rules files, calc scripts and data synchronization rules from 11.1.2.1 to 11.1.2.4
• Prepared documents for future reference.

Environment: - Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, HFM, Winscp, UNIX, Smart view.

Confidential, Blue Bell, PA

Hyperion Lead

Responsibilities:

• Aggregated the scripts based upon the Functional team request.
• Performed Defragmentation in QA/ Production environment to improve the performance of the application.
• Loaded HFM Region Actuals to Hyperion Planning and matched data with the reconciliation sheet.
• Loaded HFM Plan rates, Actuals to Hyperion Planning on Functional team request, matched data with reconciliation sheet.
• Worked on Planning applications for revenue/expense budgeting and forecasting.
• As a Technical/Project lead always helped the team members and Confidential them to perform the assigned task on a day to day basis.
• Provided 24/7 support for the Hyperion applications during Financial close periods, Month end and Quarter end close periods
• Involved in setting the substitution variables for the applications.
• Performed Security update by Provisioning and refreshing users/groups and recreating security filters Hyperion application in QA/ Production environments upon the request.
• Performed Opening/ Closing of OTLK setup process in QA/Production on monthly basis to load the data from PeopleSoft to different versions.
• Developed Hyperion Planning models for accounting/finance department, migrated legacy budgeting/ forecasting Excel models to Hyperion Planning to achieve efficiency and cost savings
• Verified Hyperion Planning and HFM applications after cold backup on weekly basis.
• Used Remedy tool for tracking the incident tickets.
• Built COA and numerous custom properties in DRM application.
• Run ODI chain to update Hyperion DRM metadata to EPMA applications and EPMA apps deployment.
• Verified Hyperion Planning and HFM applications after implementation of MS Patches/ CR’s.
• Verified the Citrix servers after the implementation of MS Patches.
• Solid understanding of Multidimensional and Relational database architecture; Extensive knowledge of planning, budgeting, and forecasting procedures.
• Managing Hierachies, Business rules, mappings and validations using DRM.
• Used DRM to import/export process, blenders, various metadata validation process.
• Interacted with the users regarding the issues and resolved them within the SLA time frame.
• Cleared the data based upon the scenarios and versions.
• Modified/executed the Calc scripts based upon the request.
• Modified the Data forms on monthly basis in QA/Production environment.
• Oracle Data Integrator was used as an interface to load the data into Hyperion Planning.
• Informatica was used as an interface to load/create files the data from staging table to load into Hyperion Planning.
• Verified the loaded data of staging /target in SQL Server 2005.
• Experience on maintenance of Hyperion Financial Management Application.

Environment: - Hyperion Essbase 11.x, Hyperion Planning 11.x, Excel add in, BMC Remedy 9, PeopleSoft, Oracle Data Integrator, Informatica 9.0, Financial Reporting, DRM,FDMEE, Smart view, Sql server, Hyperion Financial Management 11.x., EPM.

Confidential, Danbury, CT

Hyperion Consultant

Responsibilities:

• Involved in refreshing the cubes on a daily, weekly basis.
• Refreshing, populating the data and validated the Quality Checks.
• Refreshing the reporting cubes from Production to UAT and Dev environment.
• Migrated the reports from DEV to UAT, UAT to Production environment.
• Involved in setting the substitution variables for the applications.
• Interacted with the Users, clients regarding the issues.
• Resolved the issues according to the SLA time frame.
• Involved in Smoke test, Regression test.
• Involved in loading the cube manually when the automatic cube load failed.

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Excel add in, SQL server 2005, Financial Reporting

Confidential, EA, CA

Hyperion Developer

Responsibilities:

• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developed Calc Scripts and Report Scripts.
• Created and managed numerous Data entry forms, Business Rules for several applications.
• Developed batch files using MaxL and ESSCMDs and rule files to upload data from system’s database to Essbase cube.
• Hyperion Planning was used in testing of the new calculation scripts and to define business rules to match the needs of the users.

Environment: Hyperion Essbase, Hyperion Planning, Hyperion Financial Reports, Excel Spread Sheet Add in, Smart view, Oracle 10g.

Confidential

Software Engineer

Responsibilities:

• Written Business rules as per the requirements and created substitution variables for the ease of maintenance of application.
• Developed the Calculation Scripts, MAXL Scripts for reports generation,
• Loaded security configurations manually and modified access using shared services.
• Worked on the Hyperion Smart view and Essbase Excel Add-In formatted reports and developed reports based on the business analysts needs.
• Developed the reports by entity and also by department by using financial reporting.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in and smart view.
• Managed the access permissions to all the reports from Hyperion workspace.
• Performed performance tuning by using the dense/spares settings and developed the required alternate rollups for reports.
• Wrote SQL queries, analyzing and optimizing queries.

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Financial Report 9.3 Microsoft Excel 2003, Oracle 9i.