Kyle Leber Email & Phone Number

Columbus, Ohio Area

Discover customer trends and attributes by retrieving and analyzing data using SAS, SQL and Python. Create ad-hoc and reoccurring reporting to be used by our client partners.Accomplishments: Developed a process to automate over 90% of my team’s reoccurring reports helping to save over 100 hours a month Trained and mentored junior analysts in programming methodologies as well as best practices. This included creating and implementing a training program for SQL that was rolled out to multiple departments throughout the company Developed a basket analysis macro in SAS that has the ability to be easily used by entry level analysts and non SAS programmers Gathered and stored data from various sources using APIs and web scraping techniques to further understand what factors affect our customers shopping behaviors Developed and implemented an incremental value study to analyze various programs offered by the company including paperless billing and online activity Created a logistic regression model to determine the likelihood of a customer using our card in the first 30 days

Columbus, Ohio Area

Provided ad-hoc and reoccurring reporting for our care centers using SAS, SQL and VBA in ExcelAccomplishments: Developed and automated a new reporting tool to rank our collections associates based on numerous factors including dollars collected, hours worked and efficiency Recommended a new retention strategy to target our most profitable card members and extend them offers to continue using our card Led a team of entry level associates who created and maintained reporting for our care centers