Summary
Overview
Work History
Education
Skills
Timeline
Generic

Kelvin Nguyen

Marietta,GA

Summary

Dynamic data analyst with a proven track record at MaxAir Mechanical, skilled in PowerApps and Power BI reporting. Successfully developed custom applications and optimized workflows, enhancing operational efficiency. Strong problem-solving abilities complemented by effective communication skills, driving impactful solutions across IT and data management initiatives.

Overview

2
2
years of professional experience

Work History

JR Data Analyst

MaxAir Mechanical
01.2025 - Current
  • Developed custom Power Apps Canvas applications integrated with SharePoint, Excel, and Office 365 connectors to manage asset checkouts, employee offboarding, and email group permissions.
  • Built and optimized Power Automate flows to handle conditional approvals, Office 365 group management (add/remove members), and structured data submissions from Power Apps using dynamic JSON payloads.
  • Created role-based access controls within Power Apps using user-specific filters, enabling personalized views and actions across departments.
  • Integrated Excel-based ERP exports into PowerApps for editable customer records, using patch logic to sync updates back to both Excel and SharePoint.
  • Designed and deployed SharePoint-backed tracking systems with automatic patching of history logs for equipment assignments, condition updates, and department transfers.
  • Constructed interactive Power BI dashboards using SharePoint and Excel data to visualize task progress, employee visits, and key business metrics, leveraging DAX for dynamic calculations.
  • Implemented scheduled email reports via Power Automate with dynamic content such as last Monday’s date, task completion percentages, and filtering for overdue assignments.
  • Troubleshot and resolved delegation issues and performance limitations in Power Apps when handling large datasets, ensuring smooth user experience and reliable data output.

JR Systems Administrator

MaxAir Mechanical
05.2024 - 01.2025
  • Managed and resolved over 800+ IT service tickets, ensuring minimal downtime and efficient operations across multiple branches.
    Introduced and implemented Apple Business Manager and Mosyle, a Mobile Device Management (MDM) software, to streamline device deployment and enhance security.
  • Maintained and monitored network security protocols, including firewalls, VPNs, and intrusion prevention systems, safeguarding company data and ensuring compliance with industry standards.
  • Configured and managed Active Directory (AD), including user account creation, group policies (GPOs), and permissions to optimize access control and streamline IT processes.
  • Played a role in the onboarding of new branches, by setting up IT infrastructure, configuring networks, and ensuring seamless connectivity.
  • Assisted with the implementation of new technology in the expansion building, enhancing operational capabilities and preparing for future growth.
  • Provided support for the main Marietta branch, as well as the Newnan and Duluth branches, ensuring consistent IT operations across all locations.
  • Trained and mentored two IT interns, guiding their development and contributing to team scalability.
  • Conducted regular system updates, patching, and backups, ensuring business continuity and system reliability.

IT Intern

MaxAir Mechanical
06.2023 - 05.2024
  • Successfully resolved 500+ IT support tickets, including hardware, software, and network troubleshooting, ensuring minimal downtime and seamless operations.
  • Initiated and supported the transition process from Verizon to Granite Telecommunications, including planning, vendor coordination, and infrastructure adjustments to optimize communication systems.
  • Provided technical support for system upgrades, software installations, and employee onboarding, enhancing overall IT efficiency.
  • Collaborated with the IT team to identify and implement process improvements for faster issue resolution and better user experience.
  • Monitored and maintained cybersecurity protocols to safeguard sensitive company data.

Education

Bachelor of Science - Information Technology

Kennesaw State University
Kennesaw, GA
05-2024

Skills

  • PowerApps
  • Power automate
  • Windows administration
  • System troubleshooting
  • IT documentation
  • Hardware installation
  • Application support
  • Access control
  • Email administration
  • VoIP systems
  • PowerBI reporting

Timeline

JR Data Analyst

MaxAir Mechanical
01.2025 - Current

JR Systems Administrator

MaxAir Mechanical
05.2024 - 01.2025

IT Intern

MaxAir Mechanical
06.2023 - 05.2024

Bachelor of Science - Information Technology

Kennesaw State University