ACCESSible Database Solutions, Inc.
352-200-4704

Diana Eaton
ACCESSible Database Solutions, Inc.
http://www.dianaeaton.com
dianaeaton@yahoo.com
352-200-4704
352-279-7748 Cell

I am a Senior Software Programmer/Analyst with 25 years experience in supporting and developing business and commercial software. I am well versed in full-lifecycle skills, including requirement analysis, client-server systems, design methods, deployment, maintenance, documentation and training. I am a productive self-starter with a strong work ethic; excellent communication skills; and I consistently achieve goals.

My strengths include:

• 25 years experience with Microsoft Access.
• Highly skilled in VBA, DAO, ADO, API, etc.
• 21 years of experience in Visual Basic and SQL to analyze, design, develop and administer software products for business and consumer markets.
• Proven abilities to develop and implement solutions.
• Experienced in writing complicated queries in SQL to achieve desired results.
• Work with minimal supervision.
• Data Cleansing and Validation.
• Importing and Exporting between Access/Excel/SQL Server
• Reporting experience utilizing Access and Excel
• Database Conversions (MDB to SQL) and Upgrades.
• Repairing corrupt databases.
• Excellent customer care.
• Excellent communication and interpersonal skills.

For more current projects, please email or call.

ACCESSIBLE DATABASE SOLUTIONS, INC. – Deltech Corporation                                                  July 2013  – June 2015

11911 Scenic Hwy; Baton Rouge, LA 70807

Sr. Access Programmer /Analyst  

• Continuation of enhancements to Lab Database.
• Created custom reporting
• Created Export features for large data sets

ACCESSIBLE DATABASE SOLUTIONS, INC. – HSBC Bank/Cap Gemini Consulting                     October 2012  – June 2013

N. Riverwoods Blvd; Mettawa, IL

Sr. Access Programmer /Analyst  

• Create an Access 2010 Database to import various Excel files
• Create Access and Excel Pivot Tables and Charts
• Create Documentation for users

ACCESSIBLE DATABASE SOLUTIONS, INC. – Deltech Corporation                                            
June 2012  – September 2012

11911 Scenic Hwy; Baton Rouge, LA 70807

Sr. Access Programmer /Analyst  

• Rebuild old FoxPro Database in Access 2010.
• Import dbf data into the new system
• Create user friendly interface

ACCESSIBLE DATABASE SOLUTIONS, INC. – Diesel Specialists, LLC.                                                  May 2012  – June 2012

8784 South Choctaw Dr; Baton Rouge, LA 70815

Sr. Access Programmer /Analyst  

• Created Access Reports  utilizing AccPac SQL Server tables
• Create and Edit AccPac VBA Macros
• Run Pricing Updates against AccPac utilizing Access 2010 and AccPac Macros

ACCESSIBLE DATABASE SOLUTIONS, INC. – CJ Publishing                                                              March 2012  – June 2012

Pinellas Park, FL  33780

Sr. Access Programmer /Analyst  

• Corrected Issues in Access 2003 Database
• Created Reports
• Enhanced Form design

ACCESSIBLE DATABASE SOLUTIONS, INC. – PNC Mortgage                                                           July 2011 – February 2012

Newmark Dr; Dayton OH  45342

Sr. Access Programmer /Analyst  (Partial Telecommute)

• Worked on a team of 6 to convert 60 Access 2003 Databases into SQL Server 2008 backend.
• Implemented security on Access front end and secured data via SQL Server schemas as well as Access Workgroups.
• Utilized SSIS packages via a Landing Zone to manipulate and import flat files into SQL Server
• Integrated databases with Lotus Notes Mail
• Created testing scripts and tested utilizing Quality Center (ALM)

ACCESSIBLE DATABASE SOLUTIONS, INC. – Exxon Mobil                                                                     June 2010 – June 2011

4200 Dacoma, Houston TX  74470

Sr. Access Programmer /Analyst (Partial Telecommute)

• Converted an Access 97 database to Access 2007 to assist in the scrubbing and conversion of legacy system data to SAP.  Modified most of the record sources, forms and reports to suit the new business requirements
• Created an Access Database to assist in EMITs Downstream conversion to SAP
• Imported and Exported data via automation
• Data management, scrubbing and maintenance for conversion from legacy systems into SAP

ACCESSIBLE DATABASE SOLUTIONS, INC. – E-Destin                                                                            May 2010 – June 2011

31881 Via Pato,Coto de Caza, CA 92679 

Sr. Access/SQL Programmer /Analyst  (Telecommuting Contractor)

• Added new forms, reports and web services to an Access 2003 Event Management Database
• Corrected existing errors

ACCESSIBLE DATABASE SOLUTIONS, INC. – www.thehousewaresstore.com                                         Jan 2009 – June 2010
8454 Day Street; Spring Hill, FL  34606

Sr. Access Programmer/Analyst Yahoo Merchant Store Creator

• Create custom drop-shipping database to handle the automation of orders via Access 2010 (SQL 2008 back-end) and Yahoo Merchant
• Created a Yahoo Merchant Store selling house-ware products
• Automated data feeds from various sources (FTP, txt, csv, xls, etc.) utilizing Access VBA and/or Outlook to download of web crawl for the data.
• Implemented code to handle manipulation of distributor data to then upload to Yahoo Merchant store utilizing VBA.
• Integrated Web Services into VBA
• Created automation of incoming and outgoing orders using ODBC from Access VBA to Outlook.
• Utilized VBA in automation of various supplier websites.

ACCESSIBLE DATABASE SOLUTIONS, INC. – www.gotogetit.com                                                          June 2009 – May 2010
8454 Day Street; Spring Hill, FL  34606

Access Programmer/Analyst. Yahoo Merchant Store Creator

• Created an OSCommerce Store
• Create custom drop-shipping database to handle the automation of orders via Access 2007  (SQL 2008 back-end as well as Connector to MYSQL for OS Commerce Data) and OSCommerce
• Automated data feeds from various sources (FTP, txt, csv, xls, etc.) utilizing Access VBA and/or Outlook to download of web crawl for the data.
• Implemented code to handle manipulation of distributor data to then upload to OSCommerce modules utilizing VBA.
• Created automation of incoming and outgoing orders using ODBC from Access VBA to Outlook.

ACCESSIBLE DATABASE SOLUTIONS, INC. - ESBIN & ALTER INC                                                   Aug 2007 – June 2010

497 South Main Street; New City, NY 10956

Access/SQL Programmer /Analyst  (Telecommuting Contractor)

• Converted Case Management Software in Access mdb (97) to Access 2003 adp utilizing SQL 2005. 
• Converted all dao code to ado.
• Linked MS Outlook to Access emails and calendars
• Troubleshot and corrected all issues of the upsizing.
• Automated integration with Microsoft Outlook 2007.
• Created new reports and various forms to assist in productivity.
• Found and corrected prior errors in code, as well as logic.
• Created new stored procedures and views in SQL 2005
• Utilized DTS packages to update SQL 2005
• Enhanced File Folder system through Access.
• Created Technical Documentation and User Manuals

ACCESSIBLE DATABASE SOLUTIONS, INC. – SCREWS INDUSTRIES INC                                      Dec 2007 – May  2009

301 Highgrove Blvd; Glendale Hts, IL 60139

Access/SQL Programmer /Analyst  (Telecommuting Contractor)

• Converted numerous Access 97 mdb to Access 2003 adp utilizing SQL 2005. 
• Converted all dao code to ado.
• Enhanced the look and ease of use of forms.
• Found and corrected prior errors in code, as well as logic.
• Implemented conversion of reports to PDF and automated emailing utilizing Outlook.
• Troubleshot and corrected all issues of the upsizing.
• Created new stored procedures and views in SQL 2005

ACCESSIBLE DATABASE SOLUTIONS, INC. - ProClaim                                                                    Aug 2008 – February 2009

496 South Main Street; New City, NY 10956

Access/SQL Programmer /Analyst (Telecommuting Contractor)

• Created an automated system to file Bankruptcy claims to various United States Bankruptcy Courts utilizing xml through Access 2007 (adp) through Pacer.org and CM/ECF programs.
• Automated Document Management system
• Implemented Bar Code technology for document tracking.

ACCESSIBLE DATABASE SOLUTIONS, INC. – SMA Airport                                                                       Jul 2008 – Aug 2008

1080 San Mateo Avenue; South San Francisco, CA  94080

Access  Programmer /Analyst (Telecommuting Contractor)

• Analyzed productivity issues and corrected coding errors
• Enhancements made to an existing Access 2000 Database

ACCESSIBLE DATABASE SOLUTIONS, INC. – Lyon Industries                                                                Aug 2008 – Aug 2008

1630 Shanahan Dr; South Elgin, IL  60177

Access  Programmer/Analyst (Telecommuting Contractor)

• Analyzed and corrected issues with PawCom interface of Peachtree to Access 2000

ACCESSIBLE DATABASE SOLUTIONS, INC. - EMPIRE TODAY FLOORING                                       Aug 2007 – Oct 2007

333 Northwest Ave.; Northlake, IL 60164

Access Programmer /Analyst (Telecommuting Contractor)

• Create new Access 2003 database to track the flow of requests for business lines, products, vendors and markets.
• Created forms and ad hoc reports.
• Integrated emailing capabilities with Outlook.

ACCESSIBLE DATABASE SOLUTIONS, INC. - JAYSTAR SOFTWARE GROUP                                   Jun 2007 – Aug 2007

85 East Avenue; Norwalk, CT 06851

Access/SQL Programmer (Telecommuting Contractor)

• Analyzed and corrected various reports and forms using Access 2007 ADP project with SQL 2005 on the back-end.
• Created new stored procedures and triggers on SQL 2005 to enhance productivity.

HERNANDO COUNTY PROPERTY APPRAISER                                                                                            Oct 2005 – Nov 2007

201 Howell Ave; Brooksville, FL  34608

Senior Access Programmer/Analyst 

• Analyzed existing work flow and systems and recommended procedural and/or system improvements to increase efficiency and reduce costs.
• Provided back-up to the IT Director. (Assisted in budgeting for IT Department; Linux/Oracle 9i and 10g Assistant DBA.)
• Installation and upgrades of Oracle 10g on Linux server.
• Developed, deployed, maintained and enhanced applications in Access, Visual Basic and Asysco Lion Developer (using SQL 2000 on the back-end for data).
• Creation of Stored Procedures and Pass-through Queries.
• Utilization of T-SQL for queries to SQL Server.
• Developed and deployed new applications utilizing Asysco Lion Developer, Access 2003 and Access 2007, Visual Basic 6 accessing both SQL 2000 and Oracle 9i and 10g data.
• Integrated Consumable Web Services.
• Created XML files for CAMA data integration with Apex and MobileO software.
• Assisted with the maintenance of multiple databases in SQL and Oracle.
• Database and geodatabase design, maintenance, tuning, and support utilizing Arcmap.
• Utilized Visual Basic to create a dll interface with ArcMap.
• Created and edited complex Excel spreadsheets and pivot tables.
• Troubleshot hardware, software, and peripheral issues as needed.
• Wrote system and procedural documentation and trained users.

ACCESSIBLE DATABASE SOLUTIONS, INC. - RON FEE INC.                                                                  Aug 2005 – Sep 2006

Commercial Blvd; Spring Hill, FL  34609

Access/SQL Programmer/Analyst (Telecommuting Contractor)

• Updated and corrected existing multi-user Access database.
• Analyzed structure and corrected where necessary.
• Created financial, ad-hoc, statistical, and auditing reports.
• Converted DAO to ADO
• Upgraded from Access 2000 to Access 2003, migrated to an ADP version to SQL 2000 back-end, trained users, created documentation.
• Create stored procedures and views.

ACCESSIBLE DATABASE SOLUTIONS, INC. - U.S. BASEMENT WATERPROOFING                          Sep 2004 – Jun 2005

153 Main Street; Brewster, NY  10509

Access/ Visual Basic/SQL Programmer/Analyst  (Telecommuting Contractor)

Customer Tracking and Estimating Database:

• Updated Access database (that I had created in 1998) to utilize SQL Server 2000 as a backend.
• Utilized Access for static as well as dynamic reporting, created detailed documentation and trained the end-users.
• Analyzed technical needs and created a user friendly front end to enhance productivity.
• Created technical drawings of space, phones, network, and lighting for new office construction.
• Ran Category 5E cables and terminated network and phone lines.
• Installed and terminated the network hub, installed a wireless network, and configured TCP/IP settings.
• Designed and installed an Office 2003 server running SQL 2000.
• SQL 2000 DBA and Access 2003 DBA.
• Developed, implemented, and tested backup and recovery plans.
• Utilized VB.Net to create exes and dlls to assist in productivity.
• Automated Access uploads to Quick Books Pro 2005.
• Installed and maintained the new Panasonic Phone system.
• Updated hardware and software as necessary.

HOBBS GROUP (HRH CORPORATION)                                                                                                           May 2000 – Sep 2004

39 Old Ridgebury Road, Suite 5; Danbury, CT  06810

Visual Basic/SQL/Access Programmer/Analyst and SQL Server DBA 

• Designed and created accounting Sub-Ledger and Broker-Dealer/New Business tracking systems for the insurance industry.
• Designed and created a Commission Calculations system utilizing VB6 and SQL 7.0 as the backend utilizing ADODC.
• Utilization of T-SQL for queries to SQL Server
• Built all of these modules into one unique system for ease of use and data sharing.
• Created new and converted existing Visual Basic 6.0 applications from DAO to ADO and backend to SQL server.
• Created Stored Procedures and Pass-through Queries.
• Created OLAP Cubes.
• Creation of Complex SQL Joins.
• Created reports utilizing Crystal Reports and Access 2000.
• Provided support to clients as needed.
• Assisted with the maintenance of Internal Web Programs using Ultra Edit and Visual Basic.
• Created user manuals and code documentation, provided training to users.
• Installed and provided Database Administration of the new SQL 7.0 Server.
• Utilization of T-SQL for queries to SQL Server
• Designed, constructed, and implemented physical databases.
• Developed, revised, and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environment.
• Planned and conducted structured testing of database designs to confirm functionality and performance.
• Developed and implemented plans to oversee the data and database administration function, and ensured smooth transition to new technology.

ACCESSIBLE DATABASE SOLUTIONS, INC. - DHL/AIRBORNE EXPRESS

One Technology Plaza; Norwalk, CT  06830

(Telecommuting Contractor)                                                                                                                                       Dec 2003 – Mar 2004

Access Programmer 

• Analyzed and upgraded Shipping Claims System written in Access 2.0 to Access 2002.
• Enhanced outdated features.
• Created automated archival of data.
• Created user manuals and code documentation, provided training to users.

ACCESSIBLE DATABASE SOLUTIONS, INC. - PFIZER PHARMACEUTICALS                                   Apr 2000 – May 2000

235 E 42nd St.;  New York NY 10017

Access/VBA/VB Programmer/Analyst 

 Forecasting Database System:

• Corrected existing Access database reports.
• Created user-friendly menus and ad-hoc reports to illustrate supply and demand using Access reports.
• Created complex queries and pivot tables for utilization in reports using Access.
• Integrated database with a packaged software-forecasting product (Peer Planning).
• Created a one step automation to eliminate a lengthy, manual, weekly process of importing various data files and running of multiple VB executables.
• Automated sending the status of this automation process via Outlook e-mail.
• Created documentation on the system.

ACCESSIBLE DATABASE SOLUTIONS, INC. - GE CORPORATE                                                              Jan 2000 – Mar 2000

3135 Easton Turnpike; Fairfield, CT 06431

Access/VBA Programmer/Analyst 

• Developed multi-user Project Tracking Access Database System to track the progress and finances of all Corporate Environmental Protection projects.
• Split the database for data to exist on server while front-end existed on user’s machines for higher performance.
• Created a form driven interface with coded security.
• Developed forms and multiple reports with cross-tab record sets, union queries and action queries.
• Created Reports Filter form for users to customize their search criteria for reports.
• Created dynamic reports for access via Intranet.
• Utilized Er-Win diagrams for data modeling.
• Documented system and trained users.

GUINNESS BASS IMPORT COMPANY                                                                                                               Feb 1999 – Jan 2000

6 Landmark Square; Stamford CT 09601

Senior Access/VB/SQL Programmer/Analyst and SQL Server DBA 

Supply Chain Project:

• Analyzed requirements, designed layouts, structured timelines, and programmed using VBA in Access 97 as front-end and ODBC with SQL 6.5 as back-end.
• Created stored procedures and utilized ADO to automate the nightly import of various text files from FTP, EDI and e-mail attachments to be imported and validated into the various tables in SQL.
• Created OLAP Cubes.
• Utilized Sagent to create a data mart of the SQL tables relating to the supply chain and built various views for ease of report creation.
• Created numerous validation and statistical reports utilizing Access with a reference to MS Graph being for the graphical reports.
• Created SQL Pass-Through Queries in Access to call SQL Procedures.
• Built SQL 6.5 Server and databases on an Alpha system as well as on a HP Pentium.
• Administrated SQL Server databases for security and optimization.
• Developed, implemented, and tested backup and recovery plans for SQL Server.
• Managed project lifecycles. Interviewed, hired, and managed additional consultants as needed.
• Created and managed project timelines utilizing Project 98.

ACCESSIBLE DATABASE SOLUTIONS, INC. - NEXTEL COMMUNICATIONS                                    Aug 1999 – Oct 1999

Access/VB/SQL Programmer  (Telecommuting Contractor)

Site Management Project: After hour’s consultant on Project Phase II

• Converted the Access 97 database into an Access front-end with SQL 6.5 back-end, implementing security and creating additional queries and reports.
• Automated backup and compacting procedures to reduce the workload of the database administrator.

U.S. BASEMENT WATERPROOFING                                                                                                                 Nov 1998 – Jan 1999

153 Main Street; Brewster, NY  10509

Access Programmer/Analyst  (Telecommuting Contractor)

Customer Tracking and Estimating Database:

• Created a multi-user Access 97 database to track customers, service calls and contracts. Utilized Access for static as well as dynamic reporting.
• Project included automating the import of data from Paradox, designing table structure and relationships, user-friendly forms, queries, and reports.
• Utilized ODBC with Word 97 for simplicity of mail merges.
• Automated Exchange/Outlook with Access utilizing ODBC.
• Created technical documentation and trained the end-users.
• Converted data from an existing FoxPro system into the new Access Database.

ACCESSIBLE DATABASE SOLUTIONS, INC. - NEXTEL COMMUNICATIONS                                   Aug 1998 – Nov 1998

1 N Broadway 5^th Floor; White Plains, NY

Access/VBA Programmer  (Telecommuting Contractor)

• Analyzed, designed, and created normalized tables for a Site Management Database.
• Utilized ODBC to automate the import/migration of Excel data into a structured Access 97 database to track the Cell Site development process.
• Created approximately 30 detailed statistical reports, as well as ad-hoc reports and user-friendly forms.
• Took the site tracking process from a mass of papers in various files to a well-organized Site Management Database.

JACKSON, LEWIS, SCHNITZLER & KRUPMAN                                                                                            Mar 1997 – Feb 1999

1 N Broadway 14^th Floor; White Plains, NY

Access/VBA Programmer/Software Systems Specialist/Technical Writer  

• Analyzed requirements and created various Access 97 database programs for an Insurance Law firm (Financial, HR, Facilities, and MIS), tested programs, created technical documentation in hard copy and via Intranet for firm-wide use, and trained users on firm’s standard software packages and specialized database programs.
• Designed and programmed WordPerfect 7 macros and templates.
• Built installations for databases, programs, and macros.
• Was primary support for application usage questions.
• Assisted in researching equipment and software solutions.
• Assisted troubleshooting AS400 problems.
• Implemented web page improvements utilizing Front Page 98 on SQL 6.5 server.

MICHAELS & ASSOCIATES, INC.                                                                                                                      Sep 1994 – Feb 1997

80 Business Park Drive; Suite 306; Armonk, NY 10504

Access/VBA Programmer/Systems Specialist 

• Analyzed, designed, and programmed Access 95 Database systems utilizing VBA and ODBC with Word for organizational management, insurance status, lead tracking, accounting, medical plan management, human resources, and others as needed.
• Troubleshot any computer-related problems encountered on a day-to-day basis, including printing problems, set up new users on the LAN.
• Developed new sales ideas and marketing material, created PowerPoint presentations.
• Installed all new computer software and trained staff.
• Created technical documentation on all software and business standards.
• Responsible for reviewing and updating all software, coordinated repairs on hardware.

TRANSAMERICA LEASING CORPORATION                                                                                                 Dec 1991 – Sep 1994

100 Manhattanville Rd ; Purchase, NY 10577

Access Programmer 

• Created a Rolodex database for the International Tank Container Department using Access 01.
• Created various databases as needed.
• Created overheads and slides for presentations using PowerPoint.
• Created departmental calendar utilizing Access.

Oracle - Oracle 10g Administration Certificate

Oracle - Oracle 10g Administration II Certificate

SmartTree -- SQL 2000 Database Administration Certificate

ICM -- SQL 7.0 Database Administration Certificate

Westchester Community College -- Visual Basic 5.0

Simmon’s Business School for Vocational Arts -- Business/Court Stenography

Our Lady of Victory -- Business Regents