POS Polling & Reporting

POS Polling & Reporting

A licensee of a client was familiar with the Operational Reporting solution I had implemented. They wanted something similar but the monthly cost of the POS vendor’s polling and replication services was too steep. I built a polling agent that extracted the sales data...
Compliance Data

Compliance Data

Many companies now face legal requirements to report health insurance and/or benefit participation information. These compliance activities can consume a lot of valuable staff time. Way back in my McDonald’s days I worked on non-discrimination testing for the...
Accounting System Integration

Accounting System Integration

There is great efficiency to be found in moving data from one system to another without requiring human intervention. As such, a common request from clients is to automate the entry of data from one system into the client’s accounting system. 1) Load data from a title...
Time and attendance system

Time and attendance system

A client was opening a new branch and doubling in staff size. Their payroll process was not scalable without adding another payroll employee. They needed a time and attendance system that would allow them to increase the efficiency of their payroll processes. I led an...
Sales and Labor Projections

Sales and Labor Projections

I have developed several projection tools with the rich operational data my clients have compiled. 1) Sales projection – Given recent sales trends relative to prior year, project sales for an upcoming week. 2) Labor projection – Given the sales projection from #1 and...
Power BI Dashboards

Power BI Dashboards

The recent improvement of Microsoft’s Power BI service has made it a reachable tool for smaller businesses. For $10/user/month (as of mid-2018), this tool can provide small businesses with analytical capabilities previously reserved for companies with much deeper...