Mahidhar

Email: acpqua@r.postjobfree.com

Contact: 571-***-****

Professional Summary

• A team oriented and solutions focused IT professional with over 8 years of work experience in out

of which 6.9 years of experience in design, analysis, development, implementation and support of

BI solutions using Essbase, Essbase Administration Services, Essbase Integration Services,

Hyperion Financial Reporting, Smart View for Office, Hyperion Web Analysis, ESSCMD, MaxL

and Essbase Excel Add-in

• Experience in installing, maintaining and optimizing Hyperion System components

• Experience in all stages of Software Development Life Cycle including Requirements gathering,

Design, Development, Testing, Rollout, Implementation, and Training

• Designed and developed numerous OLAP cubes from a conceptual level and Multi-dimensional

databases which includes ASO & BSO in Essbase with excellent balance of dense and sparse

dimensions allocation strategy, developed various OLAP Models & Meta-Outline for loading

dimensions and data into Essbase cubes

• Managing / administration: security, permissions to users and groups, controlling access to

database cells through creating, copying and assigning filters

• Involved in Dimension build rules, Data load rules, Calculation Scripts, EssCmd, MaxL, Batch

scripts, Dimension build rules, Partitioning & report scripts

• Extensively involved in automation, backups, Performance tuning and Optimization of cubes and

calc scripts, partitioning database, upgrading, testing and migration of cubes in different

environment

• Proficient in administering and using Hyperion Shared Services (HSS), Analytic Provider Services

(APS), Work Space & Financial Reporting Studio

• Developing support, enhance budgeting and reporting templates and ad-hoc reports using Excel

Add-in, Smart view for office

• Proficient in Star and Snowflake schema modeling technique used to design data warehouse &

data mart

• Excellent troubleshooting and debugging skills

• Support user training, software documentation and technical report writing

• Excellent interpersonal, presentation and communication skills with the ability to work in a team

and a stand-alone environment

Technology

Hyperion Essbase 9.x/11.,Financial Data Management (FDM),

OLAP Tools

Financial Reporting,Excel Add-In and MaxL

Databases Essbase 9.x/11.x, Oracle 9i/11g,DB2

Web Analysis, Hyperion Financial Reporting(HFR), Interactive

Reporting Tools

Reporting, Hyperion Spreadsheet Add-in, Smart View

Languages SQL,PL/SQL

Operating Systems UNIX, WINDOWS 2003 and 2008 Servers

Experience Profile:

Cigna Global Health, Bloomfield, CT Jan 2014 – Present

Hyperion Production support executive

The Finance Roadmap initiative was developed through close collaboration among Finance,

Business and IT leadership. The Finance Roadmap program is Cigna’s desire to enable new

financial planning/forecasting capabilities and technology through the design and implementation

of streamlined FP&A processes and controls supported by a robust EPM technology platform.

This vision for the enhanced EPM platform is guided by the following principles:

• Strategic Planning process will produce financial targets that will be used as the basis for

the Annual Plan

• One common expense allocation methodology will be utilized for both actual results and

planning/forecasting

• Definitions will be consistent between Planning/Forecasting and Actual reporting

• Plans/Forecasts will be developed within the Hyperion Planning applications; off-line work

will not be uploaded to the new Hyperion Planning tools

• Projections will be completed with a time horizon of 6-8 quarters

• Planning/Forecasting Dimensions will be derived from the new Chart of Accounts

Segments

Roles & Responsibilities

• ALM Lifecycle Management delivers requirements analysis, system analysis, test

planning and functional testing, performance testing

• Building Calculation Scripts, Load rules and loading the backup data using rules and

deploying cubes

• Analysing the data variances in Daily Nightly Plan

• Involved in Product Support & Maintenance activities

• Extensively involved in designing and modifying the outlines for Essbase Cubes

• Involved in Deployment, Support for Development and Administration activities

• Responsible for knowledge sharing / transition from development team to production

support functional team

• Worked with user community to ensure usage of Hyperion tool is appropriate to meet

requirements

• Developed documentation and training strategy for end-users

• Monitoring and maintenance of Hyperion services

• Trouble shooting and resolving support requests via HPSM and Oracle SRs

• Provide necessary support during every Quarter end and Year end for planning cycle

• Involved in weekly Security update and Objects migration activity

• Hyperion security Administration using the Hyperion Shared Services

• Initial testing after building the cube and preparing the Test scenario cases

Environment: Hyperion Planning and Essbase, FDQM, BMRS, HPSM, ESP Scheduler, CA

Workbench and CA Workstation, Putty, Windows 2003 servers

Transamerica, Cedar Rapids, IA July 2012 – Dec 2013

Hyperion Essbase Administrator

Applications that are developed and maintained under corporate systems are used primarily for

financial analysis and reporting. Oracle-Hyperion Suite and Clarity Reporting suite are used in

AEGON for General Ledger reporting and other reporting purposes.

Service Level agreement (SLA) serves to formalize the arrangement between Corporate Systems

and Transamerica Group to deliver specific support and maintenance services, at specific levels

of support, and at an agreed-upon cost. The SLA will evolve over time, with additional knowledge

of the FAR-EBIS requirements, as well as the introduction of new applications and services into

the support portfolio provided to Corp-FAR Reporting Group.

Roles & Responsibilities

• Involved in Product Support & Maintenance activities

• Involved in Deployment, Support for Development and Administration activities

• Developed Calculation Scripts for existing applications

• Monthly MIS(Management Information System) reporting for management

• Worked with user community to ensure usage of Hyperion tool is appropriate to meet

requirements

• Disaster Recovery testing, SOX Assurance, Financial Year Changes in Essbase

applications

• Involved in assigning security for Hyperion Essbase application using Hyperion Shared

Services.

• Applied security on different applications by creating Filters on its dimension members .

• Developed documentation and training strategy for end-users

• Provided technical/functional support for EPM suite and IR users globally

• Monitored & maintained Hyperion services

• Trouble shooting and resolving support requests via BMC Remedy and Oracle SRs

• Technical Specification document preparation(Design document and RPMT proportion)

for every new cube build and if any change/enhancement in the existing cubes as well

• Development of calc scripts and business logic

• Performed Unit testing after building the cube and preparing the Test scenario cases

Environment: Hyperion Essbase, Hyperion Interactive Reporting studio, Unix,IBM DB2

Trilogy EPM, Global Services & Support Portal (GSSP) July 2011 – June 2012

Schaumburg, IL

Hyperion Administrator

Motorola Solutions Inc. is a global leader in providing integrated communications and embedded

electronic solutions,our company role is to provide financial planning and Reporting functions for

Corporate and the business units of Motorola-Solutions and drive down cost of transactions and

enhance information delivery. FTT is a transaction system to provide Plan, Forecast and Outlook

financial information, Corporate-wide monthly budget reports (MBR) and Financial statement

data, which feeds the corporate consolidations.

Project Trilogy is an initiative to bring Order management, Supply chain and Finance under single

umbrella. Enhancement and Maintenance of Enterprise Performance Management (EPM) suite in

Invoice to Report (I2R) part for Trilogy Project. Global Solutions & Service Portal provides

capability for the Managed Service customers of Motorola to access their services via the

Motorola Customer Portal. Service IQ project is initiated to achieve the objective of reporting a

unified view of revenue, margins and costs information across various dimensions like region,

products etc. Service IQ will support Trilogy in financial reporting.

Roles & Responsibilities

• Initial requirement study and System Analysis with the help of client IT Team

• Deployment and Support for Deployment activities

• Production Support and Maintenance Administration Activities

• Developed and manipulated Calc Scripts to improve Essbase database performance

• Monthly project reporting/metrics for management

• Responsible for knowledge sharing / transition from development team to production

support functional team

• Played an admin role by creating users using shared services and implemented security

filters at different operating levels.

• Work with user community to ensure usage of Hyperion tool is appropriate to meet

requirements.

• Disaster Recovery testing, SOX Assurance, Financial Year Changes in Essbase

applications

• Develop documentation and training strategy for end-users

• Provide technical/functional support for EPM suite and IR users globally.

• Monitoring and maintenance of Hyperion services

• Trouble shooting and resolving support requests via BMC Remedy and Oracle SRs.

• Development and maintenance of Metadata, Member lists, web forms, data grids, Scripts,

journal reports, ICP reports and Task lists

• Provide necessary support during Forecast and Planning cycle

• Developed technical documentation for different cube loading process.

• Developed and Maintained of Essbase Cubes.

• Testing and Test plan preparation

Environment: Hyperion Planning and Essbase, FDQM, HFM, FR.ODI. Interactive Reporting,

Oracle Data Integrator (ODI)

Hyperion Sprint, Connecticut Ave NW, DC Nov 2010 – June 2011

Senior Essbase Developer

Hilton Worldwide Inc. (HWI) is undertaking a transformation of its back office business processes,

functions, systems and reporting capabilities at the corporate and properties levels. The overall

objectives and benefits of the Hyperion Sprint program are set forth below

Retire the US and HUKI separate Hyperion Enterprise instances Implement Hyperion Sprint to

maximize efficiencies and realize immediate results from the Hyperion suite, including: Hyperion

Financial Management (HFM) for financial consolidations Hyperion Planning for forecasts and

annual budgeting (Hyperion Planning and Essbase).

Financial Data Management (FDM) for extraction, transformation and loading of data into

applications Hyperion Financial Reporting (FR) for standardized report repository for HFM and

Planning.

Roles & Responsibilities

• Involved in Essbase development and support

• Extensively involved in designing and modifying the outlines for Essbase Cubes.

• Interacted with customers regarding technical queries while designing the outline

• Provided necessary support during Forecast and Planning cycle

• Hyperion security Administration

• Developed calculation scripts to perform the calculation on the outline.

• Enhancement of planning applications per Business Process Owner’s request

• Developed and maintained Metadata, Member lists, web forms, data grids, Scripts,

journal reports, ICP reports and Task lists

Environment: FDQM, HFM, Hyperion Planning and Essbase, FR

TCL HFM Project Spring, Kolkata, India Oct 2008 – Sep 2010

Essbase Developer

Tata Communications Limited (TCL) is a leading global provider of a new world of

communications. With a leadership position in emerging markets, Tata Communications Limited

leverages its advanced solutions capabilities and domain expertise across its global and pan-

India network to deliver managed solutions to multi-national enterprises, service providers and

Indian consumers. Over the period, TCL has acquired other companies in different parts of the

world. So there is a need to consolidate the financial results from all these legal entities at a

higher level. To meet this requirement, TCL has embarked in to the Hyperion Financial

Management system implementation project called SPRING.

Roles & Responsibilities

• Worked as a Hyperion Essbase developer

• Involved as Technical Developer for Essbase

• Designed and Developed Essbase applications

• Developed outlines from scratch for ASO and BSO applications depending on the

business changes

• Technical Specification document preparation for Essbase

• Prepared LLD, HLD documents and User Manual

• Performed Unit testing after building the cube and prepared the Test case scenarios

Environment: FDQM, HFM, Hyperion Planning and Essbase, FR.

CBS Rollout for ALB Branches, Kolkata, India May 2007 – Sep

2008

Production support Executive

TCS BaNCS Banking solution is a fully scalable, modular core banking solution which automates

every aspect of a financial institution’s back, middle and front office operations in one fully

integrated solution. This multichannel, multilingual and multicurrency system allows 24/7 real

time, event driven transaction processing and reporting which results in substantially lower

hardware and integration costs. TCS BaNCS Banking solution offers the world’s leading banks

with the opportunity to maximize efficiency and minimize risk through its advanced business

application technology.

This product have modules like Savings / Current / CC-OD Account, Loan / Advances, Inventory

Management, Cheque / DD realization, User Maintenance etc.

Roles & Responsibilities

• Implemented and provided the operational support to different branches

• Provided training to the bank employees at training centres

• Provided support at the time of year end reconciliations

Environment: Oracle 9i/10g, PL/SQL, Forms, Reports, TOAD

Education

• Bachelor of Electronics & Computer Engineering, JNTU University, India.

Contact this candidate