Hi, I'm Omkar — a detail-oriented Data Analyst skilled in SQL, Excel, Power BI & Python. I build interactive dashboards and analytics solutions that turn raw data into actionable business insights.
Data Analyst · Power BI Developer
I'm a final-year B.Sc. Computer Science student at KSD's Model College, Dombivli (Mumbai University), passionate about uncovering meaningful stories hidden inside raw data.
I have hands-on experience with SQL, Microsoft Excel, Power BI, and Python through real-world academic projects — performing EDA, data cleaning, and building interactive dashboards that deliver actionable business insights.
I'm actively looking for opportunities as a Data Analyst, Power BI Developer, or BI Analyst in Mumbai, Navi Mumbai, and Pune. I believe great analysis is not just about numbers — it's about telling a story that drives decisions.
My technical toolkit for data analysis, visualization, and business intelligence.
Real-world analytics projects built with industry datasets and business context.
Built an end-to-end pipeline — raw data ingested into Lakehouse, cleaned via SQL, modeled in Data Warehouse, and visualized in Power BI. Analyzed 197K orders & ₹53M sales; veg food drives ~64% revenue with Karnataka as the top state.
View on GitHub →Analyzed a food-tech startup crisis across 149K orders & 105K customers — quantified a 70.9% revenue drop (₹37.6M → ₹10.9M). Built a 5-page dashboard covering segmentation, restaurant health, and sentiment analysis.
View on GitHub →Analyzed 426K trips, 238K passengers & ₹108M revenue across 10 tier-2 cities. Identified Jaipur as top performer; Surat & Lucknow led repeat passengers (~40%). Delivered city-specific recommendations projecting 5–8% revenue growth.
View on GitHub →Performed deep EDA on customer purchase data — segmented customers by spending habits, churn indicators, and retention patterns. Delivered actionable insights through rich visualizations using Python and Seaborn.
View on GitHub →Designed a revenue intelligence dashboard for a hospitality chain — analyzed booking trends, occupancy rates, ADR, and RevPAR metrics. Surfaced city-wise and property-wise performance gaps to guide pricing strategy.
View on GitHub →Created an interactive financial performance dashboard for LT Foods — tracked revenue, profit margins, and YoY growth trends. Enabled leadership to spot underperforming segments and make data-driven financial decisions.
View on GitHub →I'm actively looking for Data Analyst, Power BI Developer, and BI Analyst opportunities in Mumbai, Navi Mumbai & Pune. The best way to reach me is via email — I typically respond within 24 hours.
kotkaromkar988@gmail.com