Prachursya Prasad Sarma

Business Intelligence and Data Analyst with 3+ years of experience delivering analytics solutions across e-commerce and research environments. Skilled in SQL, Python, Power BI, Tableau, and data modeling to develop dashboards, KPI frameworks, and actionable insights. Experienced in analyzing datasets exceeding 100K+ records and automating reporting pipelines to improve operational efficiency and business decision-making.

Operations Executive & Data Analyst at Flipkart (2025-04 – Present)

Building SQL-driven dashboards and conducting data analysis to improve operational efficiency and logistics performance.

• Built SQL-driven dashboards tracking 25+ warehouse and logistics KPIs enabling leadership to monitor fulfillment performance.
• Analyzed 100K+ order and shipment records identifying operational bottlenecks improving processing turnaround time by 15%.
• Automated recurring reports using SQL queries and Excel dashboards reducing manual reporting effort by 40%.
• Developed dashboards monitoring shipment SLA adherence, inventory movement and workforce productivity.
• Conducted root cause analysis on operational anomalies reducing issue resolution time by 30%.

Business Intelligence Intern at Aivariant (2024-07 – 2024-10)

Built interactive dashboards and conducted exploratory data analysis to identify patterns and actionable insights.

• Built interactive Power BI and Tableau dashboards visualizing product performance and customer engagement metrics.
• Conducted exploratory data analysis and correlation analysis identifying patterns and actionable insights.

Technical Assistant at National Institute of Pharmaceutical Education and Research (2019-06 – 2022-07)

Conducted quantitative and qualitative data analysis supporting research reports and strategic insights.

• Conducted quantitative and qualitative data analysis supporting research reports and strategic insights.
• Delivered data-driven insights and summaries for stakeholders, enhancing decision-making processes

Master of Business Administration in Marketing Management – Krishna Kanta Handiqui State Open University (2021-08 – 2023-11)

Bachelor of Engineering in Mechanical Engineering – Rashtrashant Tukadoji Maharaj Nagpur University (2018-12)