KEY RESPONSIBILITIES
Report Generation & Management: Design, maintain, and publish daily, weekly, and monthly operational performance dashboards for senior management.
Workflow Automation: Develop automated scripts using Google Apps Script and Excel Macros (VBA) to minimize manual data entry and streamline repetitive tasks.
Data Extraction & Processing: Consolidate and clean multi-channel raw datasets utilizing advanced lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, Pivot Tables, INDEX-MATCH).
Data Integrity & Auditing: Perform regular data validation checks to identify discrepancies and ensure high data precision across departmental reports.
Cross-Departmental Support: Collaborate with internal teams to gather functional requirements, standardize reporting templates, and support data-driven decision-making.
