Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

I am Keith A. Swerling, a VBA Developer with a strong blend of analytical and creative thinking. I excel at turning manual, error-prone processes into automated solutions using VBA to automate office procedures, data manipulation, and document preparation. I strive to reduce employee fatigue and improve accuracy through scalable automation and robust reporting. I am technically proficient with MS Office, DOS and command-line tools, SharePoint, Win32 API, Web Scraping, Adobe PDF, and eCommerce web management. I enjoy continuous process improvement and collaborating with teams to deploy practical, reliable solutions.…I am Keith A. Swerling, a VBA Developer with a strong blend of analytical and creative thinking. I excel at turning manual, error-prone processes into automated solutions using VBA to automate office procedures, data manipulation, and document preparation. I strive to reduce employee fatigue and improve accuracy through scalable automation and robust reporting. I am technically proficient with MS Office, DOS and command-line tools, SharePoint, Win32 API, Web Scraping, Adobe PDF, and eCommerce web management. I enjoy continuous process improvement and collaborating with teams to deploy practical, reliable solutions.

Keith A. Swerling

Web Developer, Programmer, App Developer, +4





I am Keith A. Swerling, a VBA Developer with a strong blend of analytical and creative thinking. I excel at turning manual, error-prone processes into automated solutions using VBA to automate office procedures, data manipulation, and document preparation. I strive to reduce employee fatigue and improve accuracy through scalable automation and robust reporting. I am technically proficient with MS Office, DOS and command-line tools, SharePoint, Win32 API, Web Scraping, Adobe PDF, and eCommerce web management. I enjoy continuous process improvement and collaborating with teams to deploy practical, reliable solutions.…I am Keith A. Swerling, a VBA Developer with a strong blend of analytical and creative thinking. I excel at turning manual, error-prone processes into automated solutions using VBA to automate office procedures, data manipulation, and document preparation. I strive to reduce employee fatigue and improve accuracy through scalable automation and robust reporting. I am technically proficient with MS Office, DOS and command-line tools, SharePoint, Win32 API, Web Scraping, Adobe PDF, and eCommerce web management. I enjoy continuous process improvement and collaborating with teams to deploy practical, reliable solutions.

Available to hire

I am Keith A. Swerling, a VBA Developer with a strong blend of analytical and creative thinking. I excel at turning manual, error-prone processes into automated solutions using VBA to automate office procedures, data manipulation, and document preparation. I strive to reduce employee fatigue and improve accuracy through scalable automation and robust reporting.

I am technically proficient with MS Office, DOS and command-line tools, SharePoint, Win32 API, Web Scraping, Adobe PDF, and eCommerce web management. I enjoy continuous process improvement and collaborating with teams to deploy practical, reliable solutions.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Intermediate

Language

English

Fluent

Work Experience

Variable Data Specialist at Amwins Inc

January 1, 2021 - Present

Developed and implemented Excel/Visual Basic for Applications to automate ID merges for printing. Created Excel control panels for three medical ID output lines, pulling and transforming data from SQL servers, SharePoint, and emailing daily reports to increase operational efficiency. Automated conversion of output Excel data to Mail Merge and Fusion for a digital workflow. Initiated an error reporting system to alert managers of data issues and duplicated ID requests. Synchronised backup of source data and SharePoint documents, automating check-in/check-out processes to prevent data loss and protect customer data.

Desktop Support at CVS (contract work)

January 1, 2020 - December 31, 2020

Handled phone requests for login and password issues in AS400 and Active Directory; trouble-shot hardware and internet devices; assisted in online setup and login of registers and photo machines.

Data Clerk at MetLife Insurance (contract work)

January 1, 2019 - December 31, 2019

Excel Report Developer. Onboarding agents, including VBA automated website integration. Managed Agent Laptop Rollout. Troubleshot agent hardware and software issues with laptop rollout. Documented internal processes and managed agent document requests and receipt returns. Supported a rollout of 400 Windows 10 laptops, including document migration, printer and docking station setup. Converted a 2-hour onboarding process into a button-click on a spreadsheet of agents with VBA.

Network Engineer at Gold's Gym

January 1, 2013 - December 31, 2018

Managed networks, servers, and workstations for two Rhode Island locations. Configured and maintained 45 workstations and 6 servers to maintain member and billing databases. Installed software, configured VPN and network for remote work. Maintained computers of the Lifecycle fitness equipment.

Founder and Administrator at RI and MA Lost Pets

January 1, 2011 - Present

Founded and administer RI and MA Lost Pets pages, growing community since 2011. Automated VBA posting to more than 350 Facebook Pages of emailed lost and found pet reports for volunteers.

Excel Report Developer at MetLife Insurance (contract work)

January 1, 2019 - January 1, 2019

Onboarding agents, including VBA automated website integration; managed Agent Laptop Rollout; trouble-shooted Agent hardware and software issues; documented internal processes; managed Agent document requests and receipts; supported a rollout of 400 Windows 10 laptops, including document migration, printer, and docking station setup; converted a 2-hour onboarding process into a button-click on a spreadsheet of Agents with VBA.

Network Engineer at Golds Gym

January 1, 2013 - January 1, 2018

Managed the networks, servers, and workstations for two Rhode Island locations; configured and maintained 45 workstations and 6 servers to maintain member and billing databases; installed software, configured VPN and network access; remote support for equipment lifecycle.