This is an old revision of the document!
Table of Contents
David McConnell
Location- Nashville, Tennessee
Contact- redheaddebater@gmail.com • 724-822-7422
Summary
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.
Technical Strengths & Skills
| Category | Technologies & Competencies |
|---|
| 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 |
Professional Experience
BFC Solutions — Programming Analyst
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.
ApolloLIMS — Client Solutions Programmer
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.
InterSystems — Software QA Tester
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.
Baxter Healthcare — Application Engineer II
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.
Nothing Is Impossible Studio — Prototype Game Developer
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.
Roundtable Software — Programmer
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.
Education
Grove City College
B.S. Computer Information Systems, 2001 – 2005
Activities- Speech & Debate (Captain), Student Governing Council (Commuter Representative)
Languages
- English- Native
- American Sign Language- Native/Bilingual