Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Timothy J. | Elance
 
176985602337900
Last Sign-in: Jul 9, 2015

Timothy J.

MS Office Desktop Tools Developer
   United States
  |   Honolulu, HI
  |  10:36 pm Local Time

Overview

Minimum Hourly Rate $45

Reduce Redundant Tasks, Reduce Errors and Save Money

Having worked extensively both as architects/designers and as end users of Microsoft Of, we know the needs, frustrations and expectations of users. We keep our interfaces as intuitive and user-friendly as possible. Simple is key.

We have worked in a wide range of industries for such clients as Merrill Lynch, Fannie Mae, Goldman Sachs, New Yorker Magazine, Memorial Sloan Kettering Cancer Center, Planned Parenthood, and Human Rights First.

In developing software for clients, we have...

Read More »
Jul 1, 2013|Database Development|$3,513|Working
Apr 21, 2013|Database Development|$543|Completed
|
5.0
Aug 1, 2012|Database Development|$1,405|Completed
|
5.0
Aug 3, 2011|Database Development|$163|Completed
|
5.0

View All »

Portfolio

Database created for Human Rights First, Human Rights Watch, and the ACLU to track...
Access Database for Planned Parenthood to track legislation and elected officials.
MS Access 2007 Contact Management Database
Made it possible to filter the contents of one page field based on the selection in...
This forecasting model was created for Ipsen Pharmaceuticals. Nearly 21,000 inputs...
The purpose of the model forecast advertising sales for The New Yorker Magazine. This...

Skills (10)

Tested
Microsoft Excel
Microsoft Excel 2003 Test
My Score
avg
Microsoft Excel 2007 Test
My Score
avg
Microsoft Access Administration
Access
My Score
avg
Microsoft Access 2003 Test
My Score
avg
Microsoft Access 2007 Test
My Score
avg
Microsoft Word
Microsoft Word 2003 Test
My Score
avg
Visual Basic
Visual Basic 6 Test
My Score
avg
English
U.S. English Basic Skills Test
My Score
avg
FrontPage 2000
HTML
Adobe Premiere
VB.NET
VBA
VBA
My Score
avg

Service Description

TJs Tools finds or creates the best solution to fit your requirements. Whether it be automating a weekly mail merge function or creating a full-fledged database from scratch, we work hard to ensure the specifications are crystal clear before beginning work. This ensure that all stakeholders are clear on expectations and that no money is wasted on miscommunication.

With more than 18 years of experience with MS Office, SQL Server and web programming, we have developed an extensive library of features that immediately become a part of your solution from the moment we begin work. Once such feature is our global error handling routine that is particularly useful during Beta testing -- this feature will send us an email in the unlikely event that an error is generated. The email contains the exact line number where the error occurred, the progression of events that led up to the error, the username and machine name where the program was running and optionally a message from the end-user describing in more detail what happened. This feature alone allows us to address issues within minutes instead of days.

A few examples of work we did some years ago:
Sloan Kettering Memorial Cancer Center: To over-ride the inherent clumsiness of MS Word's "protection" feature and "forms" feature, we completely remapped the keyboard so that users working in a specific template could not type in various areas of the document. This made it possible to be like a form, but with all the built...

Read More »

Employment

Altamont Country Kennels
Access 2003 Developer
2009 - 2009
Revised queries and interface for client on guru.com. Communicated all needs and specifications via email and over internet connections.
BAS Services & Graphics, LLC.
MS Access 2007 Database design, architecture SQL Server
2009 - 2009
Worked with client to create rich MS Access front-end with a TreeView control for end-users to generate crosstab queries on data generated from remote sensing devices and input to SQL Server.
Technology Sales Leads LTD
MS Access 2000 , Excel 2000 Development Architect
2009 - 2009
Created Excel front-end to connect to 2 backend MS Access databases. All technology was in Office 2000 and all communication was via the internet. Interface allowed for end-user to choose...
Access Safety LLC
Excel 2007 Developer
2008 - 2009
Dependent Page Filters: Client was seeking a way to get Page Fields in MS Excel Pivot tables to display data based on information displayed in other page fields. For example, if both State and...
Rapa Nui Youth Involvement Program
Applications Developer
2008 - 2009
MS Access Database design, architecture MS Excel template design and automation HTML, Javascript & Google Maps API implementation http://www.terevaka.net/dc: Worked with client to create a...
Tinga USA
Excel 2003 Develope
2008 - 2008
Usage Report: Created an Excel add-in for a Mexican food restaurant chain. Add in loads and removes custom menu items. Application opens text files that are generated by the Tinga Point of Sale...
Solomon Enterprises
MS Access VBA Developer
2008 - 2008
Batch Processing: Wrote VBA code for client that allowed for them to add hyperlinked files to their access database while simultaneously insuring data integrity and the existence of all...
Planned Parenthood of Orange and San Bernardino
Applications Developer - MS Access/HTML/ASP
2005 - 2008
Legislation Database: Designed database for tracking all elected positions from school board to state governor, including complete contact information, staff, meetings, choice advocacy positions,...
Fannie Mae
Independent Consultant
2006 - 2007
Amortization Calculation, Automation and Reporting for Financial Restatement: Designed numerous applications in MS Excel and MS Access to enhance and automate the amortization processing for...
Human Rights First
Data Migration Applications Developer
2004 - 2005
GetActive: Served as lead programmer in migrating data from CMS OnContact software to an online member management program called GetActive. Utilized MS SQL Server, MS Access and MS Access VBA to...

Education

New York University School of the Arts
Bachellor of Fine Arts in Acting
1980 - 1982

Keywords

VBA
VB
.NET
Word
Excel.Access
Powerpoint
WordBasic
Macro
Automation
My Snapshot
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
0
0
48
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
tjeffryes
Type
Individual
Member Since
May 2008
Elance URL
Verifications
Groups
Timothy J. | Elance

Timothy J.