Data Driven Insights for Smart Real Estate Decisions

Market Research · Policy & Regulatory Framework · Development Feasibility · Data Analytics

About Me

🏙️ Strategic Real Estate Professional with 1.5+ years of experience in market research, policy & regulatory framework, development feasibility, and data analytics. I help developers and investors unlock value by translating complex data into actionable insights.

📊 Analytics & Feasibility: Expert in financial modeling, scenario analysis, and policy evaluation (TOD, NILP). Worked on 30+ acres of land parcels across Gurgaon for development feasibility and investment assessment..

🚀 Mission: Bridging the gap between raw data and strategic real estate decisions — delivering dashboards, market intelligence, and robust financial frameworks.

Portfolio

🏘️ Group Housing Financial Model

Detailed DCF, IRR, NPV analysis with sensitivity dashboard.

Download Excel + Dashboard

📊 Summary: 18% IRR | 2.5x Equity Multiple

🏙️ NILP+TOD Financial Model

Transit-oriented development, FAR incentives & premium analysis.

Download Model

📊 TOD premium: +22% land value | 3.2 years payback

🧓 Senior Living Financial Model

Operational & development feasibility, annuity based revenue.

Download Excel

📊 Stabilized yield: 9.7% | Occupancy 85%

💼 Commercial Office Financial Model

Lease structuring, rental growth & exit cap rate simulation.

Download Model

📊 Prime office: 12% ROI, 7.5% rental uplift

📊 The Gurgaon Residential Market Research

Comprehensive dashboard + qualitative summary on micro-markets, price trends & absorption rates.

Download Dashboard (Excel)

🔍 Qualitative: Emerging micro-markets (Sector 62/63) show 15% annual appreciation. Inventory overhang reducing.

📘 Case Study: The Fall of Raheja Revanta

Analysis of liquidity crunch, regulatory delays and market sentiment shift. Lessons for land banking.

📉 Key takeaway: Over-leverage + pre-sales dependency = high risk. Recommended mitigation strategies.

🏚️ Case Study: Unitech: A Sinking Ship

Corporate governance lapses, delayed delivery cycles and impact on buyer trust. Policy recommendations.

⚖️ RERA impact: Lessons for escrow & transparency. Financial cascading effects.

📑 Delhi Master Plan 2041

Review of land use, redevelopment policies, and affordable housing incentives.

Policy Summary PDF

🏗️ NILP Policy Impact Assessment

Floor area ratio relaxations and infrastructure potential in NCR submarkets.

➕ FAR bonus leads to 30% higher development potential.

🏢 TOD Policy: Case of Gurgaon

Transit Oriented Development density bonuses and market adoption.

📌 Recommendations for affordable housing integration.

Technical Arsenal

📊 Advanced Excel

📈 Power BI

🗄️ SQL

🐍 Python

Let's Connect

Sumesh K.

Real Estate Intelligence & Analytics

+91 96935 22953

sumesh.dataanalyst@gmail.com

hello@sumeshrajput.in

Available for consulting

Digital Profiles

Gurgaon, India

Data-Driven Real Estate Expert

Schedule a call: Let's collaborate

Work With Me

Market research, financial modeling, feasibility studies, or strategic advisory — let's turn insights into assets.

📧 Send a Message