Planner and Inventory Control

SKILL & ABILITIES:

Proficient with SAP Modules, JDE, IFS systems. Meet all requirement under ITAR

Proficient with Microsoft Word, Power Point, Excel, Access, and Visio. Microsoft Excel Marco and VBA, Pivot Table, Formulation. Create Excel forms. Operating Systems: Win XP, Win Vista, Wind 7, Win 8, Server 2008

Diagnose and analyses computer problem. Zebra label printer setup and create label format.

10 years of experience in electronics industry. Planning, analyzing material inventory and software test.

EXPERIENCE:

Ameditech - San Diego, CA May 2017 – Aug 2017

Production Planner II - Contractor

Supervised the manufacturing production schedule to reach on time delivery.

Used advanced MS Excel functions including pivot tables, v-lookups and macros to create and document BOM, inventory, assembly of products and incoming and outgoing shipments.

Maintained and updated the Build Requirement List for all new and existing product.

Continual assessment and improvement of raw material accruement strategies and communication partners to maintain on time delivery of all none chemistry raw materials, chemistry strips & chemistry bars

Built and controlled safety stock with expiration date. Communication & coordination making daily, weekly schedule with Supervises, Quality Control and Purchasing, Customer Services and Operation.

Supported and made schedule for existing and new product.

Kontron America - Poway, CA 92111 June 2006 – Jan 2017

Demand Planner and Inventory Control Planning

Used SAP to process tasks for demand material planning and inventory.

Demanded forecast at multiple levels to ensure uninterrupted supply parts while maintaining optimal inventory levels. Reviewed historical sales trends, backlogs and set safety stock level.

Used SAP modules and advanced MS Excel functions including pivot tables, v-lookups and macros to manage inventory and forecasting.

Provided demand input to Purchase Processing in create the supply plan on existing items, new product.

Analyzed and maintained sufficient inventory levels to meet production, R&D and Test Engineering orders.

Generated Metric Inventory to report material movements and defect of each product lines.

Maintained, updated inventory records & cycle counts daily. Reduced material excess to stock and cycle count all projects. Applied working with sort, sanitize, standardize, sustain and safety.

Reported any inventory issues to management and action shortage items with purchase orders.

Supported configuration change by ECO & ECR. Support production planning.

Updated new material NPI development plans. Assisted in generation purchase to meet production.

Analyzed and reported obsolete and excess issue to management.

Analyzed, reported on metrics and recommended ways to improve the inventory control function.

EDUCATION:

American Sentinel University, Birmingham – Alabama

Bachelor of Science in Computer Science – 2005

SDCE – San Diego

Certify of CCNA 01- 2011

San Diego City College

Certificate of Auto Mobile Technician – 1998

RELEVANT COURSE:

C++, C#, J++, Java, JavaScript, Visual Basic, Python

Turbo Pascal, HTML, XML, Data Abstraction, Data structure, Data Base

Contact this candidate