SUMMARY:

Excel VBA/MS Access Database Developer with data analysis, SQL, and VBScript experience. Over 10 years experience, including 5 years in the financial services industry. Extensive experience with object oriented programming OOP, writing classes , change events, add-ins, API calls including 3rd party APIs , early vs. late binding, passing arguments ByVal vs. ByRef, executing SQL within Excel using data from within Excel as well as from external sources, creation of pivot tables both manually and programmatically, creation of UserForms and input boxes to collect user input, creation of custom ribbon tabs and buttons using XML. Excel/Access 2013, 2010, 2007, 2003. I also have a basic understanding of derivatives call and put options, interest rate derivatives .

Confidential

• Excel VBA
• Maintenance and enhancement of existing large scale, complex Excel applications
• Contributed to the development of new large scale, complex Excel applications
• Wrote a class to populate data fields across multiple sheets depending on user selections. Integrated classes I previously wrote to execute SQL queries within Excel to gather the data and populate the data fields. This code was executed within sheet level events depending on user inputs and actions.
• Development of large, complex Excel application from scratch
• Used SQL to transfer data from an existing spreadsheet used as a user input form into another spreadsheet as line items that the business uses as an intermediary for loading into a third party application.
• Used XML to create custom ribbon tabs and buttons. Used VBA to manipulate the buttons while the application was running e.g. enabling and disabling buttons depending upon other variables .
• Wrote a class to convert a variable string into a property and associate it with an Excel object. This allowed me to looped through an array of combobox names and change their properties such as enabling/disabling, clearing contents, etc.
• Wrote code to allow users to click a shareholder in a list and a detail report is generated for that shareholder
• Worksheet change event is used to detect click and generate report
• Access
• Maintenance and enhancement of existing databases
• Used VBA to create dynamic SQL statements table creation, select, insert into, add columns, etc.
• Used DAO recordsets
• Modified existing tables, forms and subforms, reports, queries, and VBA code
• Modified queries in SQL mode to handle multivalue fields coming from tables linked to Sharepoint
• VBScript
• Wrote a script to restore Excel settings that get changed by VBA code and are not reset if the code does not run to completion. This was done in VBScript so that an Excel Application object could be created and opened from outside of Excel because some settings were preventing Excel from opening properly. This sped up development by eliminating the need to manually reset multiple options every time code was stepped through or an error was encountered.
• Wrote a script to automatically email my timesheets as an attachment using Outlook.

Confidential

Excel VBA

• Imported text and csv files

• Wrote code to automatically consolidate data and generate reports for the Underwriting Department
• Used DAO to move Excel data into Access
• Linked Excel pivot tables to Access databases using MS Query
• Used MS query, DAO, and ADO to connect to external data sources
• Performed queries and recordset navigation using ADO
• Wrote code to automatically synch related pivot tables on filtered values
• Created forms to accept user input
• Created and distributed add-ins
• Created classes OOP to:
• perform SQL queries on Excel spreadsheets, Access databases, or SQL Server databases and return the results to either a spreadsheet or to a recordset for further use within the cod

• get file paths from spreadsheets
• download files from the Internet or Sharepoint using an API call
• Connect/disconnect from HP Quality center
• Map HP Quality Center database column names to the column names seen by the user so that the developer does not have to know the database column name when programming, they can use the collection of mapped column names to reference the fields by the user friendly name
• Programmatically created and manipulated Active-X controls and objects such as buttons and pivot tables
• Automated export of HP Quality Center data using the OTA API 3rd party API in VBA
• Reverse engineered existing macros to improve speed, enhance functionality, and fix issues discovered during the review of the code
• Gathered requirements and documented new and existing processes
• Liaison between business and SQL Server development team for conversion of Access databases to SQL Server
• Access
• Created relational databases in Microsoft Access

• Normalization of data
• Used junction tables to create many to many relationships
• Used SQL to perform complex queries
• Created forms, subforms, and reports
• Automatically populated databases with Excel data using VBA
• SQL
• Wrote SQL statements to extract data from Excel, Access, and SQL Server

Confidential

Senior VBA Developer NH

• Resolved spreadsheet issues resulting from an upgrade from Office 2003 to Office 2007
• Fixed missing library issues
• Developed user forms to replace functionality dependent on a feature retired in Office 2007
• Developed a timesheet for a large pharmaceutical company that had just gone through a merger with another large company and needed an interim solution until their systems could be merged
• Created system in Excel to collect and report on time and work codes
• Included functionality to export the data to a tab delimited file for uploading to a SAP system
• Designed a database to integrate information from various excel sources into a single consolidated access database
• Developed PivotTables and PivotCharts to translate complex data into customizable visuals
• Integrated and analyzed disparate sources of data to draw conclusions
• Automated with VBA the process of downloading email attachments, normalizing and concatenating the data, and uploading to Access databases
• Connected spreadsheets to external data sources for data analysis
• Wrote queries in Access to extract data and perform calculations
• Automated Excel processes with VBA including
• Performed text file reading and writing operations
• Generated and ran custom VB scripts
• Manipulated external programs
• Automated data import / export operations
• Recoded existing Access databases to account for version migration issues and implement user change requests
• Wrote simple web page, using HTML, for SharePoint site
• Developed Excel VBA code for reporting of financial data

Confidential

Project Analyst / Excel VBA Developer

• Responsible for VBA Developer and Program Management tasks related to two large server migration projects with very aggressive schedules
• Develop new macros and analyze existing VBA code
• Modify macros as necessary
• Identify data dependencies and assess impact/risk to business of changes
• Provide written and oral communication to all levels of the organization
• Create and distribute weekly project status PowerPoint presentation to senior management in Boston and New York offices
• Attend meetings to update senior management on projects status
• Communicate timelines, deadlines, and information to end users and team members
• Provide real time user support to ensure uninterrupted business operations
• Listen to and act upon user concerns
• Collaborate with different departments to identify risks and devise solutions
• Delegate tasks as appropriate to ensure continued progress of projects

Confidential

Reporting Data Analyst Quality Assurance

• Monitor performance of multiple Business Areas against company goals
• Maintained knowledge of continually evolving company policies and procedures and ensure compliance
• Developed and disseminated reports, metrics, and presentations. Provided support to team members and projects as needed.
• Developed and maintained Access database to track milestones
• Used Access VBA and SQL to achieve advanced functionality and automation.
• I developed this database in response to my observation that the current system was not serving the team well and providing needed information in a timely manner. Conversion to this database resulted in:
• Clear, up to date information, including historical logs of changes and commentary
• Early identification of potential problems, allowing proactive measures to be implemented
• Accurate year end projection of results
• Automated complex calculations and routine report generation through the use of custom functions and VBA code Access, Excel, and Word utilizing the following constructs:
• Conditional statements If and Select Case , loops Do and For , arrays multidimensional and dynamic , subroutine calls, argument passing, user forms, object properties and methods
• Created complex graphs, tables, and PivotTables/PivotCharts in Excel to present, simplify, and distill data
• Devised and maintained tracking systems to ensure that key events and deadlines were communicated and monitored
• Created presentations for senior management using PowerPoint