Summary
Overview
Work History
Education
Skills
Skills
Timeline
Generic

Usha Royala

Chattanooga,Tennessee

Summary

Experienced Professional with a proven track record of Successful Development, Customization, Implementation and Support of Oracle Fusion (SAAS (Page Composer) and PAAS) and EBS applications. Being in this professional industry with 14 Years of experience which includes 4 years in Oracle Cloud, coupled with confident decision-making abilities for enabling effective solutions leading to high customer satisfaction. Recognized for strong interpersonal, project management, and programming skills, with a 'look beyond the obstacles' approach to problem solving.

Overview

17
17
years of professional experience

Work History

Oracle ERP Technical Manager

Astec
Chattanooga, Tennessee
03.2024 - Current

Sr

Fusion Finance Techno, Think Big Solutions LLC
Germantown, Maryland
12.2023 - 02.2024
  • Supporting a support project (IOT) in oracle fusion financials
  • Working on technical aspects which includes design development and testing in oracle fusion SAAS
  • Developing various oracle fusion FBDI, ADFDI and BIP reports based on the requirement
  • Working on OIC integration to automate Invoice Capture and voucher creation for Oracle Cloud Accounts Payable.

Senior Implementation

Oracle Fusion Finance Technical, Safeway/Albertsons
Houston, Texas
05.2023 - 09.2023
  • Consultant for Fusion ERP SAAS offerings for financial s
  • Major activities performed are authoring technical design, build integration's, training team
  • Worked on Oracle Fusion Cloud Data Conversion using File Based Data Imports (FBDI) and spreadsheet Uploads
  • Involved in the Quote to Cash Process(Quote to Cash) integration streamlining the Order Management fulfillment process enabling dynamic pricing and global order processing(GOP)
  • Worked on Various BIP Reports
  • Worked on Various OTBI Dashboards
  • Worked on modifying the application pages using Application Composer (App Composer)
  • Modify user interface pages by exposing your newly created fields for an object
  • Created Service connection in VBCS application which is used to call REST API
  • Built a POC to demonstrate IDR (Intelligent Document Recognition) functionality to automate AP Invoice processing.

Sr, Finance/SCM Reports Developer

Delta Dental of California Remote – HCL
, India
12.2022 - 03.2023
  • Developed Various Drill - through FRS reports and get the data with the combination of Quarterly Periods + PTD as Amount type
  • Hands on experience to move FRS Reports from source instance to Target instance
  • Scheduled FRS Reports to get attachment as Excel instead of PDF
  • Created FRS Reports to display only Accounts which have balances in Reports
  • Designed and built FBDI automation integration in OIC to automate the load of GL Journals feed from Core Banking System to ERP Cloud on a daily basis
  • Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to email
  • Ability to facilitate design discussions on Oracle Fusion ERP product lifecycle and related order orchestration processes (i.e
  • Product creation, maintenance, price books) in Product Data Hub.

Sr, OIC Technical Developer

AEGON Life Insurance Company HCL
, India
07.2021 - 12.2022
  • Oracle Fusion OTBI/BIP/FRS &, Provide day-to-day support and quality assurance for a variety of customers
  • Experience in working with end clients/customers to understand / analysis business requirements
  • Travelling with experience people for requirement gathering and super User Training's
  • Design, develop and support reports in BI Publisher and OTBI
  • Involved in creating Dashboards, Reports, Analysis, Filters and Graph reports
  • Hands on experience in using Oracle Integration Cloud - OIC Instance Setup, FTP, SOAP, REST etc
  • OIC integration's to setup inbound and outbound transactions flow using SOAP and REST API's
  • Built an integration to achieve the data sync between SAAS and On-Premises application using connectivity agents in OIC
  • Design, develop and support integration's in OIC to Oracle ERP Cloud including making REST and SOAP calls, FBDI File Uploads
  • Developed complex Procurement - AR Invoice Integration using REST API
  • Design, develop and support integration's in OIC to Oracle ERP Cloud including extracting Oracle ERP Cloud data using BI Publisher reports, analysis and OTBI Reports
  • Provide hands-on technical and development support for implemented Oracle ERP Cloud modules

Fusion Technical Consultant

Waterpik Re-Implementation HCL
, India
02.2021 - 06.2021
  • Experience in Retrofit/Conversion of Custom BI Reports for AP, AR, OM, GL and FA modules
  • Developed various Pl/SQL programs and registered them as a concurrent programs to fetch the data and write to comma separated files in the predefined server location for the extraction of files like Users/COA’s/Supplier’s/Payments’
  • Utilized FND LOAD for data migration between various instances such as Menu’s, Custom responsibilities and program’s
  • Solid working knowledge of accounting principles particularly as they relate to Account Receivables and Account Payable’s
  • Generate and send out invoices
  • Assist with Reconciliations and Month End Closing

Sr, Technical Consultant

Oracle R12 & Fusion, The Wonderful Company LLC Strattek Consulting Pvt.Ltd
, INDIA
04.2019 - 09.2019
  • Experience in Oracle Application Implementation and Production support in 11i and R12 in both Financials and SCM modules
  • Worked on EBS Alerts and Form Personalization's in R12 environment
  • Managing Tickets and resolving the issues on day to day basis and on priority
  • Worked on to develop new reports and enhance standard ERP cloud reports using reporting tools (Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI) and Business Intelligence Publisher (BIP)
  • Worked on in Data Migration using FBDI in finance modules for suppliers
  • Experienced Oracle Integration cloud environment and created many App Driven Orchestration pattern integration's using SOAP and REST API's
  • Developed custom BIP Reports in AP, AR, Purchasing, GL, FA, OM and I Expenses modules
  • Knowledge on Oracle Procurement Cloud.

Sr. Oracle Apps Consultant

Al Arrab Contracting Company Appstec ERP Solutions Pvt.Ltd
, India
08.2018 - 03.2019
  • Coordinating with Riyadh clients directly for the requirement gathering and testing the object's
  • Worked on Implementation and support project and created BIP Reports using Excel Based templates
  • Worked on Finance modules like AP, AR, PO, FA, OM, I Expense, Shipping and GL modules to develop customizations and Reports
  • Worked on Form Personalization's
  • Worked on Aging Buckets -4
  • Worked on O2C Support Project, involved in verifying the process flow till order gets invoiced
  • Hands on experience in creating RTF Templates for creation of reports in BIP
  • Introduction to Fusion Environment and learned on how to develop BIP and OTBI Reports
  • Developed various Fusion BIP Data Models and OTBI Reports using different Subject Areas
  • Working with Oracle support for Subject Area's and Tables used in developing BIP/OTBI Reports by raising Service Request's
  • Taking Care / Monitoring the Scheduled Jobs at different Time zones
  • Develop and maintain support activities Weekly Dashboard's.

Sr. Oracle Applications Consultant

Cantor Fitzgerald ESK Technologies Pvt.Ltd
, India
03.2018 - 06.2018
  • Involved in Functional Setups for Oracle Projects and Payables
  • Coordinating with onsite Manager and gathered the functional requirements for the setups
  • Configured implementation options and project related hierarchies
  • Designed and developed customizations on Oracle Projects
  • Developed Custom reports as per the business requirements
  • Worked on AP, AR and Oracle Projects Modules
  • Exposure to Cloud/ Fusion environment
  • Trained a team of size 3 on EBS technical aspects

Sr. Oracle Applications Consultant

Morning Star Accenture
, India
03.2017 - 09.2017
  • Worked on R12 financial OM,AP,AR and PO Modules
  • Support projects which involves tracking and resolving production issues
  • Worked in Implementation part as well to develop the Reports and do form personalization’s
  • Monitor team activities and train them for quick resolutions
  • Worked for another support project on Procure to Pay (P2P) flow cycle
  • Provided global support and resolved several O2C & P2P related issues
  • Performed backend testing using test scripts (PL/SQL), generating reports to ensure data integrity and to validate the updated data
  • Performed the system admin role by setting up the user privileges, assigning responsibilities, customizing the menus, adding new concurrent requests, creating Requests.

Sr. Oracle Applications Analyst

Cisco Systems, Inc
London, India
07.2016 - 01.2017
  • UKWipro Technologies (Remote, Day-to-day activities involve monitoring the cases and prioritizing the escalated cases to the team and analyzing the complex cases that require root cause
  • Major challenges include understanding the client requirements and designing a solution that fits well to the need, applying fewer loads on the server during the execution of the scheduled programs
  • Involved in meetings with direct clients to discuss the permanent solutions for the issues escalated
  • Consistently meet deadlines to compensate reps on Quarterly basis
  • Support the rules and policies defined in the yearly sales compensation plans
  • Facilitate greater understanding of the sales compensation rules to sales management so they understand how the decisions are made in certain situations
  • Audit quarterly sales compensation against predetermine thresholds to verify accuracy.

Sr. Oracle Apps Technical Lead Consultant

Berry Plastics, Wipro Technologies
Evansville, India
03.2016 - 06.2016
  • Handled a team of size 45
  • Worked as a Transition Manager and took KT from Direct Clients and Vendors and provided KT to my team
  • Developed Project Documentation and make my team to understand the project synopsis
  • Developed customizations on INV and Finance Modules
  • Prepared MD070 Technical design document and conversion mapping document CV040 to extract data from legacy systems into Oracle Applications open interface tables
  • Worked on Items, Item Categories conversions
  • Defined Item Catalog Flex fields, item Catalog Groups and assigned items to catalog groups
  • Used various Categories and Category Sets to group your items for various reports and programs.

Sr. Oracle Apps Technical Lead Consultant

Sun Power, SPWR, Wipro Technologies
Richmond, Bangalore, INDIA
04.2015 - 03.2016
  • Worked as a Individual contributor for an End to End implementation Project which involves integration from Oracle Applications to 3rd party Hyperion tool
  • Involved in meetings with direct clients to discuss on the New Integration Project from EBS to Hyperion
  • Day to Day activities included in prioritizing the development of interfaces from EBS
  • Identify applications level and module level integration touch points and business flows - applicable for both target and source -Oracle E-Business Suite
  • Identify and obtain details about the E-Business Suite integration touch points, needed for the integrated solution using the SQL Server
  • Modules involved BBB (OM),Financials (GL), Depreciation (FA), Headcount(HR)
  • Provided data from Source EBS - R12 using API's interfaces and send to SQL Server so that programs can be scheduled from SQL Server and the data can be migrated from EBS
  • Completed the integration and validated data is successfully migrated from EBS to SQL Server and from SQL Server the data is floated to Hyperion Essbase Cubes and data gets loaded using Essbase/ Hyperion Reports.

Sr. Oracle Apps Techno Functional Lead Consultant

Seagate Technology LLC, Cupertino Wipro Technologies
Bangalore, INDIA
04.2014 - 04.2015
  • Day-to-day activities involve monitoring the cases and prioritizing the escalated cases to the team and analyzing the complex cases that require root cause
  • Written Data base procedures and Packages in Conversion tool and generate CSV Files and zip the files manually and upload them to create Master and Transaction data for migration activities
  • Developed Pl/Sql dynamic queries, materialized views and extracted the data from various modules like AP, AR, PO, INV, FA, OM, Cash management, and Projects
  • Worked on Data Migration activities
  • Developed API to create Bank Account details and do CRUD Operations
  • Scripts - Pl/Sql Packages, Procedures and API's are developed to import Bank Accounts details for Suppliers.

Sr. Oracle Application Techno Functional Consultant

Cisco Systems, Inc, CA Wipro Technologies
San Jose, Bangalore, INDIA
06.2013 - 04.2014
  • Worked on various projects which includes development, Support and Implementation
  • COVC Project - Bug Monitoring - Resolves the issues that arise during Order to Cash O2C and P2P Process flows
  • Handled a team of size 23 and responsible for taking Care of Order fulfillment to order deliver process
  • Responsible for Order, Return, Inventory, Procurement and Compliance Management
  • Hands on Experience using REMEDY ticketing tool by tracking the issues so that we can easily diagnose and resolve them
  • Used R12 for booking the order and creating the customer invoices and integrating with General Ledger
  • Also involved in customization of Reports and development of Interfaces for importing the orders from Legacy Systems to Oracle and finally booking and customer invoicing
  • Worked with Thailand and Penang clients for resolution of their issues
  • Handled APAC, the Americas and EMEA Region escalated issues and within less time completed the critical issues in the EMEA region which got appreciation from clients as well
  • Supporting team members to take up the cases and help them for closure
  • Worked in 24
  • 8 Bridge and resolved typical issues during Month End and Year End closure activities
  • Got various awards for the quick closure of issues from Cisco and Clients as well.

Sr. Oracle Finance &SCM Techno Functional Consultant

Symantec
Mountain View, INDIA
02.2011 - 04.2012
  • Worked on the design and development of Interfaces, Data Conversions, BI Publisher Reports, Java Concurrent Programs, XML Reports and Pl/SQL Packages and Procedures
  • Estimated the level of effort and prepared Technical Design documents MD070 and as per the functional requirement documents MD050
  • Worked with Project Managers and other Technical Leads to accurately estimate efforts, resource requirements, risks, and constraints
  • Developed RICE components in both Finance and SCM modules
  • Work daily with development teams to carry out delivery with high quality and within given time frames
  • Extensively worked on RICE (Report, Interface, Conversion, Extensions) components
  • In both finance and SCM modules
  • Prepared Unit Test Cases to verify the code developed and deployed to the Server
  • Involved in defining Value sets, Concurrent Programs, Alerts and registering reports with Pl/Sql Procedures
  • Developed Order Entry Import interface using Oracle staging to process and complete the order
  • Developed and created programs using Public API's, concurrent programs, Reports and host script
  • Having experience to work on different methodologies like Waterfall and Agile.

Oracle Apps Associate Technical Consultant

Burley Sub Sea FZE, Tom –Lee, Emirates
Dubai
08.2008 - 01.2012

Technical Manager

iGrid Technologies Pvt.Ltd
Hyderabad, INDIA
  • In Astec, a manufacturing industry company
  • Played a crucial role in performing both onsite and offshore proof-of-concept (POC) activities
  • My responsibilities involve working and assigning the tickets to the team (10 in size, both technical and Functional) and work on bug fixes, enhancements, and developing new reports using BIP/OTBI and helping the other team in loading FBDI templates
  • Directly communicate with the business stakeholders to gather their requirements and ensure their financial significance
  • Involved in confirming whether the business requirements are financially significant or not
  • Migrate the reports by creating DEVOPS Pull Requests
  • Handle the REMEDY incident tool to maintain business tickets and create new Change Requests., Worked as an S/w Eng
  • And learned Oracle Applications EBS Suite
  • Having Good Knowledge on Finance (AP/AR/PO/GL) and SCM (OM/INV/Shipping)
  • The Project includes using OM/INV/Shipping and Finance modules and AOL using Oracle Applications 11i (11.5.8 / 11.5.10)
  • Involved as a team member that implemented the Oracle Purchasing / Receivables and Order Management modules by interacting with the client and business team for the requirement gatherings from clients
  • Involved with the study of the existing system, preparing the Functional (MD050) and Technical (MD070) design documents
  • Wrote Functional (MD050) , Technical (MD070) and Conversion Mapping documents (CV040) for importing legacy Purchase Orders into Oracle Purchasing, Legacy Payable invoices into Oracle Payable s, Items into Inventory
  • Strong Oracle RICE Development experience in OM, Inv, Shipping, AP, Purchase Order, AR, GL
  • Developed SQL
  • LOADER Control programs and Pl/Sql validation procedures to load legacy data into Oracle Applications
  • Developed various Concurrent Programs, Alerts, Value Sets, and DFF & KFF flex fields and registering them
  • Having good knowledge on TCA Architecture
  • Involved in customization of several standard reports includes Purchase Order Detail Report in PO, Invoice on Hold Report, Vendor, Payments and Analysis reports in AP and also Customer, Receipts, Invoice and Adjustments Reports in AR
  • Developed conversion programs to import vendor/Supplier information into purchasing by loading data into staging tables from legacy systems , validating data using Pl/SQL API's and then loading the data into vendor information Base Tables
  • Designed various reports using Oracle Reports Builder and BI Publisher
  • Hands on experience in Order to Cash (O2C) and Procure to Pay (P2P) cycles
  • 9

Sr

Oracle Apps R12

Education

Master of Computer Applications -

B.Sc. -

Computer Applications

Skills

  • Windows
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Agile
  • JIRA
  • SDLC
  • UOM
  • Oracle Integration Cloud (OIC)
  • XML
  • JSON
  • SOAP
  • WSDL
  • REST
  • FTP
  • BI Publisher
  • OTBI
  • FRS
  • FBDI
  • EBS
  • Oracle Fusion
  • AP
  • AR
  • PO
  • OM
  • INV
  • GL
  • Procure to Pay
  • Order to Cash
  • Inventory
  • BPM
  • HTML
  • JavaScript
  • SQL
  • PL/SQL
  • SQL Plus
  • TOAD
  • SoapUI
  • Postman
  • FileZilla
  • WINSCP
  • Loader
  • Putty
  • Oracle PDH Application Components
  • I Expenses
  • RICE
  • Oracle Reports
  • XML Publisher Reports
  • Finance
  • FA
  • Oracle Projects
  • SCM
  • Development
  • Implementation
  • Support
  • Migration Projects
  • Oracle Fusion Finance
  • Oracle Fusion SCM
  • BIP
  • OIC Integrations
  • Oracle Applications
  • Oracle EBS
  • Oracle Applications R12
  • Plus
  • PLSQL/Developer
  • Developer 2000
  • Reports 9i
  • BI Publisher 10g
  • BI Publisher 11g
  • Windows 7
  • Windows XP
  • Windows NT
  • Windows 2000

Skills

3+ years of experience in all aspects of Oracle Fusion implementation/Techno-Functional (80-20) and integration with other enterprise applications., Deep understanding of ESS jobs for BI Publisher Reports. Owned development of very complex reports - data extraction, RTF/Excel Layouts (BIP), Bursting and distribution via email and scheduling on ESS., Strong hand-on-experience integrating Oracle Cloud with on-prem and SAAS applications using OIC platform., Rich experience in Oracle EBS/Applications R12 Version, 11i, and R12 Financial Modules (AP/AR/PO/GL/FA), SCM (Order Management, Inventory, and Manufacturing), Projects and MOAC, TCA., Hands on experience in utilizing tools like Oracle Data Integrator (ODI ETL Tool) for data migration tasks., Skilled in preparing Technical Documents, Test Plans, and Test Results documents based on Customer/User requirements., Knowledge of Dev Ops Process which includes Migrating the reports from one instance to another.

Timeline

Oracle ERP Technical Manager

Astec
03.2024 - Current

Sr

Fusion Finance Techno, Think Big Solutions LLC
12.2023 - 02.2024

Senior Implementation

Oracle Fusion Finance Technical, Safeway/Albertsons
05.2023 - 09.2023

Sr, Finance/SCM Reports Developer

Delta Dental of California Remote – HCL
12.2022 - 03.2023

Sr, OIC Technical Developer

AEGON Life Insurance Company HCL
07.2021 - 12.2022

Fusion Technical Consultant

Waterpik Re-Implementation HCL
02.2021 - 06.2021

Sr, Technical Consultant

Oracle R12 & Fusion, The Wonderful Company LLC Strattek Consulting Pvt.Ltd
04.2019 - 09.2019

Sr. Oracle Apps Consultant

Al Arrab Contracting Company Appstec ERP Solutions Pvt.Ltd
08.2018 - 03.2019

Sr. Oracle Applications Consultant

Cantor Fitzgerald ESK Technologies Pvt.Ltd
03.2018 - 06.2018

Sr. Oracle Applications Consultant

Morning Star Accenture
03.2017 - 09.2017

Sr. Oracle Applications Analyst

Cisco Systems, Inc
07.2016 - 01.2017

Sr. Oracle Apps Technical Lead Consultant

Berry Plastics, Wipro Technologies
03.2016 - 06.2016

Sr. Oracle Apps Technical Lead Consultant

Sun Power, SPWR, Wipro Technologies
04.2015 - 03.2016

Sr. Oracle Apps Techno Functional Lead Consultant

Seagate Technology LLC, Cupertino Wipro Technologies
04.2014 - 04.2015

Sr. Oracle Application Techno Functional Consultant

Cisco Systems, Inc, CA Wipro Technologies
06.2013 - 04.2014

Sr. Oracle Finance &SCM Techno Functional Consultant

Symantec
02.2011 - 04.2012

Oracle Apps Associate Technical Consultant

Burley Sub Sea FZE, Tom –Lee, Emirates
08.2008 - 01.2012

Technical Manager

iGrid Technologies Pvt.Ltd

Sr

Oracle Apps R12

Master of Computer Applications -

B.Sc. -

Computer Applications

Similar Profiles

CREATE PROFILE
Usha Royala