WORK
Commercial Marketing Intern
Lucky Core Industries - Chemicals & Agri Sciences (CHAG)
Independently led end-to-end evaluation of 3 marketing agencies for CHAG, building a weighted 6-criteria scoring framework (Platform Fit 25%, Contract/SLA 20%, Audit Accuracy 17%, Influencer Quality 15%, Sector Credibility 15%, Cost Efficiency 8%) with Excel radar and bubble chart models. Shortlisted agencies from an initial pool of 8 through pre-qualification criteria, reducing evaluation time by 40%; gathered data via RFPs, pitch decks, and reference calls with 2 past clients per agency. Conducted cost/value analysis across retainer, project-based, and performance-linked pricing models, projecting 12-month spend and expected ROI based on historical CAC and lead conversion benchmarks. Delivered formal proposal with risk matrix and recommendation to Group Product Manager and commercial leadership; presented findings to a panel of 3 decision-makers with sensitivity analysis.
•Independently led end-to-end evaluation of 3 marketing agencies for CHAG, building a weighted 6-criteria scoring framework (Platform Fit 25%, Contract/SLA 20%, Audit Accuracy 17%, Influencer Quality 15%, Sector Credibility 15%, Cost Efficiency 8%) with Excel radar and bubble chart models.
•Shortlisted agencies from an initial pool of 8 through pre-qualification criteria, reducing evaluation time by 40%; gathered data via RFPs, pitch decks, and reference calls with 2 past clients per agency.
•Conducted cost/value analysis across retainer, project-based, and performance-linked pricing models, projecting 12-month spend and expected ROI based on historical CAC and lead conversion benchmarks.
•Delivered formal proposal with risk matrix and recommendation to Group Product Manager and commercial leadership; presented findings to a panel of 3 decision-makers with sensitivity analysis.
Key Achievements
→Enabled the immediate launch of the division's first-ever marketing campaigns by providing a structured, data-backed agency selection framework.
→Independently led end-to-end evaluation of 3 marketing agencies for CHAG, building a weighted 6-criteria scoring framework (Platform Fit 25%, Contract/SLA 20%, Audit Accuracy 17%, Influencer Quality 15%, Sector Credibility 15%, Cost Efficiency 8%) with Excel radar and bubble chart models.
→Shortlisted agencies from an initial pool of 8 through pre-qualification criteria, reducing evaluation time by 40%; gathered data via RFPs, pitch decks, and reference calls with 2 past clients per agency.
→Conducted cost/value analysis across retainer, project-based, and performance-linked pricing models, projecting 12-month spend and expected ROI based on historical CAC and lead conversion benchmarks.
→Delivered formal proposal with risk matrix and recommendation to Group Product Manager and commercial leadership; presented findings to a panel of 3 decision-makers with sensitivity analysis.
→Catalyzed the launch of the first marketing campaigns in the division's history.
→Reduced evaluation time by 40% through pre-qualification criteria.
→Built a weighted 6-criteria scoring framework for agency evaluation.
Microsoft ExcelRadar ChartsBubble Chart ModelsRFPSensitivity AnalysisROI ModelingCAC Benchmarks