Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Drew L. | Elance
 
176985602337900
Last Sign-in: Apr 19, 2014

Drew L.

Developing Professional Software for Business
   Thailand
  |  9:05 pm Local Time

Overview

Minimum Hourly Rate $27

Offering more than 20 years of experience designing, developing, and optimizing MS Access/VBA/SQL Server database applications and MS Office automation across a wide variety of industries. I have a great understanding of business processes and the ability to listen to the problems faced by the client in their work process and to translate that into a user friendly application that effectively addresses those issues.

Read More »
Mar 27, 2014|Database Development|$0|Working
Mar 15, 2014|Database Development|$220|Working
Oct 24, 2013|Database Development|$140|Completed
Oct 19, 2013|Database Development|$151|Working

View All »

Portfolio

From this Property Management screen the user can easily manage all aspects for each...
Detailed information regarding each of your tenants can be maintained on the screen....
Mini-Storage rental information can be maintained on this screen. The tenant, their...
This handy Reports Filtering and Sorting tool allows you to easily tailor the output of...
This tool actually provides a way to filter the records by any field or combination of...
This screen displays the result of the production analysis for various aspects of this...
This Analysis Screen provides a snapshot of an employee's productivity/activities for...
This screen lists the results of an analysis of all production data in accordance with...
Performance can be graphically illustrated on the fly by adjusting the controls at the...
Searches for data by any field or combination of fields in the dataset. Also provides...
Displays a listing of all Marketing Materials sent to prospects.
Depicts the training history and study groups for the selected student.
Maintains all lead information for the selected client including links to their web...
Provides a simple interface from which canned letters can be customized and printed out.
From this screen customized mailmerged letters can be generated from scratch or applied...
This tool allows the user to quickly spot overlapping intervals of time logged by...
This form is utilized by Payroll personnel to quickly manage the weekly payroll hours....
This tool is used by Payroll personnel to review employee hours and to approve/reject...

Skills (5)

Tested
Microsoft Access Administration
Microsoft Access 2007 Test
My Score
avg
Microsoft SQL Server Programming
Visual Basic
Data Modeling
Microsoft Excel

Service Description

I am a freelance developer with more than 20 years of experience in the computer industry. I have created applications for a wide array of industries and companies of every size. This range of experience has given me the ability to understand your process requirements and to translate those into cost effective and user friendly applications.

Read More »

Employment

Bausch & Lomb
MS Access/MS Excel/MS Outlook/Visual Basic Application Developer
2008 - 2008
For this sales team I worked on 2 projects. The first involved automating the distribution of sales reports. The existing problem was that their department maintained several access databases,...
Joyful Eyecare
MS Access/Visual Basic Application Developer
2008 - 2008
For this client I converted their MS Access prototype to a commercial grade MS Access application. The application is an office management tool for Optometrists to use in-office for capturing...
Maggard Information Services
MS Access/MS Excel/MS Outlook/Visual Basic Application Developer
2008 - 2008
I took over this project from a prior developer to complete work on this automated email reporting and response system. The system receives emails, via MS Outlook, containing tenant delinquency...
Gedeon Solutions
MS Access/Visual Basic Application Developer
2008 - 2008
For this client I created a password protected Access 2007 program to monitor other companies and websites for SAP coursework/software infringement violations. The system allowed information...
Delvies Plastics, Salt Lake City
MS Access/Visual Basic Application Developer
2008 - 2008
Created an Invoice Generation application. The client sells products on the web and would receive multiple text files denoting the products purchased and customer information. I created an...
MiData Inc.,
MS Access/Visual Basic Application Developer
2007 - 2008
Acting as a subcontractor to a project for Bridge Bank, I designed and developed a Fee and Invoice tracking system for the commercial properties loan department. The system tracks all transaction...
Data Transfer Solutions
MS Access/Visual Basic Application Developer
2007 - 2008
For this client I coded various import and data transformation routines. The client receives patient billing information from various medical associations in a variety of formats. The client...
Glenridge Solutions
MS Access/Visual Basic Application Developer
2007 - 2008
For this client I performed various coding tasks to enhance their ER Diagram Generation product. These tasks including copying files between databases, creating SQL strings and storing them in...
Children’s Community School
MS Access/Visual Basic Application Developer
2007 - 2007
Created a donor tracking database application to allow for the receipt and administration of pledges and payments made by the various donors to this school system. The system was capable of...
Bob Thomas Books
MS Access/Visual Basic/Dreamweaver Application Developer
2007 - 2007
Created an Access database for logging sales calls at various golf courses around the country and tracking open tasks and commissions. After the Access DB was created for onsite usage a Website was...
ChemAssist
MS Access/Visual Basic Application Developer
2007 - 2007
Created a PO/Invoice processing and Inventory Management application. Purchase Orders and shipment information was tied to the Inventory database to alert the user when stock needed to be...
Carroll’s Martial Arts
MS Access/Visual Basic Application Developer
2007 - 2007
Created a business management application for this Martial Arts Academy. The application provided for the easy collection of information on students and their family members, creation of...
Davis Consulting
MS Access/Visual Basic Application Developer
2007 - 2007
Created a keyword search and reporting tool used to search databases of course information in Excel format to determine the applicability of any particular course to the client’s needs. The...
BRIDGE BANK
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2006 - 2006
Created a currency exchange management system. This system calculated the buy/sell price of foreign currencies based upon exchange rates and contracted rates for exchange services. It prepares...
A-SEMI-SERVICE, INC.
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2004 - 2006
Created a operations management system to manage all aspects of this new operation including purchase orders, RMAs, contractor time and expenses, parts inventory, shipping and receiving...
3PARDATA
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2005 - 2005
Created a sales commission payment and reporting system. This application calculated each sales person and managers commission reports based upon a very complex set of rules and fluctuating...
BANK OF AMERICA
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2004 - 2004
Created Cross Referral/Scorecard reporting management system. This system was designed to allow the financial advisors and the bankers to report business booked and referred to each other....
BEA HK LTD, Hong Kong
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2004 - 2004
Created Legal Document Tracking and Reporting System. This system was designed to allow pertinent information regarding the clients legal documents (including a PDF image of the document) to be...
EPRI
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2003 - 2004
Debugged and modified an existing Excel VBA application for the original developer that left the company. Created a Visual Basic application that uses an Access MDB file as the backend. This...
LEGACY MARKETING GROUP
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2003 - 2003
Customized the Ernst & Young Documentation Template to make the branches of the TreeView object user modifiable via input forms. Created functionality to allow the creation and storage of...
SAN FRANCISCO HEALTH PLAN
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2003 - 2003
Performed data migration from legacy denormalized structure to SQL Server 2000 normalized structure. Created Visual Basic.Net windows application used to perform user specified database...
WELLS FARGO BANK
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2002 - 2003
Performed various upgrades and modifications to Wells Fargos Real Property Reporting and Management systems. The bulk of the work involving upgrading the Access client application to extract...
FIRST REPUBLIC BANK
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2002 - 2002
Developed a Fee Waiver client-server Access project. This application presents client account information of non-qualified customers and requires the bank officer to indicate related account...
INFORMATION INTERFACE SYSTEMS
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2002 - 2002
Revised an existing MS Access application to encompass the various external processing steps into a single application. The application produces passthrough queries to run against an Oracle...
COUNTY OF ALAMEDA
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2001 - 2002
Developed a Contract Insurance Management system. This system provides a mechanism to manage the insurance certification process required of all contractors to the County of Alameda. Utilizing...
OCTAGON RISK SERVICES
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2001 - 2001
Performed various modifications/additions to the various Risk Management applications created for this firm formerly known as Professional Risk Management.
INFORMATION INTERFACE SYSTEMS
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2001 - 2001
The module created for this Wells Fargo application involved a 2 step process. The first step required the importation of raw data from text files and the examination and categorization of that...
SAN FRANCISCO HEALTH PLAN
MS ACCESS/VISUAL BASIC APPLICATION DEVELOPER
2001 - 2001
This project involved the creation of a reporting module that would produce SQL cross tabulation reports based upon the user specified criterion. This reporting tool is capable of summarizing...

Education

Dartmouth College
BA
1978 - 1982

Keywords

Access
Database
VBA
Visual Basic
Outlook
My Snapshot
IT & Programming
3
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
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
tootwotrue
Type
Individual
Member Since
June 2007
Elance URL
Verifications
Groups
Drew L. | Elance

Drew L.