Resume: Ed Armstrong
Microsoft Access Database / VBA / SQL Developer experienced in Financial, Operations, logistics, MRP systems, supply chain design and implementation
Active Department of Defense Secret Clearance
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
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, …
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. .