
Raza Jamil
DT Engineer

Connect with Raza Jamil to Send Message
Connect
Connect with Raza Jamil to Send Message
ConnectTimeline
About me
Expert Data Analyst | Data Scientist | Business Intelligence Expert | SQL/BigQuery Expert | PowerBI/Tableau/Looker Studio Expert | Project Management | BS Telecommunication Engineering | Masters in Data Science
Education

Comsats Institute of information technology, Lahore.
2010 - 2014Bachelor of Engineering (BE) Telecommunications EngineeringActivities and Societies: • Part of management team in welcome and farewell parties. • Group leader in Final Year Project. • Organized trips.

University of Management and Technology - UMT
2017 - 2019Master 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, Regression, Classification, Naïve Bayes Algorithm, Decision Trees, Clustering and SVM (Support Vector Machines) • HDF (Hortonworks Data Flow) and HDP (Hortonworks Data Platform) • Hadoop Architecture, HDFS (Hadoop Distributed File System)• Spark Streaming & Apache Flink• Python (Pandas, Numpy, Keras, Tensorflow etc)
Experience

KomKonsult Private Limited
Jun 2013 - Sept 2013DT Engineer• 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.

Jazz
Jan 2014 - Apr 2014Trainee Qos EngineerResponsibilities: 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

KomKonsult Private Limited
May 2014 - Aug 20143G Drive Test EngineerResponsibilities:•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

Jazz
Aug 2014 - Sept 2015RF EngineerResponsibilities:• 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

LCC - A Tech Mahindra Company
Oct 2015 - Jan 2016RF Engineer (Outsource Employee for Mobilink RF Dept.)• 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

Ufone 4G
Jan 2016 - Apr 2019RF EngineerResponsibilities:• 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

Zong CMPak Ltd
Apr 2019 - Nov 2023Responsibilities:• 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 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
Assistant Manager - PMO
Jan 2022 - Nov 2023Sr. Executive - PMO
Apr 2019 - Dec 2021

Ufone 4G
Nov 2023 - nowManager - Network Performance AnalyticsResponsibilities:• 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
Licenses & Certifications

Data Analysis with Python
IBMSept 2020
Data Visualization with Python
IBMOct 2020
Data Science & Machine Learning
Dice AnalyticsOct 2020
Python for Data Science
IBMAug 2020
Recommendations

Patricia garcia
Commercial Real Estate Analyst at Wells FargoDenver, Colorado, United States
Prince saini
UX/UI Designer and Developer at R2Media Pvt Ltd.Delhi, India
Lara rodrigues
Editora de Videografismo at GloboRio de Janeiro, Rio de Janeiro, Brazil
Hojjat izadi, phd
Software Engineering Group Manager at General MotorsToronto, Ontario, Canada
Leopoldo perez
Electrical EngineerDenver, Colorado, United States
Colin harris
Head of ITRustington, England, United Kingdom
Francisco marco
CFA Level III candidateGeneva, Geneva, Switzerland
Gabriel lindersson
Art Director & DesignerGothenburg, Västra Götaland County, Sweden
Samantha b.
HealthcareSurrey, British Columbia, Kanada
Jack switzer
Director of Operations at Vision DirectGreater Indianapolis
Mark ireland
Information Systems Specialist at Idaho Youth RanchBoise, Idaho, United States
Syed zaffer
Senior Cloud & DevOps Engineer @ CGI | AWS Certified Solutions ArchitectBengaluru, Karnataka, India
Apoorva kohli
Project Manager: Paid Media at dau Agency | Freelancer | Ex - Practo | MBA Marketing Major at Doon B...Gurugram, Haryana, India
Sidney sneed
Officially retired...I finally made it.Phoenix, Arizona, United States
Ifechukwu juliet uwakwe
Business Development Manager at Arit of AfricaAbuja, Federal Capital Territory, Nigeria
Latonya williams-west
Midwife Assistant/Adv.State-Certified Community Doula/MCCHW/NCS/PAILAdvocate/Mentor/State Ambassador...Richmond, Virginia, United States
🧑💻 álvaro guirado cárdenas
Desarrollador Full-StackJaén, Andalucía, España
马璐瑶
Linco Marketing Ltd. General ManagerXuhui District, Shanghai, China
Lingeshwaran ravi
Business Analyst at Softura (CSM® | CSPO® | Certified Associate CMMI V2.0®)Tamil Nadu, India
Aaron johnson
Real Estate Broker at John L ScottVancouver, Washington, United States
...