Mohit Nath — Business Analyst

💼 About Me (📍Bangalore) Data Analyst with 1.5 years of experience at Raksha Pipes (Shand Group of Industries). I specialize in automating manual processes, building impactful dashboards, and enabling data-driven decisions through Power BI, Excel VBA, and Python. 🧹 Data Cleaning Process Automated cleaning of Sales, Collection, Outstanding, and Daily Calls data using Excel VBA. Reduced 4–5 hours of daily manual work into seconds via macro buttons. 📊 Power BI Dashboards (All dashboards below were created by me and are currently maintained by me) ➡️Sales vs Last Year Dashboard: Tracks current sales in real-time and dynamically compares with last year’s data. Filters by branch, product category, and executive for detailed insights. ➡️Collection & Outstanding Dashboard: Monitors incoming collections and pending outstanding amounts, helping finance and management teams stay on top of receivables. ➡️Product Performance Dashboard: Analyzes over 7,000 SKUs across states, districts, customers, and sales executives. Identifies top/bottom performers to drive inventory and sales strategies. ➡️Employee Performance Tracker: Evaluates 200+ executives and branch managers on KPIs like sales, collections, attendance, and expenses. Used by senior leaders to drive accountability. ➡️HR Performance Dashboard: Helps HR monitor salary, attendance, and target-based performance. Flags underperformers automatically for warning letters and intervention. ➡️Executive Activity Tracker: Captures daily login/logout time, visits, and working hours of field executives. Used by the support team to ensure productivity and field discipline. 🔗 Data Modeling Integrated 20+ Excel and Google Sheets using proper and virtual relationships for efficient and accurate reporting. 🔐 Row/Role Level Security Designed 20+ role-based access levels in Power BI for Branch Managers, Support Teams, and Strategy Units—ensuring each role sees only what they’re authorized to. 🤖 Automation ➡️DCR Reporting Automation: Built a Python script that captures DCR dashboard screenshots and automatically sends them to relevant WhatsApp groups—eliminating the need for manual follow-ups and enabling instant field visibility. ➡️Penalty Deduction Alerts: Developed an advanced automation system that calculates penalty amounts for 200+ executives daily based on activity logs. It sends personalized WhatsApp messages with detailed deductions—streamlining HR enforcement with zero manual effort.

Stackforce AI infers this person is a Data Analyst with a focus on automation and dashboard development in the SAAS industry.

Location: Bengaluru, Karnataka, India

Experience: 5 yrs 11 mos