Senior Excel VBA SQL Database Developer
Resume:
Keith E. Weirick
Lyndhurst, OH *****
***********@*****.***
LinkedIn: https://www.linkedin.com/in/keith-weirick-681976275/
SENIOR EXCEL VBA SQL DB DEVELOPER
Report Automation - Database Architecture - ETL Development - Complex Application Overhaul
Professional Summary
Senior application developer with 20+ years designing enterprise database solutions using SQL Server, MS Access VBA/SQL, Excel VBA/SQL, Word VBA, and ETL technologies. Specializes in modernizing legacy applications, automating reporting systems, and architecting scalable data solutions for finance, energy, manufacturing, and clinical research. Known for solving high-complexity technical problems while delivering maintainable, user-focused results.
CORE COMPETENCIES
●Languages and Frameworks: VBA, SQL, T-SQL, VB6
●Databases: MS Access, SQL Server, ODBC/ADO
●Tools and Platforms: Excel (Advanced: Power Query, Pivot Tables, Slicers, User Forms), Crystal Reports, Visual Studio, SSMS, SSIS.
●Specialties: User Interface Design, ETL Workflow Optimization, Report Wizard Development, Legacy System Modernization, Metadata-Driven Applications, Financial Data Consolidation, Troubleshooting and Debugging, Data Migration, Agile project management, UAT forms.
●Strong written and verbal communication skills for both technical and non-technical personnel.
Continuous Learning
Python, Power BI Desktop, DAX, PowerShell, AI
PROFESSIONAL EXPERIENCE
Senior MS Access Excel VBA Developer
System One/Joule (Client: Procter & Gamble Clinical Research) Mason, OH
April 2024 - June 2026
- Managed a sophisticated MS Access application featuring over 500 forms, enabling custom FDA-approved Clinical Study eCRF database generation for Data Managers through an intricate multi-page study construction process.
Designed and implemented a 160+ table SQL Server database, migrating schemas and data from the existing MS Access application to bolster backend data integrity and scalability.
Strengthened a Clinical Dental Study system, which included an MS Access module with over 8,000 lines of VBA code, alongside maintenance forms and reports. Developed an Excel User Acceptance Testing (UAT) form containing 1,496 tests to meticulously validate all system functionalities, achieving a 100% pass rate in accordance with P&G standards. Engineered an ETL tool for the seamless migration of Word content into MS Access tables.
Senior Excel VBA MS Access Consultant
ARTECH LLC (Client: Wells Fargo Commercial Bank) Charlotte, NC
June 2022 - February 2024
In the Process Automation and Process Improvement department:
- Developed complex Excel VBA/SQL financial applications linked via ODBC to MS Access, utilizing pivot tables, slicers, multi-page user forms, and Power Query M for dynamic data maintenance and report wizards.
- Built an interactive, metadata-fed Agile Roadmap “Gantt Chart” project management tool in Excel/VBA featuring 2-click movable colored project bars, providing Scrum team swimlane and sprint visualization, planning, and tracking.
- Bullet-proofed a mission-critical Access DB by implementing comprehensive error-handling across 600+ VBA code locations, minimizing system crashes.
- Designed a user-sharable 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
September 2023 - January 2024
- 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
August 2001 - May 2022
- Sole architect of the PCS (Project Control System): A suite of 14 integrated MS Access/SQL/VBA applications managing, consolidating, and reporting field data from up to 4,872 project databases.
Databases were designed as star schemas or snowflake schemas, to make them practical for user maintenance and reports. Created PowerPoint files to train all users -- one contained 181 slides. PCS involved extensive Agile SDLC project management across all Siemens divisions. Also managed DevOps for PCS.
- 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.
EDUCATION AND CERTIFICATIONS
Microsoft Certified Product Specialist - Visual Basic, SQL Server, Windows OS
Master's Degree - Bob Jones University Graduate School, Greenville, SC
B.S. Business Administration - Ohio State University, Columbus, OH
Contact this candidate