Himalayas logo
JOHN THORPEJT
Open to opportunities

JOHN THORPE

@johnthorpe

I am a SQL Developer and Data Support Specialist specializing in SQL and performance optimization.

United States
Message

What I'm looking for

I seek remote-friendly roles using SQL, ETL, and BI to optimize performance, solve complex data issues, and deliver actionable insights in collaborative teams.

I am a results-driven SQL Developer and Data Analyst with over seven years of hands-on experience building and optimizing data solutions using Microsoft SQL Server, SSMS, and MySQL. I specialize in T-SQL scripting, ETL pipelines with SSIS, and delivering actionable reports with SSRS, Power BI, and Tableau.

I have a track record of improving database performance and operational efficiency—optimizing queries and indexing strategies to reduce execution times by 35% and automating reporting workflows to cut report generation time by 40%. I design ETL pipelines, perform data cleansing and bulk operations, and troubleshoot data inconsistencies to preserve data integrity for stakeholders.

I thrive in remote and cross-functional environments, providing technical support through ticketing systems like Asana and collaborating via Slack, Teams, and Zoom. I combine clear communication with practical technical skills to support internal and external users and to deliver reliable, timely data solutions.

I hold a B.S. in Computer and Information Systems and an A.A.S. in Database Administration, plus a Data Analytics Certification from Colaberry. I am committed to continuous learning and seek opportunities where I can apply strong SQL, ETL, and BI expertise to drive measurable business impact.

Experience

Work history, roles, and key accomplishments

DA

SQL Data Support Specialist

DDC Public Affairs

Apr 2025 - Aug 2025 (4 months)

Identified and resolved data inconsistencies and performance issues in MS SQL queries, optimizing inline T-SQL scripts to improve data integrity. Provided technical support via Asana and executed bulk inserts/updates and data cleansing to maintain enterprise databases.

TI

SQL Developer and Data Analyst

Tic Tic Inc.

Aug 2018 - Apr 2025 (6 years 8 months)

Designed and implemented complex SQL queries and SSIS ETL pipelines, reducing query execution times by 35% and automating reporting workflows with T-SQL. Built SSRS dashboards to deliver actionable insights for remote teams and conducted root-cause analysis to improve database performance.

CC

Junior SQL Developer & Data Analyst

Christ Embassy Church

Aug 2015 - Aug 2018 (3 years)

Developed and maintained SQL queries and SSIS ETL workflows, automating reporting tasks and reducing report generation time by 40%. Provided training on data extraction and maintained data quality through T-SQL scripts and validation.

Education

Degrees, certifications, and relevant coursework

New York City College of Technology (CUNY) logoN(

New York City College of Technology (CUNY)

Bachelor of Science, Computer and Information Systems

Completed Bachelor of Science in Computer and Information Systems, graduating May 2020.

Borough of Manhattan Community College (CUNY) logoB(

Borough of Manhattan Community College (CUNY)

Associate of Applied Science, Database Administration

Completed Associate of Applied Science in Database Administration, graduating May 2015.

Tech stack

Software and tools used professionally

Find your dream job

Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan
JOHN THORPE - SQL Data Support Specialist - DDC Public Affairs | Himalayas