Ziyue Fan Email & Phone Number

Houston, TX, US

• Developed and integrated Python script with ChatGPT API to clean 500K noisy text data, significanly reducing manual verification time
• Implemented a distributed computing solution with PySpark on Google Dataproc, expediting data processing efficiency by 5x
• Architected a Python data pipeline to extract and transform 7,000+ universities’ tuition and employment data for in-depth analysis
• Constructed a ranking system for 275 institutions, designing methodology grounded in four metrics of graduates' career outcomes
• Streamlined and transformed 170K text records across multiple sources using Power Query and VLOOKUP, enhanced data consistency
• Leveraged PivotTables to build hierarchical views of company contact data spanning three years and uncover underlying data trends

Austin, Texas, United States

• Revitalized Slalom's operational efficiency by implementing AI automation for RFP information extraction, significantly freeing up staff for strategic activities. This innovation reduced response time and bolstered.
• Spearheaded project scoping, adeptly pinpointing four key business needs and selecting optimal technological solutions
• Facilitated weekly cross-functional team meetings to forage consensus, strategically aligning project plans with client priorities
• Initiated preliminary research to assess and evaluate 5+ effective APIs and AI resources for content extraction integration

Xi'an, Shaanxi, China

• Coordinated 15+ stakeholder interviews to gather requirements, directly contributing to Business Requirements Documentation
• Mapped workflows for 9 subsidiaries using Visio, identifying process improvements that enhanced interdepartmental transparency
• Facilitated the migration of 1M+ legacy system records by crafting a scalable database schema, eliminating data redundancy
• Built an interactive dashboard for real-time project cost visualization, speeding up the cost control decision-making process
• Assisted the IT team in the ERP module implementation by performing User Acceptance Tests, minimizing post-launch errors

Jiuquan, Gansu, China

• Analyzed sensor data and created monthly time series graphs to track trends, optimizing maintenance plan and resource allocation
• Led the creation of an intuitive dashboard by gathering feedback from 20+ surveys, increasing clarity and operational oversight
• Conducted detailed data quality checks with SQL, resolving inconsistencies and standardizing formats to elevate data reliability
• Collaborated with engineers on building predictive models to forecast equipment failures, reducing monthly unexpected downtime
• Optimized HSE system’s query sorting efficiency by applying indexing strategies, accelerating data retrieval and report generation

• Formulated product plans and strategies for dancing and rhythm video games and promoted the establishment of 15-20 projects
• Assessed customers’ needs and prepared PRD document, defined the product form with the game project team of five members
• Programmed game files weekly which support dance pad input, including song information, music and image files, beat and rhythm
• Focused on the game data trend and user feedback and continuously promoted the iterative optimization of products

Master Of Science - Ms, Computer/Information Technology Administration And Management, 3.76/4.00

Activities and Societies: UT Danceholic (dance crew President)Coursework Includes Design Methods, Advanced Programming & App Development.

Bachelor'S Degree, Management Information Systems, General, 3.82/4.00

Activities and Societies: UT Danceholic(dance crew member)

High School Diploma, International Department, Gpa 4.0/Rank 8