658 Palmer Ln.

Menlo Park, CA 94025

Email: chris_e_ohare@yahoo.com

Cell: 408-605-9913

Versatile programmer with five years experience in an IT environment. An organized, quick learner known for producing high quality results in a wide variety of situations. Strengths in identifying and solving problems, troubleshooting, database manipulation and process automation. Expert in Perl, SQL, Visual Basic and Access.

Application Developer – Agilent Technologies, Inc. 1999-2002

Contributed to a variety of projects both independently and on teams, using skills in Visual Basic, SQL and Perl. Worked under time pressure while creating high quality solutions. Assisted coworkers with SQL and Visual Basic scripts.

• Enhanced and supported Access and Visual Basic portions of the Product Lifecycle Management tool (PLM), used by 50 analysts to plan and manage part inventory across 8 sites for millions of parts and products. Contributed heavily to user interface, identifying and solving issues, and enforcing program consistency.
• Helped transition PLM from single-site to multiple-site reporting on MS SQL Server, helping Agilent to save millions of dollars by reducing part inventory globally. Debugged hundreds of routines, forms and queries.
• Supported import/export of data to Excel. Enhanced utilities for ease-of-use and robustness.
• Managed split, migration and cleanup of Agilent’s grant tracking system from HP. Debugged, commented, and migrated over 50,000 lines of Visual Basic and SQL Server stored procedures and queries. Enabled Agilent to meet deadlines for grants programs and tax reporting accurately.
• Installed, configured SQL Server for grant tracking system. Managed three databases, and daily connections to Agilent’s finance, shipping and employee systems.
• Supported Perl/CGI scripts and HTML reporting for university grant submissions.
• Used Cygwin and created Perl scripts to analyze and document SQL Server database structures, improving support accuracy and lowering costs.
• Helped design and develop custom defect tracking system in Access for 15 users.
• Developed statistical reports and automation for GroupSystems surveys software in Perl to manage thousands of employee evaluations confidentially.

Application Support Technician – HP 1998-1999

Hired as an employee to continue development of Remedy help desk application. Supported and enhanced other site applications in Access, MS SQL Server, Excel, PERL, and Clarify. Developed new reporting tools in PERL, Excel and Essbase.

• Designed and created robust Excel / Visual Basic spreadsheets to assist financial data entry and uploading to legacy systems. Added validation, auto-correction and robust import/export features, reducing process time by 75%. Created 8 custom versions for other finance processes.
• Created reports application in Excel for Global Support Services division for presentation-ready reports and analysis of 100 million dollar figures. Pulled data from Essbase database; supported complex custom user queries.
• Designed and created a case tracking system for application support in two weeks in Remedy.
• Automated weekly employee database import into Remedy system, using Perl to convert data.
• Designed and created 50 login scripts and install packages for 1600 users. Exceeded user, help desk and auditor requirements through consistency, auto configuration, robustness and security. Reduced related calls to the help desk by 80% and saved 40 hours per week.
• Maintained 4 Access applications for 500 users. Added user logging via Perl to install packages.

PC Support Technician – HP 1996-1998

Hired as a contractor to support site of 1800 people. Regularly assigned to difficult customers and obscure problems. Installed, upgraded and supported Windows 3.11, Windows 95, Windows NT 3.51/4.0 clients. Diagnosed hardware, software, and network problems. Developed diagnostic tools and internal business applications in Visual Basic, PERL, MS Excel and Lotus 123.

• Designed, built and released a help desk system in Remedy for 50 users in six weeks saving our department $40,000 per month for three years. Migrated 10,000 historical support tickets into the new system, merging duplicate customers. Automated call referral, notification and completion, saving the help desk 20 hours per week. Designed security features and logging.
• Designed and automated monthly delivery of 150 customer satisfaction surveys for the help desk.
• Designed and created a diagnostic tool in Perl for support technicians to alert or correct a dozen common issues, improving the quality of our service and reducing potential calls to the help desk.
• Built a script in Reflections to gather and report account details for 500 users from a remote application over telnet. Automated monthly email notification to users for billing charges and expiration warnings, improving quality of service and reducing time spent by 10 hours per month.
• Built many custom scripts saving IT countless hours in repetitive tasks including user account management, for a subnet transfer of 100 people, and to restore long filenames after upgrades.

Assistant Manager - Los Altos PC 1993-1996

Provided systems and network consulting. Handled product research, diagnostics, testing, and support of PC systems and solutions. Installed and supported business software and networks. Worked under intense time pressure, while providing creative solutions to uncommon problems. Frequent customers included Xerox PARC, Stanford University, Posh Bagel and NetManage.

Enrolled in Bioinformatics Curriculum, UCSC extension, to begin in 2003.

Completed Introduction to TCL/TK training in 2001.

Completed Using Databases with Perl/CGI training in 2000.

Foothill College, Mathematics Major