TRAN DUY ANH

• Acted as Real-Time Analyst Lead, supervising live floor operations and coordinating workforce distribution across shifts. Responsible for making immediate staffing adjustments to handle absenteeism, workload spikes, and unexpected operational issues while maintaining SLA commitments.
• Designed and maintained comprehensive reporting systems covering daily, weekly, monthly, quarterly, and yearly cycles, ensuring management had reliable visibility into operational performance at all levels.
• Built standardized dashboards and monitoring templates using Excel and Lark Sheet to track KPIs, workforce productivity, and compliance in real time, enabling managers and team leaders to make timely and informed decisions.
• Developed and deployed automation solutions with Python, SQL, and Power Query, significantly reducing manual workload in reporting, scheduling, and monitoring processes.
• Conducted data analysis and performance reviews to identify operational trends, recurring bottlenecks, and improvement opportunities. Worked closely with managers to translate these insights into practical adjustments to workforce planning and reporting practices.
• Took responsibility for shift scheduling and workforce planning for over 200 staff, balancing efficiency and compliance requirements, and aligning manpower distribution with operational needs.
• Provided ad-hoc analysis and reporting support for management when specific performance, compliance, or efficiency concerns needed urgent investigation.

Core Tools: Excel (advanced), Lark Sheet, SQL Server, Python, Power Query

• Processed, classified, and structured large datasets for regular reporting cycles (daily, weekly, monthly).
• Collected and transformed customer-requested datasets, ensuring accuracy and readiness for business use.
• Designed automatic filters and workflows in Excel to improve data cleaning and processing efficiency.
• Generated aggregate reports and quick insights from large-scale data to support client requirements.

• Conducted telesales activities including data tracking, lead generation, consulting, and closing.
• Produced weekly sales and customer reports to monitor pipeline development.

• Managed the full cycle of customer interactions including telesales, client consultation, deal closing, after-sales support, and customer surveys.
• Tracked customer orders and maintained relationships to ensure service quality.
• Prepared weekly reports on sales and customer trends, supporting management in evaluating commercial performance.