Senior Software Engineer

KELSEY WILLETT

Senior Software Engineer

Backend & Data Systems Cloud Integrations Enterprise Platforms Data & Analytics

336-***-**** *************@**********.*** https://www.linkedin.com/in/kwillett-software

https://github.com/kew44 https://trailblazer.me/id/kwillett

Summary

Senior Software Engineer with 12 years of experience designing and evolving scalable backend and data systems in enterprise environments. Experienced in object-oriented development, cloud integrations, analytics pipelines, and workflow automation. Thrives on translating complex operational requirements into maintainable, reliable systems that improve data integrity, reporting clarity, and cross-team collaboration.

Technical Skills

Backend & Programming

Object-Oriented Development (Apex, Java), Python, JavaScript, HTML/CSS, SQL (PostgreSQL, MySQL, MariaDB)

Data & Analytics

Data Modeling, ETL Concepts, Power BI, Qualtrics, Analytics Pipelines, JSON, Reporting Automation

Cloud & Platforms

AWS (secure integrations, data pipelines, analytics workloads), Hybrid Cloud / On-Prem Architectures

Enterprise & Low-Code Platforms

Salesforce (Apex, Flows, ScheduledApex, Lightning Web Components, Visualforce, Aura, SOQL, SFDX),

Microsoft Power Platform (PowerApps, Power Automate, Forms), SharePoint

DevOps & Collaboration

Git/GitHub, GitHub Actions, Jenkins CI/CD, Automated Testing, Visual Studio Code

Professional Experience

Duke University / UCLA-Duke National Center for Child Traumatic Stress (NCCTS)

Analyst Programmer II Feb 2024 – Present

Design and deliver cloud-based data and reporting systems supporting national programs and multi-site initiatives; modernize legacy workflows into scalable, auditable solutions.

Architected and scaled data collection and reporting systems, replacing manual workflows with automated, auditable solutions used by hundreds of partner organizations.

Led development of automated Qualtrics survey workflows and backend logic for high-volume, multi-tenant data ingestion, including organization enrollment, customized anonymous distribution, and secure response collection.

Developing an ETL pipeline using the Qualtrics REST API, Python, and JSON to ingest survey data into an on-prem PostgreSQL database, enabling organization-level analytics and custom Power BI reporting with Python visuals.

Engineered secure AWS Power BI integrations enabling the network’s first cross-site analytics initiatives while meeting organizational and data security standards.

Partnered with clinical, data, and leadership teams to define requirements, validate data integrity, and align analytics solutions with program evaluation goals.

Duke University / UCLA-Duke National Center for Child Traumatic Stress (NCCTS)

Analyst Programmer I Apr 2014 – Feb 2024

Led long-term development and administration of enterprise systems supporting large-scale data collection, reporting, and program operations 20+ clinical sites.

Owned full lifecycle backend development for a national Salesforce-based platform, delivering secure automations, integrations, and reporting for diverse stakeholder groups.

Designed and maintained backend logic to automate time-based workflows and follow-ups, with execution tracked through automated reporting and internal audits.

Refactored legacy automation logic into a consolidated ScheduledApex service (Java-like, object-oriented backend code executed via scheduled jobs) with comprehensive test coverage, improving maintainability, reliability, and scalability.

Achieved and sustained 96% automated test coverage across custom objects, triggers, and Visualforce pages, ensuring data integrity for 3,000+ sensitive client records.

Improved system performance and reliability through code optimization, configuration audits, and governance standards, increasing overall platform health by 41%.

Established coding standards and peer review practices while working within CI/CD pipelines (Jenkins GitHub Actions) to support reproducible, auditable deployments.

Replaced fragmented reporting processes with PowerApps and Power BI dashboards, reducing quarterly reporting effort by 80% and standardizing federal grant deliverables.

Collaborated across technical and non-technical teams to translate program requirements into secure, scalable technical solutions.

Education

Bachelor of Science, Computer Science Lenoir-Rhyne University — 2013

Student Volunteer, SIGCSE 2013

Team Member, CCSC: Southeastern Programming Competition (2012)

Recipient, Trustee Honors & LR Scholars Scholarships (2009)

Additional Learning

Salesforce Trailhead “Ranger” — 137 badges, 16 trails, 65k+ points

LinkedIn Learning — 10 certificates (as of July 2025)

Publications

Named in recognition of work building CIMI, the Salesforce web application instrumental to:

“Trauma-informed measurement-based care for children: Implementation in diverse treatment settings.” Psychological Services. Purbeck et al., 2020. https://psycnet.apa.org/doiLanding?doi=10.1037%2Fser0000383

Co-Author:

“Evolution of a Client-Level Dataset: 20 Years of National Child Traumatic Stress Network Data Collection” – Submitted to International Journal of Methods in Psychiatric Research (in review)

Contact this candidate