# Robert Mills

Robert Mills is a remote worker on Himalayas, Data Architect / Conversion Architect at Database Design Arts LLC / Astreax, based in United States.

Source: https://himalayas.app/@robertmills

```text
Data Architect at Database Design Arts LLC / Astreax, building Fabric data pipelines and conversion frameworks.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 180k+ USD |
| Job categories | Data Architect, Data Engineer, Database Architect, Business Intelligence Architect, Database Administrator, Reporting Consultant |
| Skills | Data Architecture, Data Engineering, Data Conversion, Data Warehouse, Data Quality, Data Governance, ETL, Microsoft Fabric, SQL Server, T SQL, Azure Data Factory, SSIS, SSRS, Azure SQL, SQL Server High Availability Techniques |
| Portfolio | https://github.com/RCMills/WorkExamples |
| LinkedIn | https://linkedin.com/in/robert-mills-b783831 |

## About

```text
At Database Design Arts LLC / Astreax, I designed a data conversion framework for the Astreax accident reporting platform and built the process that keeps the ADOT accident reporting data mart current with source-system changes. I also developed Microsoft Fabric medallion models and pipelines for data conversion and reporting.

At ISAGENIX INTERNATIONAL, LLC, I architected the data platform for Isanet and scaled its data architecture to support 20%+ year-over-year business growth. I also designed the Will Call process with business stakeholders, reducing customer wait times by 95%.
```

## Experience

### Data Architect / Conversion Architect (current)

Database Design Arts LLC / Astreax. Jun 2023 - Present

```text
Designed the data conversion framework for the Astreax accident reporting platform, enabling migration into the existing reporting data mart. Implemented tSQLt based data quality testing and developed Microsoft Fabric medallion models to support data conversion and downstream reporting.
```

Skills: T-SQL, Microsoft-Purview, Microsoft-Fabric, Data-Pipelines, Data-Lake, Delta-Tables, SQL-Databases, Notebooks, Great-Expectations, Python, scikit-learn, VSCode, GitHub-Co-Pilot

### Data Architect

ARMLS / THEMARKT. Oct 2017 - Apr 2023

```text
Built a custom accounting platform aligned with GAAP accounting rules and strengthened SQL Server security by implementing Microsoft best practices. Established data governance policies and standardized T-SQL development by creating coding standards.
```

Skills: SQL-Server, T-SQL, SSIS, SSRS, MDS, HADR, Azure-SQL, Data-Factory, Key-Vaults, Blob-Storage, MS-Fabric, Power-Query, Notebooks, Data-Lake, Data-Warehouse, VSCode, GitHub-Co-Pilot, Azure-DevOps, Microsoft-Purview, Docker, Jupyter-Notebooks, .NET-Core, Blazor, xUnit, MySQL, GitHub, Visual-Studio, Great-Expectations, MongoDB, Dapper, Newtonsoft.Json, AutoMapper, Agile, Scrum

### SQL Server DBA - Data Warehouse Consultant

3RP Solutions (Sub-Contractor) / TriWest Healthcare Alliance. Feb 2017 - Oct 2017

```text
Guided enterprise SDLC adoption through Agile process consulting and improved developer performance through T-SQL tuning training. Implemented SSIS ETL solutions using CDC for the data warehouse and automated SSIS package development through BIML authoring.
```

Skills: Agile, T-SQL, SQL-Server, SSIS, ETL, CDC, BIML, VS-2015

### Reporting Consultant

Sharp Consulting / On-Semiconductor. Sep 2016 - Feb 2017

```text
Delivered BI solutions for the Finance team and improved the existing data warehouse through solution consulting.
```

Skills: BIツール, Data-Warehouse

### BI Architect

Valore Partners (Sub-Contractor). Jan 2016 - May 2016

```text
Designed the BI solution's logical and physical architecture and accelerated team implementation by mentoring the on-site team on design execution and maintenance. Deployed the SQL Server 2014/2016 suite, including SQL Engine, SSRS, SSAS, and SSIS, and launched a Power BI pilot program.
```

Skills: SQL-Server-2014, SQL-Server-2016, SSRS, SSAS, SSIS, Power-BI

### Senior Director / Data Architect

ISAGENIX INTERNATIONAL, LLC. May 2006 - Nov 2015

```text
Architected the data platform for Isanet, the company's core line-of-business system, and scaled the data architecture to support 20%+ year-over-year business growth. Designed and implemented the compensation plan in T-SQL and established SSRS reporting across all compensation-plan functions.
```

Skills: T-SQL, SSRS, SQL-Server-2005, SQL-Server-2008, SQL-Server-2012, SQL-Server-2014, Microsoft-BI, Redgate, Team-Foundation-Services-(TFS), High-Availability, Disaster-Recovery, AlwaysOn-Availability-Groups, Partitioning, ETL, PCI-Compliance

## Education

### Massachusetts Institute of Technology

Certificate, Data Engineering

```text
Completed a Data Engineering certificate program through MIT Emeritus.
```

### Microsoft

Certificate, Data Engineering

```text
Completed the Microsoft Azure for Data Engineering certification.
```

### IBM

Certificate, DevOps

```text
Completed the IBM DevOps certification.
```

### Microsoft

Certificate, Database Administration

```text
Passed Microsoft Exam 462: Administering SQL Server 2014.
```

### Microsoft

Certificate, Database Querying

```text
Passed Microsoft Exam 461: Querying SQL Server 2014.
```

### Databricks

Certificate, Data Engineering

```text
Completed the Databricks Data Engineering Primer.
```

## Tech stack

- GitHub
- PySpark
- MySQL
- MongoDB
- .NET Core
- Visual Studio
- Azure DevOps
- Python
- C#
- JSON
- scikit-learn
- Visual Studio Code
- Docker
- Azure Blob Storage
- Great Expectations
- GitHub Copilot
- Microsoft Fabric
- Microsoft Purview
- Power BI
- Dapper

To contact Robert, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [dave withers](https://himalayas.app/@davewithers): Director, Data Services, PWC
- [Sean Cooperman](https://himalayas.app/@seancooperman): Director of Data Engineering, Sightline Payments
- [Sadhana Sharma](https://himalayas.app/@sadhanasharma): Predictive Analytics Team Lead, Texas Children's Hospital
- [Michael Sutherin](https://himalayas.app/@michaelsutherin): Database Consultant, MacroTrenz Corp
- [Ravinder Singh](https://himalayas.app/@ravindersingh2): Lead Data Architect, Intel Corp
- [Steve Jiang](https://himalayas.app/@stevejiang): Data Engineer, UTSW
- [sabira naik](https://himalayas.app/@sabiranaik): Senior Software Architect, KIPP Foundation
- [Jose Hernandez](https://himalayas.app/@josehernandez1): Data Engineer / BI Developer, Think Together
- [Serge Shermon](https://himalayas.app/@sergeshermon): Senior Data Engineer | Data Architect, Apple Bank
- [Joel Losch](https://himalayas.app/@joellosch): Sr. Business Intelligence Developer, Esquire Deposition Solutions
