Senior MS Access | Excel | VBA Consultant - System One/Joule (Client: Procter & Gamble Clinical Research) - Mason, OH
(2024-04 - 2026-06)
- Supported a complex MS Access application with 500+ forms, managing custom Clinical Study database generation for Data Managers via user-selected forms.
- Designed and deployed a 160+ table SQL Server database to support backend data integrity and scalability.
- Bulletproofed a Clinical Study system which comprised an MS Access VBA module with 8,000+ lines of code, maintenance forms, and reports. Created an Excel form with 1,496 tests to thoroughly test all functionality of the system, which passed all tests per P & G.
Senior Excel | VBA | MS Access Consultant - ARTECH LLC (Client: Wells Fargo Bank) - Charlotte, NC
(2022-06 - 2024-02)
- Developed complex Excel VBA/SQL financial applications linked via ODBC to MS Access, utilizing pivot tables, slicers, and multi-page user forms for dynamic data maintenance and report wizards.
- Built an interactive, metadata-fed Gantt Chart tool in Excel/VBA featuring 2-click movable colored project bars, improving Scrum team sprint visualization.
- Bullet-proofed a mission-critical Access DB by implementing comprehensive error-handling across 600+ VBA code locations, reducing system crashes by 95 percent.
- Designed a user-configurable Report Wizard enabling end-users to dynamically select from 72 report fields, apply multi-filter controls, and auto-generate formatted Excel spreadsheets on demand.
Senior Excel VBA Consultant - Beacon Hill Staffing (Client: Ohio Regional Income Tax Agency) - Brecksville, OH
(2023-09 - 2024-01)
- Updated the Corporate Income Tax form to 2023 compliance standards. Utilized self-developed VBA macros to analyze 21,000+ formulas, executing 7,000+ add/update/removal actions with 100 percent accuracy.
- Engineered an Excel application to automate metric updates across multiple spreadsheets.
- Modernized the 13-level Penalty and Interest Calculator to reflect current tax codes.
IT Engineer III (Senior Application Developer) - Siemens Energy Staffing - Orlando, FL
(2001-08 - 2022-05)
- Sole architect of the PCS (Project Control System): A suite of 14 integrated VB/MS Access/SQL/VBA applications managing, consolidating, and reporting field data from up to 4,872 project databases.
- Consolidated financial data totaling $275,000.00 per fiscal year, enabling executive-level project cost and billing tracking across labor, expenses, union deductions, tool rental, truck leasing, purchase orders, invoices, and freight.
- Built custom ETL wizards for seamless data extraction from Excel and loading into consolidated reporting databases, as well as ETL processes to merge Oracle planned data with PCS actuals for Planned vs Actual variance reporting.
- Designed division-specific PCS variants, successfully cross-selling the solution to multiple business units after live demonstrations.
- Architected user-friendly report wizards for every application, allowing ad-hoc Excel report generation without programmer intervention.
- Led a VB6 development team of 5 on a nationwide Oracle database application for plant/parts tracking; implemented strict programming standards to streamline SDLC.
- Tracked personal productivity via a self-developed MS Access DB: Completed 3,312 development tasks in 25,634 hours over 19 years, including 763 screens, 178 reports, and thousands of SQL queries.
IT Consultant (Lead Excel/VBA Analyst) - Ajilon Corporation - Independence, OH
(1999-01 - 2001-07)
- Client: Timken Bearings - Sole developer of a VB6/RDO/SQL Server 6.5/Crystal Reports 8 Delay Maintenance and Reporting System for a Grindstock Inspection System.
- Client: FirstEnergy - Built a VB6/ADO/Oracle 8/Crystal Reports 8 Substation Data Collection and Reporting system.
- Client: Warner-Lambert - Senior VB analyst on a team developing a VB6/ADO/SQL Server 7 warehouse replenishment program.
- Client: Ernst and Young - Designed a VB5/ODBC/SQL Server 7/Access application for extracting raw data from diverse formats into standardized MS Access formats.
