Our Projects

Overview

Designed and developed a complete multi-page responsive business website for Elyco Technology International, a Singapore-based security hardware and electronics distributor. Built entirely from scratch with pure HTML, CSS, and JavaScript — no templates, no WordPress — hosted on Cloudflare Pages with a custom domain and full SEO optimisation.

Key Deliverables

• Multi-page responsive website (Home, Products, About, Contact, and more)
• Product catalog showcasing 200+ security hardware items with categories and filters
• Floating action buttons (WhatsApp, Email, Call) for instant customer contact
• Partner/brand marquee banner showcasing distributor partnerships
• Contact form with pre-filled mailto integration
• Full SEO setup — sitemap.xml, robots.txt, meta tags, and Google Search Console verification
• Cloudflare Pages hosting with custom domain configuration and SSL
• Mobile-first responsive design optimised for all screen sizes

Tools & Technologies

Overview

Built a two-part automation and analytics system consisting of a Python Selenium WebDriver bot and a Streamlit analytics dashboard. The bot automatically logs into LinkedIn, runs 19 targeted job searches in Singapore, filters results using 60+ role-relevant keywords, deduplicates listings by job ID, and exports structured data to CSV.

The collected data is visualised through an interactive Streamlit + Plotly dashboard featuring live KPI metric cards, category breakdowns, work mode analysis, top hiring companies, seniority heatmaps, in-demand skill bubble charts, a job market treemap, and clickable job listing cards with direct LinkedIn links.

Key Features

• Automated LinkedIn login and multi-query job search across 19 role categories in Singapore
• Smart keyword filtering across 60+ role-relevant terms (audit, data, automation, BI, SQL, Python, etc.)
• Deduplication engine using job IDs to prevent duplicate entries across all queries
• Scroll-based dynamic content loading to capture all paginated job cards per search
• Streamlit dashboard with 5 live KPI metric cards: total jobs, companies, intern roles, hybrid/remote, categories
• Interactive Plotly charts: category bar, work mode donut, top 15 companies, seniority breakdown, Category × Seniority heatmap
• In-demand skills bubble chart and interactive job market treemap (Company × Category drill-down)
• Filterable job listing cards with direct LinkedIn links, sidebar filters, and one-click CSV export

Tools & Technologies

Overview

Country-level audit risk heatmap built in Power BI, integrating multiple data sources with RAG (Red-Amber-Green) logic across Finance, Supply Chain, Procurement, and HR KPIs for global audit planning and risk prioritisation. This dashboard enables the audit leadership team to identify high-risk countries at a glance and allocate audit resources effectively across 15+ countries.

Key Deliverables

• RAG risk scoring across 5 business process areas (Finance, Supply Chain, Procurement, HR, IT)
• Advanced DAX measures with TREATAS virtual relationships for cross-source data integration
• Drill-through navigation from heatmap cells to detailed source dashboards
• Parameter-driven configurable thresholds — audit managers can adjust risk boundaries
• Consolidated management view across 15+ countries with regional rollups
• Interactive heatmap matrix with conditional formatting and colour-coded risk indicators
• Semantic model design with star schema for optimal query performance

Tools & Technologies

Overview

AI-assisted automation to detect duplicate expense claims combining rule-based field matching with AI Builder receipt image comparison to flag potentially fraudulent or duplicate submissions before processing.

Key Deliverables

• Rule-based matching on amount, date, vendor, and category fields
• AI Builder receipt image comparison for visual duplicate detection
• Confidence scoring system to prioritise flagged claims
• Automated email alerts to finance team for review
• SharePoint integration for claims data storage
• Power Automate orchestration for end-to-end workflow

Tools & Technologies

Overview

Power BI dashboards connected to ERP and MES systems for a medical device manufacturer, tracking production cycle time, yield, scrap rates, and supplier defect analysis with Pareto charts.

Key Deliverables

• Real-time production cycle time tracking by product line
• Yield and scrap rate analysis with trend charts
• Supplier defect analysis with Pareto distribution
• OEE (Overall Equipment Effectiveness) monitoring
• Drill-through from summary KPIs to production line detail
• Scheduled data refresh from ERP/MES via gateway

Tools & Technologies

Overview

End-to-end Power Automate workflows for audit operations including document extraction from emails, structured data population into SharePoint, notification flows, and exception logging.

Key Deliverables

• Automated email attachment extraction and classification
• Structured data parsing and SharePoint list population
• Approval chain automation with multi-level routing
• Exception logging and error notification flows
• Scheduled reminder and follow-up notification system
• Audit tracker dashboard integration

Tools & Technologies