SUMMARY:

20+ years’ consulting experience creating MS - Access database/MS-Excel macro applications and managing system development life cycles: working with clients to analyze and streamline business functions through automation; designing, developing, and deploying database applications; report writing/chart design; training users and providing general technical support.

IT SKILLS:

• MS Access 97 - 2016, MS Excel 2000 - 2016
• VBA, DAO, ADO.
• MS SQL Server 2000 - 2016.

WORK EXPERIENCE:

Confidential, Framingham, MA

Responsibilities:

• Designed and created a multi-user database application to streamline business processes used in analyzing and managing supply chain data.
• Created an automated process for importing and normalizing data from multiple data sources.

Confidential, Boston, MA

Responsibilities:

• Design and build MS-Access database application to replace 26 user-managed product recons via Excel macros.
• Streamline and automate business processes (data extracts from various data sources).
• Standardize and automate data patches to General Ledger tool.
• Document processes for managing data reconciliation.

Confidential, Woonsocket, RI

Responsibilities:

• Redesigned various multi-user MS-Access database applications used for managing project pipelines (enhanced user interfaces, eliminated table and query redundancies, and consolidated various databases).
• Worked with business analyst to translate business requirements.
• Automated data exports to Excel.
• Redesigned/created various reports for management and users to manage existing and future project pipelines.

Confidential, Atlanta, GA

Responsibilities:

• Added new functionality to user interfaces and reports in MS-Access database.
• Converted queries to views in SQL Server backend database.
• Redesigned Excel macro to set up customer quote requests to provide data for creating contracts, to a MS-Access and SQL Server client-server environment.
• Worked with client to design user interfaces and streamline various processes involved in creating quotes.
• Worked with end-users to enhance functionality post-deployment.

Confidential, Boston, MA

Responsibilities:

• Worked as a member of the Confidential Group responsible for enhancing, creating, testing, and deploying MS-Access databases and applying fixes/enhancements to MS-Excel macro-enabled solutions.

Confidential, Boston, MA

Responsibilities:

• Redesigned partially-built MS-Access database, from the ground up, to enhance data entry processes and better manage the storage of patient records.
• Developed additional functionality for multi-user network environment such as version upgrade and added security.

Confidential, Burlington, MA

Responsibilities:

• Tasked with creating solutions to manage compensation bonus planning processes, track job applicants/postings, and generate various monthly reports for Company executives.
• Created Excel macros/Access-based applications to import, store, format, and create Excel files for distribution to HR personnel to manage bonus planning.
• Provided Excel/PowerPoint support and troubleshooting to senior management team within HRIS group.

Confidential, Boston, MA

Responsibilities:

• Brought on to normalize a poorly maintained database being used to manage inventory information related to a data center migration project.
• Restructured objects within database and enhanced usability through the addition of user interfaces to manage data within the database and streamline reporting processes and managed daily change requests to data.

Confidential

Responsibilities:

• Designed and created a data management system for computer/electronics retail division to track orders, inventory, and sales.
• Trained sales staff to perform daily tasks involved in managing sales, customer interaction, and order processing.

Confidential, Alpharetta, GA

Responsibilities:

• Migrated MS-Access 2003 Database to 2010 and redesigned front and back end databases.
• Eliminated redundancies in table structures and relationships.
• Redesigned existing interfaces to improve user experiences by consolidating multiple data entry pop up forms as well as rewriting code to improve process flow.

Confidential, Malden, MA

Responsibilities:

• Redesigned existing database application to improve network and overall database performance.
• Migrated database from MS-Access 2003 to 2010, consolidated user interfaces, reports, and queries through the elimination of redundancies and creation of code.
• Streamlined inventory tracking and trouble ticketing processes for service requests.
• Rebuilt tables and modified existing relationships to improve data retrieval.
• Created technical and user manuals to assist with redesign process and track structural enhancements to database.

Confidential, Boston, MA

Responsibilities:

• Designed, developed, tested, and deployed a MS-Access 2010 database application for HR staff to streamline process of assigning job banding information to company-wide job titles.
• Database replaced cumbersome and inefficient use of Excel file in a multi-user environment.

Confidential, Framingham, MA

Responsibilities:

• Designed, developed, tested, and deployed a MS-Access 2010 database application used for emailing client sales and goals information by account.
• Integrated automated email functionality to send out report charts created during bi-weekly ETL data extracts.

Confidential, Framingham, MA

Responsibilities:

• Designed, developed, tested, and deployed ETL database applications used by Merchandising and Finance to manage scorecard reporting.
• Redesigned and streamlined MS-Access Scorecard applications.
• Provided knowledge transfer to business analysts upon completion of projects.
• Managed weekly MS-Access reporting.
• Provided automated solutions in the development and redesign of existing MS-Access database applications.

Confidential, Boston, MA

Responsibilities:

• Rebuilt Graduate Enrollment database in Access 2010, migrating from Access 2003 version.
• Set up automated feeds to extract data from external sources (.csv and Excel files).
• Wrote queries to enable easy migration from one version to the other and provided user and technical manuals.

Confidential, Framingham, MA

Responsibilities:

• Modified database structure to work efficiently in a multi-user network environment.
• Redesigned existing Access reports.
• Recreated Excel reports and charts referencing database in Access and integrated them to run seamlessly
• Automated data feeds into database to reduce data processing and reporting runs by 8 hours to 1 minute.

Confidential, Boca Raton, FL

Responsibilities:

• Tasked with streamlining order processing and billing operations using Excel, Word, and Access automation.
• Redesigned existing Access databases to streamline data mining and cleansing operations against SQL Server.

Confidential, Mansfield, MA

Responsibilities:

• Worked with end-users to enhance existing database applications and streamline data management processes through automation with MS-Access, MS-Excel, MS-Outlook, PeopleSoft, and Visual Studio.
• Liaised between end-users and project leads on MS-Access database conversion projects.
• Rewrote/consolidated database code, queries, forms, and reports resulting in streamlined business processes.
• Automated the execution of monthly processes to pull and load employee data into MS-Access databases and data validation for potential data issues.
• Redesigned a SQL Server database and SSRS reports using Visual Studio.net.

Confidential, Wilmington, MA

Responsibilities:

• Redesigned ROI database application to better serve client’s needs - including redesigning forms, reports, and table structures.
• Integrated time tracking functionality to provide accurate time keeping data for customer invoicing.

Confidential, Boston, MA

Responsibilities:

• Debugged existing VB application managing client’s business accounts and generating client financial reports.
• Documented and rebuilt deployment platform.

Confidential, Canton, MA

Responsibilities:

• Converted and redesigned MS-Access/Excel automated applications, providing technical support where needed.

Confidential, Andover, MA

Responsibilities:

• Reduced data mining times for three critical business processes by redesigning and streamlining existing database applications using automation in SAP, Business Objects, MS-Access, SQL Server, Lotus Notes and MS Excel.
• Redesigned MS-Access and Excel-based applications, converting them into SQL Server-based applications.

Confidential, Woburn, MA

Responsibilities:

• Modified data management database application in preparation for migration to SQL Server platform.
• Migrated database backend to SQL Server 2005; converted queries to stored procedures and views where applicable; redesigned MS-Access front-end using unbound forms to minimize data flow and improved data access times.

Confidential, Boston, MA

Responsibilities:

• Enhanced an existing multi-user application used for logging insurance claims; created unbound forms to improve performance and stability in network environment.
• Streamlined VBA code for adding, editing, and updating data.
• Worked with end-users to improve miscellaneous features during testing and debugging phases.

Confidential, Cambridge, MA

Responsibilities:

• Created a multi-user application to store server inventory information.
• Developed user interfaces to export SQL server data into Excel and reformat data for distribution among end-users assigned to validate data integrity.
• Added custom security measures for data edit and update privileges to restrict access to sensitive information.
• Created reports to help principal users ensure compliance during data verification process

Confidential, Cambridge, MA

Responsibilities:

• Launched redesigned MS-Access/SQL Server database for improved performance.
• Restructured database tables on server and user interfaces in order to optimize performance across a VPN.
• Replaced remaining form and report queries with store procedures and views where applicable.
• Implemented and integrated additional user interfaces along with supporting objects into the front-end database in order to facilitate data processing.

Confidential, Boston, MA

Responsibilities:

• Modified existing reports based on evolving needs and simplified report creation and management processes.
• Created an error control interface to scan incoming data imports in temporary tables for discrepancies and allow user to make corrections before adding data to the application’s main tables.

Confidential, Boston, MA

Responsibilities:

• Designed and developed multi-user database applications for Accounting Department to process Homeland Security funding for municipalities submitted via Adobe .PDF documents.
• Integrated various database applications used by the Fiscal Department to track funding released to municipalities.
• Modified existing databases, user interfaces, and reports.