13+
Years Experience
20
Major Projects
300
Users Supported
16
Professionals Managed
Recommendations
Projects
Recent Work History
Senior Consultant II, Data & AI
Neudesic, an IBM Company
Oct 2022 - Present
- Designed and created tabular model and standardized reporting package for Neudesic ONE Data & AI Platform Accelerator Framework 4.0.
- Large energy company client: Developed Azure Databricks and Power BI solutions related to notifications and alerts for power outages and other customer communications. Instituted standardized reporting and best practices.
Lead Data Architect
RPM Specialty Products Group
Jun 2022 - Oct 2022
- Developed and maintained existing enterprise data warehouse within Azure SQL Server as the sole data resource for 20+ companies within the group. Primary data source of D365 Finance and Operations with a BYOD solution.
- Created and presented a project plan and roadmap to transition away from the existing data warehouse to an Azure Data Lakehouse (Delta lake from Databricks) model using Azure Synapse, Azure Logic Apps, and CDM conversion framework.
- Created and presented a project plan to relaunch Power BI group wide with the data lakehouse as the single source of truth, which gained buy-in from executive leadership.
- Managed a team of offshore employees that handled report development requests within Power BI using existing data warehouse.
Enterprise Data Manager
Sanitation Specialists
Jan 2020 - Jun 2022
- Investigated and implemented new technology solutions for all company functions.
- Built and managed a team of Business Analysts, Business Applications Developers, and UX/UI Designers to create custom solutions for complex business problems.
- Built and managed an internal IT department (Help Desk & Sys Admin, transitioned from 3rd party IT support.)
- Developed custom internal applications to be used as solutions to business problems spanning a wide variety of uses across Accounting, Human Resources, Operations, etc.
- Created a custom mobile app designed for customers to promote communication, fast and easy reporting, and resolution of issues & damage claims.
- Migrated ETL pipelines from SQL Server to Azure Synapse/Data Factory.
- Engineered historical Type 2 SCD tables from static/dimensional Dynamics 365/Dataverse source systems in Azure Synapse.
Business Intelligence Architect
Sanitation Specialists
Mar 2019 - Jan 2020
- Created data architecture foundation (data modeling, ETL, data mart) for a data warehousing solution using legacy ERP and Dynamics 365 data sources in Azure Cloud / Data Lake.
- Developed SQL queries to facilitate denormalization of highly normalized database source systems.
- Defined standards for previously uncategorized data, including definition for commonly used metrics to create a single source of truth.
- Designed dashboards for executive and field use to inform decision-making and enable score-carding.
- Designed and coded Microsoft PowerApps for the purpose of increasing operational efficiency and reducing overhead costs by transitioning manual processes to automated solutions.
Business Intelligence Analyst II
Cable ONE
May 2017 - Mar 2019
- Designed, implemented, and maintained data marts optimized for natural language query to enable robust business user self-service through Microsoft Power BI and Excel.
- Developed complex SQL queries to deliver enriched data and enable impactful reporting.
- Created and maintained several high-efficiency large scale data models using transactional, snapshot, and Type2 SCD database tables from disparate sources.
- Developed high-level KPI dashboards for executive team use, with robust drill-in functionality for self-service exploration of the data.
- Designed and implemented row-level security for data models to ensure data governance needs are met.
- Created DAX methodology in Power BI to enable highly dynamic filtering of data models.
- Established standards for BI reporting, publications, presentations, and documentation.
- Helped establish and evolve Agile/SCRUM implementation to fit department needs.
Contact information
-
Country:
United States of America -
City/State:
Phoenix, Arizona
-
LinkedIn:
sean-m-hutton -
Resume:
Download CV
-
Email:
cv@shutton.cloud -
Cell:
+1 (480) 331 7301