Dhrumil Patel

Data Analytics • Data Science • Executive Reporting & Dashboards • Data Strategy

Email: dhrumilpatel02@gmail.com

Phone: 5196977110

About Me

Results-driven data and analytics leader with a track record of delivering enterprise-wide transformation, leveraging advanced analytics, machine learning, and cloud technologies. Expertise in architecting scalable data solutions, automating reporting workflows, and driving strategic insights to enhance operational efficiencies and business growth.

Skills: SQL, Python, PowerBI, Tableau, SAS, Google Analytics, Looker.

Projects

Analyzing Video Assistant Referee (VAR) decisions in the English Premier League.

Built an AI-powered analytics model to assess referee decisions in the English Premier League, improving fairness evaluation metrics.

Predicting the attributes a footballer needs in order to excel in a position..

Developed a machine learning model to identify key player attributes for various football positions, enhancing scouting and talent acquisition.

Predicting diamond prices using basic diamond measurement metrics.

Created a predictive pricing model for diamonds using regression analysis, improving pricing transparency for buyers and sellers.

Experience

BMO

Manager, Data and Analytics, Strategic Initiatives

December 2022 - Present

• Strategic lead in defining transformative enterprise-wide data strategy initiatives, defining and implementing machine learning and cloud solutions enhancing decision-making.
• Delivered $16MM in cost savings by optimizing data-driven workflows, automating reporting, and streamlining cloud infrastructure.
• Led the migration of 2.2+ petabytes of Bank of the West data to BMO AWS S3, through AWS Redshift, improving scalability and analytics performance across key business units.

BMO

Senior Data Analyst

March 2022 - December 2022

• Designed and deployed 15+ Power BI dashboards for frontline scorecards, enabling real-time performance tracking and optimization of employee incentive structures.
• Partnered with Senior Leadership to refine and recalibrate evaluation frameworks, leveraging data-driven insights to enhance workforce productivitu.
• Streamlined data engineering pipeline reducing 50% manual efforts to fetch data sources required to build insights for executive level dashboard reporting.

BMO

Data Analyst

August 2021 - February 2022

• Developed and implemented a customer 360 churn and attrition model, integrating 50+ data sources to provide predictive insights for retention strategies.
• Established data governance frameworks, enhancing SQL database integrity and Power BI reporting accuracy.
• Delivered executive-level recommendations that directly contributed to reducing customer churn and increasing lifetime value.

Cornershop by Uber

Catalog Analyst

November 2020 - August 2021

• Engineered a data-driven catalog optimization framework, improving shopper product find rates by 5% and stabilizing price markups to drive a 2% revenue increase.
• Led the transition from Tableau to Looker, enhancing self-serve analytics capabilities.
• Analyzed customer demographic and choice trends to help increase customer universe and share of wallet.

Learners.ai

Data Scientist

May 2020 - November 2020

• Developed end to end Data Acquisition pipeline fetching RSS Newsfeeds, evaluating stock market sentiments.
• Built database schematics connecting Twitter API for channel analysis providing a holistic social media view.
• Automated reports fetching insights from Sentiment Analysis Web App feeding to marketing efforts.

NRI Startup India

Data Analyst

May 2018 - June 2019

• Implemented a data-driven investment strategy, analyzing stock trends and optimizing portfolio allocation.
• Developed executive-level reporting to track key financial metrics, improving investment decision-making.
• Delivered insights resulted in 20% ROI boost through targeted optimizations on recommended ventures.

Rang Technologies

Data Analyst

October 2016 – February 2018

• Analyzed recruitment statistics to track, identify the inefficiencies, and spot the problem areas.
• Built dashboards depicting the recommendation engine results for resumes of recruited data scientists.
• Delivered an increased candidate placement rate of 60%, doubling the YOY numbers.

Education

Durham College

Data Analytics for Business Decision Making (Graduate Certificate)

September 2019 - April 2020

Majors:

Statistical Predictive Modeling For Analytics • Data Analytics Tools & Techniques • Business Analysis • Data Visualizations • Ethical Leadership And Critical Decision Making

Gujarat University

Master of Commerce

June 2013 - April 2016

Majors:

Financial Management • Financial Economics • Marketing Management • Financial Markets • Investment Management • Operations Research • Risk Management

Gujarat University

Bachelor of Commerce

June 2010 - March 2013

Majors:

Advanced Statistics • Business Economics • Corporate Financial Accounting • Business Law • Taxation • Business Organization & Management