JOHN THORPE
@johnthorpe
I am a SQL Developer and Data Support Specialist specializing in SQL and performance optimization.
What I'm looking for
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
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.
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.
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)
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)
Associate of Applied Science, Database Administration
Completed Associate of Applied Science in Database Administration, graduating May 2015.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Social media
Job categories
Skills
Interested in hiring JOHN?
You can contact JOHN and 90k+ other talented remote workers on Himalayas.
Message JOHNFind 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!
