Maria Barnes
4857 Island View Drive
Mound, MN  55364
mbarnes@BarnesBusinessSolutions.com
Phone: (630) 715-4452


EDUCATION:

University of Illinois-1986
Bachelor of Science degree, major in Mathematics & Computer Science, minor in Business.  Graduated magna cum laude with high distinction in computer science.


CERTIFICATIONS:

Microsoft Certified Professional

Microsoft Certified Technology Specialist - SQL Server 2008, Database Development

Microsoft Office Specialist – Microsoft Office Access 2007, Microsoft Office Excel 2007


ORGANIZATIONS:

Microsoft Partner


EMPLOYMENT:

President, Barnes Business Solutions, Inc. (2008-present)

President, Barnes Consulting, DBA (1999-2007)

Computer Programmer/Analyst, A+ Computer Specialists, Inc. (1992-1999)

Systems Engineer, Imagination Systems, Inc. (1989-1992)

Programmer/Marketing Assistant, SHA Computers, Inc. (19871988)

Computer Programmer/Analyst, U.S. Army Corps of Engineers (1985-1986)


EXPERIENCE:

Mobile applications (June 2015-present)

  • Developed Mobile application for iOS and Android for U.S. Water

 

SQL Server (June 2003-present)

  • Developed SQL Server 2008 stored procedures for extending an Access 2010 ACCDB and providing new client required interface for Equian.
  • Linked to SQL Server 2005 MAS tables for integration with an Access 2010 database for United Gasket.
  • Linked toSQL Server 2008 Microsoft Dynamics NAV tables for integration with an Access 2010 database for US Water Services.
  • Developed SQL Server 2008 stored procedures for extending an Access 2003 ADP and providing new client required interface for AfterMath Claims Science.
  • Developed SQL Server 2008 stored procedures for high volume searching at AfterMath Claims Science.
  • Converted Access 2000 replication database to SQL Server 2008 Express for Nalco Company.
  • Developed installation routines to setup SQL Server 2005 Express and software specific database on client machines for Hyde Park Systems Group.
  • Customized SQL Server 2005 functions and stored procedures for Hyde Park Systems Group.
  • Modified existing POS interfaces (including SQL Server 2000 functions, stored procedures & jobs ) to utilize multiple price types & linked prices. 

 

Microsoft Access (April 2003–present)

  • Developed an App for SharePoint to keep track of TL or LTL trucking shipments by Driver and Truck called "Freight Dispatch".
  • Merged two existing Access 2010 databases into one cohesive front end, updating functionality for Land Surveying Services.
  • Migrated an Access 2013 ACCDB backend to a web database for Aligned Operations.
  • Provided maintenance and enhancement development to an Access 2010 ACCDE for approximately 50 users at Equian.
  • Modified an existing Access 2007 database for student information for Douglas J Companies.
  • Developed an Access 2010 database for trucking order and load management for Shotgun Express.
  • Extended an Access 2007 database for new optional manufacturing process and provided support for new Access 2010 users for Hansen Plastics.
  • Developed Access 2007 database for commision sourcing, interfacing with Microsoft Dynamics SQL tables for US Water Services, Inc.
  • Ported Access 2003 ADP database to Access 2010 ACCDB for medical claim overpayment processing for AfterMath Claim Science.
  • Developed Access 2007 database for potential sales tracking for Accel Entertainment.
  • Developed Access 2003 database with upgrade capabilities for Access 2007 for production tool tracking for Hansen Plastics.
  • Customized Access 2003 front end MDBs and ADPs to respond quickly to user needs in production environments at AfterMath Claim Science.
  • Developed Access 2007 front end to customize an IMAGIC Inventory Access backend for trip inventory check in/out for The HistoryMakers.   
  • Customized Access 2007 database for contacts for The HistoryMakers.   
  • Combined 4 older Access databases into one integrated Access 2007 database with functional improvements for scheduling security at client events.
  • Designed an Access 2003 database for inventory tank and product control for Nalco Company.  Developed interface for detailed Excel status report.
  • Developed Access 2007 reports connected to a MySQL backend via ODBC Connection for project status reporting for The McIntosh Group.   
  • Developed several Access 2007 import routines and custom reports for Red-Works.
  • Converted an Access 2003 database to Access 2007 and expanded capabilities of current system for Allcraft Mold.
  • Developed an import routine for manufacturing job specifications for Allcraft Mold.
  • Developed an import utility in Access 2000 interfacing with Excel 2000 which provided custom data deduping based on match probabilities over multiple fields.
  • Designed and developed a Survey tracking tool in MS Access.  Interfaced tool with company databases through the use of Excel data importing.  Provided a customizable report with charts and graphs which can be printed to PDF and emailed to management for Nalco Company.   
  • Provided consulting and customization of an existing Access 2002 database including interfacing with Outlook and Word 2002 for Beasley & Company. 
  • Enhanced an existing Access database by adding an import routine for Outlook 2003 sales lead emails for A to Z Movers.
  • Interfaced existing project management Access database with MS Outlook using VBA and DAO to synchronize address books and send status messages based on employee input.  Resulted in decreased data entry efforts, increased quality and billing accuracy for Isystant, Inc.

 

Microsoft Excel (April 2005–present)

  • Developed an Excel 2013 tool and template for Sales Performance analysis for Nalco Water, an Ecolab Company.
  • Customized an Excel 2013 tool for Manufacture Forecasting for Hansen Plastics.
  • Developed an Excel 2010 tool for Imaging Sales for IMAGETEC.
  • Developed an Excel 2007 tool for formatting of horse racing data for Eclosers.
  • Customized an Excel 2010 tool for Service Order Requests to integrate a Project Completion form for Nalco, an Ecolab company.
  • Customized an Excel 2003 tool to provide multi-company functionality for Nalco Crossbow.  Later upgraded the tool to Excel 2010.
  • Extended an Excel 2007 spreadsheet to work with VeriMove Pitney Bowes address verification software to print detailed custom financial flyers with presort savings for United Mortgage Services.
  • Developed Excel 2007 tools to provide monthly inputs for new/lost account reporting and conversion planning for Nalco Company.
  • Customized an Excel 2007 tool which interfaced with PowerPoint for sales presentations for Nalco Company.
  • Developed Excel 2003 tools to replace two existing Basic 3.0 tools for AMWELL.
  • Developed Excel 2000 tools for alarming data analysis including interface with web server output and customizing Excel Charts for Nalco Company.
  • Designed and developed an Excel tool interfacing with an Access database providing graphical representation of Attrition analysis for Nalco Company. 

 

Microsoft Word (July 2005-present)

  • Customized macro on Word 2007 form to pull in more photos and rearrange better to fit for The McIntosh Group.  
  • Added a macro for Spell Checking protected fields on Word 2007 forms for The McIntosh Group.  
  • Developed template for emailing conference attendance response request for American Heartworm Society.  
  • Customized Word 2003 templates to bring in appropriate signature files and alter wording based on WAN Access database interfaces.

 

BizTalk (Feburary 2016-present)

  • Developed BizTalk 2010 Orchestrations, Ports, Maps, and Schemas for 2 new transactions for Equian
  • Modified existing BizTalk 2010 Schemas and Maps for changed transactions for Equian

 

SharePoint Workflows (August 2010–present)

  • Developed SharePoint 2007 workflow for new employee paperwork tracking for CMIT Solutions using SharePoint Designer 2007.

 

C# .NET (March 2005-present)

  • Developed front end software for management task processing and compliance verification in C# .NET 2008 for AfterMath Claim Science.
  • Modified existing C# 2008 .NET forms to use standardized table structure for AfterMath Claim Science.
  • Developed a lookup table editing interface, and Excel based reporting using C# 2008 .NET for AfterMath Claim Science.
  • Customized a Word interface using C# including modifying the Word toolbar (2000-2003) and Ribbon (2007) for Hyde Park Systems Group. 
  • Developed reports for a wholesale order system using C# .NET, Infragistics controls, and SQL Server.  Interfaced with Great Plains data to provide a simplified on-demand customer statement for Hyde Park Systems Group.

 

Visual Basic .NET (April 2005–present)

  • Developed a prototype system for new business modeling in Visual Basic .NET 2008 for AfterMath Claim Science.
  • Designed and developed a for retail sales Visual Basic .NET 2005 application for research writing. Used Windows Installer and backend SQL Express database.  
  • Developed reporting for accounting system using an Access 2003 interface with .NET and SQL Server 2005 for Young, Young, and Young.
  • Coded VB .NET 2005 forms from spec using template interfaces, ADO .NET, and SQL 2005 stored procedures for Young, Young, and Young.  
  • Developed printing and Excel export interface for form template including Infragistics Grid controls for Young, Young, and Young.
  • Developed a VB .NET front end to secure an Access database sold with source code access.   This tool limited the number of users allowed to access the back end database and connected seamlessly to the back end on new installs.

 

ASP.NET (August 2009–present)

  • Developed a website Contact form for sending email contact requests.
  • Repaired an ASP .NET website which had been moved to reestablish correct connection strings for DC Appwerx.
  • Developed an ASP .NET interface to a SMS Text Messaging mechanism for corresponding between Market Research management/analysts and technicians.

 

ASP (June 2003– August 2009)

  • Repaired an ASP .NET website which had been moved to reestablish correct connection strings for DC Appwerx.
  • Developed an ASP .NET interface to a SMS Text Messaging mechanism for corresponding between Market Research management/analysts and technicians.
  • Developed a MS Access database-driven registration process using ASP and HTML.  Interfaced with PayPal purchasing system, providing Licensing capability for software product purchase for Hyde Park Systems Group.
  • Developed a registration routine that allowed securing a distributable Access database by providing main contact information editing only through a Web Browser.   Wrote ASP code to interface with a back end Access database for registration validation for Fix My Database.
  • Developed a MS Access database-driven web site for new home construction using ASP, VBScript, Jscript , HTML, CSS, DHTML, and XHTML.  Provided 3 levels of security as well as tracking of users to aid in potential customer follow-up for Fix My Database. 
  • Developed an ASP routine for generic parent-child data entry with transaction level record updating to be used for any set of SQL Server data tables.  Resulted in increased functionality, increased consistency, & decreased programming time for future development for Isystant, Inc.
  • Designed and implemented a database-driven report writer using SQL Server and ASP, VBScript, Jscript, and HTML for Isystant, Inc. 

 

Integration (August 1999-present)

  • Developed an interface between Access & Quickbooks for Shotgun Express.
  • Developed an interface between Access & MAS 90 for United Gasket.
  • Developed an interface between Access & Microsoft Dynamics NAV for US Water Services, Inc.
  • Developed an interface between Access & Quickbooks for The HistoryMakers.
  • Developed HDF and VB scripts and designed the interface between TCI Retail Mgmt and Designer Label 32 software systems for Hyde Park Systems Group.
  • Wrote HDF script for customized interface between TCI Retail Management and EPlum scale management software systems for Hyde Park Systems Group.