====== David McConnell ======
Nashville, Tennessee \\
[[mailto-redheaddebater@gmail.com|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 =====

**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