Hyperion Devloper
Resume:
Mahidhar
Email: ****.****@*****.***
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