Rashid Ali

Data Analyst @Bell

Build and Maintain Competitive Wireless Pricing Landscape and Execution - Maintain Competitive Wireless Pricing Landscape for National Retail Channel - Continued to use the new techniques in Reporting for faster execution of HW Pricing in all banners of National Retail- Present the Weekly HW Pricing changes recap every Monday with execs - Automated the recap using Power BI and saved 8 hours of manual work per week Built Interactive Call Report Dashboard for Sales Team in Microstrategy- Allow Sales Managers/ Directors line of sight to visit frequency and optimize visit strategy - Drill down the summary from National Level to Store Level Produced weekly \"Devices/ Rate Plan Mix\" report from Microstrategy for Weekly executive view - Helps Channel Primes to Provide Channel Insights for each week - Plays important role while making pricing decisions Primed Tactical Promo Codes execution - Forecasting and Distributing Tactical Sales tools for all the channels - Shared Weekly report of Promo Code Usage for all channels using Microstrategy and SAS Automated Weekly Competitive Hardware Pricing (Smartpay, ISC and Incremental Offers) Recap - Reduced the process time from 12 hrs/week to 1 hour/week - The weekly recap helps to justify the sales results every week- Used Power BI, Excel VBA, Macros to produce the Summary Prepared HW/Service summary across all the Banners for 2021, 2020 and 2019 for all the days of a week - Helps in showing YOY HW/Service pricing info for every week and optimize pricing strategy - Used Microstrategy, SAS, Power Query to prepare results