Open to Data Analyst roles ↗
SQL / Python / Power BI
Portrait of Prathiba Muddulur, Data Analyst, wearing a light blue formal shirt and black trousers
Data Analyst & Insight Builder

PrathibaMuddulur.

I turn raw CRM and sales data into clear dashboards,
and make business decisions a little easier with data.

Scroll to explore↓
Currently into

Power BI dashboards

SQL and Python

CRM lead analytics

2Years Experience
2BI Tools - Power BI, Tableau
2Certifications
1Specialisation - CRM and Sales Analytics
Sample Dashboard

Charts and queries, the way I work

A design sample of the kind of weekly view I build. Sample charts only, no company data.

Weekly Leads by Stage

Design sample chart

Conversion Trend

Design sample chart

query.sql - sample querySample
My Own Projects on GitHub
About Me

Data you can trust. Dashboards people actually use.

My Story

Detail-oriented and results-driven Data Analyst with experience in analyzing complex datasets, building interactive Power BI and Tableau dashboards, and optimizing CRM lead workflows.

Proficient in SQL, Python, and Excel for data transformation, statistical analysis, and business intelligence reporting to support data-driven decision making.

Based in BTM 1st Stage, Bangalore. Data Analyst at HomzNspace, working on CRM and sales analytics.

What I Do Best

  • Clean and transform raw CRM and transactional data with SQL and Python
  • Build interactive dashboards for weekly business reviews
  • Map the full lead lifecycle and find where conversions drop off
  • Turn sales operations questions into clear, visual answers
Technical Skills

Code, dashboards and domain depth

Grouped exactly the way hiring managers scan a data analyst portfolio.

Languages and Tools

Pivot TablesVLOOKUP / XLOOKUPMacrosData Cleaning

Data Visualization

DashboardsKPI ReportingWeekly Reviews

Domain Knowledge

Lead TrackingData ValidationETL Concepts
Projects - Case Studies

Real work, told like a recruiter wants to read it

Every case study follows the same format: Business Question, Data and Tools, Method, Insight.

Case Study 01

CRM Lead Funnel Analysis

HomzNspace

Where do prospects drop off between the first ad click and final closure?

Data and Tools

CRM and transactional data, SQL, Python

Method

Cleaned and aggregated raw lead data, mapped the full lead lifecycle from Meta Ads and Google Ads campaigns to conversion and closure, tracked every stage.

Insight

Found the bottlenecks in the sales conversion pipeline and reduced reporting drop offs, giving the sales operations team a clear view of lead assignment and follow up gaps.

Case Study 02

Sales Performance Dashboards

HomzNspace

How are sales managers and lead assignment actually performing week to week?

Data and Tools

Power BI, Tableau, sales operations data

Method

Designed interactive dashboards for sales manager performance and lead assignment efficiency, prepared data with SQL and Python for accurate weekly business reviews.

Insight

Leadership got one trusted weekly view for business reviews instead of scattered reports.

Case Study 03

Exploratory Data Analysis

Smartbridge Internship

What patterns are hidden in structured business datasets?

Data and Tools

Python (Pandas, NumPy, Matplotlib), SQL

Method

Performed EDA, data cleaning and validation, learned ETL process concepts and database management, assisted in automated dashboard layouts and reports for business performance tracking.

Insight

Built the foundation for reliable, repeatable reporting.

Projects

Professional Data Analytics Projects

Detailed project work from her Data Analyst role at Homz N Space, Bangalore.

Project 01 - Homz N Space

Sales Performance & Revenue Analytics

Developed a sales performance and revenue analytics solution to monitor business performance, evaluate sales productivity and analyse revenue trends across multiple real-estate regions. The project focuses on transforming sales data into meaningful business insights to support management decisions.

Business Objectives
  • Monitor overall sales performance and revenue generation.
  • Evaluate employee-wise and regional sales performance.
  • Track bookings, cancellations and net booking figures.
  • Identify trends in lead generation, site visits and booking conversions.
  • Provide management with a consolidated view of business performance.
Key Responsibilities & Activities
  • Collected, organised and maintained sales datasets containing employee details, project information, lead counts, site visits, bookings and revenue figures.
  • Cleaned and validated datasets by identifying missing values, inconsistent formats and duplicate records.
  • Analysed gross bookings, cancellations, net bookings and net revenue to understand actual business performance.
  • Compared sales performance across different regions, including East, North, South and Hyderabad.
  • Evaluated employee productivity by analysing individual leads, visits, bookings and revenue contributions.
  • Created KPI summaries to monitor business performance and identify areas requiring improvement.
  • Developed SQL queries to retrieve, filter, aggregate and analyse sales data.
  • Used Power BI to build interactive dashboards with KPI cards, regional comparisons, employee performance and monthly sales trends.
  • Used Excel for data preparation, validation, reporting and reconciliation.
Key Performance Indicators
Total LeadsTotal Site VisitsTotal BookingsGross BookingsCancellationsNet BookingsGross RevenueNet RevenueLead-to-Visit Conversion RateVisit-to-Booking Conversion RateEmployee-wise Revenue Contribution
Tools & Technologies

Microsoft Excel for data cleaning, validation, analysis and reporting. SQL for data extraction, joins, aggregations and business analysis. Power BI for data modeling, DAX measures and interactive dashboards.

Business Value

Provides management with a consolidated view of sales performance, helps identify high-performing regions and employees, highlights conversion trends and supports data-driven business decisions.

Project 02 - Homz N Space

Lead Management & Conversion Analytics

Developed a lead management and conversion analytics solution to monitor customer enquiries, lead allocation, sales follow-ups, site visits and booking conversions. The objective is to understand how effectively leads move through the sales pipeline and identify opportunities to improve conversion performance.

Business Objectives
  • Monitor incoming customer enquiries and lead distribution.
  • Analyse lead allocation across sales teams and regions.
  • Track the movement of leads through different sales stages.
  • Measure enquiry-to-visit and visit-to-booking conversion rates.
  • Identify duplicate records and improve data accuracy.
  • Evaluate sales team performance and lead conversion efficiency.
Key Responsibilities & Activities
  • Maintained structured lead datasets containing customer enquiries, contact details, assigned employees, project information and lead statuses.
  • Organised lead allocation data across different sales teams and geographical zones.
  • Performed data cleaning and validation to identify duplicate contacts, missing information and inconsistent entries.
  • Analysed lead movement from initial enquiry to site visit and final booking.
  • Calculated lead-to-visit and visit-to-booking conversion percentages.
  • Compared lead handling and conversion performance across sales employees and regions.
  • Identified trends in lead distribution, follow-up progress and conversion outcomes.
  • Developed SQL queries to retrieve lead records, join related datasets, identify duplicates and calculate conversion metrics.
  • Created Power BI dashboards to visualise lead distribution, conversion funnels, regional performance and employee-wise results.
  • Used Excel and Google Sheets to maintain tracking reports and validate business data.
Key Performance Indicators
Total Leads ReceivedLeads AllocatedPending LeadsSite Visits CompletedBookings GeneratedLead-to-Visit Conversion RateVisit-to-Booking Conversion RateOverall Lead Conversion RateEmployee-wise Lead PerformanceRegion-wise Conversion PerformanceDuplicate Lead Records
Tools & Technologies

Microsoft Excel for data organisation, cleaning and validation. SQL for data querying, joins, duplicate identification and conversion analysis. Power BI for data visualization, KPI reporting and conversion dashboards.

Business Value

Helps management understand lead distribution and sales pipeline efficiency, identify conversion gaps, improve data quality and evaluate sales team performance.

Project 03 - Homz N Space

Real Estate Website Content & Data Management

Supported website content management and property information updates for the company's real-estate website, ensuring that project details, pricing, unit availability and SEO information remained accurate and consistent.

Key Responsibilities & Activities
  • Managed and updated real-estate project posts and website content using WordPress.
  • Updated project descriptions, property details, pricing information and unit availability.
  • Reviewed and maintained consistency of property information across website pages.
  • Worked on SEO titles, meta descriptions and schema-related settings.
  • Supported website content improvements and updates to enhance website information quality.
  • Coordinated project information updates with internal teams.
Tools & Technologies

WordPress, Microsoft Excel and SEO content management tools.

Business Value

Improved the accuracy, consistency and presentation of property information on the company website and supported ongoing website content and SEO improvements.

Data Analysis Workflow

What my data analysis does

Her analysis workflow, step by step, taken from her resume.

Track the Lead FlowEnd-to-end CRM lead flows, from ad campaigns (Meta Ads, Google Ads) to conversion and closure
Clean and Transform DataSQL queries and Python scripts on raw transactional and CRM data
Explore the DataExploratory data analysis with Python (Pandas, NumPy, Matplotlib) and SQL, with data validation
Build the DashboardsPower BI and Tableau dashboards for sales manager performance and lead assignment efficiency
Map the LifecycleLead lifecycle mapping that finds reporting drop-offs and bottlenecks in sales conversion pipelines
Report for DecisionsAccurate weekly business reviews that support data-driven decision making
Experience

Work history

Data Analyst - HomzNspace

Bangalore, India | 2024 - 2026
  • Designed and implemented data visualization dashboards using Power BI and Tableau to evaluate sales manager performance and lead assignment efficiency.
  • Executed SQL queries and Python scripts to clean, transform, and aggregate raw transactional and CRM data for accurate weekly business reviews.
  • Collaborated with sales operations teams to refine lead lifecycle mapping, reducing reporting drop-offs and identifying bottlenecks in sales conversion pipelines.

Data Analytics Intern - Smartbridge

6 Months
  • Used Python (Pandas, NumPy, Matplotlib) and SQL to perform exploratory data analysis (EDA) on structured datasets.
  • Assisted in designing automated dashboard layouts and reports for business performance tracking.
  • Gained hands-on experience in database management, data validation, and ETL process concepts.
Education and Certifications

Qualifications

Education

Master of Computer Applications (MCA)
Rayalaseema Institute of Management and Science
2024 - 2026

Bachelor of Science (B.Sc.) in Computer Science
Sree Vidyanikethan Degree College
2021 - 2024

Certifications

  • Data Analytics Certification - Besant Technologies
  • Data Analytics Program - Smartinternz

For Employers

I can join your team for CRM analytics, sales dashboards, SQL reporting and Power BI or Tableau dashboard builds, with clean data and clear weekly reporting from day one.

Let us talk about your data

Looking for a Data Analyst role in Bangalore. Best way to reach me is email or LinkedIn. I reply fast.

prathibamuddulur02@gmail.com | BTM 1st Stage, Bangalore