Back to Developers
prashant singh

prashant singh

Senior Data Analyst

Gurugram, Haryana 3+ yrs exp 93 · Outstanding

About

Data Analyst with 4 years at a supply chain SaaS company, building BI dashboards, analytics pipelines, and automation solutions for Automotive and FMCG clients. Strong SQL skills (joins, CTEs, window functions) and Python experience in data analysis, automation, and predictive modelling; proficient in Power BI with hands-on experience in data visualization. Reduced freight planning cycle time by 85% and SOB allocation time by 96% through process automation and logic-based decisioning. Comfortable owning the full analytics lifecycle- from requirement gathering and BRD/FRD documentation to dashboard delivery, UAT, and stakeholder sign-off.

Skills & Expertise (26)

Power BI Advanced
8.1/10
2
Years Exp
Advanced Excel Advanced
8.0/10
4
Years Exp
KPI Dashboards Advanced
8.0/10
4
Years Exp
Data Visualization Advanced
8.0/10
4
Years Exp
Reporting Advanced
8.0/10
4
Years Exp
SQL Advanced
8.0/10
4
Years Exp
Automation Advanced
8.0/10
4
Years Exp
Tableau Intermediate
7.5/10
2
Years Exp
Predictive Modelling Intermediate
7.5/10
2
Years Exp
Pandas Intermediate
7.5/10
2
Years Exp
Root-cause analysis Intermediate
7.0/10
4
Years Exp
Variance Analysis Intermediate
7.0/10
4
Years Exp
Confluence Intermediate
7.0/10
4
Years Exp
Jira Intermediate
7.0/10
4
Years Exp
Stakeholder Management Intermediate
7.0/10
4
Years Exp
UAT Coordination Intermediate
7.0/10
4
Years Exp
Requirements Elicitation Intermediate
7.0/10
4
Years Exp
Data Pipeline Development Intermediate
7.0/10
2
Years Exp
ETL Intermediate
7.0/10
3
Years Exp
NumPy Intermediate
7.0/10
2
Years Exp
Apache Spark Intermediate
6.5/10
1
Years Exp
Apache Airflow Intermediate
6.5/10
1
Years Exp
AWS Intermediate
6.0/10
1
Years Exp
BRD MongoDb Data Analysis

Work Experience

Senior Data Analyst (Process & Analytics)

Cogneau Systems Pvt. Ltd.

Jan 2025 - Present

Gathered and documented BRDs and FRDs across Automotive and FMCG engagements, facilitating workshops to translate business requirements into analytics specifications. Implemented a predictive sales planning model in Python for an FMCG client, achieving 75% forecast accuracy and reducing overstock risk. Led the SLAB-2 automation project, including As-Is/To-Be process mapping, UAT, and implementation, reducing the freight planning cycle time from 7 days to 1 day. Developed Power BI dashboards and automated reporting solutions for supply chain operations, providing real-time visibility for leadership and supporting data-driven decision-making.

Data Analyst

Cogneau Systems Pvt. Ltd.

Jul 2022 - Dec 2024

Delivered 20+ analytics and automation solutions, replacing manual Excel reporting with scalable dashboards and data pipelines. Wrote complex SQL queries for extraction, transformation, and analysis powering BI reports across multiple client accounts. Led the SOB Allocation Automation project and translated business rules into Spark-based automated logic, reducing allocation cycle time by 96%. Supported analytics and reporting for multiple Automotive and FMCG client engagements across supply chain operations.

Education

M.Tech - Dr. Ram Manohar Lohia Avadh University

2018 - 2020 · Afghanistan

B.Tech - GLA University

2012 - 2016 · Afghanistan

Certifications

Learning Path in Data Science

Board Infinity · 2022

Business Intelligence Using Power BI

Board Infinity · 2022

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

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer