JEFF B. GOODMAN

ac05gl@r.postjobfree.com

OBJECTIVE

To contribute to robust business solutions and test environments using .NET/MS Access (version 2.0 – 2013)/VBA/SQL Server/SSIS/SSRS/Oracle/VB6

QUALIFICATIONS

Rich experience working with clients/end-users to design, create, test, document and implement custom MS Reporting Services, VBA, VB6, SAP Business One SDK, MS Access, Excel, databases, user manuals and web sites

Experience with design requirements, systems analysis, MS Office automation, UAT scripts and implementation, VBScript, VBA, SQL Server, Access ADP/MSDE, database conversion (Access 2.0-Access 2013). .NET, SSIS

Experience with compensation, commissions and incentive data, workflow and reports, data reconciliation

Extensive experience with data merge, scrub and cleanse from disparate data sources

Rich experience creating complex work flow applications referencing disparate data sources

OOAD

Extensive experience with complex logic, business rules and Windows forms

EXPERIENCE

VIRGIN GALACTIC/THE SPACESHIP COMPANY 11/2016 - PRESENT

MS Access/MS Excel Developer

Create complex MS Access database to store and update MBOM and EBOM data for the design and manufacturing of sub-orbital space ships

Support and modify multiple MS Access databases for storing and updating FAA-required documentation for sub-orbital spaceship and mothership

EXPRESS SCRIPTS 5/2016 - 11/2016

MS Excel/MS PowerPoint Developer

Created complex formatting process to integrate existing MS Excel workbook into PowerPoint

Extensive VBA coding for PowerPoint and Excel DOM

Project was completed early and under budget

MEDTRONIC 8/2015 - 4/2016

MS Access Developer

Create manual ETL processes (MS Access and MS Excel) for translating 40,000 Covidien product licensing data for Medtronic SAP upload for 34 countries

Extensive data scrub, cleanse and merge

Create ad hoc reports for senior management

CROWLEY, WHITE, HELMER AND SEVIG 9/2014 - 7/2015

MS Access Developer

Created complex MS Access databases to track campaign activities for non-profit fund raising projects

Complex business rules, mail merge and reporting

CISCO/FEDEX 10/2015 - 2/2016

MS Access/MS Outlook Developer

Created MS Access/MS Outlook application to customize, send and track emails for 1700 FedEx outlets nationwide

4COM 7/2014 - 3/2015

SQL/.NET developer

Rewrite complex MS Access database into .NET/SQL solution for TV programming distribution company, including stored procedures, triggers and views

Troubleshoot and repair existing complex MS Access database including generating ad-hoc reports as needed

Debug complex stored procedures

TARGET 6/2014 - 11/2014

VB6/MS Access/VBA/Excel developer

Converted complex Excel spreadsheet to MS Access for project estimations

Implemented complex business rules (including logarithmic functions) to estimate FTEs, hours and cost for projects ranging from 2-18 months

Created front-end/back-end architecture to allow n-users to utilize database using single back-end

Assisted in legacy VB6 support

WELLS FARGO 7/2010 - 6/2014

MS Access/VBA/Excel developer

Create and maintain multiple, complex MS Access databases (versions 2003, 2007 and 2010) for Wealth Management Fees/Wachovia integration/Sales and Treasury Mgmt/Risk Compliance.

Create and maintain multiple processes for Cash Vault and AML data reconciliation

Implement complex business rules across multiple work-flow projects, complex reports, batch processing

Extensive MS Word automation including dynamic margins, bookmarks, embedded bookmarks, spacing, paragraph insertion and spacing, blank page removal, headers, footers

Create UAT scripts and manage UAT across multiple states

Create and support Tableau work books

Create and maintain SQL Server tables, functions and stored procedures for ODBC-connected MS Access databases

Created MS Access and Excel reports using AS/400

Create and maintain Info path forms

Create SSIS packages and .NET scripts consuming large data sets (>100M records)

Support multiple, multi-user MS Access databases for >150 users throughout the US

GENERAL ELECTRIC CAPITAL FINANCE 1/2010 – 6/2010

MS Access/VBA/Excel developer

Create and maintain multiple MS Access databases for sales commissions and fleet services for GE nationwide

THOMSON REUTERS 1/2008 – 7/2010

MS Access/VBA/Excel developer

Created and maintained 100+ commissions, compensation and incentives reports for sales representatives (approx. 1500) for Thomson Reuters nationwide, created table-driven process to automate report updates and design changes allowing for 1 programmer to support entire reporting process for the sales dept., extensive use of crosstab queries, manual ETL for disparate data sources (SQL Server, Oracle, Excel, text-delimited files), worked with commissions, payment, compensation and sales managers creating ad-hoc reports and applications for sales, compensation, commissions and payment detail, extensive data reconciliation for sales comp. and bonuses, extensive use of automating Excel and MS Access for workflow processes and reporting, created multiple automated (overnight) batch processes for ETL data for multiple departments

THE TWIN CITIES FINANCIAL CONSULTING GROUP 12/2008 – 6/2009

MS Access/VBA/Excel developer

Created MS Access 2003 database for National Community Stabilization Trust (http://www.stablecommunities.org/topics/NCST) to allow buyers and sellers of foreclosed properties to communicate, database will be business model for nationwide rollout of NCST applications and websites, database includes complex business rules and logic

COLD SPRING GRANITE 10/2006-4/2007

MS Access developer

Created complex estimating and pricing tool using Access 2003 and SQL Server 2005 back-end (stored procedures and triggers)

Created small VB6 interface with SQL backend to track production errors

Complex UI with large number of integrated business rules

GMAC-RFC 2/2004 – 3/2006

MS Access/VBA/Excel developer

Supported trading desk for mortgage-based transaction

Supported extensive batch files, VBScript, Windows Scripting processes

Assisted in rewrite, support and creations of daily reporting process for robustness and accuracy

Extensive MS Excel and MS Access support and development

Implemented SQL Server 2000 Microsoft Reporting Services, MS Outlook automation and custom forms

Data scrub, cleanse and merge from multiple systems and platforms including Bloomberg, Excel, Access, VB6, Word, SQL Server, Oracle and DB2

2/2004 – 8/2004, Database and application developer, Nationwide (contract)

Application Developer (contract)

Assessed, converted and migrated 80,000 MS Access databases for GMAC-RFC nationwide

Implemented Converter Technology’s Office Converter

Supported 4000+ end-users

Project was completed on time and within budget

MEDTRONIC 4/2003-8/2008

MS Access/VBA/Excel developer

Retooled and enhanced MS Access database used for tracking heart valve machining and manufacturing data

Implemented regression testing, weighted averages, complex formulae within multiple processes

Implemented extensive MS Access and MS Excel automation

Created complex forms and reports for manufacturing, education and training purposes

Worked with multiple depts./sales managers to create hotline application utilizing MS Access/Oracle back-end for Medtronic sales and training of 400 products

Implemented Oracle back-end, pass-through queries, extensive GUI manipulation, complex business rules for multiple applications

Created automating reporting system for CareLink services and products with reports sent to 93 district sales managers nationwide

Creating SMS-supported hardware/software-tracking database (for Medtronic worldwide - 40,000 network-connected devices) with integrated VBA, SMS, SQL, Created .NET interface for data viewing SMS-gathered data

SQL Server 2000, Oracle, 3-party and homegrown software applications

Created complex staging, data scrub, cleanse, and merge processes for heart-valve manufacturing

DELOITTE AND TOUCHE 8/2004-2/2005

MS Access/VBA/Excel developer

Created multiple and varied MS Access and MS Excel processes to cleanse, scrub and merge data for Fortune 100 clients

Managed large, complex data streams (DB2, Oracle, SQL Server) for data staging

Extensive data merge and analysis for GL, commissions and data reconciliation

WELLS FARGO 9/2001- 7/2003 MS Access/VBA/Excel developer

Created, enhanced, converted, maintained and documented multiple MS Access 97/2000, MS Excel and VB6 applications and interfaces for various departments

Experience with payroll and 401K/investments

Consume AS/400 data for reporting and data analysis

Developed complex, LAN-based VB/Access 2000/Oracle 7.3 workflow applications with multiple back ends using: Word, Outlook, Excel, ADO, ODBC, DAO, timed synchronization, combinations and permutations for matching processes

Complex algorithms for data manipulation

Created custom MS Outlook forms and complex reports

Assisted with department-wide conversion from Access 97 to Access 2000

HONEYWELL AEROSPACE AND DEFENSE 1/2003 – 4/2003

MS Access developer

Worked with sales managers to enhance existing Access 97 database for ease of use, data display, and price-tracking, modified and optimized existing table and forms

Estimated time savings: 1440 hours per year

WEST GROUP 7/1997-7/2000

Software engineer, Eagan, MN

Team member that assisted in the design and creating of a large 3-tier automated CD test/QA application that utilized Crystal Reports, VB 6, QARun, Access 97, SQL Server 7, VBScript, HTML, ASP 3.0, project saved $1M over 24 month period

Created multiple custom utility programs using VB6 for related CD QA tests

Created intranet website for online documentation

Lead Y2K departmental programmer, tested or modified 750 existing PL/1 programs for Y2K compliance

Created training curriculum and training manuals for Y2K project for multiple departments Y2K project brought in early and under budget

Supported large proprietary Powerbuilder/Sybase application and provided related training and documentation for 75 end users in 4 states

Created proprietary text conversion programs using PL/1 in an IBM MVS environment using JCL, TSO and Expediter

Maintained and debugged PL/1 programs while concurrently testing for Y2K-related problems

GOOD SENSE SNACKS (WAYMOUTH FARMS) 5/2001-8/2006

MS Access/VB6 developer

Created multiple VB6/MS Access applications including: 2-tier applications using VB6/MS Access 2002 and VB6/SQL Server 2000

Created stand-alone Access 2002 databases to interface with MAS90 for shipping, sales forecasting and machine efficiency

Implemented statistical formulae for Excel reports and graphs

Created complex reporting tool to predict inventory needs for 1200 products (supply chain)

ADDITIONAL CONTRACT WORK

SAP Business One SDK developer, release 6.2-6.5

Utilized VB6 (with some .NET) to create multiple custom forms for quote, contact functionality

Extensive use of UI, DI, DTW, experience with UI and DI object models

Familiarity with and use of B1 SQL Server backend

8/2003 – 12/2003, Database developer, Person-to-Person, Minneapolis, MN (contract/volunteer)

MS Access developer

Enhanced existing and complex Access 2000 database and Excel spreadsheets for low-income housing non-profit organization

Experience with Section 8, tenant-landlord, rent and eviction issues as they relate to data and reports

1/2000 – 3/2000, Database developer, Family Tree Health Clinic, Minneapolis, MN (contract)

MS Access developer

Converted Access 2.0 to Access 2000 database for use in phone tracking/hotline data, normalized tables, extensive data scrub, conversion and merge

6/2000 – 9/2000, Associate instructor, St Mary's University, Mpls., MN (contract)

Associate instructor

Created curriculum and documentation for, and instructed college students in, web design and dynamic web pages using ASP 3.0, VBScript, HTML, ADO, Access 2000

1/2000 – 7/2000, Program analyst, Access Cash, St. Paul, MN (contract)

VB6 developer

Created automated utility subprograms/interfaces to enhance large VB 6, DB2 and Access 97 application

Assisted other team members with system programming (PERL/C) duties and web duties (ASP, HTML)

7/1998-12/2001, Application developer, software trainer, Class Partners, Mpls., MN

Trainer and developer

Trained corporations for beginning and intermediate MSOffice products

Developed websites using VB6, ASP 3.0, VBScript, HTML, JavaScript, ADO, Access 97/2000, and SQL Server

Created SMB applications and websites for various clients

Created MS Access ADE/ADP/MDE databases

Experience with upsizing Access to SQL Server 2000

EDUCATION

Metropolitan State University, St. Paul, MN

B.A. Information and Computer Sciences

B.S. Mathematics, (expected graduation in 2020)

ORGANIZATIONS

Mensa

Aircraft Owners and Pilots Association

Contact this candidate