Sales Supply Chain

Resume: Ed Armstrong

Home:

Home: 949-***-****

Cell 650-***-****

************@*****.***

Summary

Microsoft Access Database / VBA / SQL Developer experienced in Financial, Operations, logistics, MRP systems, supply chain design and implementation

Active Department of Defense Secret Clearance

Experience:

Jan 2015- Present Microsoft Access / VBA / SQL Consultant

LEDEngin – rolling 16 week MRP System integrating backlog, raw material, WIP, Inventory, Open POs, Forecast. The system shows net to forecast, net to backlog,and ranked customer reports as well as Pivot table and Pivot reports.

McLaughin Research - Classified

Yokohama Tire - Repaired and maintained 6 “Mission Critical” Microsoft Access databases linked to over 90 tables in SQL server databases in the Finance organization. Converted all databases and VBA code to Microsoft Access 2016 and re-connected each to relevant SQL Servers.

NBTY – Developed a Training Tracking database for a large Pharmaceutical manufacturing company.

Naval Coatings – Developed a SAGE 300 SQL linked Invoicing system for a Navy subcontractor

SBR – Developed a Project / Budget Tracking Database for a construction company

Jan 2011 – Jan 2015 LEDEngin, Inc

Developed an algorithm for dramatically improving ability of LED manufacturing process to hit the desired color target. The Patent application is completed. Established a complete and effective supply chain and associated software (Tensoft Fabless Semiconductor Manufacturing / Great plains).

Improved a legacy MS Access system to include links to Tensoft and Great Plains financial information.

Jan 2008 – Jan 2010 Mobius Microsystems / IDT

Developed a Quality system using Flow charts on VISIO and an Access Database as well as a custom Excel VBA program that calculates FIT rates.

Jun 2006– Jan 2008 BrightScale / Reflecivity

Created an Access database to track and report customer visits and action items to be shared by the team. Created an Excel / Access structure to allow the sales team to develop forecasts and send them in to headquarters for easy integration into the Access Database.

Developed an Access Database that used the forecast, backlog, shipping and other data to give management a “Dashboard” look at the state of the company.

1999-Jun 2006 Summit Microelectronics, Inc. (Now QUALCOMM)

Developed database systems using Microsoft Access capable of

oDownloading data from vendors

oOrder entry

oOrder processing

oRMA response

oPurchasing PR to PO

oIncoming material tracking

oReport generation (Bookings, Billings, Sales, Distributor sales, order acknowledgement, Invoices, packing sheets, and others), forecast entry and tracking

oPCNS, export of reports to Sales Reps and Sales Managers, Yield reports to engieeers, …

Education:

B. S. Physics, University of New Mexico

M. S. E. E., Arizona State University

M. B. A., University of California, Irvine, 1981

Other Skills / Education:

Access Database development, 1998, 2000, 2003, 2007, 2010, 2013, Access 365

Visual Basic for Access Database development

SQL / Python for database design

SQL, T-SQL, SSIS, SSRS course (online)

HTML/FrontPage for web page development, 1996 / 2002

Office - Word, Excel, Visual Basic, PowerPoint, Microsoft Project.

MOSFET Modeling with HSPICE Level 28, MAGIC, LEDIT for IC layout. .

ISO9000 training

Contact this candidate