Data & Automation Consultant

Transforming Data Into Actionable Intelligence

Expert in Power Platform development and advanced Excel modeling. I build custom solutions that automate workflows, unlock insights, and drive business decisions.

What I Do

Services Built for Business Impact

Power Platform Development

Custom solutions using Power Apps, Power Automate, and Power BI that streamline operations and eliminate manual processes.

  • Custom Power Apps development
  • Workflow automation with Power Automate
  • Interactive Power BI dashboards
  • SharePoint & Dataverse integration
  • Legacy system modernization
📊

Excel & Data Modeling

Advanced Excel solutions, financial models, and data analysis tools that transform raw data into strategic insights.

  • Complex financial modeling
  • Dynamic dashboards & reporting
  • VBA & macro automation
  • Data cleaning & transformation
  • Forecasting & scenario analysis
Case Studies

Real Solutions, Measurable Results

Power Platform

Field Safety Compliance System

Built a comprehensive Job Safety Analysis (JSA) tracking application for water utility field operations. The browser-based system streamlined safety compliance documentation, replacing manual paper processes with automated workflows and real-time reporting.

75%
Time Reduction
100%
Digital Compliance
50+
Active Users
Excel Modeling

Contact Center Staffing Forecast

Developed an advanced Excel model combining Erlang C calculations with workload-based billing logic. The tool forecasts staffing requirements and operational costs across multiple service tiers, enabling data-driven resource planning.

90%
Forecast Accuracy
$200K
Annual Savings
12
Scenarios Modeled
Data Integration

Healthcare Enrollment Analytics

Created a multi-state ACA marketplace data pipeline integrating CMS public use files across nine State-Based Exchanges. Built automated rate multiplier tables and rural-urban classification systems for comprehensive premium analysis.

9
States Integrated
500K+
Records Processed
Real-time
Data Updates
About Me

Experience That Delivers

Solving Real Business Problems with Technology

I'm Jeffory Burnett, a data and automation consultant specializing in Power Platform solutions and advanced Excel modeling. With a background spanning water utilities, healthcare analytics, and operational efficiency, I bring practical, results-driven solutions to complex business challenges.

My approach focuses on understanding your unique workflow and building tools that integrate seamlessly into your operations. Whether it's automating manual processes, creating sophisticated data models, or building custom applications, I deliver solutions that work in the real world.

🎯
Domain Experience
Utilities, Healthcare, Operations
🔧
Technical Stack
Power Platform, Excel, VBA, DAX, M
📈
Specializations
Automation, Analytics, Modeling
🤝
Approach
Collaborative, Practical, Results-Focused
Get In Touch

Let's Build Something Together