Projects
Dynamic Fraud Radar Reports with Geo Visualization
Description: I specialize in developing dynamic fraud radar reports using Google Sheets. These reports save valuable time by enabling users to filter and analyze fraud data on a monthly or weekly basis. With automatic updates, all 49 charts, diagrams, and maps stay current through a simple copy and paste process, ensuring the latest data is reflected. Geo visualization maps enhance visibility and understanding of fraud patterns, empowering users to make informed decisions and proactively combat fraud.
Task Management Tracker with Automated Email Notifications
Description: I created a task tracker using Google Sheets, featuring columns for task details, progress, and assigned team members. The tracker includes an automated email notification system that sends emails with task updates and a direct link to the tracker file when a task is marked as "Done." This streamlines task management and saves time for seamless collaboration.
Benefits:
Efficient Task Management: The tracker enables clear visibility and effective tracking of tasks, including start and end dates, progress, and assigned team members.
Automated Notifications: The automated email notifications ensure seamless communication and prompt handover of tasks.
Time-Saving: The provided link in the email allows recipients to directly access the tracker file, eliminating the need for manual searching and navigation.
Web Page Development and Version Control
In the project, I leveraged TortoiseSVN and Microsoft Visual Studio version control systems to effectively manage and update web page code based on specific requirements. I played a key role in defining and revising specifications, investigating and resolving fault issues using PRONTO, and actively collaborating with the team to implement new features. This comprehensive approach ensured seamless development and enhanced the overall functionality of the web pages.
Core Network Cloud Base Upgrade Project
Responsible for virtual box installation, configuration, and support.
Managed release updates, upgrades, and monitored resource utilization.
Provided expert technical support and collaborated with cross-functional teams.
Contributed to knowledge sharing and continuous improvement.
Achieved smooth installations, optimized customer environments.
Customer Workshops
Project scope: Conducting twenty-plus workshops on the US market for major telecom companies such as Verizon, AT&T, and T-Mobile. The workshops cover various topics related to 5G and LTE technologies.
Workshop topics include:
5G Fault Management essentials
5G Basic Cell Trace
5G PCMD Essentials
5G Enhanced Cell Trace
5G Commissioning Wizard
5G Zero touch commissioning UI for 5G NB
5G Cell deactivation and service status
LTE NB - IoT Tracing
LTE MDT inter-frequency UE periodic measurement enhancement
LTE Independent Transport Commissioning in SBTS
LTE automatic sleeping cell detection and recovery
LTE RX Power and traffic-based sleeping cell detection
LTE Load Balancing techniques [ACTIVE MODE]
LTE Configurable number of UEs for load balancing
LTE Incoming Handover from 5G SA Option 2
P3 benchmarking measurements
Crowdsourced Data
Project scope: Utilizing crowdsourced data from TUTELA to determine Nokia's market share. TUTELA data covers a wide range of third-party mobile apps and provides insights into over 250 million handsets.
Responsibilities include developing a methodology and detailed specification document for the development team. Manual verification of the results for several countries to ensure accuracy and precise calculation of Nokia's market share using TUTELA data.
Green Belt in Six Sigma
Project objective: Lower the dropped call rate by 5% for a specific BSC (Base Station Controller) while maintaining the same traffic growth margin.
Responsibilities include managing the process flow according to the DMAIC (Define Measure Analyze Improve Control) methodology. Analyzing network-level KPIs and driving test results to identify areas for hardware and software improvements.
Results: Achieved a 19% decrease in dropped calls and a 7% overall improvement during the project's duration.
Main Railway Line in Georgia (Tbilisi to Batumi)
Project scope: Establish continuous coverage along a 400-kilometer train line between Georgia's capital, Tbilisi, and Batumi, a popular tourist destination.
Responsibilities include proper site location planning, simulation preparation, and drive test log file correlation using the planning and optimization program Atoll.
Result: Successful completion of the project within the allocated time limit.
Project for the Metro Tbilisi
Project scope: Ensure reliable wireless signal coverage in all 22 metro stations in Georgia's capital city.
Responsibilities include determining base station positions, antenna distribution point choices, and overseeing the drive test team. Preparation of before-and-after reports to track the project's success.
Result: The project was completed on schedule and to satisfaction.
Frequency Distribution for Georgia and Azerbaijan
Project scope: Create agreement documents and allocate frequencies along the shared border to prevent interference.
Responsibilities include fair and proper frequency splitting and distribution among operators. Involvement in the agreement's development process and obtaining necessary approvals.
Result: Successful completion of the project within the agreed timeline.
Vendor Swap (Ericsson to Huawei)
Project scope: Replace the entire network of the current vendor with Huawei equipment.
Responsibilities include monitoring key performance indicators (KPIs) on a daily/weekly basis to ensure the network performs at least at the same level as before the vendor exchange. Preparation and follow-up of before-and-after reports.
The project was completed effectively and without major complications.
Drive Test Tool Choices across TeliaCompany
Project scope: Renovation of the warehouse and selection of new drive test tool vendors for TeliaCompany's operators in Eurasian member countries.
Responsibilities include benchmarking specification preparation, trial test preparation, and vendor evaluation reports.
The project was successfully completed, selecting the best available vendor at the time.
Rehoming BSC & RNC at the Network Level
Project scope: Increase controller capacity through the rehoming of base station controllers (BSCs) and radio network controllers (RNCs).
Responsibilities include capacity calculations, defining new location codes, creating a list of new sites, and developing a special script file for a smooth rehoming process in a single night.
The project was completed in a single night without delays or issues.
Vendor Selection for Regular and 3D Maps
Project scope: Update outdated maps to meet new standards and create 3D maps for planning and optimization tools.
Responsibilities include writing specifications for both new and old maps, liaising with vendors, and managing workshop procedures. Assisting in the tender announcement process.
The project was effectively completed, and the best vendor was chosen for the 3D maps.
Comparing Mobile Operators
Project scope: Determine the actual market leader and performance of TeliaCompany, the largest mobile provider in Sweden, among its seven mobile operator members.
Responsibilities include participating in specification preparation, managing drive tests, and monitoring server performance and availability. Creating and presenting the final report to key stakeholders.
The project was completed effectively and met milestone expectations.
Large-scale Network Rollout
Project scope: Expand the network coverage and capacity by 35% over a two-year period.
Responsibilities include benchmarking specification preparation, trial test preparation, and vendor evaluation reports.
The project was successfully completed using the best available vendor at the time.
Global Optimization at the Network Level
Project scope: Optimize the network performance after a significant rollout to achieve the highest network quality.
Responsibilities include overseeing daily operations, approving work orders for software and hardware changes, and measuring KPIs before and after installations.
The project successfully met all deadlines and improved overall network quality.
Formation of Microlayers
Project scope: Implement the micro layer project in key districts of the capital city for network offloading and improved indoor signal penetration.
Responsibilities include selecting optimal nominal points based on drive test results, approving site visit reports, and managing the drive test team.
All prerequisite tasks were completed, and the project was successful.
Frequency Re-farming
Project scope: Improve indoor coverage for WCDMA 2100MHz using lower band 900MHz frequency, while maintaining optimal Key Quality Indicators (KQIs).
Responsibilities include maintaining network quality during frequency re-farming, monitoring KPIs, and managing frequency distribution and re-usage.
The project was completed successfully in a single night, although some cells required manual fixes to restore compromised quality.
Umbrella Solution
Project objectives: Create a centralized, automatic umbrella solution for multi-vendor network performance management.
Balancing of Traffic
Project scope: Implement a traffic balance system to prevent indoor coverage congestion on the 900MHz side by optimizing the distribution of traffic between WCDMA 2100MHz and 900MHz bands.
Responsibilities include assessing key performance indicators (KPIs) to evaluate the effectiveness of the traffic balance mechanism and creating superb files to support the project team.
Result: Developed a network-wide mechanism spreader that successfully resolved the congestion issue in the 900MHz band without the need for additional equipment distribution. The mechanism operated efficiently and effectively, achieving the desired traffic balance and improving indoor coverage.
Audit of Multi-Vendor
Project scope: Conduct an audit of multi-vendor network configuration management to ensure correct and accurate configuration of network cells.
Responsibilities include developing an automated solution for auditing multi-vendor network configuration management, serving as the main point of contact for the project, and building the solution from scratch.
Result: Successfully created an automated solution for auditing multi-vendor network configuration management. The solution effectively identified and rectified any instances of incorrectly configured network cells. Through meticulous work and the use of Excel macros and multiple module macros, an Excel file was prepared with comprehensive auditing capabilities. The project concluded with a high level of accuracy, ensuring that all network cells were properly configured.
E2E Solution for Network Troubleshooting
Project goal: Develop a comprehensive system for daily customer care performance enhancement.
Responsibilities include market research on leading suppliers, managing client workshops, overseeing on-site trial tests, and preparing reports with pros and cons.
While individual duties were completed on time, the project was suspended due to a budget shortfall.