During my Data Analytics internship by Ghiri SDuring my Data Analytics internship by Ghiri S

During my Data Analytics internship

Portfolio project
Ghiri S
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...

Tags