Prem Bhati

Data Analyst | Aspiring Business Analyst | Enthusiast for AI · Mumbai Metropolitan Region

Ever since I started studying Data Science, I’ve been fascinated by how data can tell stories, solve problems, and shape smarter decisions. At KES Shroff College, I’m building a strong foundation in Python, Power BI, SQL, and analytics while applying these skills to projects like resume screening automation and workflow bots. I work at the intersection of data analytics, quantitative research, and applied AI, turning raw, messy datasets into clear insights, automation, and decision-support systems. My focus is on behavioral analysis, machine learning, and data-driven product intelligence, with hands-on experience across Web3 trading data, customer segmentation, NLP applications, and RPA workflows. I don’t just “analyze data.” I engineer features, test hypotheses, build pipelines, and deliver insights that actually change decisions. What I work with Python · Pandas · NumPy · Scikit-learn · Data Visualization · Machine Learning · NLP · Streamlit · Google Colab · CSV Pipelines · Excel ·Power BI ·SQL I had the opportunity to explore consulting through a BCG strategy simulation, where I worked on real-world business cases, and my customer support experience at Asian Paints and HDFC Life helped me strengthen my communication and problem-solving abilities. What excites me most is using data to create impact — whether by improving processes, uncovering insights, or driving decisions. I’m eager to connect with professionals and explore opportunities in business analytics, consulting, and data-driven problem solving. Outside academics, I’m a fitness enthusiast and gamer, always balancing discipline and creativity in both my personal and professional life.

Experience

M

Data Analyst Intern

myNalanda · Dec 2025 – Apr 2026

Not yet confirmed

• Built end-to-end teacher performance dashboards in Power BI and Google Looker Studio covering attendance, leaves, and KPIs for 200+ teachers across multiple school sections.
• Implemented Row-Level Security (RLS) in Power BI using DAX and USERPRINCIPALNAME() to enforce teacher-level data privacy across all report views.
• Implemented data modelling
• Migrated production deployment from Power BI to Looker Studio, eliminating $2,000+/month in licensing costs while maintaining full functionality.
• Developed 10+ DAX measures including ROI categorization, attrition loss calculation, and dynamic KPI scoring.
• Designed 4-page interactive dashboards with drill-through navigation, dynamic teacher images (Base64), and multi-level filtering.

Customer Service Specialist

HDFC Life · Apr 2025 – Aug 2025

Not yet confirmed

• Handled customer queries and service requests via email related to life insurance policies, including policy details, premiums, renewals, endorsements, claims status, and documentation.
• Provided accurate, compliant, and timely responses by understanding customer issues and aligning solutions with company policies and IRDAI guidelines.
• Resolved customer complaints through root-cause analysis, ensuring first-time resolution wherever possible and escalating complex cases appropriately.
• Maintained detailed case documentation and updated records in internal CRM and policy management systems for audit and tracking purposes.
• Coordinated with internal teams (operations, underwriting, claims, and sales support) to close customer requests within defined SLAs

B

Strategy Consultant

Boston Consulting Group (BCG) · Mar 2025 – Mar 2025

Not yet confirmed

A

Customer Specialist

Asian Paints · Apr 2023 – Jun 2023

Not yet confirmed

• Handled high-volume inbound customer calls related to product inquiries, order status, dealer information, complaints, and service requests.
• Provided accurate product guidance on paints, coatings, application processes, pricing, and availability to customers, dealers, and contractors.
• Logged and tracked customer interactions in CRM systems, ensuring complete and accurate documentation for follow-ups and audits.
• Resolved customer issues through effective problem diagnosis, offering first-call resolution wherever possible and escalating complex cases as per defined SOPs.
• Coordinated with sales, logistics, technical support, and dealer networks to ensure timely resolution of customer requests.