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 processeswith interactive flowcharts using PowerPoint 2016. Developed MVC 5 Web applications with C#;

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 data.

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.• Designed application upgrades and Application Support remedies saving $210,000 in user time, prevented HIPAA compliance penalties, and otherwise-lost customers.• Mentored and/or trained 5 colleagues in Visual Basic programming.• Mentored Quality Assurance staff in testing the procedures I designed, saving $2,000 per rollout.• Daily duties required solid understanding and application of full SDLC.• Designed XML-based custom application configuration system.• Applied highest standards in documenting my projects.

• 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 Access to integrate 8 varied legacy systems.• 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.• Greatly improved our relationships with other agencies, including other states.• Supported or assisted 5 State sites; TB, STD, HIV/AIDS, Epidemiology, and Immunization.• Received training on handling of HIV/AIDS data by CDC staff.

• 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 records. Also created VB6 interface which allowed my clerical supervisees to review and combine records, reducing the database size by 30%.• 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.