SQL Analyst

CORE TECHNICAL SKILLS

Languages & Frameworks: React, Javascript, NodeJS, Material UI, Postman, C#.NET, HTML, Visual Studio Code, Visual Studio 2019, 2022, JSON, CSS, PHP

Databases: SQL 2019, 2022, MongoDB, MYSQL.

Platforms & Tools: APIs, Git, GitHub, Power Platform

Ticketing Systems: JIRA, JIRA Service Desk, Surado, Remedy, Atlys, Vantive Service Desk, Reflections, AgentAssist Administrator

Methodologies: Agile, Scrum, secure coding practices

Other Skills: API development & integration, workflow automation, technical documentation, cross-team collaboration

PROFESSIONAL EXPERIENCE

Carmax, Richmond, VA

Payroll Systems Developer II, May 2019 – July 2025

Achievements:

Authored and executed SQL scripts to resolve database issues, saving over 20 manhours and ensuring efficient system performance.

Acted as the primary contact for building SQL-based reports for Finance leaders, supporting data-driven decision making.

Engineered and maintained React-based applications, including a leave and away time update system, demonstrating strong application development skills.

Developed and tested a C# application using SQL Server and Entity Framework to automate document creation, streamlining processes and saving 10 hours per week.

Documented and refined processes by creating detailed scripts to correct common issues, ensuring consistency and reliability.

Responsibilities:

Responsible for all server build procedures for all Carmax store locations, ensuring robust and secure environments.

Provide code review for other developers, including performance profiling, critiquing, and creating best practice guides, fostering continuous improvement.

Documented and refined processes by creating detailed scripts to correct common issues, ensuring consistency and reliability.

Use SQL to create queries to identify data issues, troubleshoot payroll and payroll-related issues, enhancing system reliability and data integrity.

Diagnose and resolve issues with timekeeping software (Kronos) and user account data, ensuring seamless operations.

Maintain and update team documentation to support issue resolution and adapt to evolving system requirements.

Managed ticket resolution in alignment with departmental SLAs, demonstrating effective problem-solving and communication skills.

Leveraged Git for version control to support collaborative software development and ensure codebase integrity.

Advantasure LLC (formerly Tessellate LLC), Richmond, VA

Production Support Analyst, Oct 2016 – May 2019

Achievements:

Instrumental in the setup of new department, directing both the scope of projects and standard operating procedure.

Documented all procedures for the department, including scripts needed for software maintenance.

Wrote the setup and documentation material for new users coming into the department.

Created ticketing standards to ensure SOX compliance, including maintaining approval matrix.

Responsibilities:

Created SQL queries for ad hoc reporting, data validation, and system troubleshooting.

Provided story/bug identification and gather requirements to determine bug solutions and resolve issues in an agile environment.

Assisted in troubleshooting/development phase of production support tickets.

Provided demonstrations/explanation of various pieces of production portal and how they work with internal partners.

1630, Inc., Marion, NC

Software Engineer, November 2013- March 2015

Achievements:

Planned and created new updated version of MYSQL database for H.E.A.R.T. software, an EHR system.

Designed new layout for software and updated all system reports.

Created C# applications integrating with existing systems to extend functionality.

Developed web applications and forums using CSS, PHP, JavaScript, and SQL backends.

Responsibilities:

Planned/created complex SQL scripts for extracting data for reports or information for end users.

Planned/created web-based reports for end users.

Performed database migrations and managed Unix server deployments for distributed locations.

AgilQuest, Richmond, VA

Technical Support Engineer, February 2013-September 2013

Achievements:

Created procedure for a custom one click install of AgilQuest software for customers.

Responsibilities:

Performed QA testing across multiple SQL Server environments.

Built SQL scripts for analytics and custom reporting.

Worked with internal and external clients for import and normalization of third-party data.

Integrated Business Systems, Inc., Richmond, VA

SQL Support, November 2010-January 2013

Achievements:

Created training in SQL for new hires.

Responsibilities:

Troubleshoot SQL Database Issues.

Used SQL to backup/restore/resolve Client Database issues.

Clearly communicated complex technological concepts to end users of all skill levels.

Accurately documented support incidents within a call tracking system.

EDUCATION

ECPI College of Technology, Hampton, Virginia, A.A.S Networking Computer System Administration

Completed Courses in C# Programming, ASP.NET, SQL, Oracle Web Design, Unix Administration, Java, and Javascript.

Training received while enlisted with the United States Air Force

Contact this candidate