Developer Planning

H P

SUMMARY

*+ years of total experience and 5 years of experience in working with Hyperion EPM Suite.

•

• Good understanding of multidimensional and relational database architecture; Extensive

knowledge of planning, budgeting, and forecasting procedures.

• Experience in creating, maintaining, and supporting all application objects including outlines,

calculation scripts, rules files for dimension builds, data loads and security objects through both

Essbase Administration Services (EAS) and MaxL scripts; also involved in automation of these

procedures using batch scripts.

• Maintained ASO/BSO cubes in Essbase.

• Experience in full lifecycle implementations of Hyperion Planning EPMA applications.

• Experience in performance monitoring, tuning and optimization.

• Developed and created Web forms for users to input the data into ESSBASE cube through

Hyperion EPMA Planning application.

• Developed Hyperion Planning EPMA application for budgeting and forecasting requirements.

Worked with business analysts for requirement gathering and creation of design documentation.

• Created and managed data forms, involved in implementation of decided budgeting process

involving planning units, starting review process, and entity hierarchy and workflow notifications.

• Assigning security to Groups and users, modifying the Essbase Filters based on the Essbase &

Planning application business requirements.

• Created Reports using Financial Reporting studio based on business requirements.

• Experience in Excel Add-in, Smart view and reports development.

• Excellent technical, oral, communicational and analytical skills. Admirable interpersonal abilities

and an efficient team player with proven experience of managing geographically distributed teams.

PROFESSIONAL EXPERIENCE:

SunTrust Bank, Atlanta, GA Jan‘13 – 30th Nov‘13

Hyperion Developer

• Played dual role of Hyperion developer and analyst.

• Understanding the business requirement, functional specifications and analyzing the existing

Cognos TM1 reports and preparing technical documentation for the developers. Involved in

development of project plan

• Managed onsite-offshore team on clients request involved in task division while keeping the

responsibilities for development.

• Provided production support for Essbase and EPMA planning application, performed periodic

tasks for system maintenance such as substitution variable updates, setting of scenarios etc.

• Implemented new enhancements for the existing planning EPMA applications and Essbase and

working closely with business users.

• Create/modify/execute and maintain CALC Scripts, Outline modifications, member formulas,

variables, Aliases, dimension, build rules, load rules, UDA’s and MAXL

• Involved in migration of Essbase objects and data on need basis

• Responsible for Creating and maintaining alternative hierarchy structures in ASO cubes in

Essbase

• Designed load rule for loading data and Metadata into the Essbase cube.

• Performed Variance analysis using smart view reports.

• Report development – in Hyperion financial reporting studio and SmartView.

• Doing the first hand QA of reports before sending it to the program manager.

• Involved in creation of books and batches for report distribution purposes.

• Analyzing defects and correcting them. Creation of test plan, scenarios and scripts for validation

of formulas in Essbase by creating SmartView queries.

• Maintained the report folders in different environments in workspace. Involved in Migration of

reports from Dev to QA environment on daily basis and taking backups.

• Recommended process improvements; provides functional advice to peers.

• Participated along with other senior analysts and managers in advanced problem solving and

complex analysis. Strong interpersonal skills to effectively work with other departments.

• Used ALM (Application Lifecycle Management) for FIT and SIT.

• Types of reports created - Flash reports, Weekly Balance Sheet reports, Ad hoc requests.

• Other ad-hoc reporting tasks and special projects. Led meetings and maintained trackers for

project progress.

Environment: Hyperion Essbase 11.1.2.1, Planning 11.1.2.1, Hyperion Financial reporting Studio System

11,EAS, Windows 2003, Shared services, Sharepoint.

Levi Strauss & Co., San Francisco, CA Jun‘11 – Dec’12

Hyperion Developer/Administrator

Responsibilities:

Involved in developing the Hyperion planning dimensions by using the functional specifications

•

document for the forecasting applications.

Involved in improving Web based budgeting and planning system enhancing collaborative, event

•

based operational planning processes for capital expense planning and forecasting.

Hyperion Planning was used in testing of the new calculation scripts and to define business rules

•

to match the needs of the users.

Created and maintained Essbase databases using Planning application to meet financial

•

reporting and consolidation requirements.

Involved in Migration of the EPMA Planning Application from Development to Production.

•

Designed the workflow in Hyperion Planning.

•

Created multiple reports in financial reporting.

•

Created web forms as per the users need to facilitate Data entry for EPMA Planning application

•

Process.

Performed ad hoc analysis and reporting using Hyperion Smart view in Essbase and Planning.

•

Gathered information from the users and analyzed business requirements to design the database

•

architecture such as hierarchies in the outline and the reporting needs based on scenarios.

Built a new BSO cube by transforming all the information gathered into Essbase structure.

•

Designed load rule for loading data and Meta data into the cube.

•

Created MAXL scripts to import data and to run calculations during the automated process.

•

Designed security features to provide access to users worldwide using shared services such as

•

creating filters, creating groups based on entities.

Provided administrative support to all the Essbase users for multiple Essbase applications.

•

Troubleshoot all the minor and fatal errors and coordinated with Oracle support analysts to

•

resolve the unexpected system failures.

Took part in the enhancements and maintenance program for different Essbase cubes.

•

Created the user and admin guide documents on the project completion and organized

•

knowledge transfer sessions with both the Hyperion team and the end users.

Provided production support and performed periodic tasks for system maintenance such as

•

substitution variable updates, setting of planning scenarios.

Environment: Hyperion Essbase 11.1.1.3, Planning 11.1.1.3,Excel Add In, Hyperion Financial reporting

Studio System 11,EAS 11.1.1.3, Windows 2003, Shared services.

Prism Informatics, Hyderabad Dec’07 Dec’10

EPM Developer/Planning Consultant

Client Name: PAR Pharmaceuticals Sep’09 Dec’10

Responsibilities:

Involved with Hyperion Planning budgeting application to add dimensions, assign member

•

properties, variance reporting procedures, time balancing, currency dimension properties, overall

metadata building and refreshing the data.

Designed and developed the plan to implement disaster recovery and high availability

•

environment. Discussed all possible options with the client.

Developed batch scripts, MAXL scripts for the disaster recovery servers.

•

Created documentations after project wrap up and go live.

•

Contacted Oracle for product support and submitted system requests for different issues raised

•

during the implementation of disaster recovery environment.

Performed unit testing for each script and each application. Participated in mock testing by senior

•

administration to implement changes in the production environment.

Created reports for various Budgeting and Planning groups, which consist of forecasting monthly

•

quarterly expenditures, expense management and control and comparing actual vs. budgeted

revenue and expenditures.

Presented detailed analytical reports to higher management using Hyperion Financial Reporting

•

Created Budget and Financial reports using Financial reporting studio.

•

Environment: Hyperion Essbase 9.3.1.0, Excel Spreadsheet Add In, EAS 9.3.1.0, SQL Server 2005,

Windows 2003

Client Name: Comcast Nov’08 Aug’09

Responsibilities:

Involved in design, development, and implementation of Essbase and Planning (workforce)

•

applications.

Reviewed the requirement documents provided by the client to understand the nature of the business

•

and its key functionalities and then prepared requirement matrices document based on them.

Prepared and documented the budget configuration templates for Revenue, Expenses, and

•

Headcount/Salary accounts.

Drafted key functionalities of Planning and Essbase applications. Formalized and drafted key

•

elements of budget cycle and initiated preparing and documenting a design document.

Responsible for building application metadata. Used EPMA to build an interface that managed

•

application metadata used for deploying all applications. Build profiles using Flat files (ADS) to import

metadata into EPMA.

Designated resource for troubleshooting EPMA related issues. Held sessions with Oracle support to

•

overcome issues and bugs while implementing EPMA enabled applications. Addressed any

infrastructure related issues with EPMA.

End to end implementation of Planning and Essbase applications.

•

Conducted performance testing and assisted in UAT testing.

•

Environment: Complete Oracle’s Hyperion System 9.3 product suite.

Client Name: PepsiCo Dec’07 Oct’08

Responsibilities:

Transformed business models and diagrams into an operational multidimensional outline using

•

Hyperion System.

Created a metadata which is suitable for the source system account format in Hyperion Planning &

•

Budget such as for Account, Scenario, Year and Entity Dimensions.

Involved in developing new Planning Application from scratch as per business requirement.

•

Developed and maintenance of planning application for Corporate Services group using Hyperion

•

Planning and Essbase.

Workspace was used to register the application, creating the Web data forms/data grids, Workflow,

•

Task lists.

Shared services was used to maintain the user provisions and level of access (interactive user,

•

Planner, Viewer, offline user), and creating the projects.

Created the Data forms (Web forms) for the data representation for the end users.

•

Maintained reports for Income Statements, Balance Sheets, Key Metrics, Operating and Admin

•

Expenses, Consolidation, Corporate P&L, Functional P&L, Revenue.

Created users and user groups in the Planning applications and assigned security to web forms.

•

Designed reports using financial reporting tools.

•

Used EAS for the administration of Essbase Servers such as refreshing applications, restarting

•

servers, creation of users, and creation of groups.

Environment: Hyperion Planning 9.3.1, Hyperion Workspace, Shared services 9, Hyperion Essbase

9.3, HFM, EAS, Oracle, Calc Scripts, Maxl, Smartview.

Connex Technology Solutions Pvt Ltd, Hyderabad Jul’06 Nov’07

Junior Accountant

Responsibilities:

Updated and maintained financial records.

•

Involved in audits, Monthly Bank Reconciliations and month End Closing activities.

•

Prepared accounting statements and reports.

•

Compiled and maintained accurate business transaction records.

•

Processed invoices, budget documents and routine financial documents.

•

Used Microsoft excel and QuickBooks for accounting operations.

•

Education:

Bachelor of English honors, Delhi University, India 2006

References Available Upon Request

Contact this candidate