Paul Kohn

407 W Oak Street-- Paul Kohn Key Takeaways • Expert Database Administrator/ Programmer • Data Analytics • Leadership and Experience Technical Skills • Extract, Transfer, Load (ETL) • SQL Server (all versions) • MSAccess (all versions) • SSIS, SSMS, Visual Studio • SSAS, SSRS, PostgreSQL • T-SQL, SQL, SPSS, SAS • Macros Visio, Video Editing, Crystal Reports • VB Scripting • Unix Scripting • .NET • Citrix • RDP, VPN Paul is an accomplished DBA, Developer, Analyst and Management Information specialist with over 20 years of experience. His specialty is in creating automated systems along with developing small to enterprise level multi-user, client-server type applications using software tools such as SQL Server, Microsoft Office, Visual Studio, VB, Visio, VB Scripting and a variety of other tools. Experience Expert Database Programming (EDP)_____________________________2000 to Present Title: Owner/Developer (Part-Time) Silver Stone Construction (2002 to Present) Developed an MSAccess/SQL Server application to track construction base costs, change orders, draws, options, allowances and print/email contracts. West Star Organics (2002 to Present) Developed an MSAccess application to track growth cycles for organic vegetables. Floorworks (2005 to Present) Developed a multi-company MSAccess application to track flooring materials and projects. McDorman Law Offices (2005) Developed an MSAccess application to import/track/process state collections data The Douglas Stewart Company (2004) Developed an MSAccess application to track marketing projects. Energy Finance Solutions (2003) Developed an MSAccess/SQL Server application to track/approve/deny/export loans. Renewables Energy (2002) Developed an MSAccess/SQL Server application to track Renewable energy projects. Minnesota HVAC (2002) Developed an MSAccess/SQL Server application to track HVAC projects. Foundation for Anesthesia Research (2002) Developed an MSAccess application to record medical research data on anesthesia. Public Health, State of WI (2000) Developed an MSAccess application to merge with existing systems on Public Health. Targeted Home Performance (2000) Developed an MSAccess/SQL Server application for tracking low income housing. Wisconsin Marketing (2000) Developed an MSAccess/SQL Server application to distribute Energy Star marketing materials Energy Star Rebates (2000) Developed a rebate tracking process and an MSAccess/SQL Server application to print and reconcile 1000 checks weekly. University of Wisconsin Dept. of Medicine, Madison, WI Center for Tobacco Research and Intervention Title: Senior DBA (Full-Time) • • • • • • • • • • • • • • • • • • • • 2008 to 2018 10+ million records, 100+ relational tables, load balancing, index optimization, replication, ETL, multiple research studies Revamped and streamlined the development process for creating new medical research applications Eliminated data inconsistencies and down-time increasing the departments IRB standing from 25th to 1st Developed a re-usable SQL Server back-end structure and MS Access front-end application with adjustable research features Converted patient scheduling and payment system from MS Access to .NET Developed IVR, smart phone and auto-emailing applications to auto-call and auto- email patients for data collection Setup new patient randomization protocols and created a simplified HIPAA compliant security system for SQL Server data Trained UW students on application development Assisted other UW departments on hiring new IT candidates Trained other UW departments on IVR development Collaborated with medical researchers, doctors and staff to develop a variety of HIPAA compliant research applications in SQL Server, Visual Basic, .NET, MS Excel, SPSS and MS Access to support patient research on addiction Integrated SQL Server and MS Word to automate letters to patients and write checks Integrated SQL Server and MS Excel to produce graphs showing patient progress and statistics Integrated SQL Server with SPSS and MS Access for researchers to easily query and analyze data Created PowerPoint slides for training Set up protocols to auto-email doctors on adverse reactions patients have to medications Wrote ETL processes to import/clean/merge tobacco, electronic health records and other medical research data in multiple formats Analyzed point-in-time data Installed and setup SQL Servers, backups, security, SSIS, load balancing, performance analysis and active directory Designed API, PHP, Java and VB scripts to automate web tasks and merge data Environment: MS Windows (3.1, 95, 98, NT, 2000, XP, Vista, 7, 8, 10), Unix, Citrix, VPN, Direct Connect, SQL Server (2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017), Visual Basic (7.0), .NET,MS Access (2.0, 7.0, 2000,-, 365), MS Office (2000, 365), Visio (2003, 2007, 2010, 2013, 2016), MS Excel (95, 97, 2000, 2002, 2003, 2007, 2010, 2013), Adobe, SPSS, SAS, PowerPoint (2010, 2013, 365) Department of Veteran Affairs, Madison, WI Title: Expert Database Programming (EDP) (Part-Time) • • • 2008 to 2018 100,000+ records, 10+ relational tables, multiple studies Designed interactive voice applications (IVR) to call veterans at designated times throughout the day to collect and integrate live data. Developed multiple applications in MS Access for the VA department to analyze and diagnose veterans with PTSD Environment: MS Access (2.0, 2000, 365) City of Madison, Madison, WI Title: Management Information Specialist (Full-Time) • • • • • • 2007 to 2008 1+ million records, 100+ relational tables, hundreds of databases, ETL Finalized a 10-year project to merge county and city databases together Evaluated, monitored and reported on development processes by outside IT consultants Developed a variety of applications in SQL Server (back-end) and MS Access (front-end) for different city agencies Created USB code to automatically update fire and police laptops Troubleshot Crystal Reports and Document Management software issues Environment: MS Windows (3.1, 95, 98, 2000, XP), Unix, Linux, Citrix, Terminal Server, SQL Server (7.0, 2000, 2005), MS Access (2.0, 7.0, 2000, 2007), Visual Basic (6.0, 7.0), MS Office (2000, 2007) Visio (2003, 2007), Crystal Reports, Document Management System WI Energy Conservation Corporation (WECC) Title: Applications Manager (Full-Time) • • • • • • • • • • 1998 to 2006 50+ million records, 100+ relational tables, clustered indexes, triggers, stored procedures, views, ADP, ETL Database structure and application design were critical to support 100+ external users connecting with 300 to 2400 baud modems to query datasets of 20+ million records with less than a .003% discrepancy As the primary contact for all Energy Star application development in the Midwest, I routinely evaluated other agencies developing Energy Star applications for data accuracy and financial security Hired, trained, mentored and managed a team of five developers for 10 years Developed a variety of administrative, financial and business applications in SQL Server, Visual Basic and MS Access to support the Midwest Energy Star and associated programs Integrated SQL Server with MS Word and Word Perfect to automate letter writing to customers Setup a geocoding process for new data and integrated SQL Server with MS Excel and ArcMap to produce graphs and maps for each WI legislative district showing Energy Star savings throughout Wisconsin Designed ETL processes using SQL Server and MS Access to import/clean/merge Energy Star data in multiple formats from retail stores throughout the Midwest Worked with retailers on data specifications Wrote stored procedures and triggers on SQL Server • • Developed an automated check-writing and reconciling process to print 1000 Energy Star rebate checks weekly Designed SQL Server views for website returns and SSRS for reports Environment: MS Windows (3.1, 95, 98, NT, 2000, XP, Vista), SQL Server (6.5, 7.0, 2000), SQL Server Active Data Projects (ADP 7.0), Visual Basic (6.0, 7.0) MS Access (2.0, 7.0, 2000), MS Word (98), WordPerfect (6.0), Visio (2000), MS Excel (95, 97, 2000), Adobe, Linux, Unix, Terminal Server, Citrix, 50 external users connecting via- baud modems Energy Finance Solutions (part of WECC) Title: Expert Database Programming (EDP) (Part-Time) • • • • 1998 to 2006 1+ million records, 100+ relational tables, stored procedures, triggers, views, ETL The Banker’s Loan Document System was a new online service in 2000 that exported verified loan documents for every state/purpose. Downloading these documents was integrated with the loan application which eliminated thousands of dollars spent each month on lawyer fees to review every loan document before submitting the loan to Fannie Mae Developed a loan application which integrated SQL Server with the online Banker’s Loan Document System and supported data exporting to Fannie Mae for energy finance loans Developed a front-end GUI in MS Access to track and populate loan document data Environment: SQL Server (7.), Visual Basic (6.0), MS Access (2.0), MS Word (98), MS Excel (97), Citrix Additional Experience Data Analyst, GBC-Protech (1996 to 1998) Air Cargo Instructor/Evaluator, US Air Force (1984 to 1994) Legislative Technology Service Bureau (1992) U.S. Air Force Reserves (1990) Education Bachelor of Science, Computer Science University of Wisconsin-Madison, Madison, WI, graduated 1991