Medium badge

Automation Machine

Louisville-Metro-Badges/Automation-Machine

Work to automate some process in the data life cycle- from data collection to data visualization.

 

Gerald Kaforski

Expert

Awarded badge on August 10, 2018

Medium img 0561

Endorsements & Feedback

Feedback

great job

Small img 0561 kaforski Over 1 year ago

Badge Portfolio

Proof of Automation

Evidence visible to public
Write up a summary about how you were able to change the process, and how the current automation process works. More Info

Public Health and Wellness Childhood Lead Poisoning Prevention Database Application

     The Department of Public health and Wellness needed a way to automate gathering and management of data related to the Childhood Lead Poisoning Prevention Program.  The need was to track information through the process of Blood Lead Testing, Follow Up Testing, referrals to other professionals, Home Visits, and more.  In addition they needed reports that would display Blood Lead tests inputted into the system the day before, their activities, and the status of individuals moving through the evaluation and treatment process.
     I created a Microsoft Access front end and SQL Server back end database application to do the job.  In addition I used Microsoft SQL Server reporting Services to meet their reporting needs.
     This database application is now used as a reference by the Commonwealth of Kentucky.