Syed Raza Email & Phone Number

Lahore, Punjab, Pakistan

Islamabad, Islāmābād, Pakistan

Islamabad, Islāmābād, Pakistan

1. Managing all key commercial KPI Reporting – Revenue, Subscriber base, Usage and derived KPIs for Etisalat Group 2. Drafting and finalizing Executive Management Team’s Weekly KPI performance monitoring against Monthly Budget Targets and forecasting Month end’s Revenue 3. New Trackers/Dashboards Development a. Dashboard designing & implementation for internal stakeholders b. Collaborating with internal Teams for Reporting requirements c. Getting the data sourcing from the backend teams d. Conforming the Data integrity and completeness for all the dashboards and trackers e. Designing the Optimized dashboards and designing backend processes on DataMart layers (so that least data processing and cleaning required on presentation Layer) f. Reducing the manhours by designing optimized data extraction processes and reducing the chances of errors 4. Analytics & Deep dives a. Keeping an eye on the Core KPIs to monitor the Behavior change b. Finding the insights to make corrective measures whereever required. c. KPI monitored on daily, weekly & Monthly basis i. Subscriber BASE Movement , Revenue Movement, ARPU, AVPU, MOU ii. Data Sub penetration / Handset Profiling/ Active Ratios of subsequent months 5. Managing Digital Reporting - Internal & Group level a. Creating Daily, Weekly & Monthly Performace reports of Digital Sales b. ROI calculation of Digital Vs Legacy SIM Sale c. Commission Saving Projection of Digital Sales d. Monitoring Digital FCAs with Regional pentration e. Defining Digital Sales Funnel (overall Bookings, Bookings to BVS & BVS to FCA) f. Integration of Digital data in MSTR & creation of relevant Digital reports as per management and stakeholders requirements 6. Adhoc reporting & Analysis a. SQL/SDM data extraction as per management or relevant team requirement b. Pre and Post analysis & Insights c. Regional analysis of product/service & Insights d. KPI's trend analysis & insights

Islamabad, Islāmābād, Pakistan

Online Activation Shop: Initiating and launching the project of Online Activation shop for 1 step activation request via ufone web, currently getting 520 hits a day of average product subscription of Rs. 500 making 250 k revenue daily basis , making it Rs. 91 Million Activation a year with 1.9% commission saving on digital channel (appx saving 1.73 Million commission). Online Sales Project: A unique initiative to capture high value customers on digital channel with low acquisition cost and higher CLTV just by grouping two different modules residing in the existing system. Subscriber attained through the project have a 3 times better CLT and CLTV, falls in medium and high level segment and pays premium charges for Special Numbers. Leading customer acquisition and retention on rich digital media, measuring performance of digital assets through globally known digital platforms including Google Analytic.1. Segment Base BTL campaignsa. Download campaigns for My Ufone Appb. Dormancy Reduction campaignsc. Engagement Campaignsd. Identifying Universe of Digital Channelse. Identifying Target audiencei. Analyzing target audienceii. Creating Segments based on Behavioral attributes of target audienceiii. Identifying needs of target audienceiv. Product Development for BTL Subscribersv. Testing & implementation of BTL campaignsvi. Pre & Post Analysis of BTL Subscribers2. Organically increasing the app Downloads (exponential growth achieved)3. Month on month increase in traffic of Web and app usage by implementation of well-designed notification system and usage enhancement campaigns4. Creating Segmented BTL Campaigns to increasea. Downloadsb. Active Subscribers on App5. Enhancing and enriching Customer experience by introducing Online shop concept for UFONE6. Managing Social media existence of digital profile7. Up-selling, cross selling products and enhancing CLTV on digital channels8. Off-loading traffic from conventional systems to digital mediums

Ufone Tower

Ufone Customer Operation’s Nation wide reporting regarding Ufone Call Center (Internal Reporting as well as External Clients reporting, e.g British Council) , Service Center and Other Digital Channel reporting.*All Mentioned Reports Use Multiple data sources, Selection of data source depends upon requirement, we Have based the reports on Backend of Transactional Systems as well defined data marts, or flat files processed the Implementation of Real Time BI Dashboards1. Development of Front end Reporting Portal based on Real time DB of CISCO 10.52. Real Time Performance Monitoring dashboard3. Call Traffic/ Volume Analysis Dashboard 4. Agent Status ReportingPerformance Reporting of Call Center: Nation Wide reporting for all 3 nodes of UFONE for internal Clients as well as Management reports.Channel Performance Reports on Portal: Maintaining the Backend data sources of Centralized portal for performance reporting Nation Wide. Each Channel Reporting is handled end to end, from Data perspective, sanity of data, data sourcing and availability of data, data retention policy.Adhoc Reporting and Dimensional Analysis: 1. Subscribers Calling Patterns Analysis2. Revenue Trends Analysis3. Subscribers Aging Analysis4. Cell Site Level Analysis

Islamabad

Islamabad

Design and lead the execution of ad-hoc behavioral analysis through collaboration with stakeholder departments, which include Priority Customer Services, Marketing, MIS, Government Relations and Customer Service Departments. Interpretation of stakeholder’s requirements to accurately select from the range of data sources available.Demographic Data Management: Works with internal and external partners to ensure that PTML Ufone demographic data is appended properly.Segmentation Analysis: Assists in the design, development, and execution of customer segmentation schema.Customer Profile Reporting: Assists in the design, development, and execution of periodic reporting around customer behaviors and profiling.Retention Planning and Process Reporting: Assists in the design, development, and execution of reporting and analysis needed to support the periodic Customer Retention planning process. Designing Campaigns for Customer Retention Using RFM (Recency, Frequency and Monitory).Delivering data for different analytical reports as mentioned below: Subscribers’ Calling Patterns with respect to Call Count, Revenue Trends portrayed by Subscribers, Package Analysis, Subscribers Aging Analysis, Cell Site Analysis, Prediction Model Analysis, and Port Out Analysis.Maintain fresh snapshots of critical data sources.IN Dumps, Monthly Subscriber Data Dumps, Revenue and Recharges Data Dumps.

Successful Execution of disown Subscriber Project (668)The Objective to launch this campaign was to induce those subscribers who are using unregistered SIMs to register the ownership in their names. From data extraction till Data Analysis.Successful Completion of Ufone Full Subscriber base(18 million) Verification process with PTA(Pakistan Telecommunication Authority) Desktop Application Development Responsible for the development & deployment of below mentioned Soft-wares along with the designing & implementation of the databases working on the back-end.Fraud Team Activity Logging SoftwarePostpaid Subscribers Payments Analysis Software embedded with Crystal Reports.CDR Extraction Software using TeraData as Data Source.CDR & EIR Tracking SoftwareEIR Blocking / De-Blocking InterfaceAll Pre/Post Subscribers Activity Extraction And Analysis SoftwareWatch Dog (Fraud Management System) AdministrationUpdating the roaming partners list for HUR ReportsVerifiying rating Scenarios for PRE/Post Paid SubscribersObserving the Fraudulent Activities of Pre/Post Paid Subscribers

Bachelor Of Science - Bs, Computer Science

Bachelor'S Degree, Computer Science

Education record