Sign in

R, SAS, SQL, Alteryx, Megaputer, Tableau

Oak Park, Illinois, 60302, United States
January 20, 2017

Contact this candidate


(708) ***-****


University of Illinois at Urbana-Champaign December 2015 Bachelor of Arts in Economics & Statistics

• Dean’s List, Fall 2012

University of Glasgow, Glasgow, Scotland Fall 2013 WORK EXPERIENCE

CNA Financial Chicago, IL

Actuarial Statistical Reporting Analyst (Business Analyst) January 2016 - Present

• Automated manual reports (i.e., reports that involved copying and pasting data from one excel sheet to another to run macros) with the use of either SQL, R or Alteryx

• Customized the automation of reports when requested by business partners

• Transformed dense, number heavy pivot tables and datasets into meaningful, insightful, story-telling visuals through the use of Tableau

• Collaborated with IT and Finance on a monthly process that was responsible for renewing 15k+ policies

(roughly 30 million in premium)

State Farm Champaign, IL

Strategic Resources Intern Summer & Fall 2015

• Studied common theories behind text mining, such as taxonomy analysis, keyword analysis, linked terms analysis and clustering analysis and applied them to claim records

• Operated Megaputer, a text mining GUI computer program, to clean up and organize 80 million records of free form text

• Applied taxonomic analysis, with the focus of reducing false positive and false negative occurrences, to 80 million records of free form text

• Analyzed relevant data using Megaputer and presented findings at the end of semester project showcase University of Illinois at Urbana-Champaign Housing Champaign, IL Resident Advisor 2014-2015 Academic Year

• Managed an university residence hall floor of 60 ethnically diverse undergraduate students

• Led floor meetings and conducted frequent room drop-ins to discuss events, developments, and concerns to ensure that students were kept up-to-date on all pertinent information

• Promoted academic excellence, addressed student needs, and encouraged involvement among residents in a way that supported the mission of the university and the department of housing

• Collaborated with 7 other resident advisors, 1 multicultural advocate and 1 resident director to plan meaningful and insightful community programs

Park District Oak Park, IL

Site Supervisor Summer 2013, Summer 2014

• Supervised and assisted five employees while managing a summer sports camp of 40+ kids aged 9-13

• Trained staff to assess risks and respond to emergencies

• Communicated daily with parents about their camper(s)

• Oversaw behavioral issues and dealt with them accordingly

• Worked with mentally challenged campers to increase their participation in sport activities and ensure their positive interactions with other kids


• Programming: R, SQL, SAS, Alteryx, Tableau, Megaputer PolyAnalyst, Microsoft Office Suite PERMANENT ADDRESS:

126 S Scoville Ave.

Oak Park, IL 60302

Contact this candidate