Jun 2016 – May 2020 · 3 yrs 11 mos · Raleigh-Durham, North Carolina Area

• Program Lead for Financial Consolidation & Close Management, Financial Planning, Budgeting & Forecasting, Profitability & Cost Management, Master Data Management, Business Intelligence Reporting solutions using HFM, FDMEE, Hyperion Planning, Essbase, HPCM, DRM, OBI, HFR, SmartView

Jun 2015 – May 2016 · 11 mos · Dallas/Fort Worth Area

• Project Lead for implementation of Management Reporting Solution using Oracle Hyperion Essbase, Financial Reporting and SmartView

Jul 2014 – Jun 2015 · 11 mos · San Francisco Bay Area

• Project Lead for implementation of Supply Chain Planning, Budgeting & Forecasting Solution using Oracle Hyperion Essbase and SmartView

May 2013 – Apr 2014 · 11 mos · Greater Atlanta Area

• As a Project Lead for on-shore and off-shore Hyperion Planning support and development staff in an IT outsourcing arrangement between the client and Infosys, this role involves management of steady state production support (BAU activities) and development work for change requests catering to their planning, budgeting, forecasting and management reporting requirements. This includes creation & maintenance of Financial Planning applications, managing inbound and outbound interfaces with Hyperion, creation and support of Planning Task Lists, Data Forms & Business Rules, providing production support, resolution of data related issues & ensuring data integrity between systems, and system administration. The position required basic understanding of the client's financial systems, detailed application/product knowledge, with problem resolution skills.
• Responsibilities
•  Accountable for end-to-end project delivery and governance
•  Project planning, monitoring and tracking
•  Manage project resources and budgets
•  Adhere to project quality standards
•  Mitigate project risk and ensure compliance
•  Deliver effective communications across the client base and technical community
•  Manage relationships with key project stakeholders
•  Timely project status reporting
•  Change and release management
•  Co-ordinate activities between on-site (USA) and off-shore (Pune) team
•  Effective work management and efficient resource management
•  Performance management of team
•  Conduct technical training sessions for internal audience
•  Provide guidance to new joiners
•  On-shore lead for the client to gather and understand project requirements
•  Functional and technical design documentation
• Environment : Hyperion Essbase, Hyperion Planning, Hyperion Smart View

Oct 2011 – Apr 2013 · 1 yr 6 mos · London / Manchester, United Kingdom

• As a Project Lead for on-shore and off-shore Hyperion Planning support and development staff of 8 people in an IT outsourcing arrangement between the client and Infosys, this role involves management of steady state production support (BAU) and development work for quarterly change requests catering to Retail Business Banking for their management reporting, planning, forecasting and budgeting requirements. This includes creation & maintenance of Financial Planning applications, Capex Planning applications, Workforce Planning applications, managing inbound and outbound interfaces with Hyperion, creation and support of Planning Task Lists, Data Forms & Business Rules, providing production support, resolution of data related issues & ensuring data integrity between systems, maintaining proper back-up of applications/databases and system administration. The position required basic understanding of the client's financial systems, detailed application/product knowledge, with problem resolution skills.
• Responsibilities
•  Accountable for end-to-end project delivery and governance
•  Project planning, monitoring and tracking
•  Manage project resources and budgets
•  Adhere to project quality standards
•  Mitigate project risk and ensure compliance
•  Deliver effective communications across the client base and technical community
•  Manage relationships with key project stakeholders
•  Timely project status reporting
•  Change and release management
•  Co-ordinate activities between on-site (UK) and off-shore (Pune) team
•  Effective work management and efficient resource management
•  Performance management of team
•  Conduct technical training sessions for internal audience
•  Provide guidance to new joiners
•  On-shore lead for the client to gather and understand project requirements
•  Functional and technical design documentation
• Environment : Hyperion Essbase, Hyperion Capex Planning, Hyperion Workforce Planning, Hyperion Planning, Hyperion Smart View

Apr 2011 – Sep 2011 · 5 mos · Hyderabad Area, India

• This role involved design and development of Aggregate Storage Essbase Reporting Application for the client for their management reporting requirements. This includes creation & maintenance of Essbase cubes, extraction of data from data warehouse and loading into Hyperion, resolution of data related issues & ensuring data integrity between systems, and system administration. The position required basic understanding of the client's financial systems, detailed application/product knowledge, with problem resolution skills.
• Responsibilities
•  Interact with client to gather and understand project requirements
•  Design and develop Essbase outlines
•  Design and develop dimension build load rules to create the dimensions dynamically
•  Design and develop data load rules to populate the cubes
•  Use Essbase administration activities such as creation of filters, users and groups
•  Design and develop Excel Add In reports based on client requirements
•  Create batch files using Esscmd and MAXL for automation
•  Process documentation
•  Effort estimations
•  Stake holder management

Sep 2009 – Present · 16 yrs 8 mos · Bangalore Urban, Karnataka, India

• End-to-End Implementations of Oracle EPM Cloud suite of products focusing on PBCS / EPBCS
• Oracle Planning 2020 Certified Implementation Specialist
• Extensive experience with analysis, design, development, testing, maintenance and support of Hyperion Planning, Essbase and Financial Reporting solutions
• Oracle Essbase 11 Certified Implementation Specialist
• Anchor for Business Development, Go-To Market Strategy and Pre-Sales Activities

Sep 2009 – Mar 2011 · 1 yr 6 mos · Bangalore, India

• This role involved implementation of Hyperion Capex Planning. This included configuration and customization of Hyperion Capex Planning module, extraction of data from various feeder systems and loading into Hyperion, creation of Planning Custom Dimensions and Attribute Dimensions, customization of Data Forms & Business Rules. The position required basic understanding of the client's financial systems, detailed application/product knowledge, with problem resolution skills.
• Responsibilities
•  Interact with client to gather and understand project requirements
•  Creation of custom standard dimensions as well as attribute dimensions
•  Customize data forms for the users to input forecast and budget data and assign security to web forms.
•  Customize business rules and associate them to data input forms to calculate data
•  Create users and groups for Planning applications using Shared Services
•  Design and develop data load rules to populate the cubes
•  Develop member formulae and calculation scripts to aggregate the cubes
•  Develop report scripts to extract data from Essbase cubes to a text file
•  Performance optimisation for data loading and consolidation of cubes
•  Design and develop Hyperion Reports based on client requirements
•  Process documentation
•  Mentoring of new joiners
•  Conduct technical training sessions for internal audience
•  Co-ordinate activities between on-site (US) and off-shore (Chandigarh, Hyderabad, Bangalore) teams
•  People and issue management
•  Performance management of offshore team
•  Resource forecasting and planning
•  Effort estimations
•  Project risk management
• Environment : Hyperion Essbase, Hyperion Capex Planning, Hyperion Financial Reports

Jun 2005 – Aug 2009 · 4 yrs 2 mos · London, United Kingdom and Noida, India

• Lead a team of Hyperion resources whose primary responsibility was to build and support the financial planning and analysis system which was used for management reporting, budgeting and forecasting. This includes creation & maintenance of essbase cubes, planning applications, extraction of data from various feeder systems (Oracle & Java adjustment modules) and loading into Hyperion, creation and support of planning forms & Hyperion reports, providing 24 x 7 production support, resolution of data related issues & ensuring data integrity between systems, maintaining proper back-up of applications/databases and system administration.
• Responsibilities as Project Lead :
• Interact with client to gather and understand business requirements
• Assign project tasks to team members
• Co-ordinate activities between on-site (UK) and off-shore (Noida & Pune) team
• People and issue management via bi-weekly 1 on 1 meetings
• Performance management
• Capability development
• Responsibilities as Hyperion Consultant :
• Deliver various enhancement and development projects
• Support and maintain existing cubes and applications
• Process documentation
• Knowledge transfer to new joiners
• Achievements:
• Played an integral part in the transition of the production support work from UK to India
• Played a key role in upgrade of Hyperion system from version 7 to System 9.
• Received client appreciation on various occasions.
• Environment: Hyperion Essbase, Hyperion Planning, Hyperion Reports, Oracle and Java

Aug 2001 – Sep 2009 · 8 yrs 1 mo · Noida Area, India