Cat Bot(Slack Bot with Python)

• Developed a monitoring system to track the number of eligible products for a specific campaign and notify users through Slack when the product count falls below a certain threshold.
• Provided daily scheduled synchronization of production database tables required by the product importer to the development database, improving team efficiency and saving time that would otherwise be spent on individual database management.
• Integrate a self-built FTP server using vsftpd on Linux, allowing users to create FTP accounts through dialogue, and integrate with Bridgewell DSP. The system periodically checks for account creation requests and creates the corresponding user accounts.
• Improved the existing Bridgewell pixel monitoring mechanism to easily detect invalid user behaviors.

GTM Watcher

A React-based application that parses specific GTM source code and presents a user-friendly static webpage that displays the relationships between tags, triggers, and variables. This was an effective solution for debugging when customers did not authorize GTM access.

Bridgewell Pixel GTM Custom Template

Created custom templates in GTM to facilitate the installation of the Bridgewell pixel for colleagues, enabling them to install it more conveniently and quickly.

GTM Commit Helper

Developed a Chrome extension that integrated with Flask and GitLab to achieve better version control in GTM and improve the efficiency of reviews among colleagues.

Category Control Panel

Developed a web service using Flask and Jinja to manage a database, allowing users to bundle specific products into restricted categories for advertisement restrictions.

Cat.js

Developed a frontend utility library using TypeScript to simplify the code duplication process for colleagues working in GTM and improve work efficiency.

Bridgewell Pixel

• Installed Bridgewell pixel, Google Ads/GA tags, and other tracking tags on clients' websites using GTM.
• Assisted clients in troubleshooting various self-installed Bridgewell Pixel errors.
• Modified frontend and backend code to improve the accuracy of using beacon.

Product Importer(C#)

• Integrating the product feed provided by the client into Bridgewell DSP.
• Introduce CsvHelper to replace an inaccurate CSV file processing method.
• In a situation where the client was unable to provide a product feed, dynamically updated product information was obtained by crawling the client's webpage.
• Retrieve products for a specific advertiser through the integration of Google Merchant Center API and pass them through to Bridgewell DSP.
• Supporting various customization requirements for client's products.

Product Exporter(C#)

Repackage the products of Bridgewell DSP's advertisers into the format required by third-party media (e.g. Meta, Google, Yahoo, Line) and upload the product feed to the platform via API.

Data Analysis

Access various logs stored in HDFS using PySpark for analysis and debugging purposes.