PAST CLIENTS
2017
Dara Investment Group Orange, CA
Built database for a land investment company. This database controlled --- the workflow -- for employees at 8 different workstations within the office. Employees would click buttons, which would send specific sets of tasks to the next employee. And so on. This automated system of moving specific tasks from person to person, also controlled how much data each employee could see at any given time. All data entry screens were password protected.
2006 - 2010
Architectural Dimensions Walnut Creek, CA
Architectural Dimensions Walnut Creek, CA
I met an architect who wanted to develop a database for managing all aspects of a construction project. I developed a database to keep track of contacts, clients, different types building materials, where the materials came from, prices, correspondence, schedules, and more. This was a 4 year project developing a large, complex database.
2006 - 2008
O'Grady Plumbing San Francisco, CA
O'Grady Plumbing San Francisco, CA
Built a payroll database for plumbing company in San Francisco.
On-call database consultant for 2 years, while I also supported other clients.
2006 - 2008
Arlene Blum - Berkeley, CA
Arlene Blum - Berkeley, CA
Built and maintained a small contact database for an author. This database managed a mailing list of about 7000 people. It was also used as an accounting system to keep track of book sales. On-call database consultant for 2 years, while I also supported other clients.
2006
Indigo Piping Systems Berkeley, CA
Indigo Piping Systems Berkeley, CA
IT assignment from a "temp" agency developing an Access database.
2006
Employee Benefit Specialists Pleasanton, CA
Employee Benefit Specialists Pleasanton, CA
As a "temp" I assisted a huge, data-mining corporation in Silicon Valley by producing queries and reports for a statewide agency which kept track of health insurance information for the entire State of California. Millions of records for California residents. My time was spent mostly building complex queries for reporting purposes.
2003
Debt Legal Services Anaheim, CA
2003
Debt Legal Services Anaheim, CA
Built a "calculator" type of database for a law firm managing credit card consolidation. This database imported "debt" information from outside data sources. It also calculated settlement costs and lawyer fees. This was a small but useful tool I built for their office with powerful features. It was used by about 4-5 employees within the law office.
2001 - 2006
Anaheim YMCA
2001 - 2006
Anaheim YMCA
I developed several databases for YMCA programs in Anaheim, CA. This database kept track of enrollment for after school sports programs, summer camping, and year-round volunteers. Before I was hired, the YMCA had no automated system to enroll students. All information was either collected on paper or using multiple Excel sheets. I built a centralized Access database from the ground up so everybody shared the same information. This reduced 1000 manhours and increased productivity. Because 30 employees in the office were now sharing information within the same database, I also built hundreds of automated reports.
1996 - 2001
Cal State Fullerton
I developed many different Access databases around the Cal State Fullerton campus during my 6 years as a full-time Cal State Fullerton employee. This included a large-scale database used by 40 workstations throughout the Department of Education to keep track of students enrolling in teacher education, as well as faculty recruitment information. Due to the fact so many employees shared the same data, I also built hundreds of different reports. I also built databases for the Counseling Department, and Center for Nonprofit Research. Additionally, I developed an Access instruction book, and taught Beginning / Intermediate Access courses for Cal State Fullerton employees.
