Mark Edwards

Mark Edwards Email and Phone Number

Senior Access/SQL Server Developer at IT Impact, Inc. @ IT Impact, Inc.
Mark Edwards's Location
Raleigh, North Carolina, United States, United States
Mark Edwards's Contact Details

Mark Edwards personal email

n/a
About Mark Edwards

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. I also support independent Office/VBA developers. I have extensive, verifiable expert experience in: -Analyzing business and data processes and designing systems for process automation. -Fixing & rebuilding existing Access & SQL Server database applications as well as designing new ones from the ground-up. -Converting complex Excel applications to RDMS and business automation systems. -Integrating other platforms and applications with Access/SQL Server/VB applications. Please visit http://vbaofficesolutions.com for a full range of products and services. Microsoft Office and related technologies, with their rapid application development & agile programming capabilities, could - in the right hands - provide small-scale mission critical products, and technologies to businesses in the private sector much quicker and more economically than the standard costly, time-consuming development methods.Military Experience: Experienced with working in large, technical operations and dealing with high-ranking, demanding ship captains and battle group commanders. I created programs in the Basic programming language on IBM desktop computers to handle deployed units with a $2.5 million operations budget. I performed the in-house alpha-testing on the military's first desk-top program for avoiding observance by spy satellites. I worked with Sky Lab astronaut Dale Gardner to develop and train reservists for the Alternate Space Defense Operations Center, earning the Navy Achievement Medal.

Mark Edwards's Current Company Details
IT Impact, Inc.

It Impact, Inc.

View
Senior Access/SQL Server Developer at IT Impact, Inc.
Mark Edwards Work Experience Details
  • It Impact, Inc.
    Senior Access/Sql Server Developer
    It Impact, Inc. Feb 2020 - Present
    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.
    View
  • Vba Office Solutions, Llc
    Senior Access/Excel/Sql Server Consultant/Contractor
    Vba Office Solutions, Llc Dec 2007 - Jan 2020
    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 development, and I support other Office/VBA/T-SQL developers. I also have my own software development lab capable of supporting every version of MS Office and Windows operating system from WinXP and Office 2003 through Windows 10 and Office 2016. I enjoy working with Office and related technologies so much that I helped co-found the Triangle Microsoft Office Users Group (TriMOUG) so I could help others share their love for technology!
  • Ofni Systems
    Vba Developer For Fda 21 Cfr Part 11 Compliant Software (Contractor)
    Ofni Systems Aug 2017 - Dec 2017
    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 installations, etc. • 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.
    View
  • Cisco
    Business Data Analyst/Developer (Contractor)
    Cisco Jul 2015 - Jul 2017
    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 system was built with Microsoft Office 2013 and SQL Server Express 2014, and operated in a Citrix Remote App environment so that it could be operated from anywhere.• 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 system, capable of meeting all Sarbanes-Oxly data processing and retention requirements and reducing issues, errors and processing time to less than one hour vs. several days. • 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 research and reliance on outdated printed reference materials, thereby increasing the reliability of information and drastically reducing the time needed by designers to create their data files. • 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 ensure quality ETL upload to engineering database systems.• 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.
    View
  • General Electric
    Excel/Sql Server/Access Database Business Analyst (Contractor)
    General Electric Jul 2014 - Feb 2015
    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 supervision, I analyzed the company’s home-grown SQL Server/T-SQL engineering database software and mapped screen and control components to the product design data inputs to quickly and accurately create automated ETL upload files. This enabled the designers to more accurately match design data to the screens and controls on the engineering software.In addition, I designed and built two VB applications based on Microsoft Office to analyze the data in two SQL Server database enterprise systems so that new product designers could include the engineering data format in their design data extracts for the purpose of creating ETL files for ready upload into engineering database systems.Also, I developed a VB application running Excel VBA automation code to quickly and accurately import, analyze, and edit the content of dozens of Excel spreadsheets for ETL upload to engineering database systems.
    View
  • Javelinhr, Inc.
    Scheduling And Appointment Management Application Project. (Contractor)
    Javelinhr, Inc. Nov 2013 - Feb 2014
    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 data files with multiple data integrity checks and alerts for complete and accurate data import.--Designed a VBA automated scheduling process that allowed company staff to easily manage the complex process of managing trainer schedules and matching trainer qualifications with trainee needs which saved many man-hours of staff time in preparing appointment schedules.--Designed multiple data and graphical displays to enable staff to easily verify proper and complete appointment assignments of staff training personnel. --Developed multiple modules for exporting reports in Microsoft Excel and text file formats for upload into other systems. --Integrated the application with Microsoft Outlook for publishing personal training appointments to employees’ personal Outlook calendars.
  • Blue Cross And Blue Shield Of North Carolina
    Financial Data Analysis Applications Designer (Contractor)
    Blue Cross And Blue Shield Of North Carolina Sep 2012 - Oct 2013
    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 development techniques, including self-documenting VBA code modules:--Developed and implemented utility applications for use by corporate users in managing VBA application upgrades, distribution, and sanitizing complex Excel reports for publishing financial reports to corporate users and Sharepoint. --Developed an “ad-hoc” on-demand querying tool for corporate users that allowed them to create their own data retrieval and analysis queries and Excel reports whenever needed.
  • Rockett Interactive, Inc.
    Access/Sql Server Application For Internet Marketing Data Analysis And Reporting Project (Contractor
    Rockett Interactive, Inc. Mar 2011 - Jun 2012
    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 from email and reconfigure files for consumption by SQL Server.--Developed an ETL system using SSIS for importing 3rd-party Excel reports into SQL Server.--Developed a reporting system using Access 2007, Excel 2007, and SSRS for graphical template reports and data extracts to multiple media.
  • Blue Cross & Blue Shield Of North Carolina
    Financial Data Consolidation, Analysis, And Reporting Application Projects (Contractor)
    Blue Cross & Blue Shield Of North Carolina Dec 2010 - Feb 2011
    --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.
  • Kidde Safety Products, Inc. (A Division Of United Technologies Corporation
    Design And Integration Of New Corporate Pricing Structure Into Existing Applications Project
    Kidde Safety Products, Inc. (A Division Of United Technologies Corporation Jan 2010 - Nov 2010
    --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 training for company Staff. The Showcase application utilized an AS 400 DB2 Universal database.
  • Blue Cross & Blue Shield Of North Carolina
    Microsoft Access 2003/2007 Vba Project Management And Tracking Application Projects
    Blue Cross & Blue Shield Of North Carolina May 2009 - Dec 2009
    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 reporting system that allowed users to create their own reports and export them to formatted Excel workbook files.
  • Kidde Safety Products, Inc.
    Intn'L Inventory Planning And Management Application And Productivity Tool Applications Project
    Kidde Safety Products, Inc. Sep 2006 - Jan 2009
    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 forecasting and supply planning data visibility that had not been previously possible.--Created and implemented an Access 2003 VBA data transformation tool for creating upload packages to the JD Edwards/MRP system.--Asked to designed and implement an Access 2003 VBA application that handled the DPM forecasting system of another contractor because they did not have my level of expertise.--Designed and implemented a Pricing Exception Request (PER) submission and tracking tool for the Finance department. This application gave the company’s sales reps in the field ability to automatically submit, edit, track, and implement requests (a process that was previously done manually), as well as giving the finance department the ability to track, analyze, and forecast the impact of these request on the company’s bottom line – which they had not been previously able to do.--Authored a complete set of user manuals in Microsoft Word, and an easy-to-use application deployment system in Access 2003 for setting up new users of the PER application.--Installed and Configured a Terminal Services Plus remote desktop software capability so that sales personnel could access the Access application from anywhere in the country.--Designed numerous smaller Excel and Access VBA applications and tools such as a Telephone Survey application for Marketing, a Turnback Logger application for Quality Control, and many others.
  • Captrust Financial Advisors
    Commission & Payroll Applications Project
    Captrust Financial Advisors Feb 2004 - Nov 2005
    --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 Server 2003, Microsoft Access Data Projects 2003, Visual Basic .NET, and Microsoft CRM toolkit.
  • Highwoods Properties, Inc
    Database Upgrade, Advanced Reporting, And Web Applications Project
    Highwoods Properties, Inc Jul 2001 - Dec 2003
    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 database applications that allowed the conduct of business with minimal IS support staff.--Built COM and Active X components, HTML/ASP web-based data entry and reporting applications, and database access components to operate on Windows NT and Windows 2000 servers.--Used Microsoft Visual InterDev 6.0, HTML, ASP, ADO, and Visual Source Safe in a development environment to produce web-based productivity and reporting applications to support leasing agents in the field.
  • Blitz Research, Inc.
    Call Center Access Db App With Integrated Predictive Dialer And Supporting Peripherals Projects
    Blitz Research, Inc. May 1996 - May 2001
    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 included integrating the call center floor's database application with a predictive dialer system and fax server. This integration was achieved using cross-process dlls, VB components, and the Windows API.--Additional Access applications were built to process shipping orders and create client deliverables.--In late 1999, it was decided that a robust, scalable VB 6.0 application had to be developed because of the company's growth. The application was to be a 3-tier, thin-client, distributed VB 6.0 application using SQL Server 7.0 as the data store, and Seagate Crystal Reports 6 as the reporting technology. The application would run on three IBM R4500 servers with RAID 5 configurations and Citrix Metaframe Terminal Server, and all three centers would operate from the same server farm. Working with a development team, I developed COM components (ActiveX DLLs and ActiveX controls) designed to interface the predictive dialer system with the call center's VB database and minor Access database applications.
  • United States Navy
    Lieutenant
    United States Navy Jan 1980 - Jan 1991
    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 cost.--Managed the Navy’s anti-satellite surveillance data program as Fleet Support Officer at the Naval Space Surveillance Center. Received Navy Achievement Medal award.--Member of a 4-man officer team that helped build the Naval Alternate Space Defense Operations Center during the Reagan “Star Wars” program (anti-satellite missile warheads were designed at the base).--Performed the in-house “alpha” phase testing of new desktop computer Foreign Satellite Surveillance Avoidance software program.--Traveled extensively to military commands and headquarters operations in Washington D.C. briefing command personnel on Soviet and foreign spy satellite capabilities and surveillance avoidance measures.
    View

Mark Edwards Skills

Microsoft Sql Server Software Development Vba Data Analysis Database Design Visual Basic Agile Methodologies Databases Sql Access Programming Program Management Business Intelligence Testing Sharepoint Sdlc Microsoft Access Visual Basic For Applications

Mark Edwards Education Details

  • North Carolina State University
    North Carolina State University
    Aerospace & Electrical Engineering
  • Naval Electronic Warfare School
    Naval Electronic Warfare School
    Electronic Warfare
  • Navy Flight School
    Navy Flight School
    Aviation
  • Naval Aviation Officer Candidate School
    Naval Aviation Officer Candidate School
    Naval Aviation Officer

Frequently Asked Questions about Mark Edwards

What company does Mark Edwards work for?

Mark Edwards works for It Impact, Inc.

What is Mark Edwards's role at the current company?

Mark Edwards's current role is Senior Access/SQL Server Developer at IT Impact, Inc..

What is Mark Edwards's email address?

Mark Edwards's email address is ma****@****ons.com

What schools did Mark Edwards attend?

Mark Edwards attended North Carolina State University, Naval Electronic Warfare School, Navy Flight School, Naval Aviation Officer Candidate School.

What are some of Mark Edwards's interests?

Mark Edwards has interest in Technology And Software Development.

What skills is Mark Edwards known for?

Mark Edwards has skills like Microsoft Sql Server, Software Development, Vba, Data Analysis, Database Design, Visual Basic, Agile Methodologies, Databases, Sql, Access, Programming, Program Management.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.