LUAN NGUYEN
Anaheim,CA
Summary
Results-driven Data Analyst/Automation Developer with over 5 years of experience designing data workflows, working with APIs, and implementing automation systems to enhance operational efficiency. Strong background in software engineering, specializing in SQL, Python, Power Automate, Alteryx, and KNIME. Demonstrated ability to deliver scalable solutions, utilize AI tools effectively, and drive business intelligence initiatives for sales and operations.
Overview
5
5
years of professional experience
3
3
Certification
Work History
Senior Business Analyst / IT Support Specialist
Rand Technology
11.2020 - Current
- Built and maintained data workflows using Alteryx, KNIME, and SQL to automate reporting and support sales strategy.
- Developed advanced automation systems with Power Automate for email parsing, shipment tracking, and credit management.
- Created custom API data miners (Digikey, Mouser) with token refresh and dynamic input.
- Maintained enterprise reports using Power Query + SQL Server, improving report generation speed by 40%.
- Designed internal chatbot using Copilot Studio integrated with custom GPT workflows.
- Led database maintenance projects (Oracle, SQL Server), ensuring accuracy for sales forecasting.
- Addressed employee IT concerns to prevent business disruptions.
IT Support & Broadcast Systems Technician
Saigon TV / Global TV
10.2013 - 04.2020
- Maintained 24/7 broadcasting network and ensured system uptime.
- Built custom high-end PCs for video production and studio needs.
- Supported hardware/software infrastructure for media workflows.
IT Support / Web Admin (Part-time)
Trilogistic Inc.
10.2009 - 12.2013
- Provided remote and onsite IT support including network optimization and hardware upgrades.
- Built and maintained company website and internal tools for logistics operations.
Education
B.S. - Computer Science, Software Engineering
California State University
Fullerton05.2021
Skills
- Programming Language: Python, C, Java, VBA
- Database skill: Microsoft SQL, Oracle SQL
- Analytic Softwares: Alteryx, Knime
- Business Intelligence: Power BI
- Microsoft Dynamic: Power Automate, Power Apps
- AI: Microsoft Copilot, Customization ChatGPT, AI Agent N8N
- API
- JavaScript
- HTML/CSS, JSON
- Microsoft Office
- Data mining
Certification
- Microsoft Power Platform Fundamentals 11/2023
- Google Data Analytics Professional Certificate 09/2022
- CompTIA A+ Certification Core 1, 220-1001 06/2020
Project Highlights
- Dynamic Excel Filters: Used Power Query to enable advanced multi-value database filtering.
- Custom GPT Chatbot: Designed and deployed internal support bot for business FAQs.
- Company Screening Notification: KNIME workflow scraping the daily updated screening list of companies and contries from government website, then notify the team if there are matching customers to the list. This keeps all the buy/sell secured and safe
- Weekly Customer Health Report: Automated insights on customer engagement and revenue tracking using power BI
Accomplishments
- Built a huge library for computer's component (CPU, Memory, GPU, SSD) with useful information which helped company to win a deal of millions dollar over other competitor.
- Built a semiautomatic POD (proof of delivery) downloading system which helped accounting department can collect money on time from customers
Languages
Vietnamese
Native or Bilingual
English
Native or Bilingual
Timeline
Senior Business Analyst / IT Support Specialist
Rand Technology
11.2020 - Current
IT Support & Broadcast Systems Technician
Saigon TV / Global TV
10.2013 - 04.2020
IT Support / Web Admin (Part-time)
Trilogistic Inc.
10.2009 - 12.2013
B.S. - Computer Science, Software Engineering
California State University
Similar Profiles
LUAN NGUYENLUAN NGUYEN
Senior Business Analyst / Automation Developer at Rand TechnologySenior Business Analyst / Automation Developer at Rand Technology
Pranjal RoyPranjal Roy
Precision Fastening Business Area Specialist at Ingersoll Rand Technology And Services Pvt. LtdPrecision Fastening Business Area Specialist at Ingersoll Rand Technology And Services Pvt. Ltd
Priscilla Ntombifuthi MnguniPriscilla Ntombifuthi Mnguni
Funeral Arranger /Assistant Manager at Rand Funerals \ Rand Financial Services InsuranceFuneral Arranger /Assistant Manager at Rand Funerals \ Rand Financial Services Insurance
Ricardo PinedaRicardo Pineda
Process Assistant/Delivery Driver Trainer at Amazon LogisticsProcess Assistant/Delivery Driver Trainer at Amazon Logistics
Teresa CoronaTeresa Corona
Banquet Server at Anaheim Convention CenterBanquet Server at Anaheim Convention Center