 M.S. Applied Statistics, Loyola University, Chicago, IL (2014)
 B.A. Mathematics and Economics, Northeastern Illinois University, Chicago, IL (2009)

Senior SAS Programmer – College of American Pathologists
[OCT2016 – PRESENT] Northfield, IL
 Migrated S-Plus legacy codebase to R to increase functionality and processing speed
 Created an automated reporting product in R worth 2M in revenue
 Designed a QC algorithm in SAS to detect data anomalies before they reach final output
 Automated generation of MS Excel output files using SAS to eliminate manual formatting

Senior Consultant – CVS Health
[JAN2015 – OCT2016] Northbrook, IL
 Built web scraping algorithm in SAS to collect data from an online database
 Used cron to schedule batch SAS ETL processes on Unix
 Integrated Teradata, SAS, and Tableau to create a dynamic real-time dashboard
 Applied Perl Regular Expression functions in Teradata for advanced pattern recognition and fuzzy matching
 Automated generation of MS Excel output using SAS and DDE interaction
 Outsourced data processing from SAS to Teradata using PROC SQL Pass-Through
 Designed a SAS ETL process from and to Win/Unix directories, SharePoint/FTP sites

Senior Business Analyst – Zoro
[JUL2014 – DEC2014] Buffalo Grove, IL
 Developed an automated ETL process integrating MySQL, Google Analytics, R, Excel

Senior Consultant – Allstate
[SEPT2012 – JUL2014] Northbrook, IL
 Outsourced data processing from SAS to Oracle using PROC SQL Pass-Through
 Built a scheduling algorithm for processing of batch SAS jobs on Unix
 Streamlined processing via interaction between SAS and Unix instead of manual web user interface
 Automated high quality PDF dashboard reports for monitoring Drivewise program metrics
 Applied Perl Regular Expression functions in Oracle for advanced pattern recognition and fuzzy matching

SAS Data Analyst – Valence Health
[JUL2011 – AUG2012] Chicago, IL
 Collaborated with Medical Staff to build internal healthcare guidelines
 Developed and maintained data staging and validation routines supporting clinical metrics reporting
 Automated ETL processes to support hospital reporting needs
 Performed ad-hoc analyses for both internal and external clients

Business Analyst – Emdeon
[NOV2009 – JUN2011] Lincolnshire, IL
 Automated SAS reporting processes utilizing advanced SAS Macro Language branching and looping techniques to streamline and parameterize business rules logic
 Eliminated error prone manual formatting of Excel output files via SAS/DDE interaction
 Used SAS Fuzzy matching functionality to merge patient data from different sources

• PC/UNIX SAS
• R/RStudio
• S-Plus
• SQL
• Teradata
• Oracle
• MS SQL Server
• MySQL
• Tableau
• PDF
• MS Excel
• MS PowerPoint
• Google Analytics
• HDFS
• Sqoop
• Flume
• Impala
• Spark