Kevin is available for hire

Kevin Saul

Verified Expert in Engineering

数据工程师和软件开发人员

Location

Salida, CO, United States

Toptal Member Since

December 12, 2022

Kevin是一名高级数据工程师和专业服务顾问，为大型复杂数据存储提供软件解决方案, integration, analysis, and reporting. 他有22年的开发经验, delivering, 并为环境和生物技术行业提供以数据为中心的软件解决方案和8年的分析化学经验. 他对开发可持续农业和土地复垦的创新解决方案特别感兴趣.

Data Analysis Data Analytics Data Visualization Analytics Data Engineering Data Migration Data Queries Data Reporting Data Warehouse Design SQL ETL SQL Stored Procedures SQL Performance Microsoft SQL Server Data Integration Data Transformation Power Query Data Validation Azure Event Hub

Portfolio

Ecological Data Services

农业科技、生态、大数据、GIS、SQL、数据库架构、Azure、DB...

Dimension Hospitality, LLC

Microsoft SQL Server，数据工程，数据迁移，财务，SQL...

黑骑士(以前的最佳蓝)

金融科技，敏捷，Azure事件中心，Azure数据湖，Azure数据库...

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

Part-time

Preferred Environment

Azure, Data Analytics, Business Intelligence (BI), Data Engineering, Azure Synapse, Azure Databricks, Azure Data Factory, ETL, Data Warehouse Design, Azure PaaS, Microsoft SQL Server

The most amazing...

...我做了一个交易量很大的金融指数，纽交所和美联储都用它来为抵押贷款利率分析师提供领先指标.

Work Experience

Owner and Principal Consultant

2022 - PRESENT

Ecological Data Services

为一家批发分销公司提供Dynamix 365数据集成解决方案.
为一个学区举办了为期两周的Microsoft Power BI实施研讨会.
为某房地产管理公司进行为期两周的Microsoft Power BI绩效评估. 设计的数据源和网关性能增强.
提交了一份美国农业部食品和农业系统数据科学(DSFAS)项目的拨款提案.
开发互操作性解决方案，以新的开源格式使用和生成土壤健康数据，用于环境和农业评估. 参与农业数据共享和隐私保护的开源项目.

Technologies: 农业科技、生态、大数据、GIS、SQL、数据库架构、Azure、DB, Data Engineering, Dashboards, Analytics, Data Visualization, Data Analytics, Business Intelligence (BI), Data Validation, Data Analysis, Operations, Databases, Database Design, Relational Databases, SQL Server BI, Windows PowerShell, Python 3, PySpark, Data Migration, Finance, Office 365, CSV File Processing, Excel 365, Jupyter Notebook, Python, Synapse, DAX, Power Query, MySQL, Database Administration (DBA), Data Architecture, SQL Performance, Data Queries, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Microsoft Azure, Data Transformation, Azure Synapse, Data Reporting, Windows, Research & Critical Thinking, Technical Writing, Communication, Databricks, Agile, Azure SQL, Azure Event Hubs, Azure Data Lake, Azure Data Factory, Data Warehouse Design, Indexing, Partitioning, Data Pipelines, Azure PaaS, Azure Stream Analytics, SQL Server 2017, Cost Estimation, Professional Services, Custom Reports, Data Integration, Microsoft Access, Azure SQL Data Warehouse, Azure Table Storage, Data Science, Data Structures, Database Schema Design, Database Security, Microsoft SQL Server, Query Optimization, C#, .NET

MSSQL数据工程师|数据迁移

2023 - 2023

Dimension Hospitality, LLC

为会计系统协同开发迁移计划.
完成数据迁移任务，跟踪迁移状态，报告和研究错误.
应用修改后的规则来纠正迁移错误.

技术:Microsoft SQL Server，数据工程，数据迁移，财务，SQL, Data Architecture, SQL Performance, Data Queries, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Microsoft Azure, Data Transformation, Data Reporting, Windows, Research & Critical Thinking, Technical Writing, Communication, Azure SQL, Partitioning, SQL Server 2017, Custom Reports, Data Integration, Data Structures, Database Schema Design, Database Security, Query Optimization

Senior Data Engineer

2018 - 2022

黑骑士(以前的最佳蓝)

担任Optimal Blue商业智能团队的数据工程师, 与产品经理和团队成员合作，为抵押贷款发起人和二级市场投资者设计和交付商业智能仪表板产品.
开发了用于实时收集和分析抵押保险报价的事件流处理.
提供关于贷款发放工作流程的数据驱动的见解, investor hedging performance, competitive market analysis, 和抵押贷款保险报价比较.
为Optimal Blue的公开抵押贷款市场指数(OBMMI)自动交付汇总利率锁定数据.
根据客户影响和价值，使用敏捷和Scrum方法对产品特性和缺陷解决方案进行优先级排序.
交付基于云的软件产品, product enhancements, 以及使用持续集成和交付(CI/CD)方法修复错误.

Technologies: 金融科技，敏捷，Azure事件中心，Azure数据湖，Azure数据库, Azure Data Factory, Azure Functions, Scala, Data Warehouse Design, ETL, C#.NET, SQL Stored Procedures, SQL Performance, Indexing, Partitioning, Big Data, Data Lakes, Unstructured Data Analysis, Microsoft Power BI, SQL Server集成服务(SSIS), Data Pipelines, Azure PaaS, Azure Stream Analytics, Azure Analysis Services, Database Architecture, Azure, DB, Data Engineering, Dashboards, Analytics, Data Visualization, Data Analytics, Business Intelligence (BI), Data Validation, Data Analysis, Operations, Databases, Database Design, Relational Databases, SQL Server BI, Windows PowerShell, Python 3, PySpark, APIs, Data Migration, Finance, Office 365, CSV File Processing, Excel 365, Jupyter Notebook, Python, Synapse, DAX, Power Query, Database Administration (DBA), PostgreSQL, MongoDB, SQL, Data Architecture, Data Queries, Azure Cosmos DB, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Microsoft Azure, Data Transformation, Azure Synapse, Data Reporting, Data Science, Windows, Research & Critical Thinking, Technical Writing, Communication, Databricks, Azure SQL, SQL Server 2017, Cost Estimation, Custom Reports, Data Integration, Azure SQL Data Warehouse, Azure Table Storage, Data Structures, Database Schema Design, Database Security, Microsoft SQL Server, Query Optimization, .NET, C#

Solutions Architecture Consultant

2012 - 2018

Dell

领导实施K-12学区的数据仓库和报告框架.
在Azure中为基于云的数据仓库解决方案提供资源，该解决方案使用了软件即服务(使用SQL Azure和Power BI)和基础设施即服务(用于SSIS和SSAS)的组合.
开发ETL (SSIS)包，用于集成多个学生数据源并清理和转换数据，以确保准确和一致的报告.
创建SSAS表格模型，以优化和标准化数据分析和报告.
开发和部署Power BI报告和仪表板，以支持学生成功的管理和教育决策.
领导一家500强软件公司的报告和可视化计划. 记录需求并开发操作和执行仪表板报告的技术规范.
确定趋势并建议数据可视化，以最好地支持执行监督和操作改进.
为多个客户执行数据现代化评估. 介绍了SQL 2016、APS和Power BI的新特性并进行了演示.
为不同行业的客户提供Microsoft Power BI概念验证仪表板.
为一家健康保险公司执行SQL Server到Microsoft并行数据仓库的转换.

Technologies: SQL, Microsoft SQL Server, SQL Server集成服务(SSIS), Microsoft Power BI, SQL Server分析服务(SSAS), SQL Server 2017, SQL Server 2014, SQL Server 2015, SQL Server 2008, Database Architecture, Azure, DB, Data Engineering, Dashboards, Analytics, Data Visualization, Data Analytics, Business Intelligence (BI), Data Validation, Data Analysis, Operations, Databases, Database Design, Relational Databases, SQL Server BI, Windows PowerShell, APIs, Data Migration, Finance, CSV File Processing, Excel 365, ETL, DAX, Database Administration (DBA), Data Architecture, SQL Performance, Data Queries, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Microsoft Azure, Data Transformation, Visual Basic for Applications (VBA), Excel VBA, Data Reporting, Windows, Research & Critical Thinking, Technical Writing, Communication, Agile, Azure SQL, Data Warehouse Design, Indexing, Partitioning, Data Pipelines, Azure PaaS, SQL Server报表服务(SSRS), Cost Estimation, Professional Services, Custom Reports, Data Integration, Azure SQL Data Warehouse, Azure Table Storage, Data Structures, Database Schema Design, Database Security, Query Optimization, C#, .NET

Business Intelligence Architect

2011 - 2012

Intersys Consulting

为AMD企业数据仓库设计并实施业务分析和数据可视化解决方案, sales, and finance departments.
Consulted on project requirements, determined the best solution, provided accurate time estimates, executed projects on time, 并且交付了超出业务合作伙伴期望的解决方案.
Designed, developed, deployed, 并支持使用SQL Server Analysis Services的生产企业解决方案, SQL Server Integration Services, and SQL Server Reporting Services.
使用先进的数据可视化和移动商业智能的新软件平台评估和开发原型解决方案.

技术:SQL Server分析服务(SSAS), SQL Server报表服务(SSRS), SQL Server集成服务(SSIS), Database Architecture, DB, Data Engineering, Dashboards, Analytics, Data Visualization, Data Analytics, Business Intelligence (BI), Data Validation, Data Analysis, Operations, Databases, Database Design, Relational Databases, SQL Server BI, APIs, Data Migration, CSV File Processing, ETL, Database Administration (DBA), SQL, Data Architecture, SQL Performance, Data Queries, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Data Transformation, Visual Basic for Applications (VBA), Excel VBA, Data Reporting, Windows, Research & Critical Thinking, Technical Writing, Communication, Data Warehouse Design, Indexing, Partitioning, SQL Server 2017, SQL Server 2008, Cost Estimation, Professional Services, Custom Reports, Data Integration, Azure SQL Data Warehouse, Tableau, Data Structures, Database Schema Design, Database Security, Microsoft SQL Server, Query Optimization, .NET

Senior Solutions Engineer

2008 - 2011

Inquisite

为企业反馈管理产品套件交付自定义分析报告和数据集成解决方案.
为工作报表创建成本估算. 设计、开发、部署和支持定制解决方案. 交付SASS和内部部署解决方案.
对潜在客户进行售前发现和业务分析咨询.

Technologies: Cost Estimation, Professional Services, Custom Reports, Database Architecture, DB, Data Engineering, Dashboards, Analytics, Data Visualization, Data Analytics, Business Intelligence (BI), Data Validation, Data Analysis, Operations, Databases, Database Design, Relational Databases, SQL Server BI, APIs, Data Migration, CSV File Processing, ETL, Database Administration (DBA), SQL, Data Architecture, SQL Performance, Data Queries, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Data Transformation, Visual Basic for Applications (VBA), Excel VBA, Data Reporting, Windows, Research & Critical Thinking, Technical Writing, Communication, Indexing, Partitioning, SQL Server 2017, SQL Server 2008, SQL Server报表服务(SSRS), Data Integration, Data Structures, Database Schema Design, Database Security, Microsoft SQL Server, Query Optimization, C#, .NET

Lead Software Developer

2002 - 2008

State Bar of Texas

通过第三方邮寄服务管理年度州律师费和占用税报表的制作和支付数据的处理.
将司法投票处理应用程序从Access数据库升级到SQL Server 2000数据库，并创建存储过程，以提高投票处理的性能和可靠性.
Performed general DBA functions, 例如设置数据库备份和维护计划, tuning indexes, setting permissions, restoring data, 以及排除性能问题.

技术:Microsoft SQL Server, ColdFusion, Custom Reports, Data Integration, Database Architecture, DB, Data Engineering, Data Analytics, Business Intelligence (BI), Data Validation, Data Analysis, Databases, Database Design, Relational Databases, APIs, Data Migration, CSV File Processing, ETL, Database Administration (DBA), SQL, Data Architecture, SQL Performance, Data Queries, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Visual Basic for Applications (VBA), Excel VBA, Data Reporting, Windows, Research & Critical Thinking, Technical Writing, Communication, Indexing, SQL Server 2008, SQL Server报表服务(SSRS), Data Structures, Database Schema Design, Database Security, Query Optimization, C#, .NET

Consultant

2000 - 2002

Catapult Systems

与顾问团队一起分析需求和设计, develop, and deploy data-driven websites.
使用T-SQL和Microsoft Access开发新功能并改进现有系统，用于处理和跟踪律师职业税的支付, membership dues payments, and journal subscriptions.
修改了内部时间报告应用程序，增加了新的自定义特性.

技术:SQL, Visual Basic 6 (VB6)， Visual Basic .NET (VB.NET), Microsoft Access, Database Architecture, DB, Data Engineering, Data Analytics, Data Analysis, Operations, Databases, Database Design, Relational Databases, APIs, Data Migration, CSV File Processing, ETL, Database Administration (DBA), Oracle Database, Data Architecture, Data Queries, Architecture, T-SQL (Transact-SQL), SQL DML, Performance Tuning, Microsoft Excel, Data Reporting, Windows, Research & Critical Thinking, Technical Writing, Communication, Indexing, Custom Reports, Data Integration, Data Structures, Database Schema Design, Database Security, Microsoft SQL Server, Query Optimization

Scientist

1995 - 2000

CEDRA

领导实验室信息管理系统(LIMS)的设计和实施，自动化收集和报告与临床试验相关的药物分析数据.
开发自定义Microsoft Access应用程序，自动输入实验室仪器数据并生成药物分析报告.
为制药公司进行质谱和高效液相色谱分析的数据管理和质量保证审查.

技术:实验室信息管理系统(LIMS), GC Mass Spectrometry, Organic Chemistry, Linear Regression, Clinical Trials, 高效液相色谱法(HPLC), DB, Data Analysis, Databases, CSV File Processing, Oracle Database, Microsoft Excel, Windows, Science, Research & 批判性思维，技术写作，沟通，微软访问

Environmental Coordinator

1994 - 1995

Lower Colorado River Authority

使用质谱法对饮用水进行挥发性有机化合物和农药的环境分析, gas chromatography, 以及高效液相色谱法.
确保样品接收和准备的监管链.
对实验室报告数据进行质量审查和解释.

技术:气相色谱质谱, 高效液相色谱法(HPLC), Organic Chemistry, Environment, Data Analysis, Databases, Microsoft Excel, Science, Research & 批判性思维，沟通，微软访问

Research Scientist

1990 - 1994

Southwest Research Institute

使用气相色谱法和质谱法对约翰斯顿环礁上一个废弃化学武器处置项目进行环境分析.
在严格的军事许可和安全协议下进行工作.
将实验室结果传达给JACADS工厂操作员和美国陆军监督小组.

技术:有机化学，气相色谱质谱，环境，数据分析，科学，研究 & Critical Thinking, Communication

Experience

最佳蓝色抵押贷款市场指数

http://www2.optimalblue.com/obmmi/

最佳蓝色抵押贷款市场指数(OBMMI)提供了最全面的, accurate, timely, 以及在抵押贷款行业中进行的交互式定价分析. 根据全国35%的抵押贷款交易中消费者的实际锁定利率计算, OBMMI包括围绕最流行的抵押贷款产品和特定借款人属性开发的多个抵押贷款定价指数，以提供随时间变化的可配置趋势利率.

德克萨斯州黑土地草原作物产量

http://www.ecodataservices.com/2023/01/Texas-Blackland-Prairie-Crop-Yields/

这个项目演示了使用Python笔记本和微软的行星计算机来访问大型地球科学数据集, 例如网格化国家土壤调查地理数据库, 并在Power BI中可视化数据.

Education

1985 - 1989

生物学或经济学学士学位

美国圣安东尼奥三一大学

Certifications

JANUARY 2024 - PRESENT

微软认证:Azure数据工程师助理

Microsoft

DECEMBER 2016 - PRESENT

微软认证解决方案专家:数据管理和分析宪章成员

Microsoft

DECEMBER 2014 - PRESENT

微软认证解决方案开发人员

Microsoft

Skills

Libraries/APIs

PySpark, Azure Blob Storage API

Tools

Microsoft Power BI, SQL Server BI, Microsoft Excel, Synapse, Power Query, GIS, Microsoft Access, Tableau

Languages

SQL, T-SQL (Transact-SQL)， SQL DML, Scala, c#.. NET, Python, Visual Basic for Applications (VBA)， Excel VBA, c#， Visual Basic 6 (VB6)， Visual Basic .NET (VB.NET), Python 3

Platforms

Azure, Windows, Databricks, Azure Event Hubs, Azure Functions, Azure PaaS, Jupyter Notebook, Azure Synapse, Oracle Database, Azure Synapse Analytics, Azure SQL Data Warehouse, 专用SQL池(以前称为SQL DW)

Paradigms

ETL，商业智能(BI)，数据库设计，敏捷，数据科学

Storage

Azure SQL, SQL Stored Procedures, SQL Performance, Microsoft SQL Server, SQL Server分析服务(SSAS), SQL Server 2017, SQL Server 2014, SQL Server 2008, Data Integration, DB, Database Architecture, Databases, Relational Databases, Database Administration (DBA), Database Security, Data Lakes, Data Pipelines, SQL Server报表服务(SSRS), Data Validation, SQL Server集成服务(SSIS), MySQL, PostgreSQL, MongoDB, Azure Cosmos DB, Azure Table Storage

Frameworks

.NET, 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, Data Queries, Performance Tuning, Microsoft Azure, Data Transformation, Data Reporting, Data Structures, Database Schema Design, Query Optimization, 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, Architecture, Economic Analysis, Technical Writing, Communication, Big Data, Fintech, ColdFusion, 实验室信息管理系统(LIMS), GC Mass Spectrometry, Linear Regression, Clinical Trials, 高效液相色谱法(HPLC), Big Data Architecture

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.

Top talent is in high demand.

Start hiring