Mark Edwards Email & Phone Number

Chicago, IL, US

Specializing in the analysis, design, and implementation of business and data systems using Microsoft Access/VBA, SQL Server/T-SQL, Excel, Word, Outlook and related technologies for business and industry. I specialize in fixing existing Access/SQL: Server applications, or designing/building them from scratch, and everything in between.

VBA Office Solutions, LLC is a consulting company I founded for the purpose of providing professional-grade Microsoft Office/VBA/Access/Excel/Word/SQL Server/Office 365 application development for business and industry. I love to work with recruiters and businesses (W2, 1099, or corp-to-corp) in solving their IT needs for RAD and Agile data application.

• Hired by the company’ founder to make modifications to the company’s three 10-year old FDA 21 CFR Part 11 compliant software commercial applications to keep up with changes in technology.
• Modified three of the company’s VBA applications to so that they were both 32-bit and 64-bit compliant.
• Troubleshot and corrected systems that were causing errors due to new technology environments.
• Converted an application startup program written in Delphi to VBA and VB.NET/VSTO for validating login credentials with LDAP, NT Domain, and Access User-Level Security, as well as checking reference files, application.
• Created a data upsizing utility for use by customers to transfer data directly from Access databases into SQL Server databases, including identity field data, using SQL Server Ad Hoc query technology.
• Made modifications to the Excel VBA programming to monitor and log a user’s changes to an Excel workbook’s data for Part 11 CFR 21 compliancy requirements.

San Jose, CA, US

• Hired by the new unit director along with other developers to develop a series of professional automation tools to replace multiple, small Access databases and Excel applications built by former unit accountants. The.
• Onbook Reserves Processing System: Originally consisting of 9 Access databases and 3 Excel VBA applications, I analyzed and condensed all Onbook processing into one Access database UI and SQL Server Express database.
• Offbook Reserves Processing System: Designed and built one VB application based on Microsoft Office and SQL Server to mine and extract data for use in an Access VB application that eliminated the need for manual.
• For both applications, I developed a VB module running VBA automation code that could quickly and accurately import, troubleshoot, and edit the content of dozens of Excel spreadsheets of many various data formats to.
• For both applications, developed an Excel VBA process for calculating and displaying data in pivot tables and charts.
• For both applications, developed a VBA process for populating Excel templates with data for upload to the Oracle financial system.

Boston, MA, US

As part of a 7-man designer/developer team on a 2-3 year contract, I was tasked with analyzing the data transposition from ProE enterprise design software to the company’s custom enterprise HiRes engineering product resources and Bill-of-Material software program for a new industrial switchboard product line.Upon recognizing its value, and without.

As an independent contractor, developed and implemented an Access 2013 VBA database application for later transition to an Office 365 web app and SQL Server. The system was developed with rapid application and agile programming development techniques, including self-documenting VBA code modules:--Designed various ETL modules for importing Excel and text.

Developed and implemented several Microsoft Access and Excel VBA applications using Office 2003 and 2007 for importing and analyzing raw financial data from various sources for publication to highly formatted Excel workbooks for distribution to Sharepoint and other corporate users. The system was developed with rapid application and agile programming.

Conversion of five Microsoft Access 2003 databases into a single application with an Access 2007 front-end and a SQL Server back-end with the flexibility and capability to handle unexpected changes to 3rd party data inputs and reporting requirements. --Developed an Access 2007 VBA application integrated with Microsoft Outlook to harvest incoming data files.

--Developed and implemented an MS Access 2007 database system that could import financial web reports from the company’s intranet and perform various data integrity and analysis functions before publishing reports to highly formatted Microsoft Excel and text files.

--Project for modifying existing Pricing Exception Request (PER) Access 2003 application to incorporate new company pricing logic. --Analyzed and adapted JD Edwards and AS 400 DB2 Universal enterprise database application pricing module logic for use in company’s custom Access VBA application. --Designed, documented, and conducted Showcase SQL software.

Designed and implemented a custom Project Management and Tracking System for the corporate Enterprise Business Process Excellence department using Microsoft Access 2007 and VBA:--Designed the system to be able to support multiple users in various locations and allow users to input their progress as well as alert users to upcoming tasks.--Designed a.

An initial 6 month contract engagement with a major, international manufacturer of home safety products that was extended to 2.5 years:--Converted a very complex Excel workbook VBA application used to try and manage inventory levels into a Microsoft Access 2003 Supply and Forecasting application, complete with graphic analysis, giving a level of.

--Developed a Microsoft Access 2003 VBA application for calculating and reporting commissions and payroll with graphical reports.--Developed a custom on-demand querying Access 2003 VBA application allowing staff to create their own Access queries for data analysis ad reporting.--Supported a new, customized Microsoft CRM/SQL Server application utilizing SQL.

Contract programmer working for a REIT, responsible for quickly designing and implementing critical data analysis and reporting applications in MS Access, VB, and HTML/ASP for the J.D. Edwards real estate application running on an AS400/DB2 Universal database:--Created complex, specialized, critical components used in enterprise VB6/SQL Server 7/DB2.

Software designer/programmer supporting a medical recruitment business with two call centers:--Design and development of Access 2000 database applications for a single 65-seat medical recruitment call center in Raleigh, NC, that was just starting up and needed an application that had more capabilities than the DOS program currently in use. Development.

Washington, DC, US

Naval Flight Officer specializing in Electronic Warfare and Space Operations.--Designed, programmed and implemented a computerized system for managing 635-man aviation squadron’s worldwide deployments ($2.5 million budget), tracking aircraft and personnel deployed worldwide which dramatically improved morale and logistical support, plus reducing.

Bs, Aerospace & Electrical Engineering

Electronic Warfare Designation, Electronic Warfare

Naval Flight Officer Wings, Aviation

Ensign Commission In The Us Navy, Naval Aviation Officer