Bhavesh Chatnani

Bhavesh Chatnani

Data Analyst Intern

Followers of Bhavesh Chatnani4000 followers
location of Bhavesh ChatnaniChicago, Illinois, United States

Connect with Bhavesh Chatnani to Send Message

Connect

Connect with Bhavesh Chatnani to Send Message

Connect
  • Timeline

  • About me

    MSIM'24 UIUC | Data & Business Analytics

  • Education

    • Thakur Polytechnic

      2015 - 2018
      Diploma in Computer Engineering
    • University of Illinois Urbana-Champaign

      2022 - 2024
      Master of Science - MS Information Management
    • Vivekanand Education Society's Institute Of Technology

      2018 - 2021
      Bachelor of Engineering - BE Computer Engineering
  • 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
  • Licenses & Certifications

    • Introduction to Data Analytics | IBM

      Coursera
      Aug 2021
      View certificate certificate
    • Microsoft Certified: Power BI Data Analyst Associate

      Microsoft
      May 2025
      View certificate certificate
    • Leetcode SQL50

      LeetCode
      Sept 2025
    • Data Analysis using Excel | Rice University

      Coursera
      Sept 2021
      View certificate certificate
    • Data Visualization and Communication with Tableau | Duke University

      Coursera
      Oct 2021
      View certificate certificate