Developer Data Analyst

RICHARD SPECTOR

**** ****** *****, ***** ** Sunnyvale, CA 94089

************@*******.*** Home Phone: 408-***-**** Cell Phone: 408-***-**** PROFESSIONAL EXPERIENCE:

VARIOUS CONSULTING ROLES November 2018 to present

Developer Consultant

• Independent consulting to various Silicon Valley companies for per diem work or short term contract. THERMO FISHER SCIENTIFIC, Pleasanton, CA February 2013 to November 2018 Life Technologies

Developer III

• Created components to render a GUI interface of a 96 well ATR plate that travels through various stages of biotech manufacturing.

• Wrote coldfusion components and modules to support manufacturing activities.

• Handled the daily Service Now queue in a support engineer capacity to resolve IT trouble tickets for the Array Manufacturing Support group.

• Created a web interface to process replacement assays for open array division in Pleasanton facility.

• Built PL/SQL backend database logic via an Oracle package that encapsulated all query, update, edit, delete and create of database table records.

• Produced internal documentation using Word/ PowerPoint and internal company wiki (CenterStage).

• Delivered POC in Jquery3.0 overwriting default actions and rendering get operations on live data.

• Complied with WorkDay employee requirements.

• Consumed and connected to various API via WebServices Skills Used:

• ColdFusion 11/ Oracle 8-9/ JavaScript/jQuery/, JSON, Node JS /Python/ VB.Net, SVN, ALLIANCE ANALYTICAL, Fremont, CA March 2012 to September 2014 Programmer/ Data Analyst

Overlapping with above job as part time consultant

• Ported an existing store catalog system built in cfml Flex 4.5 to an eBay store using eBay store tools.

• Designed landing pages from email blasts to targeted links in the biotechnology industry.

• Added value to database of biotechnology specific email contacts by using various APIs to include address, phone and other dimensions to the data.

• Designed open house invitational email with rsvp form pre-populated with client contact detail info and obtained response rate with over 100 attendees to the corporate event.

• Employed TSQL and SSIS to extract data from SQL server to excel reports.

• Maintained and enhanced ColdFusion backend of components that connected to SQL Server 2008 database of in-house CRM system.

• Customized Adobe Flex components in the front end as required.

• Integrated the contacts data of the database with an external SMTP provider by building a web service of the data that fed into the third-party API to render email broadcasts data.

• Produced internal technical documentation including commenting source code and Microsoft PowerPoint/ Word.

• Connected to various API via WebServices using XML and working on Coldfusion Component to the web services provider to front end Flex Program

Skills Used:

• ColdFusion/ Flex 4.5/ Microsoft SQL Server 2008, JavaScript, XML,SOAP R2INTEGRATED, Campbell, CA January 2006 to January 2012 Formerly Catapult Data Systems

Programmer/ Data Analyst

• Monitored and reported on scheduled data jobs for accuracy on a daily basis and correct in timely manner on any error in process.

• Built the file upload tool (FUT) which extracted csv files uploaded via the web, checked them for accuracy and mapped the data fields to a set of required and optional fields then uploaded the file and inserted records Into appropriate Microsoft SQL tables and sent an email confirmation of success or failure of the process Built a cloud connector application in Microsoft Visual Studio 2008 C# to a marketing automation cloud service provider.

• Wrote SQL and pl/SQL scripts along with numerous views stored in the database schema. Richard Spector Resume, Page Two

R2INTEGRATED (continued)

• Used statistical charting and graphing packages to present dashboard level views of the data with drilldown from the chart regions.

• Also assisted the PHP and data warehouse development teams as needed.

• Connected to various API using standard soap interface via WebServices Skills Used:

• Cold Fusion 8.0/ Microsoft SQL Server, TSQL, JavaScript, Oracle, ML/XSLT,SOAP WSSL ECYCLE INC., Milpitas, CA October 2003 to January 2006 Web Applications Developer

• Maintained and enhanced the web portal of a custom manufacturing ERP system in cfml/ JavaScript for client base of 8K customers distributed for AMD, Yahoo, Polycom, Apple and other clientele.

• Developed requirements documentation and test plan according to pre-defined company standards.

• Maintained clustered configuration of Cold Fusion application servers.

• Built an in-house change control management system using Microsoft DOS batch files and UNIX shell scripts to archive current files and ftp upload the changed files.

• Maintained Microsoft Active Directory server of users and computers for the corporate domain.

• Wrote stored procedure and view in Sybase and interfaced them with Cold Fusion web scripting.

• Refactored the in-house open source keystone ticket management system from PHP to cfml Skills Used:

• cfml/ Sybase, PHP, TSQL, JavaScript, Oracle, XML/XSLT EXODUS INC., Santa Clara, CA October 2000 to December 2002 Senior Programmer

• Created various in-house web applications in Cold Fusion and an Oracle 8.1 back-end. Wrote SQL and pl/SQL scripts along with numerous views stored in the database schema.

• Used statistical charting and graphing packages to present dashboard level views of the data with drilldown from the chart regions.

• Assisted the PHP and data warehouse development teams as needed.

• Created dashboard web applications with role-based login to enable customized views of the data depending on job function and position in organization.

Skills Used:

• PHP 5.0, Cfml/ Microsoft SQL Server, TSQL, JavaScript, Oracle, XML/XSLT CYLINK, Sunnyvale, CA January 2000 to October 2000 Senior Programmer

• Created various in-house web-applications using cfml and Microsoft Access.

• Refactored the content management (CMS) system of (KB) knowledge base, technical support notes, and driver updates from a flat DVD publication into a web-based CMS system.

• Wrote a documentation manual for the sites produced on successful completion of contract. EDUCATION:

UCSC Extension Continuing Education, Santa Cruz, CA 2010 to Present Certificate in Programming

• Courses in XML, Advanced Unix, Node JS Microsoft SQL Server, TSQL, Angular,,PHP, Node JS (MEAN STACK) and AMAZON Aws Programming, Oracle- transcript of courses taken available upon request) Grumman Data Systems Institute, Melville, NY

Diploma in Computer Programming

SUNY@ Binghamton University, Binghamton, NY

Bachelor’s Degree – Liberal Arts, Concentration in Technical Writing Louisiana State University, Baton Rouge, LA

Master’s Degree – Library and Information Science

CERTIFICATIONS:

Certificate 8 Step PPI August 2017

Certificate Cold Fusion MX February 2003

Contact this candidate