Diana Eaton
ACCESSible Database Solutions, Inc.
http://www.dianaeaton.com
dianaeaton@yahoo.com
352-200-4704
352-279-7748 Cell
Senior Access/VBA/SQL Programmer/Analyst
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 5th 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 14th 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