Oscar Lam

PowerShell Script (Back-end) - Developed PowerShell scripts to extract and analyze Microsoft PowerPoint data to identify excessive storage usage. - Automated cleanup processes to remove files that are in recycle bin, removing duplicate files and removing file versioning and keep 5 file versioning. Defect and Use Case Results Software Development and Deployment (Front-end and Back-end) - Designed and developed a software tool to track defect reports and use case results. - Deployed the software on Linux server.

SQL, Azure Data Factory (Back-end) - Cleaned, transformed, and prepared data for visualization using Azure Data Factory and SQL. - Ensured data quality and accuracy by performing data validation and testing. Qliksense (Front-end/Dashboard) - Created and maintained interactive dashboards and reports using Qliksense for various business functions and stakeholders such as sales dashboards, e-forms dashboards, etc. - Applied data storytelling techniques to present insights and recommendations based on data analysis and visualization. - Collaborated with data analysts, data engineers, and business users to understand data requirements and deliver solutions. Mendix (Low-Code Application Development Tool) - Used Mendix to create e-forms for the company’s internal processes, such as service requests, Employee travel forms, Outlet visitation forms, and more. - Designed and implemented user-friendly and responsive e forms with features such as data validation, file upload, email notification, etc.