VBA Development
Jeff Cooper
Report Analyst/VBA Developer
Norwalk,CT
Summary
Summary Analyze, process, cleanse and report large amounts of data. Expertise in Excel, Access, Tableau, PowerPoint, and VBA Programming. Develop in Access to create programs, databases, ETL applications, data analytic tools, and reporting tools. Program Excel workbooks to graphically represent data, (dashboards, charts, pivot tables), create Business Intelligence and Business Analysis tools. Seamlessly integrating MS Office applications to work cohesively together.
Overview
26
26
years of professional experience
4
4
years of post-secondary education
1
1
Language
Work History
VBA Developer/Access
Teachers Retirement System of NYC
New York, NY
07.2016
- A three-week assignment to develop Excel workbooks that create PowerPoint Presentations utilizing macros, modules, functions and classes
- Import user survey data from Excel Workbooks and combine them into a summary
- Create pivot tables, charts, and summaries
- Create PowerPoint presentations utilizing text boxes, animations and graphs, and charts in VBA
- DBA (Access, Excel, Outlook, VBA, Visio, Word)
VBA Developer
Assa Abloy
New Haven, CT
06.2017 - 08.2017
- Working with the vendor verification department to create a risk reporting system to assess the security and vulnerability of vendors making credit cards
- Modified a system to access the risk of and verify the accuracy of the data
- Analyzed, reported and imported data from Word documents
- Wrote, stored and reporting data in Access
- Created and programmed Excel workbooks to retrieve and analyze data from vendors
- Programmed PDF files from Access databases, Excel Workbooks or Word documents
- (Excel, PowerPoint, VBA, Word)
Data Analyst/VBA Developer
MasterCard
Purchase, NY
08.2016 - 05.2017
- Maintain and upgrade several Human Resource databases in Access
- Program and create Access applications in VBA
- Create, maintain and program macros in VBA for Excel workbooks
- Create and modify dashboards in Excel workbooks
- Write ETL and data cleansing programs in VBA to upload to a SAS database
- Assist with designing and implementing the Avilar Competency Management System
- Write and maintain reports in the Adobe Cold Fusion Report Builder from a SAS database
- Create and modify PDF documents in Adobe Acrobat Pro XI and DC Pro
- Program PDF documents in Adobe Acrobat Pro XI and DC Pro in JavaScript
- Create and update organizational charts in Visio
- Modify PDF documents in LiveCycle ES4
- Access, Excel, Outlook, Word)
VBA Developer/Access
Teachers Retirement System of NYC
New York, NY
05.2016 - 06.2016
- Developed Excel Workbooks to track time and leave reports for attendance, performance reviews and other HR reporting reports
- Analyzed and enhanced HR related Access databases that include images, emails, reports and Excel workbooks
- Modified existing Excel workbooks to change automated macros
- Document existing Access databases and Excel workbooks
- DBA (Access, Excel, Outlook, VBA, Word)
HR
02.2016 - 04.2016
- Analyzed and enhanced, related Access databases that include images, emails, reports and Excel workbooks
- Modified existing Excel workbooks to change automated macros
- Document existing Access databases and Excel workbooks
- Small VBA Projects
- Multiple Short Contracts
- VBA Developer (Access, Excel, VBA, Word) Remote
VBA programmer
11.2015 - 02.2016
- On short term projects for a few companies in Access and Excel.
VBA Developer/Data Analyst
GE Capital
Norwalk, CT
04.2015 - 10.2015
- Access, Excel, Postgre SQL, PowerPoint, VBA, Word), Developed a Risk reporting system utilizing Access, Excel, Postgre, PowerPoint, and Word
- Used Postgre queries to create reports for employees to analyze risk data
- Created Access database programs to do analysis for potential risks for GE Capital
- Created Access database to be able to create dynamic reporting for the employee to create own analysis tools and reporting
- Programed Access to be able to create Excel Workbooks, Dashboards in Excel, and PowerPoint presentations utilizing macros, modules, functions and classes
- Programmed Excel Dashboards to be able to do analysis from either the Postgre database, Access database or an Excel worksheet
- Analyzed data and wrote reports on vulnerabilities to GE Capital in Word and PowerPoint.
Access Developer/Data Analyst
Pure Insurance
White Plains, NY
12.2014 - 02.2015
- VBA, Word), Debug and document an Access databases that run on a nightly basis
- Improve and move processes from the Access databases to a SQL Server data warehouse.
Access Developer
Sunland Trading
New Canaan, CT
11.2014 - 12.2014
- Access, Excel, VBA, Word), Sunland Trading is a honey importer
- A one-month project to upgrade and improve Access databases that handled inventory, shipping, and invoicing.
VBA Developer /Data Analyst
Diageo
Norwalk, CT
02.2014 - 11.2014
- Access, Excel, VBA, Word), As part of changing to ServiceNow my role was developing applications for ETL, data migration and cleansing on User, Active Directory, CMDB, and ITIL information
- Responsible for requirements documentation, data cleansing, transformation, and validation of data
- The applications are developed Access, Excel, PowerPoint and Word utilizing macros, functions and classes.
VBA Developer /Data Analyst
Diageo
02.2013 - 10.2013
- This SAP data migration project took data from one instance of SAP to another for several Latin American countries
- Responsible for requirements, cleansing, transformation, and validation of data for Employee, Customer, Vendor, Credit, Material, Open Account Payables and Open Account Receivables
- Develop applications in Access, Excel and Word utilizing macros, functions and classes.
VBA Developer
Private Family Office
New York, NY
04.2012 - 06.2012
- Access, Excel, VBA, Word), Brought in to develop Access applications to track financial information, enabling users to create custom reports and Excel worksheets in Microsoft Office 2010 as part of this hi net worth facility upgrade.
VBA Developer/Data Analyst
Scotia Capital
New York, NY
04.2011 - 10.2011
- Access, Excel, Outlook, Sybase, VBA, Word), Developed a prototype back-office trading system for Fixed Income trades in Access
- Transfer data into Access databases from a variety of text documents, Excel Workbooks and Sybase databases as an automatic nightly run
- It did analysis and created emails to show any problems with the data import
- It created emails to show current state of investments and trades for potential problems and risks
- Used Access to recognize and alert employees of trade and investment differentials between databases or downloads
- Alerted employees for potential risk based on trading levels and past positions
- It gave the employee the ability to drill down the position or trade to the source or history of the position
- It also allowed the employee to reconcile trades and positions of the previous trading day
- It created reports and export to Excel workbooks on positions and trades
- Programmed Dashboards for a quick an easy way to show the current state of Fixed Income Trading at Scotia Capital utilizing macros, modules, functions and classes
- Also developed system for tracking everything an employee changed, opened or looked at on the above system in Access.
VBA Developer/Data Analyst
MasterCard
Purchase, NY
05.2010 - 02.2011
- Access, Excel, VBA, Word), Coordinated, gathered and defined data requirements for global card benefits data with account managers
- Designed / developed in Access report generation and data maintenance
- Designed and developed a forecasting tool on card benefit revenues and expenses
- Document and trained users on Access and Excel coding, process, and procedures.
VBA Developer/Data Analyst
Diageo
Norwalk, CT
11.2009 - 02.2010
- Access, Excel, VBA, Word), Develop databases to manage employee, machine and application data for upgrade to Vista and Office 2007
- Coordinate and verify requirements for user machines and applications
- Responsible for testing and development of Excel workbooks, Access databases and their Add-ins to verify compliance and operability in Office 2007 and Vista.
VBA Developer/Data Analyst
Diageo, SAP
Norwalk, CT
08.2007 - 04.2008
- Data migration project taking data from one region into another to create a single instance of SAP data
- Responsible for requirements, cleansing, transformation, and validation of data for Inventory, Pricing, Open Sales Orders, Customer Master, Product Allocation, and Open Account Receivables utilizing Access, Excel and Word.
Data Analyst/Developer
Credit Suisse
New York, NY
05.2003 - 02.2007
- Access, Excel, Oracle, SQL Server, VB.Net, VBA, Word), Set up tactical calculations and analysis tools for commercial lending, distressed assets, fixed/other assets, and open/failed trades as part of the Quantitative Impact Study team
- The QIS team oversaw monthly and quarterly reporting of impact assessment in changing from Basel I to Basel II banking regulations utilizing Access and Excel
- Designed and implemented numerous programs to analyze and report various data for business-as-usual processes in Access and Visual Basic Net compared to Access, SQL Server and Oracle databases.
Programmer
Clairol
Stamford, CT
05.2001 - 12.2002
- VB, VBA, Word), Developed programs to operate and retrieve information from various instruments conducting test on hair and skin into an Oracle or Access database utilizing Visual Basic, VBA, Excel, and Word
- The programs utilized the data to create Word documents or Excel Spreadsheets with charts, pivot tables, and a variety of images to illustrate the product claims
- The scientists could also create test results in Excel and load them into Access or Oracle to further analyze and document their results
- Designed and programmed methods and classes in Word and Excel to pull information from Excel, Access or Oracle to demonstrate results.
Programmer/Analyst
SAC Capital
Stamford, CT
02.1999 - 12.2000
- Developed programs to operate and retrieve information from various instruments conducting test on hair Programmed, maintained and supported applications for the back office of a hedge fund utilizing Visual Basic, Java, and Active Server Pages against SQL server databases
- Wrote ASP applications to track trader information, user services, industry information, and initial public offerings
- Wrote specifications, user manuals and installation instructions in HTML and DHTML.
Programmer
Port Inc
Norwalk, CT
06.1997 - 01.1999
- Access, Excel, Oracle, VB, VBA, Word), Programmed, maintained, and supported a call center and inventory management system in Visual Basic utilizing Excel, Word and Access with a SQL Server database that allowed users to enter, bill and ship from several warehouses
- Developed an inventory tracking and prediction application so manager could successfully chart sales, inventory, stock, and volume
- Previous experience available upon request or on LinkedIn
Programmer/Data Analyst
06.1986 - 05.1997
Education
Computer Science
Pace University
01.1982 - 01.1986
Skills
ContractData Analyst/VBA Developer (Access, Excel, Outlook, PowerPoint, SharePoint, VBA, Word)November 2018 to July 2020Created and maintain a 200 active user Access database to track and report time workedCreate and update complicated Excel sheets with macrosCreated PowerPoint Presentations and programmatically populated them from a variety of data sourcesModify Access databases, debug problems, gather user requirements and create reportsGather user requirementsCreate new and maintain Access databasesProvide requested data analysis from various data sourcesGather data from various data sources and generate to a report or presentationProgram in VBA and SQLProvide support Level 2 for MS Office productsProvide support Level 2 for ad-hoc requestsResolve data quality issues (Excel, Access, ShareRoom)WaterWorks, Danbury, CTExcel VBA Developer (Access, Excel, Outlook, Word)A August 2018 to September 2018One Month project Created, programmed and edited Excel workbooks with DAX, Power Query M, Power Pivot, Power Query, and VBA for Remediation and Sales reports Created an Access database to import data and be a temporary data source for Excel Wrote documentation for the above in WordTeachers Retirement System of NYC, New York, NY/RemoteVBA Developer/Access DBA (Access, Excel, Outlook, SAS, VBA, Visio, Word, JavaScript)
Software
SQL Queries
SQL Programming
R Programming
Tableau
M Programming
MS Access
Excel
Power point
MS Teams
Python
Outlook
Share point
Word
Interests
Beagles, Compter Learning, Hiking,
Timeline
VBA Developer
Assa Abloy
06.2017 - 08.2017
Data Analyst/VBA Developer
MasterCard
08.2016 - 05.2017
VBA Developer/Access
Teachers Retirement System of NYC
07.2016
VBA Developer/Access
Teachers Retirement System of NYC
05.2016 - 06.2016
HR
02.2016 - 04.2016
VBA programmer
11.2015 - 02.2016
VBA Developer/Data Analyst
GE Capital
04.2015 - 10.2015
Access Developer/Data Analyst
Pure Insurance
12.2014 - 02.2015
Access Developer
Sunland Trading
11.2014 - 12.2014
VBA Developer /Data Analyst
Diageo
02.2014 - 11.2014
VBA Developer /Data Analyst
Diageo
02.2013 - 10.2013
VBA Developer
Private Family Office
04.2012 - 06.2012
VBA Developer/Data Analyst
Scotia Capital
04.2011 - 10.2011
VBA Developer/Data Analyst
MasterCard
05.2010 - 02.2011
VBA Developer/Data Analyst
Diageo
11.2009 - 02.2010
VBA Developer/Data Analyst
Diageo, SAP
08.2007 - 04.2008
Data Analyst/Developer
Credit Suisse
05.2003 - 02.2007
Programmer
Clairol
05.2001 - 12.2002
Programmer/Analyst
SAC Capital
02.1999 - 12.2000
Programmer
Port Inc
06.1997 - 01.1999
Programmer/Data Analyst
06.1986 - 05.1997
Computer Science
Pace University
01.1982 - 01.1986