Abhay Pareek

Data Analytics Candidate

Noida, Uttar Pradesh, IndiaData Analytics
14skills
1education
3credentials

About

B.Tech graduate in Electronics and Communication Engineering with hands-on experience in SQL, Python, Power BI, data cleaning, exploratory analysis, and dashboard development for business analytics problems.

Education

JSS Academy of Technical Education, Noida

B.Tech, Electronics and Communication Engineering

Graduated: Jun 2026

Skills

SQLPythonPandasNumPyData CleaningExploratory Data AnalysisStatistical AnalysisPower BIDAXPower QueryMatplotlibPostgreSQLMicrosoft ExcelOpenPyXL

Projects

Customer 360 — E-commerce Growth & Retention Intelligence

Engineered an end-to-end e-commerce data pipeline using Python, implemented RFM customer segmentation, analyzed sales and customer metrics with PostgreSQL, and designed a 7-page interactive Power BI dashboard. Identified At-Risk customers as accounting for 34% of total revenue opportunity.

RavenStack — Subscription Health & Revenue Retention Analytics

Analyzed churn and retention across approximately 500 subscription accounts using SQL and Power BI. Built KPI measures for MRR, churn rate, and customer risk score, identified industry and geography as key churn signals, and recommended shifting monthly-billing customers to annual billing.

InsightFlow Analytics — End-to-End Retail Data Pipeline

Built a Python and PostgreSQL retail analytics pipeline processing more than 15,000 orders across 15 stores and 2,000 customers. Designed a normalized database schema, cleaned data with Pandas and NumPy, automated Excel reporting, generated Matplotlib charts, and validated the workflow with 19 pytest unit tests.

BookVerse — SQL Analytics & Business Insights

Wrote 24 PostgreSQL analyses using joins, CTEs, window functions, and subqueries to identify top-performing books and genres by revenue and segment customers by spend relative to average order value.