Prakhyat Mishra

Analytics Consultant

Gurgaon, India 4+ yrs exp 89 · Excellent

About

Analytics Consultant with 4+ years leading data-driven strategy engagements in CRM, loyalty, and marketing analytics for retail and FMCG clients. Owns workstreams end-to-end—from stakeholder discovery through hypothesis-driven analysis to executive-ready storytelling—while coordinating cross-functional teams across Marketing, Tech, and Operations. Comfortable as the primary point of contact for client stakeholders, mentoring junior analysts, and turning ambiguous business problems into structured, actionable insight. Skilled in SQL, Python, Power BI/DAX, and BigQuery, with a consulting mindset built on ownership and measurable impact.

Skills & Expertise (27)

Python Advanced

8.5/10

Years Exp

Machine Learning Advanced

8.2/10

Years Exp

Advanced SQL Advanced

8.0/10

Years Exp

Power BI Advanced

7.8/10

Years Exp

Marketing Analytics Advanced

7.5/10

Years Exp

Report Automation Relationship Management ETL Google Cloud Platform Google BigQuery Advanced Excel Power Query DAX RAG LLMs GenAI XGBoost scikit-learn Pandas Trend Analysis Campaign Analysis Customer Segmentation A/B testing Structured problem-solving Executive Presentations Cross-functional Leadership mentoring

Work Experience

Consultant – Strategy and Analytics

Easyrewardz Software Services

Jul 2025 - Present

Act as the analytics point of contact for retail clients, owning end-to-end delivery of CRM loyalty and campaign performance workstreams from problem framing to executive readout. Led analysis of sales, inventory, and customer behavior across 40+ retail stores using Python and Excel—evaluating sell-through rate, ATV, ASP, and bill banding—to isolate root causes of excess markdowns and present recommendations. Designed and owned an end-to-end CRM Loyalty Analytics solution covering 116K loyalty members and 206K transactions, delivering insights on migration, reward liability, and retention. Built an end-to-end customer churn prediction system on 50K+ customer records using Python (scikit-learn, XGBoost), leakage-safe preprocessing, class-imbalance handling, and SHAP explainability; compared Logistic Regression, Random Forest, and XGBoost models (ROC-AUC 0.78), enabling targeted retention outreach to the top 10% highest-risk customers with a projected 370% ROI (~$29.6K net impact). Built and maintain MBR campaign performance reporting using SQL, Excel, and Power BI, setting the standard for KPI tracking used across the account. Built an RAG + GenAI-powered MBR insight-writing workflow that converts recurring chart, table, and KPI analysis into executive-ready narrative insights in minutes, cutting hours of repetitive manual insight-writing to minutes.

Analytics Consultant

EXL Services

Apr 2022 - Jul 2025

Designed customer segmentation analysis using SQL across demographic variables, identifying 3 high-value segments and presenting the business case that increased targeted marketing ROI by 25%. Owned loyalty program performance dashboards end-to-end—from requirements gathering with stakeholders to build and rollout—tracking member activity, reward utilization, and tier progression, supporting a 15% improvement in member retention. Led performance analysis for 20+ marketing campaigns using SQL, partnering with the marketing team to optimize spend allocation and increase campaign effectiveness by 18%. Implemented test-vs-holdout methodology and Power BI dashboards for campaign measurement, improving targeting accuracy and driving 12% higher conversion rates.