Venkata VattikuttiOracle E-Business Suite

Phone: 217-***-****

: abo1h4@r.postjobfree.com

Resumes ID: 48966

Location: Boston, Maine

Posted: 04.13.2012

Resume Details:

SUMMARY:

Software professional with 8 years of IT experience in Technical and Functional aspects of E-Business Suite across the modules of Supply Chain, Finance, Manufacturing & CRM.

Involved in Customizing, Implementing and Deploying Oracle E-Business Suite solutions.

Developed applications using VB.net and MS Access as database in academic projects.

Extensive experience in implementing and extending Oracle Applications with strong focus on PL/SQL, Oracle Application Framework, Forms, Reports, BI/XML publisher, Data Migration, Java, SOA and Workflows.

Functional responsibilities undertaken includes Requirement gathering, Gap Analysis, Application Design, Configuration, Root Cause Analysis, Impact Analysis and Production Support

Strong Knowledge in Oracle Order to Cash (O2C) and Procure to Pay (P2P) life cycles.

Experience with Supply Chain Management (SCM), Finance modules (GL, AP, AR, FA), Customer Relationship Management (CRM) and Oracle Self-Service Human Resources (HR) of Oracle Apps

Worked extensively on Fixed Assets, iProcurement (iProc), Purchasing (PO), Order Management (OM), Inventory (INV), Bill of Materials(BOM), WIP & Routing, General Ledger (GL), Accounts Payables(AP), Oracle Sales Compensation (CSN), Service Contracts (OKS), Trading Community Architecture (TCA) strong understanding of table structures of the above modules and Application Object Library (AOL)

Experience in doing Personalization and customization using OA Framework. Good experience on Open Interfaces (inbound and outbound interfaces) and APIs in Fixed Assets, Supply Chain (OM, INV, TCA), Manufacturing, Procurement, GL, AP, Oracle Purchasing.

End to end design and development exposure, from presentation layer (JSP, Servlets, and JavaScript), business layer (EJB, JMS, Web services, Forms) to database layer (Oracle)

Technical expertise and strong background in Data Migration and conversion of legacy data into oracle Applications using SQL* Loader, ETL.

Experience in Multi org environment.

Strong Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, Functions and Packages, UNIX shell scripts to fit the business requirements of Oracle ERP Applications.

Strong working Experience in RDBMS - Oracle 9i/10g/11g, Query Optimization and Analysis, performance tuning using Explain Plan and TK Prof Trace Files.

Experience in creating BR, MD and TE documents with in Oracle AIM methodology.

Active team player and posses strong analytical skills. Have excellent communication, organizational and presentation skills.

TECHNICAL SKILLS:

Middleware

Oracle Fusion Middleware 10g/11g, Oracle SOA Suite 10g/11g

Application Servers

JBoss, Apache Tomcat, MS IIS, Oracle Application Server 10g/11g, Oracle BEA J2EE Web Logic Server

ERP

Oracle 11i/11.5.10/11.5.10.2 E-Business Suite, Oracle E-Business Suite R12.0.

Languages

PL/SQL, Java/J2EE, JSP, Servlets, JDBC, C, C++, XML, XSD, XPath, XSLT, HTML, Visual Basic

IDEs

JDeveloper 10g/11g, Eclipse, SQL Developer, TOAD 8.0/9.0/Professional, Text Pad, Edit Plus

Scripting

UNIX shell scripting, JavaScript, VB Script

Operating Systems

UNIX, Sun Solaris 9.0/10.0, Windows 95 / 98 / NT / 2000 / XP / Server 2003/ Vista

Databases

Oracle 9i/10g, Oracle 11g

Source Control

PVCS, VSS, CVS, Subversion (Tortoise SVN), Perforce

ETL Tools

SQL*Loader, Oracle Forms and Reports 6i/10g, Data Loader

Project Management

Oracle AIM Methodology

PROFESSIONAL EXPERIENCE:

Akamai Technologies, Boston, MA OCT 2011 – Present

Oracle E-Business Suite Consultant

Project: Fixed Assets New Tax Book

Implementing of New Tax Book in the Fixed Assets Module. This book will be used as new tax book to keep state and federal taxes separate. Project implementation helps them save millions of dollars

Responsibilities:

Analysis, Design & Development of solution.

Interacting with the business team to provide the best possible technical solution.

Working with Oracle Support for Issue resolution and Bug Fixes.

Analyzed the Fixed Assets schema to design the best possible solution.

Creating the Technical design document and Unit Testing.

Design and Develop the complex SQL Queries & API’s.

Developed ADHOC Queries and Reports for Users to check status at various levels.

Providing Unit Test Results for the components designed and developed.

Environment: Oracle E-Business Suite R12/R11.5.10, Oracle JDeveloper 9i, Oracle Application Framework (OAF), PL/SQL,, Oracle 11g, TOAD 10.5, Windows XP, Perforce.

AT&T, Plano, TX AUG 2010 – SEP-2011

Oracle E-Business Suite/Apps Tech - AOL, Forms Manager

Project: Various Projects in Supply Chain & Direct Fulfillment

Implemented National Retailers Return Systems on the Oracle E-Business Suite Platform part of Direct Fulfillment; this saved around 20 Million dollars for ATT in returns processing from retailers. Design and Develop custom solutions in critical Oracle iProcurement Implementation

Responsibilities:

Development of Oracle SOAP API for validating the external data from a web service.

Involved various other customizations and report development which are part of Direct Fulfillment.

Created Custom solutions around the Receiving Interface and Requisitions of the iProcurement Implementation.

Application maintenance. Provided fixes to production issues under support.

Analyzed and Designed the DB schema using Oracle database to include Header, Lines and Approvers table in all the modules Inventory, Order Management and Purchasing.

Developed BI/XML publisher reports in DF & Purchasing Modules.

Creating the Return Orders and validating the data for testing purposed in OM.

Design of the components with help of MD 70 design document.

Design and Develop the complex SQL Queries, Reports, Oracle & Java API’s.

Developed ADHOC Queries and Reports for Users to check status at various levels.

Interacting with the business team to provide the best possible technical solution.

Providing Unit Test Results for the components designed and developed.

Environment: Oracle E-Business Suite R12/R11.5.10, Oracle JDeveloper 9i, Oracle Application Framework (OAF), PL/SQL, Oracle Forms & Reports 6i/10g, Java, JSP, OAS,Oracle 10g/11g, TOAD 8.0/9.0, Windows XP

Sony DADC, Terra Haute, IN MAR 2010 – JUL 2010

Oracle Supply Chain - PLSQL& Forms Consultant

Project Name: Central Order Management

Designed new interface based on Java/J2EE for the existing Oracle Forms Application. There are moving from Oracle Forms to Java based application for maintaining Orders, Inventory and Purchasing of the business.

Responsibilities

Provide cause and impact analysis of the components designed.

Analyzed the DB schema in Oracle database for Header, Lines and Approver tables in all the modules Inventory, Order Management and Purchasing.

Creating the Purchase Orders, Requisitions and BOM modeling for testing and configuration.

Setting up employees and roles in the Oracle Self Service module.

Design of the various components using MD70 design document.

Design and Develop the complex SQL Queries for BOM, Inventory and Orders.

Developed ADHOC Queries and Reports for Users to check status at various levels.

Interacting with the business team to provide the best possible technical solution.

Composing and testing the business rules for the components designed.

Environment: Oracle E-Business Suite R12/R11i, Windows XP, PL/SQL, Oracle Forms 10g, Java, JSP, OAS,Oracle 9i, TOAD, Windows Server 2003.

Verizon, Irving, Texas SEPT 2008 – MAR 2010

Sr. Oracle eBusiness Suite/Integration Consultant

Responsibilities:

Developed code for maintenance activities in DEV environment, code movement to QA and support testing by the QA team

Analyzed and Designed the DB schema using Oracle 10g database to include Header, Lines and Approvers table in all the modules

Worked with a team of 9 personnel for the development of the database, procedures, functions, SQL Queries etc.

Responsible for the dealing with the problems, bug fixing and troubleshooting.

Customizing the various oracle components like forms, reports and workflow.

Application maintenance. Provided fixes to production issues under support.

Description: In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, collections, functions, collections, user defined data type, procedures etc

Specialized in customization, interfaces, extensions, ADHOC reports and queries in SQL and PL/SQL etc especially in ERP and SCM modules.

Exceptionally good and experienced in handling the problem and troubleshooting.

Excellent communication, organizational and presentation skills

Environment: E-Business Suite, Solaris OS(Unix based), Windows XP, PL/SQL, SHELL SCRIPT, Java/J2ee, JSP, JDBC, Oracle Forms and Reports, Oracle 9i, Workflow Builder, TOAD, Oracle ADF, Oracle Application Server, SQL* Plus, Toad, Text pad.

Emerson Process Management, Minneapolis, MN FEB 2008 – JUL 2008

Sr. Oracle Technical Team Lead (PL/SQL, Forms, Reports & OAF)

Project: Joint Financial Implementation

Implementation of Oracle financial modules like General Ledger, Account Payables and Account Receivables, Fixed Assets and Oracle Purchasing. Some of my responsibilities in this implementation include.

Responsibilities:

Development of code for financial modules in DEV environment, code movement to QA and support testing by the QA team.

Provide cause and impact analysis of the components designed.

Creating the AP Payments, AR Receipts, AP Invoices, AR Invoices and Fixed Assets based on the business rules defined.

Developed FA Register report to show the FA activity in the system.

Developed ADHOC reports for consolidating the payment batches in the AP Payments.

Design, Development and Delivery of the components related to Check Printing, Invoice Printing (Oracle Reports), Remittance Advice (BI/XML Publisher), AP with Holding Tax customization.

Generating Automatic Payments file for wire transfer and importing Bank Statements to Cash Management Module.

Customization to existing PA account generator and development of Trail Balance Report.

Interacting with the business team to provide the best possible technical solution.

Composing and testing the business rules for the components designed.

Involved in the personal and technical training activities.

Mentoring the junior team members and help them in on time delivery of the assigned tasks.

Environment: Oracle E-Business Suite 11i & R12, Solaris OS (Unix based), Windows XP, PL/SQL, Oracle Forms and Reports and XML Publisher, OAF, Java, JSP, XML, XSL, OAS,Oracle 10g, Oracle AQ, Workflow Builder, TOAD.

Emerson Process Management, Boulder, CO OCT 2007 – FEB 2008

Sr. Oracle PL/SQL & Apps Developer

Project: Micro Motion Inc.

Implementation of Oracle Advanced Pricing Module in the Existing Oracle E-Business Suite for Micro Motion Inc division of Emerson Process Management.. Some of my responsibilities in this implementation include.

Responsibilities:

Design and develop various components for customizing the Oracle Advanced Pricing & Configuration modules.

Analyzed and Designed the DB schema using Oracle 9i database to include Header, Lines and Approvers table in Oracle Pricing module.

Development of programs for Price list, Factor List, Value sets, pricing Context DFF and several other customizations.

Creating and testing the various pricing scenarios in the business environment.

Creating Forms (Order Management) and Reports to accommodate the business functionality of the MMI.

Prepare high level design documents, DLD and User manuals.

Providing User Manual for the clients on the existing changes and customizations.

Customizing and creating the JSP pages in oracle.

Composing and testing the business rules for the components designed.

Involved in the personal and technical training activities.

Environment: Oracle E-Business Suite 11i, Oracle Forms, Solaris OS (UNIX based), Windows XP, PL/SQL, HTML, Java, JSP, XML, Oracle 9i, Oracle AQ, TOAD.

Emerson Process Management, Knoxville, TN OCT 2006 – SEPT 2007

Oracle E-Business Technical Consultant

Project: MHM Implementation

Implementing Oracle E-Business Suite 11.5.10.2 for MHM division of Emerson Process Management into their single global instance. In this project we have implemented wide range of modules in oracle across ERP, SCM, HCM, PA and CRM tracks. My responsibilities in this implementation include.

Responsibilities:

Development of Inbound and Outbound Interfaces between new and legacy systems.

Analyzed and Designed the DB schema using Oracle 9i database to include Header, Lines and other table in all the modules

Creating Forms and Reports to accommodate the business functionality of the MHM.

Prepare high level design documents, DLD and User manuals.

Setting up employees and roles in the Oracle Self Service module.

Involved in migrating the data from the legacy systems to oracle for Parties, Customers, AP Invoices, AR Invoices, Install Base, OKS Contracts, Purchase Orders, GL Periods, Quotes, Projects, Items and Bill of Materials.

Developed workflows in different modules like PO approval, AP Invoices.

Developed a report for MHM Commission Approval for sales representatives.

Composing and testing the business rules for the components designed.

Worked on the Oracle Advanced Pricing Module for uploading Pricelist of Various components.

Created interfaces for BOM, Routing, WIP and Items.

Involved in functional setups of OM,PO, PA, INV, BOM, WIP and Routing

Building an OA Framework screen to import an XML file and PL/SQL logic to validate and create sales orders using the OM public APIs

Involved in the personal and technical training activities.

Personalization of components using Oracle Forms Personalization and OAF.

Environment: E-Business Suite [R11i (11.5.10)], Solaris OS(Unix based), Windows XP, PL/SQL, SHELL SCRIPT, Java/J2ee, Oracle 6i Forms and Reports, Oracle Discoverer, Oracle 9i, Workflow Builder, TOAD, Oracle Application Framework, Oracle Application Server, Oracle 11i Quoting Module.

Motorola - Oracle Development and Deliver DEC 2005 – MAY 2006

Oracle Techno-Functional Trainee (SCM, CRM, Finance)

Oracle Sourcing is highly customized application to suit the requirement of Motorola. The project focused on the functional set up, development and customization of reports and packages to suit the specific business requirements of the Connected Home Solutions sector of Motorola. The project dealt with almost all functional as well as technical activities in Order-To-Cash (O2C) cycle and functional implementation of Service Contracts. The project included modules Order Management (OM), Inventory (INV) and Service Contracts (OKS), Customer Relationship Management (CRM) in a Multi Org environment. My responsibilities in this implementation include.

Responsibilities:

Performed functional set ups.

Was part of the team implementing the Order-To-cash functionality of Oracle E-Business suite including Order Management (OM), Inventory (INV).

Configured the necessary set ups which are essential for the functioning of Service Contracts.

End to End Cycle testing for Service Contracts.

Closely associated work with order lines, deliveries, shipments and item reservations.

Developed PL/SQL procedures, triggers, Reports.

Developed interfaces that shift data from the oracle base table to a staging table before posting into a common financial system.

Customizing the validations and personalizing the OA Framework according to business rules.

Used OAF to improve the look and feel of self service components.

Unit testing and Test plan preparation.

Provided support for component and system Integration testing.

Involved in system administration functions like creation of users, setting up responsibilities, defining value sets, creation of executables and registration of applications.

Environment: Oracle E-Business Suite 11i, SQL, PL/SQL, Java/J2ee, Oracle 9i, TOAD, Oracle Forms and Reports 6i, Oracle Application Framework, Oracle Developer2000.

VJ Info Tech, Hyderbad, India SEPT 2003 – DEC 2005

Software Programmer & Trainee

Design and Development of supply chain solutions software for the customers in enabling their business process

Responsibilities:

Configuring the system and set ups for full cycle implementation of the solutions.

Developed mapping documents for the source application with data sheets.

Setup Order Management module (OM) to enable creation and booking a sales order with credit checks and holds, applying discounts price list, ship confirm deliveries, completing Auto invoice in receivables for getting Transactions and issuing receipts.

Defined Price list using qualifiers, modifiers and formulas along with designing new pricing contexts and attributes.

Identifying the suitable hardware for the software implementation.

Defined items and assigning to Price Lists.

Developed SQL, PL/SQL stored procedures, C & Visual Basic.

Unit testing and Test plan preparation.

Provided support for component and system Integration testing.

Environment: SQL, PL/SQL, C, C++, Java, Visual Basic, Oracle 8i

TRAINING & CERTIFICATIONS:

Certified in Oracle Developer Foundation & Java Programming

Certified in Oracle PL/SQL, Forms & Reports

ACADEMIC QUALIFICATIONS:

Bachelors in Engineering Osmania University, Hyderabad, India

Contact this candidate