Hyperion Planning & Essbase consultant

Neha Gahtori

*** **** ***, *******.****@*****.***

San Jose CA – 95125 206-***-****

*/*

Summary of Experience and Qualifications

Oracle Certified Implementation Specialist with over 9 years of experience in Oracle Hyperion suite of products

Successfully completed seven end-to-end Planning, Budgeting and Forecasting implementations for Retail, Software, Manufacturing, Networking Equipment industry, and Public Sector.

Good understanding of financial process and other cross industry functional areas.

Experience in the business requirement gathering, data analysis, business processes refinement, framework designing, development team management and user acceptance testing & training sessions.

Comprehensive knowledge on CalcManager Rules, Load Rules, Maxl Scripts, MDX queries, batch scripts automation, Excel Macros and Linux commands

Work analytically, methodically and collaboratively when approaching problems.

Extensive knowledge of client/server configuration, systems integration, security management.

Strong emphasis on client relations with the ability to manage and built business relations.

Received several appreciations from leadership and awards for outstanding performance on all projects. Experience details

Deloitte Consulting LLP (Oct 2013 – present) as Senior Consultant

Deloitte Consulting India (Nov 2011 – Jan 2013) as Hyperion Consultant

Oracle (Mar 2010 – Nov 2011) as Oracle OnDemand Administrator

Zensar (Jun 2007 – Mar 2010) as Software Developer (Hyperion) Certifications

Oracle Essbase 11 Certified Implementation Specialist

Oracle Hyperion Planning 11 Certified Implementation Specialist Core Competencies

Oracle Products

Hyperion v9.x and v11.x, Essbase, Planning, PSB module, Capex, Workforce, EPMA, Smart View, Financial Reporting, Shared Services. Knowledge of HPCM, FDMEE, HFM, OBIEE

& ePBCS

Databases Oracle 11G, MS SQL SERVER, MySQL

Programming Skills CalcManager Rules, Calculation Scripts, Maxl Scripts, MDX Queries, Batch Scripts Languages SQL, Core Java, Servlets, Java Server Pages, C++, C, Visual Basic Software Tools MS Office, DRM, ODI

Work Experience

Senior Consultant, Deloitte Consulting, San Jose (Oct 2013 – Present) Planning and Reporting – Software Company

Implemented the driver based Planning (budgeting and forecasting) and Management reporting solution in multiple phases.

Solution included Workforce, Capex, Opex Planning and ASO reporting modules along with metadata management in DRM.

Lead the full delivery cycle for the CapEx work stream which encompassed overseeing requirements, design, development, build, test, and deployment.

Conducted the prototype sessions and user workshops with the client leadership for on-track and optimal solution. Neha Gahtori

764 Pine Ave, *******.****@*****.***

San Jose CA – 95125 206-***-****

2/2

Wrote various complex calculation scripts, data movement and automation scripts with focus on code reusability.

Managed the DRM implementation and incorporated all the changes as the project progressed.

Worked on an onsite-offshore delivery model and ensured smooth work allocation.

Prepared the cutover plans for the admins for production deployment during Go-Live and monthly releases.

Provided the post Go-Live support and conducted trainings for the end-users and Finance team.

Performing timely and accurate ad-hoc financial analyses as necessary to support business needs.

Responsible for documentation on Design, Administrative tasks, test cases, migration steps and training material. Planning and Budgeting – Manufacturing

Rationalized the number of applications and reduce the need for multi-application data interchanges.

Standardized and streamline master data throughout the EPM environment.

Supervised the development of the applications & evaluating the design improvement options.

Worked closely with the Finance team and the end users to collect requirements on data sources, current applications, business processes and reporting requirements.

Lead the Gross Margin work stream & support workforce application development.

Integrated the Gross Margin/workforce/existing Capex to the PnL and BalanceSheet cubes.

Prepared test cases and successfully conducted user acceptance testing with Division and Corporate users.

Worked on enhancements/break fixes involved in the existing Hyperion applications. Public Sector Planning and Budgeting – U.S. state in south central region

Implemented the Public Sector Planning and Budgeting solution for a State in the US which involves Human Capital Planning, project based Revenue and Expense planning and Budget Book generation using Financial Reporting.

Responsible for the configuring of HCP module, Map reporting applications, development of ASO cube.

Developing the Decision Packages, Budget Requests and tasklists as per client requirements and document the processes.

Studying the PeopleSoft tables and coordinating with the Integration team to import all the PeopleSoft data into the Hyperion application.

Configuring security and planning unit hierarchies as per the State’s model. Other Projects - Product Manager (Internal Site)

Lead 5 major releases of a Sharepoint content driven site as a product manager

Gather high level enhancement requirements from Leadership, break and prioritize the release features

Coordinate with the dev team during development and test the site before Prod release

Prepare Quarterly reports in QlikSense on site usage analytics

Automate other content related activities using Excel Macros & curl command Consultant, Deloitte Consulting, Bangalore, India (Nov 2011 – Jan 2013)

Implemented solution in Oracle EPM 11.1.2.1 for a leading multinational technology company - manufacturer of system networking equipment.

Managed the offshore project team working on the three threads - HFM, DRM and Planning.

Documented the requirements and contributed in design of the Hyperion Planning applications.

Developed Planning Applications and its artifacts for Revenue, COGS, Services Gross Margin and P&L.

Created CalcManager Rules including complex allocations, member formulae in MDX, maxls and automate the process using batch scripts in Linux and Windows server.

Worked on DRM to generate metadata files for all the applications including Planning, ASO and HFM.

Created Financial Reporting and SmartView Reports.

Responsible for conducting monthly knowledge share sessions for Hyperion practice and managing the knowledge repository.

Developed training material on Hyperion Planning and participated in Essbase boot-camp training for campus recruits. Neha Gahtori

764 Pine Ave, *******.****@*****.***

San Jose CA – 95125 206-***-****

3/2

Hyperion Administrator, Oracle Corporation, Bangalore, India (Mar 2010 – Nov 2011)

Managed the Oracle OnDemand customers’ Hyperion instances.

Executed administrative tasks requested by customers including patch installations and upgrades.

Migrated Hyperion implementations (all the versions) from one instance to another using LCM & other methods.

Worked on EPMA, HPCM & Planning applications.

Worked closely with Oracle development team to understand the new features & enhancements of 11.1.2.x

Efficiently handled customer escalations especially during Go-Live.

Prepared action plans for the “Requests for Change” (RFC) and executed them flawlessly.

Trained new team members on Hyperion Architecture & provide them on-job trainings. Software Engineer, Zensar Technologies, Pune, India (June 2007 – March 2010)

Successfully completed two end-to-end Hyperion Planning & Budgeting implementations for Retail and Information Technology domain.

Worked with functional analysts to understand the business requirements & design the outlines.

Performed the feasibility study of calculation logics (present in excel workbooks)

Documented Input-Calculation-Output logic in excel spreadsheet during design phase.

Developed EPMA Planning & Essbase applications, web-forms, Task lists, Custom menus and Workflow.

Wrote efficient calculation scripts/business rules including allocations and performance tuned them.

Developed load rules to load data files generated from client’s ERP system.

Created WebAnalysis Reports, Financial Reports and Workspace Personal Pages.

Implemented security in Shared Services as per business model. Key Achievements

Received “Recognition for Technology (R4T) Award FY17” for Exemplary Teamwork at Consulting level - Deloitte

Received six applause awards for outstanding performance on various projects and initiatives - Deloitte

Received appreciation from Deloitte - US Information Management Practice Leader on PSPB project - Deloitte

Received Outstanding Performance Award FY13 for a client engagement - Deloitte

Received Oracle Customer Services Pacesetter Award Q1 FY12 - Oracle Corporation

Received Oracle Customer Services Pacesetter Award Q2 FY11 - Oracle Corporation

Awarded “SPOT” award and “Young Star 2008 Award” for extraordinary performance in Business Intelligence practice - Zensar Technologies

Academic Profile

Bachelor of Engineering in Computer Science & Engineering, 71.47%, First Class, June 2007 Medicaps Institute of Technology and Management, Indore, India.

Contact this candidate