Learn Data Skills

Erik Nguyen

Technical IT Consulent

CGI Group

Technologies

My Portfolio Highlights

My New Course

Introduction to Data Science in Python

Data enthusiast, embracing the beauty of numbers and algorithms.

My Work

Take a look at my latest work.

course

Introduction to Data Science in Python

course

SQL for Joining Data

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Accredo Packaging Inc | Sep 2022 - Present

Material Analyst

Material Allocation Optimization Contributed to a cost reduction of $595,161 by implementing an effective and creative material allocation strategy, identifying aging materials, and repurposing them, thereby halving 180+ day aging inventory from January 2023 to January 2024. Build data flows from ERP systems, including Microsoft Navision and Microsoft Business Central, to facilitate the creation of intuitive Power Bi dashboards and solutions for instant access, crucial material insights and real-time inventory updates. Helped significantly reduce manual tasks and save 6 users, including the Director of Demand Planning and two department managers, about 12 hours weekly, totaling 600 hours annually. This functional enhancement resulted in an estimated yearly labor cost saving of $40,000. Categorized materials by age and identified unallocated inventory, enhancing proactive management practices. Purchased Material Master Planner Interface Development Developed an Excel-based tool for dynamic material planning, aligning incoming material schedules with open requirements and job deadlines. Successfully optimized inventory management, achieving a 33% red uction in main raw material stock while supporting a consumption rate increase of 100% year-over-year. This efficiency enhancement contributed to significant cost savings and improved supply chain agility. Power BI Dashboard Development and Data Analytics Simplified complex data, identifying key KPIs to support stakeholders in decision-making and efficiency. Maintained data integrity in report generation.
Show More

Powered by

  • Work
  • Courses
  • Experience
  • Create Your Data Portfolio for Free