Bill Dumler

Medical Survey System A distributed system to support defining, distributing, capturing and presenting statistical results for medical surveys for patient surgical procedures. System offered medical clients to manage patient surveys by procedure and administered via text messaging, email or phone call. Statistical results provided tools for evaluating by office, care team and individual provider. Solution was managed on the AWS consisting of systems supporting a global-facing UI, backend MVC, databases, interfacing to Twillo and email system . Stack : PHP (Laravel framework), MySQL DB, React and Javascript. Summary : ●​ Small startup company totaling 15 people from sales to development to support. ●​ Managed distributed development team using Agile principles. Included hiring, performance reviews and mentoring team located in multiple offices. ●​ Managed servers and systems on AWS account. ●​ Acting DB administrator and data modeler. ●​ Worked closely with management, clients and solution providers. ●​ Required knowledge of HIPAA rules and compliances as well as yearly reporting. Major Accomplishments : ●​ Updated statistical calculations of survey results to improve accuracy and reduce run times. Solution used a mix of stored procedures and backend code. Introduced new data model to improve storage and retrieval of statistical results used on the UI reporting pages. ●​ Created an email solution using AWS messaging and queues to recognize bounced messages and incorrect email addresses to avoid spamming notifications/shutdowns. Solution also include client email open tracking metrics and auto-detection of misspelled email domain names. ●​ Designed and developed voice survey system using Twillo API. Survey questions and multiple choice answers were presented as text to voice or pre-recorded voice files. Survey taker was provided tools to provide answer, repeat question/answer selection and leave voice comments. Metrics were gathered and reported to clients using the system. ●​ Improved database performance with tuning, data model design and reduced, unnecessary joins. ●​ Introduced and maintained HIPAA compliance to protect all patient data provided to the system. ●​ Introduced an Agile process suited for team dynamics to improve sprint management, velocity and reporting.