Robert Mills

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.

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.

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.

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

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.

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.

Completed a Data Engineering certificate program through MIT Emeritus.

Passed Microsoft Exam 462: Administering SQL Server 2014.

Completed the Databricks Data Engineering Primer.

Completed the Microsoft Azure for Data Engineering certification.

Completed the IBM DevOps certification.

Passed Microsoft Exam 461: Querying SQL Server 2014.