Building automated analytics solutions: RFM • Market Basket • Pareto Analysis • more 📍 Hyderabad | Open to Work

📍 Hyderabad, India 📧 nitinv0041@gmail.com 🔗 LinkedIn 💼 Portfolio

• naukri.com

Microsoft SQL Server · T-SQL · Power BI

• Built a 5-table normalized relational database for end-to-end data pipeline processing
• Designed T-SQL views for RFM Customer Segmentation using NTILE window functions
• Engineered Market Basket Analysis via strict self-joins to identify cross-selling opportunities
• Automated Pareto (80/20) Analysis to track cumulative revenue and top-performing inventory

Power BI · DAX · SQL

• YTD/PYTD Time Intelligence DAX comparisons
• Top 5/Bottom 5 RANKX product ranking measures
• Geographic map visuals across North America
• KPI sparkline cards: $11.53M sales | $1.34M profit | 11.58% margin

Power BI · Star Schema · DAX

• Star schema model: Car, Dealer, Customer, Date tables
• YTD/MTD/YOY DAX: $371.2M total sales | 23.59% YOY growth
• Drillthrough reports, cascading filters, dealer region map
• %GT company-wise trend matrix across 20+ brands

MySQL · AWS S3 · AWS RDS · Power BI (Coming Soon)

• Built cloud pipeline storing 7,043 customer records on AWS S3 and AWS RDS
• Detected hidden data quality issues using HEX() and REPLACE() SQL functions
• Identified 273 high-risk customers representing $264,058 yearly revenue at risk
• Churn drivers: Month-to-month contracts (42.71%) · Fiber optic (41.89%) · New customers (47.44%)

Freelance Power BI Developer (Apr 2021 – Present) Building end-to-end BI solutions for clients across e-commerce, automotive and ride-sharing domains.

Lead Manager – MP & CG | Swiggy (Feb 2019 – Jan 2021) Managed vendor operations across 30+ cities with Power BI KPI dashboards for senior leadership reporting.

• 🏆 Business Intelligence Analyst Course — Udemy
• 🏆 Introduction to NLP in Python — DataCamp

• SSRS Advanced Reporting
• Row-Level Security (RLS) in Power BI
• Azure Data Services