Built with datascienceportfol.io

Mohit Nath

Data Analyst

Based in Rajasthan,India

About

Data Analyst in Bangalore with 1.5 years experience at Raksha Pipes specializing in Power BI, Excel VBA, and Python automation. I transformed 4-5 hours of daily manual work into seconds using VBA macros and built six critical dashboards covering Sales tracking, Collections monitoring, Product Performance analysis of 7000+ SKUs, and Employee Performance evaluation for 200+ executives. My expertise includes data modeling with 20+ integrated sources, role-based security implementation, and Python automation scripts for reporting and alert systems that eliminated manual follow-ups across departments.

Skills

Projects

Experience

2022 - 2023

Data Analyst/Scientist Trainee

At AlmaBetter, I served as a Data Analyst Trainee, engaging in diverse projects: 1.) Hotel Booking Analysis (EDA): Explored booking data, identified trends, and presented insights. 2.) Appliance Energy Prediction (Regression): Used regression to predict energy consumption, refining models iteratively. 3.) Health Insurance Cross Sell (Classification): Predicted cross-selling opportunities, optimizing model accuracy. 4.) Netflix Movies (Unsupervised ML): Employed unsupervised learning to cluster content for improved recommendations. 5.) Tableau - Netflix Project: Created interactive dashboards for visualizing and communicating Netflix insights. 6.) Power BI - Earthquakes: Analyzed magnitude 6+ earthquakes using Power BI, showcasing trends geographically. and more..

2024/06 - Present

Data Analyst

Data Analyst at Raksha Pipes specializing in VBA automation, Power BI dashboards, and Python scripting. I transform ERP data into actionable insights through interactive dashboards tracking sales, collections, outstanding amounts, and employee performance. Key achievements include automating 4-5 hours daily manual work using VBA macros, building dashboards for 7000+ SKUs and 200+ executives, implementing row-level security, and creating Python automation for screenshot capture and WhatsApp reporting used by branch managers for data-driven decisions.

2018-2022

Independent Music Producer & Studio Owner

Commencing songwriting in 2018 fueled my passion for creating full tracks.I started learning music production in FL Studio and video editing in Adobe Premiere Pro.I actively generated income on my own during this time by offering clients services for music creation, recording, mixing, mastering, and video editing.In 2021, I launched a monetized YouTube channel to showcase my work, accumulating 73,000 views.

Education

2014 - 2018

B.tech in Civil Engineering

I successfully earned my B.Tech in Civil Engineering with a stellar academic record, maintaining a consistent 70% aggregate throughout the four-year program. Notably, I navigated the curriculum without any backlogs, showcasing my commitment to academic excellence.

2022 - 2023

Data Science at AlmaBetter

At AlmaBetter, I acquired valuable skills such as Excel, which allows me to work with data efficiently. I learned Python to handle and visualise complex data. I learned SQL to work with Databases. I also gained knowledge in statistics, which helps me make smart decisions based on data. Additionally, I learned Tableau,powerBi and looker studio to create interactive dashboards.