Data enthusiast with 6+ years of experience in developing data solutions supporting analysis, reporting and predictive modeling. Proven ability to design and maintain a data warehouse that enables scalable analysis. Master’s degree in Data Science and developed 5+ predictive models through to production. Passionate about efficiencies in database & query design and exploring new techniques/products.
Quinn Fargen
Data Warehouse Analyst
About Me
Work Experience
Data Warehouse Analyst - The Bancorp (2024 - Present)
Developed ELT processes to load multiple external processors into a data lake and unified data model on Snowflake. Documented and maintained Erwin data model to keep uniform table structure and data governance. Worked with end users and business intelligence team to develop aggregate tables for efficient reporting usage.
Data Modeling Manager - Vervent Card (2018 - 2024)
Managed a 30TB SQL Server data warehouse for the rapidly expanding data science division, which more than tripled in size during tenure. Migrated analytic processes, reporting and models onto a dedicated server to reduce resource impact on production, without gaps in operational availability. Acted as primary subject matter expert for data used by the data science division.
Latest Projects
Fake Paper Company Python SQL AirFlow MetaBase
TheMichaelScottPaperCompany.orgUsed Apache AirFlow to add fake sales with Faker python package to an Azure database daily. Processed daily sales into respective tables with a stored procedure. Developed Metabase dashboard reporting by self-hosted with a Docker container for Metabase.
Car Data Scraping & Analysis Python SQL ETL
Scraped car sales data on multiple makes, models, & years. Collected and cleaned the data into a database in an automated fasion. Analyzed data and hope to host summaries on my website soon.
NCAA March Madness Modeling Rstudio Regression
This project was to create the best possible March Madness bracket score. Multiple different decision tree regression methods such as Random Forest, Boosting, & Bagging were used. This is the data, code, paper, and poster for my senior capstone.
Auto App Submit Testing Python Selenium
A selenium app to submit in an automated fashion applications. This is the proof of concept version I brought to my job to start automating website & underwriting testing. I have extended it to multiple credit card websites to learn other application techniques and generalize the project.