Bank of America
Blue Shield of California
Del Paso School Dist
UC San Francisco
BaseBuilders - Praesto
San Joaquin OES
CA Dept of-
Food & Agriculture
CA Dept of-
Forestry and Fire
CA Dept of Justice
CA Dept of-
County Dept of-
Here are some of the people we have worked for
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.
(1) Legal Tracking and case management software. (2) Regulatory compliance management, documentation system, government access to most corporate database systems. (3) The Vendor Management System is a user-friendly database that tracks vendors, vendor contracts and staff evaluations. Vendor profiles can be entered directly or imported from Survey Monkey. Multiple contracts can be tracked for each vendor, and individual contracts can be linked together via a PO number. Staff members can enter vendor evaluations through the web using Instant Web Publishing.
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.
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.
Constructed a project management system including Accounts, Contacts, Studies, Tests and intricate timeline reporting. Integrated with the web using PHP. Integrated with Microsoft Sharepoint using SQL fed with ESS. Accomplished document storage and automated sending and receiving of email, using plugins from 360Works. http://www.pacificbiolabs.com
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.
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
Custom database for tracking and billing membership, and insurance for Engineering companies statewide. www.celsoc.org
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.
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.
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.
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.
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.
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.
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. www.sybase.com
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.
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.
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.
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. www.basebuilders.com
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. 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. www.unionsanitary.com