Experience

Pine Enterprises, LLC

• Construction
• 1 - 100 Employee

• Microsoft Access/Excel Developer

  • Feb 2002 - Present

  • 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 Show less



UHY Consulting

• United States
• Business Consulting and Services
• 1 - 100 Employee

• Consultant

  • Jun 2022 - Apr 2023

  • Set up base pricing and upcharges per customer in Sales Order Management tool (SOM) • Compile and update master pricing Excel file • Use MS Access to resolve inconsistent and duplicate data • Set up base pricing and upcharges per customer in Sales Order Management tool (SOM) • Compile and update master pricing Excel file • Use MS Access to resolve inconsistent and duplicate data



Deloitte

• Business Consulting and Services
• 700 & Above Employee

• Solution Senior Consultant

  • Aug 2019 - Jun 2022

  • Process eDiscovery documents using eCapture, Relativity and IPRO• Load data from various sources in data center

• Microsoft Access/Excel Developer

  • Feb 2015 - Jul 2019

  • Develop and maintain several Access databases to assist with Grants Management• Develop and execute import and export procedures to collect and redistribute data in Microsoft Excel• Assist in conversion of an existing Access database to SQL backend• Create Excel Add-Ins to automate frequent tasks such as password protecting and unprotecting workbooks and worksheets• Add custom Ribbon Interface for users to perform automated tasks



Siemens

• Germany
• Automation Machinery Manufacturing
• 700 & Above Employee

• Microsoft Access/Excel Developer

  • Oct 2014 - Jan 2015

  • Automated and streamlined weekly and monthly KPI reports for Credit Services Department • Organized procedures into a logical easy to manage layout • Edited data structure and changed data types to reduce overall size • Removed and archived unused objects • Automated and streamlined weekly and monthly KPI reports for Credit Services Department • Organized procedures into a logical easy to manage layout • Edited data structure and changed data types to reduce overall size • Removed and archived unused objects



22Squared

• United States
• Advertising Services
• 300 - 400 Employee

• Microsoft Access/Excel Developer

  • Aug 2014 - Oct 2014

  • Create budget reports in Excel format from within MS Access using automation • Develop VBA procedures to convert budget reports to reforecast reports • Define import procedures to allow for importing of corrected data from users in the field • Debug and correct existing reports • Train users in Visual Basic for Applications • Create budget reports in Excel format from within MS Access using automation • Develop VBA procedures to convert budget reports to reforecast reports • Define import procedures to allow for importing of corrected data from users in the field • Debug and correct existing reports • Train users in Visual Basic for Applications



QBE North America

• United States
• Insurance
• 700 & Above Employee

• Microsoft Access/Excel Developer

  • Nov 2012 - Apr 2014

  • 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 Show less



SunTrust

• United States
• Financial Services
• 700 & Above Employee

• Microsoft Access/Excel Developer

  • 1998 - 2013

  • Developed and maintained 4 applications using MS Access to process and report financial information derived from external data sources • Developed and maintained 4 applications using MS Access to process and report financial information derived from external data sources



Hopewell Designs, Inc.

• Alpharetta, GA

• Microsoft Access/Excel Developer

  • Aug 2012 - Oct 2012

  • 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 • 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



TRC Staffing Services

• Atlanta, GA

• Consultant

  • Aug 2012 - Oct 2012

  Microsoft Access/Excel Developer for Hopewell Designs Microsoft Access/Excel Developer for Hopewell Designs



FPT/Intellinet

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Microsoft Access Developer

  • May 2012 - Sep 2012

  • 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 • 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



MATRIX Resources

• United States
• IT Services and IT Consulting
• 500 - 600 Employee

• Consultant

  • Mar 2012 - May 2012

  Contractor for US Department of Labor Contractor for US Department of Labor



U.S. Department of Labor

• United States
• Government Administration
• 700 & Above Employee

• Microsoft Access Developer

  • Mar 2012 - May 2012

  • 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 • 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



Southern Company

• United States
• Utilities
• 700 & Above Employee

• Microsoft Access Developer

  • Jul 2011 - Jan 2012

  • 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. • 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.



3Ci

• United States
• Business Consulting and Services
• 100 - 200 Employee

• Consultant

  • Jul 2011 - Jan 2012

  Microsoft Access Developer for Southern Company Microsoft Access Developer for Southern Company



Northwest Plumbing

• Construction
• 1 - 100 Employee

• Microsoft Access Developer

  • Jan 1998 - Dec 2011

  • Design, develop and maintain several Microsoft Access databases • Develop reports to meet user's specific requirements • Created 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 • Design, develop and maintain several Microsoft Access databases • Develop reports to meet user's specific requirements • Created 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



Rock-Tenn Company

• United States
• Packaging and Containers Manufacturing
• 700 & Above Employee

• Microsoft Access Developer

  • Feb 2011 - Feb 2011

  • Added new forms and tables for collection of new data • Created new Reports for an existing database • Added new forms and tables for collection of new data • Created new Reports for an existing database



UHY LLP, Certified Public Accountants

• United States
• Accounting
• 700 & Above Employee

• Consultant

  • Feb 2011 - Feb 2011

  Consultant at Rock-Tenn Consultant at Rock-Tenn



COMSYS

• IT Services and IT Consulting
• 400 - 500 Employee

• Consultant

  • Oct 2009 - Nov 2010

  Consultant for Gwinnett County Public Schools Consultant for Gwinnett County Public Schools



Gwinnett County Public Schools

• Primary and Secondary Education
• 700 & Above Employee

• Microsoft Access/Excel Developer

  • Oct 2009 - Nov 2010

  • Responsible for maintaining and improving several Microsoft Access databases • Developed and implemented new application solutions using Microsoft Access and Excel • Provided Customer Support for Microsoft Office products to end users • Taught classes on using Microsoft Excel 2007, Microsoft Word 2007 and Windows 7 • Responsible for maintaining and improving several Microsoft Access databases • Developed and implemented new application solutions using Microsoft Access and Excel • Provided Customer Support for Microsoft Office products to end users • Taught classes on using Microsoft Excel 2007, Microsoft Word 2007 and Windows 7



CK Solutions, LLC

• Senior Consultant

  • Apr 2002 - Apr 2009

  • 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. Show less



MDI

• Consultant

  • 2007 - 2008

  • Developed applications using MS Access and MS Excel • Developed applications using MS Access and MS Excel



CBIZ Technologies

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Consultant

  • Jan 1997 - Jan 2003

  • 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 information and project information Show less



Coca-Cola USA

• Microsft Excel Developer

  • Mar 1997 - Mar 1998

  • Created stand alone Excel application that created promotional product comparison sheets for bottled drink products in Lucky and Save On Stores. • Created stand alone Excel application that created promotional product comparison sheets for bottled drink products in Lucky and Save On Stores.



Vanstar

• IT Services and IT Consulting
• 1 - 100 Employee

• Helpdesk Specialist

  • Jan 1996 - Jan 1997

  • Provided PC technical assistance for medium to large companies such as Fannie Mae, Bell South and Arby's. • Trained personal on the Fundamentals of MS Access and Excel. • Provided PC technical assistance for medium to large companies such as Fannie Mae, Bell South and Arby's. • Trained personal on the Fundamentals of MS Access and Excel.