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...
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...