Macro Development and Process Automation

Several businesses utilize the MS Office Suite, but seldom to its full potential. Several redundant tasks can often be automated using Visual Basic macros. Below are some projects involving the coding, debugging, and training of end users on using macros for process automation in MS Word, MS Excel, and other Microsoft Office Applications

Books By Inklings v2- Drupal-based Site

After having launched the initial brochure site in June 2011, our next phase of this project entailed a full CMS based launch. The store management wanted the ability to post announcements for special promotions and upcoming events, post pictures and … Continue reading

Project Types CMS Platform Management, CMS Site Designs, Content Creation, Editing, Management, Content Editing, Copy-Editing, Editing for SEO, Macro Development and Process Automation, Technical Documentation, Web Site Design & Management | Features & Highlights , , , , , , , , , ,

Specialists of Schools Website / Online Directory Customization

In September 2009, this nonprofit organization reached out to me in an effort to save on web-maintenance and administrative costs and help standardize their existing site. At the time, each page had its own styles resulting in an inconsistent look … Continue reading

Project Types Macro Development and Process Automation, Web Site Design & Management | Features & Highlights , , , , ,

Ridge Road Sight & Sound Custom Database

After Paperback El Rex booksellers ran their course, one of the former owners went out on his own, continuing to sell vintage paperback books, but also adding vinyl records to his inventory. We enhanced the existing database structure and application … Continue reading

Project Types Database Architecture & Administration, Macro Development and Process Automation | Features & Highlights , , , ,

Standardizing Forms, Providing Templates, and Streamlining Processes – Eureka Intranet

After a few months working at Eureka, upper management asked if I could take over and enhance the existing intranet site. The site was a static html website hosted on the company’s internal Windows 2003 servers with IIS. Highlights & … Continue reading

Project Types Database Architecture & Administration, Efficiency Studies, Macro Development and Process Automation, Web Site Design & Management | Features & Highlights , , , , , , , , ,

Hudson Group Corporate Payroll Reporting Worksheet

In order to standardize payroll reporting methods to the payroll department, I was asked to generate this basic corporate branded payroll processing sheet for company wide use. This worksheet was created in both MS-Excel and Lotus 1-2-3 formats with the … Continue reading

Project Types Literature & Publications, Macro Development and Process Automation | Features & Highlights , , , ,

Sales Margin, Retail & Cost Markup / Markdown Calculator & Web Application

When the Hudson Group took over operations of over 200 stores nationwide, they sought out a basic web-application to train managers on the concepts of retail markups, profit margins, and cost margins. I was tasked with compiling a flash based … Continue reading

Project Types Custom Business Solutions, Macro Development and Process Automation | Features & Highlights , , , , , , , ,

Hudson Group Perpetual Inventory Workbook

In 2004, the Hudson Group took over operations of over 200 stores nationwide (essentially tripling in size) and was in need of a standard for reporting sales, inventory, and payroll to the corporate office. In order to standardize sales and … Continue reading

Project Types Efficiency Studies, Macro Development and Process Automation | Features & Highlights , , , , , , ,