Pranav Tewari

Experience

• 

  Xerox

  Jan 2014 - Apr 2015

  Quality Assurance Analyst

  Use of Advanced SQL to perform in-depth analysis.process like Inventory, culling, De-duplication, Indexing and searching.Create complex SQL, Boolean or other queries as needed to research and resolve data issues.Performed positive testing, negative testing, regression testing, script testing, and code reviews in order to test the correctness of the data.Execute tests for new features as well as regression tests for each release.Design, implement, debug and unit test software for new and existing applications.techniques of sampling, statistical analysis. Show less

• 

  Ericsson

  Apr 2015 - Jun 2016

  Switch Engineer

  • Monitoring alarms on daily basis.• POI maintenance.• End to end coordination for the new POI implementation.• Carrying out E1 augmentation.• Trouble shooting of faults like RP faults, CP faults.• Disaster Recovery of APG40 C/2, APG40 C/4, APG43. Radio Network Controller (RNC) EVO RNC and Blade Cluster

• 

  Bharti Airtel

  Jun 2016 - Jun 2019

  Data Analyst

  • PREPAID BUNDLE RECOMMENDER: to customer (eg: 299, 399) which is giving more revenue to business and more opted by customers through the output of Decision Trees or Random Forest.• CHURN PREDICTOR: To check the reasons of churning of customers from system by analyzing their recharges, usages and call drops in particular area• LOAN PREDICTOR: To check which customer should get the Loan, we take majority of votes from output of decision trees in our scoring model: Considering 2 Factors: The recharge and borrowing behavior of individual customer and General Market LOAN performance.• Analyzing customer recharges and usages as per marketing plan• Performed User Acceptance testing (UAT) for Darts on HIVEWorked on Vendor V/s IN, Credit V/s Debit of each MSISDNPerformed User Acceptance testing (UAT) for Darts on HIVE, Rubik (PrestoSQL).Data and Trend analysis of all accounts of single customer (Main and Dedicated Account)My Airtel App, Wynk Music App, Airtel Money App from first Analysis to implementation, Designing Test casesCaught a Leakage of $17 Million which was going through TWSS Node to the Customer for July'17 and closed it End to EndA Fraud of $ 48 Million was reported Which was going through Web recharges to the New 4G Handset UsersA $ 35K leakage was caught by in Zambia where customer was getting double benefit on SIM upgradation.A misconfiguration was reported at vendor end when a customer getting Loan from operator was not being charged on recharge which led to $ 40K loss to AirtelNew Digital Transaction logic was Build up across all OPCOS in Africa in the Pandemic year 2020.Creating SOP and giving BRD requirements to CFTsReviewing of Free RG’s abuse, Adjustment summary of Postpaid customersFraud ManagementWorking in Prepaid Vertical for India, Jersey, Sri Lanka and Africa Operations (Tanzania & Zambia)Automations: After reviewing the requirements, activities automated using SQL (AQT and Toad) Show less

• 

  Airtel Africa

  Jul 2019 - Oct 2021

  Senior Data Analyst

  PREPAID BUNDLE RECOMMENDER: to customer (eg: 299, 399) which is giving more revenue to business and more opted by customers through the output of Decision Trees or Random Forest.• CHURN PREDICTOR: To check the reasons of churning of customers from system by analyzing their recharges, usages and call drops in particular area• LOAN PREDICTOR: To check which customer should get the Loan, we take majority of votes from output of decision trees in our scoring model: Considering 2 Factors: The recharge and borrowing behavior of individual customer and General Market LOAN performance.• Analyzing customer recharges and usages as per marketing plan• Performed User Acceptance testing (UAT) for Darts on HIVEWorked on Vendor V/s IN, Credit V/s Debit of each MSISDNPerformed User Acceptance testing (UAT) for Darts on HIVE, Rubik (PrestoSQL).Data and Trend analysis of all accounts of single customer (Main and Dedicated Account)My Airtel App, Wynk Music App, Airtel Money App from first Analysis to implementation, Designing Test casesCaught a Leakage of $17 Million which was going through TWSS Node to the Customer for July'17 and closed it End to EndA Fraud of $ 48 Million was reported Which was going through Web recharges to the New 4G Handset UsersA $ 35K leakage was caught by in Zambia where customer was getting double benefit on SIM upgradation.A misconfiguration was reported at vendor end when a customer getting Loan from operator was not being charged on recharge which led to $ 40K loss to AirtelNew Digital Transaction logic was Build up across all OPCOS in Africa in the Pandemic year 2020.Creating SOP and giving BRD requirements to CFTsReviewing of Free RG’s abuse, Adjustment summary of Postpaid customersFraud ManagementWorking in Prepaid Vertical for India, Jersey, Sri Lanka and Africa Operations (Tanzania & Zambia)Automations: After reviewing the requirements, activities automated using SQL (AQT and Toad) Show less

• 

  Accenture

  Oct 2021 - Mar 2022

  Assistant Manager

  Primary objective of project is to analyze network circuits between AT&T and vendor, TDM circuits and Ethernet circuits.Filed dispute of approx. $80K with 3 different vendors where the vendor was charging extra mileage as per FCC and the contract.

• 

  Deloitte

  Mar 2022 - now

  Executed internal control standardization and refinement, enhancing measures and dimensions forcomprehensive risk assessments.Led extensive CST regulatory audits for Mobily, STC, and Zain, assessing compliance with regulatory parameters impacting subscriber satisfaction.Evaluated operator-subscriber communication adherence and reviewed areas including subscriber rating, billing, and system maintenance, contributing to regulatory compliance.Implemented control testing protocols to verify the effectiveness of internal controls. Ensured strict adherence to telecom regulations and compliance standards.Prepared and presented comprehensive audit reports, including findings and recommendations.Proactively mitigated operational and financial risks, recommending corrective actions from audit results.Conducted multifaceted activities, including CDR validation, billing analysis, and rejection analysis, resulting in the identification of a $17 million leakage.Contributed to control enhancements for RAFM based on evolving measures and dimensions.Identified fraud instances resulting in significant financial savings and devised corrective measures.Led analysis and recommendations for major revenue-generating products, contributing to improved profitability.Developed Risk Control Matrix for Loyalty Management and Campaign Management, ensuring effective control implementation.Designed reconciliation reports to perform end to end validations, identified and fixed revenue-impacting issues, Assess existing RCMs for completeness, accuracy, risk prioritization, and other Risk/Control attributesAnalyzing New Products and their feasibility in Market for Hutch, Sri LankaA Major Fraud was identified where customer was exploiting the system since Jan 2019 by Enjoying thebenefits for free of costAnalyzed and recommended changes in the major revenue generating product (CLIQ PACK) for Hutch, Sri Lanka Show less

  • Deputy Manager

    May 2024 - now

  • Assistant Manager

    Mar 2022 - May 2024