Nick Longo
nlongo2004@yahoo.com
(510) 847-6199 mobile
(510) 548-6193 message
Access Programming Experience
• VBA/VB coding, SQL, ODBC, ActiveX, ADO/OLE
• Ability to design friendly, intuitive user interfaces, clear, precise
reports, multi-page forms and sub forms
• Knowledge of database design considerations, including normalization,
optimization, data import, export, conversion and manual entry screens,
mainframe screen scraping, data integrity, security, and network issues
• Experience working with management and users to develop and implement
multi-user applications
• Access 97, 2000, 2002, 2003 and Access Project with SQL Server 2000
Recent Programming Projects
Contractor for Magley Associates
• The Gap, February - March 2006
Resolved data and security problems, added reports to IT project database.
Independent Contractor
• Video Illusions, September – November 2005, January 2006
Built stand-alone Access application for multi-user mail order sales
data entry and processing, deployed to multiple locations
Developed Access database for automobile dealership sales tracking,
and automated sales commission calculation
• FNF Title Services, April - May 2005, December 2005
Redesigned data model and resolved record locking errors for multi-user
Access database.
• Center for Policy Analysis on Trade and Health, December 2004
Created Access queries, mail merge and e-mail merge documents, for
non-profit fund raising campaign
• Fidelity Home Warranty, October 2004 - November 2004
Worked with IT Manager to update SQL Server database
Contractor for Edward Bell Associates
• Bridger Commercial Funding, August 2000 - March 2005
Programmed Access databases and integrated Access databases with Excel
workbooks and SQL Server
Independent Contractor
• UCSF Medical Center, December 1999 - March 1999
Developed manual entry and reporting databases, systems automation
Contractor for Romac International
• Wells Fargo Bank, June 1999 - November 1999
Developed Access databases linked to Oracle databases via ODBC with
reports generated in Excel using ActiveX automation
Contractor for RHI Consulting
• UCSF/Stanford Hospitals, February 1999 - June 1999 Developed nine
Access databases
• American Baptist Homes of the West, December 1998 - February 1999
Repaired damaged Access database
Contractor for Volt Services Group
• Office of the President of the University of California, September
1998 - December 1998 Developed ten Access databases
• Vanir Construction, August 1998 - September 1998
Developed Access database for managing school construction and renovation
project for the Berkeley Unified School District
• Everett Graphics, June 1998 - August 1998 Developed three linked Access
databases
Additional Qualifications
• Experience programming in HTML and C++
• Knowledge of graphics programs including Photoshop, Illustrator, Quark
Express, Pagemaker and Freehand
• Expert knowledge of Microsoft Office applications
Business Experience
Proprietor, Cesium Sound, Berkeley, CA 1986 - 1994
• Programmed sound libraries for music workstation synthesizers, sold in
50 states and 40 countries worldwide
• Established manufacturer and press contacts, planned and executed ad
campaigns, handled personal and phone contact with above as well as
suppliers and thousands of customers
• Maintained customer and mailing list databases
Recent Professional Activities
Research and Development of original MIDI software, 1990 to present
• U.S. Patent issued May 2000, second U.S. Patent filed March 2002
• Demo software reviewed in Keyboard and Electronic Musician magazines
• Composed, produced, packaged and promoted original electronic music CD
titled Actuality, played on more than 110 radio stations, reviewed in 15 national
and local publications, 1994 - 1995
Educational Background
Mills College and Cal State University Hayward
Graduate Study, Electronic Music
September 1985 - June 1986
California State University, Hayward
B.A., Music Composition,
September 1981 - June 1984
U.C. Berkeley
Undergraduate Studies, Electrical Engineering and Computer Science
September 1971 - June 1976
|
