Experience

Bain Capital

• United States
• Financial Services
• 700 & Above Employee

• Senior Data Analyst

  • Jul 2021 - Present

  - Built and manage data platform for $2b+ AUM multi-strategy hedge fund

• Data Analyst

  • Nov 2018 - Jul 2021



Norbella

• United States
• Advertising Services
• 1 - 100 Employee

• Data Analyst

  • Apr 2017 - Nov 2018

  Designed and implemented cloud based data processing and analytics platform after self-teaching Python and SQL including: ~Writing the entire codebase ~Creating custom data connections for third party API's ~Creating web scrapers where necessary ~Creating custom ETL process to scan email inbox for delivered reports ~Automating data retrieval using the above connections and chron jobs on a cloud based server. ~Designing and building a scalable cloud… Show more Designed and implemented cloud based data processing and analytics platform after self-teaching Python and SQL including: ~Writing the entire codebase ~Creating custom data connections for third party API's ~Creating web scrapers where necessary ~Creating custom ETL process to scan email inbox for delivered reports ~Automating data retrieval using the above connections and chron jobs on a cloud based server. ~Designing and building a scalable cloud based MySQL database hosted on Google Cloud Services that is client and data-source agnostic. ~Writing custom connections to the MySQL database suited to our specific needs ~Transitioning internal teams as well as clients to Tableau for data visualizations, dashboarding, and exploration. ~Overhauling the entire reporting process through efficiency improvements (automation) and introduction of new dashboards This system has resulted in drastic time savings across the company, cost savings by building the infrastructure rather than purchasing a third-party application, and greater insights into data allowing for actionable outcomes. As a single source of truth, there are no longer data silos, allowing analysis and insights to be found across clients and media channels. Python: Pandas, numpy, beautifulsoup, requests, sqlalchemy, scikit-learn, others Show less Designed and implemented cloud based data processing and analytics platform after self-teaching Python and SQL including: ~Writing the entire codebase ~Creating custom data connections for third party API's ~Creating web scrapers where necessary ~Creating custom ETL process to scan email inbox for delivered reports ~Automating data retrieval using the above connections and chron jobs on a cloud based server. ~Designing and building a scalable cloud… Show more Designed and implemented cloud based data processing and analytics platform after self-teaching Python and SQL including: ~Writing the entire codebase ~Creating custom data connections for third party API's ~Creating web scrapers where necessary ~Creating custom ETL process to scan email inbox for delivered reports ~Automating data retrieval using the above connections and chron jobs on a cloud based server. ~Designing and building a scalable cloud based MySQL database hosted on Google Cloud Services that is client and data-source agnostic. ~Writing custom connections to the MySQL database suited to our specific needs ~Transitioning internal teams as well as clients to Tableau for data visualizations, dashboarding, and exploration. ~Overhauling the entire reporting process through efficiency improvements (automation) and introduction of new dashboards This system has resulted in drastic time savings across the company, cost savings by building the infrastructure rather than purchasing a third-party application, and greater insights into data allowing for actionable outcomes. As a single source of truth, there are no longer data silos, allowing analysis and insights to be found across clients and media channels. Python: Pandas, numpy, beautifulsoup, requests, sqlalchemy, scikit-learn, others Show less



MultiPlan

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Data Analyst

  • May 2016 - Apr 2017

  • Responsible for production and distribution of all weekly/monthly/quarterly department reporting needs, ad-hoc data analysis, preparing presentations for upper management, and other special projects • Self-taught Visual Basic, DAX, and SQL and wrote comprehensive programs to fully automate multiple report production processes, resulting in drastic time savings • Rewrote and optimized legacy SQL queries and VBA code to enhance efficiency • Designed, built, presented, and implemented a… Show more • Responsible for production and distribution of all weekly/monthly/quarterly department reporting needs, ad-hoc data analysis, preparing presentations for upper management, and other special projects • Self-taught Visual Basic, DAX, and SQL and wrote comprehensive programs to fully automate multiple report production processes, resulting in drastic time savings • Rewrote and optimized legacy SQL queries and VBA code to enhance efficiency • Designed, built, presented, and implemented a new department wide report following a Kaizen working practice improvement project to address a lack of data for analysts and managers • Created automated email notification system using SQL and VBA in order to disseminate data daily to address deficiency in internal auditing application Show less • Responsible for production and distribution of all weekly/monthly/quarterly department reporting needs, ad-hoc data analysis, preparing presentations for upper management, and other special projects • Self-taught Visual Basic, DAX, and SQL and wrote comprehensive programs to fully automate multiple report production processes, resulting in drastic time savings • Rewrote and optimized legacy SQL queries and VBA code to enhance efficiency • Designed, built, presented, and implemented a… Show more • Responsible for production and distribution of all weekly/monthly/quarterly department reporting needs, ad-hoc data analysis, preparing presentations for upper management, and other special projects • Self-taught Visual Basic, DAX, and SQL and wrote comprehensive programs to fully automate multiple report production processes, resulting in drastic time savings • Rewrote and optimized legacy SQL queries and VBA code to enhance efficiency • Designed, built, presented, and implemented a new department wide report following a Kaizen working practice improvement project to address a lack of data for analysts and managers • Created automated email notification system using SQL and VBA in order to disseminate data daily to address deficiency in internal auditing application Show less


UBS
• Switzerland
• Financial Services
• 700 & Above Employee
• Wealth Management Intern

  • Jan 2014 - May 2016

Ten-X
• United States
• Real Estate
• 200 - 300 Employee
• Business Development Intern

  • Jul 2015 - Sep 2015

Tucker Blair
• United States
• Retail Apparel and Fashion
• Brand Ambassador

  • Feb 2014 - May 2015
• Quality Assurance Analyst Intern

  • May 2013 - Aug 2013

Palmer's Garage
• United Kingdom
• Office Assistant

  • Jun 2010 - Aug 2011