Kathryn Jan Email & Phone Number

-Design, build, and maintain at least 10 different Access databases of various sizes and complexity that amass patient information and record survey information for reporting to government agencies. These were critical in allowing my department to bring in more than $15 million grant dollars over the past 15 years-Gather and document data requirements for databases by talking to end users and subject matter experts, and reading grant awards; follow through to make sure all requirements are… Show more -Design, build, and maintain at least 10 different Access databases of various sizes and complexity that amass patient information and record survey information for reporting to government agencies. These were critical in allowing my department to bring in more than $15 million grant dollars over the past 15 years-Gather and document data requirements for databases by talking to end users and subject matter experts, and reading grant awards; follow through to make sure all requirements are present in database-Create SQL queries to gather data and run as automated reports-Code in VBA to export reports to Excel for data cleaning and analysis-Conduct user acceptance testing and address any bugs/issues found-Create user manuals and/or train end users on how to use their database-Part of a team converting an Access database to a web-based application using C# and SQL databases, responsible for designing and coding custom user interface that allows for tracking of services provided by staff-Perform analysis using Excel to look for changes in data trends over time-Lead and manage staff and projects on a tight timeline to completion ahead of deadlines -Coordinate and schedule with various community agencies to permit the collection of general health surveys from homeless or undocumented families, or families residing in specific zip codes (collected anywhere from 250 to 975 surveys per project) -Train staff in how to conduct field evaluations and use their project’s database for client tracking and data entry-All responsibilities of the Bilingual Evaluation Specialist I position Show less

-Participated in planning, designing, and development of research or evaluation projects-Designed, built, and maintained at least 2 different Access databases of various sizes and complexity that amassed patient information and recorded survey information for reporting to government agencies-Conducted face-to-face interviews for the purpose of data collection-Managed data collection and analysis; assured completeness and accuracy of data collected and entered data in a timely… Show more -Participated in planning, designing, and development of research or evaluation projects-Designed, built, and maintained at least 2 different Access databases of various sizes and complexity that amassed patient information and recorded survey information for reporting to government agencies-Conducted face-to-face interviews for the purpose of data collection-Managed data collection and analysis; assured completeness and accuracy of data collected and entered data in a timely manner-Responsible for client retention by tracking and maintaining contact-Developed and maintained rapport with clients; consistently sensitive to client needs-Created questionnaires for structured interviews to gather specific project related data-Responsible for a case load of approximately 100 clients, ages 4 through 19, at any given time-Translated documents and interpreted for Spanish speaking clients as needed-Coordinated studies with outside collaborators, including the city of Fort Worth, as needed-Assisted with the implementation and organization of a study regarding family experiences in our program Show less