Adiv Abramson

MICROSOFT EXCEL VBA AUTOMATION DEVELOPER

Minneapolis, MN 612-***-**** adyux4@r.postjobfree.com Career Summary

I am a Microsoft Excel VBA Developer with over 25 years of experience in creating robust, elegant, efficient, and productivity-enhancing automation applications. With an extensive career focused on Microsoft Excel VBA Automation Development, I have the proven skills, expertise, and passion to deliver innovative and game-changing solutions for a wide variety of businesses. Experience

Excel/VBA Application Developer - 3M Corporation, Maplewood, MN Dec 2021 - Jun 2022

• Designed and developed from scratch a very complex, OOP based, mission critical, high visibility Microsoft Excel application for ergonomics analyses of industrial processes that will be used by design engineers around the world.

• My application has completely replaced an existing application and provide many powerful, innovative features previously unavailable as well as dramatic improvements to the UI, ease of use, and performance.

Excel/VBA Application Developer - Canopius USA, Chicago, IL Sep 2021 - Nov 2021

• Developed Excel VBA Add-in that extracts a large number of textual and numeric data items from a complex Excel pricing tool workbook to populate several different types of Word documents, replacing a tedious manual process that could take up to an hour with an automated solution requiring just five seconds to perform the same tasks. Excel/VBA Application Developer - Cigna Health, Bloomfield, CT May 2021 - Jun 2021

• Developed Excel VBA script to perform a series of manual tasks that used to require 15 minutes in only 2 seconds.

• Developed Excel VBA script to replace existing code for updating hundreds of bookmarks in a Word document with data pulled from an Excel workbook that required 5-10 minutes with optimized macros that perform the same operations, more robustly and efficiently, in approximately 20 seconds.

Excel/VBA Application Developer - Winshuttle, Inc., Bothell, WA Dec 2020 - Apr 2021

• Wrote custom macros and designed UI elements (Ribbon XML, Userforms) for existing financial Excel templates to enhance user experience and improve performance.

• In one template, replaced numerous VLOOKUP and custom UDFs with a macro that performs the same functions 180 times faster.

Excel/VBA Application Developer – Trane, Inc., Lexington, KY Aug 2019 - Nov 2020

• Designed and coded from scratch several automated and sophisticated multi-function data analytics tools in Microsoft Excel for use by senior management in analyzing and forecasting enterprise-wide project financials and resource allocation. Tools greatly enhanced manager productivity by generating in mere moments complex reports that used to take hours to produce manually. Excel/VBA Application Developer – CVS Health, New York, NY Mar 2018 - Mar 2019

• Developed and deployed several complex Excel based automation applications with sophisticated, rule driven data parsing, manipulation and formatting logic, resulting in dramatic improvements in operational efficiency and worker productivity.

Excel/VBA Application Developer - Mercer/CPSG Partners, Dallas, TX Apr 2017 - Nov 2017

• Analyzed existing Excel based data conversion tool, providing guidance on streamlining and enhancing code. Created new, mission critical, robust and feature rich OOP based data conversion application that is highly automated and provides an elegant, context sensitive UI for maximum flexibility and greatly enhanced user experience.

Excel/VBA Application Developer - Molecular Imaging, Ann Arbor, MI Nov 2016 - Mar 2017

• Continued development of complex Excel based scientific research application. Performed extensive troubleshooting and mitigation activities to enhance application robustness and reliability. Revised, corrected, and enhanced numerous existing VBA macros while coding several new helper procedures that significantly improved end user productivity and experience. Created data extraction add-in to create CSV files from complex worksheets. Access/Excel/VBA Application Developer - VOYA, Inc, Minneapolis, MN Nov 2016 - Dec 2016

• Enhanced existing multi-user case tracking system (CST) in Access 2010 with significant improvements to the UI and extensive modifications to the code base to provide more robust error trapping and uptime availability.

• Helped detect and mitigate critical data errors that had adversely impacted dozens of daily end user workflows. Added custom Ribbon buttons and VBA callbacks to provide several new features, including one click formatting and exporting of active datasheet objects to Excel workbooks as well as collecting data from open forms and composing formatted output files. Excel/VBA Application Developer - Molecular Imaging, Ann Arbor, MI Oct 2015 - Oct 2016

• Developed numerous macros for collection of workbook data and string parsing; dynamic code generation (modules, enums), dynamic Ribbon menus and dynamic Userforms with runtime generated controls with event procedures wired to event class modules in a large-scale Excel VBA application.

• Created unique VBA project management utility that facilitated import/export of project forms, modules, and individual procedures, making updating and rebuilding of projects substantially quicker. Excel/VBA Application Developer - Mills Financial Marketing, Fort Worth, TX Sep 2015 - Nov 2015

• Developed Excel Addin to import, validate, and reformat tabular data extracted from a PDF file. Program then automatically determines complex, range dependent formulas for calculation columns and copies them down, populates static data columns, creates new spreadsheet with columns rearranged for export into an Access database.

• Developed sophisticated text parsing code that rewrites and adjusts formulas on new spreadsheet to reflect new locations of precedent columns, automatically transposes and denormalizes hundreds of data rows for export to Access tables and Tableau for reporting.

• Application reduces overall processing time from several hours to less than two minutes, thereby greatly improving client's productivity and profitability. VBA Application Developer - Wells Fargo Bank, Minneapolis, MN Dec 2011 - May 2012

• Designed and developed Access 2003 and VBA based Housing Issues Log database solution for Relationship Managers throughout the enterprise.

• Created and coded sophisticated VBA macros to import, parse, scrub, transform and append loan servicing data from hundreds of complex Excel spreadsheets into centralized Access database application with more than 200 distinct data elements in multiple related tables.

• Designed and developed custom project management log in Access 2003 for department manager. Created and coded sophisticated VBA macros to import, parse and transform complex Excel spreadsheet data into database application that provides convenient search and reporting capabilities as well as an export to Excel feature to create spreadsheets on the fly in a format identical to original source data.

VBA Application Developer - American Stock Transfer & Trust, Brooklyn, NY Apr 1997 - May 2011

• Vastly improved accuracy and throughput of a large number of external and internal client data file conversion processes by developing enterprise level applications in Access, Excel, Word and Outlook, including proxy file, shareholder list, certificate history file conversions; surrender file processing; ACH transaction file processing, BAI1 and BAI2 file processing; and direct debit/deposit file processing, directly resulting in significant increase in service revenue and dramatic cost savings by eliminating thousands of man-hours of manual labor annually. Education

Rensselaer Polytechnic Institute

MS Technical Communication

Rensselaer Polytechnic Institute

BS Physics

Skills

• VBA

• Microsoft Excel

• Regular Expressions

• OOP

• Data Transformation

• Power Query

• Power Pivot

• Microsoft Access

• Userforms

• DAO

• ADO

• Automation

• T-SQL

• Macros

• Userforms

• End User Documentation

Links

• LinkedIn Profile: https://www.linkedin.com/in/adivabramson

• GitHub Profile: https://www.github.com/scriptingbear

Contact this candidate