Thomas J. Johnson

215-***-**** *** Westtown Way West Chester, PA. (actiql@r.postjobfree.com)

SKILLS SUMMARY

Data Warehouse Tools: MS Access/Excel, VBA, SQL Developer, SQL Server 2008 R2, and SQL Server 2012

Reporting Tools: Crystal Reports, Excel, MS Access

Languages: Visual Basic 6.0, Microsoft VBA, SQL

Applications: Windows 95,98,2000 Windows NT, Windows 8.1, Microsoft Access 1.0, 1.1, 2.0, 95, 97,2000, 2003, 2007, 2010, TSQL, PLSQL, SQL Developer, SSMS, Microsoft Word 6.0&7.0, EXCEL 2010,

Microsoft PowerPoint, MS Office 2010, SSMS, and SQL Server 2012.

Clearance: Top Secret

PROFESSIONAL EXPERIENCE:

Allied Technologies & Consulting, LLC 1/2012 -present

MS Access 2010/Excel Programmer2010/Software DeveloperIII/Team Lead

Develop custom MS Access2010/Excel 2010 applications to work on SQL Server 2012 platform. Design and develop complex user interface for tracking of projects and financials across multiple departments of the US Army medical Corps. Develop stored procedures and SQL queries using SSMS. Develop Excel 2010 report interface for Excel 2010 based reports.

Dow Chemical 7/2011 -1/2012

MS Access 2007/Excel Programmer2007/Developer (contractor)

Develop MS Access/SQL Server 2008 R2 application to track and report company projects across multiple lines of business. Develop Excel 2007 application interface for input/output to and from MS Access application and SQL Server 2008 R2 database to track progress and financials of company projects.

JP Morgan Chase 1/2011 – 7/2011

MS Access 2007/Excel Programmer2007/Developer (contractor)

RAD development of multiple Access 2007 and Excel 2007 applications covering multiple platforms used for finance processing and reporting within the investment banking department. All applications are built using VBA and SQL.

Blue Cross Blue Shield Association (Washington DC) 8/2010 – 12/2010

MS Access 2007/Excel Programmer2007/Developer (contractor)

Design, build, and implement new MS Excel 2007 application. VBA, development of Excel 2007 report application.

Freddie Mac 4/2010 – 7/2010

MS Access 2000/Excel Programmer/Developer (contractor)

Design, build, and implement new MS Access 2000 EUC application. VBA, SQL development of Access based end user reporting application with form driven user interface to manipulate data and produce static and adhoc excel reports. Responsibilities included creating new Access application using VBA, SQL queries, forms and creating Excel reports using visual basic for applications.

Cephalon, Inc. 9/2008 – 6/2009

MS Access 2003/Excel Programmer/Developer (contractor)

Design, build, and implement new MS Access 2003 EUC application. VBA, SQL, PLSQL development of Access based sales reporting application with User interface to produce dynamic excel reports for territory based sales groups. Responsibilities included creating new Access applications using VBA, SQL queries, and creating dynamic Excel reports for Sales Operations group from Oracle data sources using PLSQL and SQL Developer. Also development of Excel reporting applications using Visual Basic with data connections from Oracle to Excel and maintenance of existing MS Access EU database applications.

DEPT. of NAVY 11/2007 – 09/2008

MS Access 2003/Excel Programmer/Developer/Data Architect (contractor)

new MS Access 2003 EUC Application Development. VBA, SQL development of Access based technical reference application with User interface and reporting capabilities. Responsibilities included design, development, implementation, and training of database tables, forms, and reports using VBA and SQL.

GlaxoSmithKline 4/2007 – 12/2007

MS Access 2003/Excel Programmer/Developer/Data Architect (contractor)

Maintain and update current MS Access EU database application and design/develop a new MS Access 2003 application for tracking sales incentive payouts. Also provide ad-hoc reports from existing Access and Excel data.

VBA and SQL coding. Forms and report development, VBA import coding for existing Excel documents.

VWR INTERNATIONAL 12/2006 – 4/2007

MS Access 2003 Programmer/Developer/Business Analyst (contractor)

Design and develop a new MS Access 2003 EU application for tracking project manager progress on IT projects and track budgets and invoicing.

VBA and SQL coding. Forms and report development, VBA import coding for existing Excel documents.

DUNN & BRADSTREET 11/2006 – 12/2006

MS Access 2003 Programmer/Developer/Business Analyst (contractor)

Develop new MS Access Sales end user interface and backend database application. MS Access application front end forms, linked tables, reports, VBA coded import and export file functions using MS VBA Object scripting and SQL. Import files are a combination of text and Excel files. Back end MS Access 2003 application

AMERIHEALTH ADMINISTRATORS 7/2006 – 11/2006

MS Access 2003/Excel Programmer/Developer Business Analyst (contractor)

Maintain and redevelop existing MS Access 2003 EU databases used for Claims Processing, Inventory, Audit Processing, and Claims tracking for High dollar insurance claims that were originally written by end users. Many existing databases were originally written by end users and needed to be rewritten. Second phase work required preparing other existing systems, and providing data models for migration to SQL Server. (MS VBA, SQL, Excel, and MS Access)

AMERISOURCEBERGEN 11/2005 – 7/2006

MS Access/ Excel Programmer/Business Analyst (contractor)

Analyze business contract requirements between Pharmaceutical Suppliers and Pharmaceutical Distributors. Document source and target data. Provide data conversion and mapping model. Provide Traceability Matrix back to original source requirement. Design and build MS Access EUC database sales and SLA applications and SQL Server tools to report on Contract compliance and specified business metrics using DB2 tables and queries, and AS400 text data as ODBC data sources.

THE VANGUARD GROUP 5/2005 – 11/2005

MS Access/ Excel Programmer/Business Analyst/Data Architect (contractor)

Design, build, and implement, an Executive Information and Reporting System using MS Access 2003 VBA, SQL, and Excel. Document and provide data model. Analyze incoming Risk Assessment data from numerous sources. Convert data to be used by end user applications. This system is designed to be used on both user and administrative levels to track, manage, and assess Security Risks to software, business applications, IT and Business processes, and other company assets.

EAST COAST SIGN ADVERTISING 7/2002 – 5/2005

Programmer/ Business Analyst/Customer Project Manager/Data Architect (Full time/Permanent)

Design, build, and implement an employee, and manufacturing time management system. This system uses laser scanners to read employee bar coded IDs to track time spent in each phase of manufacturing while producing real-time reports for manufacturing and Capacity Planning, as well as allowing HR to effectively manage the company’s payroll system. This system also replaces the standard time clock and inventory management system by utilizing the same laser scanner method. The application utilizes a VB 6.0 GUI to administrate the application and generate reports from data collected using MS Access2000, VBA, Excel XP and SQL Server 2000. Microsoft Excel is used for end user reporting. Data migration to Excel from a real time database allows the end user to easily adapt to current reporting requirements. This application is designed to be used by numerous users on the administration level, while continuously collecting data. User training is minimal and documented.

GMAC RESIDENTIAL MORTGAGE 5/2002 – 7/2002

Programmer Analyst/Data Architect (Contractor)

Design and build an automated MS Access 97 EU database reporting application, using Oracle data source, to track and locate mortgage documents stored within a document storage facility. This is a multi-user Visual Basic application with MS Access database as a data warehouse and Microsoft Excel for generating active end user reports.

TOSCO/BAYWAY REFINING CORPORATION 11/2000 – 4/2002

Contractor/Programmer/Analyst/Data Architect

Redesign, redevelop, distribute, and implement, existing, Access 2.0 EUC database applications using Visual Basic and Access 2000. This Visual Basic application that provides multiple users with access to all re-developed MS Access databases

ATOFINA 7/2000 – 9/2000

Programmer/Analyst (Contractor)

Visual Basic 6.0 - Wrote VB script to convert Office platform and data from Corel Office Suite format to Microsoft Office 2000 format. Convert Corel Presentations to Powerpoint 2000 and Quattro Pro spreadsheets to Microsoft Excel.

WYETH AYERST PHARMACEUTICALS 4/2000 – 11/2000

Programmer/Analyst (Contractor)

Design and build new EU database applications for IT Finance department using VBA in Access 97 to track Telecommunications invoices, import budget information from MS Excel and provide a Budget Reporting system as well as Infrastructure software development approval system, and Budget/Forecast Analysis Program.

MBIA - MUNICIPAL TAX BUREAU 7/99 – 4/2000

Programmer/Analyst (Contractor)

Year 2000 compliance testing and conversion of Microsoft Access 2.0 and Access95 database applications to Access97. Hardware and software auditing for Y2K compliance, and new application development

TOSCO/BAYWAY REFINING CORPORATION 3/99 – 7/99

Programmer/Analyst/Data Architect (Contractor)

Year 2000 testing and reporting of Access 2.0 databases, Conversion of Access 2.0 applications to Access 97, New Access97 application development, and conversion of Oracle databases to Access 97.

SMITHKLINE/BEECHAM 3/97 - 3/99

Programmer/Analyst/Software Trainer (Contractor)

Assist team in developing Executive Information System using MS Access 2.0,

MS Access 7.0, MS Access 97, Winbatch, Powerbuilder 5.0, and Powerbuilder 6.0. Also used Sybase to create a second market product

Training instructor for use of MS Office products and newly developed software, including lesson plans and Help desk instruction.

LAW SCHOOL ADMISSION COUNCIL 11/96 – 3/97

Programmer/Analyst (Contractor)

Assist team in developing, Visual Basic 4.0 CD-ROM, application for distribution as an instructional tool for applying to law school. Also develop a tracking system to track Quality Assurance progress and Problem Reporting using Microsoft Access version 2.0.

Resume Truncated. Previous Experience available upon request

EDUCATION:

PENNCO TECHNICAL INSTITUTE - Bristol, PA

Associate Business Degree (Computer Programming)

Currently pursuing PMP Certification

References available upon request

Contact this candidate