Derek Cate Email & Phone Number

Chicago, Illinois, United States

• Worked with developers of new PostgreSQL based data warehouse / analytics database to verify new features, test for functionality and stability, and otherwise try to break the database before customers did.
• Wrote tests in SQL, Ruby, Python, and Shell to test features as well as find and verify bugs.
• Reviewed and approved the tests of others through pull requests on a git repository.
• Worked with developers in testing the porting to a Kubernetes based cloud product in AWS, Azure, and GCP.
• Filed over 1,000 bug reports in Jira and verified their fixes.
• Created confluence pages to give other employees the knowledge they needed.

• Worked with Sentry Data Systems, doing ETL projects in Ruby to get data from Disproportionate Share Hospitals into Sentry’s Oracle database to participate in and receive the additional reimbursements available in the.
• Identified problems in customer data and worked with project managers to get the problems resolved and verified the fixes.
• Wrote SQL scripts to fix problems in prior implementations and saw these fixes through to completion in bug tracking software.

Lynchburg, Virginia, United States

• Worked with doctors’ offices to debug and resolve problems with practice management software, EMR software, MS SQL Server databases, and HL7 based interfaces. Filed dozens of bug reports and verified their fixes using.
• Helped support department diagnose customer problems and either find the source of the problem or provide the information to the 3rd party vendor to fix their application working with Java, JSP, JavaScript, and Java.
• Performed SQL Server performance tuning and optimization using SQL Profiler, SQL wait stats and other DMVs, identifying and adding indexes, rewriting queries.
• Built tools in C# and Java to diagnose and fix data problems from a 3rd party product in the MS SQL Server database before customers were impacted.
• Enhanced functionality of EMR product through use of SQL triggers, functions, stored procedures, views, and scripts.
• Made bug fixes and enhancements to core products using C#.

Lynchburg, Virginia, United States

• Worked with PublicData.com on their Professional License information using Java.
• Built Post Office change of address application for PublicData.com using Python.
• Worked on a peer to peer, encrypted backup utility using Python and Twisted.
• Developed websites for local businesses using PHP, MySQL, and JavaScript.

San Jose, California, United States

• Added new modules and features to PowerPath suite of pathology lab software, both back end and user interface, using Delphi.
• Worked with beta customers to identify, file, and fix bugs or verify fixes done by others.
• Research and development’s technical resource liaison for customer support and implementation departments to come to with questions. Resolved customer problems when others were unable.
• Mentored employees in their jobs and helped them understand how pathology labs use PowerPath products.
• Tuned database performance of the MS SQL Server database used by PowerPath products by rewriting queries, stored procedures, changing database schema, and adding indexes.
• Rewrote many modules in PowerPath products to improve application responsiveness.