Bhargav Bhalodi

Experience

• 

  The College of Wooster

  May 2017 - Jul 2017

  AMRE Data Analytics Consultant

  - Worked with AMRE team members for a consulting project for The Goodyear Tire and Rubber Company- Collected and analyzed 10,000+ data points on geographical factors across the USA using Python- Manipulated the data points to generate a useful predictor variable and assessed its effect on the tire tread wear rate- Analyzed the data to build and present a model explaining the effect of geographical features on the tire tread wear rate- Helped develop a Python script to automate generation of some geographical features Show less

• 

  Meed Partners

  Aug 2018 - May 2019

  Programming Intern

  - Worked as a Programming Intern for Meed Partners on a company project in the Sales Performance Management (SPM) Information Technology space. The program comprised of 3 other interns (for the first out of the two semesters) and 3 senior technologists. Work done for the internship involved, but was not limited to the following:- Used Python to help work on the backend logic that connected databases to the desired functionality. This was mainly done during the first semester/first half of the internship.- Used Python, Django, PostgreSQL, HTML, CSS and Bootstrap to help develop a basic infrastructure for a website for the product. The work done provides a base and a starting point for adding further functionality and styling to the website.- Connected a PostgreSQL database to the Django framework. Added functionality to add to the database from a web page. Added logic to query the database to extract and display useful information on a web page. Show less

• 

  AML RightSource

  Sept 2019 - Apr 2022

  - Transaction monitoring of assigned accounts to assess potential suspicious activity on the account, such as money laundering- Identify data anomalies as they relate to AML initiatives, AML/BSA regulations, and industry best practices for AML/BSA analysis- Assist other members of the Compliance Unit, data management efforts, and other company employees to maintain and implement the most effective means of meeting the company's AML and other transaction analysis and reporting requirements- Work effectively with multiple complex data sources and technical analytical tools/resources- Work and contribute in a team-oriented and collaborative environment to improve the analytical and reporting processes- Adhere to and comply with all applicable, federal and state laws, regulations and guidance, including those related to Anti-Money Laundering (i.e. Bank Secrecy Act, USA PATRIOT Act, etc.), as well as adhering to company policies and procedures and client requirements Show less

  • Associate Analyst II

    Mar 2021 - Apr 2022

  • Associate Analyst I

    Sept 2019 - Mar 2021
• 

  Calamos Investments

  Jun 2023 - Aug 2023

  Intern - Business Intelligence

  - Collaborated in an agile scrum environment using Jira with the BI team, Data Science team and other stakeholders- Developed from scratch ETF Flows and Intranet Usage Analytics dashboards to track financial and platform usage KPIs- Loaded and pre-processed large datasets, and created measures and calculated columns using PowerBI M and DAX- Transformed enterprise SQL queries for 100+ existing PowerBI reports to utilize Azure Databricks cloud database- Created SQL views on Azure Databricks to retrieve information for Executive Briefings and Sales Compensation Reports- Detected variable mapping anomalies between industry data and company data using Python and SQL Show less

• 

  XLab at Weatherhead School Of Management

  Aug 2023 - Dec 2023

  Data Science Specialist

  - Worked with a team for KeyBank to conduct deep user research on the financial and banking habits of Gen Z- Built and deployed an extensive Qualtrics survey for primary quantitative research- Preprocessed and cleaned survey data, generated features, and conducted exploratory data analysis- Developed an unsupervised clustering ML model for customer segmentation and created insightful visualizations- Developed meaningful Gen Z personas based on observed traits and insights derived from clustering- Formulated innovative solutions for KeyBank tailored to observed behaviors, similarities, and differences among the developed personas Show less

• 

  Penske Truck Leasing

  Feb 2024 - now

  Data Analyst