Chandra Namani

Email: acoy7o@r.postjobfree.com

Ph: 469-***-****

Objective

A highly skilled and growth oriented professional with excellent communication skills seeking a

challenging position which utilizes my business intelligence skills, business analysis skills, MBA

knowledge and experience as a Hyperion Consultant.

Summary of Work Experience

• Nine years of professional IT experience in OLAP, ETL, Business Analysis, Development,

Testing and Database Administration of Data Warehousing and Client/Server projects using

industry accepted methodologies and procedures.

• Strong experience in Hyperion Essbase, Hyperion Planning, Hyperion Workspace,

Hyperion Financial Reporting Studio, HPCM, SmartView, OLAP, VBA and Teradata.

• Hands-on expertise creating reports using EssBase Excel Add-In & Hyperion Financial

Reports.

• Understanding of Finance business process in a global finance environment.

• Strong experience in all phases of testing including defining user acceptance criteria, developing

plans/scripts, documenting expected results, execution of scripts, validating actual results.

• Strong database development and business intelligence modeling capabilities like expert level

Essbase calculations, MaxL script knowledge and Essbase API programming capability.

• Strong knowledge of multi, relational database design and programming (PL/SQL).

• Strong experience as Essbase Cube Analysis & Design, Essbase database Administration

and performed Upgradations, Maintenance, database backups, Performance tuning,

Optimization, Dense/Sparse settings, partitioning.

• Gain necessary input/approval of requirements and design and participates in code reviews and

may perform code review for others.

• Understand business process, how the application supports business process and applies

knowledge to best solve problems.

• Develop functional specifications and works with technical resources to complete object

development and testing.

Certification in the area of Oracle Hyperion Certified Consultant

Project Profile

Florida Blue BCBS, Jacksonville, FL Aug ’14 to Present

Sr. Hyperion EPM Consultant

Our health care system is in the midst of an historic national reform effort. Like many companies,

Florida Blue is engaged in public policy advocacy on issues that impact our business at the local, state

and federal levels. To stimulate concrete action in the market, we believe that active engagement in the

legislative process is an important part of responsible corporate citizenship and the right way to develop

effective strategies.

• Full life cycle experience in project development including Designing, Developmenting,

Testing, Implementation and user training.

• Administrator of Hyperion Essbase, Hyperion Planning, System 11 Web-based solution for

Corporate Accounting and Financial Reporting area.

• Worked with Hyperion Support on number of issue resolutions.

• Involved in Determining customer business requirements, project scope and assisting the

estimation of efforts.

• Production Support and problem solving Financial Monthly End Closing using Essbase.

• Analyzing the raw data and converting it into valuable business information by Design &

development of appropriate cubes. Created new Essbase Application/Database/Outline and

Making changes to existing Outline.

• Support Management Reporting Group with Hyperion Essbase, Hyperion Planning and

Hyperion Reports.

• Involved in defining requirements, functional specifications, designing documentations and

testing strategies.

• Leveraged EPMA dimensions including custom dimensions for the Essbase cube

implementation.

• Leveraged corrections in the metadata and mapping rules made in HP and ODI.

• Defined and setup the application security in Hyperion Planning, Hyperion Essbase and Essbase

Integration Services

• Developed outlines, Data Load rules for loading dimensions and data into Essbase cube

• Optimized outlines to have faster data loads, calculation and retrievals

• Played key role in troubleshooting data reconciliation issues, extract issues and technical issues.

• Trouble shooting any load failures, restoring a cube from backup if DB is corrupted.

• Involved extensively in creating Data Grids and Data Entry Forms using HFM web client.

• Developed Import formats, Mapping, Dimensions and POV in FDM.

• Designed and built a partitioned database as per business requirement

• Coordinate UAT and fix any bugs/issues reported by the users. Creating mock reports for user.

• Closely worked with functional and Business during the pre-implementation phase of

applications.

• Documented all the application and user issues and the corresponding resolutions in order to

facilitate easy knowledge transfer.

• Expertise skill on Oracle Financial Reporting using functions, methods and levels of usage.

• Interact with end users and gathering business requirement sessions as per required.

• Created lots of reports and book of reports and assisting business users as per requirements.

• Resolving issues of Report generation and explaining issues to users and development teams.

• Designing and developing Business Rules, Calc Scripts, Load rules batch scripting.

• Working with Capex and Workforce planning modules to integrate with Web forms and business

process flow.

• Efficiently use of ASO and BSO cubes mix architecture with various partitioning strategies.

• Strong experience in writing MDX and MaxL member formulas, Calculation and Export scripts

Environment: Hyperion Planning 11.1.2, HPCM, 11.1.2, Hyperion Essbase 11.1.2, Hyperion

Workspace, EPMA, EAS, SmartView, Hyperion Financial Reporting Studio 11.x, ODI, Oracle

11i, SQL, PL/SQL, Windows 2007.

SunTrust Bank, Atlanta, GA Sep ’13 to Jun ‘14

Sr. Hyperion Admin/Developer

Atlanta-based SunTrust enjoys leading positions in some of the most attractive markets in the United

States also serves clients in selected markets nationally. We are committed to Lighting the Way to

Financial Well-Being for our clients. It is our purpose as an organization, and we do it by putting our

clients’ interests first. We strive to understand our clients’ individual circumstances and provide

personalized advice and services that meet their unique banking, barrowing, and investing needs.

• Efficiently use of ASO and BSO cubes mix architecture with various partitioning strategies.

• Strong experience in writing MDX and MaxL member formulas, Calculation and Export scripts.

• Designing and developing Business Rules, Calc Scripts, Load rules batch scripting.

• Working with Capex and Workforce planning modules to integrate with Web forms and business

process flow.

• Provisioning Planning and Essbase security with Native and Active directory

• Extensively working with Planning, Calc Manager, EPMA, Essbase modules continuously.

• Extensively involved in performing DBA activities like performance tuning and optimizations

for data/dimension loads, database restructuring, calculations, overall Essbase performance,

Reports and taking Essbase backup.

• Modified existing outlines for addition, deletion and movement of members both through

manually and used dimension build methods.

• Developed batch scripts using for building dimensions dynamically and load data into cubes

and scheduled to run on a periodic basis.

• Involved in estimating and tuning the Essbase database performance.

• Hands on experience in backup and recovery of database.

• Perform regular as well as ad-hoc support activities including data load, migration, backup etc.

Environment: Hyperion Essbase 11.1.2.3, Hyperion planning 11.1.2.3, Hyperion Workspace,

SmartView Excel, Hyperion Financial Reporting Studio 11.x, ODI, Oracle 11i, SQL, PL/SQL, Linux,

Windows 2007/XP/Sever2008

Centers for Disease Control and Prevention (CDC), Atlanta, GA Apr ’12 to Aug’13

Sr. Hyperion Admin/Developer

CDC seeks to accomplish its mission by working with partners throughout the nation and the world to

monitor health, detect and investigate health problems. Conduct research to enhance prevention,

develop and advocate sound public health policies. Implement prevention strategies, promote healthy

behaviors, faster safe and healthful environments provide leadership and training.

Responsibilities:

• Full life cycle experience in project development including Designing, Developmenting,

Testing, Implementation and user training.

• Installation of Hyperion Planning, Hyperion Financial Reports and Workspace.

• Expertise skill on Oracle Financial Reporting using functions, methods and levels of usage.

• Interact with end users and gathering business requirement sessions as per required.

• Created lots of reports and book of reports and assisting business users as per requirements.

• Resolving issues of Report generation and explaining issues to users and development teams.

• Efficiently use of ASO and BSO cubes mix architecture with various partitioning strategies.

• Strong experience in writing MDX and MaxL member formulas, Calculation and Export scripts.

• Hands on experience in backup and recovery of database.

• Provided security for various levels of users using Hyperion Shared Services.

• Involving in Data and Meta data loads using ODI and FDM components.

• Involved in estimating and tuning the Essbase database performance.

• Expertise skills in ODI using change data captures, customized knowledge modules.

• Performed testing of reports on quarterly forecasts, annual budget and management reports.

1 Created reports for Budget Vs Actual and Budget Vs Estimates, for Monthly, Quarterly and

Yearly time periods.

1 Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports.

Environment: Hyperion Essbase 11.1.2.2, HPCM, 11.1.2.2 Hyperion planning 11.1.2.2, Hyperion

Workspace, SmartView, Hyperion Financial Reporting Studio 11.x, ODI, Oracle 11i, SQL, PL/SQL,

MS Excel spreadsheet Add-in, Linux, Windows 2007.

BNY Mellon, Pittsburgh, PA Aug ’11 to Mar 12,

Sr. Hyperion Planning Consultant

BNY Mellon is a leading investment management and investment services company, uniquely focused

to help clients manage and move their financial assets and succeed in the rapidly changing global

marketplace. Headquartered in New York, BNY Mellon has $25.9 trillion in assets under custody or

administration and $1.2 trillion under management.

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and

deploy Hyperion Planning Applications.

• As a Hyperion Administrator involved in Installation and Configuration of Hyperion products

such as Planning, Essbase and reporting tools.

• Actively participated in upgrade of Hyperion System from 9.3.1. to 11.1.1.3

• Worked on Hyperion system 11g planning to support complex financial applications for

budgeting and Forecasting.

• Created MaxL Scripts to load data from DRM to Planning and dimension building.

• Created web forms in Hyperion planning for users to input forecast, budget, actual, accounting

changes and other variance explanations data.

• Experience in subscriber forecasting for implementation of data forms.

• Developed HBR (Hyperion Business Rules) with Run-Time Prompts.

• Involved in designing reports and snapshots using Hyperion Reports/Financial Reporting.

• Used Hyperion Planning 9 to create EAS applications / security filters, modify existing and

develop new database outlines, business rules, setting up dimensions, users / user groups and

security rights.

• Developed Extensive experienced in creating various types of reports using Hyperion

Financial Reporting Studio and WebAnalysis.

• Worked with multiple Currencies and changing the currencies of a data cell.

• Worked on Hyperion system 9 BI+ to create various ASO and BSO applications for budgeting

planning and forecasting for higher management of decision support system.

• Modified existing outlines for addition, deletion and movement of members both through

manually and used dimension build methods.

• Developed batch scripts using for building dimensions dynamically and load data into cubes

and scheduled to run on a periodic basis.

• Involved in estimating and tuning the Essbase database performance.

• Hands on experience in backup and recovery of database.

• Provided security for various levels of users using Hyperion Shared Services.

Environment: Hyperion Essbase 11.1.1.3, Hyperion planning 11.1.1.3, Hyperion Workspace,

SmartView, Hyperion Financial Reporting Studio, Web analysis, ODI, Oracle 11i, SQL, PL/SQL,MS

Excel spreadsheet Add-in, Windows 2007.

Amazon, Seattle, WA Mar ‘10 to Jul ‘11,

Sr. Hyperion Planning Consultant

Budgeting and Forecasting Reporting Application

Amazon strives to be Earth's most customer-centric company where people can find and discover

virtually anything they want to buy online. By giving customers more of what they want - low prices,

vast selection, and convenience - Amazon continues to grow and evolve as a world-class e-commerce.

Responsibilities:

• Full life cycle experience in project development including designing, testing implementation

and user training.

• Extensively involved in performing DBA activities like performance tuning and optimizations

for data/dimension loads, database restructuring, calculations, overall Essbase performance,

Reports and taking Essbase backup.

• Expertise in Currency conversions and Exchange rate tables.

• Extensively participated in Chart of Accounts for making of reports.

• Working with Workspace created multiple reports as per required.

• Write, Debug and enhance various custom calculation scripts, Business Rules.

• Assist in the analysis, design and development of new reports using Hyperion Financial

Reports.

• Designed and developed web based data entry Data forms in Hyperion Planning.

• Maintained outline, metadata, maxL, MDX scripts and member formulas as business

requirement change.

• Participated in a group to work with task lists, work flows and work force planning.

• Extensively involved in Web Analysis for creation of multiple reports for Analysis.

• Schedule the Hyperion Reports using reports batch scheduler.

• Developed flow diagram using DIM link jobs for bulk metadata loading.

• Capital expense planning is a Web-based solution that enables you to manage, prioritize and

plan for capital expenses

• Automated and generated the Planning refresh using batch scheduler.

• Create and provision the users with necessary roles on application using Hyperion Shared

Services.

Environment: Hyperion Planning 9.3.1/11x, Hyperion Essbase 9.3/11x, Hyperion Workspace,

Hyperion Financial Reports, SmartView, DIM, Hyperion Shared Services 9.3/11.x, Hyperion

Business Rules, Linux, Unix(Solaris), SqlServer 2008 and Windows 2007.

Pfizer Inc., NY May ’09 to Jan ‘10.

Sr. Hyperion Planning Consultant

Pfizer is the world largest research-based biomedical and pharmaceutical company. Pfizer is dedicated

to developing new, safe medicines to prevent and treat the world's most serious diseases. Assist it

developing and maintain the Hyperion Planning application for finance department. Participated in

group to identifying, developing, reporting needs like process changes, data analysis and assist it for

further exploitation. Hyperion Planning improved reporting planning process which eliminates 1200

spreadsheets.

• Installation of Hyperion Planning, Hyperion Financial Reports and Workspace.

• Migrating Planning Applications into newer versions and newer operating systems.

• Responsible for producing the functional design documents and specification for the Planning

architecture.

• Involved in Optimization and development of previous Planning Apps.

• Created new batch jobs and scheduled these batch files for complete automation process over

the nights and weekends.

• Developed many load rules for loading specific type of data forms.

• Extensive use of Business Rules to run calculation scripts and report scripts.

• Modified and replaced existing Financial, Marketing and other reports.

• Designed and developed in Planning Units, Deployment of application, multicurrency’s and

security provisions.

• Also responsible for DBA functions such as user creation, security profiles and authorizations

• Extensively involved in designing the new structure for Metrics.

• Extensively involved in doing automation and developing Calc scripts.

• Extensively involved in performing DBA activities such as performance tuning the Calc scripts,

database tuning, and taking the backups.

• Involved in migration of Analyzer reports from one environment to another environment.

• Involved in software upgrades and migration of cubes from one environment to another

environment.

Environment: Hyperion Planning 9.3.1, Hyperion Web Analysis 9.3.1, Hyperion Financial Reports

9.3.1, Hyperion Essbase 9.3.1, VBA, Excel Add-In, Oracle 10g, Windows 2003, and UNIX

Hyatt Corporation, Chicago, IL Sep ’08 to May ‘09

Hyperion App Developer

Hyatt Corporation is one of the world’s premier hotel companies. The company’s affiliates own, operate,

manage and franchise Hyatt branded hotels and resorts under the Park Hyatt, Grand Hyatt, Hyatt

Regency, Hyatt Resorts, Hyatt Place and Hyatt Summerfield Suites brands. Hyatt launched its newest

global brand, Andaz.

Responsibilities:

1 Created Applications, Databases and outlines using Essbase Application Manager.

1 Develop load rules, calc scripts, maxL scripts, MDX formulas, reports, security and overall

maintenance of cube.

1 Developed web forms using Hyperion Planning web client for the users to input Forecast,

Budget, Actual, Accounting changes and other variance explanations data.

1 Developed Business rules and attached to the input forms to calculate data on save Option.

1 Used HAL to load data values, accounts, entities, and custom dimensions from flat file into

Planning Cube.

1 Maintain complete database security and provisions.

1 Providing technical support on Database and interface functionality

1 Uploading data to and data from Hyperion Planning.

1 Liaise with team members (analysts) to ensure functionality to system specifications.

1 Provided technical guidance concerning business implications of reporting applications.

1 Mainly worked on the Hyperion Reports. Designed and Developed 120 reports based on the

client’s needs.

2 Created reports for Budget Vs Actual and Budget Vs Estimates, for Monthly, Quarterly and

Yearly time periods.

2 Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports.

Environment: Hyperion Essbase 9, Hyperion Planning 4.0.5, HAL 3.0, Hyperion Reports 7.0.1,

Hyperion Shared Services 9, Hyperion Business Rules 9, Hyperion EssBase Excel Add-inn, VBA,

MS SQL Server.

Ernst & Young, NJ Mar ’07 to Jul ‘08

Hyperion Developer

Financial Planning System

Worked for Ernst & Young as a consultant providing technical support and enhancements for internal

planning clients using Hyperion Essbase and Planning. As a developer/administrator responsible for

design, development and maintenance of Financial Planning System. This system is mainly used

to support the process of budgeting, planning and forecasting to align strategic objectives to

organizational goals.

Responsibilities:

1 Designed, developed and involved in complete life cycle of planning process.

2 Develop load rules, calc scripts, reports, security and overall maintenance of cube.

1 Involved in Performance tuning and Performance monitoring.

1 Developed and deployed interfaces used for Planning and to generate reports using Analyzer

and Essbase API’s

1 Providing technical support on Database and interface functionality

1 Uploading data to data form in Hyperion Planning and maintained complete database security.

1 Develop front end applications (Complex planning Excel Interfaces) to support planning

process.

1 Developed the maxL scripts, MDX scripts to take backup of the database and to recover from

the failure.

1 Use business analysis skills to troubleshoot, drill down, analyze, define, debug report and

document problems, and identify and implement effective solutions.

1 Custom developed application installation and usage.

1 Liaise with team members (analysts) to ensure functionality to system specifications.

1 Modified procedures to solve complex reporting business problems and created detailed report

specifications.

1 Provided technical guidance concerning business implications of reporting applications.

Environment: Hyperion Essbase 6.5, Hyperion Planning 4.0.5, HAL 3.0, Hyperion Analyzer, Excel,

MS SQL Server, Visual Basic 6.0.

GE Commercial Finance, GECAS, Shannon, Ireland. Mar ’06 to Jan ‘07

Hyperion Essbase Developer

GE Commercial Finance is one of six major operating divisions of General Electric. Headquartered in

Norwalk, Connecticut, USA, it plays a role in over 35 countries and has assets of over $232 billion.

Formerly a part of GE Capital, it is the avenue through which GE reaches other businesses to provide

financing. It offers products such as revolving lines of credit, floorplan finance, equipment leasing of

various forms, real estate services and car fleet management. The industries served include healthcare,

manufacturing, fleet management, communications, construction, energy, aviation, infrastructure and

equipment.

Responsibilities:

2 As an Essbase Developer, responsible for Evaluation of Essbase 7.x and providing

recommendations to Management

3 Requirement gathering for various Essbase Cubes including design & development for

corporate.

4 Created Database outlines and optimized the outlines arranging the Dimensions.

5 Responsible for creation of users and groups and granting different kind of access to them.

6 Validated and updated outlines periodically and provided validation reports

7 Created Data load rules files using the Prep-Editor for loading data

8 Developed many load rules for loading specific type of data files

9 Created numerous web forms in Hyperion Planning for end users based on requirements.

Extracted/loaded financial databases.

10 Design of Models and Meta Outlines in EIS

11 Process automation using ESSCMD and MaxL Scripts

12 Performed testing of reports on quarterly forecasts, annual budget and management reporting

using Hyperion Analyzer

13 Authentication of users with corporate involving Tuning and Optimization of EssBase cubes.

Environments: Hyperion Essbase 6.x, Hyperion Reports 5.x, Hyperion Planning 3.3.1, Hyperion

Analyzer 6.x, EssBase Integration Services 6.5.1, ESSCMD, MaxL, Microsoft Excel 2000, Oracle 8i,

Windows NT.

Contact this candidate