Tim is available for hire
Hire TimTim Langseth
Verified Expert in Engineering
Database Developer
Hawley, MN, United States
Toptal member since October 28, 2022
Bio
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
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, Web App Development, Agile Software Development, Data Structures, Startups, Advisory, Coaching, Scalability, Process Development, Engineering, Clean Code, IT Projects, Data Strategy, Business Analysis, SharePoint Online, Azure SQL Databases, Database Management, System Administration
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 3rd-party hosting and DNS company support team when servers or services were down, causing client downtime, to resolve the issue as quickly as possible.
- Wrote Python scripts to do data extracting and website scraping from multiple websites, merging data into one data warehouse. Worked through websites that required login credentials, website navigation, and page navigation to collect all listed data.
- 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, Google Workspace, Office 365, Office 365 API, DocuSign, Google Workspace APIs, 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, UI Development, Web App Development, Agile Software Development, Data Structures, PHP 5, Advisory, Coaching, Scalability, Process Development, Engineering, Clean Code, IT Projects, Data Strategy, Business Analysis, Azure Active Directory, SharePoint Online, SharePoint 365, ASP.NET MVC, Entity Framework Core, Azure SQL Databases, Database Management, System Administration, Microsoft Fabric, SSAS
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, UI Development, Web App Development, Agile Software Development, Data Structures, Startups, Advisory, Coaching, Scalability, Process Development, Engineering, Clean Code, IT Projects, Data Strategy, Business Analysis, Azure Active Directory, SharePoint Online, Azure SQL Databases, Database Management, System Administration, SSAS
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, Google Workspace APIs, 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, UI Development, Web App Development, Agile Software Development, Data Structures, PHP 5, Startups, Advisory, Coaching, Scalability, Process Development, Engineering, Clean Code, IT Projects, Data Strategy, Business Analysis, Azure Active Directory, SharePoint Online, ASP.NET MVC, Entity Framework Core, Database Management, System Administration, SSAS
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, UI Development, Web App Development, Agile Software Development, Data Structures, Coaching, Scalability, Process Development, Engineering, Clean Code, IT Projects, Data Strategy, Business Analysis, SharePoint Online, ASP.NET MVC, Entity Framework Core, Database Management, System Administration
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, UI Development, Web App Development, Agile Software Development, Data Structures, Scalability, Process Development, Engineering, Clean Code, IT Projects, Business Analysis, Database Management
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.
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.
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.
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.
Education
1997 - 2001
Bachelor's Degree in Computer Science
Minnesota State University Moorhead - Moorhead, Minnesota, United States
Skills
Libraries/APIs
React, REST APIs, Node.js, ReactPHP, ODBC, LINQ, Web API, jQuery, Windows Forms (WinForms), Entity Framework, Vue, Beautiful Soup, Office 365 API, Google Workspace APIs, Pandas
Tools
Visual Studio, TFS, Jira, Bitbucket, Microsoft Excel, Microsoft Access, Google Sheets, SSAS, Microsoft Power BI, Power Pivot, Tableau, Sitefinity, Git, GitLab, RabbitMQ, Google Analytics, Query Plan, Crystal Reports, Power Query, Microsoft Power Apps, Wix, SolarWinds, NGINX, Google Workspace, GitHub, ChatGPT
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, PHP 5, 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, React Native, Windows PowerShell, AngularJS, Angular, .NET 4, Bootstrap, Spark, Vue SSR, Selenium, ASP.NET MVC, Entity Framework Core, Windows Presentation Foundation (WPF), OAuth 2
Paradigms
REST, Business Intelligence (BI), ETL, Requirements Analysis, DevOps, Database Design, Agile, Application Architecture, Management, Design Patterns, Web Architecture, Web Application Architecture, Object-oriented Programming (OOP), Testing, ETL Implementation & Design, Automation, Manual Testing, Test Automation, Server-side Programming, Agile Software Development, Clean Code, 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, SharePoint 365, Microsoft Fabric, Docker, Amazon EC2, Linux, Google Ads
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, Azure SQL Databases, Database Management, 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, Azure Active Directory, 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, Data Science, ETL Pipelines, Big Data, Cloud, Dashboards, Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Web Applications, Minimum Viable Product (MVP), Data Scraping, 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, Web Scraping, Data Quality, Release Management, Code Review, API Testing, Web App Development, Data Structures, Startups, Advisory, Coaching, Scalability, Process Development, Engineering, IT Projects, Data Strategy, Business Analysis, System Administration, 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, Scraping, RESTful Services, RESTful Web Services, QA Automation, Web Analytics, SEO Tools, Technical SEO, UI Automation, Workflow Automation, Algorithms, Web Dashboards, Microsoft Azure, UI Development, SharePoint Online, Azure Data Lake, Site Reliability Engineering (SRE), Lambda Functions, Serverless, Networking, IT Security, DocuSign, CI/CD Pipelines, DataFrames, Website Data Scraping
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