DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
  • Rancho Cucamonga,
  • California,
  • United States of America
Member Since: 2006/09/11
Industry: Computer & IT
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month0
Total points11,522,596
Questions: 19
Solutions: 9005
Articles:
Videos:
Tutorials:
Posts:
Group Discussions: 16
Professional Background
(See Full Biography below)
More
Education
California State University Long Beach
Bachelor of Science, Electrical Engineering, 3.75 GPA  Cum Laude, Deans Honor List
Engineering and Computer Science
More
Full Biography

Joe Anderson
Rancho Cucamonga CA
?Replace(Replace("ja alldatacorp=com" ,"=", ".")," ","@")
==============================================
Awarded Microsoft MVP, Microsoft Access, July 1, 2009 - Current
https://mvp.microsoft.com/en-us/PublicProfile/4025508?fullName=Joe%20Anderson
==============================================

Seventh Annual Top Expert Award 2010
Sixth Annual Top Expert Award 2009
Fifth Annual Top Expert Award 2008
Fourth Annual Top Expert Award 2007
===================================================================
Zero to Genius in 161 days = DateDiff("d", #02-15-2007#, #07-26-2007#)
===================================================================
Bachelor of Science, Electrical Engineering
California State University Long Beach
3.75 GPA  Cum Laude
Deans Honor List
===================================================================
Microsoft Access Relational Database Applications since Access 1.0
Hundreds of thousands of lines of VBA code.
Tens of thousands of lines of MAI / Basic Four Business Basic code.
Endless lines of firmware and microcode.
Fortran II and IV (what??).
===============================================================================
Contributing member of the Microsoft Access Users Group of San Diego ..
www.augsd.org/HallofFame.aspx since 1998.
Treasurer and Webmaster of www.blusd.org from 1999 to 2008.
===============================================================================
Charter Member Subscriber to Access Advisor and Smart Access publications.
===============================================================================
Guitar / Slide Guitar / Vocals / Blues / Classic Rock / 60's RnB.
Multiple Bands over many years. Currently a hired  gun (er guitar) for LA and Inland Empire blues bands.
====================================================================================
Friend to ALL animals.  If you shoot defenseless animals with high powered weapons, do not contact me!
====================================================================================

******************************
PROFESSIONAL RESUME
******************************

2006 -  Present (full-time)
Database Architect
Southern California Edison, Rancho Cucamonga CA
(A-Could-Not-Refuse Full Time Database Gig)

Complete redesign of a mission critical Quality Assurance database into a state of the art, user friendly, multi-user application working daily on the SCE wide area network, with new features and functionality
non-existent in the original version.

Currently developing multiple Access databases for various operations within the SCE Revenue Services Organization, all operational on the SCE WAN.

=======================
1985  Present (now part-time)
CEO and Chief Database Architect
AllData, Inc., Rancho Cucamonga CA
Database Consultants
www.alldatacorp.com

Multiple Microsoft Access-based products, projects and multi-user applications for clients nationwide.
Static and data driven websites utilizing both Microsoft and Adobe/Macromedia platforms and technologies.

**** AllData Inc Highlights - in no particular order *****

Bureau of Land Management, El Centro CA
Multi-user Permit Tracking System

Hancock, Rothert, & Bunshoft, LLP Attorneys, San Francisco CA.
Multi-user asbestos verdict tracking database, currently being used by Lloyds of London.

Arizona Dept of Commerce, Phoenix AZ
Multi-user Export Tracking System for the International Trade Division.

Recordata West, Burbank, CA.
Multi-user Computer Aided Ambulance Dispatch System written entirely in MAI/Basic Four Business Basic
5 year project, Touch screen operation, PSAP 911 Interface, Vehicle Tracking System

Solar Communications International, San Diego, CA
Multi-user Job Tracking System for company telecommunications projects.

Blues Lovers United of San Diego, San Diego, CA
Design and development of an ASP.Net  & Flash MX based Access database driven website:
www.blusd.org

Sunrise Imaging Inc, Tustin, CA
Multiple engineering, database and IT consulting projects.
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.

Southwest Millworks Inc, San Diego, CA
Complete design and development of a Flash MX based website:
www.southwestmillworksinc.com

Integrated Revenue Management, Carlsbad, CA.
Numerous emergency fixes, modifications and enhancements to databases
used for medical billing audit analysis.

Notary Brothers, San Diego CA
Multi-user Job Tracking System for a nationwide signing service business.

HMC Associates, Frankfort, KY
Multi-user Real Estate Appraisal Information Management System.
Data Driven Flash and HTML website with Access backend:
www.frankfortkyrealestate.com

M. Parkinson Co, Milwaukee, WI
Multi-user Job Tracking System for a jewelry repair business.

Campus Photography International, La Costa, CA
Multi-user Job Management System for controlling an international photography business.

Brushed Metal Design, Costa Mesa CA
Flash based website:
www.brushedmetaldesign.com

San Diego County Sheriff's Department, San Diego, CA
Multi-user Work Release Program Management System

Home First Physical Therapy, Inc., Corpus Christi, TX
Multi-user Therapy Tracking System

Advanced Digital Research, Tustin, CA.
Factory automation Report Generator Module

On Demand Learning, Greeley, CO
FlashMX / ASP.Net data driven online training website:
www.odlearning.com

ILISA Spanish Language School, San Jose, Costa Rica
Multi-user international student tracking database

Citgo Oil Co., Corpus Christi, TX
Automated data entry, data retrieval and reporting system to replace DOS-based data entry system.
Enhanced user interface and reporting system for oil well tracking and financial analysis.

Marcus & Millichap Commercial Real Estate Company, Irvine, CA
Automated information download and tracking system to retrieve, modify and archive data from an on-line real estate information service.

Western Medical Center, Tustin, CA
Multi-user prospect tracking, seminar scheduling and reporting system
for a hospital fund raising organization.

=======================
1977-1985
Advanced Development Engineer
MAI/Basic Four Systems, Irvine  CA
Computer Systems Mfg.

System, firmware and digital circuit design       .
Managed development of an advanced personal office workstation.
Touch screen interface system software, hardware, firmware, Business Basic utilities.
Generated Company VLSI strategy
Group leader of system, hardware, firmware and production release for the MAI 2000 computer system

=======================
1976-1977
Senior Project Engineer
Comtec, Inc., Irvine CA
Process Control Systems Mfg.

Designed process control computer and Remote Temperature Test System
Hardware & firmware design and production system.
Four microprocessor-based products. Designed Programmable Clean and Etch and
Crystal Bank Sorter systems.

=======================
1975-1976
Senior Development Engineer
Coherent, Inc., Palo Alto CA
Laser Mfg.

Design team member on laser scanner for UPC bar codes - precursor to today's
barcode scanning systems found everywhere.
Assisted POS manufacturers in defining scanner interface requirements.
Hardware and firmware design of several interface circuits for various POS terminals.

=======================
1969-1975
Senior Development Engineer
Hughes Aircraft Co., Fullerton CA
Ground Systems Group

Analog/digital hardware and systems design.
Microprocessor sub-systems for submarine display system.
Radar video distribution system; Trackball interface for a radar display system.
=======================

1967-1972
Student Programmer / Computer Operator
Cal State University Long Beach,  Long Beach, CA

As an undergraduate ... developed several programs written in Fortran IV for graduate students,
including a simulation of a phased array radar system.
=======================
EOF

More
Languages
No Languages shown

Level Progress

Current: Level 75
DatabaseMX (Joe Anderson - Former Microsoft Access MVP) needs 29,404 points to level up.
LVL 76
  • Overall
    75
  • Microsoft Access
    75
  • SQL
    18
  • Microsoft Applications
    15
  • Databases
    13
  • Microsoft Development
    13
  • Visual Basic Classic
    13
  • Microsoft Office
    13
  • Microsoft SQL Server
    7
  • VBA
    6
  • VB Script
    6
  • Microsoft Excel
    6
  • Visual Basic.NET
    6
  • Windows XP
    5
  • Programming
    4
  • .NET Programming
    4
  • ASP
    3
  • Microsoft SQL Server 2005
    3
  • Microsoft SQL Server 2008
    3
  • Windows 7
    3
  • Windows OS
    3
  • Microsoft Word
    3
  • MySQL Server
    3
  • Security
    3
  • Editors IDEs
    2
  • Microsoft SharePoint
    2
  • Web Development
    2
  • ASP.NET
    2
  • Office Productivity
    2
  • SBS
    2
  • Networking
    2
  • Windows Server 2003
    2
  • Software
    2
  • Adobe Dreamweaver
    2
  • Windows Vista
    2
  • Oracle Database
    2
  • Miscellaneous
    2
  • Outlook
    2
  • Windows Networking
    2
  • DB Reporting Tools
    1
  • Windows 8
    1
  • Microsoft Server OS
    1
  • Delphi
    1
  • Programming Languages-Other
    1
  • Windows Server 2008
    1
  • Shell Scripting
    1
  • Web Applications
    1
  • Web Development Software
    1
  • FileMaker Pro
    1
  • Microsoft 365
    1
  • Web Components
    1
  • Azure
    1
  • Printers and Scanners
    1
  • Office Suites-Other
    1
  • Microsoft Forefront ISA Server
    1
  • Active Directory
    1
  • SSRS
    1
  • Storage Software
    1
  • Operating Systems
    1
  • Email Servers
    1
  • Microsoft Server Apps
    1
  • Adobe Acrobat
    1
  • Crystal Reports
    1
  • OS Security
    1
  • System Utilities
    1
  • COBOL
    1
  • Installation
    1
  • C#
    1
  • Microsoft Legacy OS
    1
  • FoxPro
    1
  • PHP
    1
  • Displays / Monitors
    1
  • Images and Photos
    1
  • Programming Theory
    1
  • Remote Access
    1
  • Telecommunications
    1
  • Power BI
    1
  • E-Commerce
    1
  • Network Analysis
    1
  • GIS/GPS Programming
    1
  • Windows 10
    1
  • Exchange
    1
  • Server Hardware
    1
  • Sybase Database
    1
  • Web Browsers
    1
  • Wireless Networking
    1
  • Scripting Languages
    1
  • Sales
    1
  • Network Architecture
    1
  • Adobe Flash
    1
  • CSS
    1
  • File Sharing Software
    1
  • IP Telephony
    1
  • IT Administration
    1
  • JavaScript
    1
  • Lotus IBM
    1
  • Network Management
    1
  • Project Management
    1
  • Visual C++.NET
    1