Bhavesh Chatnani

Experience

• 

  AVI Products

  Jul 2020 - Oct 2020

  Data Analyst Intern

  •Bolstered data quality by cleaning unstructured historical purchases data from multiple clients over the past 5 years using MS Excel, enabling product and sales managers to analyze sales trends and demand for specific products•Executed market research to identify underexplored areas in dental healthcare industry in India seeing 6% increase in sales•Collaborated with a team of 3 in collecting and analyzing consumer data to understand consumer purchasing trends

• 

  HOPE NGO

  Jun 2021 - Mar 2022

  Social Media Team Lead

  -Managed and governed all the activities related to the social media exposure for HOPE NGO.-Hosted weekly review meetings and oversaw the social media team's overall progress.-Worked as a content writer for Instagram Posts.-Organized two sports events (cricket and football) for small underprivileged children.

• 

  Verve Advisory Pvt. Ltd

  Oct 2021 - May 2022

  Data Analyst

  • Led process optimization and automation in recruiting, client management process on ClickUp, reducing tickets by 54%• Boosted sales by 9% through refined sales strategies using Tableau for client sales analysis, exceeding revenue goals• Delivered department based ad-hoc reports on Tableau to gain insights on project timelines, job satisfaction, burndown charts and workflow planning to help with decision-making and strategic planning

• 

  University of Illinois Urbana-Champaign

  Aug 2022 - Dec 2022

  Course Assistant

  Grader for course CS 598: Foundations of Data Curation (Fall 2022)

• 

  Business Intelligence Group (UIUC)

  Jan 2023 - May 2023

  Analyst Consultant

  • Conducted secondary research to draw insights from venture capital funding reports; presented statistical recommendations to client for establishing digital healthcare footprint in metaverse• Visualized data on Tableau to predict future user growth based on current trends and potential revenue streams from promising startups within emerging healthcare sector in metaverse• Developed robust risk mitigation strategies by addressing pitfalls in digital healthcare investments within metaverse, ensuring protection of client’s capital and investments Show less

• 

  Cline Center for Advanced Social Research

  Jan 2023 - Aug 2023

  Data Scientist

  • Leveraged PowerQuery and DAX for data transformation and PowerBI to develop crime analytics dashboard to identify criminal and policing patterns• Enriched data granularity by merging external datasets with Python and PostgreSQL, offering county-level policing insights• Implemented Random Forest classifier to reveal racial profiling patterns in use of lethal force, achieving F1-score of 0.79• Crafted PowerBI dashboard to visualize detailed ethnic diversity demographics and Herfindahl indices across 120+ countries Show less

• 

  CHS Inc.

  May 2023 - May 2024

  Data Engineer

  • Achieved monthly reduction in overdue invoices by developing Invoice KPI Dashboard on PowerBI to optimize vendor payment pipeline emphasizing on aging of payables• Catered to 25+ ad-hoc user stories for data models and dashboard requests on PowerBI to solve business problems• Developed reusable SQL views and schemas to compute sales and financial KPIs, saving 7 hours weekly• Used SAP Predictive Modeling techniques to forecast timelines and clearing days for accounts receivable invoices• Integrated Azure DevOps data into AWS S3 bucket to develop PowerBI dashboard to increase team productivity• Automated QTD and YTD P&L, balance sheet and revenue operations reporting pipeline on Excel with VBA Macros Show less

• 

  DigiFarmz Smart Agriculture

  Jun 2024 - Oct 2024

  Data Scientist
• 

  Quintessa Marketing

  Oct 2024 - now

  Data Science Analyst