Guy Duerr Email & Phone Number

Duluth, GA, US

• Contractor to CDC - Opioid Division
• Used MS Access to analyze data for the Division of Overdose Prevention of the CDC.
• Developed complex management reports using MS Access for Division of Overdose Prevention of the CDC.
• Developed and implemented a project plan for various databases for Division of Overdose Prevention of the CDC.
• Created complex on-demand reports using MS Access and Excel for Division of Overdose Prevention of the CDC.
• Used SAS programs to analyze data from the states for Division of Overdose Prevention of the CDC.

Tulsa, OK, US

• Contractor to CDC - Influenza Division
• Used T-SQL, SQL Server and MS Access to analyze data for the Flu Division of the CDC.
• Created and modified spreadsheets for FluLab related data using ADO.Net, Excel, and.Net Framework.
• Developed complex management and statistical reports using Tableau and C#.Net.
• Created dashboard programs using T-SQL and SQL statements.
• Created complex on-demand reports that used SSIS. Converted these reports to permanent reproducible reports using stored procedures.

Norman, OK, US

• Contractor to CDC - Influenza Division
• Used T-SQL, SQL Server and MS Access to analyze data for the Flu Division of the CDC.
• Created and modified spreadsheets for FluLab related data using ADO.Net, Excel, and.Net Framework.
• Developed complex management and statistical reports using Tableau and C#.Net.
• Created dashboard programs using T-SQL and SQL statements.
• Created complex on-demand reports that used SSIS. Converted these reports to permanent reproducible reports using stored procedures.

• Contractor to CDC - Influenza Division
• Analyzes data, develops and runs management and statistical reports, creates and modifies spreadsheets with FluLab related data / information, and supports FluLab information and data systems.
• Uses a variety of tools and media to prepare reports, briefings, issue papers and other communications that inform stakeholders about VSDB activities, findings and initiatives
• Assists with development of materials for reports to external entities, including the World Health Organization (WHO) annual report.
• Designed, developed and implemented databases for tracking, calculating and reporting the FLU virus.
• Project management and facilitation of meetings between FluLabs development team and VSDB.

Reston, Virginia, US

• Contractor to CDC
• Develops various StarLims programs using SSL (StarLims Scripting Language), SQL, JSscript.NET and ADO.NET to develop a new DLS Laboratory Information System (LIMS). These programs include: Forms, Grids, Exports.
• Developed and maintained databases for DLS CCB labs.
• Developed and implemented a reporting tool for a CDC program in C#.Net. It allows end users to track laboratory results to ensure CDC standards were being met.
• Created a scheduling tool in C#.Net that prioritizes laboratory runs.
• Created software in C#.Net that automatically creates a backup to the network and an external drive system for the CCB labs.

Nashville, TN, US

• Created a program using C#.Net and ADO.Net to read real time information from a traffic controller. It then allowed the end user to make changes to settings as needed and download back to controller.
• Built a portal program using C#.Net and ADO.Net to increase efficiency of the user interfaces by immediately responding with a data set to the various user interfaces.
• Created a program using C#.Net and ADO.Net to read data from a database and created user friendly Crystal Reports.
• Modified existing developed software to use 2008 C#.Net and ADO.Net technology.
• Designed portal database using Visio.
• Use WinCvs software to ensure programs being created were placed in a repository for entire team.

Bethesda, MD, US

• Contractor to CDC - Clinical Chemistry Branch
• Created an MS Access and VBA application that reads the varied outputs from an instrument used by Lipid Lab, to de-code and compile the output to send to a third party application. The application waits for feedback.
• Developed a VB6 application that creates and decodes masked pool IDs, to enable the Lipid Reference Lab to send out pools to its participating laboratories.
• Created a SQL Server database that uses stored procedures and triggers to track and report lipid results from CDC laboratories.
• Built an MS Access ordering database that tracks all orders for a CDC branch. This database categorizes and calculates expenditures for each fiscal year.
• Created an MS Access database using VBA that calculated the stipend for ORISE students.

• Contractor to CDC - Clinical Chemistry Branch
• Created an MS Access and VBA application that reads the varied outputs from an instrument used by Lipid Lab, to de-code and compile the output to send to a third party application. The application waits for feedback.
• Developed a VB6 application that creates and decodes masked pool IDs, to enable the Lipid Reference Lab to send out pools to its participating laboratories.
• Created a SQL Server database that uses stored procedures and triggers to track and report lipid results from CDC laboratories.
• Built an MS Access ordering database that tracks all orders for a CDC branch. This database categorizes and calculates expenditures for each fiscal year.
• Created an MS Access database using VBA that calculated the stipend for ORISE students.

Albuquerque, NM, US

• Designed, developed, and implemented structured programs in Microsoft Visual Basic and Microsoft Access. Interacted with all staff levels to define project scope, set expectations and establish timeframes. Created.
• Developed Relational Database programs using Microsoft Access. Created a database to track inventory of approximately 6,000 Personal PCs and miscellaneous hospital property. Also created a database to house and perform.
• Provided 24-hour support to diagnose and resolve system and software issues of applications acquired from vendors and developed internally.
• Utilized Microsoft Visual Basic and Access, developed programs to effectively troubleshoot and amend other programs in a timely manner.
• Created batch jobs in Microsoft Visual Basic to schedule programs to run in the Windows 95 and Windows NT environments.
• Implemented and maintained Health Care Industry specific software including SoftMed, DonorII, PrivPlus, QualPlus and RiskPlus.