Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

YOGESH BALIYARASIMHULA

Miami

Summary

  • Over 20+ years of Oracle Applications E-Business Suite Experience including Developing, Customizing, Testing and Implementation as a Techno-functional Consultant. Worked on several modules which include General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CM), Order Management (OM), Inventory (INV), Purchasing (PO), Shipping (WSH), Workflow and System Administration. Experienced in Implementing Order to Cash and Procure to Pay Process Flows. Experienced in developing Data Conversions and Interfaces from external systems to Oracle ERP. Good Knowledge in FORMS CUSTOMIZATION using Custom, TEMPLATE.fmb and FORMS Personalization. Expertise working with Oracle 8i/ 9i, Developer 2000, PL/SQL, Forms 6i, Report 6i, SQL
  • Loader, TOAD, Data Load, Oracle Discoverer 4i and XML Publisher. Good Knowledge of the TCA architecture, HZ Schema tables, Relationships and the TCA Model. Ability to handle both Development and Production Support Roles. Extensive use and application of AIM in projects. Expertise in managing Oracle SRs and escalations with Oracle Cloud Support. Experienced in implementation and customization of Oracle Applications, integration with legacy systems, design, and development of inbound and outbound interfaces. Worked with Sys Admin Module (Registering Forms, Reports and PL/SQL Programs), Creating Users, Customizing Menus, Assigning Responsibilities, creating concurrent executables, concurrent programs, Creation of Value sets, setting System profile options as per the requirement. Experienced in identifying technical gaps, estimating work, architecting system interactions, designing custom solutions, and programming, scheduling, producing documentation, user manual to users and providing production support. Ability to work individually as well as in a team. Strong team player.

Overview

1
1
Certification
21
21
years of professional experience

Work History

Oracle Applications Techno-Functional Consultant

World Fuel Services
Miami, FL
08.2012 - Current
  • Involved in the Oracle 11.5.10.2 to Oracle R12.2.9 upgrade project.
  • Worked on setup and configuration of various custom AP configurations into R12 AP Payment module.
  • Worked on setups related to Oracle Treasury module mainly counterparty, banks and custom configurations related to Custom Treasury forms.
  • Worked on the setup and reimplementation of the Cash Management Process.
  • Involved in the Mass Additions Conversion process for a company merger Implementation into Oracle Fixed Assets Module.
  • Developed conversion and interface programs. Reports design and development
  • Worked on the retrofit and revalidation of the Oracle Lockbox process.
  • Worked on the custom Mass Additions Update using WEBADI.
  • Worked on custom WEBADI development for Fleet PO updates.
  • Involved in the end-to-end testing of the various custom integration processes developed in SOA and Mule Applications.
  • Involved heavily in the bank integration project developed in the Mule Application that handles the transmission of the various payment files to the respective banks.
  • Loaded Employee Data, Supplier Data, Jobs Data, Locations Data using FBDI into Oracle Fusion.
  • Worked on Fusion REST APIs to create, update and add invoice attachments in Payables module.
  • Loaded AP Invoice data into Fusion using SOAP UI and FBDI functionality.
  • Created custom reports in Oracle BI Publisher based on existing Financial and Supply Chain subject areas.
  • Created Workday synchronization reports in Fusion to integrate workday data into Fusion.
  • Developed Custom Sanctions Interface that integrates with the SOA application to bring SANCTIONS data into the Oracle Inbound.
  • Used XML Bursting File feature in the various reports to deliver emails to the end-users with EXCEL/PDF output attachments.
  • Developed AR Consolidated Invoices package that will deliver the printed invoices into the FTP Outbound to various Customers.
  • Developed Customer/Supplier Integration package that integrates EBS customer information (TCA) with the Oracle CRM On-Demand Application.
  • Environment: Oracle Cloud Application 21C (11.13.21.07.0), Oracle Apps 12.2.9, Oracle Apps 12.2.9, GL, AR, AP, FA, CM, OM, PO, INV, Oracle 10g, PL/SQL, SQL
  • Plus, SQL
  • Loader, Forms 6i, Reports 6i, XML Publisher, Shell Scripting, Windows XP, HP-UNIX.

Oracle Applications Techno-Functional Consultant

Amazon Inc.
Seattle, WA
02.2011 - 08.2012
  • Involved in the development and design of the Global AR Aging report across all organizations and also worked on the UAT testing.
  • Developed GL Close period BI Publisher reports for month-end closing. Used XML Bursting File feature in the report to deliver emails to the end-users with EXCEL output attachments.
  • Worked on the Customer Conversion from 11.5.9 to R12.
  • Worked on the Unposted Journals Conversion from 11.5.9 to R12.
  • Worked on the Customer Conversion from 11.5.9 to R12.
  • Worked on the Unposted Journals Conversion from 11.5.9 to R12.
  • Used seeded Oracle interface programs (Import Standard Purchase Orders and Receiving Transaction Processor) to create new POs and receipts.
  • Re-customized the AR Module Sales Journal by GL Account Report from Report Version in 11i to XML Publisher in R12.
  • Customized the standard forms in application modules using CUSTOM.PLL for hiding the fields, changing the visual attributes & prompts of the fields.
  • Environment: Oracle Apps 11.5.10.2/R12.2.9, GL, AR, AP, OM, PO, INV, Oracle 10g, PL/SQL, SQL
  • Plus, SQL
  • Loader, Forms 6i, Reports 6i, XML Publisher, Shell Scripting, TOAD, Windows XP, HP-UNIX.

Oracle Applications Techno-Functional Consultant

LPL Financials
San Diego, CA
04.2010 - 01.2011
  • Imported Items from legacy system into Oracle Inventory base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
  • Developed PO interface to import Purchase Orders from legacy systems.
  • Developed queries for summaries of AR Aging reports, AR to GL Reconciliation reports, Auto-invoice execution/validation report, Tax and Revenue reports, Receipt register reports etc.
  • Worked GL Unposted Journals Conversion from 11.5.9 to R12.
  • Worked on the Customer Conversion from 11.5.9 to R12.
  • Involved in the modification of custom reports for changed tables in R12.
  • Used seeded Oracle interface programs (Import Standard Purchase Orders and Receiving Transaction Processor) to create new POs and receipts.
  • Re-customized the AR Module Sales Journal by GL Account Report from Report Version in 11i to XML Publisher in R12.
  • Customized the standard forms in application modules using CUSTOM.PLL for hiding the fields, changing the visual attributes & prompts of the fields.
  • Environment: Oracle Apps 11.5.9/R12, GL, AR, AP, OM, PO, INV, Oracle 10g, PL/SQL, SQL
  • Plus, SQL
  • Loader, Forms 6i, Reports 6i, XML Publisher, Shell Scripting, TOAD, Windows XP, HP-UNIX.

Oracle Applications Techno-Functional Consultant

Hitachi Data Systems
Santa Clara, CA
09.2008 - 03.2010
  • Involved in developing new interfaces, customizations of existing interfaces, developing new reports and customizing existing Reports and Forms 6i to meet the business/client requirements.
  • Developed several Ad Hoc reports using Reports 6i. Developed complex reports using lexical parameters, bind variables and several dynamic SQL queries.
  • Involved in the functional setup of GL, AP, AR and PO.
  • Upload of payment receipt through Auto Lockbox Interface in AR.
  • Exporting AR invoices to a legacy system.
  • Customized the Invoice Aging Report in AR and Purchasing Requisition form in PO.
  • Worked on invoice interface in AP.
  • Worked on Mass Addition Interface in FA. Build PL/SQL programs to perform Mass additions to load conversion of assets from legacy system.
  • Customized Purchase Order Report according to the business requirements PO.
  • Developed Item Interface conversion script for importing item information from Legacy System to Item Base tables through Open Item Interface program in INV.
  • Developed Custom Oracle Reports for Oracle Order Management.
  • Uploaded the assets information into Fixed Assets module.
  • Environment: Oracle Applications 11.5.10.2 (GL, AP, AOL, Alerts), OM, Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer 4i.

Oracle Applications Techno-Functional Consultant

NCH Corporation
Irving, TX
11.2007 - 08.2008
  • Rewritten and modified most of the custom reports for OM and Inventory modules in 11i.
  • Developed interfaces between ARGO Custom shipping application and Oracle OM.
  • Integrate Clarify with Oracle OM and AR modules.
  • Worked on DNSREC Project to bring the installation information from E
  • Connect through Web Methods to staging tables in Oracle OM. Pick released and ship confirmed the serial numbers using Oracle OM APIs
  • Developed a Custom API to import orders from one of the legacy system Siebel to OM using oe_order_pub API.
  • Developed custom API to copy inventory items from one org to another org (used an API Inv_Item_grp_create_item).
  • Developed API to update the items to set the serial control flag at Receipt.
  • Custom Open Purchase Orders Report (by Buyer) report developed using XML Publisher.
  • Custom PLL was used to place validations when the some of the orgs were set to serial controlled at receipt. The major validations are to validate the part number is matching against the legacy data based on the serial number entered or not. Is serial number entered is all caps or not.
  • Developed many reports in Inventory, OM modules. Custom Serial Sub inventory reports, Custom DBS Sales report.
  • Environment: Oracle Applications 11i (GL, AP, AOL, Alerts), PA, Forms 6i, Reports 6i, Oracle 8i (SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer 4i.

Oracle Applications Techno-Functional Consultant

Scholastic
Secaucus, NJ
03.2007 - 10.2007
  • Developed Custom Sales Representative Sales Payments Report for OM, which allows users in order for them to pay the sales force their commissions.
  • Developed Custom Outstanding Sample Orders Report for OM, to track sample requests that have not been returned or invoiced.
  • Environment: Oracle APPS 11.5.10, UNIX (AIX), Windows NT, Oracle 9i, GL, AP, AR, OM, INV, Reports 6i, Oracle Discoverer 4i.

Oracle Applications Techno-Functional Consultant

State of Rhode Island
Providence, RI
10.2006 - 02.2007
  • Customized GL Request Approval Process for changing the Timeout of Request Approval from Approver Notification in GL Module.
  • Designed, developed and implemented the following interfaces AR Lockbox Interface for multiple banks AR Custom Aging.
  • AP Invoices Interface for Multiple data sources.
  • Update MD70s as needed based on defect resolutions.
  • Mapping of data elements in the source system to facilitate GL Import Process. Analyze various required, conditionally required columns of GL_INTERFACE table.Worked on a Custom AR Invoice Report using Reports 6i.
  • Environment: Oracle APPS 11.0.3/11.5.10, UNIX (AIX), Windows NT, Oracle 9i/10g, GL, AP, AR, PO, OM, INV, Reports 6i, XML Publisher.

Oracle Applications Techno-Functional Consultant

Sanmina-SCI International
San Jose, CA
01.2006 - 09.2006
  • Developed database triggers on Order Lines Table for returning REASON CODE in the Receipts DFF.
  • Developed Custom Shipments Report to communicate with customers, sales reps and regional offices more effectively and less expensively by emailing the results.
  • Customized the Order/Invoice Detail Report in Order Management.
  • Worked on the Migration of Custom.pll customizations from 11.0.3 to 11i.
  • Worked on Custom Oracle Alerts for Terms Code Validation Email Verification and PO's in "Requires Re-Approval" Status based on client requirements.
  • Developed All Order Type Margin Analysis Report in OM.
  • Made changes to the Shipping Transactions FORM logic to restrict the generation of duplicate serial numbers.
  • Worked on Return Material Authorization custom package development in OM.
  • Involved in the Conversion of legacy Purchase Orders into PO module. Developed separate validation programs for different PO types.
  • Developed Item Extract and Item Costs Extract programs.
  • Customized Purchase order report according to the business requirements PO.
  • Environment: Oracle APPS 11.0.3/11.5.10, UNIX (AIX), Windows NT, Oracle RDBMS Server Ver 8i, GL, AP, AR, PO, OM, INV, Shipping, Reports 6i.

Oracle Applications Techno-Functional Consultant

UTStarcom International
Chicago, IL
06.2005 - 01.2006
  • Developed Custom Forms namely Revenue Accounting Setup form for Revenue Accounting and Progress Billing Setup Form for Progress Billing Custom modules.
  • Worked on Performance Tuning of Custom Package for COGS and Revenue Accounting.
  • Developed Conversion scripts for the Item Category and Product-Tree Conversion.
  • Developed database triggers on Order Lines Table and Order Price Adjustments Table for Custom Requirements.
  • Developed a Custom Package to update and add pricing attributes to Items.
  • Environment: Oracle APPS 11.5.9, UNIX (AIX), Windows NT, Oracle RDBMS Server Ver 9i, GL, AP, AR, PO, OM, INV, Form 6i, Reports 6i.

Oracle Applications Techno-Functional Consultant

Weight Watchers International
Woodbury, NY
01.2005 - 06.2005
  • Developed a Custom Open Invoice Interface to AP, which automatically populates the AP interface tables through a concurrent program.
  • Developed Cross-reference tables for mapping Supplier Location Codes, Line of Business Codes to GL Accounts.
  • Developed FTP shell scripts, which automatically logs into the Supplier sites and downloads the Invoice Data Files and saves into the Client Server Inbox.
  • Developed Tally Interface to GL taking into consideration the Debit and Credit Memo.
  • Involved in the study of Client’s Business Requirements and developed complete automation process plan of the Invoice Import to GL.
  • Developed a Custom Report to show all the invoices sent to each business locations from different suppliers and categorizing them into Capitalized Expenses and Non Capitalized Expenses based on client’s requirements.
  • Worked on Adhoc reports in AR. Involved in making changes to Custom Pro
  • C programs according to Business Requirements.
  • Environment: Oracle APPS 11.5.8, UNIX (AIX), Windows NT, Oracle RDBMS Server Ver 8.i, GL, AP, AR, PO, OM, INV, Reports 6i.

Education

Master's Degree - Industrial and Systems Engineering

University of Memphis
Memphis, TN
01-2004

Bachelor's - Mechanical Engineering

Andhra University
India
01-2000

Skills

  • ERP implementation
  • Business process analysis
  • Agile methodology
  • Application support

Certification

AWS Essentials Certified Professional

Timeline

Oracle Applications Techno-Functional Consultant

World Fuel Services
08.2012 - Current

Oracle Applications Techno-Functional Consultant

Amazon Inc.
02.2011 - 08.2012

Oracle Applications Techno-Functional Consultant

LPL Financials
04.2010 - 01.2011

Oracle Applications Techno-Functional Consultant

Hitachi Data Systems
09.2008 - 03.2010

Oracle Applications Techno-Functional Consultant

NCH Corporation
11.2007 - 08.2008

Oracle Applications Techno-Functional Consultant

Scholastic
03.2007 - 10.2007

Oracle Applications Techno-Functional Consultant

State of Rhode Island
10.2006 - 02.2007

Oracle Applications Techno-Functional Consultant

Sanmina-SCI International
01.2006 - 09.2006

Oracle Applications Techno-Functional Consultant

UTStarcom International
06.2005 - 01.2006

Oracle Applications Techno-Functional Consultant

Weight Watchers International
01.2005 - 06.2005

Bachelor's - Mechanical Engineering

Andhra University

Master's Degree - Industrial and Systems Engineering

University of Memphis

Similar Profiles

CREATE PROFILE
YOGESH BALIYARASIMHULA