Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Suganya Ram Prakash

Bentonville,AR

Summary

Hyperion Consultant and Oracle SQL Developer with extensive experience in full life cycle Hyperion Planning implementation and Oracle database management. Successfully improved financial planning productivity and end-user experience through advanced calculation scripts and comprehensive training. Expertise in data manipulation, performance tuning, and developing robust security protocols, bringing strong problem-solving and team collaboration skills.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Hyperion Consultant

Igate Global Solutions
02.2013 - 02.2015


  • As a technical/functional consultant worked on complete life cycle of the Hyperion Planning Implementation.
  • Implemented Hyperion Planning Classic applications from the scratch to the Go Live.
  • Boosted productivity in financial planning activities with well-designed calculation scripts for efficient data manipulation in Hyperion applications.
  • Improved end-user experience, delivering comprehensive training sessions on Hyperion tools and functionalities.
  • Strengthened internal controls over financial reporting, developing robust security protocols within the Hyperion environment.
  • Involved in gathering requirements from business users and developing a project plan.
  • Worked on detail level of requirements and worked with functional team experts to create the functional design documents.
  • Development of reports for sales forecasting trend, variance and other analysis.
  • Development of calc scripts for final administration tasks such as Full aggregations, full currency conversion, and data copy from one scenario to another.
  • Document the processes of loading data and metadata.
  • Development of SmartView templates and reports.
  • Performance tuning of Essbase Calculations and reports.
  • Trained users with usage of Planning web forms, Ad Hoc grids and running business rules.

Oracle SQL Developer

Sutherland Global Solutions
07.2012 - 01.2013
  • Design, Development, Maintenance and support of Customer support application.
  • Develop and maintain Oracle DB jobs running in LINUX systems which are scheduled through Tivoli Workload scheduler.
  • Bug fixes from customer feedback tickets and deploying them to production.
  • Enhancements of existing flows in Oracle PLSQL.
  • Performed performance tuning on existing views in Oracle SQL.
  • Co-ordinate with scheduling team to schedule unix jobs.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.

Education

Bachelor of Technology - Information Technology

Anand Institute of Higher Technology
Chennai
05.2012

Skills

  • EPBCS/PBCS
  • Business Rules and CALC scripts
  • Essbase
  • SQL, PL/SQL
  • Java
  • Unix
  • Budgeting and Forecasting Knowledge
  • Problem-Solving
  • Team Collaboration

Certification

Oracle PLSQL developer certified Associate


Timeline

Hyperion Consultant

Igate Global Solutions
02.2013 - 02.2015

Oracle SQL Developer

Sutherland Global Solutions
07.2012 - 01.2013

Bachelor of Technology - Information Technology

Anand Institute of Higher Technology
Suganya Ram Prakash