David McConnell

Nashville, Tennessee
redheaddebater@gmail.com • 724-822-7422

Flexible, detail-oriented Software Analyst with 10+ years of experience in SQL Server development, workflow automation, API integrations, and enterprise software support across healthcare, LIMS/LIS, and operational systems. Strong communicator who excels at improving processes, troubleshooting complex issues, and coordinating cross-functional teams. Passionate about building clarity out of complexity and delivering reliable, scalable solutions.

Core Skills: SQL Server (T-SQL) • SQL Stored Procedures & Jobs • REST API Integration • PowerShell • VBScript • Python • Workflow Automation • LIMS/LIS Systems • HL7 • Caché Server Pages web design • Crystal Reports • QA Testing • Technical Documentation • Cross-Team Collaboration
Languages: SQL, VB.net, PowerShell, VBScript, InterSystems ObjectScript, C++
Tools: SQL Server Management Studio, Dynamics SL, Crystal Reports, Git, InterSystems Caché, Visual Studio
Domains: ERP troubleshooting, Healthcare IT, LIMS/LIS, Pharmacy Workflow
Methods: Process Mapping, Requirements Gathering, Test Case Design, Troubleshooting

Nashville, TN | Dec 2019 - Present

• Maintain and enhance SQL Server scripts, stored procedures, and scheduled jobs supporting enterprise operations.
• Review project plans, QA final programs, and describe root causes and find temporary workarounds if the programs have already been released.
• Design and document backend workflows for Dynamics SL updates.
• Build automated REST API data pipelines using PowerShell and VBScript.
• Collaborate with operations and leadership to clarify requirements and streamline processes.

Nashville, TN | Aug 2016 - Dec 2019

• Developed integrations between LIMS software and external systems, including APIs and web interfaces.
• Designed and maintained customer-facing websites and internal tools.
• Provided technical support, troubleshooting, and workflow customization for laboratory clients.
• Improved communication between software interfaces to enhance data flow and system reliability.

Remote | Sep 2015 - Dec 2015

• Tested installation, UI, and functionality of Enterprise Manager across large-scale Caché environments.
• Validated mirrored databases, DataMoves, and new feature implementations.
• Authored test cases and verified bug fixes for production readiness.
• Ensured stability and usability across multiple deployment scenarios.

Daytona Beach, FL | Jun 2010 - Sep 2014

• Customized pharmacy workflow software for hospital clients, including label design and Crystal Reports.
• Converted patient-data formats and analyzed HL7 feeds for DoseEdge compatibility.
• Coordinated cross-department changes affecting pharmacists, technicians, and nursing workflows.
• Reviewed peer changes and documented all workflow modifications.
• Supported hospitals through implementation, troubleshooting, and workflow optimization.

Norfolk, VA | Apr 2009 - Nov 2009

• Built gameplay prototypes using Gamebryo Lightspeed integrated with PhysX.
• Documented engine behavior and development processes while building features.
• Contributed to early-stage design and technical experimentation for online gaming.

Tavares, FL | Sept 2005 - Aug 2008

• Ported DOS-based accounting software to Windows MFC.
• Designed Windows MFC application from the ground up.
• Converted function libraries in DOS based system into compatible C++ syntax and MFC system call.

Grove City College
B.S. Computer Information Systems, 2001 - 2005
Activities Speech & Debate (Captain), Student Governing Council (Commuter Representative)

• English, Native
• American Sign Language, Native/Bilingual