Manh Toan Doan
Data Engineer at Joon Solutions- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Data Engineer with Python
DataCampSep, 2021- Oct, 2024 -
SnowPro Core Certification
SnowflakeMar, 2023- Oct, 2024 -
HashiCorp Certified: Terraform Associate (002)
HashiCorpJan, 2023- Oct, 2024 -
AWS Certified Solutions Architect – Associate
Amazon Web Services (AWS)Dec, 2021- Oct, 2024 -
dbt Developer
dbt LabsDec, 2022- Oct, 2024 -
Professional Data Engineer
GoogleAug, 2022- Oct, 2024 -
Microsoft Certified: Azure Data Engineer Associate
MicrosoftMay, 2021- Oct, 2024 -
Microsoft Certified: Data Analyst Associate
MicrosoftMar, 2021- Oct, 2024
Experience
-
Joon Solutions
-
Canada
-
Business Consulting and Services
-
1 - 100 Employee
-
Data Engineer
-
Apr 2022 - Present
-
-
-
Synodus
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Engineer
-
Oct 2020 - Mar 2022
- ETL data from API into AWS RDS database + Get data into AWS S3 from various API: Google Ads API, Facebook Marketing API, Quickbooks API, Shopify API, Xero API ... using Python script + Use AWS Glue to incrementally load data from S3 into AWS RDS database - Manage SQL database + Optimize table performance with indexes and partitions, tune queries + Build Stored Procedures and setup daily jobs to ETL and clean staging tables - Setup alerts for failed jobs + Build Stored Procedure to store job errors + Combine AWS SNS and database data to send alerts about failed jobs - Develop reports with Power BI: + Connect, transform and visualize data from various datasources (SQL Server, Web Scraping, API, MongoDB, Flat File) + Deploy reports, setup Row Level Security, Incremental Refresh, schedule refresh + Optimize Power BI reports loading speed
-
-
-
Citigo
-
1 - 100 Employee
-
Business Analyst
-
Sep 2019 - Oct 2020
- Connect to Google BigQuery, transform data and visualize software usage with Power BI - Collect User Requirements from customers and team members, then summarize into User Stories/Business Requirement Specification - Draw Business Process and Activitity Diagram to illustrate business flow - Design wireframe, mockup, prototype - Write Software Requirement Specification - Connect to Google BigQuery, transform data and visualize software usage with Power BI - Collect User Requirements from customers and team members, then summarize into User Stories/Business Requirement Specification - Draw Business Process and Activitity Diagram to illustrate business flow - Design wireframe, mockup, prototype - Write Software Requirement Specification
-
-
-
Tek Experts
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Subject Matter Expert
-
Oct 2018 - Aug 2019
- Analyze good/bad performance trends and offer training accordingly- Draw up case handling process diagram and handling manual for advocates using Visio- Review cases in Quality Assurance forms to ensure quality is met- Act as technical consultant on Xbox-related technical issues- Deal with demanding customers as supervisor
-
-
Xbox Support Advocate / Service Request Analyst
-
Jun 2018 - Sep 2018
- Explore customer's request and elicit actual needs- Researched and provided effective technical solutions while politely dealing with emotional customers- Reviewed cases and gave out advisory feedback for team improvements- Summarized emerging trends, to-do list and reported to team daily
-
-
Education
-
Foreign Trade University
Bachelor's degree, Economics and International Business