Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Frank Dunn | Elance
 
176985602337900
Last Sign-in: Apr 10, 2014

Frank Dunn

Automated Solutions Provider
   United States
  |  5:55 pm Local Time

Overview

Automated Solutions Provider
Systems Analysis/Programmer

The primary skill I will be offering on ELance is my indepth knowledge of and experience with the MS Office and VBA environment with a secondary avenue to provide development of Visual Basic/Access/MS Office applications and Websites from concept to design, implementation, and maintenance.

I do have many additional skills/talents pertinent to providing effective business solutions but for now I am going to concentrate on Excel/Access/VBA/SQL projects to keep the scope small,...

Read More »
Nov 21, 2013|Database Administration|$980|Completed
|
5.0
Oct 7, 2013|Statistics|$200|Completed
|
5.0
Jun 5, 2013|Other IT & Programming|$0|Completed
Feb 10, 2012|Software Application|$50|Completed
|
5.0

View All »

Portfolio

This application was developed for American Insectaries which monitors insect...
Data acquired from Avocado and Citrus Groves Field devices is downloaded from the Field...
A special feature was built which allows the User to select specific Avocado and Citrus...
This is an example of the report generated from one of the many Avocado and Citrus...
This feature allows the user to link the the UC Davis website and specify the date span...
The Weather Data is generated from the UC Davis website and then downloaded. This...
Here the user is about to Import the Weather Data generated from the UC Davis database...
This worksheet in the workbook explains the Incremental Backup Schema for the user.
Here you can see the Incremental Backups created during each Field Data Import Cycle....
Hickok-Dible maintains years worth of monthly Budget and Income workbooks. What...
The ability to chose between 'Budget' and 'Income' is only given when the workbook is...
Here the difference is obvious between the two different operating modes offered in...
What began as a fairly simple Shopping Cart Order Data Download for Analysis and...
The Menu Form is the central control point for the application. The Menu was used...
The Import Form allows the user to specify the Folder which contains downloaded...
The Report Form allows the user to specify a 'span date' to control the data extracted...
This Form allows the User to review all Orders and recreate/produce an Invoice for any...
This is a complex form designed to maintain a SKU Master Table within the Excel...
When data has been changed a "Yellow" bulb is used to note what data has been...
Five support Forms are available from the SKU Maintenance Form: 1. Add a SKU...
The Codes Maintenance form consists of three 'tabs' where one of the three code tables...
The Reports Form allows the User to generate one or more reports for a specific Date...

Skills (15)

Tested
System Analysis
Data Structures
Microsoft Excel
Microsoft Word
Microsoft Access Administration
Visual Basic
MySQL Administration
HTML
Java
Web Services
Microsoft Visio
Accounting
Microsoft SQL Server Programming
Microsoft PowerPoint
DHTML

Service Description

Experienced Programmer/Systems Analysis/Database Designer/Solutions Provider in a variety of computing environments.

I am a Professional Programmer/Systems Analysis/Database Designer with a broad foundation utilizing a variety of programming languages and data manipulation tools/techniques for Fortune 500/100 Corporations.

In recent years, I have leveraged these skills and experiences to provide cost effective and professional solutions to many Small Business Owners who benefit from solutions which are economically feasible and prove to be solid deliverables.

My solutions are designed to provide a lasting value while being easily maintained... whether by me or a technician unfamiliar with the application.

I find the Small Business environment to be the most rewarding due to the minimal level of project management which results in the quick resolution of design specifications/issues allowing me to progress rapidly and provide professional solutions effectively, economically and in a timely fashion.

I have proven myself by providing automated solutions to solve everyday business requirements with practical and efficient automated procedures/solutions/applications.

I am particularly skilled in capturing data from diverse resources to satisfy the data requirements of the business solution while providing clean, clear, maintainable code and documentation.

I "go-the-extra-mile" to provide solutions which satisfy the business requirements while being...

Read More »

Education

UTSA - University of Texas - San Antonio
BBA Finance
-
TAMU - Texas A&M University
B.S. - Computer Science w/EE
-

Keywords

Excel
VBA
Forms
Macros
Visual Basic
Programmer
Systems Analyst
Data Mining
CSV
EDI
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
Total
Milestones
Hours
Reviews
5.0
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
BitFiddler
Type
Individual
Member Since
May 2009
Elance URL
Verifications
0
Frank Dunn | Elance

Frank Dunn