Yi Xuan K. Email & Phone Number

Over the past two years, my primary focus has been on extracting, transforming, and loading (ETL) customer bills from AWS or GCP.As a prominent agent for both GCP and AWS, responsibilities include billing customers on their behalf.Main areas of concentration:Development of the backend system using Python and FastAPI.Utilization of Cloud SQL for data storage with a focus on designing optimal schemas and selecting suitable indices to enhance SQL query efficiency.Emphasis on reducing code time and space complexity for performance optimization.Deployment of services on GCP Cloud Run and GKE, leading to a deep understanding of mechanisms and effective design of service structures, including networking, volumes, and CPU/memory settings.Leveraging BigQuery for storing raw customer bill data, enabling effective grouping and searching at a large scale.Implementation of the MapReduce concept to parallelize the parsing of substantial datasets, utilizing DataFlow as the supporting tool.Adherence to clean architecture principles and writing maintainable code.Conducting stress tests and unit tests to ensure fault tolerance.I have implemented GCP Cloud Task and queue to handle data counting in parallel, which has significantly saved us a considerable amount of time

1. ADACThis is a service which provides automated records and notification of financial stock statement Use Gmail API to retrieve and organize stock financial analysis reports from client’s gmail and write them into the PostgreSQL database each dayUse Celery beat to process the above periodic tasks and put them into queue for asynchronous consumption by workers, and use Redis as a BrokerConnect Google Sheet API to write back the financial stock information from the database to google sheetSet PostgreSQL Streaming Replication (master and standby model) on two EC2 machines separately to handle database synchronization2.CIWEBThis website presents the company's official announcements and activities and allow staffs to add, edit and publish the company's recent activities and announcementsAllow users to upload and save their image files to S3 through database by using Boto3 and view image file by its presigned url3.BTOXThis service provides employee account system, contact lens fit, shopping cart, andorder sales service of glasses and peripheral goodsApply hierarchical database schema, self reference model, and many to many field to suite the requirements of providing company and dealer identity and access management systemUse Python Matplotlib and Pandas to analyze the data generated by medical equipment and transform the data to eyeball 3D graph, conduct process described above by AWS LambdaUse AWS ECS Fargate to deploy the whole project, use Task Definition to define nginx and django-server container and connect to AWS RDS PostgreSQLDefine the VPC, subnets, and security groups of this service to allow connections between each servicesUse uWSGI as a container to wrap django serverUse docker-compose to package nginx and django-server container, and deploy to ECS Fargate during Gitlab CI/CD processUse AWS Elastic Load Balancer before ECS Fargate to separate flow

1. I designed front-end web pages of game entertainment by React and Angular.2. Users placed their bets of horse and dog racing online, these bet contents weresent to Backend to calculate win/lose results.3. I used array methods, such as ForEach and Map, to organize the instant gamedata transmitted by Websocket into win/lose reports to display on the web.4. I used Angular Http Service as an API tool to communicate with Backend.5. I used Angular Routing Module to separate the entertainment component intoseveral smaller modules and connected them by routing.6. I used CSS3/SCSS to do the RWD page and UI designs.