An accomplished Sr. Oracle EPMA HFM, Hyperion Planning and Essbase

Multidimensional database consultant (Administrator, Developer and upgrade

specialist) with demonstrated success of designing, implementing and

administrating complex business applications and solutions that improve

business functionality. Possess diversified background. Proven ability to

deal with technologies that decrease costs, increase performance and

positively impact the bottom line.

SUMMARY

. 9+ years of rich experience in IT including 8+ years experience in

evaluation, requirement gathering, design, analysis, development,

implementation, and testing of various complex applications environment

using Oracle EPMA 11.1.2.3, Dimension Library, Application Library, Data

Synchronizer, Calculation Manger, HFM, EPM Hyperion Planning, Hyperion

Essbase, FDQM, Financial Close Management (FCM), Essbase Administration

Services, Workspace, BSO/ASO cubes, Hyperion Financial Reporting, Shared

Services, LCM, Outline Load Utility, ODI, Web Analysis, Smart View for

Office, ESSCMD, MaxL, MDX, PL/SQL, VBA, Essbase Excel Add-in, HAL, Windows

and UNIX environments.

. Well acquainted with Financial terms (IS, FS, Cash Flow, Cash Flow,

Allocations, Cost Centers as well as actual, forecast and budgting cycles)

. Experienced in installation, maintenance, administration, and upgrade of

Hyperion products suite.

. Hands on experience on latest Hyperion System 11 (Oracle EPMA System 11).

. Extensive knowledge of upgrade between different versions of Hyperion

Suite.

. Extensive Knowledge with deployment using Websphere, Web logic, Tomcat,

IIS and Oracle application server.

. Experience with MSAD and SSO (Essbase security through shared services)

. Responsible for looking into the performance issues, Disc space,

optimization, Responsible for applying the needed Patches.

. Knowledge of Change management for the System/Infrastructure/Business

requirement Changes.

. Extensive experience in designing and developing OLAP cubes from a

conceptual level.

. Extensive experience in Calc scripts, MaxL, ESSCMD, Hyperion business

rules, Dimension build rules, Partitioning, Data load rules and report

scripts.

. Implemented Hyperion planning applications and customized the plan types

according to client's requirement.

. Experienced in all stages of Software Development Life Cycle (SDLC) with

comprehensive knowledge of

Business and requirements analysis, Business Process Modeling, Project

planning and creation of user cases.

. Skilled in automation, optimization and performance tuning of Essbase

application data/metadata processing, upgrading, testing and migrating of

cubes in different environments.

. Key strength in optimization and tuning of Essbase cubes across Block

Storage (BSO) and Aggregate Storage (ASO) Essbase kernels.

. ODI (Worked on Repositories, Designer, topology, Security, Operators,

Interfaces, Packages, Source Targets, KMs)

. . Capable of managing organizational data, assess and fulfill its

reporting needs, and develop powerful BI solutions that have true impact on

the performance of a company.

. Hands on experience with data integration from multiple data sources into

Hyperion Planning and Essbase

. Managing security, permissions, users and groups, controlling access to

database cells through managing filters as well as Shared Services.

Dimension level Security, Business Rules Security, filters: creating,

copying and assigning filters.

. Monitoring and support Hyperion Essbase Business Intelligence

applications and batch load processes to

ensure the highest level of system availability.

. Support user training, documentation, and rollout of new projects.

. Experience in Ticketing systems, WinSCP, Putty, SubVersions and other

client specific technologies.

. Excellent communication and interpersonal skills with ability to be a

team player and team leader.

. Handled many complex business application systems and projects by working

closely with a variety of individuals at all levels.

TECHNICAL SKILLS:

OLAP, ETL and BI Tools: Oracle EPMA (Enterprise Performance Management

Architecture), Dimension Library, Application Library, Calculation Manger,

Data Synchronizer, Business Rules, HFM, Hyperion Planning 11.x/9.x,

Hyperion Essbase 11.x/9.x/7.x/6.x, Essbase Administration Services (EAS),

Analytic provider Services (AIS /EIS), Workspace, Hyperion Financial

Reporting, Smart View for Office, MS Excel Add-In Essbase query designer,

Performance Management, HAL, Outline Load Utility, ODI, LCM, FDM.

Reporting Tools: Web Analysis, Smart View, Excel add-ins, and Hyperion

Financial Reporting (FR), Excel Reporting

MS Office Tools: MS Office Suite 2010/2007/2003/2000.

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL, VBA, Windows batch scripting, C,

C++, UNIX Shell Script, Windows Batch Scripting

Modeling Tools: Star schema, Snowflake schema, Dimension and Fact tables,

Logical and

Physical Modeling

Databases: Oracle 11i/10g/9i/8i, MS SQL Server, MS Access.

Operating Systems: Windows 2008 Enterprise Edition R2, Physical as well as

virtual machines, Windows NT/2000 /XP/Server 2003, UNIX OS

Additional skills/knowledge:

. Well acquainted with BI Tools - Business Objects and Cognos Reporting.

. Diversified industries experience including Finance, Publishing, HR,

Sales and Marketing, and Manufacturing.

. Extensive knowledge of financial systems involving critical and

confidential financial data involving Income statements, Balance

Sheets, Cash Flow, Employee information.

. Worked extensively to support actual, forecasting and budgeting

process of an organization with time sensitive financial reporting.

Strong Business analysis skills around Financial Planning and

Forecasting.

. Trained on Oracle eBusiness Suite Financial modules -

> Oracle General Ledger - GL (Certified)

> Oracle Payables - AP

> Oracle Receivables - AR

> Oracle Assets - FA

> Oracle Projects - PA

> AP AR Netting - NET

> Intercompany/Intracompany Transactions - IC

. Experienced in gathering business needs and documenting existing

business processes, and dataflow in order to identify, recommend and

document the appropriate new business and systems requirements to

address those needs. Worked closely with application developers team,

users, IS&T team, company management, software vendors, contractors

and outside business associates in multiple time zones to support the

technical system design, systems testing, integration testing, quality

assurance and user acceptance testing to implement agreed upon

solution.

PROFESSIONAL EXPERIENCE

Client: Amkor Technology

Role: Sr. Oracle EPM Hyperion Consultant

Duration: November 2013 to till date

> EPM 11.x system administrator and developer (4 Planning Applications

and Standalone ASO and BSO applications)

> Centralized administration and monitoring of daily OS jobs (UNIX)

> Performs all routine database management procedures, installation,

upgrades, patching, troubleshooting, data movement and performance

tuning, capacity planning, export / import operations, users'

management, production support and more

> Managing Metadata and dataload, synchronizing metadata and data

between different environments (Prod, QA and Dev).

> Provide consultative services to a diverse group of businesses to

optimize system utilization

> Act as business liaison for triaging and managing application issues

and enhancement requests

> Perform complex problem solving; develop creative, innovative

solutions to enhance financial reporting creation and workflow

> EPMA Hyperion Planning, Essbase, Maxl, WinSCP, Putty, UNIX scripting,

Windows Batch scripting, Shared Services, ODI, Outline Load utility,

EPM Workspace, Trouble shooting, Backup and Disaster recovery, tuning,

Enhancement (New cube development), Ticketing system, managing

interfaces between various systems (BI, SAP, SQL to Hyperion),

Business requirement gathering and providing solutions.

Client: JPMorgan Chase Bank, AZ

Role: Senior EPM Hyperion Consultant/ Administrator /Upgrade Specialist

Duration: April 2013 to October 2013

> Essbase System Upgrade from version 7.1.6 to EPMA 11.1.2.3

> Worked with Subject matter experts (SME) and business analysts to

gather the business requirements during development stages and

prepared BRD and FRD

> Involved in defining requirements, functional specifications,

designing documentations and testing for creating budgeting and

forecasting tool

> Senior Hyperion DBA (70+ Essbase DBs both ASO and BSO)

> Prepared templates for achieving quarterly forecasts, annual budget,

ad-hoc reporting and management reporting by working with the business

managers

> Designed Essbase and planning applications for all day to day

financial data analysis and for budgeting and forecasting purposes.

> Set up users and groups according to business department and assigning

security to users and groups using Shared Services.

> Wrote complex and simple business rules and calculation script to meet

all the custom calculation needs.

> Designed Outlines, report scripts, Global variables, Location aliases

for Essbase application development.

> Designed Data forms, Business rules, menus, task lists, workflow

process for planning application development.

> Designed ETL using ODI to integrate various source systems to Essbase

and planning applications.

> Automated dimension building and data loading process using maxl and

batch scripting.

> Created or modified the reports in SQR and Interactive reporting based

on the business requirement.

> Involved in Knowledge transfer and development transition to the other

team members and to production team (onshore and offshore).

> On time completion of all assigned tasks and desirables meeting the

business expectations and timelines.

> Documented complete application development and maintenance process as

per client standards.

> VBA coding, creating reports, batches, Mortgage Banking rates

management, process improvement

> Actuals data load, outline changes, new cube development, scenario

shuffle, managing partitions, outlook data load, server management,

Essbase security, cubes optimization

> Toad, PL/SQL

Client: Cymer Inc, San Diego

Role: Sr. Oracle EPM Hyperion Consultant

Duration: Mar 2011 - Mar 2013

> Supporting Financial System of client involving Net Revenue Reporting,

Gross Revenue Reporting, Cash Flow and Balance Sheet, Employee

database etc. (Actual, Forecast and Budget data)

> Upgraded the system (Hyperion Planning) from 9.2.0.3 to EPM 11.1.2.1

in a distributed environment. Worked closely with financial system

super users, infrastructure team, other IT system administrators,

software vendors and company management to upgrade the system within

strict deadline.

> Hyperion Financial Management (HFM) - Data Grids, Data Forms, ICP,

Rules, Calculations, Consolidation, Translation, Task Lists, task

flows, Workspace, Journals, Smart View, Importing Data and Metadata

from Interface Tables/ODI, Reports

> Analysis, design, integration and implementation of solutions across

multiple applications in domain, to include work processes,

modifications, interfaces, and reports.

> Worked with software vendor for upgrade issues, enhancements, fixes

and troubleshooting

> Created new calc scripts, MaxLs, Batches for new system, ODI, SQL

> New system is pretty stable and resolved every issue with upgrade,

enhanced system availability, integrity and confidentiality.

> Good experience on all versions (Hyperion Essbase and Planning),

Physical as well as virtual Environment

> Performing weekly, monthly and yearly activities such as archiving,

monthly actual load through HAL/ODI, user training, resolving issues

through Team Track (ticketing system), User Security etc.

> Developed new Cubes as per Business requirement and optimized cube

performance.

> Provided end-user system training as needed.

> Performed and reviewed recurring tasks and user support on timely

basis. Provided end user support for technical problems or application

questions

Client: Ernst & Young, NJ

Role: EPM Hyperion Consultant

Duration: Mar 2010 - Mar 2011

> Essbase reporting team leader for North and South America financial

reporting. Worked on Essbase Cubes development process in DEV, QA and

PROD.

> Daily maintenance, support and enhancement (BSO/ASO)

> Performed system audits for data integrity and security

> Coordinated with IS&T for resolution of application and infrastructure

issues for support and user requests

> Worked with projects teams to understand and clarify business

requirements and developed complex business applications.

> Involved in writing complex Essbase calculations scripts, automation

of Essbase Cubes using MaxL, ESSCMD, and MDX.

> Developed Batch Scripts and Rules files for dynamically uploading

dimensions and data to Essbase Cubes.

> Skilled in optimization and performance tuning of Planning and Essbase

application data/metadata processing, upgrading, testing and migration

of cubes in different environment.

> Responsible for security groups and access for the users in Hyperion

Reports and Hyperion System 9 Planning and Hyperion Shared Services

> Actively involved in taking daily requests (Ad-hocs) from users and

fixing them.

> Worked extensively on production support and was involved in solving

the production tickets.

> Developed functional as well as technical documentation of the

existing Essbase cubes and financial reports to transfer knowledge

for users, for administration and support.

> Worked closely with business persons, and extensively involved in

requirement gathering process.

> SQL Server 2005 (MaxL, MDX, ASO/BSO), worked on SQL stored procedures,

SQL Jobs to atomize Essbase jobs ( through MaxL scripts)

> Developed Excel VBA code using macros and formulas to model and create

financial reports to be used with Essbase.

> Used Hyperion Essbase Excel Add-In for data manipulation and report

creation

> Well versed with financial terms like General Ledger, Reporting and

Analysis, Budgeting and Forecasting. Maintained mapping tables (GL and

GCOA)

> Data refresh as per users demand, data transfer to another Essbase

Cubes/other Hyperion Systems.

Client: Citibank, NJ

Role: Hyperion Consultant and Lead

Duration:

May 2008 - Jan2010

> Extensively involved in total SDLC (Software Development Life Cycle)

of Essbase Cubes.

> Team leader, involved in hiring new people and training them on

Essbase

> Daily maintenance, support and enhancement

> Worked on currency conversion on Essbase cubes.

> Created MAXL scripts and developed batches to automate them.

> Worked extensively on Hyperion Reporting, EAS and Created numerous

users, groups and provided them different privileges.

> Developed Excel VBA code using macros and formulas to model and create

financial reports to be used with Essbase.

> Used Hyperion Essbase Excel Add-In for data manipulation and report

creation.

> Worked extensively on production support and was involved in solving

the production tickets.

> Developed functional as well as technical documentation of the

existing Essbase cubes and financial reports to transfer knowledge

for users, for administration and support.

Client: International Masters Publishers (IMP), Malmo, Sweden

Role: Hyperion Administrator/Developer

Duration: Mar 2005 - Mar 2008

Description: As a Hyperion Administrator, responsible for implementation,

migration and technical-support for maintaining Hyperion Essbase production

and Development servers for various clients. Working onsite and supporting

client through VNC, Dameware or other remote desktop tools. With the

leadership qualities and also as a versatile team player in the migration

team worked with other analysts to understand requirements, specifications,

testing strategies and also for planning the project time line for

migration.

> Worked at client Location (Malmo, Sweden) (End user support, issue

analysis and bug fixing)

> Migrated of Essbase from version 6.5.4.2 to 7.1.6.

> build rules/ load rules/calc script development, EssCmd/MaxL

Scripting, security/administration

> Provided technical Support for Oracle- Hyperion Essbase and Hyperion

Enterprise 6.0 with clients spread all over Europe, US, EMEA and APAC

as a part of Hyperion Worldwide Support.

> Supported Financial System of IMP involving Net Revenue Reporting,

Gross Revenue Reporting, Cash Flow and Balance Sheet, Liquidity

reporting etc. (Actual, Forecast and Budget data)

> Responsible for Performance Monitoring, Optimization, Backup and

Recovery of the cube.

> Troubleshooting Essbase database partitioning related issues and data-

load on portioned cubes.

> Used Shared Services to create users, groups and assigning roles

according to the requirements.

> Involved in building an outline and assigning descriptive alias name

to members.

> Provided 24/7 Essbase technical supports to all business units of

Essbase / Reports / Enterprise, offered suggestions and proposed

solutions to resolve issues and involved in recovery and back up on NT

Servers.

> Well acquainted with financial terms like General Ledger, IS, BS, CF,

Reporting and Analysis, Budgeting and Forecasting cycles.

Project: Competitive Intelligence & Market Research (CI&MR)

Company: Tata Consultancy Services, Mumbai.

Role: Hyperion User and Market Analyst

Duration: Sep 2004 - Mar 2005

Description: Financial performance analysis of the competitor IT companies

using Tools as well as Market Research using research tools like Gartner,

IDC, Forrester, Datamonitor, IDC etc.

> Researched on various competitors and developed 15+

competitor/customer/market based intelligence reports for both senior

management and sales team globally. Profiled customers across various

horizontals/verticals of the IT industry.

> Analyzed the financial performance of the competitors and made

presentations on the same. Well acquainted with research tools like

Gartner, Forrester, Factiva, IDC, Datamonitor, Bloomberg and other

free and paid news sources.

> Conducted training sessions and mentored new members of the team.

> Took initiative to market the reports to the sales and practice heads.

> Identified methods to create awareness amongst employees and

implemented the same to increase the foot print of the team.

> Involved in negotiation with the customers for requirement gathering

> Performed User Acceptance Test of the Competitive Intelligence System

EDUCATION

1] Sardar Patel College of Engineering, Mumbai - India

Bachelor of Engineering, 2001-2005

Major: Computer Science

Achievements: 1] Overall First Class, 2] Positioned amongst top 10 in

the class of Computer

Engineering 2005, 3] Selected as class

representative of 2nd year

2] Maharashtra Board - India

HSC (Grade 12), 1999- 2001

Score: 91.5%

3] Maharashtra Board - India

S.S.C (Grade 10)

Score: 92.5%[pic]

Contact this candidate