Prabhat Kumar Email & Phone Number

Bengaluru, Karnataka, India

Client : Dell TechnologiesDomain : Payment, Pricing & Dell Identity

• Monitored and optimized ad performance for renowned real estate builders,including Gopalan, Garuda, Brigade, and B grade builders and Deliveredvaluable insights to drive data-informed decisions.

Bengaluru, Karnataka, India

a) Conducted market research and competitive analysis to identify emergingtrends, potential partnerships, and growth opportunities in the food deliveryindustry.b) Conducted in-depth data analysis to identify key trends and patterns incustomer behavior, order volumes, and delivery times, resulting in improvedcustomer satisfaction.c) Clean and validate datasets, ensuring data accuracy and integrity, and performad-hoc data analysis using SQL as required.d) Utilize SQL queries to extract, analyze, and transform large datasetsfrom the company's internal database, enabling accurate reporting anddecision-making.e) Developed efficient Excel-based Weekly and Monthly KPI trackers to identifyand monitor high potential zones, resulting in improved team productivity andsubstantial time savings.f) Designed Power BI visualization dashboards for Regional Key Accounts,empowering stakeholders with comprehensive insights for informeddecision-making on investment strategies and profitability analysis.Achievements:a) Secured an impressive 2nd rank in the city in terms of portfolio GMV, totalingnearly INR 4 Crore, demonstrating my ability to analyze and optimize businessperformance.b) Exceeded in KPI for Q1 and Q2 and ranked among the top 10 performers inthe south for driving growth for the portfolio in FY 21-22.c) Achieved remarkable 240% growth in orders and improved CMPO for Kapoor's Cafe, a leading Regional Key brand, capturing substantial market share within 6 months.d) Delivered an impressive 46% MOM growth for Biriyani Zone within a 2-month period through strategic analysis and operational optimization, resulting in an increased client investment on the platform from 51k to 6 lakh per month.e) Collaborated with a diverse set of Ads clients to optimize their ROI by effectively managing advertising expenditures in relation to a commissionable value of approximately 5 % and generated an annual revenue of INR 1.9 Crore.

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering

Matriculation, Schooling