Easy License Requester (ELR)

⏱️ Timeframe: 2019

🧑‍💼 Client: Confidential

🛠 Tech Stack: Python · PyQt5 · MSSQL · MySQL · XML · XLSX

🧩 Overview

Easy License Requester (ELR) is a custom-built application developed for Vodafone to search and analyze license data across telecom network databases.
It facilitates automated querying, data parsing, and real-time insights into Ericsson network license usage — significantly reducing manual effort and improving data visibility.

🎯 Project Objectives

• Automate license data discovery across Ericsson’s telecom systems.


• Provide fast, accurate search capabilities through complex datasets.


• Ensure secure and scalable access to network license information.


• Enable smooth integration with Vodafone’s existing infrastructure.

🔍 Key Features

• ✅ Advanced Search Engine: Query across network-wide license databases.


• ✅ Multi-Database Connectivity: MSSQL and MySQL integration.


• ✅ XML Processing: Parse and extract data from XML structures.


• ✅ Audit-Ready Output: Supports reporting and compliance checks.


• ✅ Modular Architecture: Easy to maintain and scale for new datasets.

🚀 Results & Impact

• ⏱ 85% reduction in manual license lookup time.


• 🧠 Improved audit readiness and data accuracy.


• 📈 Enhanced scalability to support expanding telecom infrastructure.


• 🔐 Secure access layers integrated with enterprise IT systems.

💬 Client Testimonial

"The ELR tool has streamlined our license tracking process across multiple databases. It's accurate, fast, and fully integrated with our network — a real game changer."
— Network Operations Manager

📸 Visuals (For Slide Deck / Web)

• Screenshot: ELR interface with search function and XML output viewer


• Diagram: Architecture showing DBs → ELR → Output/Reports


• Graph: Time saved (before vs. after automation)

👥 Team Involved

• Software Developer – Python scripting, DB integrations


• Data Engineer – MSSQL/MySQL optimization, XML pipeline


• Project Manager – Client coordination, delivery


• Network Expert – System testing, data validation

✅ Summary

ELR is a robust automation tool that brings transparency, speed, and accuracy to license data management within telecom environments.
It exemplifies our ability to deliver secure, scalable, and domain-specific software solutions for global enterprise clients.