Overview
Work History
Education
Skills
Timeline
Generic

Ruby G

Tirunelveli

Overview

8
8
years of professional experience

Work History

Oracle EPM Senior Consultant

Amba Systems
05.2021 - Current
  • Experience with application implementation as design, development, and maintenance of Metadata/Dimension in Oracle EPBCS
  • Integrate the data from various sources and load it into EPBCS using Data Management components Import formats, Data load Mapping, and data Load rules
  • Worked on enhancement requests to develop Web forms to build Dashboards
  • Creation of Data Maps and transferring data between cubes, Validation rules, and Task lists
  • Setup of workflow within EPBCS application and basic security setup for the financial users
  • Migration of artifacts within EPBCS, automation of migration using EPM automate
  • Development and modification of existing Rules to aggregate, consolidate and calculate various combinations of data and other related requirements
  • EDMCS administrator for metadata maintenance for EPBCS and FCCS
  • Service Now Administrator to keep track of tickets and work on enhancements and Interact with the end users to fix the issues
  • Technical lead in analyzing the financial report requirement by interacting with Business users for design and discussions
  • Development of Hyperion Financial Reports using EPM- PBCS/FCCS/EPRCS
  • Migration of Financial reports from one environment to another
  • Optimize and troubleshoot data processes for performance and efficiency for Financial Reports
  • Developed and recreated Management reporting/narrative Reporting to combine financial statements and data in MS Word/PDF
  • Reconciliation of data with ERP for all the reports.

Oracle EPM Consultant

Birlasoft
05.2018 - 05.2021
  • Technical Expertise in all tasks related to Oracle EPM-EPBCS/ARCS/SmartView
  • Support during Financial Month end close, Forecasting/Budgeting and Planning of Volume across the products, by closely interacting with Finance Users across Asian, Middle East
  • Account reconciliation of GL with AR/AP financial modules and Production support activities for ARCS / PBCS applications
  • Development of Financial Data management components using Import formats, Data load Mapping, data Load rules for new entities as per business requirements
  • Data Management and Integration setup for ARCS application and Sourcing data using Hubble reports
  • Responsible for Backup and restore of Hyperion/PBCS application
  • Managing files/jobs/tasks using AWS server for day-to-day activities
  • Troubleshooting financial user queries using Oracle SmartView, etc
  • Modifying existing Business rules as per planning submissions
  • Reconciliation of data across SAP/BW, BODS layer, Hyperion/PBCS application etc
  • Participate and contribute in daily/monthly meetings with business users
  • Financial restatements during SCOA changes yearly, IFRS audits etc.

Oracle Reporting Analyst

JustDial
06.2016 - 04.2018
  • Maintenance and Support of Hyperion Planning/Essbase/Shared Services/EAS, Financial Reporting from the version EPM 11.1.2.3.500 Automation of Hyperion data load and dimension build in ETL-ODI, MAXL using Batch scripting
  • Installation and configuration of ODI 11g, setup of Oracle database connections, file-based sources, and Hyperion planning
  • Migration of Hyperion artifacts(forms/reports) using Hyperion LCM
  • Development of Calculations in Calc Scripts, Business rules via EAS and Calc manager
  • Worked on Jira tickets for new updates and modifications
  • Automation of Hyperion Migration scheduled in LCM using Anthill Pro
  • Hyperion application Administration through EAS and server troubleshooting
  • Hyperion dimension validation against Oracle EBS during Dimension build
  • Used Oracle SQL queries for validation of data.

Education

Bachelor's of Engineering -

Anna University
04.2014

Skills

  • Data Integration
  • Data Migration
  • Automation

Timeline

Oracle EPM Senior Consultant

Amba Systems
05.2021 - Current

Oracle EPM Consultant

Birlasoft
05.2018 - 05.2021

Oracle Reporting Analyst

JustDial
06.2016 - 04.2018

Bachelor's of Engineering -

Anna University

Similar Profiles

CREATE PROFILE
Ruby G