Data Management
Resume:
Chandra Namani
Email: *******.***@*****.***
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