Commercial Analyst
Aujan Coca-Cola Beverages Company
Total years of experience :9 years, 2 Months
Sales Forecast across countries and SKUs, hence manage to achieve at least 75% on forecast accuracy.
Design and prepare Monthly state of the business review reports on fundamentals.
Track channel execution plans and provide necessary timely recommendations on the variances. Continuously strive to improve productivity, drive faster and more meaningful reports into action.
Review and interpret Retail Audit Readings from AC Nielsen Reports, identify gaps and report findings.
Generate metrics dashboard to highlight and mitigate areas of non-performance and potential areas.
Finalize the Budgeted Volume across SKUs, for all the countries for the next year.
Designed Sales Development Dashboard for higher management to devise sales strategies.
Shared the product availability report, along with competition analysis and provide suggestions.
Provided price point, discounts and margin analysis on SKU level.
Analyzed the performance of the Top 10 key performing SKUs on various timelines.
Standardized Distributor Incentives Structures and provide provisions for efficient pay-out.
Continuous coordination with sales team and monitoring of the recurring stock to increase the sales.
Prepared the Monthly Commercial Review for EXCOM’s strategic planning.
Prepared monthly sales analysis across category, IC:FC split, segment and channel across territories.
Undertook sales performance analysis and develop insights into improving revenue generation.
Kept a track of zero primary, secondary and stock position across distributors to improve sales.
Compared nationwide approved promos per SKU with the actual promos active across territories.
Rolled out the weekly Commercial KPIs Report to track performance and take corrective actions.
Introduced Live Tracking of Sell-Out for Pakistan, leading a team of 6 people.
Designed, synchronized, prepared insights, presented to GM & processed commissions.
Initiated sharing weekly insights to equip sales teams with relevant information to manage product mix.
Conducted Price Analysis across competition to study the impact on business performance.
Used internal and GfK data to outline opportunities to enhance the Market Share and identify threats.
Localized the pre-launch, launch and post-launch strategies for new models being introduced in Pakistan.
In charge of online selling and promotional activities.
Prepared ad-hoc brand tracking presentations for BMs with fast turnover.
Presented monthly 8 Bottler Diagnostics with key insights and way-forward.
Designed a monthly top line sheet, 4 scorecards, 8 dashboards and deliverables for each category.
Well equipped with the Nielsen tools; PEP View, NITRO, Adviser, Retail Audit Data and its facts.
Trained PepsiCo partners on Nielsen Insight Studio - tools, facts and PEP View.
Coordinated amongst all the local clients and regional offices while the head of AAC was in Pakistan.
Actively participated in Nielsen’s Global Impact Day and International Woman’s Day.