Internal Operations Dashboard

A robust, multi-page Streamlit application designed to centralize channel metadata and automate the processing of WMM meter XML logs.

Project Impact & Architecture

  • Designed and deployed an automated dashboard to monitor channel information.
  • Engineered an automated XML log processing pipeline, reducing manual operational workload by 70–80%.
  • Built with a focus on high-efficiency data retrieval and secure, role-based access.

Problem Statement

Retrieving specific channel IP addresses across hundreds of terminals and manually unzipping/parsing WMM meter XML logs to find time drift or missing WMIDs was a massive bottleneck for the operations team.

Solution & Features

I built a centralized Streamlit platform consisting of multiple specialized apps:

  • Channel Search Engine: Allows instant querying of channel names to fetch associated IP addresses across Airtel, TataSky, Dish TV, etc., with full data export to Excel.
  • Log Data Processor: Automatically extracts and processes `.xml` logs from zipped snapshots based on IP and date.
  • Anomaly Detection: Automatically flags missing WMID differences greater than 1 min 30 sec and highlights time drifts greater than 2 minutes.

Tech Stack

PythonStreamlitPandasXML ParsingData Analysis

Confidentiality Notice

Source code and proprietary network topologies are withheld due to organizational confidentiality policies.