Robert Shelly

Business Intelligence / Analytics Architect with an MBA and 5+ years designing and building enterprise analytics solutions in the Microsoft ecosystem. Hands-on across analytics engineering, Power BI Dataflows, semantic models, Power Query (M), DAX, SQL and query integration, orchestration, and governed reusable data assets. Built cross-system transformation and conformance layers that converted fragmented operational data into trusted analytics supporting 800+ business units.

Partnered with executive leadership, IT, and business owners to automate reporting, improve data quality, standardize multinational KPIs, and deliver scalable decision-support solutions from the C-suite to frontline operations.

GFL Environmental | Business Intelligence Architect 02.2021 - 02.2026

• Designed and maintained the reporting platform as the sole BI Architect supporting Procurement and Fleet Operations.

• Designed, deployed, and maintained 30+ enterprise analytics solutions spanning 100+ production reporting and model artifacts, supporting executives, regional leadership, and frontline operations across 800+ business units.

• Built reusable analytics-engineering layers in Power BI Dataflows, including conformed/mastered dimensions, shared transformation logic, curated facts, and semantic models used across multiple reporting products.

• Developed Power Automate workflows to orchestrate dependent Dataflow and semantic-model refreshes with automated retry logic, failure monitoring, and gateway-aware scheduling.

• Built a governed business-unit master spanning 800+ BUs, combining cross-system organizational, leadership, contact, location, and operational attributes into a trusted enterprise source of truth with exception-driven validation and remediation.

• Developed effective-dated historical-state models that reconstructed asset status and context across transfers and organizational changes for point-in-time and duration-weighted analysis.

• Integrated SQL, API, ERP, and business-managed reference data across multiple source systems, using Power Query/Dataflows to standardize, blend, and serve analytics-ready datasets while optimizing source queries through query folding.

• Standardized multinational operational KPIs and externalized reusable mappings, thresholds, conversions, and business rules so definitions remained consistent across reporting products.

• Reduced manual reporting effort by approximately 15,000 hours annually through automation.

Robert Half | Accounting Consultant - Contract Assignments 06.2020 - 02.2021

• Completed contract assignments for Robert Half clients supporting accounting and reporting functions.

Bailey’s Fine Jewelry | Reporting & Accounting Specialist 10.2018 - 05.2020

• Managed operational reporting and financial-data accuracy for a four-location retail enterprise.

• Built executive reporting and financial models using advanced Excel, Power Query, and Power Pivot while reconciling POS, inventory, sales, tax, cash, and general-ledger data.

• Developed financial models and managed multi-unit tax compliance to support forecasting and business planning.

• Standardized data-entry workflows and internal controls to improve audit readiness and reporting accuracy.

Master of Business Administration in MBA – East Carolina University (2018)

Bachelor of Science in Communications – East Carolina University (2009)