SUMMARY:

Extensive data conversion development experience with VBA based solutions integrating Confidential Excel, Access, Outlook, Word, SQL Server 2000, VB6 and other tools. Solid understanding of data import/export tasks, file formats (e.g. CSV, BAI et. al.) and conversion requirements for major business clients ( Confidential, Confidential etc.) and financial institutions ( Confidential, Confidential, Confidential, Confidential ). Developed multiple automated solutions to connect Excel/Access to diverse desktop and enterprise data sources such as Access, FoxPro, SQL Server 2000, Crystal Reports and DB2 for data extraction, analysis, scrubbing, transforming and loading to/from in - house storage systems. Extensive experience creating hybrid applications utilizing automation in VBA, VB6 and VBScript. Prior experience with developing custom EDI mapping and parsing software for processing 810, 816, 850, 860, 864 and 997 files.

EXPERTISE AREA:

• VBA (macros, user forms, ActiveX, classes)
• Office/workflow automation
• Regular Expressions
• Confidential Excel 97 - 2016
• SQL, SQL Server 2000 (DTS)
• Data import, export, parsing, scrubbing, conversion
• Confidential Access 97 - 2016
• Visual Basic 6
• Application development
• Database design
• UI design (forms, menus, Ribbon)
• Technical documentation

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Excel/VBA Application Developer

Responsibilities:

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

Confidential, Ann Arbor, MI

Excel/VBA Application Developer

Responsibilities:

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

Confidential, Minneapolis, MN

Access/Excel/VBA Application Developer

Responsibilities:

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

Confidential, Ann Arbor, MI

Excel/VBA Application Developer

Responsibilities:

• 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.
• Developed Ribbon UI driven Access relational database application for tracking complex measurements and formulas programmatically imported from an Excel workbook.

Confidential, Fort Worth, TX

Excel/VBA Application Developer

Responsibilities:

• 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.
• Automatically transposes and denormalizes hundreds of data rows for export to Access table where it will be used by Tableau for reporting.
• Application reduces overall processing time from several hours to less than two minutes, thereby greatly improving client’s productivity and profitability.

Confidential, St. Paul, MN

Excel/VBA Application Developer

Responsibilities:

• Developed internal insurance summary reporting tool with dynamically displayed subsections, automated data entry and validation, print to PDF functionality and a sophisticated, responsive Ribbon UI.

Confidential, Tigard, OR

Excel/VBA Application Developer

Responsibilities:

• Coded several complex macros to automate numerous formatting and editing operations on multi thousand line CSV data files, eliminating hundreds of hours of manual labor.
• Coded macro to extract and reformat product item sizes from PDF catalog.
• Created CSV file processing application with custom menus and numerous data manipulation features that drastically reduce file processing time and labor.

Confidential, Green Brook, NJ

Excel/VBA Application Developer

Responsibilities:

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

Confidential, Tualatin, OR

Excel/VBA Application Developer

Responsibilities:

• Enhanced and upgraded Excel based quotation configurator with VLOOKUPs, ActiveX controls, a context sensitive multitab UI form and dynamic SQL statement composition for extracting source data from Access/SQL Server.

Confidential, Atlanta, GA

Excel/VBA Application Developer

Responsibilities:

• Developed custom VBA application to automatically extract and transform patient billing data from complex input files.
• Coded sophisticated and efficient data location routines, UI forms and error handling.
• Delivered fully functional solution in only 30 hours.

Confidential, Vancouver, WA

Access/VBA Application Developer

Responsibilities:

• Developed an Access program to automatically detect and report on sequence number gaps in a reference table, providing a solution to an urgent business need for which none had been previously been available.

Confidential, Portland, OR

Excel/VBA Application Developer

Responsibilities:

• Developed Excel Addin application for automated parsing and reformatting several types of plain text reports that will be submitted to government agencies into Excel spreadsheets featuring dynamic Ribbon controls that adjust based on a file system folder’s contents.
• Application saves employees many hours of tedious manual labor each month.

Confidential, Minneapolis, MN

Excel/Access/VBA Application Developer

Responsibilities:

• Developed an Access application that imports, parses and uploads complex and difficult to process trading transaction error report files into Access tables for further integration with enterprise wide reporting system.

Confidential, Portland, OR

Excel/Access/VBA Application Developer

Responsibilities:

• Created custom data processing business solutions using VBA, Excel, Access and Word featuring innovative programming techniques that included on the fly creation of Word documents with event procedures; a sophisticated customer name parsing function for Excel; an automated text data splitter for Excel; a product code parser and reformatter; and a regular expressions testing application in both Excel and VB.NET 2010 with several advanced features including display of matches and groups by position; input, output and saved RegEx panes; an XML data store; adjustable mode operators, replace functionality and a Match Evaluator for in situ manipulation of matched strings.

Confidential, Minneapolis, MN

Programmer/Analyst

Responsibilities:

• 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 deployed over 20 custom dynamic reports to support end user analysis requirements, thereby greatly simplifying research tasks and enabling outstanding issues to be more quickly identified, addressed and resolved. Composed end user documentation including step by step UI guide and operating instructions.
• 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. Application has significantly enhanced department manager’s ability to track, update and report on numerous projects. Composed end user documentation including step by step UI guide and operating instructions.
• Designed and developed ongoing Access 2003 database housing deal solution using sophisticated VBA macros to import, parse and transform very complex financial data from dozens of Excel spreadsheets into a centralized database solution which will provide sophisticated reporting and analysis functions that greatly simplify and enhance debt service management and tracking. Created and coded unique UI featuring multiple synchronized listbox and multitab controls that has been adopted by management and other developers as the standard for similar projects in the department.

Confidential, Brooklyn, NY

Programmer/Analyst

Responsibilities:

• Generated millions of dollars in revenue/labor cost savings and vastly improved external and internal client data file conversion processes by developing a large number of enterprise level and ad hoc applications in Access, Excel, Word and Outlook for Office 97-2003, including proxy file conversions, shareholder list and related certificate history file conversions; surrender file processing; ACH transaction file processing (multiple types); BAI1 and BAI2 file processing; direct debit and direct deposit file processing and reporting; escheatment file processing; 1099 data processing; IRS tax record processing, et. al.
• Ported several mission critical Excel/Access 2003/VBA based applications to VB6 with SQL Server 2000 backend data storage and DTS for automated processing of many complex data file types.