Telecom Reporting Principal
Current• Perform data mining project such as Churn Predictive Modeling, Customer Profitability, New Customer Acquisition, Credit Risk Propensity & Payment Color Model, Market Basket Analysis (up/cross selling), Customer Behavior Segmentation and Recharge Color Model• Identify and prepare reports for different stakeholders (program management, BUs, partners, etc.) to assess the impact of the Loyalty Program i.e. member retention rates, usage growth• Provide support in designing, extracting data and reporting for campaigns, promotions and loyalty offers• Responsible for Data Modeling of Dimensions and Facts for the Data Warehouse.• Responsible for designing ETL strategy for both Initial and Incremental Load.• Responsible for the development of various mappings and process flows i.e. ETL logic for the extraction, transformation and loading of data into the Data Warehouse.• Responsible for development of Test Cases• Responsible for BI team • Lead a team responsible for reporting and analysis supporting departments such as Marketing, Sales, Operations and Finance• Provide detailed reports related to revenue, usage, customer base, as well as performance of GSM and Non-GSM products and services • Responsible for revenue reconciliation process between Finance & IT-DWH, which enables BU department to use the revenue figures in DWH on all levels (SAN, Account, Segment, and product levels)• Responsible for generating the BU commission reports on a monthly and quarterly basis• Participate in preparing the commercial presentation which summarizes the overall Business Unit performance which is attended by the Chief Business Unit Officer and all Business Unit department heads • The main responsible for ICT reports and analytics• Representing the Business Unit in communicating performance actuals to company management on a periodical basis