Senior Oracle Apps Scmtechno Functional

Senior Oracle Apps Scmtechno Functional

Laxma Reddy Putta

Senior Oracle Apps SCMTechno Functional

SUMMARY:

Over 9 years of total IT experience and Over 8 Years of extensive Oracle E-Business experience in implementations, Upgrades and Customizations.

Have extensive technical and functional experience in Order management (OM), Inventory (INV), Purchasing (PO), Supplier Life Cycle Management (SLM),Account Receivables (AR), Account payables (AP) and General Ledger (GL) modules.

Good knowledge of Order to Cash (OTC), Procure to Pay (P2P) business flows.

Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, Reports 6i, XML Publisher, WebADI, Form Personalization, Shell Scripting, Sql*loader, Interfaces, Conversions & Workflow Builder.

Successfully completed 2 Full life cycles projects with Oracle Applications 11i (11.5.10) and 1 full life cycle in R12 (12.1.3).

Experienced in new implementation from legacy systems to Oracle EBS and have very good experience in Oracle API’s.

Expertise in Design and Development of Interfaces and Conversion programs to import data from various sources into Oracle Applications

Adept at development and customization of RICEFW (Reports, Interfaces, Conversions, Extensions, Forms Personalization and Workflows) objects

Extensive experience in developing reports using XML publisher 5.6.3/5.6.2, Reports 10g/6i/2.5.

Expertise in developing data integrators using WebADI.

Experienced in registering PL/SQL procedures, Reports, Forms, XML/BI Reports, and SQL*Loader scripts as concurrent programs in the Oracle Applications

Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts

Experience in SQL*Loader, UTL_FILE, Oracle Import/Export utilities, SQL Navigator, UNIX Shell scripting and WebADI.

Prepared Technical Specification (MD70) documents based on the (MD50) documents provided by the functional team.

Expertise in System Administrator and Application Developer responsibilities.

Ability to identify root causes of problems and consider both long and short-term impact of proposed solutions and develop workable solutions along with excellent communication and interpersonal skills.

Work Experience Summary

Burns and McDonnell, US

  • Oracle Applications Techno Functional Consultant

Duration:Mar-14 to till date

Location:Kansas City, Missouri

Project Details:

Oracle PTP/ SLM Implementation Project

Role / : / Techno Functional Consultant
Project Summary / : / Earlier BMCD used Equifax Austin Tetra application as a tool to onboard their suppliers. BMCD’s requirement was to retire Equifax and use Oracle SLM as a tool for supplier registrations and supplier maintenance activities.
Oracle Solution involved implementation of the following module on EBS R12.1.3. These modules were implemented on BMCD’s on premise EBS instance, which already had other modules related to Financials, Projects and SCM implemented.
  • Supplier Lifecycle Management (SLM)

Environment / : / Oracle Applications 12.1.3–(Oracle PTP, SLM,OM,PO,AP), Oracle 11g, PL/SQL, SQL*Loader, Shell Script, WebADI, TOAD
Responsibilities / :

Developed WebADI (Application Desktop Integrator) program to develop reports that would download supplier information and inactivate suppliers who are no longer doing business with BMCD.

  • Developed extract query to download the supplier data with which BMCD has not done any business over a period of time based on couple of parameters.
  • Extract query checks for open Purchase Orders and Open Invoices that have been created after the Transaction date entered in the Parameter.
  • Created six parameters to download the data based on these parameters.
  • Created Download Integrator and attached the query to the integrator.
  • Created the Integrator Layout and mapped the query columns to the layout.
  • Created staging table to upload the data from excel to the staging table as part of WebADI upload.
  • Created the upload Integrator and attached thePlsql package to Activate/Inactivate the suppliers using the public API AP_VENDOR_PUB_PKG.Update_Vendor.
  • Created the Integrator Layoutfor the upload of suppliers from the desktop to excel.
  • Created the concurrent program to send the suppliers records that are failed in the validation through the Email.
  • Supplier Activation/Inactivation report is captured in the output file of the concurrent program.
  • Created Menu for the Downloading or Uploading of Supplier data and the menu is assigned to “BMCD Supplier Management Administrator” responsibility.

Developed Conversion program to load the supplier attribute data into oracle from Equifax using the API POS_VENDOR_PUB_PKG.PROCESS_USER_ATTRS_DATA

Developed Price List Conversion Program.

Developed Item Conversion Program.

Developed PO Conversion Program.

Developed PO Requisition Conversion Program.

 Developed AP Invoice Conversion Program.

Developed concurrent program to update Safety Ratings for Suppliers using an automated program.

Prepared CV60’s, MD70’s and MD120 for the developed objects.

Interacted with the functional consultant for better understanding of the functionality of the objects and the exact requirement.

Kaycan, US

  • Oracle Applications Techno Functional Consultant

Duration:Apr-13 to Feb-14

Location:Alpharetta, Georgia

Project Details:

Kaycan Implementation Project

Role / : / Techno Functional Consultant
Project Summary / : / Kaycan has implemented new operating unit Kaytec USA and this project involves the development of new components to the new operating unit
Environment / : / Oracle Applications 12.1.1 – (INV, OM, AR), Oracle 11g, PL/SQL, XML/BI Publisher, SQL*Loader, Alerts, TOAD, Putty
Responsibilities / :
  • Developed Customer Conversion Program.
  • Developed Inbound Invoice Conversion Program.
  • Customized Pick Slip Report.
  • Developed Item Conversion Program to load the items from legacy system to Oracle EBS.
  • Developed form customization to restrict the Pick Slip Report to reprint from the tools menu.
  • Developed Event based alert to assign a category set and the category when a new item is created.
  • Developed pl/sql code to create the adjustments using the API for the invoice amount.
  • Prepared CV60’s, MD70’s and MD120’s for the developed objects.
  • Interacted with the functional consultant for better understanding of the functionality of the objects and the exact requirement.
  • Developed Triggers, Packages & Procedures.
  • Involved in testing the objects and preparing the test scripts.
  • Need to work closely with customer as well as our onsite counterparts in performing a detailed impact assessment on business.

Global Payments, US

  • Oracle Applications Technical Consultant

Duration:Jul-12 to Mar-13

Location:Alpharetta, Georgia

Project Details:

AP Direct Membership

Role / : / Technical Consultant
Project Summary / : / This project is to develop a custom module to develop interface between legacy system and oracle eBS, main objects are AR Invoice, AP Invoice, GL Journal , Customization of Customer Statement Report and few xml reports were developed
Environment / : / Oracle Applications 12.1.1 – (OM, AR, PO), Oracle 11g, PL/SQL, XML/BI Publisher, SQL*Loader, Shell Script, TOAD, Putty
Responsibilities / :
  • Involved in writing UNIX Shell Scripts for moving files from server to the email id provided in the concurrent program parameter.
  • SQL*Loader will fetch data from CSV files and insert into custom table.
  • Developed an Interface program to convert the Receivables (AR) invoice data from legacy system to Oracle Receivables using Auto Invoice Import Program
  • Customized standard Customer Statement report, implemented the bursting technology to send the output to the customers through Print, Mail, Fax
  • Customized Pick Slip Report.
  • Customized Packing Slip Report.
  • Developed PO Conversion Program.
  • Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation
  • Developed PL/SQL stored procedures, functions and triggers
  • Followed MD50 functional documents and designed the MD70 technical specifications, provided support for end users and documented the modifications
  • Did the unit testing for the objects that are developed

EPIB PRODUCT, US

  • Oracle Applications Technical Consultant

Duration:May-11 to Jun-12

Location:Enrich LLC, Alpharetta, Georgia

Project Details:

EPIB (enrich IT Procurement-in-a-Box)

Role / : / Technical Consultant
Project Summary / : / EPIB (enrich IT Procurement-in-a-Box) is a productized offering from enrich to achieve a rapid time-to-Market, and is built to address common requirements experienced at several of enrich’s clientele. This solution is built as a wrapper on top of Oracle’s IPROCUREMENT module (standard).
Environment / : / Oracle Applications 12.1.1 – (INV, PO, AP), Oracle 11g, PL/SQL, SQL*Loader, TOAD, Putty, Shell Script
Responsibilities / :
  • Developed Item Conversion Program.
  • Developed PO Conversion Program.
  • Developed PO Requisition Conversion Program.
  • Developed AP Invoice Conversion Program.
  • Developed Supplier Conversion Program.
  • Prepared CV60’s and MD120’s for the developed objects.
  • Interacted with the functional consultant for better understanding of the functionality of the objects and the exact requirement.
  • Involved in testing the objects and preparing the test scripts.
  • Extracted the ldt files and applied the same files in UAT environment for user testing.

Nuance, US

  • Oracle Applications Technical Consultant

Duration:Feb-12 to Jun-12

Location:Burlington,MA

Project Details:

Nuance-Equitrac Integration Project

Role / : / Technical Consultant
Project Summary / : / Nuance has acquired Equitrac and this project involves the migration of Equitrac objects (11.5.10) to Nuance (11.5.10) to a new operating unit.
Environment / : / Oracle Applications 11.5.10 – (OKS, AR, OM, INV), Oracle 11g, PL/SQL, SQL*Loader, TOAD, Putty, Shell Script
Responsibilities / :
  • Developed Outbound Interface and Inbound Interfaces.
  • Developed Oracle Service Contracts Conversion Program.
  • Developed Price List Conversion Program.
  • Developed Inbound Invoice Conversion Program.
  • Developed FedEx Interface.
  • Developed Items Conversion Program.
  • Customized Packing slip Report.
  • Prepared CV60’s, MD70’s and MD120’s for the developed objects.
  • Interacted with the functional consultant for better understanding of the functionality of the objects and the exact requirement.
  • Developed Triggers, PackagesProcedures.
  • Involved in testing the objects and prepared the test scripts.
  • Extracted the LDT files for concurrent programs; concurrent request set from dev environment and applied the same files in UAT environment for user testing.
  • Need to work closely with customer as well as our onsite counterparts in performing a detailed impact assessment on business.

Riso, US

  • Oracle Applications Technical Consultant

Duration:Jul-11 to Jan-12

Location:Burlington,MA

Project Details:

Riso-Lacrosse Integration Project

Role / : / Technical Consultant
Project Summary / : / Riso is the leading manufacturing and service assurance Company for color printers. They have implemented 11.5.9 version of oracle application. This project involves the integration of the Riso and Lacrosse Systems.
Environment / : / Oracle Applications 11.5.9 – (AR, OM, INV), Oracle 11g, PL/SQL, SQL*Loader, TOAD, Putty
Responsibilities / :
  • Developed Outbound Interface and Inbound Interfaces.
  • Prepared MD70’s and MD120’s for the developed objects.
  • Interacted with the functional consultant for better understanding of the functionality of the objects and the exact requirement.
  • Developed Triggers, Packages & Procedures.
  • Involved in testing the objects and prepared the test scripts.
  • Extracted the LDT files for concurrent programs; concurrent request set from dev environment and applied the same files in UAT environment for user testing.
  • Need to work closely with customer as well as our onsite counterparts in performing a detailed impact assessment on business.
  • Updated the Technical Design Documents as per the changes made

Oracle Corporation, US

  • Oracle Applications Technical Consultant

Duration:Nov-09 to Jun-11

Location:Oracle, California

Project Details:

Oracle EMEA Localization

Role / : / Technical Consultant
Project Summary / : / Oracle Corporation (NASDAQ: ORCL) is a multinational computer technology corporation that specializes in developing and marketing enterprise products — particularly database management systems.The corporation has arguably become best known due to association with its flagship product, the Oracle Database. The company also builds tools for database development and systems of middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software.
Oracle EMEA decided to consolidate all existing extensions, which have been, build locally by different EMEA country consulting organizations and to migrate them to R12, leveraging standard development processes.
Environment / : / Oracle Applications 11.5.9 – (AR, OM, INV), Oracle 11g, PL/SQL, SQL*Loader, TOAD, Putty
Responsibilities / :
  • Provided support for objects in Oracle Financials and SCM modules.
  • Involved in providing the support for Israel Localization objects.
  • Extensively worked on SR'S and ER'S for Israel Localization objects.
  • Updated the Technical Design Documents as per the changes made.
  • Created patches and released them to MOS (My Oracle Support) as per the requirement.
  • Involved in developing the value sets and concurrent programs.
  • Interact with the functional consultant for better understanding of the issues.
  • Interact with the clients through web conference for more information regarding the issues.
  • Involved in testing the objects in UAT instance.

Involved in developing the ldt files for concurrent programs, data definitions and form personalization's

SFI, INDIA

  • Oracle Applications Technical Consultant

Duration:Mar-08 to Apr-09

Location:Hyderabad, India

Project Details:

Singapore Food Industries

Role / : / Technical Consultant
Project Summary / : / Since its incorporation in 1973, Singapore Food Industries Limited is the largest integrated food company in Singapore, with a wide portfolio of food products and services. With more than thirty years of footprint in Singapore, SFI has grown in size, diversification and market reach, from a food raw material supplier, to food distribution, to food catering, and to food manufacturing and processing. The expansion and diversification led SFI to be listed on the Main Board of the Singapore Exchange in November 1999.
Environment / : / Oracle Applications 11.5.10.2 – (AR, OM, INV, PO), Oracle 9i, PL/SQL, SQL*Loader, TOAD, Putty
Responsibilities / :
  • Converted Invoices from LegacySystem into Oracle Receivables using Auto Invoice Import program.
  • Created SQL*Loader control programs and PL/SQL validation procedures to execute along with AR Invoice Interface (AR) programs to support the interface requirements.
  • Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
  • Created a process for order import using standard API for validating data and update the base tables.
  • Run Journal Import in General Ledger (GL) to load the data into Oracle application tables.
  • Prepared the TDD (Technical Design Document) based on the FDD (Functional Design Document).
  • Developed BI Publisher reports.
  • Developed XML templates according to customer’s requirements and required format based on Oracle.
  • Developed RICE components.
  • Involved in creating parameters in data template file according to the requirement.
  • Primary point of contact with the client for technical issues.
  • Analyzing the change requests whether the scenario is feasible and helping the team in incorporating the Change Requests.
  • Responsible for fixing of various Day-to-Day as well as Development/ Enhancement Issues.
  • Responsible for developing and reviewing the issue resolution documents.

Thumman’s phase1 SE Accelerator, India

  • Oracle Applications Technical Consultant

Duration:Sep-07 to Mar-08

Location:Hyderabad, India

Project Details:

Thumman’s

Role / : / Technical Consultant
Project Summary / : / It is Oracle Manufacturing Implementation project with the objective of Creating and Maintaining a Master Sales Order where in the user on the phone queries the Master Sales Order already existing for a given customer and copies it to an operational sales order, each time makes relevant changes to the Items/Quantities and books the order.
Environment / : / Oracle Applications 11.5.10.2 – (AR, OM, INV), Oracle 9i, PL/SQL, SQL*Loader, TOAD, Putty
Responsibilities / :
  • Created SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface programs to support the interface requirements.
  • Designed and developed complete Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
  • Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
  • Created a process for order import using API for validating data and update the Base tables.
  • Defined Descriptive flex fields necessary for report.
  • Worked on Data conversion project for extracting data from INV.
  • Run Journal Import in General Ledger (GL) to load the data into Oracle application tables.
  • Prepared Technical Specification (MD70) Documents.
  • Designed and developed Reports in OM: (Back Order Detail Report, Cancelled Orders Report and Shipment not Invoiced Report).

Clopay, India

  • Oracle Applications Technical Consultant

Duration:Jan-07 to Sep-07

Location:Hyderabad, India

Project Details:

Clopay

Role / : / Technical Consultant
Project Summary / : / Clopay Building Products Company is the nation's largest manufacturer of residential garage doors and a leading supplier of industrial and commercial sectional doors. Our installation services business, Clopay Service Company, sells, installs and services manufactured fireplaces, garage doors, flooring, kitchen and bath cabinets and related products. Clopay Plastic Products Company is a leader in the development and production of embossed barrier and breathable plastic films for the healthcare and hygienic markets as well as specialty graphics arts films.
Environment / : / Oracle Applications 11.5.10.2 – (AR, OM, INV), Oracle 9i, PL/SQL, SQL*Loader, TOAD, Putty
Responsibilities / :
  • Developed RICE components.
  • Involved in preparation of various documents like MD070, MD120.
  • Created and developed Staging tables for Order-To-Cash process implementation.
  • Imported the bulk of Journal Entry Transactions into GL table and successfully created the Journal Entries in GL.
  • Customized forms using custom.pll.
  • Added new menus, responsibilities, functions, concurrent program etc.

Juniper, India