Back to Developers
Sumeet Rajput

Sumeet Rajput

Data Analyst

Shillong, India 4+ yrs exp 90 · Outstanding

About

Data Analyst who collects, cleans and analyses data from multiple sources, and turns business questions into structured analysis, interactive dashboards and KPI reporting that drive decisions. Strong in SQL (CTEs, window functions, multi-table joins over 244,827 records), Power BI and advanced Excel, with a track record of data validation – catching and resolving discrepancies before they reach a report. Automates repetitive reporting and communicates findings clearly to technical and non-technical stakeholders, working independently in remote settings.

Skills & Expertise (29)

Power BI Intermediate
7.5/10
2
Years Exp
Data Cleaning Intermediate
7.0/10
2
Years Exp
Exploratory data analysis Intermediate
7.0/10
2
Years Exp
Advanced Excel Intermediate
7.0/10
2
Years Exp
Data Analysis Intermediate
7.0/10
2
Years Exp
SQL Intermediate
6.5/10
2
Years Exp
Forecasting Intermediate
6.5/10
2
Years Exp
Pandas Intermediate
6.0/10
2
Years Exp
Python Intermediate
6.0/10
2
Years Exp
Anomaly Identification Performance Analysis DVC Trend Identification Integrity Auditing scikit-learn NumPy Consistency Checks Data Validation Data Transformation Data Manipulation Data Extraction Plotly Streamlit Cohort Models Charts LOOKUP functions Pivot Tables Window Functions CTEs

Work Experience

Founder

Shillora

Mar 2023 - Present

Translated a business question into structured data analysis – which acquisition channels actually produce orders – and found paid advertising at 60% of orders against 10% for influencer partnerships and 30% word of mouth. The resulting recommendation reallocated budget and grew revenue ~200% against the opening quarter. Built and maintain KPI reporting on conversion rate, average order value, return rate and campaign ROI, through interactive Power BI dashboards and Excel Pivot Tables and cohort models. Investigate data discrepancies across multiple sources – website orders, WhatsApp enquiries and records from 15 supplier vendors – coordinating with the people involved to resolve mismatches before data reaches a report. Identified trends and anomalies in post-purchase failures, root-caused them and held the return rate under 10% of orders; automated day-to-day operations so the business runs with minimal owner input. Present insights and recommendations to non-technical stakeholders, turning analysis into budget and channel decisions for a six-person team.

Data Science and Analytics Intern

NextHikes IT Solutions

Aug 2025 - Sep 2026

Collected, cleaned and transformed 1M+ records across 1,115 stores from multiple source files, resolving missing values, inconsistent encodings and cross-source mismatches. Performed exploratory data analysis and supported forecasting, identifying trends in demand, seasonality and promotional effects through a model reaching R2 = 0.88 and 14.78% RMSPE. Automated repetitive reporting and data preparation, delivering results through a Streamlit interface for non-technical reviewers with refresh automated via MLflow, DVC and GitHub Actions. Collaborated with the technical team on shared data requirements; built a reusable preprocessing and evaluation template adopted by 3 team members, cutting evaluation cycle time by 30%.

Sales Executive Intern

The Times of India / Malayala Manorama

Jul 2022 - Aug 2022

Maintained records for 300+ subscription accounts in Salesforce, keeping pipeline and follow-up data accurate for downstream reporting.

Sales Executive Intern

The Times of India / Malayala Manorama

Jul 2021 - Aug 2021

Maintained records for 300+ subscription accounts in Salesforce, keeping pipeline and follow-up data accurate for downstream reporting.

Education

MBA, Marketing and Human Resources - EIILM Kolkata (Vidyasagar University)

2020 - 2022 · Afghanistan

BA, Sociology - St. Edmund's College, Shillong (NEHU)

2016 - 2019 · Afghanistan

Postgraduate Program in Data Science and AI - Digicrome Academy

- 2026 · Afghanistan

Certifications

No certifications added yet

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 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Open to Relocation