Emmett Quan - SENIOR DATABASE ADMINISTRATOR

Emmett Quan

4.9

Select me!

Emmett is available for hire

Hire Now

Emmett Quan

4.9

Gender

Male

Address

Ward, District 7

Main expertise

Database Administrators SQL Python Power BI PostgreSQL MongoDB AWS RDS Azure Big Data Architects Business Intelligence ETL Elasticsearch

Introduction

Emmett Quan has nearly 20 years of experience in the IT industry, having held roles such as Data Manager, Business Intelligence Manager, and DBA. He seeks to leverage his skills and knowledge to contribute to your company as a Data Manager.

Project list

Database Migration from AWS to GCP

Handled the migration of databases from AWS to Google Cloud Platform, focusing on optimizing database performance and ensuring data integrity throughout the transition.

Manage AWS RDS PostgreSQL Database Manage SQL Server Manage MongoDB Build Data Warehouse Build Reports: Customers, Orders, Inventory, Delivery

Technologies: AWS RDS, Postgres, MongoDB, GCP

AlwaysOn SQL Server 2016 Implementation

Worked on a significant implementation of SQL Server 2016 with a focus on high availability and disaster recovery.

Design, build, and operate core database cluster. Design database setup for high availability and disaster recovery site. Develop T-SQL components such as stored procedures, views, and functions. Performance tuning and database optimization. Implement data pipeline for data warehouse which includes data replication, ETL processes.

Technologies: SQL Server 2016

Business Intelligence System

Confidential

Build a decision support system for 15 million users. Sales & Revenue analysis. Content Inventory management. Behavioral analysis. Customer Journey mapping. RFM (Recency, Frequency, Monetary) analysis.

Technologies: Python, SQL Server, PostgreSQL, Power BI

Unified Metadata Management

This project involved merging and organizing metadata to improve consistency and accessibility across systems.

Unify metadata

Technologies: MongoDB, SQL Server

Real-Time User Recommendation System

Developed a recommendation system for FPT Play to enhance user experience and engagement.

Build the user recommendation system for FPT Play. Collaborate with data scientists to integrate machine learning algorithms. Optimize system performance to provide real-time recommendations. Ensure the system's scalability and reliability.

Technologies: Hadoop, Kafka, Spark, Casandra DB, MongoDB

Content Search Feature for FPT Play

Developed a search engine to enhance content accessibility and user experience on the FPT Play platform.

Build feature to search content for FPT Play

Technologies: ElasticSearch, Python

Firmware Development for Sigma Box IPTV

Responsible for leading a team in the backend development, alongside building APIs, databases, and systems for the project.

Lead the backend team Build API Develop Database Design System

Technologies: Flash, C#, Python, SQL Server, MongoDB, Elastic Search, Redis

OneTV Application for Smart TVs

An application developed for Smart TVs, specifically for Samsung and Sony, focused on delivering seamless integration and optimal viewing experience.

Build the OneTV application for Samsung Smart TVs. Develop compatibility and features for Sony Smart TVs. Ensure application performance and user experience across different platforms.

Technologies: HTML5, JS, SQL Server

OneTV Comtrend HD Box Portal

Developed a project related to IPTV services, ensuring efficient and high-quality content delivery.

Build portal IPTV Service

Technologies: ASP, JavaScript, SQL Server

OneTV SD Box Portal

This project involved the creation and management of a secure and high-performance IPTV service portal.

Build portal IPTV Service

Technologies: ASP, JavaScript, SQL Server

Content Management System for FPT IPTV

Developed a custom Content Management System for an interactive television platform.

Build the Content Management System Designed and implemented system features Collaborated with team members for integration Ensured system functionality and quality

Technologies: ASP, ASP.NET, SQL Server

Project list

Education

Expertise

Certifications