Keegan Smith Email & Phone Number

Chicago, Il, Us

Plano, Texas, United States

Assisted the Auto Finance team in determining best practices for sales associates to build and maintain relationships with dealership partners. Crafted SQL statements in Snowflake across multiple tables to aggregate data and create actionable insights into dealer availability, unrealized value in queue, and cashout rate differentials across various time segments and geographies. Created a framework for optimizing and automating sales staffing schedules by comparing various factors based on actionable insights. Documented the research project and successfully presented findings to company leadership.

Greater Chicago Area

Researched and tested multiple software solutions capable of converting PDF formatted financial data into Microsoft Excel spreadsheets. Utilizing client feedback, created an application in Python that transformed AWS Textract outputs into usable excel sheets, reducing conversion times from over 5 minutes to less than 1 minute on average. Utilized agile methodologies to develop and manage project.

Chicago, Illinois, United States

Conducted financial due diligence on potential grantees using in-house methodology in Microsoft Excel by examining audited financial statements. Create dashboards to highlight the impact of the work of the Foundation. Created data models to advance the understanding and visibility of program impact.

Created a ten-year report using SQL to compile data stored in Access and exporting the data to Excel for analysis culminating in a 17-page document outlining various successes of the Commission (found below).

Des Moines, Iowa, United States

Participated in the Iowa Legislative Page Program during the 2019 Legislative Session serving under the Legislative Services Agency, which is an administrative, non-partisan agency that provides legal bill drafting, committee staffing, and fiscal analysis services. General duties included moving the confidential bill drafts to legislators, party and administrative offices within the capital, and floor of the House and Senate.