Shehroz Aftab

Experience

• 

  Telenor Pakistan

  Apr 2008 - Apr 2013

  • Built Demographic projections to predict customer’s demographics (Gender, Age, skill level etc) using statistical techniques (Logistic Regression/Decision tree/Neural networks). The results will help micro-segmentation to launch targeted BTL campaigns for customers segregated on the basis of demo-graphics.• Built VAS segmentation on prepaid subscriber base to understand different subscriber segments present in the base w.r.t offered value added services.• Development of Churn Prediction Model using Logistic Regression/Decision Tree/Neural Network for various segments of the subscriber base. Models are built using SAS base, SAS enterprise miner, TDW miner & TD SQL Assistant. • Performed Product Affinity Analysis on a large portfolio of products offered to customers, in order to identify opportunities for Up-Sell, Cross-Sell and New Products development.• Currently Working on Event based marketing triggers for Retention, Non VAS Growth, VAS Growth and Internet Growth. It focuses on addressing needs of the customers immediately after defined event has taken place.• Social Pressure model for identification of potential internet subscribers based of Social network analysis.• Deployed Incremental Uplift model to support marketing for selecting the right set of customers which have higher propensity to respond to offers. It results in an increased qualification rate and more targeted campaigning.• To ensure smooth operations of developed statistical models on defined frequency. Show less • Project Speed (EDW Architecture Revamp): Worked on a project which focuses on reincarnating the aggregation layer in order to reduce ad-hoc reporting workload, ensure single version of truth and faster access to information. My responsibly involves gathering the requirements from business users, building the semantic data model, ETL development and migration of reports and dashboards to the new layer. Tools used are Teradata and Business Objects• Location Intelligence: Involved in development, design, implementation and maintenance of Location intelligence solution deployed at Telenor. My responsibility is to enhance the capabilities of this solution and make it useful for business units within the company by giving a geospatial meaning to the data. Tools used are Business Objects and Teradata.• BI Dashboards: Involved in design, development, implementation and maintenance of dashboards for multiple business units within Telenor. • Liaison with business users, understand their requirements and deliver them efficient solutions (via OLAP tools or Ad-hoc reports) to full fill their business needs.• Ensure timely and accurate delivery of Ad-hoc reports and analysis to business users.• Design, develop and roll out new business models, in order to equip business with quick and efficient solution for their business needs.• To bring out improvements in existing Semantic layer design and cube development.• To ensure smooth delivery of automated scheduled reports/analysis to the business users.• To coordinate with DWH team for fixing of Data Quality issues and new aggregates development and deployment• Ensure smooth coordination with vendor for business models upgrades and expansions. Show less

  • Business Intelligence Specialist - Advanced Analytics

    Mar 2011 - Apr 2013

  • Business Intelligence Specialist - Planning and Design

    Apr 2008 - Mar 2011
• 

  Stc

  Apr 2017 - now

  Enabling E2E visibility through a customer-centric platform to have insights on customer experience across customer life cycle stages. Covering B2C & B2B services, ensuring E2E service experience design, delivery, and assurance. Strategizing the technology initiatives and related business cases supporting business goals in order to ensure the necessary data and analytics technologies operate effectively to allow advanced analytics• Planning and Supervising implementation of Strategic initiatives to serve Corporate Customer Experience and Digital Transformation Program objectives• Developed Customer Experience Index (CEI) by collaborating with partners for Technology SMEs such as Delta Partners, Nokia, and Huawei CEX teams.• Ensured Automation and digitization of KPIs for Corporate indices covering all touchpoints, product and services offered across stc group subsidiaries• Planning and Design of Self-Service analytics solutions to support internal teams for impact/value generation• Managed Development of innovative Customer Experience product Solutions to enhance executive management visibility on Customer Experience initiatives and products• Leading team of skilled SMEs and architect who ideate and design solutions along with managing delivery of strategic products to proactively identify and create unique experience opportunities for our customers • Ideate and design Simple solutions for complex problems by utilizing innovative technologies and available resources• Managing team of technology enablers who act as a bridge between business and technology teams. Show less • Delivered high quality and insightful analyses on customer behavior and customer segmentation, customer profiles, existing, new products and services..• Apply data mining and machine learning techniques to build statistical models to solve complex business problems. • Lead a team of skilled architects tasked with the responsibility of assessing business trends and requirements, developing appropriate solutions, selecting most cost effective methodology by leveraging existing available technologies.• Explore new technologies in market to continuously improve Analytics capabilities at STC and acquire competitive edge in market over its competitors. Performed a detailed study of modern day BI tools available in market to add to existing BI tool set.• Provide Technical recommendations for optimized data access and retention for the data repositories and review of Solution architecture, High Level design documents. Build repository of reusable knowledge assets and implement best practices. • Designed and implemented real time reporting and analytics platform by replicating source data using oracle golden gate from more than 10 sources into oracle exa-data. At application layer, different BI tools (Microstrategy, Tableau) were connected to provide access of real time data to business users • Designed and implemented comprehensive self-service semantic model in Microstrategy which enabled business with qucik access to information through the 600+ predefined attributes and measures. • Design and implemented IT BSS Systems data reconciliation framework to identify discrepancies among different applications in real time. More than 50 KPIs were defined and implemented among different systems (CRM, Billing, Inventory etc) and identified discrepancies were rectified which reduced orders/requests failures among systems by more than 50%. This helped increase operational efficient, increased customer satisfaction and reduced revenue loss. Show less

  • Platform and Ecosystem Manager, Corporate Customer Experience

    Jan 2020 - now

  • BI & Analytics Lead

    Apr 2017 - Jan 2020