Available for freelance projects
I’m Sanskar, a business analyst helping e-commerce and operations teams turn messy data into useful dashboards and automated reporting.
SQL · Python · Power BI · Google Sheets
A practical process, from source to handover.
Experience across
growth, product & operations
01 / How I can help
For teams that need to understand their performance—and spend less time putting reports together.
Bring sales, funnel or delivery data into one clear view, with consistent metrics and analysis that answers a real business question.
Turn recurring exports and spreadsheet updates into a repeatable workflow, with clear logic and checks along the way.
AI-assisted workflows. Have a repetitive summarization or reporting task? We can scope a small prototype with source checks and human review.
02 / Selected professional work
Examples from my work in growth, delivery operations and recurring reporting.
ZOMATO
Used SQL and Python to prepare large datasets, analyze conversion funnels and cohorts, and support festival planning with historical trends and forecasting.
Where do customers drop out of the order funnel, how does performance vary by city and cohort, and what can historical demand tell us about peak periods?
Cleaned and validated data, built granular funnel trackers, examined cohort-level differences, and developed campaign dashboards and festival-planning analysis.
Decision support for growth and campaign teams: performance trackers, segmented reporting and demand-planning analysis.
SUPERTAILS
Defined delivery-promise and SLA breach logic, reconciled shipment-level results, and compared courier and city performance across reporting periods.
Are deliveries meeting the promise made to customers, and are comparisons consistent across delivery types and reporting windows?
Documented metric definitions and missing-value treatment, handled different promise cutoffs, and validated shipment-level calculations against source data.
Consistent month-to-date reporting and courier/city analysis that supports investigation of delivery delays.
SUPERTAILS
Built Python workflows that pull operational data from a database, refresh Google Sheets, and append new customer-support tickets without duplicating existing records.
How can operational teams receive refreshed reporting and new ticket records without repeating the same extraction and spreadsheet steps?
Built database queries and Python transformations, added ticket-ID deduplication, and scheduled daily jobs on a virtual machine.
Recurring reporting workflows and a ticket-tracking sheet that appends newly identified records.
Professional work summaries. Employer datasets and internal dashboards are not published here.
03 / Independent projects
Personal projects exploring dashboards, prediction, recommendations and applied machine learning.
DASHBOARD CASE STUDY
A Zomato-inspired portfolio reconstruction exploring sales, customer cohorts and city performance with clearly labeled synthetic data.
Explore the case study ↗
PREDICTIVE ANALYTICS
A housing-price prediction project exploring data preparation, feature selection and regression.
View project on GitHub ↗
RECOMMENDATION SYSTEMS
An independent project exploring recommendations for fashion products.
View project on GitHub ↗
APPLIED MACHINE LEARNING
A personal modeling project focused on credit-risk analysis.
View project on GitHub ↗Define the business question, available data and what a useful result looks like.
Agree the metrics, check the source data and review the first version together.
Deliver the dashboard or workflow with documentation and a clear handover.
Have a reporting bottleneck?