Keith Mccann Email & Phone Number

Camp Hill, Pennsylvania

Responsible for working on the more complex reporting needs of the customers• Led project for migrating ~700 SAS programs to a new SAS grid server which included working with with internal SAS support team to gather requirements, documenting changes that were required, creating new custom startup files and scripts and training team members on new environment and how to update programs and scripts• Focus on productionizing programs to run on a schedule in a unix environment.• Create standard macros that will extract commonly used pieces of data• Document processes that are lacking documentation• Mentor team members• Perform QC reviews to ensure accuracy

Camp Hill, Pa

Responsible for reporting of provider data to assist in data cleaning and daily operations• Gathered reporting requirements from customers• Created reports using SAS and SQL to retrieve data from a DB2 database• Provided maintenance and support for ~700 scheduled jobs

Responsible for creating CDISC datasets (SDTM and ADaM) from raw clinical data and creating tables, listings, and figures as defined in the statistical analysis plan.•Perform primary programming to produce outputs for submission to regulatory agencies.•Perform QC programming to ensure other programmers’ outputs are accurate and consistent.•Regular usage of proc freq, proc means, proc sql, proc report, proc sort, proc transpose, proc format, ODS, SAS/Graph, and SAS/Macro to achieve results.•Concentrate on run-time efficiency by limiting disk I/O and using in-memory lookups such as arrays, hash objects, and formats.

Responsible for developing and maintaining clinical trial databases. •Create and maintain documentation for projects (Annotated CRF, design specifications, test scenarios, user guides). •Develop electronic forms for data capture. •Program edit checks for data validation using PL/SQL and VBScript. •Develop ad-hoc reports using SAS and SQL. •Create SAS programs to standardize raw data received from external vendors.

Scranton, Pennsylvania Area

Maintained and updated The Times-Tribune website and other affiliated Times-Shamrock websites. •Created photo galleries using JavaScript and CSS.•Prepared web traffic reports for 20 sites that included a list of issues found on each site.•Created banner and tile graphics for advertisers.•Maintained a digital archive of news articles for the website.•Answered inquires related to the website.

Scranton, Pennsylvania Area

Maintained and updated The Times-Tribune website and other affiliated Times-Shamrock websites. •Reviewed website and ensured all the news articles for the day were posted on the website.•Added photos to news articles.•Made corrections and updates to news articles.