| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Senior VBA /TSQL Manager/DeveloperGlen Allen, VA Street Address
EMAIL AVAILABLEPHONE NUMBER AVAILABLEStreet Address year veteran building and supporting complex Excel Spreadsheets, Access Databases, SQL Server databases, and MySQL databases.Managed development team of both domestic and foreign employees and subcontractorsDatabase Development Skills:Heavy use and modification of TSQL and VBA CodeHeavy use of recordset manipulationHeavy use of VBA to automate Excel/Word/OutlookIntegration 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 SkillsVisual 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 ZoomLight PHP /Java / Python HTML / Java script developer.Authorized to work in the US for any employerWilling to relocate anywhereWork ExperienceSenior Developer - Data ControlData Control, LLC - Richmond, VAJanuary 1998 to PresentScoped 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 workActuarial Applications Developer, - Fidelity InvestmentsDurham, NC hybrid remoteNovement 2022 to PresentWorked 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, KEJanuary 2021 to PresentContracted 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, NYJanuary 2002 to December 2004As 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, VAJanuary 2000 to December 2002As 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)EducationBachelor's degree in EconomicsUniversity of Delaware - Newark, DESeptember 1985 to May 1989SkillsExcel 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 / LicensesMicrosoft Certificed Solutions Developer (MCSD)January 2002 to PresentPassed the 4 core Microsoft Tests for this certificationMicrosoft Certificed Trainer (MCT)January 2002 to Present |
