Pavan Jakka Email & Phone Number

Hyderabad Area, India

Greater Los Angeles Area

Houston, Texas Area

Greater Boston Area

Project description: - (R12 Upgrade project mainly in Accounts Payables, Project Accounting and Procurement modules) Environment: - All the Account Payables, Receivables and GL are in 11i and iProcurement and Purchasing are in R12. Here Client is looking for creating one R12 instance with all the modules integrated.Role and Responsibilities:-• Designed and developed new Payment formats for US checks and Canada Checks in BI publisher.• Designed and Developed US , Canada and Ireland Payment process profiles and templates. • Developed custom Advice Remittance and Positive Pay file in XML Publishers for US and Canada OU’s based on business requirement.• Designed and Developed Citi bank extracts for State Street corporation payments.• Designed and developed complex XML reports for reconciliation of PO’s, Payments and Invoices in R12 system based on business requirement.• Designed and develop custom OAF page for AME approvals for approval management of Invoices based on business requirement.• Developed Generic Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems.• Documented MD070 for the custom US NACHA format for PEP team and signed off by business.• Experience in design and development of Oracle Payments Discoverer reports based on Business requirements.• Designed and Developed ETEXT payment file using BI publisher for Canada Bank.• Developed Top Supplier payment report in XML publisher based on business requirement.• Expertise on Oracle to INSTANTIS integration for project creation as a part of Project accounting implementation. • Modified existing VPD functionality, in order to hide Sensitive data in Suppliers and Invoices forms.• Converted all the legacy Invoices, Suppliers and Bank accounts into Oracle R12 TCA.• Designed and Developed advanced BI publisher reports for reconciliation of PO’s and Invoices matched.• Created OAF page for importing Electronic Invoices and Purchase Orders.

Greater Seattle Area

Amazon business would be launching the “Digital Content Store” in Netherlands market place. The digital content would be sold on a NL website, and managed by legal entity outside of Netherlands. Developing Automation/Reconciliation Process for Amazon Kindle iProcurement System for maintaining transparency for Business Users in R12.2.4 version.Role and Responsibilities:-• Documented MD050 for the Contra Cogs for NL project and signed off by Project manager.• Designed and developed Email matrix table to send specific templates to specific user groups.• Converted all the legacy Netherlands Suppliers and Bank accounts into Oracle R12 TCA.• Designed and Developed Complete Procure to Pay process from Amazon Kindle iProcurement system for Netherlands.• Designed and developed Technical Specifications for the Inbound Interfaces as per the Functional Specifications in OM.• Imported data from legacy system into staging tables using SQL*LOADER, perform validations prior to transferring data into OM Open Interface tables.• Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.• Converted all Amazon Kindle Management System Customers into TCA.• Designed and Documented Unit test cases for all the business cases for the Users to sign-off.• Developed Reconciliation process for Amazon Kindle iProcurement System.• Converted NL requisitions using Requisition Import program.• Worked on iProcurement Requisition and Receiving pages for testing the Functionality of NL iProcurement setups.• Designed and Developed advanced BI publisher for Orders booked and Fulfilled for Business users.• Personalized iProcurement Receiving OA pages such as Receiving Home page and Receiving Search Page based on Business requirements.• Create AP invoices after Accounting in AR if the same Customer is a Vendor based on Business Requirements.• Developed SQL - Loader script to load the Requisitions file from upstream to Oracle Staging tables.

Phoenix, Arizona Area

Bechtel (BEK Corp) is known for engineering, construction, and project Management Company. Up-gradation of Oracle Applications EBS from 11i to R12. Consisting of approximately 2000+ custom objects to be modified and also as a part of Implementation of Billing and OBARS project in Oracle R12.Role and Responsibilities:-• Involved in Design, Development, Testing and Documentation of Oracle Apps R12 Upgrade Project.• Involved in implementing TCA architecture for Banks, Bank branches and Customers from BPS legacy System to Oracle R12 as a part of R12 Up-Grade project.• Developed PLSQL Routines for loading Invoice and PO Related Information into Oracle R12 from Custom Applications.• Designed and developed HLD’s for Oracle R12 Payments module and developed Interfaces for Vendors and Vendor Sites from SAP to Oracle to meet business requirements.• Designed and Developed Custom OAF pages for Jobs and Projects based on Business Requirements.• Designed and Developed Custom Invoice Validation program Using Oracle Standard Validation Hook to add Custom Hold on the Invoices Dynamically.• Designed and Developed Custom Invoice Workflow using Workflow Builder to get approved by Project Contacts based on the Approval authority.• Design and develop various Government billing reports using XML Publisher and Reports 6i.• Analyzed, Designed and Implemented Oracle R12 Payments module for Bechtel Corporation and set up payments for different Countries. • Designed and Developed Interfaces for Employee Bank Accounts from SAP to Oracle R12 instance.• Automated all the Employee and Vendor Interfaces to Oracle by XML Bursting Technique to send automated Email Notifications to the Related Business Leads.• Designed and Developed Custom EXCEL forms using Oracle WEBADI for the Users to upload manual Journals.• Designed and developed XML Publisher Reports like Invoice template, Sales Order template and Billing reports.

San Jose

Cisco Systems, Inc. is the worldwide leader in networking for the Internet. Today, networks are an essential part of business, education, government and home communications, and Cisco Internet Protocol-based (IP) networking solutions are the foundation of these networks. Cisco hardware, software, and service offerings are used to create Internet solutions that allow individuals, companies, and countries to increase productivity, improve customer satisfaction and strengthen competitive advantage. Role and Responsibilities:-• Developed High Level Technical design documents (TD) for CISCO Inbound and Outbound transactions. • Implemented new XML Gateway Transactions for new Vendors.• Modified existing customizations for DEX implementation project.• Modified existing Oracle Standard pick slip and packing slip report for the DEX implementation project.• Designed and developed wrapper packages in order to store XML data into oracle tables.• Enabled XML messages for the particular Trading Partner based on business requirements.• Designed and developed mapping for 3A4 RMA Create / Confirmation transactions.• Developed wrapper program (PLSQL) for collecting data from the XML files.• Worked extensively with XML Gateway message designer.• Designed and developed mappings for 4B2 Receipt notice inbound, 7B5 work order outbound, 7B1 work order status inbound, 7C6 Quality data inbound, 3B11 Ship notice inbound.• Modified existing B2B Query form (Custom) based on the business requirements.• Designed and developed wrapper packages in order to store XML data into oracle tables.• Designed and Developed Custom XML Publisher reports based on Business requirements.

Boca Raton

ADT Security Services is America's number one provider of electronic security systems and services. Since 1874, ADT's leadership has been - and still is - based on providing all our customers with uninterrupted safety and peace of mind. ADT's continuing commitment to serving its customers better is borne out in significant numbers.Role and Responsibilities:-• Developed flexible PL/SQL scripts/packages for importing Project Details into Oracle R12 from legacy Applications.• Involved in Requirements Analysis, Design, Data Mapping and Client Interaction.• Prepared Technical Specifications based on the Business Requirement Documents.• Designed and developed conversions for Projects, Tasks and Costs into Oracle R12 from a third party tool based on business requirements.• Designed, developed and documented the Custom Interfaces for AP modifications based on Business requirements when Project Accounting is installed in Oracle R12.• Worked on development of Logical apps rules based on Business Requirements.• Customized Oracle Standard forms using ADT_CUSTOM.PLL file to meet the Business requirements.• Developed custom Forms using Forms Builder based on Business requirements.• Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.• Worked on development of Logical apps rules based on Business Requirements.➢ Rule 1 :- Restrict Project numbers based on Vendors➢ Rule 2 :- Restrict Custom fields based on Project details.➢ Rule 3:- Make a particular field Mandatory or not based on Business requirement.• Developed SQL Loader Programs and PL/SQL procedures to load data into Oracle R12 from various feeder systems.• Designed and developed Custom PA Utility package which is used by all the Standard and Custom processes to derive Project fields ie:- Project Number, Expenditure type, Expenditure organization, Task Expenditure Item date.

Alpharetta

AT&T is the largest communications holding company in the world by revenue. Involved in Scientific Atlanta Merge Project and also implementing new Transaction types in E-Commerce gateway for Invoices and Purchase orders.Overview of Project:-DITREX sends EDI 850 POO and 860 POCO files from AT&T to Vendors containing PO’s. These PO’s are sent to Vendors to fulfill orders for Network Equipment. Vendors send Invoice files to AT&T via DITREX. The project is to develop an Automated EDI Reconciliation process through a comprehensive design to reconcile the transactions sent to Vendor and received from Vendor.Role and Responsibilities:-• Designed customizations, interface/conversion mapping, pre production testing, and related documentation.• Created High Level Design (HLD) documents for Reconciliation of Invoice inbound transactions (INI-810) and Advice outbound transactions (ADVO-824).• Created and documented HLD for EDI Reconciliation Report for POO-850, POCO-860, INI-810, ADVO-824.• Performed Functional testing for INI-810 and ADVO-824 transactions.• Worked with development team to resolve issues during testing and post production.• Supported Business users in the User Acceptance Testing and resolved issues raised by the Business team.• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data. • Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file and also import invoices from Scientific Atlanta System.• Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.• Written PL/SQl packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.

Greater Salt Lake City Area

Project Management , Agile , Sql , Plsql , Matlab , Solid WorksRole and Responsibilities:-• Designed and Developed PL-SQL packages for (Mini ERP) Class Room Management system.• Designed and Developed Database for Library management System.• Developed Complex SQL queries.• Worked as a Teaching assistant in Solid Works Lab.• Mentored and Graded a Class of 60 Students.• Developed Matlab programs for Artificial Intelligence neural Networks. • Developed complex Algorithm (AI) for filtering data using Feedback technique for Robotics.

Master'S Degree, Engineering, A

Master's in Engineering

Master'S Degree, Engineering

Project Management

Bachelor'S Degree, Engineering

Maths , Physics & Chemistry

Schooling