During my Data Analytics internship at Burma Burma Restaurant & Tea Rooms, I identified that manually compiling, formatting, and auditing monthly statutory filings across 15+ outlets was consuming critical administrative hours and creating operational bottlenecks.
To solve this end-to-end, So, I built an HR Statutory Compliance Engine & Real-Time Notice Portal to automate the complete workflow. โ๏ธ๐
The platform brings together:
๐น Microsoft SharePoint / OneDrive Integration
โ Fetches centralized payroll and employee datasets through APIs with retry handling for network failures and throttling.
๐น Dynamic Schema & Rule Mapping Engine
โ Automatically maps inconsistent fields such as Emp Code, Empl_Code, and Code into a standardized structure.
๐น Automated Statutory Form Generation
โ Generates regional compliance registers while preserving government template layouts, rotated headers, formulas, formatting, and row structures.
๐น Excel Engineering with Python + OpenPyXL
โ Handles large identifiers, prevents scientific notation, applies formulas, manages text wrapping, and dynamically prepares data rows.
๐น Real-Time Notice & Incident Portal
โ A Google Apps Script-based portal for tracking statutory notices, inspections, licenses, approvals, and closure status.
๐ Business Impact
โก < 5 seconds โ document generation per outlet
๐ 85%+ โ reduction in manual processing effort
โ
0% โ template formatting corruption
๐ 100% โ centralized compliance visibility
โ๏ธ Cloud-synchronized and audit-ready workflows
๐ ๏ธ Technology Stack
Python | Pandas | NumPy | OpenPyXL | Streamlit | Microsoft Graph API | SharePoint | OneDrive | Google Apps Script | Gmail | Excel Automation
What I particularly enjoyed about this project was solving the problem at the intersection of Data Analytics + Automation + HR Operations + Regulatory Compliance.
It reinforced an important lesson for me:
Good automation isn't just about reducing clicks it's about building a reliable process that people can trust.
This project strengthened my interest in building data-driven business automation solutions that create measurable operational impact.


0 likes ยท 2 views ยท Oct 11, 2026
During my Data Analytics internship at Burma Burma Restaurant & Tea Rooms, I identified that manually compiling, formatting, and auditing monthly statutory f...