Guy Duerr

Guy Duerr Email and Phone Number

Database specialist. Create innovative storage and reporting solutions using Microsoft VBA.Net and C#.Net
Guy Duerr's Location
Alpharetta, Georgia, United States, United States
Guy Duerr's Contact Details
About Guy Duerr

I have worked as a contractor to the CDC for over 20 years with various companies. I utilize my 20+ years of Agile programming to develop innovative solutions for the needs of my client. I create relational databases for storing lab outcomes using VBA.NET and C#.NET. I excel at programming complex reports.

Guy Duerr's Current Company Details

Database specialist. Create innovative storage and reporting solutions using Microsoft VBA.Net and C#.Net
Guy Duerr Work Experience Details
  • Sis, Llc
    Data Analyst/Senior Software Developer
    Sis, Llc Apr 2020 - Sep 2020
    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.• Created SAS programs that I used to verify data from participants. • Effectively worked in a team environment to complete deadlines.• Utilized time management skills to effectively balance resources in order to meet the scheduled deadlines of multiple projects successfully.• Provided ongoing support, maintenance and enhancements throughout the program/database’s full life cycle.• Provided system analysis and plans for updates and enhancements to improve dataflow and time management.
    View
  • Cherokee Nation Businesses
    Senior Software Engineer
    Cherokee Nation Businesses Sep 2019 - Dec 2019
    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.• Used T-SQL, SQL Server, C#.Net, ADO.Net, MS Access, .Net Framework, Adobe PDF, MS Word and PowerPoint to automatically generate reports, briefings, issue papers and other communications that inform stakeholders about VSDB activities, findings and initiatives.• Created a program using C#.Net, ADO.Net and .Net Framework that allowed users to quickly trace flu virus sample counts by country.• Created a dashboard program using MS Access to give big picture overview of testing stage of the flu samples. • Created a program using C#.Net, ADO.Net and .Net Framework that showed location of sample id and processing status.• Created ETL (Extract, Transform, Load) code that parsed data from an instrument database and stored it automatically into a LIMS database.• Developed a program using SQL stored procedures that created reports for external entities, including the World Health Organization (WHO).• Designed, developed and implemented databases in SQL Server using T-SQL for tracking, calculating and reporting the FLU virus.• Project management and facilitation of meetings between FluLabs development team and VSDB.• Used T-SQL to problem solve issues related to the Flu Lab database and reporting.• Developed and implemented a project plan to catalog various databases for VSDB.• Communicated upcoming updates to the FluLabs database for all levels of users.
    View
  • Chickasaw Nation Industries, Inc.
    Senior Software Engineer
    Chickasaw Nation Industries, Inc. Oct 2016 - Sep 2019
    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.• Used T-SQL, SQL Server, C#.Net, ADO.Net, MS Access, .Net Framework, Adobe PDF, MS Word and PowerPoint to automatically generate reports, briefings, issue papers and other communications that inform stakeholders about VSDB activities, findings and initiatives.• Created a program using C#.Net, ADO.Net and .Net Framework that allowed users to quickly trace flu virus sample counts by country.• Created a dashboard program using MS Access to give big picture overview of testing stage of the flu samples. • Created a program using C#.Net, ADO.Net and .Net Framework that showed location of sample id and processing status.• Created ETL (Extract, Transform, Load) code that parsed data from an instrument database and stored it automatically into a LIMS database.• Developed a program using SQL stored procedures that created reports for external entities, including the World Health Organization (WHO).• Designed, developed and implemented databases in SQL Server using T-SQL for tracking, calculating and reporting the FLU virus.• Project management and facilitation of meetings between FluLabs development team and VSDB.• Used T-SQL to problem solve issues related to the Flu Lab database and reporting.• Developed and implemented a project plan to catalog various databases for VSDB.• Communicated upcoming updates to the FluLabs database for all levels of users.
    View
  • Carter Consulting Inc
    Senior Software Developer/Software Engineer
    Carter Consulting Inc Jan 2016 - Oct 2016
    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.• Troubleshoot and solve database and reporting issues.• Developed and implemented a project plan to catalog various databases for VSDB.• Communicate upcoming developments of the FluLabs database to all levels of users.
    View
  • Caci International Inc
    Systems Analyst, Lead
    Caci International Inc May 2009 - Jan 2016
    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, Imports, User Interface Controls and Reports.• 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. • Developed and implemented a C#.Net program that generates blind pool ids for a CDC program.• Created a C#.Net program that generates barcodes for laboratory samples.• Developed a C#.Net program that decodes pool ids for a CDC program.• Created a C#.Net program that allowed an end user to review/troubleshoot the laboratory instruments and the duration of specific sample types.• Created a VB.Net application that tracked chemicals in the laboratory. It allows all users to determine the location and amount of chemicals available.• Employed all resources to develop, test and submit prototypes within specified timeframe and incorporate feedback/changes into final product.• Provided ongoing support, maintenance and enhancements throughout the program/database’s full life cycle.• Utilized time management skills to effectively balance resources in order to meet the scheduled deadlines of multiple projects successfully.• Utilized knowledge of technical and functional components to convert technical terminology into user friendly discussions and end user documentation.• Acted as subject matter expert and knowledgeable resource to peers and end users.• Used data to Create and Design Functional Specifications outlining data types, data flow, development tools, users and timeframes.
    View
  • Transcore
    Senior Software Developer
    Transcore Oct 2007 - Feb 2009
    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.• Effectively work in a team environment to complete deadlines.
    View
  • Lockheed Martin Contractor To Cdc
    Systems Analyst, Lead
    Lockheed Martin Contractor To Cdc Jun 2004 - Oct 2007
    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 and imports results back into the program.• 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.• Created a VB6 application that backed up laboratory information to different drives and CDs.
    View
  • Eds Corporation
    Computer Programmer
    Eds Corporation Jan 1999 - Jun 2004
    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 and imports results back into the program.• 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.• Created a VB6 application that backed up laboratory information to different drives and CDs.
    View
  • Presbyterian Healthcare Services
    Programmer Analyst
    Presbyterian Healthcare Services Aug 1996 - Dec 1998
    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 related files, utilities and documentation, as well as provided ongoing post-implementation support and maintenance.• 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 calculations for the training evaluation results of approximately 20,000 hospital employees sorted by location and physician.• 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.• Effectively worked in team environment to design programs/databases and provide the transfer of knowledge to team members.
    View

Guy Duerr Skills

Microsoft Excel Government Analysis Research

Guy Duerr Education Details

  • University Of North Carolina At Charlotte
    University Of North Carolina At Charlotte
    Computer And Information Sciences And Support Services

Frequently Asked Questions about Guy Duerr

What is Guy Duerr's role at the current company?

Guy Duerr's current role is Database specialist. Create innovative storage and reporting solutions using Microsoft VBA.Net and C#.Net.

What is Guy Duerr's email address?

Guy Duerr's email address is gd****@****isn.com

What schools did Guy Duerr attend?

Guy Duerr attended University Of North Carolina At Charlotte.

What skills is Guy Duerr known for?

Guy Duerr has skills like Microsoft Excel, Government, Analysis, Research.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.