Back to Developers
Rooney Nanda

Rooney Nanda

Data Analyst / MIS Executive

India
80
Profile Score

About

Data Analyst / MIS Executive with hands-on experience analyzing 10,000+ records using SQL, Excel, and Power BI to generate actionable business insights and support decision-making. Specialized in MIS reporting, KPI tracking, and dashboard development in simulated business environments. Built end-to-end analytical solutions including revenue analysis, churn prediction, and performance tracking. Strong ability to translate raw data into business insights and recommendations. Available for immediate joining.

Skills & Expertise (23)

Power BI Advanced
8.7/10
4
Years Exp
SQL Advanced
8.5/10
4
Years Exp
Excel Advanced
8.3/10
5
Years Exp
Dashboarding Advanced
8.0/10
4
Years Exp
Data Modeling Advanced
7.8/10
4
Years Exp
Decision Support MIS Reporting Revenue Insights Trend Analysis KPI Tracking Business Analysis Interactive Dashboards DAX validation Data Cleaning Power Query Pivot Tables Advanced Excel Aggregations Window Functions CTEs Joins Postgresql

Work Experience

Data Analyst

Project-Based

Present - Present

Analyzed $3.5M+ retail dataset to evaluate revenue trends, product performance, and regional sales distribution. Identified top 20% product categories contributing ~65% of total revenue, enabling focused sales strategies. Built KPI dashboards to track revenue growth, category performance, and regional distribution. Detected seasonal demand trends to support inventory and demand planning decisions. Delivered actionable insights to improve inventory allocation and promotional targeting. Simulated real-world reporting environment with structured KPI tracking and business-focused insights.

Data Analyst

Project-Based

Present - Present

Analyzed 7,000+ customer records to identify churn drivers and revenue impact. Identified 52.9% churn rate among month-to-month customers, highlighting high-risk segments. Built interactive dashboards with churn metrics, revenue insights, and customer segmentation. Performed segmentation based on tenure, contract type, and revenue contribution. Provided retention-focused recommendations to improve customer lifetime value. Translated analytical findings into actionable business strategies for customer retention.

Data Analyst

Project-Based

Present - Present

Performed customer revenue analysis using joins, aggregations, and window functions. Calculated Customer Lifetime Value (CLV) to identify high-value customers. Generated monthly revenue trends using window functions for business tracking. Ranked top-performing customers and analyzed category-wise revenue contribution. Delivered structured insights supporting data-driven decision-making.

Data Analyst

Project-Based

Present - Present

Built an end-to-end MIS reporting solution using SQL, Excel, and Power BI on an e-commerce dataset (1200+ records). Designed relational tables and performed data extraction using PostgreSQL. Created a master dataset in Excel and conducted profitability and loss analysis. Developed interactive Power BI dashboards to track revenue, profit, delivery performance, and customer behavior. Identified loss-making products, high-discount impact, and delivery delays affecting customer satisfaction. Segmented customers into new vs repeat and analyzed their revenue contribution.

Education

Bachelor’s Degree (BBA)

- · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Skills (23)

Power BI SQL Excel Dashboarding Data Modeling Decision Support MIS Reporting Revenue Insights Trend Analysis KPI Tracking +13 more