I am a senior MS Access/Excel/VBA Developer and SME with over 27 years of experience building front- and back-end MS Access databases and Excel applications using VBA. I design user-friendly interfaces, implement robust data models, and integrate Access with SQL Server to deliver scalable solutions. I focus on usability, reliability, and performance. I partner with organizations across financial services, government, healthcare, and professional services to automate processes, generate compliant reports, and improve data integrity. My approach blends business analysis with hands-on development to translate requirements into high-quality tools and dashboards.

Abe Amsel

I am a senior MS Access/Excel/VBA Developer and SME with over 27 years of experience building front- and back-end MS Access databases and Excel applications using VBA. I design user-friendly interfaces, implement robust data models, and integrate Access with SQL Server to deliver scalable solutions. I focus on usability, reliability, and performance. I partner with organizations across financial services, government, healthcare, and professional services to automate processes, generate compliant reports, and improve data integrity. My approach blends business analysis with hands-on development to translate requirements into high-quality tools and dashboards.

Available to hire

I am a senior MS Access/Excel/VBA Developer and SME with over 27 years of experience building front- and back-end MS Access databases and Excel applications using VBA. I design user-friendly interfaces, implement robust data models, and integrate Access with SQL Server to deliver scalable solutions. I focus on usability, reliability, and performance.

I partner with organizations across financial services, government, healthcare, and professional services to automate processes, generate compliant reports, and improve data integrity. My approach blends business analysis with hands-on development to translate requirements into high-quality tools and dashboards.

See more

Work Experience

MS Access/Excel/VBA Developer
June 1, 2025 - October 20, 2025
Enhanced, serviced and administered the company's existing Access-based Dispatch System. Created user-friendly MS Access forms/screens for the Dispatch System. Implemented an Auto-Logon system to replace an outdated login process. Created backend SQL Server views for reporting using Pass-Through queries to speed data retrieval and improve reporting performance.
MS Access/MS Excel/VBA Developer
March 1, 2024 - October 20, 2025
Remediated issues across hundreds of Access databases and Excel workbooks. Collaborated with stakeholders across the USA and Europe to address data problems, produced client-facing compliance and securities reports, built Excel VBA macros, and developed Power Query ETL solutions to replace Monarch.
MS Excel/VBA Developer at PepsiCo
January 1, 2022 - October 20, 2025
Created an Excel tool leveraging the Analytics for Office (AFO) API to speed data downloads; tool adopted by hundreds of users, reducing data retrieval time by approximately 50%.
MS Access/MS Excel/VBA Developer at Fiserv/First Data
November 1, 2021 - October 20, 2025
Built Office 365-compatible Access/Excel applications and remediated existing apps; developed a daily wire transaction data downloader; built Power Query solutions to replace Monarch ETL.
SQL Server Developer/SSRS Developer/MS Access Developer at Centene Corporation/Health Net Federal Services
October 1, 2019 - October 20, 2025
Upgraded a back-end environment connecting multiple systems; created pass-through queries via ODBC; delivered upgrades within a short window and ensured data integrity.
MS Access/VBA Developer at New York State Dept. of Health/NYSTEC
May 1, 2019 - October 20, 2025
Remediated and enhanced Medicaid Incentive Database; improved user experience with interactive forms, dashboards and reports; automated updates via VBScript; OBIEE used for querying/mining.
SQL Server Developer/SSRS Developer/MS Access Developer at Disability RMS/Sun Life Financial
January 1, 2018 - October 20, 2025
Updated MS Access forms with VBA Class Modules for FlexGrid; standardized SSRS reports; created new T-SQL scripts to manage tables, views, sprocs and triggers; worked in an Agile environment with Jira.
VBA Developer/Automation at Prudential Insurance Company
July 1, 2017 - October 20, 2025
Automated report generation in Excel; built automation tools in Access/Excel to generate HR compensation reports; pulled data from PeopleSoft and other sources.
VBA Developer/Automation/Reporting at RJ Reynolds
September 1, 2016 - October 20, 2025
Automated Excel Pivot-Table reports; automated usage of Beyond Compare; created an Access tool to map data for FURLS upload reporting; improved user experience.
MS SQL Server Developer/MS Access Developer/XML-Xpath/Data Validation at New York Life Insurance Company
January 1, 2016 - October 20, 2025
Maintained existing MS Access databases; ETL using MS Excel and XPath; designed and built a SQL Server database with tables, views, and stored procedures to support NYLIS and legacy FTIS.
MS Access Developer/Data Analyst at L’Oréal USA/Finance Division
December 1, 2010 - October 20, 2025
Designed and built an Access tool to automate P&L statements; data import/export automation between Access and Excel; created client field-mapping for automated data loads.
MS Access Developer/MS Excel/VBA at Deloitte
February 1, 2010 - October 20, 2025
Troubleshot and maintained existing Access/Excel automation; enhanced macros for speed and reliability; developed new Access applications for multiple business units; supported migration to Office 365.
MS Access Developer at Mitsui Foods
February 1, 2009 - October 20, 2025
Reverse-engineered an existing Access database to document the system for an SAP implementation and prepared tooling to support the transition.
MS Excel Developer/MS Office Automation at Abt Associates
January 1, 2012 - October 20, 2025
Lead Excel development for Oracle Projects interface; redesigned project-tracking tools; delivered forms and custom functions in a RAD environment.
MS Access Developer at Kaplan, Inc.
February 1, 2009 - October 20, 2025
Developed Leadership Tracking Tool in Access; automated data flows and improved reporting for executives and program managers.
MS Access Developer at EverDixie EMS Supply Co.
May 1, 2009 - October 20, 2025
Developed a Data Interface Application for eCommerce to automate data transfer into PF; created data mappings using VB scripts.
MS Access Developer at AT&T
June 1, 2002 - October 20, 2025
Developed a Billing System in MS Access; automated data entry and billing workflows.
MS Access Developer at Empire Equities
December 1, 2005 - October 20, 2025
Developed an Investor Tracking System; built data interfaces and reporting tooling.
MS Access Developer at Community Medical/Dental Care
May 1, 2001 - October 20, 2025
Developed Patient-Tracking System; implemented data input forms and reporting.

Education

Master of Talmudic Law and Theological Education at Telshe Yeshiva College
January 11, 2030 - October 20, 2025

Qualifications

MICROSOFT CERTIFIED TECHNOLOGY SPECIALIST (MCTS) - SQL SERVER 2005
January 11, 2030 - October 20, 2025
Microsoft Office User Specialist Master Certification
March 1, 2001 - October 20, 2025

Industry Experience

Financial Services, Education, Government, Healthcare, Professional Services, Software & Internet, Media & Entertainment, Retail, Other