Syaamil Rosli

Data Analyst/ Front End Developer

Sigma Info Analytics Data Sdn Bhd•  July 2022 - Present

Crafted automated processes for data extraction, transformation with Python and Power Automate. Created PowerBI dashboards and data visualizations for efficient and effective data analysis. Developed Power Apps forms with intuitive User Interfaces and PowerBI layouts. Implemented scheduled data refresh and extraction processes with Power Automate for over 200 rows of data. Designed automated products using Power Automate, DAX and Power Apps to facilitate daily email distribution to stakeholders.

Data Analyst

Mudah.my•  July 2022 - October 2022

Developed a monthly webscraping script using Python to extract visitor counts from SimilarWeb for 200 websites Conducted research on 10 competitors and proposed effective strategies based on data analysis and AB testing Composed SQL scripts to extract over 500,000 rows of data from Google BigQuery and generated effective dashboards in Google Data Studio for stakeholders

Data Analyst

MrDIY Trading Sdn Bhd•  February 2022 - June 2022

Utilized VBA to automate, maintain, and debug 9 Excel templates for generating routine reports pertaining to warehouse/outlet stock movements for MrDIY Malaysia and 6 other countries. Implemented SQL queries via Quickdesk to extract data from warehouses, followed by data cleaning and processing. Designed layouts for 5 international warehouses, with over 5,000 racking units and 1,000+ CBM Volume. Monitored, standardized, and provided guidance for the end users of 6 report templates