Management Supply Chain

DAVID YIP

** ******* **.

Brampton, Ontario

L*S 1X7

Tel Home: 905-***-****

Tel Cell: 647-***-****

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

PROFESSIONAL PROFILE

. Solutions-oriented with success in implementing systems to automate

processes

. Knowledgeable experience in a manufacturing and distribution environment

. Strong business analysis and technical skills to accomplish company

objectives

. Proven ability in improving, streamlining and implementing existing or

new processes

. Knowledge of security policies, procedures and problem management

. Ability to work under pressure and adapt to a changing environment

. Excellent organization, project management, time management, detail

oriented skills

TECHNICAL SKILLS

. Computer skills: AS/400, RPG400, RPGLE, Query400, BPCS V4.0 BPCS V6.0,

Cognos PowerPlay Series 7, CoLos Create, Pdfing, Robot, MAPICS DB, QMS,

. MS Office, Project, Access, Lotus Notes, iRely, PowerPlant, QuickBooks,

Data Tracker, Keyfile, Service Tracker, LIMS

. Customer Order Management, Order Entry, Billing, Invoicing, PRO,

A/R, A/P, G/L,

Supply Chain Management, Inventory,Purchasing, Manufacturing MRP,

SFC, BOM

ACCOMPLISHMENTS

. Designed and created analysis reports of all applications for management

decisions

- Reconcile inventory and sales to balance control totals on a daily

basis for A/R, billing, costing and inventory

- Daily and monthly item/customer sales reports with costs and margins

for Sales & Marketing

- Order Frequency Report for customer order management and purchasing

department to monitor product movement patterns for savings in

logistics

- Troubleshoot and analyze when errors occurred

. Implement process for batch/lot control

- Setup bar coding scanning for batch and location control in warehouse

. Created and designed Cycle Count Process

- Streamlined downtime of system with scanning of products

DAVID YIP

EMPLOYMENT HISTORY

Technical Support Jan/2009 - Current

Bourne Technical Support Toronto, ON

. Setup and Installation and repair of printer and copier peripherals

. Training of users for printing, scanning and faxing functionalities

. Provide technical support to customers for hardware and software issues

. Troubleshoot networking issues for clients

Operations Coordinator (Contract) Aug/2012 -

Dec/2012

Mother Parkers Ajax, ON

. Daily reconciliation of commodities inventory into BCPS database

. Created inventory reports from Cognos PowerPlay application

. Troubleshoot inventory problems and provided corrective actions to users

. Created AS400 queries to streamline processes

. Maintained and created CoLos bar coding files for packaging

. Asset management of hardware to corporate IT

BCPS Consultant (Contract)

WellSpring Pharmaceutical Oakville, ON

June/2011 - Dec/2011

July/2010 - Dec/2010

June/2009 - Nov/2009

Aug/2008 - Nov/2008

. Automate process of updating BPCS inventory files & G/L accounts from

third party

logistics data file

. 3 Way Matching of Accounts Payable entry with cost centers and G/L

accounts

. Creation from BPCS A/P files to upload an ASCII file for electronic

payments

. Auditing services and testing of programs for BPCS FDA Part 11 compliance

. Create G/L transactions to debit inventory and accrued A/P for PO

receipts

. Maintained documentation for creation or modification of programs

. Modification of invoice printing and emailing to customers using PDFing

. Maintenance of BPCS programs

. BPCS End User Support

. Perform month end closing processes

Office/Network Administrator Oct/2005 -

Mar/2008

Insight IT Mississauga, ON

. Provided technical support onsite and offsite to customers

. Logging of calls to Service Tracker application

. Follow-up of calls completed daily with clients

. Build or rebuild of computer systems for users

. Configured users for MS Outlook or Outlook Express

. Troubleshoot hardware problems e.g. PC's, notebooks, printers

. Technical support with users on software applications

. Negotiated contracts with vendors on supplies and services

. Maintenance of QuickBooks database on item and customer master files

IT Manager/IT Site Coordinator

Jan/1986 - July/2005

Givaudan Canada Inc.

Mississauga, ON

. Performed Project Planning tasks for the organization

. Managed in-house staff of 3 and external business consultants for project

implementation

. Identify and analyze processes and provided solutions to enhance systems

and business process flow

. Data modelling on test environment for user acceptance

. Designed and created business analysis reports from the BPCS database for

inventory and sales management

. Ensured consistent data integrity for BPCS database

. Provided application support for supply chain management and configurable

enterprise

financials

. Performed RPG and Query programming on AS/400 to automate manual data

analysis

. Coordinated meetings with business units and provided BPCS in-house

training to users

. Reconciled inventory and sales transactions to control totals daily

. Change management process on new and modified programs onto production

system

. Developed and implemented "Disaster Recovery Plan" to secure daily

business operations

. Technical support for Wan / Lan and MS Office XP applications

PROFESSIONAL DEVELOPMENT

. Supervisory & Management Training Project Management

. BPCS Concepts & Applications BPCS Supply Chain Management

. Quality Training COE Training

. Microsoft Office Lotus Notes

. Network Administration Herzing College Diploma

Contact this candidate