Ralph Macfadden Email & Phone Number

Winter Haven, FL

Design and automate processes to prevent and resolve application errors. Designed and developed OLB conversion (merger)/ETL processes using T-SQL programming, Excel VBA, and Powershell scripts. Designed, created, and maintained SQL Server 2016 databases. Created SSRS 2012 reports and SSIS 2008 transformations. Program PowerShell 5 scripts. Document.

Palm Beach Gardens, FL

Manage HL7 data interface projects between testing labs and EMR software at hospitals and physicians' offices. Ensure HIPAA compliance on my projects. Design and develop data transformation and storage processes with VB.Net (WinForms and Windows Services) and t-SQL programming. Analyze/support C#.Net applications. Design and develop databases to store the.

Convert VB6 applications to VB.Net with MySQL back end. Configure development workstations. Consult with CIO on meeting PCI standards. (Completed contract successfully.)

• Designed and programmed application upgrades that allowed for $500,000 in increased sales.
• Identified need for, designed, and created research tools while solving software problems in 20 applications involving VB.Net, VB6, ADO, ADO.Net, SQL Server, and MS Access.
• Designed XML-based custom application configuration system.
• Applied highest standards in documenting my research and applications.
• Managed document authentication project, designing processes that allowed for $500,000 in increased sales.
• Served as interim manager of Marketing Department.

• Guided implementation of Hawai`i’s Bio-Terrorism Response Suite for 150 users.
• Guided and developed Hawai`i’s National Electronic Disease Surveillance System (NEDSS) initiative, full development cycle. Planned and executed NEDSS custom ETL processes using MS SQL Server, XML, MS Excel, and MS.
• Configured, managed, and created reporting for data on published MRSA study.
• Developed 4 disease-response databases, often in emergencies, which resulted in awards for the response team. A federal grant reviewer called a 5th database the best of its kind in the country.
• Participated in the Hawai`i Strategic National Stockpile Exercise and planning.
• Participated in national health informatics conferences, founded the healthDB discussion list and a 3-state (UT, CA, HI) user’s group for users of PHS3, a NEDSS solution.

• Hired, trained, and managed clerical staff of 4 people.
• Designed and created Hawaii’s immunization registry for 30,000 at-risk children using complex custom SQL queries and automated ETL processes, converting flat files to fully-relational databases of over 1 million.
• Created user-friendly help and training documentation for the registry in HTML and Javascript.
• Created and maintained immunization information Web page on State intranet, the "best content on our intranet".
• Administered SQL Server, including all immunization databases.