We provide IT Staff Augmentation Services!

Oracle Supply Chain Consultant Resume

2.00/5 (Submit Your Rating)

Santa Clara, CA

SUMMARY

  • 12+ years of Oracle Applications experience as a Techno - Functional consultant and specializes in the development of Oracle software solutions and expertise in requirements definition, business analysis, design, systems integration and implementation.
  • Hands-on involvement in business requirement, GAP analysis, module setup, process mapping, solution design, configuration, workarounds, conversion & interface and user training.
  • Exposure to business processes in different modules of Oracle Apps such as OM, Quoting, Teleservice, Shipping, configurator, Advance pricing, INV, AME Business Analyst, AR, AP, PO, iProc, iProcurement Catalog administrator, GL, FA, BOM, WIP, Quality, Core HRMS, Costing, Alerts, Sys admin, e-Commerce Gateway, XML publisher administrator and Application developer.
  • Developed functional and technical specifications as well as release plans and test scenarios using AIM methodology and handling oracle product support service requests.
  • Good Experience in Order-to-Cash and Procure-to-Pay Business Process flows and worked in various oracle implementations such as extended support patch implementation of 11.5.10 and upgrade to R12 implementation by going through development, conference room pilot (CRP), user acceptance test (UAT) and production migration cut-over task, go-live and post go-live support in complex environment.
  • Fit gap analysis on the requirement and proposing solutions for gap using extensions. Familiar to E-Biz standard tables, API’s, Forms and Reports in Oracle Applications.
  • Extensively worked on RICE (Reports, Interfaces, Conversions and Extensions) components and familiar with AOL process such as registration of concurrent programs, request sets, lookups, printer setups, value sets and flex fields.
  • Involved in customizations such as oracle forms, reports enhancements, form personalization, processing constraints, defaulting rule, Business Events, Discoverer, CUSTOM pll and workflow. Proficient in writing stored procedures, packages, functions, triggers, views and indexes. Exposure on Mod SQL, OAF and UNIX shell scripting.
  • Developed generic custom API’s for future acquisitions process and pro-actively sort areas of opportunity to find solutions that meet the business needs of the customer.
  • Experience in tuning SQL statements to improve execution performance using TKPROF, SQL Trace etc., Worked on supporting 3rd party tools such as EDI, Protobase, AMO, IPFOLIO, RevPro, SpreadSheet Server and DBMS.
  • Excellent communication skills, adapt in client interaction and understanding business applications.

TECHNICAL SKILLS

ERP: Oracle Applications 12.1.3, 11.5.10, 11.5.8

Modules: OM, Quoting, Teleservice, Shipping, configurator, Advance pricing, INV, AME Business Analyst, AR, AP, PO, iProc, iProcurement Catalog administrator, GL, FA, BOM, WIP, Quality, Core HRMS, Costing, Alerts, Sys admin, e-Commerce Gateway, XML publisher administrator and Application developer.

RDBMS: Oracle 10g, 9i, 8i and MySQL.

Languages: SQL, PL/SQL, Mod SQL, UNIX Shell, JAVA, XML Publisher.

GUI: Developer 6i/10g Forms & Reports

Tools and Utilities: Workflow builder, SQL*Plus, SQL*Loader, Toad 10.6, SQL Developer, WINSCP, Putty, Filezilla, Citrix server, SQL Navigator, Data Loader.

Version control tools: PVCS, Perforce and Clearcase.

3rd Party applications: EDI, Protobase, AMO, IPFOLIO, RevPro, SpreadSheet Server, GPS, BarTender and DBMS

Operating systems: Windows 2003/XP, Linux.

Support tools: Mercury, HP Service Manager 9.2, HelpDesk, JIRA, ServiceNow.

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Oracle Supply Chain Consultant

Responsibilities:

  • Developed interfacing oracle order header/line status, hold status, product serial numbers, rev rec dates back to SFDC in a complete payload through Oracle Advanced Queuing (AQ).
  • Performed multiple oracle advanced queueing mechanism to enqueue the data for middleware mulesoft consumption. Configured queue tables, queues, agents, business events, subscriptions, schedule propagations to support the AQ mechanism.
  • Implemented VMI/CI (Vendor Managed Inventory/Consigned Inventory) process end-to-end between the External supplier and Hitachi for US operating unit. Engaged in Setup, Configuration, Development, Unit-Testing, UAT and Deployment. As part of VMI process deployed min-max, ownership transfer, consumption advices and Consumption dashboard reports.
  • Enhancement to the existing Oracle Asset interface structure to send a complete payload to SFDC for asset tracking.
  • Performed impact analysis to identify the oracle global supply chain objects, since the source system changed from Siebel to SFDC. Later, modified the impacted objects to support both the source system.
  • Enhancement performed in the in-house WMS tool to support the 2D Label scanning during the assembly process as part of the Pick/Pack process.
  • Enhancement to existing interfaces such as oracle sales orders, service orders and order returns process.
  • Performed functional unit testing on the SFDC orders flowing to oracle from enter to close and the entire shipping process done in WMS (In-House system) through Barcode scanners (Hi-Jump).

Environment Oracle Applications R12.1.3 OM, Shipping, WMS, Inventory, BOM, PO, Advance Pricing, System Administrator, Workflow Administrator, Functional Administrator, Application Developer and Alert Manager. SQL, PL/SQL, Oracle Advanced Queueing (AQ), UNIX shell script, Putty, Winscp, PLSQL Developer, PVCS, JIRA and Kintana.

Confidential, San Francisco, CA

Oracle Supply Chain Consultant

Responsibilities:

  • Developed interface to apply cash receipts for the cash/check payments published by JD Edwards to EBS in order to record the receipts and apply to the invoices.
  • Conversion data for Open work orders, BOM, Routings, Open PO, Item Cross Reference, PO Price and ASL.
  • Worked in the financial conversion extract for Open GL Balances, FA Master & Balances and Open AR balances for US and Canada organizations.
  • Outbound interface of Credit card receipts from Oracle EBS to JD Edwards.
  • One-time wrapper process to inactivate the supplier and supplier site that are identified by the business as outdated.
  • Performed form personalization in the PO forms for the specific operating units.

Environment Oracle Applications R12.1.3 Modules Purchasing, Inventory, General Ledger, OM, Shipping, Receivables, FA, BOM, WIP, System Administrator, Application Developer and Advanced Pricing.

Confidential, Mountain View, CA

Lead, Oracle Technical Developer

Responsibilities:

  • Created new Punch-outs in Oracle iProcurement using the Supplier-Hosted Catalog (cXML) model.
  • Developed and supported the Interface between GPS (genome processing system) and Oracle. GPS will trigger each event to oracle to Create SO, RMA Lines for the Samples, Create WIP jobs, Issue Components/Resource to the JOBs, Move and Complete transaction.
  • Generated different labels for Receiving, Incoming Inspection, Work Order labels from Oracle to BarTender software.
  • Created multiple reports in Spreadsheet server for iProc req’s pending approval, PO un-invoiced receipt, Supplier on-time delivery report, WIP resource report, lot genealogy report, WIP Detail report, SO line detail report.
  • AME changes performed on the Purchase Requisition approval and Requestor change order approval, to include buyer as first level of approver, then include finance approver and rule setup for the approval limit based on the job approval authority level.
  • Flow Cell Automation to Oracle - Developed an Application to maintain and track flow cell production process. As part of this development project, we have created multiple custom responsibilities, developed 14 custom forms, enabled oracle auditing, developed 10 Bartender labels, developed 4 Upload log files from the PVA robotics machines to the custom applications and created 15 custom spread sheet server reports.
  • Defined different sets of periodic and event based alerts for the process “Notify PR preparer when 75% and 90% amount billed”, “PR Approval reminder alert awaiting for more than 3days and 2nd alert after 6days”, “PO Item received alert to the Requestor”
  • Performed business events customization for the PO CREATE to transfer the PR attribute values to PO attributes and make the receipt close tolerance to 100% for the credit card suppliers.
  • Performed CRV (cross-rule validation) to exclude certain accounts from PR creation.
  • Customized multiple OAF personalization’s in the iProc, buyers workbench pages.
  • Gathering the requirement from the Business in client side and guiding the development team with the detailed requirement. Coordination with the team on testing of the new designs including extensions, conversion, interfaces and reports.
  • Maintaining the Month-End-Closure activity in terms of any stuck transactions and issues reported during the closure and running the Change Request for the production issues.
  • Providing a better technical solution on the existing customization issues and resolving any user training issue reported in SCM area.
  • Preparing AIM Technical documents and consolidated migration spreadsheet for the weekly releases.
  • Creating an SR with oracle on the standard issues and analyzing the impact on the PATCH recommended for the application.
  • Working on the existing or new customization in the technical area of Oracle Forms, reports, XML publisher, Workflow, Alerts, Stored procedures, functions, OAF, SQL Loader and Shell scripting.

Environment: Oracle Applications R12.1.3 Modules Purchasing, iProcurement, iProcurement Catalog administrator, Inventory & Engineering, Payables, General Ledger, OM, Shipping, Receivables, FA, HR, Alerts, BOM, WIP, Quality, System Administrator, Application Developer, e-Commerce Gateway and XML publisher administrator.

Confidential, Santa Clara, CA

Senior Technical Consultant

Responsibilities:

  • Fix all the broken and identified customized objects, such as reports/view/forms/process-oriented due to the changes in the R12 structure.
  • Worked upon the CHECK Printing and Bank payment file process.
  • Updating the CUSTOM.pll to incorporate the R12 changes and integrating the Mark view application i.e. third party system for all images/attachments.
  • Creating a separate remittance advice and configure it to the Payment process profile.
  • OAF personalization on the iProcurement and iExpense self-service pages based on the business requirement.
  • Renaming the approval groups and modifying the pay group queries in AME to support the R12 structure.
  • Excluding certain menus and function in the Custom GL/FA/CASHMAN/AP/AR responsibilities for the SOD violation according to the business needs.
  • Changed the customized process for the GL Daily Rate, GL Import Journals and Invoicing XML publisher reports.
  • Fixing various Discoverer reports in FIN/P2P such as Print Voucher, AR Adjustment Report, AR Audit report, GL AP PO Drill down reports, Travel and Entertainment report.
  • Applying certain data fixes for the AP, Expense, EBtax as per the business needs.
  • Preparing AIM Technical documents, testing scenarios and consolidated migration spreadsheet for the cutover task.

Environment Oracle Applications R12.1.3 Modules Purchasing, iProcurement, iExpense, Payables, General Ledger, Receivables, AME Business Analyst, HRMS, Alerts, System Administrator, Application Developer and XML publisher administrator.

Confidential, Santa Clara, CA

Senior Technical Consultant - ERP

Responsibilities:

  • Create and define template and data definitions for Custom invoice/Acknowledgment/Customer reports and conditionally display company logo information based on run time parameters.
  • Created and customized reports using XML Publisher and Oracle Report builder in OM, Shipping and INV. Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
  • Extensive Experience in OM API's such as order creation and order updating and resolved issues in the workflow of Order flow in OM module and had the modified workflow re-deployed in the instance.
  • Create and define template and data definitions for Customer Order reports in XML Publisher responsibilities. Created custom Shell scripts to handle the loading of data file into the custom tables and archiving of the data file.
  • Performing the change request and project life cycle migrations in the development and test instance and later co-ordinate the monthly/quarterly releases for limited/major changes in the application.
  • Maintaining the Month-End-Closure Activity and Progressing the Stuck invoice during the closure and running the Change Request in the Custom Responsibility for the production issue.
  • Sending Alerts global wide and performing Sanity check on the order, configurator, quote during the Month-End-Closure. Working on the enhancement issues and Prepared Module Design technical documentation MD070 using Oracle AIM documents.

Environment Oracle Applications R12.1.3 and 11.5.10 Modules OM, Quoting, Shipping, Advanced Pricing, Inventory, Alerts, System Administrator, Application Developer and XML publisher administrator.

Confidential, Beaverton, OR

Senior Technical Consultant - ERP

Responsibilities:

  • Gathering the requirement from the Business Analyst in client side and guiding the development team with the detailed requirement. Coordination with the team on testing of the new designs including extensions, conversion, interfaces and reports.
  • Implemented automated Oracle Teleservice service request created based on the XML data received from web request and customized email acknowledgment sent back to the customers.
  • Moved the imaging system from FileNET to Oracle Enterprise Content Management (ECM) by generating the Meta data’s based on the post scripts.
  • Configuring new Modifiers and Qualifiers in the Pricing Modules. Implemented various acquisition projects within Tektronix during the acquisition of companies such as Sypris, Davis and Keithley instruments. Developed generic, Custom API scripts for the future acquisitions.
  • Created an Oracle Alert to send an alert whenever a Tek Credit Hold is released either from the order header or line level. Changes in the Multi-lingual reports and configuring the Multi-lingual setups according to the Business Specifications. Customizing the AP Check Printing in XML Publisher Report.
  • Preparing the MD070’s, analysis documents, migration sheets, project release sheets and offshore delivery checklist. Supporting 3rd party issues in EDI/Protobase/DBMS tools and Handling Oracle SR’s.

Environment Oracle Applications R12.1.3 and 11.5.10 Modules OM, AR, Shipping, Multi-Lingual, Quoting, Teleservice, INV, Pricing, Alerts, System Administrator, Application Developer, Imaging and XML publisher administrator.

Confidential, Green Bay, WI

Technical Consultant

Responsibilities:

  • BI Publisher report to show the shipment statistics from OTM for the general ledger and creating Repository & Reports as per the functional & technical documents. Registering the report programs developed as concurrent programs. Tuned the existing oracle reports to improve performance.
  • Follow-up with the Business team in gathering and populating the data columns for the custom reports. Deploying the data definitions and templates in the XML Publisher administrator responsibility.
  • Uploaded all the concurrent program, value sets and responsibility details into another instance by using FNDLOAD commands. Studying the MD050 documents and preparing MD070 documents. BI Publisher report to show the shipment statistics from OTM for the general ledger.

Environment Oracle Applications R12 AP, AR, OTM, XML publisher administrator, INV, System Administrator and Application Developer

Confidentia, Smyrna, TN

Technical Consultant

Responsibilities:

  • Performing system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to app users for any technical and functional issues.
  • Developed Inbound Interfaces and conversions to transfer the data from legacy system. Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
  • Created various PL/SQL procedures/packages according to the Client requirements. Developed new XML Publisher reports.
  • Involved in customizing and developing the Reports. Modifying the Materialized views and discoverer views. Custom Staging schema preparation and Validation of the staging data before inserting into interfacing tables.
  • Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger.
  • Translate business needs into technical deliverable solutions. Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
  • Creation of value sets in various Modules of the application. Customized Invoice Print Report and performed scheduling activity in system administrator.
  • Responsible for customizing reports and writing the reports with required specifications. Developed custom programs to meet the business process requirements.
  • Developed SQL queries to obtain specific information as per requirements. Prepared technical and Unit Test Case (UTC) design documentation.
  • Helped to improve the performance, scalability and stability of views. Prepared Technical Documentation for future use.

Environment: Implementation of Oracle EBS for Cholamandalam DBS Modules GL, Core HRMS, Application developer and System administrator.

We'd love your feedback!