Xinyu Cindy Duan
Tracy,CA
Overview
2025
2025
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
Work History
Logistics Analyst
4P Foods
4 2024 - Current
- Power BI Development: Develop dynamic Power BI dashboard by using SQL in Azure Databricks, integrated inventory, equipment, order and route information to enhance warehouse management
- Predictive Model: Conduct regression analysis and predictions on user behavior, insurance, and inventory transfer data to facilitate decision making, resulting in monthly savings of over 6,000 dollars
- Routing Optimization: Clean and analyze over 3,000 large scale geo-spatial supply chain data weekly, and deliver orders to external vendors for route optimization
Business Analyst Intern
American Chemical Society (ACS)
05.2023 - 08.2023
- Machine Learning: Collaborated on building machine learning model by using Python to calculate members engagement rate, set email alerts for members with low interactivity, resulting in 3% product usage improvement
- Database Management: Evaluated feasibility of launching membership directory by administrating dashboard of over 150,000 records, and categorized members, expanding proposal applicability
- Market Analysis: Identified ACS popular products for school use by visualizing over 2,000 surveys for Association of Teachers by using R, explored demographics of teachers and customized demands
- Research Report: Assessed achievements of over 50,000 women in chemistry by extracting data for Women Chemists Committee through SQL usage, posted evaluation report and achieved 1,000 views
Operation Management Analyst
Xiamen Xiangyu Logistics Group Corporation
07.2021 - 06.2022
- Data Monitoring: Monitored coal supply chain data including price, futures, options, and profits for trading subsidiaries with annual sales of over 15 million dollars by using Oracle CRM and SAP, and prepared monthly reports for leaders, ensuring operational sustainability of key businesses and projects
- Risk Prevention: Contributed to corporate management strategy by designing internal guidelines to better tailor business operation model, preventing 3 loss cases totaling over 1 million dollars
- Strategic Planning Innovation: Upgraded supply chain models by customization of systems through inspection of cliental business-as-usual activities, reducing risk of expanding market
Education
Master of Science - Business Analytics
George Washington University
Washington, DC 08.2022 - 12.2023
Bachelor of Science - Finance
China Foreign Affairs University
Beijing, CN 09.2017 - 06.2021
Academic Exchange Program - Business and Economics
University of California, Berkeley
Berkeley, CA 01.2020 - 05.2020
Skills
SAS Base Programming
Certified Scrum Master
Google Analytics Certification
Python
panda
numpy
scikit-learn
SQL
R
ggplot
SAS
MATLAB
NLP
AWS
Azure
Power BI
Tableau
Jira
ERP
Microsoft Office
Excel
pivot table
vlookup
ETL
Websites
Certification
SAS Base Programming
Academicprojectexperience
Analytics Edge and Data Ethics: Credit Card Payment Prediction, 03/01/23, Analyzed credit card delinquency rate by using decision tree model based on over 30,000 customers historical payment records, selected branch by using validation AUC, inspected AUC iteration plot, Evaluated final model by using confusion matrix and AIR (Adverse Impact Rate) between subgroups of race and gender for bias remediation, updated cutoff value and achieved 82% accuracy rate
Timeline
Business Analyst Intern
American Chemical Society (ACS)
05.2023 - 08.2023
Master of Science - Business Analytics
George Washington University
08.2022 - 12.2023
Operation Management Analyst
Xiamen Xiangyu Logistics Group Corporation
07.2021 - 06.2022
Academic Exchange Program - Business and Economics
University of California, Berkeley
01.2020 - 05.2020
Bachelor of Science - Finance
China Foreign Affairs University
09.2017 - 06.2021
SAS Base Programming
Certified Scrum Master
Google Analytics Certification
Logistics Analyst
4P Foods
4 2024 - Current
Similar Profiles
Mayuresh Raj ShingteMayuresh Raj Shingte
Head - Controlled Chaos & Client Calm (Operations) at 4P Events and ExhibitionsHead - Controlled Chaos & Client Calm (Operations) at 4P Events and Exhibitions
Burton ChaneyBurton Chaney
Equipment Operator at 4P Land ServicesEquipment Operator at 4P Land Services
Jaylon Ellison, CFP ®, AIF ®Jaylon Ellison, CFP ®, AIF ®
Chief Investment Officer at 4P Wealth TrustChief Investment Officer at 4P Wealth Trust
Francisco AguirreFrancisco Aguirre
Propulsion Engineer at American Institute of Aeronautics and Astronautics (AIAA)Propulsion Engineer at American Institute of Aeronautics and Astronautics (AIAA)
Ismael Sagrero PartidaIsmael Sagrero Partida
Demolition Crew Member at RJ Commercial FlooringDemolition Crew Member at RJ Commercial Flooring