Sql Server Business Intelligence
Resume:
Jon Jaeger
Senior VBA /TSQL Manager/Developer
Glen Allen, VA 23059
*******@**************.***
** **** ******* ******** *** 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