Project Oracle

YI LING LIU (TRACY)

Email ID: ******@*****.***

Phone Number: 1-714-***-****

Current Location: Tustin, CA

Linkedin ID: https://www.linkedin.com/in/tracy-liu-ba10691

WORK STATUS: Green Card

SUMMARY

Over 17 years of experience working with Oracle Applications (EBS) analysis and using development tools (Oracle PL/SQL).

Extensive experience in Oracle ERP R12 and 11i.

Completely responsible for providing functional and technical support for Oracle Distribution (PO, OM, INV), Manufacturing (WIP, BOM), Internet Supplier Portal (ISP) and Business Intelligence (BI) for the last 15 years

Good experience in writing successful extensions (Oracle PL/SQL), interfaces and customizations to Oracle applications (EBS)

Extensive experience in working with e-Business Suite (EBS) and well developed technical and functional expertise in Oracle Distribution and Manufacturing modules using Oracle PL/SQL.

Experienced in customizing (Oracle PL/SQL) and implementing Oracle Applications Modules like Order Management (OM), Shipping Execution (WSH), Inventory (INV), Purchasing (PO), Receiving (RCV), Work in Process (WIP), Bill of Material (BOM), Agile (Item Import to Oracle EBS), Project Accounting, Project Costing, Payables and E-Business Tax

Good experience with development of Forms, Reports, Forms customization (CUSTOM.pll), Database Triggers, Stored Procedures (Oracle PL/SQL), Web ADI, XML Publisher, PLSQL Developer, TOAD, Apex (Application Express), Oracle API, interface table, Oracle Alert, Oracle Workflow and Customization Oracle seeded Reports

Experienced in designing and customizing reports (Oracle PL/SQL) as per the business requirements using Oracle Reports

Expertise in design and development of RICE (Reports, Interfaces, Conversions and Enhancements) components using Oracle PL/SQL

Good working experience in Order to Cash (O2C) and Procure to Pay cycles (P2P)

Experience in Writing UNIX Shell Script

Oracle Application Tool on ORACLE PL/SQL; ORACLE Form 4.5/6(i)/10G, ORACLE Report 2.5/6(i)/10G, ORACLE Work Flow Builder 2/2.4/2.5/2.6, ORACLE Alert, ORACLE Designer, ORACLE AK Developer, ORACLE Discover, ORACLE Application Object Library ERP 10.7/11//12, Oracle e-business suite 11(i)(11.5.2 - 11.5.10) and R12(12.2), Web ADI, APEx (Application Express), Oracle Application Framework (OAF), TOAD; SQL Net; SQL Navigator Pro; SQL Loader; Data Loader, XML Publisher and PLSQL Developer

Core Competencies include: Oracle Distribution, Oracle Manufacturing

Oracle PL/SQL, SQL, UNIX

oOracle Reports, Forms, Shipping Documents and Invoicing

oBI Publisher and Forms Personalization

USA EXPERIENCE

CLIENT: Toppan Chunghwa Electronics Co., Ltd. Taiwan and Round Rock, Texas, USA NOV 2007 – NOV 2008

CLIENT: Aromat Corp. N.J. USA. New Providence, NJ, USA APR 2004 – MAY 2005

Optum Software Costa Mesa CA, USA MAR 1998 – MAR 1999

Customer Support Software Engineer (WMS)

EXPERIENCE

Independent Consultant (Freelancers) for EY (Ernst & Young) Advisory Services Inc, Taiwan

JUL 2016 – NOV 2016

CLIENT: AmTRAN Technology Corporation Taiwan office

PROJECT DESCRIPTION: AmTRAN is one of the biggest digital televisions, LCD monitors, LCD/LED, sound bar and streaming boxes manufacturing company in Taiwan. This project is a combination for rollout and upgrade in SuZhou China for Raken. Suzhou Raken Technology Limited is one of relationship enterprise of AmTRAN. AmTRAN ERP currently version is 12.1.3, and Raken ERP version is 11.5.2. The Mission is migrating Raken system into AmTRAN system.

RESPONSIBILITY: Systems Analyst Lead, Supply Chain Consultant for OM, PO and INV

1.Review 11 Raken system, and Build new solution for new version focus on Receiving and Shipping, discuss and meeting with key users, deliver BRM for each modules.

2.Setup new system base on R12 solutions, provide test scripts and hold user training, and writing BR100 Setup documents.

3.Convert R11 Programs to R12 system using Oracle PL/SQL, and testing with users.

Independent Consultant (Freelancers) for TATA Consulting Service Limited Taiwan Branch

MAY 2015 – SEP 2015

CLIEN: RICHTEK Technology Corporation Taiwan office

PROJECT DESCRIPTION: Richtek Technology Corporation is one of the world’s leading analog IC company, the project is a new implementation for Demantra and Advanced Supply Chain Management (ASCP) EBS R12 project.

RESPONSIBILITY: Associate Functional and Technical Consultant/ Architect

1.In charge of helping functional consultant to test and setup plan, after plan running finished, check the data results with key users.

2.Do Oracle Web Conference (OWC) with Oracle Global Support to identity product issue

3.Modify ERP Current functions and programs using Oracle PL/SQL for ASCP go live.

ABeam Consulting (Taiwan) Ltd. Taipei, Taiwan APR 2004 – MAR 2015

Oracle Associate Manager

R12, EBS,P2P,O2C,SCM (Supply Chain)

1.Specialized in Distribution modules in Oracle e-Business Suite, I have participated in more than 30 Oracle Applications projects and rollouts.

2.Design Global BPA, Global Procurement and intercompany transactions solution for Multi OU.

3.Familiar with P2P and O2C, including the modules of Inventory, Product Information Mgmt., Purchasing, i-Procurement, Payables, i-Expense, Order Mgmt., and Receivables.

4.Rollout Project for Toppan Chunghwa Electronics R12.

5.As a Distribution Module leader in oversea roll-out project of Huawei and in Oracle upgrade project of Aromat Corporation (10.7 to 11.5.9).

6.Built the solution for OM standard Order Hold function using Oracle PL/SQL for approval flow in SAC

7.Created the solution (Oracle PL/SQL) to link the relationship of job and sales order for Elite Group

8.Engaged in the upgrade project (Oracle PL/SQL) from 11 to 11i for OM module in Chi-Mei Project

9.Pre-going live and Post-going live support, include OM and PO in Promos project.

10.An expert in system customization using Oracle PL/SQL and acquaints with Oracle development tools (Oracle Developer 2000(10G), Oracle Alert, Oracle Workflow, Oracle Discoverer).

11.Worked as a technological leader to help client IT using Oracle PL/SQL to modify and develop standard or new functions for Distribution and Manufacture modules in Chang-An Project

12.Technological training (Oracle PL/SQL) client’s IT for Oracle tools and Application for BENQ and Well power.

13.Developed Manufacture Scheduling System using Oracle PL/SQL for Premier Corporation

14.Developed Shipping Schedule using Oracle PL/SQL between Job and Sales Order and built new system for automatic job creation for ECSM project

15.Modified rescheduling standard function of Internet Supplier Portal for Chi-Mei (Oracle PL/SQL)

16.Used AOL structure to develop project management system for MXIC Project

17.Modified the standard Workflow account generator (Oracle PL/SQL) for Lite-On IT project

18.Created new workflow (Oracle PL/SQL) for New item PO in San-Yang Project.

19.Developed the GUI/VAT Invoice system (Oracle PL/SQL) for President PEC Project

20.Modified Standard FA account Generator (Oracle PL/SQL) for Ho-Tai Project.

21.Have the experience about Oracle Business Intelligence and a main force in the BI Team

22.Attend Oracle BI Applications workshop and help built the POC Scenario

Major Clients as the following:

CLIENT: GARENA INTERACTIVE HOLDING LTD. Taipei, Taiwan NOV 2014 ~MAR 2015

PROJECT DESCRIPTION: GARENA is a leading platform provider for online PC and mobile digital content, eCommerce and payments across Asia, serving millions of users.. In this project, we support GARENA for EBS R12 project, including project management (PJC).

RESPONSIBILITY: Systems Analyst Lead, Oracle PL/SQL Architect

1.Customize a LOV in OAF(VO Extension)

2.Modified OM header and Line workflow (Oracle PL/SQL)

3.Create Order import package, import order from legacy system

4. Create Oracle Alert to send mails

5.Writing MD050 deliver to clients

CLIENT: GEM Services, Inc. Kaohsiung, Taiwan FEB 2014 ~NOV 2014

PROJECT DESCRIPTION: GEM Services is a multinational semiconductor assembly and test contractor. Founded in 1998, GEM specializes in small-outline surface-mount packages for power management semiconductors. In this project, we support GEM rollout Oracle from China to Taiwan, and integration with GEM MES system.

RESPONSIBILITY: Systems Analyst Lead, Supply Chain Consultant (SCM) / Oracle PL/SQL Architect

1.Build solution for Taiwan rollout focus on Receiving and Shipping

2.Develop Oracle PL/SQL to integration with GEM MES

3.Review all customization reports and functions make sure users can use.

4. Create Oracle Alert to send mails

5.Writing BR100 and MD050 deliver to clients

6.Create Procure to Pay cycles (P2P) flow

CLIENT: O-film Tech Co., Ltd. Nanchung, China OCT 2012 ~ DEC 2013

PROJECT DESCRIPTION: O-film is a touch panel and digital camera manufacturer. In this Oracle EBS R12 project, we design solutions for 3 sites (Shenzhen, Nanchang and Suzhou) and 27 inventory organization transactions, including iProcurement, IR/ISO, inter-company and global procurement.

RESPONSIBILITY: Systems Analyst Lead, Supply Chain Consultant(SCM) / Oracle PL/SQL Architect

1.Build the transaction flow between each company focus on Receiving and Shipping

2.Develop solutions for Global BPA

3.Create Data Migration programs to Oracle Interface tables for Item, PO and BPA (Oracle PL/SQL)

4.Modified CUSTOM.pll to meet users requirements

5.Use XML Publisher create reports

6.Add new triggers for Oracle Personalization

7.Create Oracle Alert to send mails

8.Writing BR100 and MD050 deliver to clients (SDLC,AIM)

9.Create Procure to Pay cycles (P2P) flow

CLIENT: MSIG Mingtai Insurance Co., Ltd. Taipei, Taiwan MAR 2012 ~AUG 2012

PROJECT DESCRIPTION: Mingtai is an insurance Company. In this project, we help Maingtai to use Oracle EBS R12 Finance module (E-Business Tax), including implement standard function and build solution for special requirement.

RESPONSIBILITY: Extentation Consultant

1.Develop Web ADI (Oracle PL/SQL) for Insurance Data upload

2.Create Reports for Finance KPI data

3.Writing MD050 deliver to clients (SDLC,AIM)

CLIENT: Huawei Technologies, Sao Paulo and Campinas, Brazil MAY 2010 ~ DEC 2011

PROJECT DESCRIPTION: Huawei is a telecom equipment manufacturer and solution provider. In this project, we support Huawei rollout Oracle EBS system in overseas subsidiaries, including developing solutions to fulfil local requirements.

RESPONSIBILITY: Systems Analyst Lead

1.Develop Spare Parts Management Solution focus on Receiving and Shipping

2.Oracle Inventory, Purchasing, and Order Management Implementation

3.Desire Web ADI (Oracle PL/SQL) for order import, using OM interface for unit price updated, Auto call RAM order import API.

4.Writing BR100 and MD050 deliver to clients (SDLC,AIM)

CLIENT: SOLAR APPLIED MATERIALS TECHNOLOGY COR, Ltd. Tainan, Taiwan MAY 2009 ~ APR 2010

PROJECT DESCRIPTION: Oracle Application EBS R12 implementation for Taiwan.

RESPONSIBILITY: Designing (both high level and detail level) requirements gaps MD050 providing data mapping

between legacy system and Oracle Applications. (SDLC,AIM)

CLIENT: Chengdu Huawei Symantec Science & Technology Co., Ltd, Chengdu, China JAN 2009 ~APR 2009

PROJECT DESCRIPTION: Huawei Symantec is a telecom equipment manufacturer and solution provider. In this project, we support Huawei Symantec rollout Oracle system in Hong Kong, including developing solutions to fulfil local requirements.

RESPONSIBILITY: Systems Analyst Lead

Oracle Inventory, Purchasing, and Order Management Implementation.

1.Writing BR100 and MD050 deliver to clients (SDLC,AIM)

2.Worked on Oracle EBS focus on Receiving and Shipping

CLIENT: Toppan Chunghwa Electronics Co., Ltd. Taoyuan, Taiwan and Round Rock, Texas, USA NOV 2007 ~ NOV 2008

PROJECT DESCRIPTION: Oracle Application EBS R12 implementation for Taiwan, upgrade from 11 to 12 for USA, and over sea rollout.

RESPONSIBILITY: Three countries Project include Taiwan, Japan and USA. In charge of the MFG process flow implementation and template, order Entry. Contact window for Taiwan with Japan and USA, deliver Gap documents. Train super users.

1.Writing BR100 and MD050 deliver to clients (SDLC,AIM)

2.Create Procure to Pay cycles (P2P) flow (Oracle PL/SQL)

CLIENT : Huawei Technologies MAR 2006 ~NOV 2007

Mauritius, Bangladesh, Kenya and South Africa, Spain and Portugal, Romania and Sweden

PROJECT DESCRIPTION: Huawei is a telecom equipment manufacturer and solution provider. In this project, we support Huawei rollout Oracle system in overseas subsidiaries, including developing solutions to fulfil local requirements.

RESPONSIBILITY: Systems Analyst Lead

1.Develop Spare Parts Management Solution (Oracle PL/SQL) focus on Receiving and Shipping

2.Oracle Inventory, Purchasing, and Order Management Implementation

3.Countries include: Third phase (Romania and Sweden 11.5.8), Second phase (Spain and Portugal 11.5.8), First phase (Mauritius, Bangladesh, Kenya and South Africa 11.5.8).

4.Writing BR100 and MD050 deliver to clients (SDLC,AIM)

5.Create Procure to Pay cycles (P2P) flow

CLIENT: Novatek Microelectronics Corp., Ltd, Hsinchu, Taiwan OCT 2006 ~MAY 2007

PROJECT DESCRIPTION: Novatek is a IC Design manufacturer and solution provider. In this project, we design Oracle solutions for Novatek’s operations on finance, Distribution and Shop Floor Management (OSFM).

RESPONSIBILITY: Systems Analyst Lead

1.Implementation in Order Management module for Shipping schedule

2.Discuss with key users, understand Novatek requirement, write system analysis document

3.Training key users. Co-work with client ITs, help Novatek to know Oracle tools (Oracle PL/SQL)

4.Writing MD050 deliver to clients (SDLC,AIM)

CLIENT : Taiwan Mobile, Taipei, Taiwan JUL 2005 ~ SEP 2006

PROJECT DESCRIPTION: Taiwan Mobile is a telecommunication services provider. In this project, we deliver Oracle application implementation (Project costing and Project accounting) and system integration services.

RESPONSIBILITY: Systems Analyst Lead

1.Implementation in Purchasing including gathering business requirements, mapping requirements to Oracle

2.Designing (both high level and detail level) requirements gaps, providing data mapping between legacy system and Oracle Applications (Oracle PL/SQL)

3.Performing unit/integration testing and providing key user training

4.Writing MD050 deliver to clients (SDLC,AIM)

CLIENT : Promos Technologies, Hsinchu, Taiwan MAY 2005~ NOV 2005

PROJECT DESCRIPTION: Promos is a Semiconductor manufacturer. In this project, Tracy support Promos Pre-go live and Post go live support, include OM and PO.

RESPONSIBILITY: Functional and Technical Lead Consultant

1Debugging and trouble shooting for Customization Shipping schedule

2Work with key users from UAT1, UAT2 and PROD; modify solutions and training users for Oracle Shipping standard function

3Write documents to teach users Oracle Shipping flows

4Discuss with key users, understand users’ requirements, and mapping their requirement to standard function or Customization modules

5For PO, teach users using Oracle standard Receiving(RCV) interface and API, and PO flow (Oracle PL/SQL)

6Post-going Support, stand by in client site for any issues

7Check data for users and do research on each issue, define the issue is bugs or data issue, and check Oracle Metalink to find out solutions

8Writing MD050 deliver to clients (SDLC,AIM)

9Create Procure to Pay cycles (P2P) flow

CLIENT : Aromat Corp. N.J. USA. New Providence, NJ, USA APR 2004~ MAY 2005

PROJECT DESCRIPTION: Aromat is Panasonic North American branch, the project is an upgrade project from 10.7 to 11.5.8.

RESPONSIBILITY: Distribution Functional and Technical Leader

1.In charge of the DIS module (OM, PO, INV) upgrade part, for both of Functional and Customization focus on Receiving and Shipping

2.Build the solution for new 11i functions include intercompany, drop shipment, consignment flow, follow oracle standard doc

3.Finish the upgrade process, check the history data, make all orders upgrade, include open and close orders

4.Convert customization items from 10.7 to 11i (Oracle PL/SQL)

5.Fulfill users demand, provide solutions for technological extension, writing the documents

6.Writing BR100 and MD050 deliver to clients (SDLC,AIM)

7.Create Procure to Pay cycles (P2P) flow

Oracle Taiwan Inc. Consulting Service Taipei Taiwan (Oracle INC Since APR 1999 – APR 2004)

Senior Consultant

Provided training class for clients

Client: Chi-Mei Corp. Jan 2003, Workflow.

Client: Benq Corp. Sept 2003, Application, Report and Form, WorkFlow, Alter, ERP DIS

Module (11i), ER-Model, SQL.

Client: Depo Corp. Dec 2003, Application, Report and Form.

Client: Tek Core Corp. Dec 2003, Application, Report and Form.

Major Clients as the following:

CLIENT: BENQ Corp. (BQE) DEC 2003 ~MAR 2004

PROJECT DESCRIPTION: Oracle 11i

RESPONSIBILITY: Functional and Technical Consultant

1.Build the solution together with other team members, fulfill users demand

2.Provide solutions for technological extension, act as a technological leader teach the R&D term in china to achieve the Gaps and technological extension part, include: price list security control, carton checking, check minimal order amount, payment term check, Inter-company Order Flow, commission percentage maintain, order hold function, Change Shipping Warehouse (Oracle PL/SQL)

(Receive thanks letter from client)

CLIENT : Premier Corp., Ltd. MAY 2003 ~ DEC 2003

PROJECT DESCRIPTION: This project is for 3 sites, include Taiwan, China and Hong Kong, 3 set of Books, 9 Inventory organizations.

RESPONSIBILITY: Functional and Technical Consultant

1.Manufacture Scheduling system, IR/ISO and inter-Org transfer, Import/export custom documents process, MRP auto update IR/ISO, Resource Change (Oracle PL/SQL)

2.Under client’s requirements, Discuss and meeting with key users, define the solutions, provide solutions for customization, writing the documents

3.Create new form, let user can do simulation job scheduling, call standard pro C program to calculate the job completion date by different production line

4.Create DB-trigger for WIP operations, when resource change, update the correct usage rate

5.Get transactions from rcv_transactions table and wsh_delivery_details table for different countries

6.Define different transaction type for import and export custom documents

(Receive thanks letter from client)

CLIENT: XAC Corporation MAY 2003 ~OCT 2003

PROJECT DESCRIPTION: ERP MFG module Oracle (11i) 11.5.8

RESPONSIBILITY: Technical Consultant

1.Build the solution together with other team members, fulfill users demand

2.Provide solutions for technological extension, writing the documents Work in Process

3.Create process for “Rework Job”, Auto replace the BOM for the Rework job, create new form, for batch sub-inventory transfer (Oracle PL/SQL)

(Receive thanks letter from client)

CLIENT: Unitech Electronics Co., Ltd MAR 2003 ~ MAY 2003

PROJECT DESCRIPTION: Unitech provides distribution service on information products and manufactures automatic data collector equipment with own brand. The goal of this project is to help Unitech to redesign service on line system.

RESPONSIBILITY: Functional _ Technical Consultant

1.Build the solution together with other team members, fulfill users demand

2.Provide solutions for technological extension (Oracle PL/SQL), writing the documents

3.create new workflow to sent notification for sale order RMA service reports

(Receive thanks letter from client)

CLIENT: PMC Prince Motor Corp MAR 2003 ~ AUG 2003

PROJECT DESCRIPTION: PMC is an Automobile manufacturer. The project tasks include Oracle ERP implementation.

RESPONSIBILITY: Functional and Technical Leader

1.Using Sourcing Rule auto create Blanket Release, KD set PO detail create, calculate PSPO item unit price, update PO unit price

2.Build the solution (Oracle PL/SQL) together with other team members, fulfill users demand

3.Provide solutions for technological extension, writing the documents

Create new form, after PO create, when receiving the items can re-calculate the unit cost, base on the supplier’s invoice

(Receive thanks letter from client)

CLIENT : Chi-Mei Corporation OCT 2002 ~ FEB 2003

PROJECT DESCRIPTION: Internet Supplier Portal Project.

RESPONSIBILITY: Technical Consultant

1.Modify standard function(Oracle PL/SQL) for re-schedule, let Supplier and Buyer can negotiate ordered item promised date

2.Discuss requirements with key users, create a new function let buyer create the new revision of PO, then start workflow to notify supplier the new schedule date of delivery, supplier can reject or acceptance the new Revision

3.Modify java code and using oracle AK developer for supplier to re-schedule promised date, split PO line, then start workflow send notification to Buyer, if all acceptance then creates new revision PO, update tables and insert archive tables as standard function did

(Receive thanks letter from client)

CLIENT: Chang-An Automobile (Chong-Qing, CHINA) JUL 2002 ~ SEP 2002

PROJECT DESCRIPTION: ERP DIS/MFG module (11i), INV, PO, WIP, BOM, QA, MRP, ENG...

RESPONSIBILITY: Technical Leader

1.Follow BRM, work as a technical leader, teach user’s IT and partners to modify standard manufacturing and distribution system, and create customization functions to reach client’s requirements

2.Training user’s IT and partners for ER- Model, Coding Standard, Name Ruling, application structure, and how to register forms, reports and batches under application, and how to create menus, groups, and functions, value sets

3.Review all the SA/SD (system analyst / system designer) documents, control the gradation of the customization, monitor some core functions

4.Create new functions (Oracle PL/SQL), call ‘material flow control card’, use bar code to control the material flow on the whole manufactory, this functions can reduce the cycle count process and change the time point for payables

(Receive thanks letter from client)

CLIENT: President PEC Corp. (Tainan, Taiwan) (PHASE 2) MAY 2002 ~ JUL 2002

PROJECT DESCRIPTION: ERP MFG module Oracle (11i), OPM

RESPONSIBILITY: Technical Consultant

1.Working on OPM PO data conversion, cost update (Oracle PL/SQL)

2.Create request set, include SQLLOADER load Data from excel to database, then insert into interface table, then call standard API to PO Table, create sqlplus script insert into cost update standard table

(Receive thanks letter from client)

CLIENT: ECSM Corp. (Shen-Zhen, CHINA) (PHASE 1) NOV 2001 ~ FEB 2002

PROJECT DESCRIPTION: APS (Advanced Planning Schedule),

Manufacture Scheduling (MSCH), Material Control (MC), Computer Aid Issuing System

(CAI).

RESPONSIBILITY: Functional and Technical Consultant

1Build the whole system, can create jobs automatically, and base on sale order to create jobs, bind the distribution and manufacture system, after then do manufacture scheduling (Oracle PL/SQL)

2base on order management schedule ship date, use the recourse of production line completely, to match the target of ship the orders on time, and follow the result of manufacture scheduling, to do computer aid issuing system, to reach the mission of getting all components

(Receive thanks letter from client)

EDUCATION

Masters of Science in Information Systems, Northeastern University, Boston, MA, 1998

Bachelor of Science in Chemical Engineering, University of Missouri-Columbia, 1996

CERTIFICATIONS

11i10 Sales Technical Presales Champion Proficiency Assessment (25-MAR-2008)

11i10 Procurement Technical Pre-Sales Champion Proficiency Assessment (24-MAR-2008)

11i10 Procurement Implementation Champion Proficiency Assessment (08-MAR-2006)

11i10 Procurement Implementation Champion Awareness Assessment (07-MAR-2006)

11i10 Applications Developer Implementation Champion Proficiency Assessment (07-MAR-2006)

AWARDS

The Best Project Team (ECSM China) of 2002 Q3, Oracle Taiwan OCS, March 2002

The Best Project Team (ABIT) of 2001, Oracle Taiwan OCS, May 2001

Certificate of Achievement, Dean's Honor Roll, MU-Columbia, Dec 1996

Contact this candidate