Kota Semarang, Central Java, Indonesia
-Developed an Excel Macro that consolidates five individual
reports (in xlsx/csv format) into one comprehensive master report.
-Created a CSV data loading tool to automate raw data processing and integrate it into SQL databases for analysis. This tool was instrumental in analyzing site data for the Telkomsel project in Semarang.
-Established a Database Bank that streamlined OA (On Air) Reporting for newly commissioned sites, enabling the visualization of charts and graphs once the site was OA.
-Designed an Excel-based KPI Dashboard to monitor site performance, tracking improvements, maintenance, and degradation following on-site activities.
-Processed and analyzed data in XML format to support various reporting and performance metrics.
-Developed Line Reports and KPI Monitoring tools for special events (e.g., Presidential visits, Eid al-Fitr, and Christmas/New Year events) to facilitate real-time monitoring and prompt escalation when site anomalies occurred.
-Maintained detailed logs of site execution activities, ensuring a complete history of site operations for future reference.