Senior Consultant - Hyperion

AKSHAY GUPTA

A-*** *nd Floor, M*K Aura Complex, Sector – 47, Gurgaon – 122018, India.

Mobile: +91-995-***-**** ******.******@*****.*** EDUCATION

****-**** ****** ********* ** MANAGEMENT (IIM) Calcutta, India Executive Programme for Young Professionals (EPYP), Majors Finance 2004-2008 Y.M.C.A INSTITUTE OF ENGINEERING, MDU University (Y.M.C.A.I.E) Haryana, India Bachelor of Technology in Computer Engineering

EXPERIENCE ERNST & YOUNG LLP (EY) Gurgaon, India

2012-Present Leading consulting firm in EPM Advisory services. Part of the Core team implementing Oracle EPM tools for domestic and Global clients. Senior Consultant (Oct, 2015-Present), Consultant (Jul, 2012-Sep, 2014)

Led a team of 3 for Profitability and Cost management (HPCM) implementations for banking (UK) and insurance

(US) clients. Enabled the clients to allocate 100% indirect costs.

Worked on 3-7 member teams to implement Consolidation (HFM) solutions for US, UK and India clients to improve financial close process and compliance reporting. Automated consolidation rules – intercompany, investment- equity elimination etc to reduce manual effort upto 70%.

Instrumental in developing automated email and archiving functionalities for data load in FDMEE jython scripting.

Built financial reports (HFR) for IFRS and GAAP compliance reporting and multidivisional reports for cost allocation.

Developed and presented consolidation and cost allocation proof-of-concepts which helped win engagements.

Built software Robotics (Tool: Blue Prism) demo for banking clients to automate operational processes.

Conducted training sessions on HFM and HPCM for clients and EY internal teams (15-20 participants). Technical Expertise

Hyperion Financial Management (HFM) 11.1.2.x

Hyperion Profitability and Cost Management(HPCM) 11.1.2.x

Hyperion Planning and Essbase 11x

Hyperion Financial Data Quality Management (FDMEE/FDM) 11.1.2.3

Hyperion Financial Reporting (HFR), Smart View

Rewards & Recognition

Direct recognition award from EY US for exceptional Client delivery – July 2015

Excellerator award for Oct-Dec, 2012 and 2014 at EY for superior client satisfaction.

Awarded with multiple Extra Miler, Kudos and Feather-in-Cap awards in 2013, 2014 at EY for outstanding performance in project delivery.

Exceptional performer in FY 2012-13 (attained top rating) 2011-2012 BA CONTINUUM INDIA PVT. LTD. (Nonbank Subsidiary of Bank of America) Gurgaon, India Senior Software Engineer

Designed Hyperion Essbase and Planning applications for deposits data.

Involved in optimization of the Essbase cubes for enhanced performance.

Automated existing cube loading process using perl scripting. 2010-2011 HAYS BUSINESS SOLUTIONS PVT. LTD. (HAYS Plc) Gurgaon, India Test Analyst

Involved in the performance enhancements and optimization of the existing cubes for better reporting solutions.

Handling ETL and DWH functions for the Hyperion Essbase/Mart for OBIEE Reports. 2008-2010 STERIA INDIA LTD. (Formerly Xansa)

Noida, India Assistant Test Engineer

Worked on Budgeting and forecasting cycles for Hyperion Planning.

Carried out ETL process involved in loading the Essbase cubes.

Performed Reconciliation of the budget and forecast data on database cubes in Hyperion 9x. ADDITIONAL DATA

IELTS score: Listening 9, Reading 7, Speaking 7, Writing 6.5

Visa Status: Work Permit (H1B) - Authorized to work in US for next 6 years starting from October 2015, B1/B2 Visa valid till 2023.

Contact this candidate