Ha Van Do Email & Phone Number

Fort Worth, TX, US

Fort Worth, Texas, United States

Fort Worth, Texas, United States

Dallas, Texas, United States

• Developed and optimized machine learning algorithms (XGBoost Regression and Time-Series) to forecast transfer bag volumes across 162+ airport stations, providing 30% more accurate solutions for the Assets Management team
• Deployed statistical models (Linear Regression) into 4 Revenue and Sale Tableau dashboards using Python scripts and Tableau Analytics Extensions API, enhancing real-time predictive accuracy up to 15% for better.
• Built multiple interactive dashboards with a data warehouse of 600+ million rows and automated daily real-time updates utilizing Teradata SQL, Alteryx Server, and Tableau Server, enabling timely insights on flight turn.
• Designed and implemented ETL pipelines to save 40 hours of manual processing time in ingesting 5 million records of airport asset data weekly from external CSV files to Data Lake using Airflow and Alteryx
• Performed Gap Analysis by integrating the data from the external REST APIs in JSON format using Python and Alteryx, saving 100 hours of manual data validation and ensuring the data quality

Fort Worth, Texas, United States

• Performed the Price Study to identify and implement cost-reduction initiatives by analyzing the inventory database using SQL and VBA, reducing order mismatches by 40% and saving $800,000 in annual losses
• Collaborated with the Supply Chain Department to optimize the data lake infrastructure to accommodate a 20% increase in data volume from the newly integrated SAP system, ensuring real-time analytics with minimal lag
• Conducted thorough testing and validation for the new SAP integrated system using SQL and Python scripts, ensuring the seamless data transfer between the SAP system and the data warehouse for advanced analytics
• Created a dashboard using Power BI to track inventory orders to provide real-time visibility into budget utilization and inventory management, contributing to the cost saving of $3 million
• Led a team of 4 interns in documenting global order processes using Excel Pivot Table and Visio, developing distribution strategies for 4 production plants to improve vendor management and reduce waste time by 30%

Hanoi Capital Region

• Automated scraping and ETL process over 30,000 rows of data from five real estate websites using Python(BeautifulSoup) and Excel VBA, increasing data entry productivity and accuracy by 80%
• Developed 8 interactive dashboards using Power BI for Investment Departments to provide Comparative Studies over10,000+ AUM in the commercial real estate sector, supporting the Manager make better investment decisions
• Initiated Power BI applications in the Financial Planning team, creating real-time Revenue Mix analysis,reducing reporting time by 30%, and supporting Senior Directors managing a portfolio of 60 SKUs
• Conducted in-depth market analysis on office and apartment real estate sectors by evaluating CPI, mortgage rates, andmacroeconomic data, providing strategic insights to the investment team and stakeholders