Trong Ngo

Data Analyst with 4+ years of experience building reports and analytics for business, finance, and operations teams, backed by a prior background in IT infrastructure and systems administration. Core strength in automating data processing and reporting pipelines (data pipeline automation, report automation) using Python, SQL, VBA, and Power BI, reducing manual processing time by 60-80%. Experienced in building automation bots, self-updating dashboards, and API integrations between systems.

Seeking a Data Analyst role to apply programming and analytical skills to optimize operations and support data-driven decision-making.

Data Analyst | Risesun Vietnam (Textile Manufacturing) 06/2025 - 06/2026

● Built and operated an automated daily reporting system using Python, VBA, and Power BI, reducing report consolidation time from 3 hours to 15 minutes per day.

● Designed automated ETL pipelines extracting data from multiple sources (PostgreSQL, MySQL, API) and loading it into the internal Data Warehouse on a scheduled basis.

● Developed Power BI dashboards with scheduled refresh to support the Sales & Merchandising team in tracking revenue, orders, and business KPIs in real time.

● Extracted, consolidated, and standardized data from the internal ERP system to support ad-hoc analysis for business units.

Data Analyst | ATMO Vietnam (Financial Services) 05/2019 - 03/2025

● Analyzed business data and built periodic KPI reports for multiple departments using advanced Excel and SQL.

● Automated weekly/monthly report consolidation using VBA and Python, replacing a manual process that took 5 hours per week.

● Built self-calculating Excel report templates adopted company-wide across departments.

● Performed data cleaning and standardization for analytics projects, maintaining input data accuracy above 98%.

● Partnered with Finance and HR to calculate monthly performance-based bonuses using operational data.

● Maintained and updated recurring reports including Disbursement & Repayment, IL-Start Converted, Mapping Repayment, Collection Performance, and Call Center Performance.

IT Specialist | TMI Vietnam (Garment Manufacturing) 10/2015 - 02/2019

● Installed, configured, and administered SQL Server database systems; designed and optimized SQL queries to support department reporting.

● Configured and managed network infrastructure: Cisco switches, multilayer switches, routers, firewalls, modems, and access points.

● Administered network infrastructure and security: Fortigate firewall, VPN, Active Directory, DNS, DHCP, file servers, and email servers.

● Established information security policies aligned with ISO 27001, supporting audit requirements from international clients including Adidas, Nike, Puma, and Hugo Boss.

Bachelor in Bachelor of Applied Information Technology – Ha Noi Open University (2015-05)

College in Diploma of Network Engineer – The Academic of NIIT (2011-04)