Eric Choate
Data Analyst - Eliza Corporation
Merrimack, NH
********@*******.*** - 603-***-****
Thirteen years of electro-mechanical manufacturing and technical support.
Fifteen years of experience in clinical data research and support.
• Use of Microsoft SQL Server and Oracle to manage and analyze data.
• SQL scripting.
• DTS and SSIS package development.
• Exposure to Visual Basic, HTML and SAS.
WORK EXPERIENCE
Application Support Specialist
Alexander Technology Group, - Bedford, NH - May 2013 to October 2013
• Update Crystal Reports.
• Convert Crystal Reports to Report Builder.
• Install and maintain Academic Enterprise Resource Planning software.
Data Analyst
Eliza Corporation - Beverly, MA - December 2006 to May 2013
• Design, develop, test and produce reports and alert files by extracting data from various sources using
Access, SQL, SSIS, and DTS packages and perform business analysis.
• Utilize Microsoft Access and SQL to create and run queries to manipulate, clean and scrub data.
• Create packages, functions, and triggers to process data and track data updates.
• Build ad hoc queries and analyze data using SQL, Access and Excel for management and marketing.
• Create SQL Server Agent jobs to monitor data condition.
• Work with engineering and management to report and resolve technical and logistical problems.
• Help create and implement improved data handling platform on SQL Server.
• Develop process monitors to alert team members of potential issues.
Research Associate/Data Specialist
SYNARC - Maynard, MA - 1995 to 2006
• Control user access to Oracle database, and assignment of privileges.
• Debug P/L SQL programs.
• Modify loading process to reduce user error and increase speed in MS Access.
• Write monitoring scripts in SQL and PL/SQL to ensure data integrity.
• Develop Oracle forms using Developer 2000 tools.
• Load data into Oracle database using proprietary software, manual entry, SAS, SQL*Loader, and SQL.
• Train new employees in electronic data entry.
• Created data conversion program which transferred data between different media.
Electro-mechanical Test/Repair Technician
HOLOGIC, Inc - Waltham, MA - 1990 to 1995
• Build Quantitative Digital Radiographic bone densitometers.
• Test and repair to PCB level and mechanical assembly levels of bone densitometers.
• Prepared units for domestic and international shipping entailing printer and optical drive installations as well
as voltage conversions.
• Helped train new technicians and made myself readily available for any questions they may have.
• Conducted field service assistance at night over phone.
Electro-mechanical Test and Assembly Technician (Hewlett Packard)
Sullivan and Cogliano Technical Temporaries, Inc - Waltham, MA - 1989 to 1990
• Conducted environmental tests on medical monitors and supplied resulting data to engineers.
• Troubleshot problems to the board level.
Assembly Technician (Hewlett Packard)
• Assembled PC boards.
• Prepared shipping lists.
• Aided with spreadsheet work for planning.
Part-time Engineering Support Technician
General Scanning, Inc - Watertown, MA - 1988 to 1989
• Assisted engineers by building mechanical test fixtures using mill and lathe.
• Aided in product reliability testing.
• Repaired units damaged from testing.
Class A Recorder Test/Repair Technician
General Scanning, Inc - Watertown, MA - 1986 to 1988
• Production testing of strip chart recorders.
• Trouble-shooting strip chart recorders to component level.
• Independently wrote a handbook concerning all aspects of strip chart recorder test procedure and use of
test fixtures.
• Aided in the training of new technicians.
High Voltage Test/Repair Technician
Keltron Corporation - Waltham, MA - 1983 to 1986
• Responsible for testing and component level trouble-shooting of high voltage power supplies.
• Repair and re-calibration of in-house test equipment.
• Trained new technicians.
Electro-mechanical Assembler
Keltron Corporation - Waltham, MA - 1983 to 1983
• Perform touch-up work and repairs as instructed by technicians.
• Final assembly.
Printed Circuit Board Fabrication
Ocean Research Equipment, Inc - Falmouth, MA - 1981 to 1982
Printed Circuit Board Fabrication
• Produced single and double sided printed circuit boards from untreated laminate board.
• Nickel and gold electroplating.
• 1:1 positive/negative film processing.
• Machine work as needed.
Radar Simulator Maintenance Assistant
Massachusetts Maritime Academy - Buzzards Bay, MA - 1981 to 1981
• Assisted in maintaining an electronic/mechanical navigational training computer and the individual
subordinate radar units.
• Aided scientists in a pollution study of New Bedford Harbor entailing trawling and piloting a 42ft craft.
EDUCATION
B.S. in Information Technology
University of Massachusetts - Boston, MA
Sylvania Technical School - Waltham, MA