PORTFOLIO
With 2 decades of work experience under my belt, the following projects are merely a small sample of the successful client engagements that have been completed. If you have a challenge and can't find something like it among the following, let me know and I can tell you more about projects I have completed that are analogous to your particular challenges.
Project Case Studies
PROJECT 1: Automated Catalog Generation
The annually-produced Homeschool Connections Course Catalog was manually created for the many years since the company's establishment. This was a labor intensive task that became increasingly burdensome (easily 200+ hours of effort annually) as the business grew with more than 41 instructors and an excess of 250 course offerings.
The solution produces a much-higher quality and useful catalog that also conveys the professionalism that the company represents. These outputs bring forth higher student enrollment and income. The time savings and stress reduction by the company's staff represent tangible and intangible benefits that will be realized for many years to come. And growth of the company can continue without adversely affecting catalog quality because the solution is scalable to any increased quantity of instructors and their courses.
Audio Summary of this Case Study
PROJECT 2: CSI Cost Estimation Tool
CSI had a series of estimating workbooks in Microsoft Excel format that have been in place for several years. The workbooks supported the successful capture of many new jobs and allowed for CSI to remain profitable.
The solution consists of an enhanced Excel workbook, built from the original source material, to standardize the process, add custom user interfaces and menu groups, establish audits, allow for cost "deep dives", and perform data validation.
Audio Summary of this Case Study
PROJECT 3: News Studio "Election Big Board"
As a national online media network grew, there was a desire to upgrade their election coverage capabilities. In previous election years, results were updated by hand with colored markers on a white board.
The provided solution allowed for a data-driven and interactive touch-screen experience on their "Big Board" with national results, individual state results, polling data, historical results for comparison, integrated charts for visualizing data over time, and a "What-If" Electoral Vote calculator.
Audio Summary of this Case Study
PROJECT 4: CSI Cost Management Report Automation
The process of building up Cost Management Reports for over 100 jobs became so burdensome that the main POC, Rodney, literally had to sleep in his office one night each week for years.
An automated process performed by "Rod-Bot" (seen at left) replaced his manual efforts and allowed Rodney to return home in time for dinner.