PROFESSIONAL SUMMARY:

15+ Years Dedicated ERP Functional professional with strong technical background to take a major roll of implementing Global, Multi Orgs, Multi Languages ERP system, involved more than 10 life cycles implementations. Strong manufacture experience with 13 years discrete manufacture company and 2 years process manufactures (OPM).

TECHNICAL SKILLS:

Oracle Modules: WMS,OPM, GL, FA, AP, AR, PO, OM, INV, WIP, BOM, Shipping, RMA,MRP, Supply Chain, Core HR, Payroll, HRMS, Self Service, iProcurement System Administration, Hyperion, Demantra, BIS View, ASCP, Agile, EDI, E - Commerce Gateway

Languages/Tools & Utilities: SQL, PL/SQL, Unix Shell, Business Objects, SQL *Loader, TOAD, Discoverer4i/Discoverer 10g, Oracle workflow 2.6 and HTML, XML Publisher, Java, ASP, JSP, VB,C++.C, OEM, Oracle Server Manager, Sql*Loader Export/Import, Net8, API, Microsoft ODI,SSIS, ODI Topology Manager, ODI Designer

ERP: Oracle Applications 11i (11.5.5, 11.5.7,11.5.9,11.5.10) R12.1. R12.1.3

Databases & Operating Systems: Oracle 11i/10g/9i/8i, SQL Server 2008, Sun Solaris8, HP-UNIX, Windows NT, Windows XP, MS-DOS, Linux

Development methodology tools: Qlickview, Discoverer, Oracle Report/Form, XML, BI Publisher, Workflow, Toad, Sql*Plus, Sql Load ERWIN,SSIS,ETL tool, ODI, API, e-Commerce Gateway, EDI

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Responsibilities:

• Created three new DCs for Chile.
• Implemented internal requisition to internal sales order with shipping document, standard POCrossed modules INV,PO,OM, and AR, SLA

Lead of implementation of HRMS

Confidential

Responsibilities:

• Order to AR invoice, advanced price to meet sale promotion/discount activities
• Standard PO and Requisition, Internal requisition and internal sales, blanket PO, gobble blanket POContract PO.
• SCM production support,
• Month end, year end close support,
• Inventory physical cycle coining support. Resolved all of pending transactions.

Confidential

PO support

Responsibilities:

• Resolved all of different types PO issues such as standard PO, blanket PO, global blanket PO
• Standard requisition, internal requisition.
• Troubleshooting approve hierarchy, clean up all of POs. (close or cancel or processed)
• Receiving issues.

Confidential, Eatontown, NJ

Oracle ERP Business Analyst

Responsibilities:

• Book a sales orders in OM for an ATO item => Discrete Job automatically created by the Auto create Final Assembly concurrent process “like an FG Make item”
• Routing of the FG item will consume the SA from inventory when the WIP job starts
• Routing will include an OSP step; the Discrete Job will trigger the creation of an OSP purchase requisition for the FG item “like an FG Buy item”
• FG Item will be received against the OSP PO into Oracle Inventory; receipt will complete the Discrete Job
• Inventory related implementations
• Shipped Items Tracking
• Some of Confidential items don’t shipped to designated Cisco VMi, but shipped to third party inventory
• To do test before goto cisco inventory, therefore, therefore the performance and item tracking becomes very important. Upon performance and tracking purpose, we implemented “in-Transit” bucket once item shipped out of Confidential inventory, then move to Third party inventory once we get
• Receiving report from third party. Once third party (test hub) shipped out item, we move item to another “in-transit” bucket, until we get cisco receiving report, we move the item to the cisco VMi,
• This also help financial group track the item cost.
• Serialized control and logistic numbers related set up to help business to track the items.
• PTP (purchase order to payable) support and set up
• Daily support anything wrong with PO, approve list, forward to different manager for approve,
• Cancel PO, correction of PO after receiving.
• Implemented punch-out function with insight supplier.
• Implementation of iProcurement
• Troubleshooting the cause of unexpected results of ASCP report.
• Oracle HR implementation
• Implemented HRMS core, Self-service, interface to ADP, interfaces to benefit providers.
• Set up Benefits for health, Dental, Life, Flex Account.
• Developed outbound programs for HR salary data to ADP. HR benefits Data files to Anthem health supplier, Guardian dental supplier, Omaha Life insurance supplier, Ceridian for out of employment employees benefits
• Inbound for Japan HR data including position, assignments, salary allowance, bonus, performance review rate ect. Detail information.
• Daily Support for HR user tickets.
• Developed Discoverer reports Attrition, Benefits, Salary, assignments, person detail etc.
• OTC support and Set ups (including intercompany sale)
• Know OM/WSH/INV/WIP/BOM/AR/GL from End to End, not only know the data molding, data structures in database end, but also know user functions in the forms and set ups.
• Daily support sales order from entering to shipping. Helping move forward all of transactions stuck in Inventory, serial number, material transaction, WIP, WF, Interface table etc. open ticket with Oracle if need more help.
• Help auto invoice creation if there is any reason invoices are not created.
• Customized oracle reports (revenue, gross margin, item cost and price, shipped orders with serial number etc.)
• Supplied solution and Implemented automated shipping documents (commercial invoice, packing slip etc. automatically distributed to FedEx, customer and our sales team
• Customized workflow for price and export approve.
• Support final assembly outsourcing (ATO item) at contract manufacturers in China and Thailand with consumption of consigned components and global drop shipments to customers.
• Developed global web barcode shipping label accessed by China, Japan, Thailand, and many global shipping locations in US.
• Bill of Material
• Help checking set up of bill of material once anything wrong with wip including the interface of Agile, SCMnet GUI
• Financial support
• Help monthly close, push thru any pending transaction or restart any stopped scheduled concurrent program, find cause if any clearing account with balance, reconcile reports.
• Lead and implementer of Confidential ERP calendar change.
• For the merge, Confidential calendar has to align to Oclaro 4-4-5 GL calendar from current month end fiscal calendar. Lead of CRP and UAT, did all set ups and coordinated Japan, US and Europe financial users testing, sign off.
• Did all of closing process from Inv., PO, AR, AP and GL, till consolidated books in test instance.
• It is more difficulty to close books in test instance than production since I have to restart all of Backend concurrent programs, fill in users rule if user cannot participate test.
• The testing involve all of Inventory transactions, OTC, PTP, WIP, AR/AP/GL transactions cross all of organizations, Bus etc. I identified all of errors and made project done on time.
• ASCP & Demantra Implementation.
• As application analyst, took major roll from gathering requirements till going live and post live.
• Planned Demantra and ASCP instances and architecture.
• Implementation of data collection
• Set up Items, BOM, suppliers, inv
• Prepared test instances and scripts for UAT (User Acceptor Test)
• Helped CRP
• Helped User to set up ASCP plan, sourcing rules.
• Daily support and work with Supply Chain Manager
• Created ASCP reports such as End Demands, Supply Pegging, Buyer sheet,
• Excess and Obsolete Detail etc.
• CM (Contractor Manufactory) integration as part of ASCP
• Interface programs to get WIP,PO confirm and On hand Qty, supply and Demand from CM
• Added CM inventories to Confidential sub- inventories. Such as in-transit, vmi, raw material at WIP, Raw Material at Product line,Raw material at store, FG etc.
• Set Up Two-Level Plans
• Use only critical components and bottleneck resources
• Includes end items (MPS Planned)
• Includes components (MRP Planned) that are identified as critical
• Includes all items not planned in MPS plan (e.g. resistors, capacitors etc )
• Daily support for ASCP
• Work with Supply Chain Team daily base to help check the ASCP plan results, reports, helping
• Check the set up whenever the Demand or Supply are not the same as user expected.
• Helping Users to upload promise date, forecast sets etc.

Oracle ERP Interface Developer

Confidential

Responsibilities:

• Developed Interface programs including: Shipping data to FedEx, Positive Pay to Wells Fargo, Agile BOM to Oracle ERP, e-commerce gateway data for EDI transactions, ADP connection to send HR salary data to ADP software. HR benefits Data files to Anthem health supplier, Guardian dental supplier, Omaha Life insurance supplier, Ceridian for out of employment employees benefits.
• Developed Promise date upload template and program, MRP upload template and program, forecast data Inbound and Outbound with BWT (Board WalkTech Forecast System).
• Implemented the company's first automated B2B processes via EDI with a major customer. Served as a Developer and Functional Analyst on the project to receive inbound orders, long-term sales forecasts, and consigned inventory pulls, and outbound invoice via EDI. Created daily business activity monitoring e-mails with Oracle Alert. Created inbound outbound files EDI 850/855/810/846/861/862.
• Developed APIs; Auto ship confirm .auto moving transactions, GL import, BOM, item, receiving transactions.
• GL Expert, helped set up and test of multi-currency for General ledger, well-know how oracle use daily rate, period rate, historical rate. Conversion, translation, revaluation etc. developed G/L trial balance reports to show functional currency, foreign entered currency, foreign translated currency balance to help manager to analyze the exchange rate impact on our business.
• Did set up of consolidation (mapping, copy and elimination set ups and tests) to consolidated three set of books to global set of book.
• Supporting Fixed Assets, migrate from one system to another.
• Implemented positive pay with Wachovia Bank
• Installed and set up portal server with discoverer.
• Implemented the company's first automated B2B processes via EDI with a major customer. Served as Developer and functional lead on the project to receive inbound orders, long-term sales forecasts, and consigned inventory pulls via EDI. Created daily business activity monitoring e-mails with Oracle Alert.
• Cost Manager - Set up cost for items including FG, Parts, to do cost roll up test
• Troubleshooting AP invoice, close. AP, reconcile with GL etc.
• Trained users in China to do receiving and shipping. We have ATO (Assemble to Order) items which users in CM need to do receiving component against PO, then ship to our customer directly.
• Support monthly closing process; include AP/AR/GL/INV/FA.
• Lead of migration for new business, set up a new operating system from OTC, PTP, GL.
• Set up consolidation of GL for multi orgs.
• Multi Language Expert, UTF8 etc set up at OS Database and application. NLS parameter etc environment setting Japanese Japan.JA16SJIS, UTF8 etc Character set convert.

Confidential, San Jose, CA

Oracle DBA

Responsibilities:

• Database physical/logical design by Erwin for Confidential v6.0
• Design central and local database, implement a distributed database ( replication, dblink, snapshot) for global trading
• Using Oracle 8i InterMedia text service for Multilanguage Search
• Maintain /Support Production Database by 24*7
• Apply patch, migrate and upgrade oracle
• PL/SQL programming (package, partition table, trigger, dblink etc)

Confidential

Oracle DBA

Responsibilities:

• Migration dBMagic+Beterive to dBMagic+Oracle
• Upgraded Oracle7.3.3 to Oracle8.05
• Transfer data from other system to my system using SQL*Load /export/import
• Programmed script file for auto install Oracle Database and configuration network using SQL&C
• Programmed Excel using macro + VBA