Business Analyst Intelligence

Sylvia Zhou

Graduate Student in Information Management Data & Business Analysis SQL, Excel, BI Tools

217-***-**** ******@********.*** Champaign, IL www.linkedin.com/in/sylviazhou58/ EDUCATION

University of Illinois Urbana-Champaign Champaign, IL Master of Science in Information Management GPA: 4.0 September 2024 - May 2026 Courses: Information Modeling, Database Systems, Data Warehousing and Business Intelligence, Information Consulting Macau University of Science and Technology Taipa, Macau Bachelor of Arts in Journalism and Communication September 2020 - May 2024 WORK EXPERIENCE

Poizon, Merchant Experience Team Shanghai, China

Business Analyst Intern May 2023 - August 2023

• Extracted and processed sales data for 180+ merchants using SQL, ensuring data consistency and accuracy by handling missing values, removing duplicates, and standardizing records to support reliable revenue tracking and performance analysis.

• Enhanced sales performance by aggregating transaction data, analyzing growth trends, and segmenting merchants to generate 38 comprehensive customer sales reports using Excel; provided data-driven recommendations, including effective bundling strategies, resulting in a 15% increase in revenue and improved product visibility.

• Analyzed drop-off rates, average completion time, and engagement metrics using SQL to identify onboarding bottlenecks, delivering recommendations that streamlined onboarding processes and improved merchant activation rates by 23%.

• Collaborated with cross-functional teams to simplify the merchant onboarding standard operating procedures (SOPs) by removing redundant steps and clarifying process guidelines, reducing average completion time by 18%.

• Translated complex data insights into clear, actionable recommendations for non-technical stakeholders, improving cross-team communication by aligning technical analysis with business priorities. Shanghai Tizhi Information Technology Co., Ltd. Shanghai, China Digital Marketing Intern May 2021 - July 2021

• Conducted competitive benchmarking by analyzing market trends, user sentiment, and engagement strategies; delivered insights that informed product positioning and strategic planning.

• Analyzed social media performance data using Excel to identify behavioral engagement trends and high-impact content patterns, providing insights that refined strategy and boosted interaction by 39%.

• Tracked advertising metrics including CTR, CAC, and ROAS across multiple platforms to assess campaign effectiveness, optimize budget allocation, and reduce overall marketing costs by 15%.

• Led user research through 10+ interviews and performed sentiment analysis on community feedback, identifying pain points that enhanced targeting accuracy and improved marketing ROI by 20%. PROJECTS

AI-Powered Compliance Optimization & Scheduling System (Client Project) Champaign, Illinois Technical Consultant Jan 2025 - Present

• Conducted user research through structured interviews with pilots and collaborated with stakeholders to identify scheduling and compliance challenges, aligning system development with regulatory and operational needs.

• Developed and implemented an ETL pipeline using SQL and Airbyte to integrate multi-source scheduling data for downstream compliance analysis.

• Engineered a predictive fatigue risk model analyzing historical flight hours and workload data, reducing Collective Bargaining Agreement (CBA) violations by 30% and optimizing workforce allocation.

• Implemented dynamic scheduling optimization using semantic search and NLP to automate CBA rule verification, improving planning accuracy and reducing manual effort by 40%.

• Created an AI-powered chatbot and visual dashboards to deliver compliance insights to pilots and stakeholders, accelerating decisions and aligning outputs with cross-functional operational needs. SKILLS

Programming Language: SQL, R, Python

Tools & Software: Power BI, Tableau, Web Intelligence, Excel, SPSS, Adobe XD, RStudio, Figma Industry Skills: Data Analysis, Data Visualization, Graphic Design, Quantitative Research, User Interface Design

Contact this candidate