Stephen Chow Email & Phone Number

Bloomington, Illinois, United States

•Developed and maintained Chestnut’s SQL Server EMR database to support the functionality of TIER- the clinician facing interface for Chestnut’s database.•Improved and optimized stored procedures, functions, and agent jobs.•Carried out ETL processes to load client data from Excel spreadsheets into TIER; manually facilitated process by running stored procedures and troubleshooting as necessary.•Led projects to create developments in TIER requested by clinical directors.•Developed forms and SSRS reports in TIER.•Analyzed data to investigate issues within TIER and the database.•Wrote SQL queries and analyzed results to identify unexpected behavior within the system, or unintended clinical usage of the system.•Accessibly communicated data from database through Excel documents.•Collaborated with directors to devise solutions, such as improvements to TIER forms and education of staff on usage standards.

Colorado, United States

• Aided in the research and design efforts of Spectrum Reach's UX team• Specifically, helped with the refinement of the design of Ad Portal- a digital tool that helps clients to cheaply and efficiently launch advertisement campaigns on Spectrum's cable network• Wrote and refined a user interview protocol• Helped to refine a user test protocol• Analyzed user data• Executed a data visualization• Collaborated on the creation of a wireframe • Created a high-fidelity prototype

Bloomington, Illinois

Answered Crisis Line and 211 calls.• Helped people who were experiencing crises, by providing guidance and emotional support.• Helped people who were in need of social assistance, by referring them to resources in their community.

Masters Of Science - Msi, Information Science, 3.89/4.00

Masters Of Arts, Psychology, 3.25/4.00

Bachelors Of Science, Psychology, 3.91/4.00