Access VBA Sql Server Accounting

Michael Goyette

**** ****** **.

Lapeer, MI *****

Phone 810-***-****

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

EXPERIENCE SUMMARY

I am an experienced application developer and use my business, accounting and manufacturing process background to identify areas to increase efficiency and profitability. I am a well rounded technologist with skills in programming, database management, application training and networking. Most importantly I am a good listener and will help to translate your concepts into workable programs.

SKILLS SUMMARY

Programming: VS2017- C# programming – Razor Pages – MVC – EF – Current – using daily.

SQL Server – 3 years experience – SSMS – SSIS- ETL – SSAS - SSRS – Transact SQL

MS-Access/VBA Programmer – 20 plus years in database design and front end-detached application deployment

VB/VB.Net/ASP/ASP.Net Programmer – 18 years plus experience in 3 tier website design and processing.

VB/VB.Net/Winforms – For graphics production programming (See DBMS/DPOS below)

HTML5/CSS3 Programming – 12 years plus experience in designing multi-platform websites

Javascript Programming – 3 years plus experience in using Javascript to automate client side websites and

Adobe Javascript to script automation of ebook platform in Adobe Edge Animate

Microsoft Office - 2 Years Experience In Outlook and Word automation.

Larger Scale Systems (See DBMS/DPOS below – Hundreds of Thousands (500,000 – 800,000) of Lines of Code – complete module interaction with online purchasing – local data processing – all based on quick response (less than 3 second response times) Am currently upscaling all of my systems into SQL Server, C# using EF and Razor.

Databases: SQL Server – Versions-2005-2012-2016-2017

MS-Access – 1992-Present – All Versions

MS-Foxpro – 3 Years Experience

Dbase – 2 Years Experience

Platforms/OS: Microsoft Windows – 1984-Present – All Versions

Windows Server – 1997-Present – All Versions (Over 40 Installations)

Apple OSX – 2000-Present – Networking To Windows Networks

Netware – 1986-1989

Software: Microsoft Visual Studio – Versions -1997-2002-2005-2008-2012-2015-2017

Microsoft Office Professional – 1989-Present – All Versions

Adobe Creative Cloud – 2012-Present – Photoshop, Premiere, Edge Animate

Cakewalk Sonar – 1990 – Present – All Versions

Migration 1990 -1995 – Converted Accounting System From Dbase to Foxpro to Access

Highlights 1995-1997 – Converted Online Print Order System from Java to Asp

1995-2015 – Converted Accounting System From Access 1.0 to Access 2016

2007 – Converted Online Print Order System from Asp to Asp.net/Vb.net

2013 – Converted 50 SISS Projects from Sql Server 2005 to Sql Server 2008 - VSB

2015 – Converted Online Print Order System From Asp.net to HTMLs5/CSS3/Vb.net – 3 tier application

2017 – Converting Accounting System from MS-Access VBA to C# Razor-Pages with EF – Sql Server 2016

PROFESSIONAL EXPERIENCE

Papa God Corporation 2017-present

Position: President and Chief Programmer

• Currently working on project converting large MS-Access accounting system to C# on Razor pages – EF – SQL Server 2016. Have successfully worked in the past 2 years on Visual Studio projects involving HTML5, CSS3 and Javascript cross platform – Android-Ios.

Symbi Corporation 1994-2016

Position: President and Chief Programmer

• Worked on ACS (Artists Creative Studio) online studio control system and creative project

management system – prototype done in MSAccess 2013/2016. Now making web version as .Net

Website using SQL Server 2012-2016 or Access backend, and .Net 4.5/5.0 front end using mixed Vb.net and C#.Net,

using Visual Studio 2015. System will allow unique artist project tracking for music and video projects,

as well as accounting for income tracking from various sources (Itunes, Google play, Amazon, ASCAP, etc.)

with automated distribution of revenues to participants individual bank accounts. The goal of this project

is to take all previous work done in accounting (DBMS) – creative asset management-music-videos(DVAS)

and fuse it with this new type of accounting for creative projects. It will be available online on all kinds of

devices and will allow artists to create cooperatively in a new way, with assurance that they are being treated

fairly in their remuneration.

• Created DPOS System for automating online print ordering and processing.

DPOS is a .Net based print ordering system, with complete back end support for uploading files to be printed,

ordering business enhancement products online and create printed products online using templates.

DPOS is in the third iteration going from Java based(1995) to VB/ASP.net based in 1999 to current

.Net Framework 4.5, VB.Net/Aspx(2012-2016) based on responsive HTML5/CSS3 web design using Visual Studio 2012.

One of the first in the nation (1995-1997) online print ordering systems. End users have included US Airforce Recruiting

and Countrywide Home Loans.

DPOS includes .Net based online payment linkages to First Data global payment systems. DPOS is a pure Microsoft.Net

system with no third party libraries or controls including the real-time imaging routines.

• Expanded DBMS system to complete Accounting System (GL/AR/AP/IC/PHR/SM, etc.) using MS Access/VB/VB.Net starting in 1994 with version 1.1. System has been in continuous use from 1994-2017. Use Winforms for screens that require more complex graphic types (TIFF(RGb, CMYK,Bitmap) for production use for printing/imaging systems.

• Created DVAS (Digital Video Advertising System) for organization and display of multimedia assets and advertising.

• Created CCMS (Construction Company Management System) for quoting and tracking needs of small construction

companies.

• Created DPMS (Digital Photo Management System) for event/convention contact tracking. Loads photographs

and contact details for event attendees which can then be distributed in book form.

• Did work for Schwaab, Inc. (2013-2015) converting all of their SSIS projects to SQL Server 2008 from SQL Server 2005.

Wrote Transact SQL script for daily HTML shipping notifications, integrating ship tracking numbers.

AWT Burbank 1989-1993

Position: Typesetter and Programmer

• Created DBMS system for wholesale printing Order Entry and Accounts Receivable tracking system using Dbase.

• Created automation links to QuarkXpress(desktop publishing) in C language to automate grouping and plating of print

orders. Transitioned team from traditional typesetting to first PC-Based desktop publishing.

• Established in-plant tracking of orders from Data Entry to Delivery.

• Put in Netware networking system for 30 plus PC Servers and Workstations.

Symbi Company 1984-1988

Position: President and Chief Programmer

• Developed programs in MS Basic for:

Libralter Plastics

Just In Time Inventory System for medium sized ($24 Million Year) plastic injection molding company producing automotive parts.

Terry Barr Sales

Complete sales call tracking and reporting system for medium sized manufacturer’s representatives for sales to the automotive industry. Established 1st generation IBM pc networking system for secretarial word processing and file sharing

EDUCATION

Walsh College

Graduated 1987

BA General Business

Oakland Community College

Graduated 1983

AS Accounting

AS Data Processing

Contact this candidate