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.
• 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

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.