Project Oracle

Pavan Jakka

Oracle Applications Techno-Functional Consultant

Phone No: 313-***-****

Email: **********@*****.***

Summary:-

. Around 8 years of experience in the IT mainly Implementing, Merging and

Up-grading of Oracle Applications11i/R12 (Financial and Supply Chain

Modules).

. Extensively worked on Oracle Reports 6i/9i, Oracle Forms 6i/9i, PL/SQL

Packages, Procedures, Functions, Custom PL/SQL APIs, Workflow builder 2.6

and SQL Loader.

. Experience in Procure to Pay, Order to Cash and Supply Chain business

flows.

. Good understanding of data flow in the different modules of Oracle

Applications EBS.

. Expert in designing and developing EDI: - INI, POO, POCO, INO, POI, POCI

transactions.

. Experience in writing documents like MD050, MD070, and CV040.

. Expertise in SLA implementation and Configuring Accounting rules in

Oracle R12.

. Expertise in Converting Bank and Bank Accounts for Suppliers.

. Expertise in Adding Custom validation rules for Invoices and payments in

Oracle R12.

. Expert in developing XML/BI publisher reports.

. Expertise in jdeveloper and development of custom OAF pages.

. Experience in OA Framework, Customization and Personalization of JSP

pages.

. Experience in enabling XML messages to Trading partners using Oracle XML

Gateway module.

. Recent Experience in Oracle Modules AP, OM, PO, AR, GL, XML Gateway,

Ecommerce Gateway and PA.

. Experience in developing Reports, Interfaces, Conversions and Extensions

(RICE).

. Expert in troubleshooting and fixing the bugs, creation of SR/TAR with

metalink, obtaining patches from oracle support and applying patches with

coordination of Apps DBA.

. Strong knowledge in ETL and Reporting and expertise in OBIEE.

Education:-

Under Graduation (B-Tech) :- MGIT (JNTU), India.

Graduation (Master's) :- Wayne State University (Michigan), USA

(2006).

Graduation (Master's) :- University of Utah (Salt Lake City), USA

(2006-2008).

Tools:-

Programming Languages C, C++, Assembly Language, Matlab, SQL, PL/SQL

and UNIX

Database MySQL, Oracle

Operating Systems Windows 98/XP/7/8, MacOSX, LINUX

GUI / TOOLS Developer (Forms 6i/9i, Reports6i/9i), JDeveloper,

XML/BI Publisher, XML Message Designer, Oracle

Workflow builder

Version Control Harvest, SVN, PVCS, STAT, Kintana and

SharePoint

Project Details:-

Oracle Applications Techno-Functional Consultant

Amazon, Inc, Seattle, WA.

Aug'2014 -Till Date

Amazon.com, Inc. is an American electronic commerce company with

headquarters in Seattle, Washington. It is the largest Internet-based

company in the United States. Amazon.com started as an online bookstore,

but soon diversified, selling DVDs, VHSs, CDs, video and MP3

downloads/streaming, software, video games, electronics, apparel,

furniture, food, toys, and jewelry. The company also produces consumer

electronics-notably, Amazon Kindle e-book readers, Fire tablets, Fire TV

and Fire Phone - and is a major provider of cloud computing services.

Project description:-

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. As part of

this launch Amazon would enter into Co-op agreements with the Vendors which

will be signed and available in Contra COGS Tool for calculation of Co-op

to be billed to the Vendors.

Role and Responsibilities:-

. Documented MD050 document for the Contra Cogs for NL project and

signed off by Project manager.

. Designed and Documented Unit test cases for all the business cases for

the Users to sign-off.

. Developed PLSQL Routines for loading AR Invoices and Customers Related

Information into Oracle R12 from 3rd party Applications.

. Helped Users for "Contra Cogs Go live" in the User acceptance testing

phase.

. Designed and developed Contra Cogs Billing import program to create AR

invoices based on business requirements.

. Create Customers in Oracle R12 if not existing using Customer

Interface.

. Create AP invoices after Accounting in AR if the same Customer is a

Vendor based on Business Requirements.

. Create BI Publisher reports for the following Document Types and send

Email to the respective users:-

> Invoice

> Credit memo

> Debit note

> Request for Credit

. Developed SQL - Loader script to load the Billing file from upstream

to Oracle Staging tables.

. Designed and developed Email matrix table to send specific templates

to specific user groups.

. Designed and Developed Booking import program to import Journal

Summary details from 3rd parties to GL interface.

Oracle Applications Techno-Functional Consultant

Bechtel Corporation, Phoenix, AZ.

Oct'2010 -July'2014

Bechtel (BEK Corp) is known for engineering, construction, and project

Management Company. Our diverse portfolio encompasses energy,

transportation, communications, mining, oil and gas, and government

services. We currently have projects in dozens of locations worldwide, from

Alaska to Australia.

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.

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

. Developed Conversion program for Legacy Invoices into Oracle R12

instance from Bechtel Custom Application.

. Developed Interface to Create Employees from SAP to Oracle R12 based

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

. Developing Self- Service based web applications for OBARS using OA

Framework.

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

. Developed General Ledger Trial Balance, Multi-Country Statutory and

Bechtel Aging reports using BI publisher reporting.

. Designed and developed Custom ERP modules like OBARS and OIR based

business requirements to meet Projects Costing and Reconciliation.

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

. Developed PLSQL Wrapper packages to Load Bank data into Oracle AR

Tables (Custom Auto lockbox Process).

. Developed Complex Oracle R12 Statutory Reports using BI Publisher

based on business requirements.

. 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 custom application called Open Item

Reconciliation (OIR) in Oracle Applications 11i to reconcile all the

major Global Bechtel Accounts.

. Develop Oracle Reports and convert focus based billing application

data into Oracle 11i.

. Design and develop various billing reports using XML Publisher and

Reports 6i.

. Designed and developed XML Publisher Reports like Invoice template,

Sales Order template and Billing reports.

Oracle Applications Technical Consultant

Cisco Systems, San Jose, CA.

Feb'2010 -Oct'2010.

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.

Oracle Apps Techno-Functional Consultant

ADT Security Systems, Boca Raton, FL.

Aug'2009- Jan'2010

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.

> Rule 4 :- Navigation to custom fields based on validation on

standard fields.

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

Oracle Apps Techno-Functional Consultant

ATT Communications, Alpharetta, GA

July'2008- Aug'2009

The AT&T network includes extensive wireless and wired access capabilities,

as well as one of the world's most advanced and powerful IP backbones. 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.

Teaching Assistant

University Of Utah, Salt lake City, UT.

Dec'2006 -June'2008

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

Contact this candidate