Supply Chain Oracle Erp

SHAOQING SHI

310-***-**** ● ********.***@*****.***

Enterprise Solution Architect and Consultant

Fit/Gap Analysis ● CRP ● Setup/Configuration ● Design/Develop ● Go-live

* ******* ** ***** ***cle ERP solution and integration experience, in both functional and technical areas.

7 years of Oracle Cloud (SaaS/PaaS) customization and integration with on premises and cloud systems

Areas of functional strength include Oracle ERP fit/gap analysis, integration and custom solution design and development, setup / configuration, as well as go-live support.

Areas of technical strength include in-depth experiences in full Oracle tech-stacks and cloud integration

Extensive experience in best industry practices on HRMS, CRM, Financial, and Supply Chain modules.

Completed 20 full life cycle projects, as leading designer and developer.

Worked for both US domestic and international clients from industries of Financials, Manufacturing, Government, High-Tech, Utilities, Retail, and Healthcare.

Extensive experience/knowledge in building custom applications and extensions using core Oracle technology stacks.

Excellent communication and team building skills.

SKILLS SUMMARY

Oracle Products: Cloud ERP (SaaS), OIC and DBCS (PaaS), EBS R12.x and 11i

Oracle DB Versions: 9i-21c (Linux, Solaris, IBM AIX, HP-UX, Windows)

Other integrated systems: AWS, Azure, BizTalk, Kafka, PeopleSoft, Salesforce, Siebel, Snowflake

Oracle Application modules:

oFinancials (AR, AP, GL, PA, FA, SLA, BPA, iExpense);

oManufacturing (INV, BOM, EAM, WIP, FLM, OSFM, WMS, CST, WPS, MSCA,QA);

oProcurement (iProcurement, iSupplier, Purchasing, Sourcing)

oOrder Management (OM, QP, Shipping)

oCRM (TCA, Service, Field Service, Service Contracts, Install Base)

oEDI/e-Commerce Gateway

oHRMS (MSS, Payroll, Benefits, Data Management)

oOBIEE, ODI

Tech-stacks: APEX, Web Service (REST/SOAP), Message Queue, OAF/ADF, Workflow/BE, Alert, Forms, Reports, OBIEE, BI Publisher, SQL*Loader, Data Loader, Toad, SQL Developer, SOA Gateway, ESB, BPEL

Programming Languages: PL/SQL, SQL, Java, JavaScript, JSP, XML, HTML, Pro*C++, Unix Script, Perl

OUM, CEMLI and AIM methodology; Agile/Scrum/DevOps

WORK AUTHORIZATION STATUS

US Citizen

EDUCATION

Master’s of Science Degree in Computer Science, Brown University (2001)

JOB SUMMARY

Company

From

To

Designation

Oracle Corporation (Development)

Apr 2001

Sep 2006

Principal Application Developer

Oracle Corporation (Consulting)

Oct 2006

Jun 2009

Sr. Principal Consultant

9-Pillar Corporation

Jul 2009

Current

Oracle ERP Lead Consultant

PROFESSIONAL EXPERIENCE

Graco Inc, Minneapolis, MN (Nov’22 – current) (hybrid)

Role: Oracle Lead Technical Functional Consultant

Oracle EBS 12.1.3 to 12.2.11 Upgrade

Modules: Financials, O2C, P2P, Manufacturing, Inventory/Warehouse, ASCP

Tech Stacks: OAF, WF, ISG, APEX, Forms, BIP/RDF Reports, MSCA, etc.

Make 12.1.3 custom code 12.2.11 GSCC compliant

Fix all upgrade issues, from system/DB, to application server and EBS modules

Upgrade or redesign 12.1.3 RICEWF components for 12.2.11, including but not limited to,

oCustom configurations such as lookups, profile options, and system setups

oCustom UI extensions (OAF and Forms)

oWF customizations

oForms personalization and custom Forms

oCustom reports (RDF/BIP)

oCustom MSCA functions and Mobile Express (3rd party) personalization

oCustom inbound and out bound integrations

oUptake of 12.2.11 new features and technologies, while decommissioning outdated 12.1.3 components

Advance Auto Parts, Raleigh, NC (Sep’21 – Nov’22) (remote)

Role: Oracle Cloud Technology Architect

Oracle Cloud ERP (SaaS) and Oracle Cloud PaaS, APEX

Modules: AP, AR, GL, PO, PA

Tech Stacks: OICS, APEX, Kafka, Snowflake, MFT, JS, Java, Web Service, PL/SQL

Defined system integration standards and templates for data and process integration (with EBS, PeopleSoft, Kafka, MFT, Snowflake)

Designed and implemented integration platform on Oracle Cloud PaaS

Designed and implemented APEX-based scheduling manager

Designed and implemented inter-system cross-walk for GL accounts, suppliers, and projects

Designed and implemented inbound interface framework based on both FBDI and Web Services

Designed GL, AP, Customer, and AR interface on inbound interface framework

Designed and implemented Supplier Portal for suppliers to manage invoices and payments

Designed and implemented SCF (Supply Chain Financing) solution with 8 major banks

Designed Customer Billing Portal and Transaction Authorization Service

Best Buy, Minneapolis, MN (May’17 – Aug’21), (remote)

Role: Oracle Solution Lead Consultant

Oracle eBS R12.2

Modules: PO, Sourcing, OM, Costing, WMS, WSH, INV, BOM, ISG, EDI, ECX, PLM, XML

Tech stacks: APEX, Java, Rest Service, PL/SQL, OAF, Forms, Reports, WF, AQ

Designed and implemented rule-based sourcing solution for service and repair parts and end-to-end PTP solutions

Designed and implemented custom mobile (MSCA) solutions for material management

Designed and implemented full custom label printing solution on Zebra printers

Designed and implemented receiving processes with APEX UI and EBS backend API

Designed and implemented shipping integration between EBS and carriers with Azure cloud and APEX UI

Designed and implemented generic XML Parser for XML data integration with EBS

Customized XML Gateway messages for purchasing in Message Designer

Designed and implemented EBS integration with other systems via inbound and outbound interfaces, Integrated SOA Gateway, and web service

Designed and implemented inventory and bill structure for repair unit and part

Designed and implemented custom GL, AP, PO, RCV, ASN, INV, and BOM interfaces

Technical lead on R12.1.3 to R12.2.x upgrade project

ICU Medical, Part-time Remote (Jun’18 – Dec’18)

Role: Oracle Integration Consultant

Oracle ICS, DBCS, eBS R12.2

Modules: integrate Oracle Agile PLM with eBS 12.2 MFG/ENG via OICS and DBCS

Tech Stacks: APEX, Web Service, PL/SQL, Concurrent Program, Business Event

Designed and implemented integration solution between Agile PLM and eBS

Designed and created data model on DBCS to store payload and logs

Designed and developed integrations on ICS between PLM and eBS

Designed and developed APEX UI as an administration tool

Designed and developed Oracle Engineering and Manufacturing inbound/outbound interfaces

Be The Match (previously NMDP, non-profit), Minneapolis, MN (Jan’16 – Apr’17)

Role: Oracle eBS Lead Consultant

Oracle eBS R12.1

Modules: AP, AR, TCA, OM, QP, OZF, GL, PA, GMS

Tech Stacks: APEX, OAF, PL/SQL, Service Bus, AOL, Forms, Reports, OBIEE, BI Publisher

Led multiple-year effort to migrate legacy systems to Oracle EBS

Designed patient data model based on TCA

Integrated OM with OZF to support partner reimbursements

Designed custom UI to process grant request, approval, and EFT payment (US Bank, Wellsfargo)

Integrated with Enterprise Service Bus to synchronize patient, donor, and order information via messaging and web service

Developed the end-2-end process, including UI, business rules, financial transactions, multiple trading partner communications, and various reports including OBIEE and BIP

Accenture, Part-time Remote (Jun’15 – Nov’15)

Role: Oracle eBS Lead Designer and Architect

Oracle eBS R12.2, Cloud-Readiness Project

Modules: Custom Objects Management, Integration Framework

Tech Stacks: ADF, jDeveloper 11g/12, PL/SQL

Designed and coded Custom Objects Library using latest ADF technology to automate initiation, tracking, testing, deployment, and maintenance of custom objects within Oracle Applications

Design and coded Integration Framework using latest ADF technology to configure multi-stage integration process including source/target system definition, source file staging and mapping, staging to Oracle Application interfacing, and to automate code generation, testing, deployment, and reporting of integration execution.

Deploy ADF application on standalone Weblogic server and integrated with EBS with single sign-on

Best Buy, Minneapolis, MN (Jul’14 – Dec’15)

Role: Oracle eBS Lead Consultant

Oracle eBS 11i/R12

Modules: AP, AR, GL, FA, HR/Payroll, PO, PA, TCA, iProcurement, iSupplier, OTL

Tech Stacks: PL/SQL, OAF, Forms, Reports, Workflow

11i to R12 upgrade (both US and Canada operating units), with tasks including planning and analysis, updating customization for R12 tech stacks, and go-live support

Rule-based custom PTO configuration and engine, a future-ready configurable PTO platform that can handle new laws and regulations without program changes

Drop Ship process to support millions of sales that are fulfilled by vendors including Apple, with automatic PO creation, receiving, returns, 3-way invoice matching, management UI and reports

Custom EBS automation and change management tools, including custom objects management, event-driven job scheduling, code migrations, and universal integration frameworks

OTL, iProcurement/purchasing, and Procurement Contract customizations

Customized EFT payments process to handle big volume of AP invoices

Wellsfargo, Chicago, IL (Feb’13 – Jul’14)

Role: Oracle eBS Lead Consultant

Oracle eBS R12

Modules: eAM, WIP, PO, INV, AP, PA, AR, BPA, TCA

Tech Stacks: OAF, Workflow, PL/SQL

Rail car maintenance application is built by customizing Oracle eAM. Major customizations are repair estimate process and workflow, lease termination settlement process and workflow, and project billing and accounting for vendor and customer transactions.

Responsible for integrating EBS with customer systems (Salesforce) and vendor, go-live support

Responsible for designing and delivering lease termination settlement, which accounts for 70%+ maintenance work

Responsible for optimizing existing business process and rules.

Designed new process to automate lease termination settlement utilizing OAF and Workflow.

Integrated with eAM in order to generate settlement proposals based on repair estimates

Integrated with Project Billing and Receivables to generate AR invoices.

Implemented and deployed lease termination settlement object

Consolidated Edison, Remote (Jun’11 – Dec’12) – Project One

Role: Oracle eBS Lead Consultant

Oracle eBS R12

Modules: AP, PO, PA, SLA, GL, ICX, INV, EDI, WMS, MSCA, OM, FND, ALR

Tech Stacks: OAF, JDeveloper, PL/SQL, Workflow, AME, Alert, ICAP, Web Service, BizTalk

In this major implementation of Oracle eBS Financials and Supply Chain applications, led functional gap analysis, feasibility analysis, solution design, and implementation of extensions, customizations, interfaces, reports, and workflow (RICEW). He is also a major resource working on go-live and production support.

Based on gap analysis of iProcurement versus existing processes, designed solutions to implement custom business rules in procurement process, for both catalog and non-catalog items, through both internal and external requisitions. The solution added support to back-to-back (cross dock) orders and back-order capability due to inventory shortage, and streamlined the process by automating front-end data entry and back-end integration to Inventory, Order Management, Project Accounting, and EDI.

Led EDI integration with BizTalk through e-Commerce Gateway, web services, and custom interfaces. The solution involves functional setup and technical implementation for 810, 850, 852, 860, 861, and 867. Complex customization was done to handle both cross-dock and consigned items.

Designed and developed a high-volume vendor invoice process utilizing OAF and Workflow. Custom OAF UI enforces user-defined business rules and workflow routes approval based on AME rules. Workflow also integrates with AP invoice through open interface.

Designed and developed Mobile UI (MSCA) customization to receive cross-dock materials in WMS, and automatically kicks off Pick Release for order fulfillment. The custom cross-dock receiving label is generated by a custom report.

Designed and developed an anti-virus solution for vendor-facing modules in R12 iSupplier and Sourcing, by integrating OAF with Symantec Scan Engine through internet-based virus scan standard ICAP (Internet Content Adaptation Protocol)

During go-live and production support, worked closely with IT, business groups, and Oracle Support on solving critical issues including but not limited to performance tuning, data fixes, workflow/process diagnosis, integration improvement, and month-end closing

US Postal Service, Topeka, KS (Jul’09 – Jun’11)

Role: Oracle eBS Lead Consultant

Oracle eBS R12

Modules: eAM, WIP, BOM, INV, FA, IB, PO, OM, WSH, PIM, EDI, WMS, MSCA

Tech Stacks: Forms, OAF, JDeveloper, PL/SQL, OBIEE, ODI, BI Publisher, Workflow

Led major efforts in eAM gap analysis, solution design, architecture, and development. With his deep functional knowledge in eAM and Oracle Supply Chain applications and his extensive technical skills in Oracle technologies, he could design the optimum solutions that well exceeded customer expectations.

Analyzed AS-IS and TO-BE processes and designed prototypes to fill gaps during CRP phase.

Led the efforts to define RICEW objects and review major design documents.

Led the efforts to evaluate 3rd party Mobile platforms for eBS and customized package tracking to comply with Postal barcode and tracking standards

Set up and configured eAM and dependent supply chain modules manually or through data loader.

Prepared UAT test scripts and supported go-live for all phases.

Designed custom business processes for eAM, PO, and INV modules – specifically re-designed work order form to satisfy specific VMF (vehicle maintenance facility) requirements and meantime simplified the maintenance through automations.

Designed, developed and tested key RICEW objects for eAM, PO, INV, OM, WMS, WSH.

Worked with Oracle Support to identify and log SR’s and got the issues resolved.

Set up HR Security Profile to control access to different data and processes.

Designed OBIEE physical data models for eAM and underlying modules, configured repositories, and developed ODI packages to load and refresh eBS data into OBIEE.

Skipjack, Part-time Remote (Jan’10 – May’10)

Role: Oracle eBS Lead Consultant

Oracle eBS 11i/R12

Modules: MSCA, WMS, iSupplier, INV, PO

Tech Stacks: OAF, JDeveloper, PL/SQL, MSCA, Java

As solution architect, integrated Skipjack’s industry-leading barcode printing product with Oracle eBS iSupplier and WMS through OAF extensions and Mobile Supply China Application (MSCA) customizations.

Extended iSupplier by developing new pages to automate barcode printing for shipment.

Customized WMS transactions to automatically print labels with serial# and LPN information.

Sun Microsystems, Sunnyvale, CA (Sep’07 – Jun’09)

Role: Oracle EBS Lead Consultant

Oracle eBS 11i

Modules: TCA, HR, Field Service, Service Contract, OM

Tech Stacks: OAF, JDeveloper, Forms, PL/SQL, BI Publisher, Concurrent Program

On Oracle 11i implementation focusing on service modules, led the efforts in designing and delivering many key RICEW objects in Service, Customer, and Order Management modules

Designed and developed a customer management custom module to manage customer relationships, customer hierarchies, and presented the data in BI Discoverer 10g.

Designed and developed Service-Level Agreement extension to Field Service and Service Contract. It analyzed transaction data in Service modules and compared the result to the service contract terms. The data was presented in BI Discoverer 10g to evaluate service quality and guide management decisions.

Designed and developed Order Management Fulfillment Rules Management and Execution utilizing OAF. Through this solution, order fulfillment process was automated and optimized by applying business rules defined on customer, order, and inventory information.

Key Bank, Remote (Sep’08 – Nov’08)

Role: Oracle eBS Senior Principal Consultant

Oracle eBS 11i

Module: Lease Management

Tech Stacks: Business Event, Workflow, JSP, PL/SQL

During this global rollout of Oracle eBS 11i with focus on Lease Management,

Independently designed and implemented custom solution for debt-service loans.

Customized loan booking business event to trigger custom billing logic for billable streams and generate accounting entries accordingly.

Customized JSP pages according to custom rules regulating those loans.

Alcoa Brazil, Remote (Jul’07 – Sep’07)

Role: Oracle eBS Senior Principal Consultant

Oracle eBS R12

Modules: OSFM, Costing, Inventory

Tech Stacks: Forms, PL/SQL, Concurrent Program

Customer requested PAC (Periodic Average Costing) feature for OSFM due to local financial reporting regulations and escalated the requirement to top executive management. Led the gap analysis and functional design and helped local consultants implement the solution successfully.

Worked as the only US functional and technical resource, coordinated efforts with customer, development, local consulting team, sales team, and customer management team.

Analyzed different LOT transactions in the requirements and identified the gaps between R12 offerings and customer expectations. Delivered a prototype and functional design for an optimum solution.

Ceridian Corporation, Bloomington, MN (Oct’06 – Jun’07)

Role: Oracle eBS Senior Consultant

Oracle eBS R11

Modules: AR, GL, FA, OE, custom Billing

Tech Stacks: Forms, Report, PL/SQL, Concurrent Program

Client was running on Oracle eBS R11 with customized contract and billing application. My tasks included leading an evaluation of R12 upgrade and enhancements to custom applications.

Led and completed an evaluation for an upgrade from eBS 11.0 to R12.

Performed gap analysis on custom applications versus R12 new features, and provided a roadmap for R12 upgrade.

Identified potential technical issues related to database schema and custom/3rd-party programs during future upgrade, and implemented procedures to address them or to minimize impact.

Designed and developed enhancements to custom contract and billing application.

Converted fixed assets from legacy system into eBS and developed monthly depreciation report.

Oracle Corporation, Redwood Shores, CA (Apr’01 – Sep’06)

Role: Oracle Principal Application Developer

Oracle eBS R12 Development, CRM, Receivables Application, Supply Chain Management

Modules: FLM, PO, MRP, ASCP, ILOG, eAM, WIP, BOM, INV, FA, IB, WPS, AR, TCA, INV, IB, QP, OM, BPA

Tech Stacks: OAF, Forms, Report, JDeveloper, PL/SQL, Pro*C++, Concurrent Program

As a lead developer during R12 Receivables development, designed and developed major R12 features including TCA (Customer Online in 11i) and integrated billing solutions.

As a key member of 11i and R12 development team of Oracle Manufacturing and Distribution division, worked on many modules including Flow Manufacturing (FLM) and Work in Process (WIP). Gained in-depth product knowledge and extensive hands-on experiences from product setup, configuration, development, testing, and integration with other core modules.

Contributed to major solution design and architecture in the first release of Enterprise Asset Management. He also took ownership of designing and delivering Maintenance Workbench, which integrated together all important daily processes of work requests, work orders, resources, materials, scheduling, and preventive maintenance.

Researched features, open interfaces, and public APIs of existing eBS modules related to customer, pricing, order, and billing information

Designed and built an integrated billing solution on top of Trading Community Architecture, Inventory, Install Base, Advanced Pricing, Order Management, Bill Presentment Architecture and Receivables.

Led the TCA integration with AR. Designed and developed new customer UI to incorporate TCA functionalities, data model, and back-end processes into Receivables application.

Designed and developed Flow graphic line designer and graphic Kanban workbench.

Designed and developed Flow mixed model map, Flow schedule workbench, and Flow workstation.

Led the design and development of Flow Sequencing, a solution to schedule flow schedules based on user-defined constraints, by leveraging OAF, ILOG Solver, Pro*C++, and concurrent program.

During eAM first release, researched features and interfaces of underlying WIP, BOM, INV, PO.

Worked together with client team from Alcoa on eAM requirement analysis and solution design.

Successfully developed, tested, and released the first version of eAM within 11i timeline.

Contact this candidate