Software Developer Development

MICROSOFT ACCESS DEVELOPER

Accomplished results-oriented Software Developer specializing in providing systems solutions using Microsoft Access that maximize productivity while reducing costs. Extensive experience in full software development life cycle; system analysis, requirements gathering, design, coding, testing, debugging, maintenance, documentation and end-user training on both mainframe and client/server platforms. Outstanding communication skills create exceptional working relationships with peers, clients, and management. Proven track record of designing and implementing flexible solutions that support user interface and functionality changes using software engineering methodology. Confident to take on challenges with the tenacity to be successful.

System Expertise

Databases: MS SQL Server

Programming Languages: VBA, SQL, VB, Dataquery, PL/1 Ideal

Applications: MS Access, MS Visual Studio, MS Office, MS Soursafe, FTP, Syncra

Mainframe(IBM): JCL, Endevor, MQ-Series, TSO, ISPF, OPCA, RMS, MVS

Operating Systems: Windows, Unix

Professional Experience

Mavis Tire, MS Access Developer, October 2022 –

Backfill MS Access support/development. Migrate MS Access from 32 bit to 64 bit.

Sazerac Company, MS Access Developer, May 2022 –

Interfacing Excel with MS Access for increased productivity and automation..

Grifols Inc, MS Access Developer, April 2021 – December 2021

Excel lost connectivity/data to MS Access. Migrated several databases from .mdb to .accdb.

Upstate Metrology, MS Access Developer, November 2013 – June 2021

Supported clients proprietary MS Access databases and upgraded from .mdb to .accdb. Added numerous forms and reports including new logo and a process to update db when doing off site work.

Excellus Blue Cross Blue Shield, MS Access Developer, March 2020 – November 2020

Migrated over 1500 MS Access databases from versions from 2003 to office 365. I was brought in to fix MS Access database that broke after migration.

Collaborated with end users to verify databases were working correctly.

City of Rochester, MS Access Developer, November 2016 – June 2017 & January 2019 – March 2020

Upgraded 65 MS Access databases from version 97 to 2013 and directed administrators to build new tables so front end could be linked to back end. Also made requested enhancements to forms and reports using VBA.

Datrose, MS Access Developer, September 2018 – November 2018

Supported and updated clients MS Access databases. This included building new interface to create auto data import from Excel.

US Employee Benefits Services Group, Data Analyst, October 2015 – June 2016

Performed ACA Compliance verifications. Made improvements to the process for inputting data.

American Aerogel, MS Access Developer, May 2016 – November 2016

Built new MS Access database to monitor production line.

CareerStart LLC, MS Access Developer, November 2013 – June 2016

Supported/updated their proprietary MS Access database. This included new way to input data, deploy databases, add new employees and new forms, reports. Created extracts from data to new software after MS Access.

CDS Monarch, MS Access Developer, September 2014 – December 2015

Developed and built new MS Access database for quality audits. Was using ‘word’ documents and this allowed to documents audits online for data analysis.

LiDestri Spirits, MS Access Developer, August 2014 – December 2014

Developed and built daily production database for new spirit product line.

Excellus Blue Cross Blue Shield, Health Informatics Analyst, January 2014 – February 2014

Supported their MS Access databases. Enhancements, changes, new tables, forms reports were built.

Thomas & Solomon, on LLP, MS Access Developer, June 2012 – June 2013

Supported and modified existing Access front-end with SQL Server back-end applications.

Designed and developed new Access applications based on user requirements.

Unity Health Systems, Senior Database Analyst/Programmer, September 2006 – October 2011

Demonstrated ability to quickly become knowledgeable to provide primary application support and development of multiple SQL Server databases that currently support user and business needs.

Focused on Microsoft Access applications including automating imports/exports via MS SQL Server.

Consolidated multiple (8) disparate MS Access databases into one database.

University of Rochester, Analyst/Programmer, September 2004 – August 2006

Designed/implemented solution that automated manual process resulting in 100% data accuracy and saving over 400 person hours a year.

Installed custom built real-time intranet delivered application that eliminated paper requests for Time-Off, dramatically increasing productivity and quality of work life for 400 users.

(MS Access (VBA), SQL Server, Excel, Trendstar, HDM, are all applications worked with.)

Eastman Kodak Company, Business Systems Analyst/Software Developer, 1992 – 2004

Analyzed user needs, prepared alternatives, and gained approvals for implementation of applications, documented new systems and changes to existing systems and trained end users.

EDUCATION

Business Management, Rochester Institute of Technology

Computer Programming, Rochester Business Institute

Contact this candidate