Tom is available for hire
Hire TomTom Schedin
Verified Expert in Engineering
Data Engineer and Developer
Saint Paul, MN, United States
Toptal member since May 28, 2024
Bio
Tom has 14 years of experience with SQL, spanning roles in data engineering, report writing, data analysis and conversion, ETL development, and technical support. He has worked for various industries, including the financial and healthcare sectors, collaborating closely with internal and external stakeholders from top to bottom. Tom is used to thriving in remote and hybrid environments and strives to efficiently provide the most valuable solutions in all kinds of challenging projects.
Portfolio
Avionte
SQL, IT Project Management, Data Analysis, Implementation...
LTCG
SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS)...
Newbury Partners
APIs, SQL, SQL Server Management Studio (SSMS), Postman, Data Analysis...
Experience
- Complex SQL Queries - 14 years
- SQL Server Management Studio (SSMS) - 14 years
- Windows - 14 years
- Schemas - 14 years
- SQL - 14 years
- Data Conversion - 12 years
- Data Analysis - 12 years
- SQL Server Integration Services (SSIS) - 5 years
Availability
Part-time
Preferred Environment
Windows, Office 365, SQL, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), FTP Servers
The most amazing...
...thing I've accomplished is creating custom SQL schema solutions for a large client, allowing them to greatly increase application security and logging ability.
Work Experience
Technical Solutions Engineer
2022 - 2024
Avionte
- Completed a comprehensive database analysis of various source systems, validated content, and ensured a seamless migration into the Avionte systems.
- Documented internal and external comments daily in Zendesk and tracked and updated up to 10 simultaneous projects across multiple stages.
- Provided in-depth, after-hours technical support to the overseas team when necessary and acted as the escalation point for other internal stakeholders.
- Helped support the technical services department's needs during a sudden six-week managerial absence, working closely with the department's director, VP, and managers.
Technologies: SQL, IT Project Management, Data Analysis, Implementation, Applicant Tracking Software (ATS), Office 365, Data Conversion, SaaS, Schemas, SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), Technical Support, Amazon Web Services (AWS), FTP Servers, Amazon S3 (AWS S3), Documentation, FTP, SQL Stored Procedures, SQL Functions, SQL Triggers, Complex SQL Queries, Zendesk, Time Management, Windows, Version Control, JSON/XML Schemas, DocuSign, ETL, PostgreSQL, Databases, SQL Server 2016, T-SQL (Transact-SQL), Microsoft SQL Server, Data Engineering, Microsoft Excel, Data, Git, Data Migration, JSON, Microsoft Data Transformation Services (now SSIS), CSV, Data Analytics, Excel VBA, Business Analysis, Database Administration (DBA), Azure, SFTP, Microsoft 365, Visual Basic, Visual Basic for Applications (VBA), Database Schema Design
ETL Developer
2022 - 2022
LTCG
- Designed, developed, and implemented data transformations using ETL tools and stored procedures within the data warehouse.
- Produced solutions that maximize performance, scalability, and extensibility while assisting with requirements gathering and reverse engineering of existing processes as needed.
- Worked closely with test and deployment groups to ensure high-quality solutions that are easy to test and deploy.
Technologies: SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), SQL, Agile DevOps, Scrum, Complex SQL Queries, SQL Stored Procedures, Office 365, Schemas, Windows, Data Conversion, ETL, ETL Development, Version Control, Documentation, Databases, Reports, T-SQL (Transact-SQL), Microsoft SQL Server, Data, Data Warehousing, ETL Implementation & Design, ETL Testing, Data Migration, Microsoft Data Transformation Services (now SSIS), CSV, Data Analytics, Agile, SFTP, Microsoft 365, GitHub
Senior Data Engineer
2020 - 2021
Newbury Partners
- Worked with the implementation team to translate customer technical specifications into database solutions and consulted with stakeholders regarding best practices for migration issues and how to resolve them.
- Developed complex, optimized Transact-SQL scripts to migrate data and perform ad hoc data updates between multiple projects simultaneously.
- Analyzed various data sets and identified entity relationships and attributes without diagrams or documentation.
- Maintained version control of all scripts via Git and intermittently addressed various SQL server and database maintenance issues.
Technologies: APIs, SQL, SQL Server Management Studio (SSMS), Postman, Data Analysis, Data Conversion, ETL, Implementation, IT Project Management, Office 365, FTP, Complex SQL Queries, SQL Triggers, SQL Functions, SQL Stored Procedures, Databases, SQL Server 2016, Technical Support, T-SQL (Transact-SQL), SaaS, Windows, Schemas, Applicant Tracking Software (ATS), Documentation, PostgreSQL, Time Management, JSON/XML Schemas, Microsoft SQL Server, Data Engineering, Microsoft Excel, Data, Git, Data Migration, JSON, .NET, Microsoft Data Transformation Services (now SSIS), CSV, Data Analytics, Excel VBA, Business Analysis, Database Administration (DBA), SFTP, Python 3, Microsoft 365, Database Schema Design, GitHub, REST APIs, SQL Server 2012
Senior Implementation Specialist
2016 - 2020
TempWorks Software
- Handled the initial client environment set up of SQL Server Reporting Services (SSRS), Active Directory (AD), and an internal licensing system, including configuring internal websites.
- Completed the ETL process by creating and manipulating DDL and DML scripts, then maintained and improved these conversion scripts throughout the implementation process.
- Dealt with multiple projects simultaneously while adapting to changing timelines and performing occasional on-site visits to client locations for first-week live support.
- Provided in-depth technical support to external stakeholders through multiple phases, including ad hoc report creation related to custom data.
Technologies: SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Data Analysis, Data Conversion, ETL, Implementation, Office 365, Technical Support, IT Project Management, FTP, Databases, SQL Stored Procedures, Complex SQL Queries, SQL Functions, SQL Triggers, SaaS, APIs, Documentation, Windows, Schemas, JSON/XML Schemas, Applicant Tracking Software (ATS), PostgreSQL, Visual Studio, FTP Servers, Reports, Microsoft Report Builder, Time Management, SQL Server 2016, T-SQL (Transact-SQL), Microsoft SQL Server, Data Engineering, Microsoft Excel, Data, Database Design, ETL Implementation & Design, Data Migration, JSON, .NET, Microsoft Data Transformation Services (now SSIS), CSV, Data Analytics, Excel VBA, Business Analysis, Database Administration (DBA), SFTP, Microsoft 365, Microsoft Access, Visual Basic, Visual Basic for Applications (VBA), Database Schema Design, Active Directory (AD), SQL Server 2012, SQL Server DBA
Custom Reports Programmer II
2014 - 2016
Paylocity
- Analyzed new report requests and consulted with stakeholders to ensure the best option was presented to clients.
- Created SQL queries to display or calculate the necessary information identified from client discussions.
- Built reports within Visual Studio and Microsoft Report Builder and worked with IT to deploy them for end-user testing.
Technologies: SQL, SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Technical Support, Reports, Visual Studio, Microsoft Report Builder, T-SQL (Transact-SQL), Time Management, SQL Functions, Complex SQL Queries, SQL Stored Procedures, SQL Server 2008, SQL Server 2014, Microsoft SQL Server, Microsoft Excel, Data, CSV, SQL Server 2012
Systems Analyst
2010 - 2014
TempWorks Software
- Performed the ETL process for new client implementations and existing client upgrades by analyzing various source data.
- Handled data conversions and supported clients through testing and go-live phases.
- Developed reports, exports, imports, and feeds based on client needs identified during and after implementations.
- Worked with IT leaders to analyze self-hosted client environments and confirm requirements to run company software were present. Necessary changes were outlined and recommended to the client.
- Performed primary database and server tasks, including size management, security configurations, and general optimizations.
- Built and troubleshot reports, documenting issues and resolutions within the internal ticketing system.
Technologies: SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio, FTP, Databases, Technical Support, IT Project Management, Data Conversion, Data Analysis, Documentation, ETL, SQL Stored Procedures, SQL Triggers, SQL Functions, Complex SQL Queries, Applicant Tracking Software (ATS), SaaS, T-SQL (Transact-SQL), PostgreSQL, Time Management, FTP Servers, JSON/XML Schemas, Microsoft Report Builder, SQL Server 2008, Microsoft SQL Server, Microsoft Excel, Data, Database Design, ETL Implementation & Design, Data Migration, .NET, Microsoft Data Transformation Services (now SSIS), CSV, Data Analytics, Excel VBA, Business Analysis, Database Administration (DBA), SFTP, Microsoft Access, Visual Basic, Visual Basic for Applications (VBA), Database Schema Design, Web Design, Active Directory (AD), SQL Server 2012, SQL Server DBA
Experience
ETL Process Validation Report
This project involved building an in-depth and robust SQL procedure to report on all stages of the ETL process for one of the company's largest clients. The primary purpose was to ensure data counts were as expected between stages; the secondary purpose was to provide descriptive error reporting if issues were found during the process.
Skills
Libraries/APIs
Complex SQL Queries, REST APIs
Tools
Microsoft Excel, Visual Studio, Microsoft Report Builder, Git, Microsoft Access, Postman, GitHub
Languages
SQL, T-SQL (Transact-SQL), Excel VBA, Visual Basic, Visual Basic for Applications (VBA), Python 3
Paradigms
ETL, Database Design, ETL Implementation & Design, Scrum, Agile
Platforms
Windows, Zendesk, Amazon Web Services (AWS), Azure
Storage
SQL Server Management Studio (SSMS), Databases, SQL Server 2016, SQL Stored Procedures, SQL Triggers, SQL Functions, SQL Server 2008, SQL Server 2014, Microsoft SQL Server, SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), JSON/XML Schemas, PostgreSQL, Amazon S3 (AWS S3), JSON, Database Administration (DBA), SQL Server DBA
Frameworks
.NET
Industry Expertise
Web Design
Other
Office 365, Schemas, Data Analysis, Data Conversion, Applicant Tracking Software (ATS), Implementation, Time Management, Data, Data Migration, CSV, Data Analytics, SFTP, Microsoft 365, Technical Support, SaaS, ETL Development, FTP Servers, FTP, Reports, Documentation, DocuSign, Data Engineering, Data Warehousing, ETL Testing, Microsoft Data Transformation Services (now SSIS), Business Analysis, Database Schema Design, Active Directory (AD), Version Control, IT Project Management, Agile DevOps, APIs
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring