Sophia Kosiek
Fernandina Beach
Summary
SQL-focused Software Engineer with 4+ years of experience supporting high-availability, regulated enterprise systems within the Microsoft .NET ecosystem. Strong background in SQL Server development and administration, T-SQL optimization, CI/CD pipelines, permissions management, and production support, combined with hands-on experience building and maintaining EDI platforms for medical suppliers supporting VA and DoD contracts. Proven ability to own mission-critical systems end-to-end and quickly ramp into healthcare operations and claims-adjacent workflows.
Overview
4
4
years of professional experience
Work History
Software Engineer
Flightline
02.2023 - 06.2025
- Worked as the primary software engineer for a cloud-based EDI SaaS platform supporting medical supply chain operations for organizations working with VA and Department of Defense contracts; owned the full software development lifecycle (SDLC) from design through production support.
- Built an internal EDI diagnostics and monitoring tool that reduced support resolution time by 60%, enabling technical and business teams to trace, validate, and troubleshoot EDI transactions across five major trading partners.
- Developed, tested, and supported EDI X12 workflows including 850, 856, and 810, ensuring accurate parsing and transmission across procurement, logistics, distribution, and billing workflows.
- Automated Azure Logic App integrations handling B2B transactions, increasing system reliability and improving uptime by 30%.
- Modernized legacy SQL Server stored procedures, improving performance and maintainability; implemented version-controlled CI/CD pipelines for application and database deployments, reducing release time by 70%.
- Wrote and optimized T-SQL queries supporting order management, inventory tracking, reporting, and downstream system integrations.
- Provided on-call production support, troubleshooting SQL performance issues, failed EDI transactions, and Azure service incidents during peak hours with zero unplanned downtime.
- Managed secure access patterns and configuration secrets using Azure Key Vault and role-based permissions.
- Authored comprehensive technical and onboarding documentation, reducing recurring support tickets by 40% and improving long-term knowledge transfer.
Software Engineer
Quick Tie Products, Inc
08.2022 - 02.2023
- Modernized legacy C#/.NET applications into modular, maintainable services with improved SQL data access patterns.
- Optimized backend logic and database queries, reducing defects by 35% and improving system reliability.
- Supported internal IT operations, including user access provisioning, permissions management, and application deployments.
- Conducted root cause analysis and resolved production issues across distributed teams and time zones.
Software Developer
Prosper IT Consulting, Inc.
10.2021 - 08.2022
- Developed ASP.NET Core MVC applications using Entity Framework and SQL Server to support internal content and asset management systems.
- Implemented authentication, authorization, and CRUD workflows in multi-user environments.
- Participated in Agile development cycles, contributing to backend development, testing, and feature delivery.
Education
Graduate Certificate - Computer Programming
The Tech Academy
Portland, OR11.2021
Bachelor of Science - Chemistry
West Virginia University
Morgantown, WV05.2014
Skills
- SQL Server, T-SQL, Stored Procedures, Query Optimization
- SQL Security & Permissions (role-based access, least privilege)
- SSMS, LINQPad, Entity Framework
- Version-controlled database deployments
- C#, ASPNET Core, NET 6/7, Web API, MVC
- Blazor, Razor Pages
- JavaScript (Angular, React)
- HTML5, CSS3
- XML, YAML, JSON
- LINQ, OOP, RESTful API design
Databases and SQL
NET, Backend and Frontend Development
Cloud, Reliability and DevOps
- Microsoft Azure (App Services, Logic Apps, Functions, Key Vault, App Configuration, DNS)
- Azure DevOps CI/CD Pipelines
- Application Insights, monitoring, incident response
- High-availability workflow design
- EDIFACT and ANSI X12 (X12M Supplychain)
- Trading partner onboarding and support
- Secure B2B integrations using Azure Logic Apps
- Git, GitHub, SourceTree
- Visual Studio, VS Code, Postman
- Jira, Confluence, Agile/Scrum
- Technical documentation & knowledge transfer
EDI and Integration
Tools and Practices
PROFESSIONAL DEVELOPMENT & CERTIFICATIONS (IN PROGRESS)
Microsoft Certifications (In Progress)
- Azure Administrator Associate (AZ-104)
- Azure Database Administrator Associate (DP-300)
- Power BI Data Analyst Associate (PL-300)
Focused on Azure infrastructure management, SQL performance and availability, data governance, and analytics for enterprise and healthcare-adjacent systems.
Affiliations
- Veterans of Foreign War: Auxiliary
- Habitat For Humanity
Timeline
Software Engineer
Flightline
02.2023 - 06.2025
Software Engineer
Quick Tie Products, Inc
08.2022 - 02.2023
Software Developer
Prosper IT Consulting, Inc.
10.2021 - 08.2022
Graduate Certificate - Computer Programming
The Tech Academy
Bachelor of Science - Chemistry
West Virginia University