Data Analyst
Resume:
Quang Nguyen
Garden Grove, CA *****
**********@*****.***
A highly skilled data analyst with 8 years of experience in supply chain management seeking a challenging role to utilize my expertise in data analysis, forecasting, and optimization to help improve business processes and drive growth.
Authorized to work in the US for any employer
Work Experience
Data Analyst
PENTEL OF AMERICA - Torrance, CA
January 2021 to Present
• Leveraged SQL (including Snowflake and BigQuery) and Python to extract, clean, and transform data from various sources, including sales and production data, to inform decision-making and optimize supply chain operations.
• Developed and maintained dashboards and reports using data visualization tools such as Tableau to track key supply chain metrics, such as inventory levels, lead times, and on-time delivery.
• Analyzed data to identify opportunities to optimize and streamline supply chain processes through data-driven analysis and continuous improvement efforts.
• Collaborated with cross-functional teams, such as procurement, logistics, and production, to analyze data and provide insights that supported business goals and objectives.
• Assisted with the development and implementation of ETL processes to support the integration and harmonization of data from different systems and platforms.
• Provided support and training to users of data-driven tools and systems.
• Utilized advanced analytics techniques, such as machine learning and predictive modeling, to forecast demand and optimize inventory management.
• Utilized Excel and Oracle databases to analyze and manipulate data.
• Led and mentored a team of analysts to ensure the accuracy and timeliness of forecasting efforts.
• Conducted data discovery and forensics for issues resolution to maintain data integrity.
• Maintained an in-depth understanding of business functions, processes, and relationships as they relate to data.
• Documented and aligned with cross-functional teams on key decisions that impacted process and business operations.
• Created documentation, such as SOP BRD, process flows, data matrix, business cases, and gap analysis, to ensure clear communication and understanding of business requirements. SUPPLY CHAIN ANALYST
PACIFIC AMERICAN FISH COMPANY Inc. - Vernon, CA
February 2017 to January 2021
• Analyse, manage, forecast, and schedule material requirements using the ERP system.
• Coordinates with Engineering to create and update bills of Materials.
• Create and monitor forecasts, and validate that they are in alignment with historical trends.
• Coordinate planning decisions from users, production, and information from suppliers to reduce material shortages.
• Utilize point-of-sale data, customer inventory, promotional calendar to develop item-level forecasting and replenishment plans.
• Optimize inventory levels to meet customer, operational, product, and financial needs.
• Create, issue and track PO (Purchase Orders) in the ERP system for all products while working closely with vendors
• Collaborates with sales, logistics, and manufacturing departments to establish schedules and plans that
• allocate available resources to serve customer needs best.
• Drive sustained performance in all critical areas of customer scorecard (customer fill rate, in-stock %, inventory, on-time ship) through accurate forecasting, development, and execution of item/categories specific strategies.
• Monitor SKU levels and recommend SKU rationalization in the future.
• Responsible key metrics include Line Level Fill Rate, Back Order, Working Capital, and E&O.
• Responsible for inventory management, assure adherence to planned levels, and minimize excess & obsolete exposure (E&O).
• Collaborate with the distribution center to ensure inventory levels and accuracy.
• Develop and maintain documentation and standard operating procedures for demand planning processes and systems.
Logistics Coordinator
ROSE PHARMACY - Santa Fe Springs, CA
August 2012 to February 2017
• Experience in a dispatching environment working with the LA/LB Ports.
• Effective managing orders to ensure that they deliver on time and within budget.
• Oversee scheduling, coordination, and distribution for daily operation.
• Actively manage containers at Marine Terminals to avoid demurrage.
• Analyse and review expenditures, route, schedule planning, and post-job results for the optimum time and cost -efficiency.
• Ensured that transactions were recorded accurately and available to budget and finance department upon request.
• Experience working in an environment with both contractors and company drive. Education
Bachelor of Business in Administration
Cal State Fullerton - Fullerton, CA
August 2008 to June 2012
Skills
• Python
• MySQL
• Data analytics
• Data Modeling
• ETL
• Power BI
• Tableau
• SQL
Links
https://github.com/QNTV
https://www.linkedin.com/in/quang-nguyen-0a579b22/ Certifications and Licenses
IBM DATA SCIENCE PROFESSIONAL CERTIFICATE
June 2020 to Present
APPLIED DATA SCIENCE BY IBM CERTIFICATE
July 2020 to Present
Contact this candidate