Oracle Customer Service

Professional Summary:

Total ** years of Oracle Applications experience in Oracle Order Management, Procure to Pay, Order to Cash, Record to Report, Oracle Financials, in design development, implementation and production support

Experience in Integration, support and maintenance of Oracle E-Business Suite with the 3rd Party Systems.

Implementation of solutions to Business problems with a purpose to prevent once & for all, with a proactive stable efficient, realistic, mutually agreeable one-time solution with having excellent reputation across different global clients onsite/offshore model. (Reference of LinkedIn profile recommendations) https://www.linkedin.com/in/papayyasastrychalla/

Technical Skills:

Oracle Applications Tools Experience/Exposure:

Discoverer, JDeveloper, Workflow Builder/PL SQL, OBIEE 11.1.1.7, XML/BI Publisher, UPK, Java Web Services, Oracle Application Server 10.x/11.x, Oracle Concurrent Managers, Oracle Forms /Reports developer 10.x/OAF/ADF

Oracle Applications Modules Experience/Exposure:

Oracle EBS (11i and R12) Finance, Inventory, Supply Chain, Discrete/OPM MFG modules: GL, AR, AP, FA, Projects, INV, WIP, BOM, PO, OM, Advanced Pricing, WMS, Install Base, Service Contracts, TOAD, SQL Developer, XML Publisher, High Jump, Pitney Bowes Software, Pick 2 Light systems for Shipping, QlikView, Endeca integration with EBS, Oracle ERP Cloud, SCM Cloud,OM,CPQ,GOP, Plan to Produce cloud in Oracle Hybrid Cloud E-Business Suite environments

Education: Bachelor’s Degree in Mechanical Engineering 1993-97 Sri Krishnadevaraya University Anantapur India

Certification: PMI PMP® Certification # 1617337. (Grant date: 06/15/2013 Expiration Date: 06/14/2019)

Professional Experience:

Client Universal Furniture High Point NC

Employer ZVST Cloud Technologies

Dates Dec 17 – Till Date

Role Oracle Applications Developer/Analyst

Modules/Domains: Oracle E-Business Suite Release 12.1.3, Oracle E-Business Suite Release 12.2.6, GL, AR, AP, OM, WIP, BOM, INV, Costing, QP (Advanced Pricing), WMS, Loft ware Labelling, Oracle CPQ Cloud, Oracle Cloud integration (SOA)/BI Cloud/WebCenter Portal, BI Publisher

Project Description: Universal furniture is part of Samson Holding Ltd.'s portfolio which has made recent acquisition of Wisconsin based Kohler company which acquired Baker furniture. This acquisition also involved Hickory and Hildebrand Warehouse locations. These locations need Oracle Applications System to perform the daily Business transactions.

Participate in the analysis and implementation of computer systems and development of specifications based on a solid understanding of IT project life cycle stages.

Involved in Production Support ticket issues resolution & work on Oracle development of all Sales Orders statuses extracts along with Advanced Pricing adjustments extract for cross functional departments requirements

Oracle Inventory Material Account Distribution details seeded report customizations

Label design, format and setup for EDI Customer specific requirements

conversion of Oracle Reports to Oracle XML Publisher reports

Design and development of Items categories report for displaying the explosion of Kit & configured items

Work with the manufacturing modules of Oracle EBS (OM, Advanced Pricing, BOM, WIP, Inventory) and moderately complex applications in accordance with established project schedules in an Oracle E-Business Suite R12 applications environment to provide some end-user applications support by assisting users with functional technical questions resolutions and enhancement requests completion.

Design Development of Custom User Interface for Picking enhancement project using Oracle Forms, JDeveloper OAF/ADF.

PLSQL API for Order modifications and applications of Sales Order Holds

Oracle CPQ Cloud Integration with R12 Oracle EBS.

Oracle SOA Web services design and development using JDeveloper using XML, XSD, XPATH etc.

Oracle Reports design and development using Oracle Report Builder, BI publisher, SQL, PLSQL.

Employer Velcro USA Inc. Manchester NH 03110

Dates Nov 09 - Oct 17

Role Oracle Applications Developer/Analyst

Modules/Domains AR, AP, GL, OM, INV, PO, AP, FA, WIP/BOM, WSH, WMS, Labelling,3rd Party HJ, Pitney Bowes, Software, Pick 2 Light Systems for Shipping, Process Weaver’s TMS product xCarrier, Pitney Bowes

Responsibilities:

Development of Oracle Forms, Reports using Oracle Report Builder, Discoverer and XML Publisher reports.

Oracle PLSQL programs design and development using Oracle Applications seeded PLSQL API, Unix Shell Scripts

Oracle WMS Label configurations and integration with Loft Ware Labelling system

Functional Technical Analyst to implement order capture flows with Oracle setups for order fulfillment flow configuration that Oracle Order Management facilitates, with setup of Order transaction types, document sequence, order import, hold setup, that enable these flows. perform Oracle Inventory setup steps that support Oracle Order Management, create sub inventories, units of measure, items, perform required Oracle Receivables setup steps, creating customers, payment terms, and territories, define credit checking, Multiple organization access control (MOAC) for Oracle Order Management.

Part of Implementation of EDI setup, upgrade from legacy EDI to Soft share in loading purchase orders electronically into Oracle Applications to load the sales orders, with ASN setups using Soft share, EDI Customer specific UCC label Implementation designs, rollouts, Shipping exceptions defined for EDI specific customers by designing and implementing custom rules to enforce High Quality Shipments to Customers

Implementation of Pilot test to demonstrate internally the real time reporting benefits, OTBI, info tiles, info lets, Configuring Oracle SCM Cloud modules, Oracle Global Order Promising Cloud module, Oracle Plan to Produce with Oracle SCM and IOT cloud module

Map oracle OTC with Standard Items, Ship Only Lines, Bill Only Lines, Drop Shipment setups, IR-ISO flow, Back-To-Back Orders Buy, Make,Sales Agreements setups with Blanket Agreement to Blanket Releases, Negotiation or Quote flow, Quote to Order Flow configuration, Shipping Execution Setups .Functional Setup involved with features and capability to set up of mfg. operations in order entry phase, Incorporated Sales Key features as a system capability for configuring flexible response unit which allows to get quotes or place orders online for never before produced items.

Implemented a solution to allow order entry using configurable items by mapping configure to Order Business Flow model using CTO configurator for ATO model, ATO option Class, kit type of options, mapping with BOM routing creation.

Implementation of Oracle Basic Pricing setups, profile options like QP Pricing Transaction Entity for procurement and Order Management with setup and defaulting of Price Lists, Secondary Price List in single currency specific to Customer price. Pricing API’s are used to update the price increases periodically during Christmas.

Design the Price list maintenance for maintaining price for Promotional period of items, regular period of items to maintain different prices, define the price list for corporate customer for bulk deals for customer delight.

Implement complex pricing situations for a range of Business Requirements, implement multiple currency price lists that enable global pricing, setup of Oracle Advanced pricing, Range and Point breaks, create GSA Price List, price list setup and use with pricing lines to define item prices or item category prices, price breaks, modifiers, price books setups etc.

As a Project Leader: Building strategic initiative and tactical steps designed in alignment with Organization goals to achieve realized custom projects for successful implementation via Technical, Functional best solutions in either Oracle Applications modules or 3rdParty Applications, to solve a Business problem right away in desired short span. These intended custom projects deal with preventing the problem as best of breed solutions rather than dealing with the problem. Some of successfully implemented projects module wise are described below in different roles. I lead the offshore onsite team with an example by demonstrating High Professional excellence in many daily production robust designs with stable resolutions.

As a Project Leader design, configure, implement Pick-to Light systems integration with Oracle Applications, designed the inbound, outbound interface to and from the Pick 2 Light systems trigger printing of Labels via Loft ware. Streamlined the Pick 2 light upgrade, support, maintenance.

As an Oracle Solution architect involved in Implementation setup of Oracle shipping exception rules to eliminate delivery shipments with missing product shipment specifications incurring fines. Designed the implementation rollout of custom project consisting of EDI specific customers and customer specific rules and thus these rules are applied via Custom pll to apply during ship confirmation thus avoiding missing information and reducing the probability of fine to almost 99%.EDI Customers have different shipping rules defined which are mandatory shipment labelling requirements i.e. different barcode labelling specification standards (UCC-128,code 39 etc.),different delivery product shipment characteristics description like customer part number, # of LPN’s, weight, waybill number, tracking number to be mandatory to avoid customer fines. Designed custom shipping exception rules for each and every customer via custom specific Oracle Form which provides easy enforcement of any new shipment exception required by the customer in future. Extended this design to recent acquisitions in Spain to facilitate customer specific shipping documents processing rules.

Functional Setup configuration of Oracle Inventory, Order Management Different Order Transaction Types, drop shipment, Intercompany Sales Orders Processing, Internal Sales Orders, UOM conversions, Picking and Shipping flow to facilitate Order fulfillment end to end for picking, packing and shipping activity (considering lot of variations in pick and ship activities with manual and automatic variations manual, semi-automatic, automatic via shipping transactions form. Setup configuration of Shipping document setup with Shipping documents, commercial invoice, Certificate of compliances, Bill of lading, Product Compliance document printing etc.

Oracle WMS setup configuration, inbound processes put away rules configuration, mapping with Rules Workbench Step Put away, Case Picking scenarios setup, Loose and packed quantity with Sub inventory LPN setups, Outbound processes setup of Dock Door setups and LPN shipping with load drop plan with automated label printing, unload plan for any user errors.

Warehouse setup of Internal processes for Replenishment flow Min-Max Driven, Pull Replenishment configuration

Opportunistic Cross Docking setup to facilitate smooth Cross Docking operations also Planned Cross Docking setup to facilitate Planned cross docking operations

Cycle counting setup in WMS to perform cycle counting using MSCA and performing Cycle count with Count Approver.

Oracle WMS label printing configuration, support, maintain to facilitate Oracle WMS Label printing when Load with Drop operation.

Direct Ship setups to facilitate smooth flow of Direct Ship

Proposed a designed WMS Analysis report which is in pilot phase to focus on right transactions at right time by users which is found as the Business requirements gap and problems found. We used Volume, Velocity, Variety of data to empower the Modern Value chain by QlikView dashboards for EBS suite Warehouse Management. By identifying key User Groups (Warehouse Mgr., Director of Operations, VP of Operations), Key Business Drivers. For WMS, how to manage revenue targets, Inventory, Warehousing costs, Labor or Workforce productivity in warehouse. Prototype demo of Design driven Warehouse Management using Real Time Operational Dashboards using Fulfillment Planning & tracking (tied to Revenue Business Driver), space utilization (Inventory Whose Cost Business Driver How to store the product most efficiently ), Labor Performance(Manage productivity of the warehouse identifying who is working on what and take actions right from Operational Dashboards ) thereby demonstrating the Key Business Benefits tied to Operational Dashboards, proposed system will let you know how to Optimize Outbound activities, reduce the warehousing cost by optimally storing the product & improve the labor utilization overall by making sure people have enough work to do and people are working on the right tasks at the right time assigned in right priority queues.

Proposed Planned quarterly meeting with Key Business Stakeholders cross functionally to review all the existing customizations in place from 2000 onwards so that old customizations are not being forgotten & then subsequently reported as an Issue but in fact we found that old Business rules being in place with new resources on board this a very important step in streamline Business with existing IT system features and its in built and customized features as an approved Business Capability.

Implementation, support of 3rd party systems i.e. High jump Spinney Bowes TMS product, Loft ware Labelling, Pick-To-Light system maintenance prior to Oracle WMS rollout recently

Manager with ownership of daily key deliverables for High Revenue $40 Million customer specific application built for Customer Delight. Ensured that daily orders, daily deliveries are having customer specific roll labels, Pallet labels which is spanned across Global Shipping organization catering to customer daily requirements.

Designed and architect of the Custom UCC design application catering to EDI Customer specific requirements of different Box, Pallet label shipments for different customers.

Design, Architect of Loft Ware Manual labels, Database labels, UCC Labels for automated label printing, customer specific application to print labels automatically via oracle custom forms application built as Customer specific application for customer delight

Lead the Project for existing TMS product (Pitney Bowes replacement with Organization identified new TMS Product I.e. Process Weaver’s TMS product I. e xCarrier. Designed custom solutions to retrieve the Carrier freight rate by connecting to Tech Logistics and getting the discounted price rate when shipments have more than 6 Pallets in LTL Shipments loads in comparison to small parcels. Carrier Freight setups with appropriate ship methods configurations to facilitate usage in TMS products

Prepaid Freight customizations to create internal Invoice with zero amount and adjustment to recognized the prepaid freight paid to the customer to record in the accounting. Capturing Freight account numbers when Freight carriers accounts are being paid these account numbers are being saved at the Customer Ship to Site or Bill to Site Location as the customized dff.

Post Live Production Support of Oracle WMS (Implemented by Inspirage) in Manchester, Somersworth Organizations which replaced existing High jump WMS product with Oracle WMS products. Review of WMS Setups performed using Advanced Task Framework how different material movement tasks are configured like Picking, put away, Cycle count and How task type assignments rules are assigned to different resources specialized in picking, put away, cycle count via Advanced Task Framework setup. Designed excel worksheet to list out employees and corresponding tasks to review the Advanced task framework.

Streamlined the process of month - end, Year end close activities with Focus Groups, organizing meetings to review periodically to identify any unknown known issues, working on identifying the global process owners for Intercompany Sales and Finance operations and designed a model to work closely in agreement for faster period close.

Oracle Shipping accuracy increased from 87% to 99% with Custom Picking Validation Shipments application development using Oracle Forms in VAP, Douglas facility wherein WMS is not implemented.

Reduced the time frame in waiting for Custom clearance in shipments transportation globally from Mexico to US for High Value Customer. Increased the shipment accuracy to 100% by enforcing customer specific shipping exception rules.

Supervising monitoring, mentoring team for better Coding standards, documentation, unit testing, debugging, documented, and maintained programs. Incorporate error checking, quick turnaround, easily switch off enhancements to reduce impact of unknown issues or facilitate difficult timeline migration by production rollout performing earlier with switch off feature. When Business Signals the right time then immediately switch on of the production rollout was done.

Facilitated smooth material movement operations causing errors thus designed an efficient stable resolution replacing manual methods with enforcement of best practices to be followed with efficient automation techniques wherever possible. Similar approaches were done in cross functional departments like Finance, Manufacturing, Planning, Receivables, and WMS, Shipping thus increasing user productivity and successful order fulfillment with efficient shipping methods. Instead of dealing with regular daily problems I prevented the problems justifying major stake of IT in smooth Business Operational tasks.

Managed successfully cross functional team challenges in resolving disputes over conflicting opinions on root cause of the Latency issues causing intermittent Label printing impacting High Revenue customer shipments. Managed successfully disagreement with reporting director, cross functional director by demonstrating proofs via meeting and earning goodwill and respect in demonstrating expertise as Custom application owner.

Cross-Functional Network infrastructure departments replacement of old aged printers with new unsuitable HP, Zebra printers were found to be problematic and resolved this with proper communication channels with policy enforcement.

Sales Order processing configured with Business Rules enforcement via Order Holds for MOQ, Product Compliance resulting in saving fines ensured that global product shipments are with 100% global compliance for chemicals in the shipment products.

Reduced the influx of Production Support tickets to 25% by providing re usable one-time stable solutions.

Client SMS Consulting NJ USA

Dates Aug 07 – Nov 09

Role Oracle E-Business Suite Developer/Analyst

Module or Domains: Financials, Inventory, Shipping Procure to Pay, Order to Cash, Record to Report

Responsibilities:

Blue Coat Inc. Sunnyvale CA: Oracle Applications custom project to Lead/Design/Implement the custom solutions as per the requirements provided for custom built Point of Sales System which involves Custom Form Design/Develop trigger AR Revenue Recognize event via Receivables API or push recognize revenue to Deferred Revenue account as per the Business.

Yahoo Inc. Sunnyvale CA: Worked in Oracle Financials Production Support team and was involved in resolution of High Priority/Urgent/Normal Tickets. Custom projects GL, AP, AR issues & FA was involved in uploading for foreign Language characters into Oracle Assets as an Asset Description.

UTStarcom Inc. Hangzhou China San Jose, CA: Worked in Production Support team involved in addressing R11 upgrade to R12 Inventory Reconciliation issues. Inventory Reconciliation extracts were frequently analyzed on Material Movement transactions generating accounting issues.

Client Data Methods Inc. TX

Dates Jan 07 – Aug 07

Role Oracle E-Business Suite Developer/Analyst

Module/Domains: Order-To-Cash

Responsibilities:

My role was a Functional/Technical lead consulting role for the clients IronPort Systems San Bruno CA for the Custom Revenue Recognition project

Technical Design, Build, Test and facilitate smooth Transition phases of custom revenue recognition.

Design included Custom GUI development using Oracle Forms.

Based on a particular business event the Revenue Recognition PL SQL API’s were developed to trigger Revenue Recognition or transfer the recognized revenue to deferred account.

Based on Business needs the revenue recognition API’s were used to periodically recognize revenue on an installment based on customer service realization and satisfaction.

Client IBM Global Services Bangalore India

Dates Oct 03 – Dec 06

Role Advisory System Analyst

Module/Domains: Procure to Pay, Order to Cash, Record to Report

Responsibilities: My role was a Functional/Technical lead consulting role for the IBM US clients in EBS Projects:

Reuters UK/Bangalore India Offices: Procure to Pay Functional Support tasks involved in Production support/development team on daily Function/Technical tasks in Production Support in Reuters Procure to Pay Business Process daily transactions generating in London office. We facilitate smooth procurement fulfillment operations by ensuring strict compliance with Reuters Policies like No Purchase Order is raised without requisition, Regular approved Purchase Orders are transmitted to Supplier via Oracle Supplier Network. We monitor the Purchase workflow and ensure Purchase orders are not stuck for known/unknown issues like workflow attributes missing or not found and we need to pass those values to expedite the workflow to ensure Purchase Order delivery to Supplier via PO XML transmissions. Setup/development of Purchasing Alerts to report on the PO XML Transmission issues via Oracle Supplier Networks.

I-Buy procurement registration of punch-out sites to expose new punch-out configurations.

Invoice approval workflow was customized to incorporate Business Logic of Invoice attachment scanned via 170 Mark view systems. Invoices are scanned and stored in 170 systems as Reuters compliance requirements.

Audit trail enhancements involved enabling of audit with an intention to monitor Purchasing User's data entry process discipline to validate the Reuters compliance policies. Audit information is tracked and generated for further reporting.

General Ledger Functional/Technical: Balance Sheet Reconciliation (BSR) tool has been purchased by Reuters from Assurity Corporation US (earlier Trinitech). Reuters accounting policies require balance sheet accounts data from Oracle ERP (Assets/Liabilities/Shareholders Equity) to be reconciled on a periodic basis. Designed and developed custom solutions to send outbound files to BSR tool.

Handle man Troy MI (Music CD distribution company): Implemented WMS features like Cross Docking, Opportunistic Cycle Counting, Opportunistic Put away, Cost Groups functionality mapping based on Sub inventory/Org/lot/Suppliers/Locators to separate the evaluation of the products & to avoid commingled inventory transactions errors. Pro-Active approach in Oracle WMS reporting modifications to display the LPN Information, Cost Group Information for reporting needs to differentiate the impact of WMS generated LPN transactions on Non LPN based other Inventory & Shipping transactions. Data conversion issues are eliminated after WMS by ensuring locator-based sub inventories setup. Improve Customer Service, Profitability in Outsourced Operations. Implementing WMS Solution in a Typical Outsourced Manufacturing facility. Outsourced partner will report WIP Completions/shelves movement in a Flat B2B file which is uploaded to Server automatically process the data by packing the material into LPN (developed WMS API program) into Oracle. Packed material is moved to FG sub inventory ready for material allocation via Picking Rules process execution. Picking task is dispatched to Picker via Mobile Handheld, drops the material into Staging sub inventory triggering automated label printing eliminating manual label printing thus improving Logistics operations with value additions to Supply Chain.

WMS advantages improved customer service, reliability of Order Fulfillment process by mobile handheld configured shortcuts to improve picker/shipper productivity, Real time Barcode scanning, automated label printing causing reduction in Lead Time for Shipping, fast shipping execution, material availability delay reduced by at least 1 day, cost group assignment reduced manual GL entries.

Technical Design Build development documentation and filling the identified gaps in Oracle Inventory Automation via Move Order API and Oracle Purchasing with custom solutions.

Accusort (CD Scanner machine) build a custom, automated vendor returns application that will both meet Handle man’s vendor return requirements & integrate with Oracle Inventory, Purchasing, and Accounts Payables modules.

Implemented custom automated vendor returns application. Forms Customization for Vendor Returns Application. New Form Developments based on the requirements. Custom Application Vendor Returns consists of custom forms developed to perform the returns of material to vendor through the following forms Enter Returns, Prepare Returns, Transfer Inventory, Return Authorization Tracking, RAR completion. Edit Cartons Forms.

Defining Oracle Purchasing Sourcing Rules, Local and Global Sourcing rules, developed a program for Assignment of Sourcing Rules to the Items to associate newly created items with the suppliers to import quotations for the items which have a list price value defined into Oracle Applications.

Worked on development in Oracle Supply Chain Management, Discrete Manufacturing and Inventory Modules involving PDOI interface in Oracle Purchasing to create Catalog Quotations for Handle Man Supplier Price Import.

Client Wipro Technologies Bangalore India

Dates Apr 02 – Oct 03

Role Oracle E-Business Suite Module Lead

Module/Domains Procure-To-Pay, Plan, Design for R11 Upgrade

Responsibilities:

My role was an Oracle Applications Project Module lead consulting role for Wipro clients in EBS Projects like Sony Inc. US & Worked in Production Support/development team based in Bangalore India:

Worked in designing and customizing Oracle Purchasing enhancements to enable Buyer to accept or reject the schedules and correspondingly the shipments would be created in Oracle Purchasing involving new Oracle Forms development and SQL, PLSQL programming to create shipments, distributions.

Oracle purchasing standard Enter Purchase Order Form in Oracle Applications 11i has been customized to incorporate the corporate policy to be followed while placing Oracle Purchase order.

Cisco Systems San Jose US: Worked in R10.7 to R11i upgrades, Functional production support.

Client ZenSar Technologies Pune India

Dates Nov 00 – Apr 02

Role Oracle E-Business Suite Associate Consultant

Module/Domains Order-To-Cash, Procure-To-Pay, Record-To-Report

My role was an Oracle Applications Associate consultant role for Zen Sar client Honeywell Control Systems UK:

Led a team to successfully migrated around 400 objects of customizations. Our Testing strategy was based upon the tactical steps provided to us by the client.

These tactical steps involved reading the existing production usage testing plan document and perform the similar testing in 11i instance of the successfully migrated object.

Cisco Systems San Jose US:

Worked on mainly Production Support, maintenance, development and enhancements-oriented Project.

Automated the process in Oracle Supply Chain Management, Oracle Inventory, Oracle Manufacturing modules in which SQL, PL SQL programs developed will process orders from different external sources like the web enabled, and EDI.

The SQL, PLSQL programs and Unix programming scripts will process the Sales Orders using Oracle supplied Process Order API and then the Sales Orders are pushed into Oracle Order Entry through PL SQL Engine which will filter the erroneous order and the Import correct orders in Oracle Order Management.

Clients have Order Entry both on the Customer Side and the Manufacturing side. So, Orders, which are populated into the Customer Side Order Entry Server has to be pushed into Manufacturing Side so that the goods can be manufactured and shipped.

The status of the manufacturing process and shipping should be updated in the Customer side too.

For the above there is tool SOM (Supply Order Manager) that will update the respective status across the databases.

Client Ashok Leyland Information Technology Bangalore India

Dates Nov 99-Nov-00

Role Software Engineer

Tools Oracle Forms 4.5/Reports 2.5, SQL, PL SQL, Oracle 7.x/8.x

Responsibilities:

Study of the existing design, code of existing CICS screens developed for IBM Mainframes and then re design, redevelop in Oracle as custom Forms/Reports application.

Successfully rebuilt CICS screens in Oracle Forms and Reports Application.

Client Relational Software Project Solutions India

Dates Nov 97-Nov-99

Role Software Engineer

Tools Oracle Forms 4.5/Reports 2.5, SQL, PL SQL, Oracle 7.x/8.x

Responsibilities:

User defined custom SQL/Shell Script files/PL SQL packages, Forms/Reports, database triggers development which generalizes error code/ messages for reporting.

Successful implementation rollout of Custom application to demonstrate the data storage, retrieval, modifications with Oracle Forms 4.5 Non-database block programming using packages and procedures to process data efficiently.

Contact this candidate