User Tools

Site Tools


resume

David McConnell

Nashville, Tennessee
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
resume.txt · Last modified: by david

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki