Neeraj Kumar

Product-focused Data Analyst with 2+ years of experience in SQL, Python, ClickHouse, MongoDB, AWS, and BI tools like Superset and Redash. Skilled in product analytics, dashboard development, reporting automation, and conversational analytics systems. Experienced in building real-time analytics solutions, optimizing SQL performance, and delivering data-driven insights for business growth.

Work Experience

Product Analyst

November 2025 – Present

Coffer Internet Services Private Limited (Powerplay)

Built real-time dashboards in Superset and Redash tracking engagement, retention, and revenue KPIs
Optimized SQL queries on 1M+ records, reducing execution time by ~40%
Designed scalable data models and materialized views to improve reporting performance
Developed an AI-powered "Chat with Data" platform using ClickHouse and AWS for conversational analytics
Automated reporting workflows using SQL and Python, saving 20+ hours/month
Integrated MongoDB and SQL systems to enable centralized analytics and reporting

Data Analyst

September 2022 – May 2023

Girnar Insurance Brokers Private Limited

Developed business dashboards tracking acquisition, conversion, retention, and revenue KPIs
Identified funnel drop-offs and user behavior patterns, contributing to 8% improvement in conversion rates
Analyzed large-scale datasets using SQL and Excel to support business growth initiatives
Automated reporting workflows using Python, saving 15+ hours per month
Generated actionable insights and reports for cross-functional stakeholders

MIS Analyst

January 2020 – June 2021

Globiva Services Private Limited

Built automated MIS reporting systems to improve operational efficiency and reporting accuracy
Reduced report turnaround time by more than 8 hours per week through workflow optimization
Performed data validation and reconciliation checks to improve data integrity
Created Excel-based reports and dashboards for business operations and management reporting

Projects

AI-Powered Chat with Data Analytics Platform

Python, SQL, ClickHouse, AWS EC2, Apache Superset, AI APIs | analytics.rangsilk.com

Built conversational analytics platform for natural language data querying
Integrated AWS-hosted ClickHouse for high-performance analytical querying
Designed SQL generation workflows converting prompts to optimized queries

RangSilk E-commerce & Analytics Platform

MongoDB, AWS EC2, Apache Superset, Vercel | rangsilk.com

Developed production e-commerce website with integrated analytics ecosystem
Built dashboards for sales tracking, customer analytics, and operational KPI monitoring

Customer Retention Analysis

Python, Power BI, Machine Learning

Achieved ~90% model accuracy for churn prediction using feature engineering and ML

Skills

Languages: Python, SQL

Databases: MySQL, SQL Server, ClickHouse, MongoDB

Cloud: AWS (Athena, Redshift, EC2)

BI Tools: Power BI, Apache Superset, Redash

Analytics: A/B Testing, Cohort Analysis, Funnel Analysis, Forecasting

Tools: Excel, JIRA, Docker, Git

Education

Bachelor of Technology

Jan 2017 – Jan 2021

Pacific Institute of Technology, Udaipur, Rajasthan — 7.8 CGPA

Certifications

Data Science 360 — Python, SQL, Machine Learning, Data Visualization, Predictive Analytics

Professional Summary