Learn Data Skills
Beta
Tuan Anh Do

Tuan Anh Do

Senior Data Analyst

SmartOSC | Vietnam

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

Algorithm aficionado, dancing with equations in the realm of possibilities.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Bamboo Airways | Jul 2022 - May 2023

Assistant To Chief Executive Officer

• Together with CCO and CIO, overseeing the entire implementation process of the passenger service system transition to Amadeus Altea, along with other projects in the company. Collaborating with project managers and IT managers to push deadlines, troubleshoot, and resolve issues. Reporting directly to the CEO. • Assistant to CEO, performing assistantship work and overseeing the operation of all departments in the company, mostly task management and advising/giving recommendations and insights to the CEO to assist daily operation activities, enhancing departments' work performance & efficiency.
Show More

Bamboo Airways | Feb 2022 - Present

Senior Specialist - E-Commerce Department

• In charge of online ancillary team, responsible for ancillaries products design and launching for online channels (Web/Mobile App). • Utilize PowerBI and Python to create dashboards, enabling comprehensive monitoring of spending and key performance indicators (KPIs) for the entire Division. Identify cost optimization and revenue enhancement opportunities through data-driven insights. Collaborate with cross-functional teams to gather financial data and provide accurate reports for informed decision-making. Forecast spending trends, resolve discrepancies, and communicate findings to senior management for strategic resource allocation. • Harnessing Python to create automation jobs (data retrieval, ETL process, rendering online dashboard for website performance monitoring) and adhoc data analysis

One Mount | Aug 2021 - Feb 2022

Supplier Development Specialist

• Conducted FMCG market research, focusing on category and subcategory trends, and identifying potential suppliers. Initiated supplier outreach, leading negotiations for trade terms and pricing agreements. • Leveraged advanced data analysis techniques and tools, including BigQuery and Looker Studio, to conduct in-depth supplier and market analysis, providing critical insights for strategic decision-making. Collaborate cross-department in the preparation of sales forecasts and P&L reports, offering recommendations for sourcing new products to optimize the product portfolio. • Managed supplier accounts, including on boarding and ongoing maintenance, utilizing Salesforce to streamline processes and enhance supplier relationships. • Coordinated closely with the product team to facilitate the successful launch of new products on the Vinshop application, ensuring seamless integration and customer satisfaction.

Bamboo Airways | Jul 2020 - Jul 2021

Route Development Analyst

N/A

Bamboo Airways | Jul 2020 - Mar 2021

Secretary to Executive Deputy General Director

• Reviewed proposal documents of Commercial Department to the DCEO, acted as a liaison between the DCEO and the directors of Commerce Department to discuss planning, sales and technological topics/issues. • Conduct weekly, monthly reports, project reports, research papers, clients and upper management presentation materials per DCEO’s requests. • Exchanged communication with clients and Bamboo Airways’ Commercial Department as well as other departments directly or via email/phone on behalf of the DCEO. • Tracked all on-going projects of Commercial Department and report to DCEO on a daily basis. • Accompanied the DCEO in business meetings with clients, partners and authorities.

Bamboo Airways | Jan 2019 - Jul 2020

Executive - Frequent Flyer Program

Frequent Flyer Database and Points Calculator Engine Project: ● In collaboration with the IT team, I developed an Oracle database designed to store passenger and sales data. My responsibilities included creating an efficient data model for the Oracle database to optimize data organization and relationships, data cleaning, creating SQL queries and procedures for automated data merging and querying, with a specific focus on frequent flyers' information. ● This database was seamlessly integrated with PowerBI to craft a dynamic dashboard for monitoring and analyzing frequent flyers' travel patterns. ● Additionally, I designed a rules engine using Access to accurately calculate frequent flier points, streamlining the reward system for our valued customers. Loyalty System Implementation: ● Worked as the product and project manager for the loyalty system implementation program. ● Built requests for proposal documents and technical requirements, met and discussed with vendors, performed evaluation and vendor selection, contract negotiation, and was in charge of the entire implementation process. ● Product Maintenance and Upgrading in Post Cutover phase.

United Capital Management | Nov 2017 - Dec 2018

Investment Analyst

● Collected and processed stock market data through various data sources (data files, APIs, etc.), integrating data sources into AmiBroker tool to analyze and enhance data-driven decision-making processes. ● Conducted analysis of market trends, industry statistics, and company- specific data to derive insights and inform strategic decision-making. ● Leveraged statistical methods to forecast key financial metrics, including revenue, cash flow, and profitability, prepared detailed feasibility studies for investment fund-raising proposals. ● Engaged in the end-to-end process of data acquisition, cleansing, analysis, and visualization to support informed business initiatives, including projects such as the Real Estate Investment Trust (REIT) fund and Peer-to-Peer (P2P) lending platforms. ● Facilitated effective cross-border communication as a bilingual interpreter, bridging the gap between international clients and the CEO, thus contributing to successful client relationships and negotiations.

Bank of America | Mar 2017 - Aug 2017

Relationship Manager

• Prepared credit and sales reports for senior management • Established and maintained long term relationships with customers. • Cross sold bank's products including personal loans, overdrafts and fixed deposits. • Analyzed customer credit data and other related financial information in a timely manner.

Nordstrom | Oct 2016 - Mar 2017

Client Services Representative

N/A

My Education

Take a look at my formal education

Bachelor’s Degree, Business Administration and Management, major in FinanceAlbers School of Business and Economics at Seattle University | 2016
Associate's degree, Business Administration and Management, GeneralShoreline Community College | 2014
High School Foreign Language Specialized School - Hanoi, Vietnam | 2012

About Me

Tuan Anh Do

I am learning to become a Data Scientist. I want to pursue the OMSA program of GTx and I have so much to learn please help me god

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free