Kevin Saul
Verified Expert in Engineering
Data Engineer and Software Developer
Salida, CO, United States
Toptal member since December 12, 2022
Kevin is a senior data engineer and professional services consultant providing software solutions for large and complex data storage, integration, analysis, and reporting. He has 22 years of experience developing, delivering, and maintaining data-centric software solutions and eight years of experience in analytical chemistry. He has experience consulting with a variety of industries, including finance, education, logistics, retail, agriculture, and environmental research.
Portfolio
Experience
- SQL Performance - 20 years
- Data Analysis - 20 years
- Data Warehouse Design - 12 years
- Ecology - 6 years
- Azure SQL - 6 years
- Microsoft Power BI - 5 years
- Azure Databricks - 3 years
- Azure Data Factory - 2 years
Availability
Preferred Environment
Azure, Business Intelligence (BI), Data Engineering, Azure Synapse, Azure Databricks, Azure Data Factory, ETL, Data Warehouse Design, Microsoft SQL Server, Power BI Embedded
The most amazing...
...thing I've made is a high-volume financial index used by the NYSE and the Federal Reserve to provide mortgage-rate analysts with leading indicators.
Work Experience
Owner and Principal Consultant
Ecological Data Services
- Delivered Dynamix 365 data integration solutions for a wholesale distribution company.
- Conducted a 2-week Microsoft Power BI implementation workshop for a school district.
- Conducted a 2-week Microsoft Power BI performance assessment for a real estate management company. Designed data source and gateway performance enhancements.
- Submitted a grant proposal for USDA's Data Science for Food and Agricultural Systems (DSFAS) program.
- Developed interoperability solutions to consume and produce soil health data in a new open-source format for environmental and agricultural assessments. Contributed to open-source projects for agricultural data-sharing and privacy protection.
- Provided data engineering consulting services to an animal health software product company. Worked directly with the owner and technical team to refactor SQL server data access procedures to improve the performance of complex reporting processes.
- Collaborated with owners of a commercial electric system developer to define requirements, design, and deliver a custom inventory and project management solution.
- Designed and delivered MS Azure Synapse Analytics data pipelines, SQL server data model, and interactive Power BI dashboards for analysis of math assessment scores for a state university.
- Developed a custom project management application for a commercial electric installation company.
- Consulted on re-architecture and performance optimization of back-end (MS SQL Server) processes for a zoo and aquarium software product.
MSSQL Data Engineer | Data Migration
Dimension Hospitality, LLC
- Developed the migration plan collaboratively for the accounting system.
- Completed data migration tasks, tracked migration status, and reported and researched errors.
- Applied modified rules to correct migration errors.
Senior Data Engineer
Black Knight (previously Optimal Blue)
- Acted as a data engineer with Optimal Blue's business intelligence team, working with product managers and team members to design and deliver business intelligence dashboard products for mortgage loan originators and secondary market investors.
- Developed event-stream processing for real-time collection and analysis of mortgage insurance quotes.
- Provided data-driven insights on loan origination workflows, investor hedging performance, competitive market analysis, and mortgage insurance quote comparisons.
- Automated delivery of aggregated rate-lock data for Optimal Blue's publicly available Mortgage Market Index (OBMMI).
- Used Agile and Scrum methodologies to prioritize product features and defect resolutions based on customer impact and value.
- Delivered cloud-based software products, product enhancements, and bug fixes using continuous integration and delivery (CI/CD) methods.
Solutions Architecture Consultant
Dell
- Led the implementation of a data warehousing and reporting framework for a K-12 school district.
- Provisioned resources in Azure for a cloud-based data warehouse solution that used a combination of software as a service using SQL Azure and Power BI and infrastructure as a service for SSIS and SSAS.
- Developed ETL (SSIS) packages for integrating multiple student data sources and cleaning and transforming data to ensure accurate and consistent reporting.
- Created an SSAS tabular model to optimize and standardize data analysis and reporting.
- Developed and deployed Power BI reports and dashboards to support administrative and educational decisions for student success.
- Led reporting and visualization initiatives for a top-500 software company. Documented requirements and developed technical specifications for operational and executive dashboard reporting.
- Identified trends and recommended data visualizations to best support executive oversight and operational improvements.
- Performed data modernization assessments for multiple customers. Presented new features and conducted demonstrations of SQL 2016, APS, and Power BI.
- Delivered Microsoft Power BI proof of concept dashboards for customers in various industries.
- Performed SQL Server to Microsoft Parallel Data Warehouse conversion for a health insurance company.
Business Intelligence Architect
Intersys Consulting
- Designed and implemented business analytics and data visualization solutions for AMD enterprise data warehouse for marketing, sales, and finance departments.
- Consulted on project requirements, determined the best solution, provided accurate time estimates, executed projects on time, and delivered solutions that exceeded business partner expectations.
- Designed, developed, deployed, and supported production enterprise solutions using SQL Server Analysis Services, SQL Server Integration Services, and SQL Server Reporting Services.
- Evaluated and developed prototype solutions using new software platforms for advanced data visualization and mobile business intelligence.
Senior Solutions Engineer
Inquisite
- Delivered custom analytical reporting and data integration solutions for an enterprise feedback management suite of products.
- Created cost estimation for statements of work. Designed, developed, deployed, and supported custom solutions. Delivered SASS and on-premise solutions.
- Conducted presales discovery and business analysis consultation with prospective clients.
Lead Software Developer
State Bar of Texas
- Managed the production of annual state bar dues and occupation tax statements with third-party mailing service and processing of payment data.
- Upgraded the judicial poll ballot processing application from an Access database to a SQL Server 2000 database and created stored procedures to improve the performance and reliability of ballot processing.
- Performed general DBA functions, such as setting up database backups and maintenance plans, tuning indexes, setting permissions, restoring data, and troubleshooting performance issues.
Consultant
Catapult Systems
- Worked with a team of consultants to analyze requirements and design, develop, and deploy data-driven websites.
- Developed new functionality and improved existing systems using T-SQL and Microsoft Access for the processing and tracking attorney occupational tax payments, membership dues payments, and journal subscriptions.
- Revised in-house time reporting application to add new custom features.
Scientist
CEDRA
- Led the design and implementation of a laboratory information management system (LIMS) to automate the collection and reporting of pharmaceutical analysis data related to clinical trials.
- Developed a custom Microsoft Access application to automate the entry of laboratory instrument data and generate reports for pharmaceutical analysis.
- Performed data management and quality assurance reviews of mass spectrometry and high-performance liquid chromatography analyses for pharmaceutical companies.
Environmental Coordinator
Lower Colorado River Authority
- Performed environmental analysis of drinking water for volatile organic compounds and pesticides using mass spectrometry, gas chromatography, and high-performance liquid chromatography methods.
- Ensured chain of custody in sample receipt and preparation.
- Performed quality reviews of laboratory report data and interpretations.
Research Scientist
Southwest Research Institute
- Performed environmental analysis using gas chromatography and mass spectrometry for environmental monitoring of an obsolete chemical weapons disposal program on Johnston Atoll.
- Conducted work under strict military clearance and safety protocols.
- Communicated laboratory results to JACADS plant operators and US Army oversight teams.
Experience
Optimal Blue Mortgage Market Index
https://www2.optimalblue.com/obmmi/Texas Blackland Prairie Crop Yields
https://www.ecodataservices.com/2023/01/Texas-Blackland-Prairie-Crop-Yields/USDA-NIFA Award Distributions
https://www.ecodataservices.com/2024/02/USDA-NIFA-2022-and-2023-Awards/API Paging in Power BI with iNaturalist Data
https://www.ecodataservices.com/2024/11/iNaturalist-Observations-PowerBI-API-Paging/iNaturalist Data Source to MS Fabric Data Lakehouse
https://www.ecodataservices.com/2024/11/iNaturalist-Datasource-to-MS-Fabric-Data-Lakehouse/Education
Bachelor's Degree in Biology and Economics
Trinity University - San Antonio, USA
Certifications
Microsoft Certified: Azure Data Engineer Associate
Microsoft
Microsoft Certified Solutions Expert: Data Management and Analytics Charter Member
Microsoft
Microsoft Certified Solution Developer
Microsoft
Skills
Libraries/APIs
PySpark, Azure Blob Storage API
Tools
Microsoft Power BI, SQL Server BI, Microsoft Excel, Power BI Embedded, Synapse, Power Query, GIS, Microsoft Access, Tableau, Looker
Languages
SQL, T-SQL (Transact-SQL), SQL DML, Scala, C#.NET, Python, Visual Basic for Applications (VBA), Excel VBA, C#, Visual Basic, Visual Basic 6 (VB6), Visual Basic .NET (VB.NET), Python 3, Snowflake, Power Query M
Paradigms
ETL, Business Intelligence (BI), Database Design, UI Design, Agile
Platforms
Azure, Windows, Databricks, Azure Event Hubs, Azure Functions, Azure PaaS, Jupyter Notebook, Azure Synapse, Microsoft Fabric, Adobe ColdFusion, Oracle Database, Azure Synapse Analytics, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Oracle, Amazon Web Services (AWS), Salesforce
Storage
Azure SQL, SQL Stored Procedures, SQL Performance, Data Pipelines, Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server 2017, SQL Server 2014, SQL Server 2008, Data Integration, DB, Database Architecture, Databases, Relational Databases, Database Administration (DBA), Database Security, Database Performance, SQL Server 2016, Data Lakes, SQL Server Reporting Services (SSRS), Data Validation, SQL Server Integration Services (SSIS), MySQL, PostgreSQL, MongoDB, Azure Cosmos DB, Azure Table Storage, NoSQL
Frameworks
.NET, Spark, Windows PowerShell
Other
Azure Analysis Services, Azure Databricks, Azure Data Factory, Data Warehouse Design, SQL Server 2015, Data Analysis, Data Analytics, Data Visualization, Analytics, Dashboards, Data Engineering, Data Migration, CSV File Processing, Data Architecture, Architecture, Data Queries, Performance Tuning, Microsoft Azure, Data Transformation, Data Reporting, Data Structures, Database Schema Design, Query Optimization, Data Modeling, Business Analysis, Business Requirements, Stakeholder Management, API Integration, Data Warehousing, Data Strategy, Exploratory Data Analysis, Data Governance, Data Management, Dashboard Design, Web Dashboards, Excel Dashboards, Data Auditing, Science, Research & Critical Thinking, Agrotech, Ecology, Azure Data Lake, Indexing, Partitioning, Unstructured Data Analysis, Azure Stream Analytics, Cost Estimation, Professional Services, Custom Reports, Organic Chemistry, Environment, Operations, APIs, Finance, Office 365, Excel 365, DAX, Data Monetization, Excel Macros, SFTP, Product Analytics, Economic Analysis, Technical Writing, Communication, Big Data, Fintech, Laboratory Information Management System (LIMS), GC Mass Spectrometry, Linear Regression, Clinical Trials, High-performance Liquid Chromatography (HPLC), Big Data Architecture, Data Science, SAP ERP
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
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring