Home

Prasanth - Oracle Applications Techno Functional Consultant AND EBS

[email protected]

Location: Remote, Remote, USA

Relocation: no

Visa: USC

Resume file: Prashanth Vallamalla Oracle resume_1770229037106.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Prashanth Vallamalla Oracle Applications Techno Functional Consultant Summary: OCA Certified Professional with 10 years of IT experience as an Oracle Application Techno Functional Consultant in Implementing Oracle Applications 11i/R12 and Oracle Cloud Application (Procurement and Financial), upgrade and customization in Oracle e-Business Suite Applications (EBS). This includes system study, design, development, post implementation maintenance and support of Oracle EBS and Oracle Cloud Application. Successfully completed full life cycles of implementations of Oracle Cloud Application 23D (Procurement) R 13.18.05, Oracle Applications release R12 (12.2.5, 12.2.2, 12.1.3) and 11i (11.5.10). Extensive work experience with the modules like General Ledger (GL), Accounts Receivable (AR), Accounts Payable(AP), Cash Management(CM), Advanced Pricing, Fixed Asserts(FA), Purchasing (PO), I-Procurement, I-Supplier, Projects, Order Management (OM), Shipping, Inventory(INV), BOM, AME, AOL, SCM, CRM, (Service Contract (SC), Install Base (IB), Field Service (FS), Depot Repair (DR)) and AOL modules. Proficient in functional flow of Procure to Pay (P2P) and Order to Cash (O2C) business flow. Experience in Implementing Oracle Procurement Cloud - Purchasing, Supplier Portal, Self-Service Procurement, Sourcing, SCM, and Procurement Contracts. Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions). Worked Closely with Middle Ware Team like SOA for integration process. Experience in integrating Oracle Cloud (Interfaces, Conversions and creating/updating (Integrations) using FBDI, ADFDI, HDL, Webservices (RestAPI s and SOAP)). Well Experienced in creating reports using BI Publisher/ Smart View/ FRS/ OTBI. Having very good knowledge on Oracle REST APIs for all Financial and Procurement modules. Experience in Fusion-based Integration development using OIC. Experience working with on prem EBS R12 to Oracle Cloud using OIC. Involved in OIC inbound and outbound OIC integration to Oracle Fusion (SaaS) and external systems. Experience in Oracle PCS and DBCS for application development. Ability to expose Cloud DB objects as REST API through ORDS that can be used in VBCS, SOA, OIC, ICS, etc Created Financial Data Analysis report as per business requirements for Month end or reconciliation Planning/analysis. Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases, test scripts. Involved in Functional, Performance. Testing Oracle ERP Cloud Bug Fixes and Quarterly patches Involved in writing documents MD50/Functional, MD70/Technical specs, CV40, etc. using AIM. Expert in Requirement gathering, analysis, design, developing and Testing (CRP and UAT). Extensive experience identifying product gaps coordinated with development team by creating Service Requests with Oracle Service portal/meta-link and obtained one-off fixes. Managed and monitored SR/TAR s for several P1 issues. Good experience in SQL/Report Performance Tuning and Strong debugging and analytical skills and troubleshooting. Imported and exported data between Oracle Cloud and Excel using tools like Oracle Data Integrator (ODI) or custom scripts. Extensively worked on XML/BI Publisher, Oracle Reports 6i/10g, OAF, Oracle Forms 6i/10g, PL/SQL Packages, Procedures, Functions, Custom PL/SQL APIs, and SQL Loader, workflow, shell scripting. Oracle Fusion/Cloud tools: Smart View, Financial Reporting Studio (FRS), OTBI, BI Publisher, HDL data loader, ADFDI and FBDI-based data conversion and integration (RestAPI s, Webservices) Proficient in using advanced Excel functions and creating rtf files. Technical Skills ERP APPLICATIONS: Oracle Cloud Applications 23D, EBS R12 (12.2.7,12.2.5/2.2/1.3) and 11i (11.5.10), AR, AP, GL, CE, FA, SCM, OM, PO, INV, PA RDBMS: Oracle 11g, 10g, 9i/ 8i / 7.x, SQL Server LANGUAGES: SQL, PL/SQL, Java, VB, HTML, XML, XSLT, UNIX Shell Script Integration Tools: OIC, ICS, SOA, VBCS, PCS, DELL Boomi TOOLS: Microsoft suite, TOAD, SQL Navigator, SQL Developer, SQL* Plus, Visual Source Safe 6.0, SQL*Loader, JDeveloper, Forms Builder, ODI, Reports Builder, Workflow Builder 2.6.3, OBIEE, Discoverer, GIT, JIRA, Service Now ticketing tools. Professional Experience PPL, Allentown, PA (Remote) Sep 2019 Till Date Oracle Cloud Techno Functional Consultant Responsibilities Responsible as a Techno Functional Consultant for Accounts Payable (AP), Purchasing (PO), GL and Security Modules. Supporting Oracle Cloud (Fusion) issues. Supporting/customizing existing Cloud Integrations (OIC) or creating new. Developing and customizing new and existing BI/OTBI reports for Financial, Procurement and Projects with adhoc runs, FTP/SFTP/EMAIL Bursting, Event Trigger, Flex Field, web service enabled options. Created or customized Standard or custom ESS jobs as per business requirements. Worked with third party system to get data in flat files/excel as per Oracle Standard formats. Accounts Payable: Corrected invoices import errors through ADFDI. Imported Payables Standard Invoices, Suppliers, Sites, Address, Contacts and Banks through FBDI Payables Payment update via Rest API and FBDI. Created Tax registrations at Supplier and Address level using Spreadsheet uploads. Created new Lookups, PayGroups and Payment Method as per business requirement. Creating context for BU based new DFF for Supplier Header and Line, Checks/Invoice header, line and Dist. Multi Period Accounting functionality for Prepayments in Oracle Payables, using advanced Subledger Accounting configurations. Customized Invoice email notification layout as per business requirement. Created Functional and Technical Specs for created Reports. Purchasing: Creating PO/Suppliers Infolets BI/OTBI Reports, FRS reports, and PO Interfaces report with XML format having nested tags. Creating Auto Receiving Receipt for POs via FBDI and Closed Mass POs via ADFDI. Creating DFF for PO Header, Line, Schedule, and Distribution level. Customized Purchase Order Layout PDF as per business requirement. Customized Purchase Order notification as per business requirement. Security: Mass user update via HDL Data loader o Add/Remove User Roles o Inactive/Terminate worker o Update Assignment Supervisor Creating User Categories and Mass assigning to it using Rest API. AR: Update Customers details via FBDI Created and updated Party, Party Sites, Party Site Uses, Customer Accounts, Customer Accounts Site/Uses, Relationships, Role Resp, Contacts, Banks using Customer Import FBDI. Created BI/OTBI Reports as per business requirements. OIC/Integrations: Worked on OIC instance setup creating FTP and REST adapters for Integration with SaaS environment. Used POSTMAN to run RestAPIs for Invoice update, Supplier update, AR customer Account update, User/worker update, and Purchase Order, Invoice release hold for one time update as per business requirement. Mass Cancelled Invoices via Web Services InvoiceService using SOAP UI. Invoice Payment Method, Pay Group and Due Date through Rest API. Created OIC Integration service and connections. Used Rest Api to update bulk tasks in BPM worklist to Withdraw status. Used WSDL and REST APIs for Purchase order and Invoices to update in POSTMAN and SOAP UI. Post Clone Activities: Mass email address update for all Users, Suppliers, Sites, Address, Contacts, Remit and Customers. Turning off all notifications. Environment: Oracle Cloud Applications (PO, AP, INV). Financials, SCM and Procurement, Oracle EBS R12.2.7 Oracle Tools: OTBI, BI Publisher, PL/SQL, SOAP UI, REST API, POSTMAN, HDL data loader, OIC, ICS, VBCS, BPM Workflow, Security Management. Bank of America, TX June 2017 Sep 2019 Oracle Apps EBS/Cloud Techno Functional Consultant Responsibilities Responsible as a primary technical consultant for Accounts Payable (AP), Purchasing (PO), Inventory (INV) and General Ledger (GL) Modules. Created BIP/OTBI reports as per business requirement in GL, AP, PO, INV Worked extensively on FBDI and ADFDI for Financial and Procurement modules Created or customizing OIC Integrations and created OIC integration calling BI report in OIC Cloud Application: Creating DFF fields for Supplier, Sites, Bank, Purchase Order, Purchase Requisition, and Item. Creating and Inactivating Business Units, Lookups, and Managing GL Charge Accounts. Defining Security Profiles and Custom Roles in Cloud as per the SOX Compliance and business needs. Created new Supplier s, Purchase orders and Invoices etc through FBDI process. Defining ESS Jobs and Job Sets in ERP Cloud for the new Processes. Creating DFF fields for Supplier, Sites, Bank, Purchase Order, Purchase Requisition, and Item. Creating and Inactivating Business Units, Lookups, DFFs and Managing GL Charge Accounts. Used SOA Web Services to Update PO Header, Line, Line Location and Distribution columns as per Business Requirement. Using SOA Web Service Updated Supplier Site Name as Per Business Request and Built an Interface from Cloud Applications to Middle Ware SOA Team destination Path. Using OIC updated mass updated Invoices details like Payment method, PayGroup, Bank Acct, due date etc., Created BI Report to Auto create PO Receipts for punch-out suppliers with given business logic through Web Service. Experience in migrating on-premises SOA solutions to Oracle Cloud. Developed SOA/REST based Interface/Webservices EBS R12: Developed PL/SQL scripts to enable integration between Oracle EBS and other systems. Worked on Supplier and Purchasing Integration from Cloud Supplier Data to EBS Legacy. Did Supplier, Purchasing, GL conversion from Legacy EBS to Oracle Cloud using FBDI. Developed concurrent programs to Inactivate Supplier Header, Site and Address using APIs. Involved in all extraction process from Oracle R12 to Cloud, for Purchasing, Accounts Payable (AP) and INV as per Cloud templates. Identified the changes needed to existing PO reports, per business requirement. Developed API for mass Purchase order List price and PO Category as per the business requirement. Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system, imported into Oracle Application using the Payables Open Interface Import program, and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices. Imported Items from legacy system Oracle Inventory (INV) to third party using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories. Bulk loading items in iProcurement. Developed MD70 Technical Design Documents based on business requirements to include technical details for the project such as input data format, table mapping, flow chart, concurrent program names and order of execution. Developed API for Mass Close Purchasing Documents Did Item Interface and Item Sub Inventory from Oracle Cloud and EBS to AMMS Server through FTP process. Working on data element Rebuildable to the Oracle EBS to AMMS Extract of Items (External system). Worked on Item Conversion for Item master, Item category, Item Sub Inventory, Manufacturer and on hand Trx. Developed fnd package to End date Responsibilities for Mass Users. Developed fnd package to Add Responsibilities for Mass Users. Worked on Oracle Contracts, extracted Adhoc data, loaded in to Applications. Imported EBS BOM Data from legacy system into Agile PLM using the Standard Oracle Interface program. Environment: Oracle Applications R12.2.5, (PO, AP, INV), Oracle Cloud Applications, Procurement, SCM, Reports 10g, Forms 10g, SQL*Loader, Toad, UNIX, Oracle Workflow 2.6, Explain Plan. Oracle Tools: OTBI, BI Publisher, PL/SQL, SOAP UI, REST API, POSTMAN, HDL data loader, OIC, VBCS, BPM Workflow, Security Management. Hobby Lobby, Oklahoma City, OK July 2016 May 2017 Oracle Application Developer Responsibilities Production Support: Worked on Production Support, attending production calls, troubleshooting the Oracle Application (12.2.4) and resolving bugs. Handling daily tickets related to various user problems in OM, AR, GL, INV, PO modules Co-ordination with various third-party vendors during business affecting changes and deployments. Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues. Identifying risks proactively and proposing solutions to resolve them. Worked heavily on Item master, enabling additional attributes in item, categories, Item catalogs. Modified and updated existing custom forms to adapt to new database schema. Developed AP Remittance batch report using XML/BI Publisher. Created Data Definition Templates, rtf templates and split the xml file using bursting feature in XML Publisher reports. Developed Custom Reports for Billing History by Client, Invoices by Client Report and Projects NDR Report using Discoverer 10g. Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader for different cases). Debugging the packages, functions, procedures and triggers. Customized an Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs. Actively handling Order Management Shipping Production issues in areas like stuck SO lines, Workflow issues, RMAs, Pick Release, Pick slip Shipping documents, Adjustments maintaining setups. Customized various reports in OM and shipping, Orders cuts and returns. Customized existing reports according to the functional specifications including Packing Slip, Pick Slip, Daily Inventory Transactions Report, Invoice and Expense reports, AR Adjustments etc. Tuning the SQL queries for performance improvement. Highly responsible in Coordinating with Project Manager, Business Leads and Functional Owners to gather requirements for all CEMLI/RICEW Components. Customized Requisition Approval workflow, Purchase Order (PO) Approval Workflow. Debugged workflow using workflow administrator to approve Requisitions, Purchase Orders. Personalized iProcurement Preferences page, Requisition Summary display page and Requisition Checkout page. Mednax, FL April 2016 June 2016 Technical Consultant This project involves re-implementation Oracle applications R12 (12.2.5) including the interface programs, reports, and forms personalisation as per the user and business requirements. Conversions/ Interfaces Understanding of EBS architecture and underlying tables / columns in Oracle EBS R12 (12.2.5). Involved in the up gradation from Oracle 11i to Oracle R12 (12.2.5). Involved in Functional document (MD50) review and preparation of technical document (MD70) based on the business requirement. Planned to implement the data conversion methodology and programs to bring Installed Base (IB) instances (software licenses) and Service Contracts (SCs) (service agreements and maintenance) from a legacy system into the Oracle application. Designed an interface to send entitlement information from SC/IB/OM Oracle to Digital River (for Electronic Software Download entitlements) and to Siebel (for support entitlement verification). Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. Worked on SQL*Loader to load data from flat files obtained from various facilities every day. JM Family Enterprise, Deerfield, FL Nov 2015 Apr 2016 Technical Consultant Responsibilities Did Conversions/interfaces for PO, AP, AR, and INV. Created Integrations for PO and AP. Prepared MD50/Func Spec, MD70/Tech Specs and Prepared Tech spec doc and mapping doc for EDI s Designed and developed a custom PL/SQL code to call the standard API's in the Installed Base and Service Contracts module to update install base instances and contract records to reflect correct ownership information for drop-ship orders Developed Various Reports/Forms/ XML/BI Publisher in PO, AP, INV Customized Requisition Approval workflow, Purchase Order (PO) Approval Workflow. Worked on Production Support, attending production calls, troubleshooting and handling daily tickets in Oracle Application. Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues. Identifying risks proactively and proposing solutions to resolve them. Personalized iProcurement Preferences page, Requisition Summary display page and Requisition Checkout page. Developed staging tables, Custom PL/SQL API to validate and load data into Interface table. Involve Functional, Performance and Regression testing. Design several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development. Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus. MedHok, Tampa, FL Apr 2014 Nov 2015 Technical Consultant Responsibilities Wrote Technical Specification (MD070), Conversion Mapping (CV040) documents. Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor Information Base tables. Developed staging tables, conversion routines, Custom PL/SQL API s in INV, PO, AP Developed Purchase Order inbound interface to upload the Purchase Orders (PO) details from the legacy to Oracle Applications base tables Designed and developed a custom PL/SQL code to call the standard API's in the Installed Base and Service Contracts module to update install base instances and contract records to reflect correct ownership information for drop-ship orders. Developed Unix Scripts for capturing PO details for EDI Transactions Create new OAF Page for Supplier Search and wrote Page Controller in Java with JDeveloper IDE. Developed Various reports in PO, AP, INV Did Performance tuning on the reports (SQL and PL/SQL), making the Procedures runs faster and more efficiently. Used SQL trace files in the tuning process. Used Oracle's optimizer and monitored how it chooses and execution path/plan for the procedures. Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development. Keywords: user interface business intelligence database rlang information technology container edition purchase order procedural language Arkansas Colorado Florida Pennsylvania South Carolina Texas