● To be documented!

● Revamped ELT pipeline, replacing Azure Data Factory w Databricks & Airflow, reducing operational costs by 90%● Initiated machine learning pipeline integration with production app to predict high-potential subscribers with the Product & B2C teams.● Established playbooks, documentation, architectual, network & logic diagrams for Data Team & administrative &/ diagnostics operations.

● Developed pipelines to support AI department’s LLM development using OpenAI models, LangChain, PgVector & AzureAI.● Developed, modeled, optimized database & assisted in feature development for LLM application, resulting in 50% reduced costs & 100% increase in throughput/performance.● Replaced former Analytics Pipeline with BigQuery, Azure Data Factory & BQ Transfer Jobs, improving analysis speeds by more than 1000%.● Revamped Analytics & Dashboarding using BigQuery, DBT & LookerStudio improving workflow efficiency by more than 100%.● Constructed an AI-powered document processing ETL pipeline, increasing workflow speed & efficiency allowing us to process more than 500% more documents.● Engineered ETL pipeline using GPT for document classification & labeling, reducing manual intervention, and saving 100’s of hours a week.● Established Airflow instance with Docker, orchestrating dozens of DAGS, unifying most data-related development into a single repository.● Built PostgreSQL, MySQL & Bigquery idempotent pipelines to extract & load data to/from, for downstream analysis.● Replaced Segment with self-hosted Rudderstack deployment for CDP analytics, reducing costs by 75%.● Crafted Batch ETL pipeline (GUI + code) for event-based/clickstream data using AWS services, enhancing data frequency from weekly to daily intervals.● Engineering Team Representative for ISMS ISO 27001:2022 certification, managing engineering-related ISMS documents, and ensuring compliance.● Deployed self-hosted Wireguard VPN server to comply with ISO 27001:2022 standard, resulting in 75% cost reduction compared to PaaS VPN.

● 75% reduction in database operational costs & reduced query times from hours to seconds by optimizing queries & applying strategic indexes.● 500% increased efficiency in improved data cleansing processes allowing respective departments to set higher goals.● Implemented & captured Type 2 Slowly Changing Dimensions data warehousing practices in analytics database to analyze historical data accurately.● Handled Migration of BI services on linux virtual machines, databases & data migration from MariaDB to MySQL during migration project.● Reduced Production MariaDB & MySQL server load by 60% (100% peak load > 40% peak load) which addressed web app freezing issues & saving RM 60,000 annually on DB upgrades annually.● Set up automated self-service dashboards/reports on LookerStudio which allowed us to take on multiple projects with business partners with less ad-hoc querying/reporting, saving dozens of hours a week.● Improved Analytics DB performance which sped up reporting & query operations from 2 hours down to seconds/minutes.● Established & managing data mart practices in analytics database for easier data governance, observability & troubleshooting, made up of over 50 components (stored procedures & events).● PIC for infrastructure migration project w/ business partner from AWS to Azure, handling migration of BI service on linux VM, Database & data migration from MariaDB to MySQL, management of Terraform script.● Increased reporting speeds from weekly to daily updates for clickstream data by implementing an ETL pipeline (GUI + code) using AWS services to pull data & load it into our analytics database.● Set up Database replication on AWS & automatic DB replication error logging & skipping ensuring 100% replica uptime

Dashboard Development● Worked with other departments to provide data requested● Developed internal dashboards for overall performance monitoring of other departments● These 2 sparked the idea of pulling external data sources (ads, clickstream data), to enrich current data, and to create automated dashboards in the futureAWS● Learned about the fundamentals of AWS● Learned AWS Glue, and the concept of ETL/Data Engineering, which sparked the whole idea of unifying all data sources in the futureDatabase Optimization● Was faced with slow queries and learned about indexing strategies● Started off by preparing indexes for a few slow queries, which then eventually led to the project of optimizing the whole analytics database in the future

● Managed FOH/BOH (Front/Back of House) resources (staff timetables, stocks, audit, opening/closing etc.)● Prepared, personalized & supervised team onboarding & training SOP's for junior & Senior Service Crews, Baristas & Shift Managers.● Calibrated & QC'd hand brew & espresso based beverages.● Managed over half a dozen brands & platforms for delivery services, handling well over 100's of orders per day.● Created social media content (pictures & copywriting) for company's Instagram.