Catherine Williams Email & Phone Number

Philadephia

Center For Clinical Epidemiology & Biostatistics/ Biostatistics Analysis Center

Provides statistical programming services using SAS/Proc SQL on biomedical research studies. Collaborates closely with Principal Investigators, Faculty/Non Faculty Biostatisticians and or Research Coordinators to provide programming support. Services provided are but are not limited to the following:* data cleaning* merging relational data and or providing queries* import/export data in format desired (xlsx, csv, spss, stata etc.)* advance macros/arrays * metric conversion* interpolate values* converting variables to proper type (numeric, date, date time, time etc.)* create derived variables* generate scale/sub scale/total scores* weighed averages* data mapping variables* summary stats/histograms/graphs/scatterplots/boxplots* generate tables/reports using proc report* create detailed code books* annotates sas program as well as create and maintains an organize project directory so that pertinent information can be located very easy.

Faculty Affairs And Professional Development (Fapd)

* Served as a FAPD administrator which included duties such as assigning and revoking user rights to FAPD’s web application and pertinent documents.* Routinely wrote SQL code to generate new and or ad hoc reports as requested by internal and external clients.* Generated / disseminated monthly reports that were reviewed by internal and external clients.* Ensured data integrity by monitoring database for errors and keeping the database clean by performing detailed review of all information on a weekly basis.* Facilitated one-on-one or group trainings on FAPD’s web based applications to minimize data entry errors.* Collaborated with department coordinators to resolve data discrepancies.* Worked with clients to better serve their data and reporting needs.* Represented the office of Faculty Affairs in a professional and courteous manner to internal/external clients.

Employer Services/Information Management Unit

* Created and maintained MS Access databases; ensured data integrity and data accuracy for reporting.* Proposed solutions to keep data accurately entered into the databases.* Proposed and implemented electronic forms created in Microsoft Word so that offsite departments had the capability to submit forms via email instead of using mail carrier.

Employer Services

* Performed routine maintenance on job seeker data to ensure data integrity.* Worked with department managers to resolve data discrepancies.* Coordinated department information necessary to produce monthly reports and or Ad Hoc reports.* Assisted manager in developing policies and procedures for all data entry and data retrieval using the Employer Services database containing thousands of entries.

Employer Services

* Accurately expedited the data entry of job-seeker data of ~100 applicants on a daily basis into internal databases as well as the CareerLink web-based application.* Monitored and tracked information entered into the Employer Services database.* Processed requests for workforce-related research information.