• Rewrote ETL processes to be run in AWS, comprising 12 input flat files, 14 AWS Redshift queries, and additional data manipulation logic, by analyzing existing SAS code and designing the most efficient possible code in Python• Supported model performance tracking efforts on a quarterly basis by updating and executing a self-authored data transformation process in R• Identified necessary code changes for accelerating the production preprocessing run schedule, for 9 ETL processes, by analyzing Python, SAS, and Java code• Contributed to development of the client team's AWS infrastructure, comprising API gateway, step functions, and Lambdas, by updating the controller and ETL process parent class, updating and enhancing configuration files, and writing a Lambda function

• Created ETL process for retrieving yearly loan limits data by authoring a Python module for pulling data from an API, transforming it to a CSV, and automatically uploading it to a database• Supported forecast model update by designing and implementing all SAS and Python preprocessing code changes

• Fixed error handling for an automated process by analyzing its behavior and modifying Python code to make emailed error reports more responsive and robust• Communicated progress on database migration project to director and VP-level stakeholders by compiling information into PowerPoint slides and delivering presentations• Contributed to the implementation of a forecast model by writing SAS code, participating in design sessions, and conducting code reviews

• Played integral role in validation and regulatory reporting efforts by standardizing a series of interrelated SAS scripts and contributing to Tableau dashboard design• Contributed to software development efforts by writing new and updating existing SAS processes• Contributed to Agile team planning efforts by analyzing SAS code, reaching out to stakeholders, and reading documentation• Created a proof-of-concept for displaying forecasts by designing several Tableau dashboards• Validated data in a deliverable for a regulatory agency by maintaining, updating, and enhancing R code processes• Extracted, transformed, loaded, and validated data from websites by maintaining, updating, and enhancing R and SQL processes

• Predicted customer revenue generation and subscription renewal for a proprietary product by developing linear and logistic regression models in R and creating a report displaying statistical results• Provided KPIs on various customer metrics by creating pivot tables in Excel

• Reported on daily sales KPIs and customer behavior by designing and implementing Tableau dashboards, collaborating with the technical team to retrieve more meaningful data, creating PowerPoint slides on findings, and presenting insights to the company's CEO

• Created a large dataset for a professor's research by merging datasets, performing data management, and running statistical analyses of variables in Stata for reporting purposes

• Assisted student-athletes with microeconomics and econometrics classes by leading tutoring sessions