SQL Developer

P R O F I L E

Knoxville, TN ***** GitHub 865-***-**** ************@*****.***

Web, Software, and BI Developer with knowledge of SQL, NoSQL, VBA, Java, C#, .Net, JavaScript, and Angular. Experience with multiple projects involving the development, testing, release, and maintenance of databases and web apps. Able to work independently and in team environments, including Agile/Scrum. E D U C A T I O N E X P E R I E N C E

Pellissippi State Community College

Knoxville, TN • 2017 - 2020

A.S. in Computer Information Tech

Nov. 2022 – Feb. 2024

Software Developer I • SSMS/SSRS Developer • Press Glass

Developed detailed, dynamic reports with SSRS for use both in-office and on the factory floor, using a combination of T-SQL, VBA, and HTML/CSS to interpret and present complex data.

Developed queries, functions, stored procedures, and recurring jobs in SSMS using T-SQL to process and store large amounts of data.

Responded quickly to user-reported errors both on the report and DB level, and also performed regular database maintenance to prevent slowdowns on factory floor.

Maintained project forks and repositories with Git version control software.

Participated in bi-weekly scrum meetings with team to discuss and assist each other with current and future projects. Mar. 2021 – Nov. 2022

Analyst I • SQL Server Analyst/Dev • Pilot Flying J

Used TSQL to investigate, identify, and fix issues or bugs in the company’s database, as reported by the users.

Maintained and created new documentation as needed, to strengthen the workflow of the BI and Dev teams, and to assist IT.

Developed solutions and scripts to quickly investigate and resolve recurring issues or bugs within the database.

Performed regular maintenance on database, including routine pruning of duplicate records and erroneous data, and inserting new data for users during UI outages.

Worked in monthly on-call rotation, diagnosing and resolving data issues reported by users after hours.

Jan. 2020 – Oct. 2020

BI Developer • SQL Server BI Dev • Securities Service Network

Performed all tasks as the sole member of the development team.

Developed Microsoft SQL Server solutions and reports for all daily requests from within the company and its subsidiaries.

Performed routine and as-needed maintenance on data warehouses, queries, jobs, stored procedures, and reports.

Applied performance tuning to pre-existing queries and tables to make data retrieval up to 90% faster.

Created and maintained up-to-date documentation on all changes made and updated existing documentation to ensure accuracy.

Assisted with data pulls and transfers during company merger. L A N G U A G E S

C# T-SQL

Java JSON

JavaScript VBA

React Git

JQuery XML

Typescript CSS/SCSS

SQL HTML

K E Y S K I L L S

Object-Oriented Programming

SQL Server Management

Knowledge of Data Analytics

and Data Structures

Agile Scrum Team

Experience using Trello, Jira,

Aha!, and similar product

roadmap tools

Proficient in Word,

Powerpoint, and Excel

Experience with Vectoring

Software and InDesign

Typing speed of 90 WPM with

96% accuracy

Excellent written and verbal

communicator

Able to easily de-escalate

difficult situations

Devoted problem solver

J o s h u a G r a n t M c M a h a n

F u l l S t a c k D e v e l o p e r

Contact this candidate