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.