Gary Wilson - Microsoft Certified Professional and Microsoft Certified Solution Developer.
When not working on computer projects Gary enjoys a lot of outdoor activities in the beautiful bluff country of southeastern Minnesota.
Gary has over 25 years of experience with micro-computers. Before working with Access, Gary developed applications with DataEase, a relational database management system used by many Fortune 1000 companies during the mid to late 80's.
From 1996 to 2001 Gary taught a variety of classes at Western Wisconsin Techinical College in La Crosse, Wisconsin including Windows 95 ®, Internet, Excel ®, Access ® and PowerPoint ®. In 1997 Gary began developing databases with Microsoft Access. Gary’s development projects have included an engineering database for Best Power, a procurement database for Organic Valley, a meter database for Dairyland Power, a jobs application called TechConnect for the Wisconsin Technical College System and a check collection application for CybrCollect.
TechConnect is a student employment application installed in twelve technical colleges in Wisconsin. This secure multi-user application includes an Access frontend for data-entry and a Web interface for students. A Visual Basic starter application is used to check for new application versions on a network server. Another Visual Basic application is used to distribute customized queries, forms and reports to individual installations of TechConnect. This allows each college to have a customized version of the application yet still add new or updated database objects without overwriting the main application database. The latest version of this project includes a central SQL Server database used to store jobs,
employer and contact information. This database has a web interface for Wisconsin employers to use when posting new jobs. It also downloads job, employer and contact information to local college databases.
From August 2001 to August 2008 Gary served as the senior Access database administrator for CybrCollect in La Crosse, WI. CybrCollect quickly grew to become one of the top companies in the United States for processing NSF checks for businesses large and small. Clients ranged from small convenience stores to national chains like Hy-Vee, Subway and Pizza Hut. The Access front end application worked with a SQL Server database to process all checks received, transmit to the automated clearing house, pay stores and clients via electronic fund transfers, email and fax reports and export forward to collections reports. The application incorporates a third party image control from Lead Tools Technology to better display images imported from AutoScan. AutoScan is software designed by VisionShape to work with a high speed scanner. The application also works with GFI Faxmaker software to automate sending hundreds of faxes per week. CDONTS is used to automate sending hundreds of emails per week. It is a very dynamic application that must respond quickly to the needs of a rapidly growing company. Late in 2007 CybCollect was sold to a private investment firm.
Since September of 2008 Gary has worked as a database analyst for Kaplan Professional developing reports with SQL Server Reporting Services. SSRS is a browser based report tool that gives users the ability to run advanced reports over the internet.
CERTIFICATIONS
Microsoft Certified Professional Jun 07, 1996
Microsoft Certified Trainer Apr 02, 1998
Microsoft Certified Solution Developer Feb 29, 2000
ACCESS DEVELOPMENT EXPERIENCE
CybrCollect Check Processing Database 2001 to 2008
WWTC Assessment and Program Outcomes Databases – 2000
TechConnect (Job Placement Database) – October 1998 to 2001
Dairyland Power – LaCrosse, WI
Equipment Inventory – October 1998 to January 1999
Organic Valley – LaFarge, WI
Livestock Purchases – January 1998
Open Lab Attendance – August 1997 to 1998
Economic Development Contracts – May 1997 to 1998
Inventory Management – July 1997
Engineering Bill of Materials – April 1997 to September 1998
SQL SERVER DEVELOPMENT EXPERIENCE
State database for Wisconsin Technical College System job postings – 2000 - 2001
Check collection database for CybrCollect 2004 - 2008
From 1996 to 2001 Gary taught a variety of classes at Western Wisconsin Techinical College in La Crosse, Wisconsin including Windows 95 ®, Internet, Excel ®, Access ® and PowerPoint ®. In 1997 Gary began developing databases with Microsoft Access. Gary’s development projects have included an engineering database for Best Power, a procurement database for Organic Valley, a meter database for Dairyland Power, a jobs application called TechConnect for the Wisconsin Technical College System and a check collection application for CybrCollect.
TechConnect is a student employment application installed in twelve technical colleges in Wisconsin. This secure multi-user application includes an Access frontend for data-entry and a Web interface for students. A Visual Basic starter application is used to check for new application versions on a network server. Another Visual Basic application is used to distribute customized queries, forms and reports to individual installations of TechConnect. This allows each college to have a customized version of the application yet still add new or updated database objects without overwriting the main application database. The latest version of this project includes a central SQL Server database used to store jobs,
employer and contact information. This database has a web interface for Wisconsin employers to use when posting new jobs. It also downloads job, employer and contact information to local college databases.
From August 2001 to August 2008 Gary served as the senior Access database administrator for CybrCollect in La Crosse, WI. CybrCollect quickly grew to become one of the top companies in the United States for processing NSF checks for businesses large and small. Clients ranged from small convenience stores to national chains like Hy-Vee, Subway and Pizza Hut. The Access front end application worked with a SQL Server database to process all checks received, transmit to the automated clearing house, pay stores and clients via electronic fund transfers, email and fax reports and export forward to collections reports. The application incorporates a third party image control from Lead Tools Technology to better display images imported from AutoScan. AutoScan is software designed by VisionShape to work with a high speed scanner. The application also works with GFI Faxmaker software to automate sending hundreds of faxes per week. CDONTS is used to automate sending hundreds of emails per week. It is a very dynamic application that must respond quickly to the needs of a rapidly growing company. Late in 2007 CybCollect was sold to a private investment firm.
Since September of 2008 Gary has worked as a database analyst for Kaplan Professional developing reports with SQL Server Reporting Services. SSRS is a browser based report tool that gives users the ability to run advanced reports over the internet.
CERTIFICATIONS
Microsoft Certified Professional Jun 07, 1996
Microsoft Certified Trainer Apr 02, 1998
Microsoft Certified Solution Developer Feb 29, 2000
ACCESS DEVELOPMENT EXPERIENCE
CybrCollect Check Processing Database 2001 to 2008
WWTC Assessment and Program Outcomes Databases – 2000
TechConnect (Job Placement Database) – October 1998 to 2001
Dairyland Power – LaCrosse, WI
Equipment Inventory – October 1998 to January 1999
Organic Valley – LaFarge, WI
Livestock Purchases – January 1998
Open Lab Attendance – August 1997 to 1998
Economic Development Contracts – May 1997 to 1998
Inventory Management – July 1997
Engineering Bill of Materials – April 1997 to September 1998
SQL SERVER DEVELOPMENT EXPERIENCE
State database for Wisconsin Technical College System job postings – 2000 - 2001
Check collection database for CybrCollect 2004 - 2008