
Experienced
- I have 14+ years of experience creating custom Microsoft Access database applications that provide labor-saving solutions to data storage, retrieval and processing needs.
- I have worked with relational databases for over 25 years, including dBase and FoxPro as well as Access.
- My on-the-job experience includes 10 years of analytical work -- making sense of data.
Previous Clients include:
- 511.org
- Blue Shield of California
- City of Oakland
- City of Palo Alto Utilities (CPAU)
- City of Pleasant Hill
- Entomological Consulting Services, LTD
- Global Merchandising / Mark Ross Intl.
- JAFCO Ventures
- LeapFrog
- Levi Strauss & Co.
- Lucent Technologies
- Quest International
- UCSF
- Wells Fargo
- Western Shower Door
Solutions may include:
- All aspects of design, development, testing, debugging, documentation, deployment and training
- GUI - user-friendly interface and tasteful form design
- Data - relational database design (RDBMS); import/export in various formats (Excel, CSV, TXT, dbf); ODBC data connectivity; SQL Server; data scrubbing and normalization; flat file to RDBMS conversion
- Queries - SQL queries of all types (Select, Update, Append, CrossTab, Union, Pass-through, subqueries, etc.); custom query design
- Reports - automated or ad hoc reports; automated export
- Programming and functions - macros and VBA coding; custom VBA functions; ADO and DAO data methods.
Previous systems include:
- Accounts Payable/Receivable
- Activity Logs
- Automated Updates for Personnel Data
- Contact Management Systems
- Census Analysis for Insurance Underwriting
- Census Scrubber (Access front-end to Excel insurance rating system)
- Employee Service Awards Administration
- Employee Incentive Awards Administration
- Grant Applications Analysis
- Inventory Control
- Lesson Content Linking and Evaluation
- Price Comparison and Analysis
- Payscale Adjustment Based on Years of Service
- Prospect Tracking
- Order Tracking
- Real Estate Foreclosed Property Monitor
- Real Estate Property Management
- Rebate Programs for Energy Saving Products
- Tracking System for Contract/Grant Proposals and Awards
- Vendor Lists
- Venture Capital Candidate Management
I offer:
- Competitive hourly rates or bids by the job
- Reduced rates for non-profit and government
- San Francisco Bay Area or telecommute
- Resume and References available
Email:
alan@alangullette.com
I am a freelance consultant. No relationship with Microsoft or any other company is intended or implied.