Adiv Abramson, Microsoft Excel VBA Automation Developer

About

Recent Experience Highlights • Expertise in Microsoft Excel and in Macros. • 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. • 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. • 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. • Wrote custom macros and designed UI elements (Ribbon XML, Userforms) for existing financial Excel templates to enhance user experience and improve performance. • Revised, corrected, and enhanced numerous existing VBA macros while coding several new helper procedures that significantly improve end user productivity and experience.

Experience

3M Corporation

Dec 2021 – Jun 2022

Maplewood, MN

Excel/VBA Application Developer

• 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. It will completely replace an existing application and provide many powerful, innovative features previously unavailable as well as dramatic improvements to the UI, ease of use, and performance.

Canopius USA

Sep 2021 – Nov 2021

Chicago, IL

Excel/VBA Application Developer

• 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. • Add-in features numerous dynamic, context-sensitive controls that allow user to select the target Word document, select items to be copied, and to retrieve additional data items from external Excel workbooks. • Add-in replaces time consuming and tedious manual copy operations that took up to an hour per Word document with an automated process requiring less than 5 seconds.

Cigna Health

May 2021 – Jun 2021

Bloomfield, CT

Excel/VBA Application Developer

• Developed Excel VBA script to perform a series of manual tasks requiring 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. • Developed standalone Excel/Word VBA mashup application that ingests and analyzes bookmarks from two different Word documents and compares properties of the shared bookmarks as well as lists those which exist in one document but not the other.

Winshuttle, Inc

Dec 2020 – Apr 2021

Bothell, WA

Excel/VBA Application Developer

• 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.

Trane Inc.

Aug 2019 – Nov 2020

Lexington, KY

Excel/VBA Application Developer

• 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.

CVS Health

Mar 2018 – Mar 2019

New York, NY

Excel/VBA Application Developer

• 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.

Mercer/CPSG Partners

Apr 2017 – Nov 2017

Dallas, TX

Excel/VBA Application Developer

• 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.

Molecular Imaging

Nov 2016 – Mar 2017

Ann Arbor, MI

Excel/VBA Application Developer

• 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 improve end user productivity and experience. • Created data extraction Addin to create CSV files from complex worksheets.

VOYA

Nov 2016 – Dec 2016

Minneapolis, MN

Access/Excel/VBA Application Developer

• 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.

Molecular Imaging

Oct 2015 – Oct 2016

Ann Arbor, MI

Excel/VBA Application Developer

• 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.

Kyle G. Mills Financial Marketing

Sep 2015 – Nov 2015

Fort Worth, TX

Excel/VBA Application Developer

• 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. • Automatically populates static data columns. • Automatically creates new spreadsheet with columns rearranged for export into Access database. Sophisticated text parsing code rewrites and adjusts formulas on new spreadsheet to reflect new locations of precedent columns. • Application reduces overall processing time from several hours to less than two minutes, thereby greatly improving client’s productivity and profitability.

Novosys, Inc

Oct 2014 – Feb 2015

Green Brook, NJ

Excel/VBA Application Developer

• Revised and enhanced several complex Excel applications with synchronized ActiveX controls, formulas, and custom macro code to provide end users with seamless navigation and efficient user interface.

Wells-Fargo Bank

Dec 2011 – May 2012

Minneapolis, MN

Excel/Access/VBA Application Developer

• 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.

American Stock Transfer & Trust

Apr 1997 – May 2011

Brooklyn, NY

Excel/Access/VBA Application Developer

• Vastly improved external and internal client data file conversion processes by developing many enterprise level applications in Access, Excel, Word, and Outlook 97-2003, 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.

Education

Rensselaer Polytechnic Institute

Sep 1983 – May 1986

Master of Science, Technical Communication

Rensselaer Polytechnic Institute

Sep 1979 – May 1983

Bachelor of Science, Physics

Adiv Abramson

Microsoft Excel VBA Automation Developer

Skills