Prerna Prakash Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

Oversaw Pan India performance analysis for 3000+ delivery centers, identifying key operational issues such as escalations, fake attempts and providing data-driven recommendations.Conducted in-depth conversion analysis to identify trends and root causes and created reportsfor hub teams and delivering insights to senior management boosting conversion up to 93%.Developed a Power BI dashboard for performance tracking of delivery executives covering morethan 5000 executives, analyzing shipment allocation, customer matrix and probable per shipment costs.Increased customer satisfaction scores to 96% by enhancing report visibility by increasing credence.Created Management Reports at State and Zonal Level focusing on key matrics such as slippage, Return to Origin, Net Promoter Scores, Conversion and Cost Per Shipment.Created SQL tables with referential integrity and developed advanced queries using stored procedures and functions using SQL server, amplifying data extraction process up to 50%.

Delhi, India

Analyzed daily inbound shipment data to optimize routing and reduce operational inefficiencies.Collaborated with on ground teams to address process gaps, analysing the end-to-end seller pickup process to reduce the mixed bagging percentage from 28% to less than 10 %.Standardized and optimized data extraction process using SQL reducing load time by 30%.Created Excel dashboard for hub level tracking of delivery executive’s performance in real time and taking corrective action before the end of the day resulting in improved conversion and reduced fake.

Noida, Uttar Pradesh, India

BI technologies (Excel & PowerBI) were used along with SQL to deliver real time data insights.Produced performance reports in Advanced Excel increasing the efficiency by 50%.Designed data flows which led in increasing data quality by 40% and reducing errors by 50%.

Bachelors Of Journalism And Mass Communication, Mass Communication/Media Studies, A

Activities and Societies: Orators' Club, Design Team

Diploma In Fashion Technology, Fashion/Apparel Design, A