Tim is available for hire

Tim Langseth

Verified Expert in Engineering

Database Developer

Location

Hawley, MN, United States

Toptal Member Since

October 28, 2022

Tim has over 20 years of software development experience. He also spent 15+ years working freelance for various-sized companies, from large organizations and enterprises to startups that needed him to bring their idea to reality. He specializes in ASP.NET, .NET, C#, SQL Server Integration Services (SSIS), MySQL, and Python. Tim's robust background allows him to ramp up on projects of all sizes quickly and efficiently.

Portfolio

MasTec

SQL Server Integration Services (SSIS), C#, Python, Windows PowerShell, APIs...

Freelance Clients

PHP, MySQL, Microsoft SQL Server, SQL Server Integration Services (SSIS)...

JOHO, LLC

C#, Azure, Azure Functions, Microsoft SQL Server, ASP.NET, Telerik, DevExpress...

Experience

SQL Stored Procedures - 20 years Relational Database Design - 20 years SQL Server Integration Services (SSIS) - 20 years SQL - 20 years MySQL - 14 years Data Warehouse Design - 12 years Python - 11 years Oracle - 8 years

Availability

Part-time

Preferred Environment

Visual Studio, SQL Server Management Studio (SSMS), C#, MySQL, Microsoft SQL Server, Oracle, .NET, ASP.NET, SQL Server Integration Services (SSIS), Python

The most amazing...

...thing I've built included 100+ ETL packages, some with 50+ steps, using SSIS to extract, transfer, convert, and load multiple sources into the data warehouse.

Work Experience

Lead Solutions Engineer

2021 - PRESENT

MasTec

Created a C# application to call third-party APIs through GET and POST requests. I used the GETs to ensure that POSTs were successful by comparing before and after data to the source and destination.
Wrote PowerShell scripts to push data to multiple systems, including Microsoft SQL DB, into Active Directory.
Created an ETL process to export data from the in-house database into a file on the file transfer protocol site.
Built a second ETL process to read data dumps from an external source back into the in-house database and compare differences.

Technologies: SQL Server Integration Services (SSIS), C#, Python, Windows PowerShell, APIs, SQL, Microsoft SQL Server, ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Back-end, Analytics, Business Intelligence (BI), Data Modeling, Data Architecture, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, Visual Studio 2016, .NET Core, REST APIs, .NET, C#.NET, Relational Database Design, Database Architecture, Relational Databases, Data Analytics, SQL Stored Procedures, T-SQL (Transact-SQL), Linked Servers, JavaScript, SQL Server Management Studio (SSMS), Visual Studio, TFS, XML, JSON, Git, Jira, Bitbucket, Back-end Development, Microsoft Excel, Reports, DevOps, Database Optimization, Data Visualization, User Experience (UX), Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Microservices, Technical Leadership, Agile, Prototyping, Application Architecture, Software Architecture, .NET 4, Web API, SQL Server 2016, Training, Networking, IT Security, API Integration, Data Integration, Office 365, Team Leadership, Management, Reporting, Data Transformation, Database Administration (DBA), Microsoft DBA, SQL DML, Data Queries, SQL Performance, ELT, Big Data Architecture, Data Migration, Data Extraction, DAX, Power Query, Entity Relationships, Database Migration, ETL Tools, Data Science, ETL Pipelines, Big Data, Database Lifecycle Management (DLM), Cloud, Dashboards, Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Dashboard Design, Windows Server, Microsoft, CSS3, HTML5, Design Patterns, Entity Framework, Web Architecture, Web Application Architecture, RESTful Services, Microsoft 365, Microsoft Power Apps, SharePoint, Object-oriented Programming (OOP), Optimization, TypeScript, Testing, ETL Implementation & Design, ETL Development, ETL Testing, Integration, Software Development Lifecycle (SDLC), Full-stack Development, Project Management, Web Project Management, IT Project Management, Data Synchronization, QA Testing, Documentation, Quality Assurance (QA), User Interface (UI), Front-end, CSV File Processing, Data Matching, Excel 365, Warehouses, Data Reporting, Data Quality, Algorithms, Release Management, Code Review, Google Sheets, Python 3, Manual Testing, Test Automation, API Testing, Microsoft Azure, Unit Testing, Visual Studio Code (VS Code), Server-side Programming, SQL Architecture

Owner and Independent Consultant

2007 - PRESENT

Freelance Clients

Wrote Python scripts to load well data from multiple states. Each state could have different formats, column names, and data points to create and map out all points of a well.
Built a MySQL stored procedure to take data from a flat row data lake and migrate it into a data source, pivotable based on month and year, and used Loop to process running historical data for different period comparisons.
Performed all project lifecycle phases, including proposal, work statement, requirements gathering, development, deployment, and production support.
Optimized the database by correcting indexes created by previous developers and implementing an archiving process to remove millions of records from the application's core table.
Generated over 30 enhanced .NET controls to make development faster, more efficient, and consistent.
Created an online address and phone book with Ajax, ASP.NET, and C# for an interactive user experience, allowing users to find what they were looking for quickly.
Developed an online auction website for cars and recreational vehicles and implemented set bid increments and up-to-bid limits to eliminate users' need to watch items constantly, including a buy-it-now feature, reserve pricing logic, and invoicing.
Collaborated with a third-party hosting and DNS company support team when servers or services were down, causing client downtime, to resolve the issue as quickly as possible.
Implemented multiple inventory management websites, including the inventory's public display and a back-end administrator login to manage inventory.
Engaged with multiple clients fixing database object performance, returning incorrect data results, data, and database security.

Technologies: PHP, MySQL, Microsoft SQL Server, SQL Server Integration Services (SSIS), Python, Windows PowerShell, C#, ASP.NET, SQL, T-SQL (Transact-SQL), APIs, JavaScript, React, AngularJS, VBScript, Microsoft Power BI, WordPress, Sitefinity, Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF), XML, JSON, Git, Jira, Bitbucket, TFS, Azure, Azure Functions, GitLab, REST, Ajax, IIS, SQL Server Reporting Services (SSRS), Excel VBA, Visual Basic for Applications (VBA), Data Modeling, Business Intelligence (BI), RabbitMQ, Back-end Development, Front-end Development, LINQ, OOP Designs, Relational Databases, Data Analytics, Amazon RDS, ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Data Warehouse Design, Data Warehousing, Back-end, Analytics, PL/SQL, Data Architecture, Google Analytics, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Desktop App Development, Windows, Visual Studio 2016, .NET Core, Angular, REST APIs, .NET, Amazon Web Services (AWS), Docker, C#.NET, Relational Database Design, Database Architecture, SQL Stored Procedures, Linked Servers, Data Lakes, SQL Server Management Studio (SSMS), Visual Studio, ODBC, VB.NET, Oracle PL/SQL, PL/SQL Developer, Web Services, Windows Services, Microsoft Excel, Reports, DevOps, Database Optimization, Data Visualization, User Experience (UX), Azure Data Lake, Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), Oracle Database, DB, Site Reliability Engineering (SRE), OAuth 2, Functional Programming, Java, Microservices, Technical Leadership, Agile, Prototyping, Node.js, React Native, Lambda Functions, NGINX, Lambda Architecture, Application Architecture, Software Architecture, Server-side Rendering (SSR), Serverless, .NET 4, Web API, Model View Controller (MVC), SQL Server 2016, jQuery, Bootstrap, Training, Amazon EC2, Linux, Networking, IT Security, Google Tag Manager, Google Ads, Windows Forms (WinForms), API Integration, Data Integration, G Suite, Office 365, Office 365 API, DocuSign, G Suite API, PHP 7, GitHub, Reporting, Data Transformation, CRM APIs, Database Administration (DBA), Microsoft DBA, Crystal Reports, SQL DML, Data Queries, SQL Performance, ELT, Big Data Architecture, Data Migration, Data Extraction, DAX, Power Query, Microsoft Access, Entity Relationships, Database Migration, ETL Tools, Data Science, Snowflake, ETL Pipelines, Big Data, Database Lifecycle Management (DLM), eCommerce, Cloud, Dashboards, Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Dashboard Design, Minimum Viable Product (MVP), Windows Server, Visual Basic .NET (VB.NET), Microsoft, CSS3, HTML5, Design Patterns, Entity Framework, Azure Cloud Services, Weebly, Web Architecture, Web Application Architecture, Data Scraping, Scraping, RESTful Services, AWS Lambda, RESTful Web Services, Microsoft 365, Microsoft Power Apps, SharePoint, Object-oriented Programming (OOP), Optimization, TypeScript, Testing, ETL Implementation & Design, ETL Development, ETL Testing, Integration, Software Development Lifecycle (SDLC), CI/CD Pipelines, Full-stack Development, Project Management, Web Project Management, WP Engine, Magento, IT Project Management, Landing Pages, Data Synchronization, QA Testing, Documentation, QA Automation, Elasticsearch, PostgreSQL, Quality Assurance (QA), User Interface (UI), Front-end, CSV File Processing, Data Matching, Excel 365, ChatGPT, Warehouses, Data Reporting, Web Scraping, Data Quality, Web Analytics, DataFrames, DevExpress, Telerik, Pandas, Website Data Scraping, Database Scripting, Databricks, Spark, ReactPHP, Shopify, Vue, Vue SSR, Search Engine Optimization (SEO), SEO Tools, Technical SEO, Wix, Automation, UI Automation, Workflow Automation, Algorithms, Beautiful Soup, Selenium, Web Dashboards, Release Management, Code Review, Google Sheets, Python 3, Manual Testing, Test Automation, API Testing, Microsoft Azure, Unit Testing, Visual Studio Code (VS Code), Server-side Programming, SQL Architecture

VP of Operations

2018 - 2021

JOHO, LLC

Built over 100 ETL packages using SSIS to extract, transfer, convert, and load multiple bank cores' data into a single data warehouse daily into dimension and fact tables.
Devised a process to keep the standard JOHO data warehouse consistent across all clients while supporting individual client-only data warehouse needs through customer-based database schemas.
Communicated with a third-party software company to help them understand our specific reporting software needs so that they could provide us with future enhancements or workarounds.
Managed the report development team, held one-on-ones, and looked to help mentor and share knowledge with all team members.
Designed a flat-table building process that took any SQL views with certain prefixes and created faster-loading SQL tables from that data nightly, recreating indexes and constraints, which also provided faster data loading from the data warehouse.
Created a data scrubbing process to scrub and sanitize production data into fake testing data, leveraging real account transactions but changing names and addresses and adjusting balances, account numbers, and any personally identifiable information.
Developed a custom .NET software product and deployed it to multiple clients' on-premises servers for consistency and efficiency.
Set up a process that enables client data to flow through Azure Functions from an on-premise server into an Azure server securely using a hybrid connection manager.
Configured ten complete Azure server environment developments, tests, and productions using Azure Functions and hybrid connections to move data.
Centralized the critical data scrubbing logic into database functions and stored procedures to streamline the data scrubbing process.

Technologies: C#, Azure, Azure Functions, Microsoft SQL Server, ASP.NET, Telerik, DevExpress, ODBC, SQL Server Integration Services (SSIS), Windows PowerShell, Visual Studio, SQL Server Management Studio (SSMS), ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Data Warehouse Design, Data Warehousing, Back-end, Analytics, Business Intelligence (BI), SQL, Data Modeling, Data Architecture, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, Visual Studio 2016, .NET Core, REST APIs, .NET, C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, Data Analytics, SQL Stored Procedures, T-SQL (Transact-SQL), Linked Servers, APIs, Data Lakes, JavaScript, Web Services, IIS, Windows Services, TFS, XML, JSON, Git, Jira, Bitbucket, Back-end Development, Front-end Development, Microsoft Excel, Reports, DevOps, Database Optimization, Data Visualization, User Experience (UX), Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Functional Programming, Java, Technical Leadership, Agile, Prototyping, Application Architecture, Software Architecture, Server-side Rendering (SSR), .NET 4, Web API, SQL Server 2016, jQuery, Bootstrap, Training, Linux, Networking, IT Security, API Integration, Data Integration, Office 365, Team Leadership, Management, Reporting, Data Transformation, Database Administration (DBA), Microsoft DBA, SQL DML, Data Queries, SQL Performance, ELT, Big Data Architecture, Data Migration, Data Extraction, Entity Relationships, Database Migration, ETL Tools, Data Science, ETL Pipelines, Big Data, Database Lifecycle Management (DLM), Cloud, Dashboards, Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Dashboard Design, Minimum Viable Product (MVP), Windows Server, Microsoft, CSS3, HTML5, Design Patterns, Entity Framework, Azure Cloud Services, Web Architecture, Web Application Architecture, RESTful Services, AWS Lambda, RESTful Web Services, Microsoft 365, Object-oriented Programming (OOP), Optimization, TypeScript, Testing, ETL Implementation & Design, ETL Development, ETL Testing, Integration, Software Development Lifecycle (SDLC), Full-stack Development, Project Management, Web Project Management, IT Project Management, Landing Pages, Data Synchronization, QA Testing, Documentation, Quality Assurance (QA), User Interface (UI), Front-end, CSV File Processing, Data Matching, Excel 365, Warehouses, Data Reporting, Data Quality, Web Analytics, Algorithms, Release Management, Code Review, Google Sheets, Manual Testing, Test Automation, API Testing, Microsoft Azure, Unit Testing, Visual Studio Code (VS Code), Server-side Programming, SQL Architecture

Director of Technology Services

2014 - 2018

Razor Consulting Solutions

Corrected the SQL Server security, cleaning up all users' permissions by assigning database roles, creating custom database roles for specific objects, and removing multiple people as admins or owners.
Used SSIS to pull data from the SQL Server, flat and Excel files, and SharePoint, transform them into clearer metrics, and store them back on the SQL Server for reporting.
Displayed custom reports using Power BI, allowing users to filter. In some instances, I also used Excel's Power Pivot, Power Query, and Pivot Tables to create reports.
Set up consistent structure and processes, so each project has the same workflow.
Collaborated and communicated efficiently with consultants from four other companies to formulate a solution for clients.
Coordinated the software development team's priorities, roles, and responsibilities and analyzed each project's priority weekly to determine if resources needed adjusting to meet deadlines.
Innovated a replication process between the Sybase database through VPN and into the SQL Server on the Rackspace cloud environment.
Sent weekly clear communication with clients on terms, contracts, status updates, budgets, and action items.
Engaged with the company's leadership and executive team, contributing impactful decisions that affected the company's roadmap, strategy, and employees.
Managed the company's technical side, including all projects, employees, and other aspects.

Technologies: Microsoft SQL Server, MySQL, ASP.NET, C#, VB.NET, Power Pivot, Windows PowerShell, Microsoft Power BI, SQL Server Integration Services (SSIS), ETL, Data Engineering, Data Pipelines, Query Optimization, Performance Tuning, Back-end, Analytics, Business Intelligence (BI), SQL, Data Architecture, Google Analytics, PHP, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, Visual Studio 2016, REST APIs, .NET, Amazon Web Services (AWS), C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, Data Analytics, SQL Stored Procedures, T-SQL (Transact-SQL), Linked Servers, APIs, JavaScript, SQL Server Management Studio (SSMS), Visual Studio, ODBC, Web Services, IIS, Windows Services, WCF Web Services, TFS, XML, JSON, Git, Jira, Bitbucket, Back-end Development, Front-end Development, Microsoft Excel, Reports, Database Optimization, Data Visualization, User Experience (UX), Databases, Datasets, Data Analysis, Data Cleansing, Data Profiling, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Site Reliability Engineering (SRE), Functional Programming, Technical Leadership, Agile, Prototyping, Node.js, Application Architecture, Software Architecture, Server-side Rendering (SSR), .NET 4, Web API, Model View Controller (MVC), SQL Server 2016, jQuery, Bootstrap, Training, Networking, IT Security, Windows Forms (WinForms), API Integration, Data Integration, Office 365, DocuSign, G Suite API, Team Leadership, Management, Reporting, Data Transformation, Database Administration (DBA), Microsoft DBA, Crystal Reports, SQL DML, Data Queries, SQL Performance, ELT, Data Migration, Data Extraction, DAX, Power Query, Python, Entity Relationships, Database Migration, ETL Tools, Data Science, ETL Pipelines, Big Data, Database Lifecycle Management (DLM), Cloud, Dashboards, Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Dashboard Design, Windows Server, Visual Basic .NET (VB.NET), Visual Basic, Microsoft, HTML5, Design Patterns, Entity Framework, Web Architecture, Web Application Architecture, Data Scraping, Scraping, RESTful Services, RESTful Web Services, Microsoft 365, SharePoint, Object-oriented Programming (OOP), Optimization, TypeScript, Testing, ETL Implementation & Design, ETL Development, ETL Testing, Integration, Software Development Lifecycle (SDLC), Full-stack Development, Project Management, Web Project Management, IT Project Management, Landing Pages, Data Synchronization, QA Testing, Documentation, QA Automation, Quality Assurance (QA), User Interface (UI), Front-end, CSV File Processing, Data Matching, Excel 365, Warehouses, Data Reporting, Web Scraping, Data Quality, Web Analytics, Algorithms, Release Management, Code Review, Google Sheets, Manual Testing, Test Automation, API Testing, Unit Testing, Server-side Programming, SQL Architecture

Software Application Development Manager

2007 - 2014

NAU Country, a QBE Insurance Company

Devised custom web and user controls that improved team efficiency by placing repetitive logic setup and control validation at the control level.
Researched a faster and more efficient way for developers to track errors across all applications to set up a core base error logging, so anything that rolls to the highest point of code still gets logged.
Built tools to optimize the development team's productivity by creating alerts when Oracle database objects were invalidated due to a change, to not cause others downtime.
Helped design and develop a code compare tool to verify code changes in all yearly-based files and prevent bugs from recurring.
Managed multiple projects, fulfilling different roles of designer, developer, code reviewer, and quality assurance officer within the development lifecycle.
Collaborated with designers to work on stronger security practices, coding standards, and other items that should be communicated to the entire development team.
Developed automated tests to run for release deployment verifications to remove the need for manual testing after nightly releases.
Created task alerts to email team members of pending high-priority tasks that need immediate assistance.
Owned release manager responsibilities and worked with project management, business analyst, quality assurance, server, network, build, deployment, and development teams to communicate daily release status updates.
Handled Progress Telerik Sitefinity configuration, customization, and enhancements after the initial vendor installation.

Technologies: Oracle, Tableau, Oracle PL/SQL, PL/SQL Developer, Microsoft SQL Server, T-SQL (Transact-SQL), C#, Visual Basic 6 (VB6), ASP.NET, Active Server Pages (ASP), IIS, Visual Studio, Windows PowerShell, Python, WCF Web Services, Windows Services, TFS, Query Optimization, Performance Tuning, Back-end, Analytics, Business Intelligence (BI), SQL, PL/SQL, Data Architecture, Google Analytics, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Desktop App Development, Windows, REST APIs, .NET, C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, Data Analytics, SQL Stored Procedures, Linked Servers, APIs, JavaScript, PHP, SQL Server Management Studio (SSMS), VBScript, ODBC, Web Services, Windows Communication Foundation (WCF), XML, JSON, Back-end Development, Front-end Development, Microsoft Excel, Reports, Database Optimization, Data Visualization, User Experience (UX), Data Engineering, Databases, Datasets, Data Analysis, Data Cleansing, SolarWinds, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), Oracle Database, DB, Site Reliability Engineering (SRE), Functional Programming, Technical Leadership, Agile, Application Architecture, Software Architecture, .NET 4, Web API, Model View Controller (MVC), jQuery, Training, Networking, IT Security, Windows Forms (WinForms), API Integration, Data Integration, Team Leadership, Management, Reporting, SQL DML, Data Queries, SQL Performance, ELT, DAX, Power Query, Entity Relationships, Database Migration, ETL Tools, ETL, ETL Pipelines, Database Lifecycle Management (DLM), Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Windows Server, Visual Basic .NET (VB.NET), Visual Basic, Microsoft, Design Patterns, Web Architecture, Web Application Architecture, Object-oriented Programming (OOP), Optimization, Testing, ETL Implementation & Design, ETL Development, ETL Testing, Integration, Software Development Lifecycle (SDLC), Full-stack Development, Project Management, Web Project Management, Landing Pages, QA Testing, Documentation, QA Automation, Quality Assurance (QA), User Interface (UI), Front-end, CSV File Processing, Data Matching, Warehouses, Data Reporting, Data Quality, Web Analytics, Release Management, Code Review, Manual Testing, Test Automation, API Testing, Unit Testing, Server-side Programming, SQL Architecture

Application Developer

2002 - 2007

Microsoft

Engaged as one of the top developers requested by project managers to be part of the development team due to experience and ability to work on any part of the system.
Ensured high-quality code output from myself and everyone else on the team. During testing sessions, I would thoroughly review as many features as possible, looking for issues that needed correcting before the next release.
Participated as one of the leading developers who interacted with consultants from around the globe to answer their questions, provide feedback, and do code reviews.

Technologies: ASP.NET, C#, Web Services, IIS, Windows Services, Query Optimization, Back-end, SQL, Data Architecture, CSS, HTML, Software Design, Web Development, Architecture, Full-stack, Leadership, Requirements Analysis, Windows, .NET, C#.NET, Relational Database Design, Database Architecture, OOP Designs, Relational Databases, SQL Stored Procedures, T-SQL (Transact-SQL), JavaScript, SQL Server Management Studio (SSMS), Visual Studio, VBScript, Active Server Pages (ASP), WCF Web Services, TFS, Windows Communication Foundation (WCF), XML, Back-end Development, Front-end Development, Microsoft Excel, Database Optimization, User Experience (UX), Data Engineering, Databases, Datasets, Data Analysis, Query Plan, Data Entry, SQL Views, Database Design, Database Schema Design, Stored Procedure, API Databases, Relational Database Services (RDS), DB, Functional Programming, Java, Web API, Windows Forms (WinForms), SQL DML, Data Queries, SQL Performance, ELT, Data Migration, Data Extraction, Entity Relationships, ETL Tools, ETL, ETL Pipelines, Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Windows Server, Visual Basic .NET (VB.NET), Microsoft, Design Patterns, Web Architecture, Web Application Architecture, Object-oriented Programming (OOP), Optimization, Testing, ETL Implementation & Design, ETL Development, ETL Testing, Integration, Software Development Lifecycle (SDLC), Full-stack Development, Web Project Management, Landing Pages, QA Testing, Documentation, Quality Assurance (QA), User Interface (UI), Front-end, Data Matching, Data Reporting, Data Quality, Code Review, Manual Testing, Test Automation, API Testing, Server-side Programming, SQL Architecture

Experience

Data Warehouse Data Flow for Fintech

Developed over 100 ETL packages, some with over 50 steps, using SSIS to extract, transfer, convert, and load multiple bank cores' data into a single data warehouse daily.

During this project, I configured ten full Azure server environment developments, tests, and productions, moving data with Azure Functions and hybrid connections. I also implemented a process using a hybrid connection manager, which enabled client data to securely flow through Azure Functions from the on-premise server into the Azure server. Additionally, I streamlined the data scrubbing process by centralizing the critical data scrubbing logic into database functions and stored procedures.

For historical comparisons, I completed an ETL process that generates monthly trending tables. I also customized data calculation processes unique for each client in how they processed their general ledger accounts. Finally, I developed a flat-table building process that took SQL views with certain prefixes and created faster-loading SQL tables from that data nightly, recreating indexes and constraints. This provided faster data loading from the data warehouse, only refreshing data nightly.

Online Auction Database

A database model for an online website. Customized their login and password credentials and portfolio table for bidders to set their customization options.

The bidding platform has range indicators for the bidding amount to be increased. The data model supports one too many bids. The table also was set up to allow any customized item to be sold with some key indicator fields setup.

I optimized the database tables using correct foreign keys, indexes, and views. I created multiple stored procedures for the website to call to manage the read, write, insert, and delete functionality.

Database Warehouse and Data Model

A database warehouse designed for an oil and gas service company to collect data and store it in tables I designed based on the customers' needs and data options collected externally.

I worked to isolate certain tables into child tables for better speed and performance where things could be one too many at some point, thereby future-proofing the design.

I created summary tables for data grouping data from the data lake into easier-to-report-off table structures. I optimized other tables that previously existed by setting up an archiving process where millions of rows of data were not leveraged at all by the application but were required to keep stored for audit purposes.

I then set up an automated database process to archive those records regularly. This greatly increased the performance of the queries within the application and allowed indexes to be more effective.

Skillset

Languages

C#, Python, PHP, SQL, T-SQL (Transact-SQL), VB.NET, XML, Visual Basic for Applications (VBA), CSS, HTML, C#.NET, Stored Procedure, Java, SQL DML, Visual Basic .NET (VB.NET), Visual Basic, Python 3, JavaScript, VBScript, Visual Basic 6 (VB6), Active Server Pages (ASP), C++, Object Pascal, Excel VBA, PHP 7, CSS3, HTML5, TypeScript, COBOL, Snowflake

Frameworks

.NET, ASP.NET, .NET Core, Windows PowerShell, AngularJS, Angular, React Native, .NET 4, Bootstrap, Spark, Vue SSR, Selenium, Windows Presentation Foundation (WPF), OAuth 2

Libraries/APIs

React, REST APIs, Node.js, ReactPHP, ODBC, LINQ, Web API, jQuery, Windows Forms (WinForms), Entity Framework, Vue, Beautiful Soup, Office 365 API, G Suite API, Pandas

Tools

Visual Studio, TFS, Jira, Bitbucket, Microsoft Excel, Microsoft Access, Google Sheets, Microsoft Power BI, Power Pivot, Tableau, Sitefinity, Git, GitLab, RabbitMQ, Google Analytics, Query Plan, Crystal Reports, Power Query, Microsoft Power Apps, Wix, SolarWinds, NGINX, G Suite, GitHub, ChatGPT

Paradigms

REST, Business Intelligence (BI), ETL, Requirements Analysis, DevOps, Database Design, Agile, Application Architecture, Management, Data Science, Design Patterns, Web Architecture, Web Application Architecture, Object-oriented Programming (OOP), Testing, ETL Implementation & Design, Automation, Manual Testing, Test Automation, Server-side Programming, Desktop App Development, Functional Programming, Microservices, Model View Controller (MVC), Search Engine Optimization (SEO), Unit Testing, Lambda Architecture

Platforms

Azure, Windows, Visual Studio 2016, Windows Server, Microsoft, Visual Studio Code (VS Code), Oracle, Azure Functions, Telerik, WordPress, Amazon Web Services (AWS), Oracle Database, AWS Lambda, SharePoint, Magento, Databricks, Shopify, Docker, Amazon EC2, Linux

Storage

SQL Server Management Studio (SSMS), MySQL, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Stored Procedures, Relational Databases, Data Pipelines, PL/SQL, Database Architecture, Databases, Database Modeling, SQL Views, API Databases, DB, Data Integration, SQL Performance, Database Migration, Data Synchronization, SQL Architecture, Data Lakes, Oracle PL/SQL, PL/SQL Developer, JSON, SQL Server Reporting Services (SSRS), SQL Server 2016, Database Administration (DBA), Microsoft DBA, Database Lifecycle Management (DLM), Azure Cloud Services, WP Engine, PostgreSQL, Elasticsearch, Database Scripting

Industry Expertise

Project Management

Other

Data Warehouse Design, IIS, Web Services, Windows Services, WCF Web Services, Ajax, Back-end Development, Front-end Development, OOP Designs, Data Analytics, Data Engineering, Query Optimization, Data Warehousing, Back-end, Analytics, Data Architecture, Software Design, Web Development, Architecture, Full-stack, Leadership, Relational Database Design, Reports, Database Optimization, Data Entry, Database Schema Design, Relational Database Services (RDS), Datasets, Data Analysis, Data Cleansing, Data Profiling, Technical Leadership, Software Architecture, API Integration, Team Leadership, Reporting, Data Transformation, Data Queries, ELT, Data Migration, Data Extraction, Entity Relationships, ETL Tools, ETL Pipelines, Big Data, Cloud, Dashboards, Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Minimum Viable Product (MVP), Microsoft 365, Optimization, ETL Development, ETL Testing, Integration, Software Development Lifecycle (SDLC), Full-stack Development, Web Project Management, IT Project Management, Landing Pages, QA Testing, Documentation, Quality Assurance (QA), User Interface (UI), Front-end, CSV File Processing, Data Matching, Excel 365, Warehouses, Data Reporting, Data Quality, Release Management, Code Review, API Testing, Linked Servers, APIs, DevExpress, Windows Communication Foundation (WCF), Data Modeling, Amazon RDS, Performance Tuning, Data Visualization, User Experience (UX), Prototyping, Server-side Rendering (SSR), Training, Google Tag Manager, Office 365, CRM APIs, Big Data Architecture, DAX, eCommerce, Dashboard Design, Weebly, Data Scraping, Scraping, RESTful Services, RESTful Web Services, QA Automation, Web Scraping, Web Analytics, SEO Tools, Technical SEO, UI Automation, Workflow Automation, Algorithms, Web Dashboards, Microsoft Azure, Azure Data Lake, Site Reliability Engineering (SRE), Lambda Functions, Serverless, Networking, IT Security, Google Ads, DocuSign, CI/CD Pipelines, DataFrames, Website Data Scraping

Education

1997 - 2001

Bachelor's Degree in Computer Science

Minnesota State University Moorhead - Moorhead, Minnesota, United States

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.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

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