Industry Group Reporting

Industry Group Reporting

A trucking and logistics client was a member of an industry group that shared some operational data among the members. This data took several days for an employee to compile from various reports, queries, and other sources around the company. They were looking for a...
Daily Operational Reports

Daily Operational Reports

A retail client with 10+ locations required their store managers to run some sales reports from the POS daily and fax them into home office. The data from those faxes was then keyed into a spreadsheet which was then distributed to management. The POS vendor was...
3rd Party Integration

3rd Party Integration

Multiple projects over the years have involved integrating my clients’ systems with vendors. Each project is different but follows a very similar pattern: 1) Define the data needed and the format of the exchange,2) Build whatever tools are needed to facilitate the...
Centralized POS Management

Centralized POS Management

A growing client was experiencing several issues related to inconsistent POS setup across their locations: 1) Inconsistent pricing,2) Missing products,3) Incorrectly configured promotions and discounts, and4) Training challenges for employees that worked at multiple...
Custom Reporting

Custom Reporting

The number of custom reports I’ve written over the years must be in the thousands. Sometimes the report lives forever in a repository like SSRS, sometimes it is a once-off data analysis, and sometimes the report expands into a full-fledged application. A title and...