Rupesh Sharma Email & Phone Number

Worked in projects for clients including implementation of Oracle Planning & Budgeting Cloud, Profitability and Cost Management Cloud to enable Segment Profitability, Project Profitability. Performed in several roles including Techno-functional Consultant, Functional Solution Architect and conducted requirement analysis of processes & data flows to propose process optimization. Created proposals and handled business development for EPM for prospects on-premise & cloud applications. Supported the Sales team in need analysis & lead generation. Presenting solution and product demos to showcase Hyperion functionality to prospective clients. Finalizing functional & technical solution architecture finalization and engaged in reviewing As-is process & designing To-be solutions. Conducting CRP sessions with the end-users and getting functional sign-off.- Designing Functional and Technical solutions in Oracle product suite PCMCS and EPBCS.- Building complex Business rules scripts in EPBCS and cost allocation rules in PCMCS- Designing Dashboards and Webform in - Managing and setting up security matrix for user groups- Ensuring seamless data integration and automation using EPM automate and Data Management

Functioned as Senior Techno-functional Consultant in a Hyperion Planning Landscape Assessment and Recommendations for a Data Science Company in the UK. Handled business development for EPM for prospects on-premise & cloud applications. Interfaced with the clients, created proposals & RFP responses and supported the Sales team in pursuits.- Reviewed Hyperion application artefacts and made recommendations on Outline Dimension Order, Application Settings, Business Rules and removal of unused application components.- Suggested potential Business Rules tuning by optimizing sample set of business rules- Identified gaps in data load & metadata build methodology and recommended better use of automation processes using EPMA Batch Client and interface tables- Suggested implementation of various application features and used enhanced cloud features & flexibility

Worked in several projects, gathered & analysed requirements to design business rules for clients’ requirements and developed Web-forms to get inputs from users. Handled pre-sales & business development activities for EPM for prospects on-premise & cloud applications. Designed and delivered presentations to the clients and created proposals.✔PBCS rapid implementation focused on Revenue Projections for regional sales teams across customers, service lines and verticals✔Creation of Retail Industry-focused Budgeting and Retail Planning Solutions using Hyperion Planning / Planning and Budgeting Cloud Service (PBCS)✔Oracle PBCS Implementation focused to replace MS-Excel based solution to handle monthly forecast, annual budget and monthly budget for a leading Industrial Gas Manufacturer in the EMEA region- Designed & developed Business Rules logics for complex data calculations & system functionalities using Action Menus- Designed & developed complex Planning Web-Forms with Data Validation Rules, Menus, Smart-list, Valid Intersections, Sand-Box & Smart-Push- Ensured automation of periodic processes in PBCS using EPM Automate like Data Backups, Calculations, Cube Refresh, Data Export/Import- Designed Security setup for bulk users in PBCS Application (User-group creation, assignment, Dimension level security, user roles in PBCS Identity Manager)- Demonstrated solution modules to internal and external stakeholders- Developed Reports and Task-Lists, Smart-Lists

- Developing Meta-Model & Meta-Outlines for multidimensional OLAP data cubes; using Hyperion Essbase Integration Services & Administration Services- Developed Reports and Task-Lists, Smart-Lists- Experienced in provisioning Users & Groups access through Shared Services and their maintenance- Created functionalities like map reporting applications & on-the-fly Member-Creation- Automating the Hyperion Loads using Windows batch scripting with *.cbs files generated in EIS- Performance testing of the system & UAT support cycle1 and cylce2 of the project- Contributed to optimization of the outline which reduced the cube refresh time.- Creating Hyperion Report-scripts for any new report inclusion using Perl Scripts

Post Graduate Diploma - Pgd

Bachelor Of Engineering - Be