Microsoft Access / VBA Microsoft ASP.Net / C# / XML Microsoft ...

elderlyscatteredInternet and Web Development

Jul 5, 2012 (5 years and 14 days ago)

334 views

Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
SERVICES
System design, implementation and support of custom database information systems for desktop,
enterprise and web applications.
Data driven interactive web site design and management.
State of the art techniques backed by an extensive knowledge of several technologies and platforms.
A team of consultants with high-quality, comprehensive services and a variety of expertise to create a
wide range of desktop, web and enterprise solutions.
Enhancing business processes by applying relational database concepts to maximize the usefulness of
information and enhance the efficiency of operation, while maintaining a smooth transition from the old
process to the new environment.
Creating Windows and web based user friendly interfaces for data entry, retrieval and reporting.
Working with clients in an interactive fashion to understand their needs and how they do business, then
translate this information into usable applications, from conception to production! If you more or less know
what you need, we can make it happen. We specialize in 'going the extra mile'. Exhaustive application
testing is done throughout the development cycle.
Adding a professional 'look, feel and functionality' to an existing user-created prototype application.
AFFILIATIONS: Microsoft MVP (Access). Number Two Microsoft Access Expert on Experts-Exchange.com.
Hall of Fame member of the Microsoft Access Users Group of San Diego. Treasurer of Blues Lovers United
of San Diego, 1999-2008.
TECHNOLOGY / PLATFORMS
This entire PDF created 100% in Microsoft Access
Relational Database Concepts
Microsoft Access
Microsoft Visual Basic for Applications (VBA)
Microsoft ASP.Net / C# / XML
Microsoft Visual Studio.Net
Microsoft SQL Server
Microsoft ActiveX Data Objects (ADO)
Microsoft Data Access Objects (DAO)
Adobe CS4 Web Premium
Page 1 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
FEES / PAYMENTS / SUPPORT
Fees are determined by the complexity of the project, the required time frame to complete the project and
whether or not any royalties may be involved.
General.
In all cases, every effort is made to work within a target budget that a prospective client may have in
mind - IF the client has a realistic concept of the complexity, scope and related time frame to complete the
project. Sometimes, however a client may initially feel that "this won't take too long..." or "this doesn't look
too hard...". This however, may not be realistic with respect to the need for a bug free, user-friendly end
product with a professional look and feel!
Client Target Budget.
Normally, ADI charges an hourly rate for time and materials since experience has shown that variables and
uncertainty make the complete requirements unpredictable in advance.
Hourly Fee.
If the complexity, scope and related time frame are well understood by the client and ADI, a fixed fee may
be quoted for a given project.
Fixed Fee.
Hourly fees are invoiced one per week and due on receipt.
Fixed fees are made in several equal payments over the duration of the project.
For both cases above, once a commitment has been made between the client and ADI to proceed with the
project, a retainer fee is required which is non-refundable in the event the project is canceled by the client.
Payment Schedule.
ADI will work with the client on an hourly or fixed fee basis to implement any changes or enhancements.
ADI is generally available via phone, cell phone and email. Every effort will be made to return client
inquiries in a timely fashion. Clients are notified well in advance of any time when ADI consultants my not
be available, such as vacations, etc.
Support.
Upon client acceptance of the project, ADI offers lifetime warranty which covers any non-Microsoft related
program bugs at no additional cost to the client. The warranty is cancelled immediately should any other
developer or organization not authorized by ADI perform any work on the project.
Warranty.
When changes, enhancements or new releases are made to the project, clients can easily download
updates directly from the ADI web site. When necessary (and geographically practical), ADI will make on-
site visits.
Application Updates.
Bug free, user friendly applications and 110% client satisfaction are the top priority goals of ADI. And our
track record over the history of the company backs this up.
Bottom Line.
Page 2 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CLIENTS / PROJECTS / REFERENCES
Prospective clients are encouraged to check the following references!
Database architect position with Southern
California Edison. Complete redesign of a
mission critical Quality Assurance database
into a start of the art, user friendly, multi-
user application working on the SCE wide
area network … with new features and
functionality non-existent in the original
version. Original version design time was
18 months. Redesigned version – 3 months!
Accepted Full Time position in June 2007 as
Database Architect. Ongoing Microsoft
Access database projects.
Southern California Edison, Rancho Cucamonga, CA
Ongoing enhancements including invoice
and purchase history modules for the
Jewelry Designer Manager product,
currently sold on the internet, with over
2000 end users.
Bejeweled Software Company., Poway, CA
858.461.1167 ... Barbara Carleton
Ongoing enhancements including a multi-
user interface to an existing job database
which tracks company telecommunications
projects.
Solar Communications International, San Diego, CA
619.243.2750 ... Jennifer Smith
Development of a Job Tracking System for a
nationwide signing service business,
including job entry, invoicing and
statements. Features include automated
notary finder, phone dialer module and zip
code mileage calculation.
Notary Brothers, San Diego CA
858.248.7834 ... William Durant
Development of a Permit Tracking System
for a new off-road area in the desert.
Includes real-time display of exact number
of groups, permits / vehicles and a lot more.
Bureau of Land Management, El Centro CA
760.337.4430 ... Joya Szalwinski
Development of a Job Tracking System for a
jewelry repair business, including job entry,
invoicing and statements.
M. Parkinson Co, Milwaukee, WI
414-774-5445 ... Mark Parkinson
Ongoing development and management of
a FlashMX / ASP.Net database driven
website: www.frankfortkyrealestate.com
HMC Associates, Frankfort, KY
502.695.4321 ... Jack McDonald
Complete design and development of a
Flash MX based website:
www.southwestmillworksinc.com
Southwest Millworks Inc, San Diego, CA
858.578.4640 ... Chris Hogan
Page 3 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CLIENTS / PROJECTS / REFERENCES
Prospective clients are encouraged to check the following references!
Development of a Multi-user asbestos
verdict tracking database, currently being
used by Lloyds of London and several
additional law firms.
Hancock, Rothert, & Bunshoft, LLP Attorneys
San Francisco CA,
415.403.8822 ... Michael Bradley
Added all Flash elements to website. All
Flash based site coming soon also.
Brushed Metal Design, Costa Mesa CA
714.549.2000 ... Tony Anderson
Multiple engineering, database and IT
consulting projects, including
implementation of a camera security
system, barcode / label generation system,
UL/FCC/CE system certification, server and
workstation backup strategy and several
other miscellaneous projects.
Sunrise Imaging Inc, Santa Ana, CA
949.252.3003 ... Dennis Childs
Development of an Real Estate Appraisal
Information Management System to
manage the collection and processing of
real estate properties, public records and
listing services.
HMC Associates, Frankfort, KY
502.695.4321 ... Jack McDonald
Ongoing numerous emergency fixes,
modifications and enhancements to two
different database used for medical billing
audit analysis.
Integrated Revenue Management, Carlsbad, CA.
760.448.1051
Data conversion and several ongoing
enhancements to a multi-user public finance
database which tracks company business
deals.
Stone & Youngberg, La Jolla, CA
858.795.8703 ... Ken Holman
Development of a multi-user Job
Management System for controlling an
international photography business.
Campus Photography International, La Costa, CA
760.943.1730 ... Tim Murray
Ongoing development and management of
a FlashMX / ASP.Net data driven online
training website: www.odlearning.com
On Demand Learning, Greeley, CO
970.576.2964 ... Howard Major
Ongoing development of a photography
database which will interface to a web front-
end used for the sale of photos on the
internet.
Grover Enterprises, Seattle, WA
425.643.0374 ... Jim Grover
Multi-user Export Tracking System for the
International Trade Division of the Arizona
DOC.
Arizona Department of Commerce, Phoenix, AZ
602.640.2513 ... Dan Bjerk (the j is silent). Dan is now at
U.S. Department of Commerce in Phoenix.
Page 4 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CLIENTS / PROJECTS / REFERENCES
Prospective clients are encouraged to check the following references!
Emergency 'fix' to an existing complex
report, including the creation of a 'chemical
source state examination and correction
utility' used to generate the report. This
eliminated a previously manual process of
correcting special exceptions present in the
source data for the report.
Occupational Services, Inc, San Diego, CA
619-252-2211 ... Nick Rinaldi
Development of a point and click utility to
replace a manual process of manipulating
source data used to generate a complex
report for the City of San Diego.
Downstream Services, Inc., Escondido, CA
760.746.2544 ... Judy Frankel
Implemented an internal rate of return
financial calculation module for an existing
company database.
Debt Acquisition Company of America, San Diego, CA
619.220.8900 ... Howard Justus
Ongoing enhancements and bug fixes to an
existing multi-user conference registration
database.
The Governance Institute, La Jolla, CA
858.909.0811 ... Kevin Kantz
Development of a multi-user Payroll Control
System for processing hourly employee
time clock data, tracking payroll history,
updating payroll status and creating various
payroll reports.
Kendall Farms, Fallbrook, CA
760.731.0681 ... David Kendall
Development of a multi-user Work Release
Program Management System which
manages the booking, scheduling and work
history of court ordered work for various
offenses.
San Diego County Sheriff's Department, San Diego, CA
619 263 8667 ... Ken Hunrichs
Development of a multi-user Marketing
Tracking System to manage a large
manufacturing rep organization interfacing
between all branches of the military and
several manufacturers selling to the military.
Chilton Marketing Company, Oceanside, CA
760.940.8699... Jovita Mahin
Implemented enhancements to a
telecommunications Project Tracking
System for the building of cellular sites.
Reliant Ventures, Inc., Santa Barbara, CA
805.964.3094 ... Rick Dochterman
Page 5 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CLIENTS / PROJECTS / REFERENCES
Prospective clients are encouraged to check the following references!
Joint development of a personal data
manager for the retail market, targeted
mainly for notebook/laptop systems with
users on the go. This product uses
advanced elements of Microsoft Access to
incorporate several novel features, in
addition to focusing on high performance
and ease of use.
8229 Corporation, Scottsdale, AZ
Bill Goldstandt
Phase 2 of a multi-user company database
including a Conference Registration and
Tracking System.
Exodus International North America, Seattle, WA
206.784.7799 ... Bob Davies
Multi-user Therapy Tracking System to
manage agencies, therapists and daily
treatment activity of Patients.
Home First Physical Therapy, Inc., Corpus Christi, TX
512.851.2845 ... Lisa Roberson
Created a Stock Market Analyzer tool which
automates the monitoring of stock market
activity and decision support processes
relating to the stock market.
8229 Corporation, Scottsdale, AZ
Bill Goldstandt
Phase One of a multi-user Conference
Registration and Tracking System.
Exodus International North America, Seattle, WA
206.784.7799 ... Bob Davies
Factory automation Report Generator
Module
Advanced Digital Research, Tustin, CA.
714-505-4004 ... Dennis Childs
Partial development of a multi-user
international student tracking database to
manage curriculums, student profiles,
accommodations and facilities, etc.
ILISA Spanish Language School, San Jose, Costa Rica
Thorwald Westmass
Integration of Contacts Unlimited (see
below) with the 'Praxis' sales manager
product - sold in CompUSA and other retail
stores.
Delphi Systems, Dallas, TX
972.243.7995 ... T.K. Lalangas
Created Contacts Unlimited, a multi-user
relational database retail product featuring
contact management, event scheduling and
project tracking including a complete
international postal database.
Created the Pro Series
(Scheduler/Project/Postal) for use by
database developers to enhance existing
applications.
Access To Business, Seattle, WA
206.644.5977... Jim Grover
Page 6 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CLIENTS / PROJECTS / REFERENCES
Prospective clients are encouraged to check the following references!
Automated data entry, data retrieval and
reporting system to replace DOS-based
data entry system. Combined databases
and greatly simplified data entry and
reporting process.
Citgo Oil Co., Corpus Christi, TX
512.844.5774 ... Jeff Nesloney
Report creation and selection interface to
extract data from mainframe database and
generate charts in Excel using OLE
automation. Went from manual process to
totally automated point-and-click process.
Citgo Oil Co., Corpus Christi, TX
512.844.5774 ... Jeff Nesloney
Restructure and creation of an enhanced
user interface and reporting system for oil
well tracking and financial analysis. This
included combing two separate databases
into a single relational database.
Manti Resources, Corpus Christi, TX
512.888.7708 ... Robert Rosales
Creation of an enhanced multi-user
interface and front-end to a Btrieve/DOS-
based inventory control system. This
included integrating two similar databases
into a single relational database to be used
both by inventory and marketing/sales
personnel
MAI Systems, Irvine, CA
800.624.1024 ... Julie Wellman
Created an automated information
download and tracking system to retrieve,
modify and archive data from an on-line
real estate information service.
Marcus & Millichap Commercial Real Estate Company, Irvine,
CA
714.538.5075 ... Jack Hopkins
Multi-user prospect tracking, seminar
scheduling and reporting system for a
hospital fund raising organization within a
medical center.
Western Medical Center, Tustin, CA
800.707.1707 ... Doug Corbin
KNOWLEDGE BASE
SOFTWARE
Microsoft Access Relational Database
Microsoft Visual Basic for Applications
Microsoft C#
Adobe CS4 Web Premium
Windows - All Versions
Microsoft Visual Studio .NET
KNOWLEDGE BASE
SYSTEMS
IBM Compatible PC's
MAI 3000 / IBM RISC 6000
Computer Aided Dispatch
Vehicle Tracking
E911 PSAP Emergency / Geobase
Process Control / Automation
Page 7 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
KNOWLEDGE BASE
SOFTWARE
MAI / BBXx Business Basic
Firmware and Assembly Languages
Fortran IV
HARDWARE
Computer Systems /Prototype Development
Custom Controllers /Microprocessor
Custom Interfaces /Simulators / Testers
KNOWLEDGE BASE
SYSTEMS
UPC Bar Code Scanners
PROJECT
Management
Specifications
Scheduling
Documentation
Production Ramp-Up
Team Leader / Member
Page 8 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
DEVELOPMENT TOOLS
Dell Precision M90 laptop, Windows XP Professional / Office 2007
Gateway M675 laptop P4 3.2 Ghz Windows XP Pro / Office 2003.
Microsoft Visual Studio.Net and all related .Net tools.
Microsoft SQL Server 2008
Adobe CS4 Web Premium
Microsoft MSDN Universal Subscription.
Multiple external backup systems.
APC battery backup systems for power failure protection.
Extensive Microsoft Access library of tools and functions.
Subscriber to multiple Microsoft Access and .Net related technical publications and newsletters.
Hi-Speed DSL Internet access.
COMPANY HISTORY
Established in 1984 as Emron, inc by founder and CEO Joe Anderson in Diamond Bar, CA. Provided
database and computer consulting services in the Los Angeles area until late 1994.
Relocated to the South Texas area in late 1994 as AllData, inc., continuing to provide database consulting
services both nationwide and to the international market.
Relocated back to Southern California (San Diego) March, 1998.
Relocated to Rancho Cucamonga, CA, November 2007.
Specializing in Microsoft Access relational database design since release 1.0 (circa 1992), completing
numerous projects for clients nationwide. Currently focusing on data driven (web and desktop) utilizing
Macromedia FlashMX connected to various database backends such as Microsoft Access and SQL Server.
Developer of 'Contacts Unlimited' and 'Pro Series' products for Access To Business (A2B) located in
Seattle, WA, marketed worldwide by A2B and other sources.
Developer of a multi-user Computer Aided Dispatch database system used throughout the ambulance
business nationwide for Recordata West, Burbank, CA. The entire product was developed in Business Basic
/ BBXx / IBM Risc 6000 platform.
Page 9 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CEO RESUME
Joe Anderson
CEO & Chief Database Architect
AllData, inc.
Rancho Cucamonga CA
800.DATA.311
www.alldatacorp.com
project@alldatacorp.com
Microsoft MVP 2009 (Access)
Experts-Exchange.com Top Expert
(DatabaseMX)
--------- Education --------
California State University Long Beach
Bachelor of Science, Electrical Engineering
3.75 GPA / Cum Laude / Deans Honor List
Database Architect.
2006-current
Southern California Edison
Rancho Cucamonga CA.
Microsoft Access Databases, 24x7x365 :-)
CEO and Chief Database Architect.
1985-current
AllData, inc., Rancho Cucamonga, CA,
Rockport TX, and, Emron, inc., Diamond Bar,
CA.
Database and Computer consultants.
Multiple Microsoft Access-based products, projects and multi-
user applications. Several static and data driven websites
utilizing both Microsoft and Adobe/Macromedia products.
Microsoft Visual Basic project for environmental services
company - AeroComp, Costa Mesa, CA.
Computer Aided Ambulance Dispatch System - Recordata
West, Burbank, CA.
Factory automation Report Generator Module - Advanced
Digital Research Inc., Irvine, CA.
Data security analysis resulting in sabotage discovery -
National Business College, Long Beach, CA.
Several PC computer systems installations.
Page 10 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CEO RESUME
Advanced Development
Group leader; system design; firmware and
digital circuit design.
1977-1985
MAI Systems (formerly MAI / Basic Four
Inc.),
Irvine, CA
Computer Systems Mfg.
Managed development of an advanced personal office
workstation prototype.
Touch screen interface system software / hardware /
firmware.
Generated VLSI strategy for company.
Group leader of system, hardware, firmware and production
release for the MAI 2000 computer system.
Senior Project Engineer
System, hardware & firmware design and
production release of four microprocessor-
based products.
1976-1977
Comtec, Inc.,
Irvine, CA
Process Control Systems
Designed process control computer and Remote
Temperature Test system.
Designed Programmable Clean and Etch and Crystal Bank
Sorter systems.
Senior Development Engineer
Design team member on laser scanner for
UPC bar code point of sale system.
1975-1976
Coherent, Inc.,
Palo Alto, CA
Laser Systems Mfg.
Assisted POS manufacturers in defining interface
requirements.
Hardware and firmware design of several interface circuits
for various POS terminals.
Development Engineer
Analog, digital hardware and systems design.
1969-1975
Hughes Aircraft,
Fullerton, CA
Ground Systems Group.
Microprocessor sub systems for submarine display system.
Radar video distribution system; Trackball interface for a
radar display system.
Multiple smaller projects and studies.
Page 11 of 12
Database Consultants 800.DATA.311
www.alldatacorp.com project@alldatacorp.com ©2010 AllData, inc.
Utilizing:
Data Driven Applications
Microsoft Access / VBA
Microsoft ASP.Net / C# / XML
Microsoft SQL Server
Microsoft Visual Studio.Net
Adobe CS4 Web Premium
CEO RESUME
Student Programmer.
1967-1972
Cal State Long Beach, Long Beach California
As an undergraduate ... developed several programs written
in Fortran IV for graduate students, including a simulation of
a phased array radar system.
Page 12 of 12