PROFESSIONAL EXPERIENCE

Confidential

Microsoft Access/Excel Developer

• Design, develop and maintain several Microsoft Access databases
• Coordinate and implement changes to accommodate new business rules
• Developed custom exports that go to a variety of formats including automated Microsoft Excel files that contained VBA code which allows users to separate data into tabs automatically as well as apply formatting
• Recommend changes to improve usability and efficiency
• Create and execute data imports for a wide variety of formats
• Converted databases to SQL server backend for greater data storage and performance
• Converted databases for compatibility with Access 2013

Confidential

Microsoft Access/Excel Developer

• Consolidated table structure for database that tracks loans for various tax jurisdictions
• Converted all Macros to Visual Basic for Applications VBA
• Updated Microsoft Access databases to 2007 file format
• Developed and implemented new screens to streamline data editing
• Split databases into front end / backend architecture and provided each user with their own local front ends. This allowed for automatic version updating with minimal user interruption.
• Created side application to help identify bad/inconsistent data

Confidential

Microsoft Access/Excel Developer

• Designed and developed a MS Access 2010 database to store and report information about customers, products and services provided by the company
• Developed screen to allow users to create, edit and print Proposals
• Created procedure to automatically email information to users for follow up action using MS Outlook

Confidential

Microsoft Access/Excel Developer

• Changed existing data structure of an existing MS Access database for a large insurance company. These changes greatly reduced the number of fields in each table by utilizing relationships and referential integrity and allowed for greater flexibility
• Tailored existing screens and reports to interface with new data structure

Confidential

Microsoft Access/Excel Developer

• Designed and developed a database to help track incoming and outgoing mail and postage. Allows users to produce daily manifest reports and search entries.
• Maintained and improved several existing MS Access databases

Confidential

Microsoft Access Developer 2009-2010

• Made requested updates, changes and additions to Budget database
• Updated Microsoft Access database to 2010 file format
• Maintained and improved several Microsoft Access 2003 databases
• Developed and implemented new application solutions using Microsoft Access and VBA
• Provided Customer Support for Microsoft Office products to end users
• Taught classes on using Microsoft Excel 2007, Microsoft Word 2007 and Windows 7

Confidential

Microsoft Access Developer

• Suggested and implemented upgrade to SQL server backend for MS Access Technical Change Management application TCM . This application tracks changes to Enterprise Solutions Support company wide
• Developed additional functionality to TCM application including MS Outlook automation
• Designed and developed a Supplier Maintenance Request application to track additions and changes for 400 buyers

Confidential

Microsoft Access Developer

• Design, develop and maintain several Microsoft Access databases
• Develop reports to meet user's specific requirements
• Create new interfaces and additions allowing users to track additional data
• Converted database to new versions of MS Access, most recently to Access 2007/2010
• Combined data from 8 locations into one database with common front end

Confidential

Senior Consultant

• Design, developed and implemented database and spreadsheet custom solutions using Microsoft applications including Access, Excel, VBA and SQL Server.
• Design, developed and implemented user interfaces connecting to Legacy Systems. Systems include Great Plains Accounting Systems and MAS 90
• In charge of creating design documents including data flow diagrams, table definitions and cost estimates
• Accountable for the tracking of actual time/cost vs. budget estimates.
• Applications design and developed for a wide variety of industries including: suppliers, construction companies, restaurant management, retail sales, surveying, service companies, and banking
• Procomm - Created Excel application that produces and formatted a Job Schedule sheet complete with custom formulas allowing users to modify entries.
• InterContinental Hotels Group - Created MS Access application that reads multiple Excel workbooks with multiple tabs that then allows users to search by criteria.
• W.H. Bass - Created application that produces and formats Excel budget sheets that users can edit and then re-import.
• Pine Enterprises - Created procedure that produces and formats billing sheets for multiple builders for electronic submission.
• StoreLink Retail Group / Home Depot - Produced and formatted store visit sheets.

Confidential

Senior Consultant

• Designed, developed and implemented database and spreadsheet custom solutions using Microsoft applications including VBA, SQL Server, Access, FrontPage, Excel and Word.
• Applications design and developed for a wide variety of industries including: suppliers, construction companies, restaurant management, retail sales, surveying, service companies, banking, and healthcare management
• SunTrust Bank - Developed and maintained 4 applications using MS Access to process and report financial information derived from external data sources
• Coca-Cola USA - Created stand-alone Excel application that created promotional product comparison sheets for bottled drink products in Lucky and Save On Stores.
• Georgia Automobile Dealers Association - Developed and maintain MS Access application to track member organizations. Application tracks member dues, conventions and political contributions. Converted DB to SQL server
• Southeast United Dairy Farmers Association - Developed and Maintain 3 MS Access applications for tracking school teacher / promotional material information, annual survey