Praveen Ravulacheruvu
San Antonio,TX
Summary
Forward-thinking Oracle EPM professional bringing 11+ years of expertise in Hyperion Suite of products. Cultivates rapport with individuals to optimize project goals and output, resolve complex problems and deliver innovative improvement strategies. Proficient in EPBCS, PCMCS, HPCM, Essbase 21c, Essbase on-prem, Data Management.
Overview
13
13
years of professional experience
1
1
Certification
Work History
EPBCS/Essbase consultant
ITEK Software LLC - Fedex Express
11.2022 - Current
- Assessing the legacy systems for requirement gathering for translation into EPBCS
- Developed the EPBCS application design based on the business requirements and documenting the same
- Developed the Budget Transfer application in EPBCS by creating the required artifacts
- Developed the Data forms using the EPBCS for the users to input budget transfer data to validate the transfers
- Created validation rules on the forms to report the transfer variances
- Created the data load rules and mappings in the data management to load the metadata and data into EPBCS
- Automated the data load by creating batch scripts to load the data from CSV files
- Supported the Essbase 21C applications hosted on OAC by performing the monthly admin/maintenance tasks
- Loaded data into Essbase applications for forecast, budget, plan, and actuals scenarios
- Validated the data using SmartView for data discrepancies and reported the same to analysts
- Demonstrated the EPBCS features, capabilities, limitations to the business users
- Prepared operational and technical documentation of the applications for the team’s future reference
- Conducted knowledge transfer on EPBCS application usage to multiple op-co.’s business analysts.
- Provided ongoing support to clients post-implementation, ensuring long-term success of implemented solutions.
Hyperion Consultant
ITEK Software LLC - USAA/HCL
07.2018 - 08.2022
- Involved in technical requirements gathering and identifying dimensions for the planning and profitability applications and maintenance of the same
- Experience in designing, developing, and administering Planning, Essbase, reporting tools, web entry forms, workforce planning, assigning provisions, FDM for data loading and optimization of Hyperion Essbase for better performance
- Exported and imported P&L budget and headcount actual data from PeopleSoft into Essbase/workforce planning for forecasting, budgeting purpose using Hyperion FDM and maintained all FDM components i.e Dimensionality, data grids/forms, mapping tables, rules, reports, provisions
- Created web form and business rules as per business requirements for Cost Rate application in Planning
- Load forecasts and actuals from planning into HFM via flat files
- Developed Load rules for Dimension build and Rules File for loading the data from the PeopleSoft GL into Essbase BSO cubes
- Writing Essbase calculation scripts, Hyperion Planning Business Rules using calc manager
- Involved in backing up the Essbase application on timely basis and restored the same whenever required
- Created web forms and used SmartPush to move data from BSO to ASO reporting cube
- Developed calc scripts and ran them to calculate complex values using BSO cubes
- Create and validate results of the calculations from member formulas and business rules
- Involved in migrating the application from one environment to another environment
- Involved in backing up the Essbase application on daily basis and restored the Essbase application whenever required
- Interacted with the data staging team to get appropriate data into Essbase cubes
- Develop and Support USAA’s Enterprise Expense Management processes on Oracle Hyperion Profitability & Cost Management (HPCM) analytic application development as part of business requirements needs to support USAA’s various product level allocations and expense management regime
- Complete the administrator tasks for the Profitability and Cost Management Cloud services (PCMCS) models during the Business-critical path
- Analyzing the impact of the new models and allocation processes to other downstream business processes at USAA
- Develop complex Smart View retrieves, Ad hoc end user reports as per business requirements and automate the process by creating Essbase scripts, ODI jobs for the end users
- Monitor Essbase script logs, schedule tasks, Shared Services Console and Error Handling for the HPCM application
- Monitor the HPCM Application and Server performances during the UAT and coordinate with UAT team on progress of the test execution at a project level and component level.
HPCM Consultant
RAC Infotech Inc - Ciena Corporation
09.2015 - 06.2018
- Good Experience in working with Hyperion Profitability and Cost management applications in areas like Stages, Drivers, Assignments, Assignment Rules, Deployments of ASO and BSO, POV’s, Calculations
- Good experience in creating and managing Standard Profitability applications for Hyperion Profitability and Cost Management
- Good experience with Oracle Hyperion 11.1.2.2, 11.1.2.3 and 11.1.2.4
- Good knowledge on Standard Profitability application from model creation till calculations and reporting
- Worked with local and shared library dimensions and the required dimension hierarchies in EPMA for Standard Profitability model, for 11.1.2.4.x Loaded hierarchies of the required dimensions to EPMA from flat files and Oracle tables
- Created and deployed the standard profitability applications on HPCM 11.1.2.4.x Responsible for application backups and user access security management
- Took periodical(monthly) LCM exports for archival process
- Exhaustive allocation modeling experience, working with POVs, Stages, Drivers, Assignments, Assignment rules in HPCM Applications
- Experience Loading the Assignment rules (staging tables) and the required Cost/Driver data for the stages in model through Essbase (easconsole)
- Experience deploying the Models from HPCM to Essbase
- Involved in requirement gatherings with client for the Assignment, Assignment rules, Drivers and Driver data
- Trained users and prepared training documents on HPCM
- Experience in loading the data load files through Essbase for cost and revenue allocations
- Experience in loading the metadata files of the models through SQL developer
- Worked and created smartview templates helping business user to verify various measures viz CostInput, Unassigned Cost, CostReceivedPriorStage etc.
HPCM /BI (OBIEE) Developer
Parexel International Pvt Ltd
06.2011 - 07.2014
- Strong working experience on Enterprise Performance Management Architect (EPMA)
- Created dimensions, Allocation types and Measures for HPCM applications
- Loaded the required dimensions from flat files
- Good exhaustive working experience on both local and shared libraries in EPMA
- Created Standard Profitability applications for Cost allocations
- Deployed the standard profitability applications from EPMA to HPCM
- Prepared Design Documents for HPCM applications Created Stages and assigned required dimensions for the Cost Allocations
- Troubleshooting the HPCM Applications for identifying UnassignedCost
- Experience Loading the Assignment rules (staging tables) and the required Cost/Driver data for the stages in model through Essbase (EAS Console)
- Prepared Functional MD 50 and Technical MD 70 documents for Report/RPD development
- Involved in GAP analysis in the identification of business rules, business and system process flows, requirements, and assumptions
- Analyzed, Designed, and developed OBIEE Analytics Metadata repository (RPD) that consist of Physical Layer, Business Mapping and Model Layer and the Presentation Layer using Admin Tool 11G
- Tuned SQL queries for better performance of both OBIEE and BIP reports
- Created complex data models and layouts for BI publisher reports
- Implemented Dimensional Hierarchies, Time series functions, Level based measures and other various features to meet the business requirements
- Performed migration of catalog objects from Development to UAT to Production Analytics
- Deployed RPD to Dev and Test environments using the Oracle EM
- Used to start, stop, and restart the services using both Linux and Oracle EM
- Created Multiuser Development (MUD) environment for different users
- Created Application roles using Oracle EM for both development and test environments
- Worked and resolved the access issues of the business users
- Also, cross checked the group access using Admin console for the users
- Successfully implemented the Object and Data level security in the Dev and Test environment.
Education
Master of Science - Information Systems Security
University of The Cumberlands
Williamsburg, KY04.2020
Master of Science - Computer Info Systems And Information Technology
University of Central Missouri
Williamsburg, MO08.2015
Skills
- Oracle Hyperion Tools: HPCM 11121/11124, Essbase 11121/11124, Planning 111x, 112x, PCMCS, PBCS, EPBCS, CDM
- Scripting Languages: MaxL, Calc script, Report Script, MDX, shell scripting
- Reporting Tools: Oracle SmartView 11125, OBIEE 11117/12C
- Databases: Oracle 11g, MS-Access, MS-Excel
Certification
1Z0-1080-22 – Oracle Planning 2022 Implementation Professional
Oracle Testing ID: OC3537178
Registration: 41352951
Timeline
EPBCS/Essbase consultant
ITEK Software LLC - Fedex Express
11.2022 - Current
Hyperion Consultant
ITEK Software LLC - USAA/HCL
07.2018 - 08.2022
HPCM Consultant
RAC Infotech Inc - Ciena Corporation
09.2015 - 06.2018
HPCM /BI (OBIEE) Developer
Parexel International Pvt Ltd
06.2011 - 07.2014
Master of Science - Information Systems Security
University of The Cumberlands
Master of Science - Computer Info Systems And Information Technology
University of Central Missouri
Similar Profiles
Bonifacio Jr PeñascosasBonifacio Jr Peñascosas
Clearance Agent/Declarant at FEDEX EXPRESS PHILIPPINES, LLCClearance Agent/Declarant at FEDEX EXPRESS PHILIPPINES, LLC
Rico Oscarito MedinaRico Oscarito Medina
Operations Manager at FedEx Express Pacific, LLCOperations Manager at FedEx Express Pacific, LLC
Grace MarcianoGrace Marciano
Clearance Agent at FedEx Express Philippines LLCClearance Agent at FedEx Express Philippines LLC