Renee Ta - Senior Developer

Renee Ta

Select me!

Renee is available for hire

Hire Now

Renee Ta

Age

Gender

Female

Address

Ha Noi, Vietnam

Main expertise

Full-stack Back-end Front-end AWS Amazon S3 Vue.js Node.js PostgreSQL Scala Google Cloud TypeScript React.js

Introduction

Renee Ta has over 6 years of experience in web development, working as a Full-Stack Web Developer. Additionally, Renee has successfully led a team of 4 members, demonstrating strong leadership and technical skills.

Project list

Reach Report Project

Automated the daily submission of AWS Batch jobs to stream reach reports from thousands of campaigns across five media Ad APIs. Once processed, the campaign reports are uploaded to Google Cloud Storage and subsequently to Big Query for data analysis.

Stream data from two media APIs using Akka Stream. Control the number of requests per second to handle API rate limits using the throttle flow of Akka Stream. Upload campaign reports to Google Cloud Storage and subsequently to Big Query. Write and maintain specification documents.

Technologies: Scala, Akka Stream, Amazon Batch, Amazon EventBridge Scheduler, Google Cloud Storage, Big Query

Advanced Reporting System

The project involves storing and managing accounts, resources, and fields related to six different media Ads APIs. These resources and fields may change with API updates. The system defines settings, including accounts, resources, and fields, and transfers these settings to another system for file downloading, conversion, and uploading to Amazon S3. Additionally, the solution synchronizes media accounts to the database daily and submits jobs every 30 minutes.

- Implement Username/Password authentication with session management, utilizing BCrypt for hashing and verifying passwords. - Grant permissions for three roles: System User, Organization Owner, and Admin, using ActionFilter. - Paginate and list all report settings based on database limits and offsets. - Display report settings that match user-defined search criteria, such as run status, run result, media, reporter, account, and name, with a debounce feature for user input in search text boxes. - Maintain search criteria when navigating away from and returning to the page, using URL Search Params. - Develop media and account selection features with debounce typeahead search in the report setting creation/editing screen.

Technologies: Scala, Play Framework, Skinny-ORM, Akka Actor, Akka Quartz Scheduler, HTML, Bootstrap 5, Vue 3, Typescript, Bootstrap Studio, PostgreSQL, Amazon EC2

Media API Version Update

Identify and document changes in resources, fields, and enums when the Media API is upgraded to a new version.

Call Google APIs to retrieve resource fields from both the old and new versions. Compare the responses of the two versions to identify added and removed resources, fields, and enums. Document changes, such as added resources, fields, and enums, as well as removed resources, fields, and enums. Write updated resources and enums to corresponding files using a predefined format. Organize the changes by resource and document them for easy reference.

Technologies: Typescript, Node.js

Kyotsu Core Project

This project involves submitting AWS Batch jobs to stream report files from multiple accounts across 15 media Ads APIs for 10 customers. These files are processed by converting them into CSV, JSON, or aggregated formats, and are then uploaded to Google Cloud Storage (GCS) and BigQuery. The project also includes syncing account information from Google Spreadsheets, Treasure Data, other databases, and media APIs. Additionally, it manages job states and notifies about any failed jobs.

Set up media API query parameters to retrieve Ads data that is uploaded to GCS. Define schema definitions to load data from GCS to BigQuery. Write SQL scripts to create tables in BigQuery.

Technologies: Scala, Akka Stream, Javascript, Node.js, Amazon Batch, Amazon EventBridge Scheduler, Amazon Lambda, Amazon EC2, MySQL 8, Google Cloud Storage, Amazon S3, Big Query

Onestar Support Tool

Developed a web application enabling users to download Excel files containing Ads reports from Facebook accounts.

Integrate Google Sign-In functionality. Download Ads report Excel files of authorized Facebook accounts via OAuth 2.0. Notify Slack users via email if access token generation or report downloads fail. Ensure software quality through code reviews.

Technologies: Scala, Play framework, HTML, Bootstrap 5, React JS, Amazon EC2

Automated Report Uploader

This project involves extracting columns from various input file formats (CSV, TSV, XLSX) according to configuration specified in a Google spreadsheet. The processed files are then uploaded to Amazon S3 and Box for storage.

Get settings from Google spreadsheet using Google API client libraries. Create output files that contain configured columns. Upload the processed files to Amazon S3. Transfer files to Box for storage.

Technologies: Scala, Play framework, Skinny-ORM, HTML, Material UI, Vue 2, MySQL 5, Amazon EC2

Third Party Web Request Form

Developed a website to assist users in defining configurations that enable operators and the scraping system to download advertising data of promotions from third-party tracking tools. Additionally, the site allows defining settings for ETL (Extract, Transform, Load) processes on the downloaded data.

Display report requests of multiple promotions. Users can search report requests by promotion names. Implement forms allowing users to create a download request list for a promotion. Each download request can be edited or deleted inline, with alerts for deleting previous requests or sole entries. Create configurable selects to set fields for ETL requests. On the screen showing downloaders' tasks, alert the number of incomplete and complete tasks when the user clicks the 'Today's work done' button. Notify Slack if all tasks are completed.

Technologies: Scala, Play framework, Skinny-ORM, HTML, Material UI, React JS, Redux, MySQL 5, Amazon EC2, Amazon Relational Databases

Project list

Education

Expertise