Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Bruce Dodds | Elance
 
176985602337900
Last Sign-in: Jul 1, 2015

Bruce Dodds

Professional Access Developer
   United States
  |   Vancouver, Washington
  |  4:26 pm Local Time

Verified Freelancer

Bruce Dodds's identity has been verified.  Learn More

Overview

I have been a professional Access developer since 1996. I'm skilled in all aspects of Access development, including relational design, forms, queries, and VBA. I will make an effort to understand your needs and deliver precisely what is requested, or more. Let's make a connection. Note - I am not a fan of social media, so you will not find me on FB or LinkedIn.

Read More »
Jun 29, 2015|Database Development|$0|Working
Jun 18, 2015|Software Application|$44|Completed
Jun 12, 2015|Software Application|$219|Completed
Jun 10, 2015|Database Administration|$180|Completed

View All »

Portfolio

This is a functional specification I created for Phase 2 of a project at a large...
A simple Access VBA function to determine whether an Excel pathname can be opened, and...
A firm wanted to know how many Access databases they had (over a thousand, it turned...
These are form / report samples from a system to allow a nonprofit to track donations....

Skills (3)

Tested
Microsoft Access Programming
SQL Programming
Microsoft Access Administration
Microsoft Access 2007 Test
My Score
avg

Employment

SHAMBHALA MEDITATION CENTER Brookline MA
Consultant (volunteer)
2013 - 2014
Adapted Access database to use Quickbooks extracts rather than bank ACH records as source of donation transactions. Added a donations detail page to the 501c(3) annual letter. (Access 2007 &...
SHECHEN TENNYI DARGYELING
Consultant (volunteer)
2013 - 2013
Advised on moving monastic sponsorship donations / mailing Access database to a cloud based solution. (Access 2003, DonorPerfect).
SHAMBHALA MEDITATION CENTER
Consultant (volunteer)
2012 - 2013
Adapted Access database for tracking donations to a nonprofit to a new bank / ACH record format and new accounting procedures. Redesigned 501c(3) annual donations acknowledgement letter....
CITYWIDE FRIENDS OF THE BOSTON PUBLIC LIBRARY
Consultant (volunteer)
2012 - 2013
Analyzed computer resources and systems of nonprofit group, researched / recommended upgrades. Provided advice on moving member database from Access database to a cloud based membership...
CVS/CAREMARK
Consultant (contractor)
2011 - 2012
Analyzed and enhanced an existing Contract Management database for Caremark MinuteClinic, a national network of walk-in clinics. The existing (incomplete) database was designed to support a...
CVS/CAREMARK
Consultant (contractor)
2011 - 2011
Assessed a 75 user Access application used to manage corporate Internal Audit projects over a WAN (Wide Area Network). (Windows XP, Access 2007, VBA)
SUN LIFE FINANCIAL
Consultant (contractor)
2010 - 2011
Developed prototype for automating monthly financial close reporting for division with $1.6 billion annual revenue and $393 billion business in force. The original system comprised 17 Access...
ST JUDE MEDICAL
Consultant (contractor)
2010 - 2010
Migrated a large (400 table, 75 form, 8000 lines of code) Access- based Manufacturing Resource Planning (MRP) system from a design using a Great Plains MRP back end to one based on SAP MRP...
FM GLOBAL
Consultant (Contractor)
2010 - 2010
Analyzed migration of corporate usersí MS Office 2003 files in Windows XP to MS Office 2007 / Windows 7. Determined that conversion of most files to Office 2007 format was unnecessary. Assessed...
BANK OF AMERICA
Consultant (contractor)
2009 - 2009
Oversaw two corporate auditing applications (Access/SQL Server) while their creator was on vacation. Enhanced the Access front end; wrote stored procedures for SQL Server back end. (Windows XP;...
FISH & RICHARDSON
Consultant (contractor)
2008 - 2009
Enhanced/maintained billing system for law firmís European office. Worked with Access forms and reports, maintained SQL Server back end. Shifted logic from Access/VBA to T-SQL stored procedures...
HARVARD SCHOOL OF PUBLIC HEALTH
Consultant
2001 - 2008
Developed and enhanced over 7 years a system to identify candidates for cancer studies. The system acted as a conduit for candidates' medical records between local hospitals and research study...
PUBLIC SECTOR PARTNERS
Consultant (contractor)
2006 - 2007
Member of team that developed & maintained Access/Excel applications for paying monthly premium subsidies for 60,000 Massachusetts participants in Medicare Plan D. The system calculated payments...

Keywords

Microsoft Access
VBA
data analysis
SQL
relational design
ETL
My Snapshot
IT & Programming
10
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
Total
Milestones
Hours
Reviews
5.0
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
Bruce_Dodds
Type
Individual
Member Since
November 2013
Elance URL
Verifications
0
Groups
Bruce Dodds | Elance

Bruce Dodds