Devi Kavya Saravanan Email & Phone Number

El Segundo, California, United States

Los Angeles, California, United States

Hyperion Administrator (Support & Developer)- Automated integration of metadata and actual data from source systems (SAP or Peoplesoft) to Hyperion applications, submission of forecast data between Hyperion applications with different dimensionalities.- Assisted and trained new Business users to perform planning, budgeting and consolidate data from different business units.- Upgraded Hyperion systems from EPM 11.1.2.3 to 11.1.2.4 and EPM 11.1.2.4 to 11.2.9.- Performed Fiscal Year (Oct to Sep) to Calendar Year (Jan to Dec) conversion for Hyperion Planning and Reporting applications including Historical data conversion.- Automated FX impact analysis using calculation scripts for multiple company codes.- Built Overhead Comparatives report (prebuilt formatted excel templates) for current estimate/budget for different divisions.- Developed automated YTD monthly variance reports using Financial Reports which gets executed for each division and sent as an email to respective division head (SVP/EVP).- Retrofit PeopleSoft interfaces to align SuccessFactors extracts for Position Management, Earnings and Billed Fringe Process in Hyperion - o Generate automated comparison report (macro) between latest estimate from Hyperion Employee database Vs changes from SuccessFactors file every week.o New employees and positions will be added automatically based on Business User approvalo Based on action codes and scenario selection, load sheet will be generated and sent to Business Users.

Los Angeles, California, United States

Hyperion Administrator (Support & Development)- System opening of Hyperion applications for estimate cycles, perform actualization & flip process and monthly submission to Management applications.- Built new business rules to calculate the salary and fringe flows, derive headcount based on payroll calendar, calculate merit, equity, and promotion flow for all the employees.- Design and implementation of new Confidential Payroll cube (Essbase).- Modified the business process from quarterly to weekly updates from PeopleSoft. - Redesigned employee cube based on Position dimension.- Gathered requirements from the business users for all enhancements, developed the changes including detailed testing, coordinated UAT with users, performed production migration and post validations (SDLC Process).- Allocated enhancements to offshore resources, reviewed and peer tested their work before moving it for UAT. - Resolved issues cropped up on the Servers and Services hosting EPM suite of products.

Los Angeles, California, United States

Hyperion Administrator- Support and Maintenance of divisional applications - Overhead, Employee, Capital and Studio applications.- System opening of Hyperion applications for estimate cycles either quarterly or monthly.- Actualization & flip process for quarterly submission to parent entity.- Assist users to perform planning, budgeting, consolidate data from different business units.- Using automated process, extracted data from different applications and load into Summary cubes.- Training to Business users in Hyperion Smart View.- Assigning Security to users on Essbase and limiting access using filters.

Chennai, Tamil Nadu, India

Hyperion Support & Developer - Monitored production jobs and supports if any job fails (Network issues, actuals feed delay, servers down) took necessary action and ensured applications are available for users on-time.- Validated the data reconciliations for all the applications and there’s no variance. - Performed the service checks after planned or routine downtime. - Hold/Release Hyperion jobs from Maestro(third party job scheduler).- Received enhancements requests from Onsite team for dimension build, automation of actuals data load from different sources, create webforms, task lists, calculation scripts. etc.- Developed and performed the unit testing and integration testing (SDLC process).

Los Angeles, California, United States

Hyperion Consultant - Involved as a part of Requirement gathering of actual load process.- Created SQL stored procedure and designed interfaces to load Metadata/Actual data to Planning application from SQL staging.- Designed business rules for true up actuals based on the Ultimates entered by users. - Creation of new simple and composite web forms to update the planning drivers and view the results at the top level.

Chennai, Tamil Nadu, India

Hyperion Support & Developer - System opening for a Forecast/Budget Cycle and support users for updating web forms, data. - Created report scripts to extract data from different applications and loaded it into a summary revenue cube.- Assist users to create smart view templates, and to perform planning, budgeting and consolidate data from different business units.

Santa Clara, California, United States

Hyperion Consultant - Upgraded Hyperion Planning applications from 9.3.1 to 9.3.3 and then upgraded to 11.1.1.3. - Installed and configured Hyperion 11.1.2.1 products (Foundation, Essbase, Planning, ODI) independently in an instance across distributed environment.- Created ODI interfaces, packages for actual data load from Oracle ERP.

Chennai, Tamil Nadu, India

Hyperion Developer - Automated dimensional build & data load by developing Shell scripts to invoke the Load Rules.- Transfer of data from BSO cube to ASO by using report scripts and sliced load.- Created Individual Perl scripts to call MaxL commands.- Currency conversion scripts created and executed using MaxL commands.

Chennai, Tamil Nadu, India

Hyperion Consultant Trained in Essbase 11.x, Planning 11.x, Financial Data Quality Management 11.x, Oracle Data Integrator 10g, Financial Reporting 11.x, Spreadsheet Add-In

Mysore, Karnataka, India

Java Developer