Business Intelligence & Data Solutions
I help businesses connect their data systems, build reporting structures that actually get used, and turn scattered information into clear decisions.
Business Intelligence
Power BI dashboards, automated reporting, and data visualization.
Data Integration & ETL
Connect enterprise systems and automate data pipelines.
Data Modeling
Database schema design and data architecture for analytics.
Custom Applications
Web applications built to support data workflows and reporting.
What I Do
How I can help
Business Intelligence & Reporting
Stop wasting hours copying data between spreadsheets. I build automated reporting solutions that pull from your existing systems and present insights you can actually use. From Power BI dashboards with live data connections to Excel-based reporting with Power Query automation.
- Power BI dashboards with live data connections
- Power Query automation to eliminate manual data prep
- KPI tracking and executive reporting
- Automated currency reconciliation and financial reporting
Data Integration & ETL
Disconnected systems create friction and bad data. I build pipelines that pull from your enterprise systems and deliver clean, unified data to the people who need it.
- ETL pipelines connecting ERP, HRIS, and financial systems
- Automated workflows connecting CRM, ERP, and Finance
- Data mapping across source systems with validation
- Regulatory compliance data integration (IRA, federal reporting)
Data Modeling & Architecture
Good reporting starts with good data structures. I design database schemas and data models that make your analytics reliable, your queries fast, and your data consistent.
- Database schema design for analytics and reporting
- Source-to-target data mapping documentation
- Data quality assessment and governance frameworks
- Multi-system data architecture for unified reporting
Custom Application Development
When off-the-shelf software doesn't fit your workflow, I build custom applications tailored to exactly how your business operates. From internal tools to customer-facing platforms.
- Applications built to support data workflows and reporting
- Real-time dashboards with live data connections
- Multi-tenant SaaS platforms with proper data isolation
- Secure applications for regulated industries
Selected Work
Projects that made an impact
Currency Reconciliation
Designed data model mapping ERP and external exchange rate sources, reducing a 6-hour manual process to 30 minutes with automated Power Query workflows.
IRA 2022 Compliance Reporting
Built ETL pipelines integrating SAP, UKG HRIS, and custom applications into unified reporting structures for federal regulatory compliance.
DoD Operations Monitoring
Designed real-time data architecture for military manufacturing operations with automated escalation when metrics fell outside tolerance.
Property Management Platform
Integrated RentManager API and payment systems, automating data synchronization that replaced hours of weekly manual updates.
Land Surveyor Project Management
Designed complete database schema from scratch covering proposals, project tracking, crew scheduling, and multi-method billing data models.
AI-Powered Data Extraction
Built an application that automatically extracts structured data from images, generating descriptive metadata and categorization tags.
I've been helping organizations make sense of their data for 20+ years
I started my career in pharmaceutical manufacturing at Abbott Laboratories, where I learned that the best data in the world is useless if it doesn't reach the people who need it. I spent years implementing SAP, analyzing supply chain and financial data, and learning process improvement (Lean Six Sigma Green Belt).
That foundation led me to consulting, where I've spent the last 11+ years helping organizations make sense of their data. Whether it's designing data models that connect scattered enterprise systems, building ETL pipelines for regulatory compliance, or creating Power BI dashboards that become a leadership team's go-to decision-making tool—I focus on turning complex data into something people can actually use.
I'm based in Lynchburg, VA and work remotely with clients across the country.
From the Blog
Tips & tutorials
Mastering Power Query: How to Lift Subtotal Text to Detail Rows
Use this technique to further analyze subtotaled data
Read articleHow to Automate ECB Exchange Rates in Excel
Use ECB Exchange Rates in your Excel / Power Query / Power BI files without downloading
Read articleHow to Spread Revenue Across Date Ranges
Determine Revenue Recognition using a date range and amount
Read articleExcel: Combine Data from Multiple Sheets with Related Data
Include data from other sheets when columns are related
Read articleLet's talk about your project
Whether you need to connect your data systems, build reporting your team will actually use, or make sense of data spread across multiple platforms, I'd love to hear what you're working on.
Book a Free 30-Minute Call