Portfolio & Case Studies

Situation

Client's nightly production report was taking 3+ hours to run, often timing out. The report pulled job-cost and production data from JobBOSS² (MariaDB backend) and was critical for morning production meetings.

Problem

The report used nested subqueries, missing indexes, and pulled unnecessary data. No one on staff understood the SQL well enough to fix it.

What I Did

• ▸Reviewed the existing Crystal Report and underlying SQL queries
• ▸Identified performance bottlenecks: nested subqueries and missing indexes
• ▸Rewrote queries using CTEs and temp tables for better performance
• ▸Added appropriate indexes to the MariaDB backend
• ▸Tested with full production data to verify accuracy
• ▸Documented the query logic for future maintenance

Situation

Operations team was tracking production metrics across 15 different Excel files. Each shift supervisor had their own spreadsheet. Data was inconsistent, and no one could get an overall picture without hours of manual consolidation.

Problem

No single source of truth. Metrics calculated differently in each file. Version control issues. Hours wasted reconciling numbers.

What I Did

• ▸Interviewed operations team to understand their workflow
• ▸Designed a simple SQL Server database with proper relationships
• ▸Built a VB.NET Windows Forms app for data entry (familiar Excel-like interface)
• ▸Migrated historical data from spreadsheets
• ▸Created SSRS reports replacing the manual consolidation work
• ▸Trained supervisors on the new system

Situation

Month-end close process took 3-4 days and involved extensive manual work: running reports, copying data to Excel, reconciling differences, and rebuilding numbers.

Problem

Viewpoint's standard reports didn't show job-cost data the way finance needed. Manual reconciliation was error-prone and time-consuming. Key person dependency—only the controller knew how to do it.

What I Did

• ▸Documented the existing month-end process step by step
• ▸Built custom SQL queries against Viewpoint tables (cvJCCDJobBilling, JCCI, JCJP, JCCM)
• ▸Created parameterized SSRS reports with drill-down capabilities
• ▸Automated data reconciliation checks
• ▸Documented query logic and report parameters

Situation

Client needed to import customer PO data from Excel files provided by major customers. Manual entry was taking hours and introducing errors.

Problem

Visual ERP had no built-in import tool for this data format. Manual entry was slow, error-prone, and couldn't keep up with volume.

What I Did

• ▸Built a VB.NET Windows Forms application to read customer Excel files
• ▸Validated data and flagged potential issues before import
• ▸Connected directly to Visual ERP SQL Server backend
• ▸Implemented error handling and logging
• ▸Created user-friendly interface requiring minimal training

Situation

IT team had no visibility into SQL Server performance across multiple instances. Relied on user complaints to know when problems arose.

Problem

No proactive monitoring. No historical performance data. Couldn't identify trends or predict issues.

What I Did

• ▸Set up data collection using SQL Agent jobs and sp_Blitz scripts
• ▸Built SQL Server database to store performance metrics over time
• ▸Created Power BI dashboard with key performance indicators
• ▸Set up alerts for critical thresholds
• ▸Trained IT staff on interpreting metrics