Back to Developers
Vikram Kotlo

Vikram Kotlo

Product-focused Analyst

Bengaluru, India 3+ yrs exp 87 · Excellent

About

Product-focused Analyst with ~4 years of experience driving measurable business outcomes in Retail and E-commerce. Improved cross-category attachment and reduced stock inefficiencies through user behavior analysis and demand optimization. Strong in SQL, Python, A/B Testing and experimentation, with a focus on translating data into actionable product decisions. Holds a Master’s in Artificial Intelligence.

Skills & Expertise (32)

SQL Advanced
8.3/10
4
Years Exp
Python Advanced
8.1/10
4
Years Exp
Power BI Advanced
7.8/10
3
Years Exp
Tableau Intermediate
7.2/10
2
Years Exp
Machine Learning Intermediate
6.5/10
2
Years Exp
Microsoft Excel Hypothesis Testing Conversion Rate DAX Power Query Data Modeling Root Cause Analysis Google Analytics Git Docker Jenkins AWS A/B testing Market Basket Analysis Inventory Optimization Churn Analysis User Segmentation Retention Analysis Cohort Analysis Funnel Analysis Shell Scripting Postgresql scikit-learn Matplotlib Seaborn NumPy Pandas

Work Experience

Senior Analyst

Celltech (A Benchmark Cellular Company)

Aug 2024 - Feb 2026

Led analysis of 50k+ transactions across 20 stores to identify customer purchase patterns, informed bundling and placement strategies that improved basket size and cross-sell in key locations. Applied Apriori Algorithm to uncover high-affinity product pairs, supporting merchandising decisions and improving product visibility. Modeled demand forecasts in SQL to rebalance inventory across 20 locations, reducing excess stock by ~15% (≈$40–50K in holding costs) while lowering stockouts for high-demand SKUs by ~10%. Built SQL + dashboard solutions to track metrics such as AOV, sell-through rate, and stockouts, reducing manual reporting effort by ~8–12 hours/week. Evaluated promotion and inventory changes using pre/post and cohort-based analysis, identifying opportunities to improve product availability and reduce lost sales.

Data Analyst

Benchmark Cellular Inc

Feb 2023 - Aug 2024

Supported A/B testing of website features (search filters, product page redesigns) by analyzing experiment metrics (CTR, time-on-page, conversion), contributing to identification of winning variants with ~10–12% higher conversion. Analyzed customer cohorts (new vs repeat users) to identify churn patterns, insights informed re-engagement campaigns that reduced 90-day churn by 7%. Conducted end to end Funnel Analysis to identify drop-offs before checkout, uncovering UX friction points that led to changes improving checkout conversion by ~12%. Modeled seasonal demand patterns for accessory categories, improving inventory planning for peak periods and reducing overstock by ~10–15% and maintaining right stock at the right time. Built dashboards using PowerBI for tracking repeat purchase behavior, including purchase frequency and estimated lifetime value, enabling the marketing team to monitor retention trends. Cleaned and analyzed web analytics and order data (SQL, Excel) to support weekly performance reviews and business decisions.

Gen C Elevate Intern

Cognizant

Feb 2022 - Jun 2022

Completed structured training in data analytics fundamentals and learned data cleaning, basic analysis using Excel, Pandas and Numpy. Practiced writing advanced SQL queries for data extraction and gained foundational exposure to python for data analysis. Worked on practice datasets, case studies and created effective charts, dashboards using structured datasets with Tableau. Built a strong foundation in data concepts and analytical thinking.

Education

Master of Science, Artificial Intelligence - University of North Texas

- · Afghanistan

Bachelor’s in Electronics and Communication Engineering - Reva University

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

Profile Overview

Member sinceMay 2026