Jon Jaeger

Senior VBA /TSQL Manager/Developer

Glen Allen, VA 23059

ad18c8@r.postjobfree.com

+1-804-***-****

** **** ******* ******** *** supporting complex Excel Spreadsheets, Access Databases, SQL Server databases, and MySQL databases.

Managed development team of both domestic and foreign employees and subcontractors

Database Development Skills:

Heavy use and modification of TSQL and VBA Code

Heavy use of recordset manipulation

Heavy use of VBA to automate Excel/Word/Outlook

Integration with HTML (using VBA to build HTML and push to sites / emails)

Frequent integration with SQL Server, MySQL, SAP, JD Edwards, Timberline, Quickbooks and other ERP/Accounting systems.

Excel VBA skills:

25 years experience developing, modifying and improving Excel workbooks using advanced VBA and functions. Heavy use of arrays, user defined functions, form building, data loading from Sybase and Azure SQL. Built and modified routines to perform SQL functions on Excel tables. Interaction with Microsoft Access to perform regression analysis. Worked in a team environment with both domestic and overseas developers. Interfaced daily with both domestic and overseas users of spreadsheets.

Management skills:

Interview, ascertain skills, assign projects. Follow up on projects, performance reviews interviews and raises. Firing when performance failed.

Managed projects of development teams. Established scope, deliverables and milestones to client's satisfaction. Brought in additional resources when needed. Helped developers push back on scope creep.

Used a variety of tools for remote communication with both foreign and domestic employees and contractors.

Foreign contractors included Pakistan, India, Russia, Philippines and Kenya.

Other useful IT Skills

Visual communication with clients with screen prints. Project Management skills including estimated budgets, estimated timelines, coming in on those budgets and timelines, pushing back on scope creep, adding project change scope requests.

Process management with various tools including JIRA (as well as dashboard creation), Confluence for documentation, Murals for team meetings, Teams and Zoom

Light PHP /Java / Python HTML / Java script developer.

Authorized to work in the US for any employer

Willing to relocate anywhere

Work Experience

Senior Developer - Data Control

Data Control, LLC - Richmond, VA

January 1998 to Present

Scoped out projects, provided budgets, developed over 300 Access databases for clients. Clients include the US Navy, Army, Air Force, Marines, the State governments of Virginia and Maryland and Fortune 500 Companies including Carmax and DuPont.

Recognized expert in Microsoft Access.

Hired other developers and managed their work.

Hired contractors of other development platforms and managed their work

Actuarial Applications Developer, - Fidelity Investments

Durham, NC hybrid remote

Novement 2022 to Present

Worked as part of a team attacking a 1,000 project backlog of Excel workbook issues across multiple clients. Required advanced knowledge of VBA including arrays and user defined functions and calls/ modifications to add in functions. Included data loaders from Sybase and Azure SQL. Regression analysis and code reviews performed for every solution implemented. Daily use of Jira and Confluence to manage workflow, documentation, and training materials.

Senior Developer - Volcafe (Contractor)

Volcafe, Switzerland - Nairobi, KE

January 2021 to Present

Contracted by Volcafe's EDF division in Nairobi, Kenya to build an auction, production, and shipping management system. The Office buys coffee at auction and then processes and delivers the coffee worldwide.

Senior Developer - Pepsi Bottling Group (Contractor)

Pepsi Bottling Group - Somers, NY

January 2002 to December 2004

As a contractor, began migrating an Excel mess for the Newport News bottling plant. Headquarters used that as a prototype to roll out the 'PTS' (Production Tracking System) company wide across the USA, Canada and Puerto Rico.

While supporting this database after implementation, began building a variety of plant specific databases for the Pepsi Concentrate Business, the Tulsa OK plant and other smaller projects.

Senior Developer - (Contractor)

Capital One - Richmond, VA

January 2000 to December 2002

As a contractor, scoped, built, implemented and supported 14 different Access database throughout Capital One. Such databases included the Chariot budget management tool, the Jones Lang and LaSalle construction project management database and an Art Management database (tracking location/value/insurance of Art on Capital One campuses)

Education

Bachelor's degree in Economics

University of Delaware - Newark, DE

September 1985 to May 1989

Skills

Excel VBA (25 years)

Access VBA (25 years)

Microsoft Access (25 years)

HTML5 (5 years)

MySQL (10 years)

Microsoft SQL Server (25 years)

Relational databases (25 years)

Software development (25 years)

ETL (10 years)

SSRS (10 years)

SSIS (5 years)

T-SQL (25 years)

Database design (25 years)

Visualizations with Power BI and Tableau (5 years)

Airtable (1 year)

Smartsheet (1 year)

Certifications / Licenses

Microsoft Certificed Solutions Developer (MCSD)

January 2002 to Present

Passed the 4 core Microsoft Tests for this certification

Microsoft Certificed Trainer (MCT)

January 2002 to Present

Contact this candidate