Large Business Clients Blue Shield of California Dolby Laboratories FileMaker Inc. Alpha Graphics EDS Bank of America Chevron-Texaco Cisco Systems Peoplesoft Apple Computer Palm Computing Handspring Sybase Corp. George P. Johnson Entex Information Systems Sutter Health Government San Joaquin OES "CalPERS" CA Dept of Transportation "CALTRANS" Union Sanitary District CA Dept of Food & Agriculture CA Dept of Forestry and Fire CA Dept of Teacher Credentialing CA Dept of Justice County Counsel Association of CA County Dept of Education Education Stanford University, School of Education University of California, Davis George Mason University Roseville School Dist, CA Del Paso School Dist, CA UCSF - University of California

Associations Local 342 Consulting Engineers and Land Surveyors of California (CELSOC) California Urban Water Conservation Council Central California Appellate Program Small Business Clients NextG Networks AEI Consulting Aentec Engineering Areia Resource Development Inc. BaseBuilders - Praesto Guide Publishing Conference Planners Corsair Memory Beauty Network Cortect River City Jewelry and Loan Silvery Distributing/Fred Pill & Company Promote! Olsen Communications Front Site Fire Arms Training Institute BenchMark HR (many more)

Details on above projects are listed below:

.	Blue Shield California, San Francisco, CA Blue Shield had an existing solution in a previous version of FileMaker. RCC created a new solution incorporating existing functionality and adding new features to create a central point of access for critical information. Production jobs include timelines for projects with step by step management and time charging. Adding SuperContainer greatly enhanced document management. The result was an intuitive and flexible FileMaker system that improved efficiency and effectiveness across all lines of business, allowing for reduced costs and quicker deployment.
.	Dolby Laboratories, San Francisco, CA Enhanced existing production job tracking system with customer feedback system. Customer accessible web survey forms enabled direct feedback on Project satisfaction. RCC created additional reporting functionality that permitted Dolby to rate customer satisfaction, enabling them to focus on specific areas of improvement.
.	Sunoptics Prismatic Skylights - Sacramento, CA A medium sized corporation which used Business Commander to create estimates, sales orders and invoices for customers. Packing lists are managed as well as contacts and accounts.
.	ITVS (Independent Television Service)- San Francisco, CA ITVS is a small business that provides funding for independent filmmakers as well as helps locate stations to broadcast their documentaries. ITVS acts as a bridge between producers and public television. A highly complex system is used to handle all production and distribution-related information, contracts with producers and stations, tracking and distributing of production funds, all outreach activities and all information needed to maintain client relations or related organizations.
.	San Joaquin County Office of Emergency Services - San Joaquin County, CA The San Joaquin County Office of Emergency Services (OES) utilizes FileMaker Pro and Custom Web Publishing to enable businesses to submit data on hazardous materials as required by state and federal laws.
.	Stanford University, School of Education - Stanford, CA 2007 Online Admission application management system for automation of review process for University Applications, completely web based in fx.php. Allows for multiple step review process, automatic notifications of staff to review and more.

.

California Dept of Food & Agriculture - Sacramento, CA (1) Worked under contract to develop system to manage assets and their associated costs, locations, disposal. (2) Utilized FileMaker Pro 9’s External SQL Source capability to directly connect to a Microsoft SQL database system. This allowed the FileMaker Pro database to directly get cost information from CDFA’s corporate budget database system. (3) Development of a system for tracking receipts and collection.

.

Chevron-Texaco - Richmond, CA Spearheaded the redesign of the database system to review and report on Chevron's Turnover process, which pulls data from a legacy Honeywell system on an hourly basis. FileMaker data is used by Area Business Units (ABU) to report refinery plant status. FileMaker executed SQL queries to the legacy source; the ODBC process now eliminates the need to use an intermediary SQL database, thereby streamlining the automation process. Reports were then immediately available to senior management at the refinery.

.

Bank of America & EDS - Livermore, CA Developed complex inventory management system, including receiving and shipping of commodity items, serialized items, and build of material items.  BOMs are constructed in the computer then pick list and assembly list are sent to the warehouse floor for execution.  Integration of bar codes and complex reporting requirements.  Mission critical applications, runs 24/7/365 on a Dell 2650 Server.

.

Corsair Memory - Fremont, CA Worked to migrate large ERP system, with over 100 tables. Complex and proprietary Corsair processes needed to be reworked in order to support FileMaker 8 technology. Performed 600% improvement. Dedicated slave system generates reports automatically at night without user interaction.

.

FileMaker Inc - Santa Clara, CA (1) Worked under contract for six months to convert older FileMaker systems to the new FileMaker 8 format.  Work includes SMART, FileMaker's core sales lead management system for its entire sale force. (2) Developed sample files for the new FileMaker 8 product under contract with FileMaker Inc. Included numerous beta testing, troubleshooting, and development procedures for a brand new product that at the time was not available to the public.  All CD Copies of FileMaker 8 contain of database work.

.

Sutter Health, CAL Pacific Medical Center - San Francisco, CA Developed and Supports Pediatric admission and discharge database system.  System considered mission critical to hospital patient care. HIPAA requirements assessed and addressed.  Pediatric system, access by hospital and also pediatric clinic.  Usage: approximately 30 doctors and specialist.

.	BaseBuilders - Praesto - Reno, NV Developed commercial application for sale.  Database system is a project management system for engineering and surveying companies. RCC provided engineering, installation services, and contract technical support. http://www.basebuilders.com

.

Local Union 342, Pipe Fitting, Welding, Refrigeration (1) Developed comprehensive web site driven by both static web pages and by FileMaker Pro, application systems where student may submit applications and potential employers may review applications. (2) Developed comprehensive database management systems that allows the union to manage work referrals to potential employers.  A second system manages the entire education system at the school, including classes, students, class schedules, and grades.  http://www.ua342.org

.

California Urban Water Conservation Council - Sacramento, CA Developed comprehensive web site design driven by FileMaker Pro, includes new information, council minutes, and complete e-commerce system to sell publications promoting water conservation.  Utilizes PayProtect™ e-commerce system, automatic email, automatic faxing, and more. http://www.cuwcc.com

.	Union City Sanitary District - Fremont, CA Developed numerous FileMaker and Lasso based projects.  Projects range among many areas such as calendaring system of school outreach, urban water runoff, and inspections reporting.  http://www.unionsanitary.com

.

Golden Retrieve Rescue - E-Bark Auction Site (Similar to EBay) Developed and supported E-Bay type proxy bidding action site.  Support unlimited bidders and items.  Project was based in Lasso and FileMaker 5.x, and used automatic emails to let bidder know when they had won an item, or had been outbid on a particular item by another party.

.	California Dept. of Teacher Credentialing - Sacramento, CA Developed and supported government web site for tracking and coordinating teacher surveys and feed back on state run programs designed to aid and assist the teacher.  Lasso based project.  Automatic email generation.

.

Palm Computing - 3COM Corporation - Santa Clara, CA (1) Developed and supported corporate database for processing PalmPilot developer applications through the web, automatic and manual list serve functionality for all developers in the database system.  Automatic cataloging of developers and their solutions on the web, allowing the end user to search database for a specific product or specific company.  System allows developers to review their applications and update information with interaction with 3com staff. (2) Deployed advanced technical support system revolving around the aggressive use of both in bound and out bound email communications.  Automatic "actions" and "issues" processing, with automatic cross reference to Palm Developer database to determine eligibility. (3) Deployment of Palm VII Beta seeding database with bug reporting made through web interface.  http://www.palm.com

.

Conference Planners - San Mateo, CA Developed and supported corporate database for retrieving web registrations of people attending worldwide conferences and seminars.  Live web reporting for customers including Oracle Corporation, PeopleSoft, Cisco, Microfocus, Autodesk, and Sun Microsystems.  Processed information through Secure/Encrypted Web transactions (SSL) for Netscape and Microsoft web browsers.  Processed credit card authorization peaking at more than $600,000 per day.  http://www.cplan.com

.

California Dept. of Transportation, CALTRANS, Sacramento, CA Developed Project management and Tracking in FileMaker Pro 6, Lasso web development and conversion to FileMaker Pro 7.0. System manages development projects, time allocation and development of Caltrans work projects. Upgraded existing FileMaker 2.0 database system to FileMaker 3.0. Redesigned system to take advantage of FMP 3.0's relational, as well as, other new features. Implemented centralized database system that tracks claims processing and service contracts. Automated data input procedures and reporting features previously done manually.

.

Daniel Lungren, California Attorney General, Dept of Justice (1) Designed and developed the Registered Sexual Molester Database System and Directory.  Comprised on Hybrid CD-Rom with searchable database, complete with over 1000 photographs. (2) Web page featuring database back-end for storing and retrieving Most Wanted Criminals Info, Unsolved Crimes Info, and Missing Children Info.

.

California Dept of Forestry and Fire Protection Database and multimedia combination to create "Smokey and Me" curriculum CD-ROM.  "Smokey and Me" won awards from the Governor's office and the Government Technical Conference, 1995.  Developed both Macintosh and Windows multimedia titles, based on Macromedia Director and QuickTime.

.	Sybase Corporation Custom seminar scheduling and tracking, fulfillment tracking, source code tracking on a world wide server.  Integration on "run-time" FileMaker Pro Engine for FileMaker Pro server access world wide.  http://www.sybase.com

.	Apple Computer Inc. (Sacramento Sales Team) Custom sales database development, consulting, and multimedia production for sales force.  http://www.apple.com

.	Apple Computers Inc. (Volume Licensing) Deployed volume licensing database for use.  http://www.apple.com

.	California Dept of Justice, Hawkins Data Center Database and multimedia combination to create Touch Screen Kiosk and Internal Conference Presentations Kiosk won award from Governor's Office at the Government Technical Conference, 1995.

.	FileMaker Inc. (formerly Claris Corporation) Database development for volume licensing system, reseller tools, price listing systems, developer relations program management.  http://www.filemaker.com

.	Consulting Engineers and Land Surveyors of California (CELSOC) Custom database for tracking and billing membership, and insurance for Engineering companies statewide.  http://www.celsoc.com

.	Entex Information Systems "INFOSource" Custom database for customer quote generation and order construction for California state agencies.

.

Areia Resource Development Inc. Provided mission critical FileMaker Pro 7 development services. Worked to create a retail product “shrinkwrap” database system. Includes innovative 3-D drafting directly from FileMaker Pro. This system was a recognized by FileMaker in 2004 as one of the top solutions at the annual developer conference.

.	High Tech Task Force, Law Enforcement Agencies of N. California Custom development of high tech crime fighting database to track and analyze criminal operational patterns.

.	Silverado Distributing Custom database for manufacturer representative company, featuring extensive quote creation, customer tracking, competitive product analysis, invoice tracking, and inventory tracking.  Integration of CPUS, printers, and networks.

.

UCSF - University of California San Francisco FileMaker 7 and FileMaker 8 support for emergency room databases. Performed conversion and migration services and consulted on HIPAA compliance issues. Bookstore website PHP with FileMaker programming services integration of PHP with Authorize.net to protect against hacker attacks.