PROFESSIONAL SUMMARY:

• More than 20 years of Visual Basic data analysis and database development with Microsoft Access and Office applications with VBA and SQL in a variety of business environments, including financial/banking, insurance, energy management and clinical trial management utilizing desktop and client/server architectures.
• Database development, troubleshooting, application wide revisions to code/functions (refactoring), version upgrades, platform migrations
• Requirements specifications documentation, data presentation and charting (Excel, PowerPoint)
• Data analysis, mapping, aggregation, validation, conversion, migration, cleansing
• Data modeling and relational architecture design;MS Access to SQLServer Conversion
• Graphical user interface, form and report design; Access - Excel data exchange
• Application implementation, end user testing, production support and system issues resolution.

SKILLS AND CORE COMPETENCIES:

Applications: MS Access, Excel through versions 2013; MS SQL Server 2008/2012

Languages: MS VBA 5/6, SQL (Access), T - SQL, SSIS

Technologies: DAO, ADO, SQL, ODBC, (ETL)Extraction/Transformation/Loading, Software Development Life Cycle

Operating Systems: Windows through version 7, Windows Server through version 2012

EXPERIENCE:

DB Developer /Analyst

Confidential

Tools: /Technologies: VBA 6, MS Access

Responsibilities:

• Development of add-in tools and components to be used in future development projects.
• Access objects to be used for user-level persmissions/security to replace previous MS Access user security which was deprecated with relaease of Access version 2007; multiple criteria selection dashboard to be used for data analysis interfaces with complex datasets.
• Online study courses from Lynda.com & Pluralsight

Confidential, Carmel, IN

Db Developer /Analyst

Tools: VBA 6, MS Access/PowerPoint 2013, SQL Server 2012(contract: Experis)

Responsibilities:

• Developed MS Access application to parse data warehouse output to SQL Server for business tracking, management and reporting from an Access GUI.
• Assisted in implementation and production support.
• Designed interface for project tracking, data review and updating cycles, and complex criteria selection to aggregate data into queries to provide reports and PowerPoint slides embedded in Access forms.

Confidential, Raleigh, NC

DB Developer /Analyst

Tools: /Technologies:VBA 6, MS Access/Excel/Word 2010, SQL

Responsibilities:

• Developed two applications to validate voter eligibility for multi-state and in-state voters without proper documentation to meet new legal requirements, including voter contact history and document storage.
• Designed applications to manage training and certification of county-level multi-partisan voter assistance teams and for reimbursement to county and state agencies for providing proper documents (birth certificates, legal alien documents, etc.) for voters’ requirements.
• Made graphics and textual modifications to voters’ documents from previous elections.

Confidential, Birmingham, AL

Database Developer

Tools: VBA 6, MS Access/Excel/PowerPoint 2013, SQL

Responsibilities:

• Reviewed a previously built Access application for a strategy to extend reporting capabilities.
• Designed a complex report criteria selection interface which allows any selections from multiple controls (text boxes, option groups, multi-select list boxes, etc.).
• These selections are then aggregated into an SQL statement built on-the-fly to provide the data source for display forms and reporting purposes, including Access forms, Excel spreadsheets and PowerPoint graphs.

Confidential, Morrisville, NC

DB Developer /Analyst

Tools: MS Access/Excel/PowerPoint 2010, VBA 6, SQL

Responsibilities:

• Assisted in review and planning of migration of a Laboratory Information Management System (LIMS) in Oracle 9/Access 2003 to a new proprietary LIMS on an Oracle 11g platform.
• Revised existing MS Access 2010 applications for Quality Assurance SOP training and laboratory metrics capture to accommodate changes in business processes.
• Upgraded reporting utilities based on Access/Excel/PowerPoint and created overview reports and dashboards of statistical data results for the genetic testing workflow.

Confidential, Columbus, GA

Tools: MS Access 97 & 2010, VBA 6, SQL

Responsibilities:

• Assisted in migrating over 400 Access 97/2003 database applications to Access2010.
• Wrote documentation to assist with data preparation and post-conversion data migration.
• Assisted with migration issues, file corruption, user security, data cleansing and de-duplication.
• Tested functionality of data import/export processes used to query Excel spreadsheets and text-based files, and MS Word merge file generation.

Confidential, Raleigh, NC

Database Developer

Tools: VBA 6, MS Access 2007, ODBC, ADO, SQL Server 2005

Responsibilities:

• Converted an application built in ADP/SQL Server to MS Access 2007/SQL Server 2005.
• Revised and added ADO and VBA code to reflect changes in business process and to ensure data integrity, including redesign and normalization of data tables, data validation, full error handling, data change tracking (audit trail) and consolidation of coded processes for greater efficiency and ease of maintenance.
• Added enhancements for document generation, management, messaging and alerts, and calculation of fees and fines with status tracking of compliance documents and fee payments.

Confidential, Houston, TX

Database Developer

Tools: VBA 6, MS Access 2007, ODBC, SQL Server 2005

Responsibilities:

• Implemented revisions to an Access 2007/SQL Server 2005 production database with over 300 tables.
• Developed reports in Excel using data extracts from Access enhanced with Excel VBA processing.
• Added functionality for increased data accuracy, validation, audit trail process and error handling.
• Added processes to insert table-sourced text/graphics into documents per policy type and state.

Confidential, Knoxville, TN

Database Developer

Tools: MS Access 2007, VBA 6, SQL, application maintenance

Responsibilities:

• Resolved frequent crashing issues in an Access 2007 billing database, preventing data loss and saving many man-hours of data review and correction for the clerical staff.
• Designed a new report interface, report templates and ad hoc reporting/user query tools in Access and Excel with improved criteria selection flexibility.

Confidential, Durham, NC

Database Developer

Tools: MS Access 2003, VBA 6, data analysis, report design

Responsibilities:

• Assisted in discovery, streamlining and documentation of manual processes being used for clinical trial research site candidate selection which was based in Lotus Notes and SQL Server.
• Designed new methods and tools for data extraction and manipulation utilizing MS Access 2003 and SQL Server 2005 data extracts to support clinical site recruitment tracking.
• Implemented a third-party reporting tool for Lotus Notes to facilitate data queries and reporting.
• Performed data cleansing and process documentation in preparation for implementation of a new proprietary clinical trials management.

Confidential, Raleigh, NC

Database Developer

Tools: VBA 6, MS Access 2003, QuickBooks, DAO

Responsibilities:

• Developed an Access 2003 tool to provide for data exchange between the Intuit ERP and the QuickBooks application used for processing of service charges and invoice data preparation and generation.

Confidential, Raleigh, NC

Database Developer

Tools: /Technologies: VBA 6, MS Access 2003, ADO, SQL

Responsibilities:

• Developed an Access 2003 application to catalogue, manage and retrieve documents and information in response to information requests in support of an enterprise system Request for Proposal (RFP) initiative. Aggregated and organized data resources to populate database.

Confidential, Knoxville, TN

Database Developer

Tools: Visual Basic 5, MS Access 2003, SQL Server 2005

Responsibilities:

• Converted financial applications from Access 97 to Access 2003/SQL Server 2005 platform.
• Reviewed, recommended, documented and implemented changes to an Access database used for tracking of financial application auditing processes during Sarbanes-Oxley control compliance audit.
• Developed Access/SQL Server application replacing a totally manual process to manage product orders, shipping, invoicing and data exchange with the Oracle General Ledger application.
• Designed an Access application to be used as a shipping and receiving reporting tool.

Confidential, Smithfield, RI

Database Developer

Tools: MS Access/Excel 2000, VB5, SQL, financial applications

Responsibilities:

• Revised an Access 2000 budget tracking and reporting database per specifications.
• Spec’d, designed and developed procedures for data interchange between Access budget application and Excel production progress/cost analysis Excel spreadsheets.
• Created upsizing plan to implement budget tracking database as Access 2000/SQL Server 2000 client/server architecture and proposed implementation of this process to Access/SQL Server.

Confidential, Sarasota, FL

Database Developer

Tools: VB6.0, MS Access/Excel 2002, SQL Server 2000, VBA, DAO

Responsibilities:

• Redesigned and enhanced an Access 2002 Help Desk / End-user support application.
• Converted tax return processing software from full Access 2002 to Access/SQL Server 2000 client/server architecture over a Citrix portal.
• Assisted development team in redesign and refactoring projects for major version upgrade of proprietary software implemented in VB6.0/SQL Server 2000.
• Created management reports in Access and Excel, including graphs and pivot tables.
• Implemented processes to extract, normalize and prepare data from SQL Server 2000 for template and ad hoc reports for marketing analysis and customer support departments.
• Developed processes to automate weekly and monthly report generation and facilitate ad hoc reporting.

Confidential, Providence, RI

Database Developer

Tools: MS Access/Excel 2003, SQL, Visual Basic, FTP, VBA 6

Responsibilities:

• Completely redesigned and implemented an application, used in recreational vehicle industry, from Excel 2003 spreadsheet format to a full Access 2003 database application.
• Added enhancements such as Adobe PDF document output feature, automated emailing of customer documents and backup/restore of data files, software updates via FTP and end-user training mode for user interface.
• Assisted in four on-site installations and configuration of software and resolution of system issues.