Raza Jamil Email & Phone Number

Lahore, Punjab, Pakistan

Responsibilities:• Data Collection and Management: Collected, organized, and processed large datasets from various sources, developing and maintaining data pipelines and databases.• Statistical Analysis and Visualization: Performed statistical analyses and created automated data visualizations to support business decisions in Power BI for Ufone & PTCL.• Cross-Functional Collaboration: Worked with cross-functional teams to identify data needs and provide actionable… Show more Responsibilities:• Data Collection and Management: Collected, organized, and processed large datasets from various sources, developing and maintaining data pipelines and databases.• Statistical Analysis and Visualization: Performed statistical analyses and created automated data visualizations to support business decisions in Power BI for Ufone & PTCL.• Cross-Functional Collaboration: Worked with cross-functional teams to identify data needs and provide actionable insights.• Data Quality Assurance: Developed and implemented data quality checks to ensure data accuracy.• Business Intelligence Reporting: Created and maintained reports and dashboards for business intelligence.• Insight Generation: Generated insights and provided recommendations to drive business decisions.• Data Analysis and Automation: Used SQL, Excel, and Python for strategic decision-making, data modeling, and automating reports for higher management using ETL and BI tools.• Data Science and KPI Monitoring: Applied data science techniques to RF optimization. Monitored and analyzed 2G/3G/4G KPIs using SmartCare (Huawei) and took action to achieve performance targets. Optimized LTE/3G/2G technologies based on statistical analysis and drive test (DT) data.• End-to-End KQI Analysis: Utilized SmartCare (Huawei) for KQI analysis of OTT services at site and user levels. Show less

Lahore, Punjab, Pakistan

Responsibilities:• Strategy Driven Data Analysis covering technical & commercial domains including Network Availability, Voice & Data Traffic, Network Utilization, Revenue Trends, Churn Analysis, Subscribers Base, Fuel & Electricity Consumption, Customer Complaints, Root Cause Analysis, MBB/Handset Traffic contribution.• Launched SQL server based Centralized Database management to provide centralized database system for the region.• Development of databases & management level… Show more Responsibilities:• Strategy Driven Data Analysis covering technical & commercial domains including Network Availability, Voice & Data Traffic, Network Utilization, Revenue Trends, Churn Analysis, Subscribers Base, Fuel & Electricity Consumption, Customer Complaints, Root Cause Analysis, MBB/Handset Traffic contribution.• Launched SQL server based Centralized Database management to provide centralized database system for the region.• Development of databases & management level interactive Dashboards in Excel, Microsoft Power BI & Google Data Studio for quick decision making and strategy alignment.• GIS mapping to analyze data geographically using MS Power BI and Folium/Leaflet in python.• Detailed analysis of low revenue/High complaints/Low traffic sites w.r.t engineering KPIs to support commercials to uplift revenue.• GIS based HeatMaps creation for degraded areas identification in terms of Utilization, Availability, throughput and correlation with revenue & traffic.• Customer experience management by analyzing churn, ticket resolution, solution mapping for coverage and capacity complaints.• Developed interactive Web/Mobile App for Business Intelligence reporting and advanced Data analytics using Python Django and Python visualization libraries ( Bokeh, plotly and chart.js).• Macro creation in Microsoft Excel VBA to automate routine tasks to improve efficiency.• Project Planning, Monitoring and Implementation of Modernization, digitalization, expansions and Rollout Projects & vendor management.• Daily/Weekly reporting, Monitoring and Control of network KPIs related to availability, 4G leadership & Customer complaints.• Technology & Commercial trainings to align sales strategy based on Technical KPIs. Show less

Lahore, Pakistan

Responsibilities:•Launched SQL server based centralized database system for the region.•Centralized Database management using Microsoft SQL Server SSIS, SSMA and MS Access.•Data Analysis and Reports/Dashboard development in Microsoft Power BI and Microsoft Excel using advanced skills.•GIS mapping to analyze data geographically using MS Power BI, Google fusion table and Folium/Leaflet in python.•Developing interactive Web/Mobile App for Business Intelligence reporting and… Show more Responsibilities:•Launched SQL server based centralized database system for the region.•Centralized Database management using Microsoft SQL Server SSIS, SSMA and MS Access.•Data Analysis and Reports/Dashboard development in Microsoft Power BI and Microsoft Excel using advanced skills.•GIS mapping to analyze data geographically using MS Power BI, Google fusion table and Folium/Leaflet in python.•Developing interactive Web/Mobile App for Business Intelligence reporting and advanced Data analytics using Python Django and Python visualization libraries ( Bokeh, plotly and chart.js).•Macro creation in Microsoft Excel VBA to automate routine tasks to improve efficiency.•Detailed analysis of low revenue/High complaints/Low traffic sites w.r.t engineering KPIs to support commercials to uplift revenue.•Customer experience management by analyzing churn, ticket resolution, solution mapping for coverage and capacity complaints.•GAP Analysis & Risk Management.•Pre & Post Project Analysis to ensure the required outputs are being made out of Projects.•Leading different digital transformation projects like centralized database solution, agile expansion prediction and implementation etc.•Project Planning, Monitoring and Implementation of Modernization, digitalization, expansions and Rollout Projects.•Monitoring and Control of network KPIs related to availability, 4G leadership & Customer complaints.•Follow ups with regional teams, vendors and HQ for timely resource provisioning, deployment and issues rectification to maintain the network quality and customer experience.•Monthly presentation preparation for higher management using advance templates and smart arts. Show less

Lahore

Responsibilities:• Used Data analytics for Customer Centric RF optimization which includes Bad Pockets identification, analysis and optimization.• Quarterly Analysis of network site level expenses with revenue to find out the low revenue sites.• Used Data Science skills to transform RF Optimization routine work.• Worked on SmartCare(Huawei) E2E Data monitoring tool for in-depth Data Analysis.• Monitoring and Analysis of 2G and 3G KPI’s(PS & CS-CSSR, RRC Success Rate, RAB… Show more Responsibilities:• Used Data analytics for Customer Centric RF optimization which includes Bad Pockets identification, analysis and optimization.• Quarterly Analysis of network site level expenses with revenue to find out the low revenue sites.• Used Data Science skills to transform RF Optimization routine work.• Worked on SmartCare(Huawei) E2E Data monitoring tool for in-depth Data Analysis.• Monitoring and Analysis of 2G and 3G KPI’s(PS & CS-CSSR, RRC Success Rate, RAB Success Rate, Interference KPI’s like RTWP, Handover KPI’s like SHO, HHO, CS-IRAT HO, PS- IRAT HO) at Cell/Cluster/BSC/RNC Level and action taken on the basis of these stats in order to achieve targets.• Troubleshooting Call Drops, HO issues, Signal Strength Issues, Call Establishment, Accessibility and logical discrepancies via DT Logs/DUMP Audits/KPI stats.• Parametric Tuning for traffic balancing between 3G and 2G.• Analysis of Low throughput worst Cells of assigned clusters.• Worked on overshooting cells with TA & TP analysis and resolved them accordingly by physical changes.• Worked on 2G 3G Neighbor Audit to Improve HOSR.• Analyzed and optimized LTE/3G /2G technologies based on stats and DT drives to improve the performance of network.• Worked on Microsoft Excel VBA to create Macros and automating routine tasks to improve efficiency.• Worked on Microsoft SQL to automate routine tasks using SQL Server integration services (SSIS), Analysis (SSAS) and reporting (SSRS).• Working on Huawei PRS tool and Huawei SmartCare for data extraction and Analysis using its built-in graph plot feature.• Data visualization and reporting using Microsoft Excel and power BI. Show less

Multan

• Monitoring and Analysis of 2G and 3G KPI’s on a daily basis at Cell/Cluster/BSC/RNC Level from BO (Ericsson), iManager PRS (Huawei) and Netnumen (ZTE).• Cell/Cluster Level Pre-Post Swap analysis of important KPIs.• Analysis of worst cells with degraded KPIs.• Stats include CSSR, DCR, CS Blocking, SD blocking, Inter-RAT Handover Success Rate, RRC Connection Success Rate, RAB Establishment Success Rate, SHO Success Rate etc.• 2G 3G Neighbor Audit to Improve HOSR.• Proposed… Show more • Monitoring and Analysis of 2G and 3G KPI’s on a daily basis at Cell/Cluster/BSC/RNC Level from BO (Ericsson), iManager PRS (Huawei) and Netnumen (ZTE).• Cell/Cluster Level Pre-Post Swap analysis of important KPIs.• Analysis of worst cells with degraded KPIs.• Stats include CSSR, DCR, CS Blocking, SD blocking, Inter-RAT Handover Success Rate, RRC Connection Success Rate, RAB Establishment Success Rate, SHO Success Rate etc.• 2G 3G Neighbor Audit to Improve HOSR.• Proposed TRX expansion on the cells with high TCH utilization in TCH Blocking.• Network performance reporting and presentation to management.• To perform 2G and 3G Drive testing using Nemo tools and TEMS.• 2G and 3G City level benchmarking and Cluster drive testing using TEMS, Nemo INVEX and Nemo Multi Lite to check quality of network.• Analyzing and reporting of drive test log files using Nemo Outdoor, Nemo Analyzer, TEMS, Actix Analyzer and MapInfo.• To analyze the issues in 2G & 3G Benchmarking, Cluster, SSVs and Complaints reports to improve the quality of network.• Identification of faults and issues during the drive test e.g. sector swaps (complete & partial) Handover failures, Call drops, Call Blocks, bad Quality and Rx level patches, Interference, missing neighbors, overshoots etc.• Performing hard optimization of the network so as to minimize coverage holes, interference & quality Issues. • To carry out joint visit of corporate customer complaint locations and highlighting issues to other technical teams.• Coordination with customer for all network related Tasks & issues. Show less

Faisalabad, Pakistan

Responsibilities:• Monitoring and Analysis of 2G and 3G KPI’s on a daily basis using different Network Performance analyzing tools.• Daily Stats Monitoring at Cell/Cluster/BSC/RNC Level from BO (Ericsson), iManager PRS (Huawei) and Netnumen (ZTE).• Cell/Cluster/BSC Level Pre-Post Swap analysis of important KPIs.• Reporting of daily major KPIs of 2G and 3G in Microsoft Excel and PowerPoint to the higher management.• Stats include CSSR, DCR, CS Blocking, SD blocking rate, PS… Show more Responsibilities:• Monitoring and Analysis of 2G and 3G KPI’s on a daily basis using different Network Performance analyzing tools.• Daily Stats Monitoring at Cell/Cluster/BSC/RNC Level from BO (Ericsson), iManager PRS (Huawei) and Netnumen (ZTE).• Cell/Cluster/BSC Level Pre-Post Swap analysis of important KPIs.• Reporting of daily major KPIs of 2G and 3G in Microsoft Excel and PowerPoint to the higher management.• Stats include CSSR, DCR, CS Blocking, SD blocking rate, PS Inter-RAT Handover Success Rate, RAB Establishment Success Rate (HSDPA), SHO Success Rate etc.• Identification of worst cells/BSCs/RNCs with degraded KPIs.• To perform 2G and 3G Drive testing using Nemo tools and TEMS.• 2G and 3G City level benchmarking and Cluster drive testing using Nemo INVEX and Nemo Multi Lite to check quality of network.• Performing Voice calls, Video calls, SMS, Ping &HSDPA test.• Monitoring SC, RSCP, Ec/No of 3G sites during DT.• Analyzing and reporting of drive test log files using Nemo Outdoor, Nemo Analyzer, Actix Analyzer and MapInfo.• To analyze Benchmarking and Cluster reports and give suggestions and recommendations to improve the quality of network.• Drive test analysis to improve 2G and 3G coverage and quality (RxQual or Ec/No).• Post processing of 2G and 3G Drive test log files to identify the RF related problems like poor coverage, pilot pollution, video and audio call testing with uplink and downlink throughput.• Identification of faults and issues during the drive test e.g. sector swaps (complete & partial) Handover failures, Call drops, Call Blocks, bad Quality and Rx level patches, Interference, missing neighbors, overshoots etc.• To carry out joint visit of corporate customer complaint locations and highlighting issues to other technical teams.• Coordination with customer for all network related Tasks & issues. Show less

Lahore

Responsibilities:•To perform 3G Drive testing using TEMS 13.1 &15.1.• Performing Voice, Video along with HSPDA test during coverage test.• Performing Voice calls, Video calls, SMS, Ping &HSDPA test.• Monitoring SC, RSCP, Ec/No, SIR of 3G sites during DT.• Performing FTP test through filezilla and through Tems script• Verifying soft handover, 3G to 2G IRAT handover, 3G to 2G IRAT cell reselection, and 2G to 3G IRAT cell reselection.• Drive test analysis to improve 2G… Show more Responsibilities:•To perform 3G Drive testing using TEMS 13.1 &15.1.• Performing Voice, Video along with HSPDA test during coverage test.• Performing Voice calls, Video calls, SMS, Ping &HSDPA test.• Monitoring SC, RSCP, Ec/No, SIR of 3G sites during DT.• Performing FTP test through filezilla and through Tems script• Verifying soft handover, 3G to 2G IRAT handover, 3G to 2G IRAT cell reselection, and 2G to 3G IRAT cell reselection.• Drive test analysis to improve 2G and 3G coverage and quality (Ec/No).• Identification of faults and issues during the drive test e.g. sector swaps (complete & partial) Handover failures, Call drops, bad Quality and Rx level patches, missing neighbors, overshoots etc.• Direct co-ordination with OMC for adding missing neighbors, removing frequency clashes and other activities needed during Drive Test.• Perform hard parameters optimization (M-Tilt and E-Tilt) to improve coverage.• Create log files and then import these log files at MAPINFO for the purpose of Reporting. Show less

Faisalabad

Responsibilities: To perform 3G/2G Drive testing using Nemo tools. Post processing of Drive test log files to identify the RF related problems like poor coverage, pilot pollution, video and audio call testing with uplink and downlink throughput. Monitoring KPI’s on a daily basis using different Network Performance analyzing tools  Daily Stats Monitoring at Cell/BSC Level from RNO (Alcatel) and iManager2000 (Huawei) OMC’s To carry out joint visit of corporate customer… Show more Responsibilities: To perform 3G/2G Drive testing using Nemo tools. Post processing of Drive test log files to identify the RF related problems like poor coverage, pilot pollution, video and audio call testing with uplink and downlink throughput. Monitoring KPI’s on a daily basis using different Network Performance analyzing tools  Daily Stats Monitoring at Cell/BSC Level from RNO (Alcatel) and iManager2000 (Huawei) OMC’s To carry out joint visit of corporate customer complaint locations and highlighting issues to other technical teams. Identification of worst cells/BSCs with degraded KPIs and forwarding to concerns for rectification. Perform drive test of swapped cities using NEMO tool during Ericsson swap project City level benchmarking to check quality of network  Benchmarking reports of drive test Scan mode drive tests to calculate interference to other cell, highlight Quality Issues and adjusting C/I thresholds. Coordination with customer for all network related Tasks & issues. Show less

Lahore

• To perform 2G Drive testing using TEMS.• Performing Voice, Data & coverage test• Performing single site verification, cluster drive testing and benchmarking.• Drive test analysis to improve 2G coverage and quality.• Identification of faults and issues during the drive test e.g. sector swaps (complete & partial), Handover failures, Call drops, bad Quality and Rx level patches, missing neighbors, overshoots etc.

Master Of Science - Ms, Data Science(Major Courses: Big Data, Business Analytics & Machine Learning)

Have deep understanding and expertise on: • Data Pre-processing (Data Cleaning, Integration, Transformation, Reduction) • Neural Networks.

Bachelor Of Engineering (Be), Telecommunications Engineering

Activities and Societies: • Part of management team in welcome and farewell parties. • Group leader in Final Year Project. • Organized.