Back to Developers
Rahul Patwal

Rahul Patwal

Data Analyst

80
Profile Score

About

Data Analyst skilled in SQL, Python, Power BI, and Excel with expertise in data cleaning, visualization, and predictive modeling. Experienced in customer segmentation, reporting automation, and data-driven decision making. Adept at applying machine learning techniques and analytical strategies to transform complex datasets into actionable business insights and support business growth.

Skills & Expertise (39)

Python Intermediate
7.3/10
1
Years Exp
Data Cleaning Intermediate
7.2/10
1
Years Exp
SQL Intermediate
7.1/10
1
Years Exp
Power BI Intermediate
7.0/10
1
Years Exp
Excel Intermediate
6.8/10
1
Years Exp
DAX Data Preparation for ML Data Modeling Power Query Pivot Modeling Advanced Charts Pendo Analytics ETL Concepts Database Management Jupyter Notebook MySQL WorkBench Asana Google Sheets Supervised Learning Linear Regression Decision Trees Model Evaluation Pandas Data Visualization Predictive Modeling Customer Segmentation Reporting Automation Data-driven decision making Machine Learning Analytical Strategies NumPy Interactive Dashboards Matplotlib Seaborn scikit-learn MySql Query Optimization Joins Indexing

Work Experience

Business Data Analyst

Nearz (Techwits IT Solutions)

Mar 2025 - Nov 2025

Performed customer segmentation using RFM analysis on 2,000+ users, helping improve repeat bookings and targeted marketing effectiveness. Designed and deployed interactive Power BI dashboards for 50+ salon partners to track bookings, revenue, and performance metrics, reducing reporting time significantly. Analyzed customer behavior and transaction data to introduce promo-code and discount strategies, contributing to improved user acquisition and conversion rates. Evaluated feature adoption and user engagement metrics using analytics tools, providing actionable insights to enhance product usage and retention. Built data-driven recommendation insights based on pricing, popularity, ratings, and proximity factors to optimize booking conversions and business growth. Built a recommendation model ranking salon deals by 5+ factors (discount %, flat discount, popularity, ratings, proximity), boosting visibility of high-value offers and driving higher first-time booking conversions for new users.

Data Analyst

CivilMantra ConsAi Limited

Dec 2025 - Present

Conducted in-depth market and competitive research analysis for the Ayurmuni Ayurvedic e-commerce app, benchmarking features, pricing models, and user experience strategies against leading e-commerce and quick-commerce platforms. Performed comparative analysis of PDP (Product Detail Page) and PLP (Product Listing Page) across 10+ apps to recommend UI/UX and conversion optimization improvements for Ayurmuni. Analyzed competitor product positioning, discount structures, delivery models, and customer engagement strategies to support business decision-making. Executed Exploratory Data Analysis (EDA) on company tender projects to evaluate monthly revenue, expenditure, profit margins, and financial trends. Built and managed Excel-based analytical models using Pivot Tables, VLOOKUP/XLOOKUP, data cleaning, and financial summaries to support internal reporting. Prepared structured research reports and dashboards to present actionable insights to stakeholders and support product strategy improvements.

Data Analyst Intern

Cognifyz Technologies

Dec 2024 - Jan 2025

Preprocessed 100K+ restaurant records, cutting missing values by 95% and ensuring clean datasets for analysis. Conducted EDA to identify top cuisines driving 70% of orders and key rating patterns influencing customer retention. Automated weekly data aggregation, reducing reporting effort by 3.5 hrs per cycle (30% faster). Developed visualizations of cuisine market share that improved report clarity and decision-making.

Education

Bachelor of Science - SGRR (PG) College Dehradun

- 2023 · 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 sinceFeb 2026

Skills (39)

Python Data Cleaning SQL Power BI Excel DAX Data Preparation for ML Data Modeling Power Query Pivot Modeling +29 more