Services & Capabilities
What I offer (business-focused services) and what I work with (technical capabilities).
Services
Business-focused solutions to fix your data problems.
Database Health Check & Performance Tuning
Best for: Organizations with slow queries, unreliable data, or databases that need attention but don't need a full-time DBA.
Common Problems I Fix
- •Reports take too long to run
- •Queries time out or fail
- •Data quality issues and inconsistencies
- •Database growing but performance declining
- •No monitoring or backup verification
What I Actually Do
- •Run sp_Blitz and other diagnostic tools
- •Identify slow queries and missing indexes
- •Review table structures and data types
- •Check backup and recovery procedures
- •Document findings and prioritize fixes
- •Implement performance improvements
What Success Looks Like
- ✓Queries run 50-80% faster
- ✓Reports complete reliably
- ✓Clear documentation of database health
- ✓Monitoring and alerts in place
Typical Engagement
Typical: 1-2 weeks for assessment and initial fixes. Ongoing monitoring optional.
Reporting Cleanup & Redesign
Best for: Teams struggling with reports that are slow, wrong, or break every time data changes. Works with SSRS, Crystal Reports, Power BI, and ERP-embedded reports.
Common Problems I Fix
- •Reports show wrong numbers
- •Filters and parameters don't work correctly
- •Reports take hours to run
- •Layout is confusing or incomplete
- •Report breaks when data changes
- •No one understands how the report works
What I Actually Do
- •Review existing reports and underlying queries
- •Fix SQL logic and performance issues
- •Rebuild filters and parameters correctly
- •Improve layout and formatting
- •Add documentation and comments
- •Test with real data scenarios
What Success Looks Like
- ✓Reports show accurate numbers
- ✓Run time reduced from hours to minutes
- ✓Users can filter and drill down easily
- ✓Clear documentation for future changes
Typical Engagement
Typical: 1-4 weeks depending on report complexity and quantity.
Custom Programming & Automation
Best for: Organizations doing repetitive manual work that could be automated. Typical tools: VB.NET Windows Forms apps, importers, data utilities, ERP helpers.
Common Problems I Fix
- •Hours spent on manual data entry
- •Copying data between systems
- •Repetitive spreadsheet work
- •No good way to import external data
- •Need a tool but ERP doesn't provide it
What I Actually Do
- •Build custom Windows Forms applications
- •Create data import/export utilities
- •Automate file processing and monitoring
- •Integrate disparate systems
- •Build tools that work alongside your ERP
What Success Looks Like
- ✓Manual tasks eliminated or reduced to minutes
- ✓Fewer data entry errors
- ✓Faster turnaround times
- ✓Tools that are simple to use
Typical Engagement
Typical: 2-6 weeks depending on complexity.
ERP / Job-Cost Reporting & Dashboards
Best for: Manufacturing and job shops using JobBOSS², Tekla PowerFab/Trimble EPM, Viewpoint/Vista, Visual ERP. Need accurate job-cost, production, or billing reports.
Common Problems I Fix
- •Can't get accurate job profitability
- •Production metrics scattered across systems
- •Month-end reporting takes too long
- •Standard ERP reports don't show what you need
- •Data in ERP doesn't match reality
What I Actually Do
- •Custom reports against ERP backend databases
- •JobBOSS² / Tekla / Viewpoint SQL-based reporting
- •Crystal Reports and Stimulsoft integration
- •Production and job-cost rollups
- •Dashboards for real-time visibility
What Success Looks Like
- ✓Clear visibility into job profitability
- ✓Production metrics in one place
- ✓Month-end closes faster
- ✓Reports tailored to your workflow
Typical Engagement
Typical: 2-8 weeks depending on ERP complexity and number of reports.
Ongoing DBA & Reporting Support
Best for: Organizations that need database and reporting help but don't need (or can't afford) a full-time DBA. Monthly retainer or on-call arrangement.
Common Problems I Fix
- •No one on staff to handle database issues
- •Reports break and no one can fix them
- •Need someone available when problems arise
- •Want proactive monitoring and maintenance
What I Actually Do
- •Monthly check-ins and health reviews
- •On-call support for urgent issues
- •Report fixes and updates as needed
- •Performance monitoring and optimization
- •Documentation and knowledge transfer
What Success Looks Like
- ✓Peace of mind knowing help is available
- ✓Fast response when issues arise
- ✓Proactive problem prevention
- ✓Budget-friendly alternative to full-time hire
Typical Engagement
Typical: Monthly retainer with agreed-upon hours or on-call arrangement.
Technical Capabilities
The tools, languages, and platforms I work with every day.
Databases & Data Platforms
- ▸Microsoft SQL Server (on-prem, SQL Agent jobs, monitoring with sp_Blitz, etc.)
- ▸MariaDB (JobBOSS² / Tekla / Viewpoint-style job-cost and production data)
- ▸Oracle Database (Crystal Reports against Oracle, date logic, etc.)
- ▸PostgreSQL (installation, basic configuration and usage)
- ▸Azure-hosted SQL / Azure-connected SQL Server (planning, JSON/file-backed setups)
Programming & Scripting
- ▸T-SQL (stored procedures, CTE-heavy queries, temp tables, performance-minded design)
- ▸MariaDB / MySQL-style SQL (reporting and rollups for ERP/production systems)
- ▸Oracle SQL (queries for reporting and date/interval logic)
- ▸VB.NET (Windows Forms apps: internal tools, importers, data utilities, ERP helpers)
- ▸SSRS expression language (VB-style expressions for filters, formatting, parameters)
- ▸Crystal Reports formula language (record selection, custom fields, conditional display)
- ▸DAX (Power BI measures and calculations for monitoring and dashboards)
Reporting, BI & Data Visualization
- ▸SQL Server Reporting Services (SSRS) - Parameterized reports, drilldowns, email subscriptions
- ▸Crystal Reports - Complex joins, grouping, drilldowns, temp-table-based reports, ERP embedding
- ▸Stimulsoft / built-in ERP report designers (Tekla / JobBOSS² style)
- ▸Power BI - Data models, measures, visuals, dashboards based on SQL / monitoring data
- ▸Excel as a reporting front end - ODBC connections, external data pulls, SQL-backed reports
Office & Productivity Tools
- ▸Microsoft Excel - Advanced formulas, pivot tables, data validation, basic dashboards. Automation via external tools (VB.NET apps that read/write Excel)
- ▸Microsoft Word - Templates for documentation, specs, and client-facing reports
- ▸Microsoft PowerPoint - Technical and business slide decks, process visuals
- ▸OpenOffice / LibreOffice - Calc and Writer for spreadsheets and documents when clients prefer open-source tools
- ▸Google Sheets - Light data analysis, shared checklists, quick prototypes for logic
Business Applications & ERPs
- ▸JobBOSS² / similar shop-management systems - Custom reporting, SQL against back-end MariaDB, production and job-cost rollups
- ▸Tekla PowerFab / Trimble EPM - Report development, Crystal and Stimulsoft report integration
- ▸Viewpoint / Vista-style job-cost environments - Phase-level cost/billing reports using cvJCCDJobBilling, JCCI, JCJP, JCCM, etc.
- ▸Visual Manufacturing (Visual ERP) - Custom tooling that launches/monitors the ERP, and SQL-based reporting
Integration, Tools & Misc
- ▸Visual Studio (VB.NET WinForms, SSRS report projects)
- ▸SQL Server Management Studio (SSMS)
- ▸DBeaver (MariaDB / ERP database access)
- ▸Google Drive (synced folder monitoring, failure detection via custom VB.NET tools)
- ▸Windows Server environments (SQL Server instances, scheduled jobs, backups)
Not sure which service fits?
Tell me what's broken and I'll suggest a starting point.