Edward W. McCarroll
Post Office Box 654, Culver City, CA 90232
Home: 310.838.4330 –– Cell: 310.904.3651

Summary: Web and Database Developer, B.A. in Math/Computer Science (CSULA, 1976) experience in all phases of the software development cycle: requirements definition, design, development, integration, quality assurance, and maintenance.

Technologies: SQL Server, T-SQL, ASP.NET, VB.NET, C#, Visual Studio.NET, Visual SourceSafe

2001 - Ongoing: Database/Web Consultant, Freelance, and Contract. Assignments include:

• Designed and Developed enhancements for a web-based payroll system. (VB.Net, C#.Net, Visual Studio .NET, Visual SourceSafe) (www.web-payroll.com, aka Cyntron Payroll Solutions)
• Developed VB.NET navigation menu for 150-page web site for a major art museum. (VB.NET, Visual Studio .NET)
• Developed MS SQL Server stored procedures and an MS Access front end, to manage an insurance claims database for a managed healthcare provider. (SQL Server, T-SQL)
• Designed and implemented an user login control system for a nonprofit. (http://www.awgoman.com) 
• Modified an interactive game program and its admin control panel for a trivia gaming web site. (http://www.TrialPicks.com/) (Flash/ActionScript, PHP, MySQL, Dreamweaver)
• Did maintenance programming for product/dealer databases for two power tool manufacturers. (http://www.MKDiamond.com/, http://www.BarrancaDiamond.com/)
• Did programming and project management for a medical university, supporting the upgrade of an enterprise accounting system
• Designed, implemented a dynamic web site for an upscale Santa Monica restaurant.
• Maintained and enhanced a budgeting database for a media production company, an inventory control reports for a liquor-importing company, and a royalty/intellectual property tracking system for a law firm.

2003 - Ongoing: ASP.NET Programmer and Assistant Webmaster, Angeles Chapter, Sierra Club – Designed and implemented an online database using ASP.NET, VB.NET and Visual Studio.NET, providing a custom web-based search engine for the Sierra Club's outings database. Serve on the committee that sets design guidelines for a 200-page web site. (http://Angeles.SierraClub.org/outingsDB/index.aspx)

2001 - 2003: Database Programmer, Teachers On Reserve – Designed, implemented, and deployed a client-server database used by a placement agency for matching personnel with orders. This database identifies potential matches by comparing qualifications, availability, and geographical location. It also imports employment applications filled out on the company web site. This system involved 50 tables, 241 SQL queries, 94 data entry forms, 92 reports, and over 21,000 lines of Visual Basic code, and replicated data between three offices statewide.

1994 - 2000: School Teacher, (Full details available on request).

Designed and Implemented a database to track the school’s disciplinary detention program. This database identified which students are assigned to detention on which dates, by which teachers, and whether or not the student actually served the detention.

1991 - Ongoing: Database Programmer, John Woolman School – Designed, implemented, and deployed a client-server database used to maintain records on staff, students, parents, and donors. Served on school’s technology committee, providing technical guidance and support in the development of academic computer facilities.

1990 - 1992: Information Systems Coordinator at California Self-Help Center – Designed, implemented, and deployed a client-server database to support an information and referral agency operating out of seven sites statewide. This database was used by volunteers to find support groups for callers seeking help with concerns such as cancer, substance abuse, etc. Designed and implemented a data replication mechanism to synchronize copies of the database in each office.

Supervised data gathering and data entry processes for faculty research project. Implemented database application for analysis of research data and project management database to track sampling parameters and ensure data validity.

Supervised staff of 3 and 20 volunteers. Provided technical support for the entire organization.

1976 - 1990: Earlier History: Software engineer for Jet Propulsion Laboratory, CitiBank, Exxon, Raytheon, and Hughes Aircraft. (Full details available on request.)