VBA Excel Access Programmer
Resume:
DAVID HERMANN
VBA Excel Access Programmer
**** **** ** **, ********** DC 20010-2201
*****.*******@*******.***
SOFTWARE
Expert in VBA, Microsoft Excel, MS Access, SQL, MS Windows. Familiar with SQL Server, MySQL, Microsoft Office on the Mac, SharePoint, Zendesk.
STRENGTHS
• Well structured, cleanly formatted and thoroughly commented code with detailed error handling
• Thorough import/export/ETL management
• Robust relational data design
• Consistent, convenient user interface design
• Translation of technical issues into everyday language
• Anticipation of users' needs
• Enthusiasm and creative thinking about data
• All VBA code and SQL queries written from scratch, with no use of "wizards" PROFESSIONAL EXPERIENCE
Supporting Strategies, Boston MA
Consultant, 2019 to present
Developed VBA code and Access databases to
• merge hundreds of biweekly/monthly Excel reports from QuickBooks and in-house CRM/timecard/financial systems (ETL)
• create periodic and on-demand BI/KPI reports in Excel for the company president and franchisees Perch (Whele LLC), Boston MA
Consultant, 2020 to 2024
Developed VBA code and Access databases to
• clean and merge hundreds of biweekly/monthly CSV and PDF files from Amazon Seller Central, Shopify eCommerce, and Walmart Fulfillment Services, with CSV file sizes up to 1 million rows (ETL)
• translate and standardize data across 10+ European languages
• create rigidly formatted Excel files for upload to accounting system New England Medical Billing, South Easton MA
Consultant, 2013 to 2020
Developed VBA code and Access databases to
• import and cross-reference Excel and text files from MassHealth and 75 school districts (ETL)
• handle dozens of file formats, both strictly specified and minimally structured
• ensure compliance with Public School-Based Medicaid Claiming rules
• provide user-friendly interactive report screens with on-demand Excel output Doubled claim capacity while reducing data entry staff hours by two-thirds. Managed database growth with strategic subdivisions of data. Planned for future migration to SQL Server. Lead Surge Advertising, Norwood MA
Consultant, 2015 to 2019
Added VBA code to existing Excel spreadsheets and created new spreadsheets to automate manual invoicing, reporting, and error checking.
Enforced relational database-type rigor on Excel spreadsheets on the Mac, where MS Access is not available. National Co+op Grocers, Iowa City IA and St. Paul MN Consultant, 2004 to 2019
Software developer and data cruncher for umbrella organization for 200 retail grocery co-ops. Created Access databases to manage the import of dozens of large inconsistently formatted Excel files monthly, and to produce multi-year summaries in Excel. Developed a robust self-contained Access database for non-technical users to do similar work with Excel files on a smaller scale, with no technical support required for years at a time. Harvest Co-op Markets, Cambridge and Boston MA
Full time, 2003 to 2015; Consultant, 2015 to 2018
Sole data architect and programmer for multi-store retail grocery cooperative. Replaced legacy code and developed new Access databases to
• track 40,000 co-op members, customers, and employees
• manage point-of-sale pricing for 100,000 UPCs/PLUs on Linux servers and deli scales
• combine catalog data on millions of SKUs from dozens of vendors in as many formats (ETL)
• analyze 900,000 sales transactions per year
• produce financial reports in Access and Excel
• generate and transmit Excel reports to business partners automatically Developed screens for non-technical users to enter data and generate interactive reports. Eliminated three job positions in the first three years. EDUCATION
Massachusetts Institute of Technology
BS in Mathematics
Contact this candidate