Microsoft Excel (Expert Level: VLOOKUP, INDEX MATCH, PivotTable, PowerQuery, etc)
Hi, I’m
Khoi Nguyen
Data Analyst
Links
LinkedIn: linkedin.com/in/khoi-nguyen-data-analyst
Tableau: public.tableau.com/app/profile/khoi.nguyen1815/vizzes
Summary
Data analyst with over 5 years of experience specializing in data remediation analysis and visualization. Expert in advanced Excel, Tableau, and Salesforce CRM. Proven track record in managing large datasets, performing statistical analysis, and creating impactful visualizations. Strong project management and problem-solving skills with a keen eye for detail and a commitment to data accuracy. Seeking opportunities to leverage my skills in data analytics and visualization to support data-driven decision-making in a dynamic environment.
Accomplishments
- Automated reporting processes using Excel Macro and VBA, resulting in an 80-90% reduction in manual efforts and increased efficiency by 50%. (PFG Core-Mark & Eby-Brown)
- Guided training sessions that contributed to an 80% reduction in onboarding time, optimizing team performance. (PFG Core-Mark & Eby-Brown)
- Utilized Salesforce CRM to manage and maintain customer data, resulting in a 30% increase in data accuracy. (Rydin)
- Implemented data-driven initiatives that led to the recovery of over $500,000 in lost checks for the Used Vehicle Sales department. (Wheels, Inc.)
- Streamlined cash desk processes, achieving a 20% reduction in processing time while enhancing accuracy. (Wheels, Inc.)
Software
Microsoft Excel Macro / VBA (Visual Basic for Applications)
Microsoft Office Suite (Word, PowerPoint, Outlook, Teams, etc)
Data Visualization: Tableau, Power BI
ERP: SAP SCM / SAP BW
CRM: SalesForce
Programming Languages: SQL, R
Collaboration Tools: Miro
Project Management Tools: Smartsheets, Trello
AI Technology: ChatGPT
Cloud Storage: SharePoint, OneDrive, Google Drive, iCloud
Google Suite (Docs, Sheets, Slides, Gmail, etc)
Windows OS
MacOS
AWS
Skills
Data Analytics / Data Analysis
Data Visualization: Winter Halt, Forecasting
Data Reporting / Data Cleaning / Data Remediation
Error Analysis / Report Analysis / KPI Analysis
Statistic: Statistical Analysis / Statistical Modeling
Agile Methodologies
Analytical Thinking
Problem-Solving
Advanced in Streamlining SOPs
Exceptional Organization Skills
Attention to Detail / Detail-Oriented
Executive Support / Administrative Support
Track and Analyze Performance and Sales Data
Leadership
Project Management / Multi-Project Management
Communication Skills (Oral and Written)
Multi-Tasking
Time Management
ETL (Extract, Transform, Load)
Overview
7
years of professional experience
5
years of post-secondary education
2
Languages
Professional Development
IT Expert System, Schaumburg, IL | Data Analytics Program | Active
WIAO Grant Recipient
- Courses Completed: Excel (with emphasis on Data Analysis), SQL, Tableau, R Programming, AWS
- Course in Progress: Power BI
Timeline
Data Analyst Internship: Data Visualization
IT Expert System
11.2023 - 12.2023
Assistant to the Director
PFG (Core-Mark & Eby-Brown)
04.2021 - 12.2022
Administrative Assistant / Procurement Specialist
PFG (Core-Mark & Eby-Brown)
11.2020 - 04.2021
Business Development Representative
Rydin
10.2019 - 05.2020
Administrative Assistant
BG Multifamily Staffing
06.2019 - 09.2019
Office Administrator
Wheels, Inc.
07.2018 - 05.2019
Faculty Recruiter
American Physician Institute
08.2017 - 01.2018
Loyola University of Chicago
Bachelor of Arts from Sociology
08.2014 - 05.2017
Education
Loyola University of ChicagoChicago, IL
Bachelor of Arts from Sociology
08.2014 - 05.2017
University Overview
- Minor: Business Management
- Former Major: Biology
- Studied Abroad: Loyola University Campus in Vietnam
Work History
IT Expert SystemSchaumburg, IL
Data Analyst Internship: Data Visualization
11.2023 - 12.2023
Job overview
- Led Tableau projects using advanced visualization techniques such as heat maps and interactive charts, enhancing decision-making processes by 30%.
- Created mock data sets using Excel, transitioned to real data while adhering to strict data privacy protocols, and improved data quality by 20%.
- Implemented Agile Scrum methodologies, utilizing Miro and Trello for efficient meetings, deadline management, and enhanced team collaboration, resulting in a 25% increase in project efficiency.
- Designed intuitive Tableau dashboards with techniques like dynamic filtering and trend analysis, leading to a 30% improvement in prospective students' decision-making accuracy.
PFG (Core-Mark & Eby-Brown)Naperville, IL
Assistant to the Director
04.2021 - 12.2022
Job overview
- Trained new hires on daily tasks, provided necessary resources, validated work, and offered continual guidance, increasing team efficiency by 25%.
- Developed and maintained spreadsheets and databases for tracking, analyzing, and reporting performance and sales data, improving data accuracy by 20%.
- Streamlined office procedures by implementing new strategies, boosting productivity by 30%, and reducing processing times by 25%.
- Produced daily, weekly, and monthly reports for upper management using Excel, VBA, SAP, and SAP BW, aiding data-driven decision-making.
- Automated tasks with Excel Macros and VBA projects, reducing manual efforts by 85% and improving workflow efficiency.
- Managed multiple projects under tight deadlines, consistently delivering high-quality results.
- Demonstrated strong communication skills, collaborating effectively with team members, vendors, and customers.
- Organized and managed documents using SharePoint, ensuring efficient access and management.
- Fostered team cohesion by providing training, support, and guidance, improving task completion rates by 20%.
- Maintained effective communication with vendors, customers, and employees, enhancing customer satisfaction by 15%.
- Excelled in time management, optimizing workday efficiency, and consistently meeting deadlines.
- Applied problem-solving and critical thinking skills to analyze large datasets, enhancing data-driven decision-making.
PFG (Core-Mark & Eby-Brown)Naperville, IL
Administrative Assistant / Procurement Specialist
11.2020 - 04.2021
Job overview
- Utilized SAP, SAP BW, and advanced Excel features (e.g., PivotTables, Macros, complex formulas) to produce daily, weekly, and monthly reports, providing management with actionable insights and supporting data-driven decisions.
- Demonstrated exceptional organizational skills and advanced data analysis techniques to ensure smooth business operations and improve process efficiency.
- Optimized large Excel files by implementing advanced formatting, data organization, and visualization techniques, enhancing readability and increasing efficiency by 25%.
- Managed and maintained spreadsheets and databases for tracking and analyzing performance and sales data, resulting in a 20% improvement in reporting accuracy and capabilities.
- Developed and implemented innovative strategies to streamline office procedures, reducing processing times by 30% and significantly boosting overall productivity.
RydinStreamwood, IL
Business Development Representative
10.2019 - 05.2020
Job overview
- Generated and qualified prospective leads through targeted outreach, driving successful account growth and increasing the sales pipeline by 20%.
- Proactively identified new business opportunities via strategic cold calling and email campaigns, contributing to a 15% increase in new client acquisition.
- Delivered exceptional customer service to both current and potential clients, enhancing client relationships and achieving a 10% improvement in customer retention rates.
- Maintained complete and accurate data within Salesforce, ensuring optimal team performance and facilitating data-driven decision-making.
- Utilized advanced technologies such as ZoomInfo, RocketReach, and LinkedIn to drive lead generation, successfully identifying key decision-makers and influencers, resulting in a 25% increase in qualified leads.
- Collaborated with the leadership team to implement data quality improvements, enhancing account updates' effectiveness and ensuring data integrity.
BG Multifamily StaffingSchaumburg, IL
Administrative Assistant
06.2019 - 09.2019
Wheels, Inc.Des Plaines, IL
Office Administrator
07.2018 - 05.2019
Job overview
- Implemented data-driven initiatives that led to the recovery of over $500,000 in lost checks for the Used Vehicle Sales department.
- Streamlined cash desk processes, achieving a 20% reduction in processing time while enhancing accuracy.
- Managed cases using Salesforce, ensuring accurate tracking and resolution.
- Used Excel spreadsheets to keep track of all checks’ information, ensuring data accuracy and completeness.
American Physician InstituteWestmont, IL
Faculty Recruiter
08.2017 - 01.2018
Job overview
- Learned and utilized Smartsheets for tracking and coordinating recruitment processes.
- Utilized Microsoft Office software (Excel, Word, PowerPoint, Outlook, Teams) to manage recruitment activities and communication.