LUAN NGUYEN
Senior Business Analyst
Anaheim,CA
Summary
Results-driven Data Analyst/Automation Developer with over 5 years of experience designing data workflows, building 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
16
16
years of professional experience
3
3
years of post-secondary education
3
3
Certifications
Work History
Senior Business Analyst / Automation Developer
Rand Technology
Irvine, California
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.
IT Support & Broadcast Systems Technician
Saigon TV / Global TV
Westminster, CA
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.
Westminster, CA
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
Fullerton 01.2018 - 01.2021
Skills
- Python
- SQL
- Java
- C
- JavaScript
- HTML/CSS
- VBA
- Alteryx
- KNIME
- Power BI
- Excel (advanced)
- Power Query
- Power Automate
- n8n
- Copilot Studio
- ChatGPT Customization
- REST APIs
- Mouser & Digikey APIs
- JSON handling
- SQL Server
- Oracle
- Embedded DBs
- Git/GitHub
- Documentation
- Debugging
- UI Scripting
- Problem solving
- process optimization
- cross-functional collaboration
- Adobe Premiere
- Photoshop (basic marketing/media assets)
- Creative scripting
- UI design
- workflow documentation
- Fast learner
- high adaptability to new technologies and platforms
Certification
Microsoft Power Platform Fundamentals
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.
- Automated Email + PDF Extraction: Created Power Automate flow to capture shipment-related emails and auto-download PODs.
- News Mining Workflow: KNIME workflow scraping headlines by keyword into Excel for sales research.
- Weekly Customer Health Report: Automated insights on customer engagement and revenue tracking.
Optional Other Skills
- Video editing: Adobe Premiere, Photoshop (basic marketing/media assets)
- Creative scripting, UI design, and workflow documentation
- Fast learner with high adaptability to new technologies and platforms
Core Skills
Python, SQL, Java, C++, JavaScript, HTML/CSS, VBA, Alteryx, KNIME, Power BI, Excel (advanced), Power Query, Power Automate, n8n, Copilot Studio, ChatGPT Customization, REST APIs, Mouser & Digikey APIs, JSON handling, SQL Server, Oracle, Embedded DBs, Git/GitHub, Documentation, Debugging, UI Scripting, Problem solving, process optimization, cross-functional collaboration
Timeline
Microsoft Power Platform Fundamentals
11-2023
Google Data Analytics Professional Certificate
09-2022
Senior Business Analyst / Automation Developer
Rand Technology
11.2020 - Current
CompTIA A+ Certification Core 1, 220-1001
06-2020
B.S. - Computer Science, Software Engineering
California State University
01.2018 - 01.2021
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
Similar Profiles
LUAN NGUYENLUAN NGUYEN
Senior Business Analyst / IT Support Specialist at Rand TechnologySenior Business Analyst / IT Support Specialist 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