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.
• 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.

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.
• 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.

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.
• 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.

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).
• 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.

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.
• 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.

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.
• 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.

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.

Master'S Degree, Engineering, A

Master's in Engineering

Master'S Degree, Engineering

Project Management

Bachelor'S Degree, Engineering

Maths , Physics & Chemistry

Schooling