sr Hyperion lead

Anil Kumar J

Certification:

Oracle Certified Hyperion Essbase 9.3 developer.

Professional Summary:

Around 10 years of experience in IT industry.

9+ years of professional experience in Hyperion system analytics services such as Hyperion Planning 11.x/9.x, Essbase 11.x/9.x client and server tools (Hyperion Essbase, excel add-in and smart view) Hyperion system BI+ tools Hyperion Financial Reporting (HFR) and Shared Services.

4+ years of experience into development where actively involved in requirements gathering, creating out lines, calc scripts, data forms, business rules, menus, task lists, etc.

5+ years into Production support where actively involved in providing support to the Hyperion applications, performing data loads, resolved the user issues etc.

5+ years into Administration and Infrastructure where actively involved in installation and configuration of Hyperion Products (Hyperion Essbase, Planning, Hyperion Financial Management, Data Relationship Management), User provisioning, Assigning access to users, Security updates etc.

As a Technical Lead always helped the team members and guided them to perform the assigned task on a day to day basis.

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 designing and modifying the outlines for Essbase Cubes.

Managed numerous Data entry forms, Business Rules for several applications.

Worked with Hyperion Planning in developing web-based forms for the various budgeting and forecasting purpose.

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.

Engaged in implementation of planning application, relational database & DSN, plan type, analytic database, shared services, business rules, and web data entry form design.

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, Interactive Reporting

RDBMS

Oracle 10g/9i/8x,SQLServer 2005/2000,Toad 8.0, SQL Loader,

Teradata, MS Access.

Operating Systems

Windows Server, Windows 95/98/2000/NT/XP/Vista, 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:

Hyperion Upgrade, MFS Investment Management, Boston, MA

Sr. Hyperion Admin Lead

Jun 16 – present

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

Supporting the end users on client install issues, tracking the issues with Incident management tickets.

Monitoring the current production environment servers for performance and stability.

Performed Sanity check once the applications were migrated.

Extensively involved in designing, developing and modifying outlines by grouping and positioning.

Developed rules file for building dimensions using different build methods and data loading.

Developed and ran calculation scripts to calculate complex values.

Maintained user input capabilities to the applications using Filters.

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, Windows 2012 R2, SQL Server, Smartview.

Northern Trust, Chicago, IL

Hyperion Admin

Nov 15 - Apr 16

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.

Installation of Hyperion products on new servers of 11.1.2.4

Performed Sanity check once the applications were migrated.

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.

OPS, Unisys, Blue Bell, PA

Sr. Hyperion Lead

Dec 11 - Oct 15

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.

As a Technical lead always helped the team members and guided 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.

Verified Hyperion Planning and HFM applications after cold backup on weekly basis.

Verified Hyperion Planning and HFM applications after implementation of MS Patches/ CR’s.

Verified the Citrix servers after the implementation of MS Patches.

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.

Build Hyperion DRM application per design blueprint and client specifications.

Mapping functional requirement to DRM and doing a gap Analysis.

Configured DRM to match functional requirement

Provide Technical knowledge for DRM implementation.

Experience on Development and Maintenance of Hyperion Financial Management Application.

Involved in creation of journals, Data Entry Forms, Grids, Consolidation etc., and Resolving day to day issues of HFM and Smart view.

Working experience on Hyperion Financial Management, Hyperion Financial Reporting, Smart view Office, Shared Services and Workspace.

Experience on maintenance of Hyperion Financial Management Application.

Environment: - Hyperion Essbase 11.x, Hyperion Planning 11.x, Excel add in, Sql server 2005, PeopleSoft, Oracle Data Integrator, Informatica 9.0, Financial Reporting, DRM, Smart view, Hyperion Financial Management 11.x., FDM, Interactive Reporting.

MRA, IMS Health, Danbury, CT

Hyperion Consultant.

Mar 11- Dec 11

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

Global Financial Reporting, EA, CA

Sr. Hyperion Developer

Sep 07 – Feb 11

Developed Block Storage Cubes (B.S.O) cubes using Oracle Essbase system

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.

Net Present value, Apollo Group, India

Software Engineer

Oct 06 – Aug 07

Developed outlines in “Hourglass model” design to optimize the Essbase application.

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.

Educational Qualification:

M.C.A - Kakatiya University, India – 68% - 2005

Bachelors in Computer Science - Kakatiya University, India - 2001

Certifications

Oracle Certified Professional 11g.

Oracle Certified Hyperion Essbase 9.3 developer.

Contact this candidate