Michael Spevacek
Certified Azure Data Fundamentals
Certified Azure AI Fundamentals
Consulting Project History
The AccuTrak Group LLC -- 03/1998 – Present
Product Developer
Developer of web-based and desktop commercial products to automate claims processing for sponsors of the USDA’s Child and Adult Care Food Program.
• Designed and developed On-Line Child Care Provider Claiming System, an ASP.Net system that allows customers to enter their claims on the web so they can be downloaded into the AccuTrak Integrity System for processing. The web interface uses JavaScript to make the system more responsive and easy to use.
• Designed and implemented SQL Server 2016 backend database on the web including stored procedures and functions.
• Developed Sponsor web administration system, an ASP.Net system that allows sponsors to monitor provider claiming activity and process claims on line
• Developed API interfaces for voice command system (LogATot.com) and documents (Laserfiche).
• Developed OMR Scanner interface, a VB6 interface to read input from an Optical Mark Recognition scanner and store the data in an Access database
Environment: Azure, ASP.Net 3.5, AJAX, Visual Basic .Net, SQL Server 2016+, Stored Procedures, Reporting Services, JavaScript, Microsoft Access, Visual Studio, CSS, HTML Charter Communications -- 3/2021 to 1/2022
• Manipulate extracted data for unique requirements Environment: Microsoft Access and Excel
DXC – 1/2019 to 9/2019
• Software Engineer for State of Wisconsin Medicaid enhancements Environment: OOP, C#, Oracle 11g, Visual Studio
Department of Workforce Development – 3/2017 – 6/2017
• Made enhancements to Youth Apprenticeship application per user requests
• The project was run using Agile methodology and used Team Foundation Server to manage the tasks Environment: VB, TFS, Oracle 11g
American Family Insurance – 3/2016 – 3/2017
• Migrated AdminRights security application from Windows 2003 server
• Migrated CAAM security application from Windows 2003 server Environment: C#, TFS, Oracle 11g
UltraTec – 12/2015 -- 2/2016
• Developed SSRS reports for Notifications Monitoring system including hourly/daily graphing
• Made ASP program modifications for data maintenance Environment: SSRS for SQL 2008, VS2013
CleaResult 8/2015 – 11/2015
• Modified XML specifications file to adapt to regulatory changes
• C# program modifications for Windows application Environment: C#, MVC, SQL 2008, VS2013
ABS Global 5/2015 – 7/2015
.Net systems maintenance
• Used MVC for maintenance and repair of Bovine applications Environment: C#, MVC, SQL 2008, VS2013, SVN
Ziegelbauer 4/2015 – 5/2015
Application conversion
• Converted VB6 app to .Net
Environment: VB, Access 2013, VS2013
Ariens Specialty Brands -- 8/2014 – 11/2014
Ecommerce website support
• Maintenance and repair of Gemplers.com, BenMeadows.com and AWDirect.com Environment: VB.Net, SQL 2008, VS2013, TFS
Stoughton Trailers -- 5/2014 – 8/2014
SyteLine 9 conversion consulting
• Modified SyteLine Reports (SSRS)
• Modified SyteLine stored procedures
• Modified SyteLine forms
• Data loads into SyteLine from user spreadsheets
• Developed application to transfer csv files into SyteLine
• Developed application to transfer PLC data into Access database Environment: SQL 2008, VS2013, Subversion
Care Wisconsin 12/2013 – 5/2014
.Net developer
• Developed SSRS Reports
• Operated SSIS packages
• Developed ad hoc data transformations
Environment: VB, VS200, Subversion
Dean Health Plan 09/2013- 11/2013
.Net Developer
• Provided enhancements to letter generation and table maintenance systems
• Member Match application development
Environment: C#, VS2010, Subversion, Oracle
WPS, Madison, WI 02/2013 – 08/2013
.Net Developer
• Developed VB.Net program to import DB2 and spreadsheet data into SQL and Excel spreadsheets
• Developed SSIS data warehousing packages to extract data nightly for web-based Find a Doctor application Environment: VB.Net, VS 2008, WinSQL
CUNA, Madison, WI 02/2012– 01/2013
.NET Developer/System Administrator
• Portal admin team for Oracle WebCenter Interaction (v10.3)
• Maintenance of .Net programs
Environment: VB.NET, VS 2010, Team Foundation Server Cardiac Science, Madison, WI 10/2008 – 02/2012
.NET Developer
• Convert classic ASP website to ASP.NET
• Make modifications to applications to ERP system (Syteline 8)
• Validate computer systems for SQL archiving process Environment: VB.NET, C#, SQL stored procedures, VSS, Crystal Reports, VS2005 Independent Consultant 07/2008 – 09/2008
Application Developer for short-term projects
• Used Reporting Services on short-term project to produce custom reports for Ultratech
• Converted infrastructure security spreadsheets to multi-user Access database for Alliant Energy
• Recovered Wisconsin Historical Society’s Web e-commerce database from infusion attack Access Wisconsin 10/2007 – 06/2008
• Converted billing and engineering spreadsheets to multi-user SQL database with MS Access front end Cleary Building Corporation 06/2007 – 09/2007
• Member of development team to upgrade entire corporate intranet with 75 branches from Visual Studio 2003 and ASP 1.1 to VS2005 ASP.NET 2.0
Environment: Visual Studio 2005, SQL Server 2005, ASP.Net 2.0, Visual Source Safe, Infragistics, DynamicPDF Uniek 05/2007 – 06/2007
• Close out database allows sales staff to export selected items to Excel
• Enhancements to fill rate tracking system enhancements; project request system generated emails to track progress
Environment: Access, Excel, SQL
New York Department of Health and Education 01/2007 – 04/2007
• Enhancements to Local Homes system
Environment: Visual Basic, Microsoft Access, SQL Server Kaboose.com 11/2006 – 01/2007
• Shopping, security and user-experience enhancements to world’s most active scrapbooking website Environment: ASP, SQL Server, JavaScript, Django
Network Engineering Technologies 10/2006
• Web screens for customer interface
Environment: Exposure to C#
Ultratec 08/2006 – 09/2006
• Modifications to Defect Tracking system, Six Sigma reporting, inventory packaging Environment: Microsoft Access, barcode scanner
Placon 06/2006 – 07/2006
• Modifications to online shopping cart
Environment: ASP and exposure to eCommerce
U.S. Cellular 02/2006 – 06/2006
• Store Planner Intranet application facilitates marketing materials coordination between corporate headquarters and USC’s 2,000 stores nationwide
Environment: ASP.Net, SQL Server, Visio
RateWatch.com 12/2005 – 02/2006
• Maintenance of VB6 n-tier Web site rate scraping system
• Intranet security system
Environment: Dreamweaver, Crystal Reports, Infragistics and FarPoint components, Visual Source Safe, SQL Server with Linked database to AS400
Members database for Petroleum Marketers Association of Wisconsin
• Maintained membership data and query database
Environment: Microsoft Access
Structured Decision Making Child Welfare System for Children’s Research Center
• Adapted Visual Basic interface to Oracle 8i database for collection of child welfare data Salary Encumbrances System for Madison Area Technical College
• Wrote Visual Basic interface to PeopleSoft Payroll System used to track salary encumbrances Environment: VB6, SQL Server
Y2K Conversion Software Development for Metastar, Inc.
• Converted various AS400 Medicaid systems to Microsoft Access applications Education
• Bachelor of Science Degree, Major Economics - University of Wisconsin Madison
• Eighteen credits in computer-related courses, including Assembly Language and Analysis and Design of Computer Based Systems - University of Wisconsin Madison
Communication Skills
• Community Theatre productions
• Head coach of Madison Memorial High School Debate Team Responsibilities included budgeting, organization, student training and motivation, supervision of one assistant and sixteen students. Overall coaching record for three years is 187 wins and 126 losses, qualifying for the State Tournament all three years
• 250 persuasive speeches in intercollegiate competition as member of the UW-Madison debate team
• Served as a Graduate Assistant for the Dale Carnegie Course in Speaking and Human Relations Career interests
• Artificial intelligence
• Data Science
• Internet of Things