Home

Pavan Kumar Thota - Senior Oracle Cloud Technical Consultant

[email protected]

Location: Wilmington, Massachusetts, USA

Relocation:

Visa: H1B

Pavan Thota Summary: Over 12 years of experience working in Oracle E-Business Suite and Fusion Cloud Applications as a Techno Functional Consultant. Experience working on Fusion Finance and SCM Modules like AP, AR, PO, OM and GL. Expert in designing end to end integration flows between various systems (Oracle and Non-Oracle) and implementing them in Oracle Integration Cloud Expert in lifecycle management of OIC Components, fault handling and encryption in OIC, migration of OIC Components using packages, lookups, versioning and cloning of integrations. Developed Outbound Integrations by using REST and SOAP services to interface the data between Oracle Cloud and other Applications. Worked on Bulk data imports using FBDI Templates and ADFDI Spreadsheets Developed BI Report (with Bursting and FTP Features enabled), OTBI reports along with Parameter Handling, LOV, Event Creation, ESS job creation and Scheduling Jobs in Oracle Fusion SaaS Model for Finance and SCM Modules. Worked on Personalization s and customizations of oracle fusion applications pages using page composer. Expertise in SQL, PL/SQL, Shell Scripting, XML Publisher Reports, Interfaces, RDF Reports, Forms (Personalization s), OAF using JDev, Workflow, SQLLOADER, UTL_FILE Package etc. Worked on PPR Setups for check printing and E-text templates. Good knowledge and exposure on P2P and O2C Flow. Worked on OAF Personalization s by using VO and CO Extensions. Adept in end-to-end implementation of Oracle ERP includes AP, AR, GL, PO and OM. Deft at mapping the requirements, providing custom design solutions, and troubleshooting the issues. Worked on Performance Tuning of long running SQL Queries with the help of tkproof and explain plan. Followed AIM Methodology, creating MD50, MD70, MD120, CV60 and TE20 documents as part of Design, Development and Deployment Process. Experiences with SDLC, Development, Testing, SIT, UAT, Production Support & Change Management Process. Worked on tools like SQL Developer, JDeveloper, TOAD, SSH-Tectia, WINSCP, Remedy, Forms Builder, Reports Builder and Workflow Builder. Efficient in handling Incidents and Service/Change Requests as part of Production Support. Excellent communication and Interpersonal skills with abilities in resolving complex issues. Technical Skills: Oracle Modules: AP, AR, GL, PO & OM, Fusion Financials and SCM RDBMS: Oracle 9i / 10g /11g Languages: SQL, PL/SQL, OIC, XML & Shell Scripting. Operating System: Windows, Unix, Linux Utilities/Tools: FBDI, ADFDI, Putty, WinSCP, SQL Loader, SSH-Tectia, Jdev, Report Builder, Form builder & Workflow Builder, SVN. Education: Master s in Business and Management from University of Bedfordshire, 2010 Bachelor of Technology, in Electrical and Electronics Engineering from Jawaharlal Nehru Technological University, 2007 Certifications and Awards: Oracle Procurement Cloud 2022 Certified Implementation Professional Oracle Inventory Cloud 2022 Certified Implementation Professional Oracle Cloud Infrastructure 2023 Certified Application Integration Professional Achieved Yes recognition award for handling complex requirements in ADQ Project. Achieved Pacesetter award for delivering exceptional results for client SEHA. Kaizen Certification for proposal and implementation of Project for client Owens Minor. Won Dell Champion Award for Underwriters Project Won On the Spot Award for Owens & Minor Project. Professional Experiences: Client: ADQ, Abu Dhabi, UAE Duration: Sep 2023 to till date Role: Fusion Cloud and Integrations Technical Consultant Project: ADQ SCM and Finance Support Responsibilities: Data Imports/Conversions Asset mass additions using ADFDI spreadsheet. Item Import using FBDI Integrations (OIC) Developed Inbound Integrations to load Journals from ADDH Systems to Oracle General Ledger using JournalImportService and ERPIntegrationService along with Callback Functionality by using OIC middleware. Reports Development BI Publisher Reports PR and PO Details Report. Worked on Negotiations summary and Details Report. Developed PO Pending Acknowledgement Report to send remainder notifications through bursting to suppliers email. Worked on PR Approval history report to show the details of number of days taken by each committee member to provide approval/rejection of PR. Created Negotiation Notification Report with delink to navigate to Negotiation details page for review and update. OTBI Dashboards Developed SCM Pending/Open Transactions Dashboard. Payable Invoices Dashboard Customizations Customized Fusion Cloud BPM Workflow notifications and Templates. Customized Negotiation scorer page to enable supplier and supplier site fields by using custom role in EL Expression through page composer. Worked on Enabling and hiding Oracle Fusion Page buttons, adding Report hyperlinks in pages, dynamic display of fields and messages based on BU. Added custom message field in Supplier Portal Invoice Page based on legal entity name capturing by enabling Partial trigger(partial page rendering). Debug and tuning of long running reports to handle exceeding time limit issues. Environment: Fusion Cloud, BI Publisher, Oracle OIC, SOAP and REST, P2P Products. Client: SEHA, Abu Dhabi, UAE Duration: Jul 2022 to Aug 2023 Role: Fusion Cloud and Integrations Technical Consultant Project: SEHA Fusion Implementation Responsibilities: Data Imports/Conversions PR and PO Data import from EBS to Fusion using FBDI Import process. Open Payables Invoices Import from EBS to Fusion cloud using FBDI Import Integrations (OIC) Developed FBDI Automation Integration to import GL Daily Rates into Oracle Fusion General Ledger from core Banking System using Oracle Integration Cloud. Created Integration between Kronos and ATP DB to interface timecard shifts and punches on daily basis that should reflect in the VBCS Pages by using REST/SOAP services, File Adapters etc. Reports Development BI Publisher Reports Developed AP Invoice Payments Notification Report in Fusion Cloud using Bursting Feature. PR and PO Details Report. Developed PR Approval Audit Report to get the approval history for selected PR s from Report. Developed PO Approval Audit Report to get the approval history for selected PO s from Report and Purchase Order Screen. Developed PR/PO ATF report to send notification to requestor about the change in PR and PO details. OTBI Reports Created PR PO and Receipt Details Report. Created Infolets using OTBI Reports to show pending Invoice Payments Customizations Customized PO PDF Report as per the requirement to add additional information and Change Order details. Customized Payments Approval Notification to display selected invoice details and amounts in Fusion BPM Notification. Tuning of queries to handle the exceeding time limit issues in Fusion BI Reports. Environment: EBS R12.1.3, Unix, Oracle 11g, Oracle ATP, XML Publisher, Fusion Cloud, Oracle OIC, SOAP and REST, P2P Products. Client: SEHA Hospitals, Abu Dhabi, UAE Duration: Sep 2021 to Jun 2022 Role: SCM Technical Consultant Project: SEHA Procurement Regionalization Project Responsibilities: Design and develop the process to implement regionalization of multiple Operating Units and enable all the procurements to handle in single business unit to improve the business operations. Worked on Requisition Interfaces, PO Interfaces and GRN Interfaces to create mirror PR, PO and GRN s as part of procurement regionalization process. Created Form Personalization s to restrict creation of PO/PR s on non-stock items on Requisition and Purchase Order Creation Forms. Created Forms Personalization to restrict the creation of PO if mismatch on Mirror PR and Original PR Lines and quantities. Developed Reports to send daily Alerts to Procurement team on Mirror PR/PO Creation errors with error messages. Environment: EBS R12.1.3, Unix, Reports Builder, Oracle 11g, XML Publisher, P2P Client: SEHA, Abu Dhabi, UAE Duration: Aug 2019 to Aug 2021 Role: SCM and Finance Techno-Functional Consultant Project: SEHA R12 Support Responsibilities: Worked on import program of Item Master data to Oracle EBS from Third-party Application as part of new products integration. Worked on the process of getting the NF Drug requests that comes from custom process (OAF Pages) to auto create approved Requisitions and Purchase Orders in Oracle Procurement by developing PR and PO creation Interface programs. Developed custom process to load Kronos data into Oracle EBS by using DB Link and created PLSQL Programs to create the timecard, shifts and punches for respective employees based on the data received from KRONOS. This enables HR Department to monitor and send alerts to employees on missing shifts and absences by employees and run the payroll accordingly. Worked on PO and Requisition Form Personalization to default the sub-inventory based on the Inventory Organization. Developed Inbound Interface program by using SQL Loader (CTL File) and creating Import Program to create new Items and their assignment to Inventory Organizations and corresponding sub-inventories. Added new dff s to make few of them mandatory and default values based on previous DFF value by using OAF Personalization, VO Substitution and Controller Extension to handle Mandatory and default the values. Worked on iProcurement Page CO extensions to throw OAException messages if buyer was not selected by using JDeveloper. Developed Item consumption and on-hand quantity report to display the monthly and yearly averages of all the inventory Organization and sub-inventories by using XML Publisher. Environment: EBS R12.1.3, Unix, Forms Builder, Reports Builder, Oracle 11g, Workflow Builder, XML Publisher, JDeveloper Client: Movianto (O&M), Luton, Bedford Duration: Aug 2017 to Jun 2019 Role: Finance Techno-Functional Consultant Project: R12 Support Responsibilities: Worked on Payment Process Request Setups for US bank and CITI bank in AP by creating XML Templates, Payment Formats, Payment Documents and creating Payment Process Profiles. Developed check printing xml Templates, position based and delimited based e-text templates to handle different EFT Formats like US NACHA, BOA, GERMAN etc. Developed PLSQL Procedures using API s by using the data coming from AMAZON Marketplace to create AR Invoices and AR Adjustments to handle the commissions and calculate final receivable amounts. Worked on Outbound Interfaces to create AR Receipts file using utl_file package and transferring the file from oracle server to third party server using shell scripting program. Setting up cross validation rules in GL as per the requirement. Developed data fix scripts as part of support. Developed AR Customer and sites and contacts creation plsql interfaces and generated WSDL URLs using pls files that enables Biztalk Webservice to trigger the packages to create customer data in Oracle from Customer Master Data System. Extended OAF Page for AP Banks Page to display unmasked bank account numbers. Worked on EDI820 Outbound Interface to extract the payment format files and place them in server using utl_file package. Environment: EBS R12.2.3, Unix, Forms Builder, Reports Builder, Oracle 11g, Workflow Builder, XML Publisher, SOAPUI, JDeveloper Client: Harvard Pilgrim Health Care, Canton, MA Duration: Sep 2016 to Aug 2017 Role: Oracle Financials Technical Consultant Project: R12 Upgrade/Support Project Responsibilities: Worked on creating check formats, EFT Templates, Payment Process Profiles creation and Remittance advice. Worked on Workflow customization on Expense Account Generator and Po Requisition Approval Workflow to override and default accounting segment based on the department segment. Worked on customer interface and Developed generic Shell Script program to call the ctl file and load the data file records into staging tables. Developed XML Publisher reports like Supplier and its Bank Account details report, AR Aging Report, Finance Charge Invoice Report and splitting and bursting the finance charges data to respective customers. Worked on service request and Incidents to enhance the existing reports interfaces, providing data extracts, and fixing the interface issues of import errors. Environment: EBS R12.1.3, Unix, Forms Builder, Reports Builder, Oracle 11g, Workflow Builder, XML Publisher Client: Unite Students, Bristol, UK Duration: Jun 2016 to Sep 2016 Role: Onside Coordinator and Finance Technical Lead Project: UK R12 Upgrade and Support Responsibilities: Designed the MD050 and BR100 documents related to retrofitting the existing 11i Reports and custom forms in Payables and Receivables modules. Worked on upgradation of Payments Process by developing payment formats, e-text templates to replace 11i payment files. Worked on converting RDF Reports to XML Publisher reports like AP Invoice Payments Report and AR Pending Transactions Report to enable bursting of output files to finance team on daily basis to monitor the AR and AP transactions. Worked on creation of summary and details report of supplier wise invoice payment details amounts. Environment: EBS R12.1.3, Unix, Reports Builder, Oracle 11g, Workflow Builder, XML Publisher Client: Owens & Minor, Mechanicsville, VA Duration: Aug 2014 to Jun 2016 Role: SCM/Finance Technical Consultant Project: Finance and SCM Implementation Responsibilities: Extraction, classification, and assignment of components to team members. Developed Invoice Interface and Supplier Interface to load the Invoice and Supplier information from its third-party system. Worked on PO and SO interfaces. Developed webservices interface models to integrate with legacy systems. Worked on XML Publisher Report, Supplier and Bank Information Report Worked on PL/SQL Tuning and Performance Tuning. Worked on Oracle standard API s to create suppliers, sites and supplier contacts as part of Supplier Interface. Environment: EBS R12.2.3, Unix, Forms Builder, Reports Builder, Oracle 11g, Workflow Builder, XML Publisher, SOAPUI, WSDL Client: Underwriters Laboratories, Northbrook, IL Duration: Jul 2013 to Aug 2014 Role: Oracle Financials Technical Consultant Project R12 Financials Reimplementation Responsibilities: Worked on GL Daily Rates Interface to load daily currency conversion rates in GL. Worked on Finance Charge Invoice report to show the outstanding amounts calculated with interest charges. Enabled MOAC to get the reports work for different operating Systems. Performed unit testing and migration process of the components to Production. Designed technical documents (MD70) based on MD050 s. Developed External Bank and branches creation interface code using oracle standard API s. Developed Custom Requisitions Remainders Workflow Notification to notify the Approvers to handle the timeout issue and ending the requisition with No Approver Found. Developed Amex Credit Cards Interface to create credit cards in ap credit cards tables and to load the credit card transactions into AP Credit card transactions using SQLLOADER and PLSQL Procedures. Worked on Invoice interface in bringing only open and partially paid transactions on prorate basis to distribute the amounts at line level. Environment: EBS 11i, EBS R12.1.3, Unix, Forms Builder, Reports Builder, Oracle 11g, Workflow Builder, XML Publisher Client: Trinity Industries, Dallas, Tx Duration: Apr 2012 to Jul 2013 Role: Technical Analyst Responsibilities: Worked on Aging Reports to generate Excel output as per the requirements. Developed an XML Publisher report to show price lists for the Inventory Items. Worked on AMEX Ghost Card Interface to import transactions sent from bank in different formats for Europe, Asia, Northern America, and Canada. The code developed handles different formats coming from AMEX and loads data into Internet Expenses. Prepared MD070 s, CV60 s and MD120 s based on functional requirements. Migrated code files using Harvest Package from lower instance to Production. Environment: EBS R12.1.3, Unix, Reports, pl/sql, Oracle 11g, XML Publisher Keywords: business intelligence database purchase order procedural language Arkansas Colorado Illinois Massachusetts Texas Virginia