Yitong Feng
Overview
4
4
years of professional experience
Work History
Business Analyst Remote
Aramark
01.2023 - Current
- Generated and tracked real-time KPI dashboards by conducting primary metrics analysis connecting SQL and PowerBI to measure vendor performance, and presented data-based insights to clients
- Defined key process to map workflows and implemented digital solutions using Power Automate to streamline and automate RPA processes, resulting in increased productivity in ticket resolution
- Participated in product development of ecoBPM system, driving enhancements and feedbacks that increased customer usability and ticket processing efficiency
IT Compliance Analyst Intern
Boehringer Ingelheim
07.2022 - 12.2022
- Processed expense and budget data of healthcare products and events in 8 countries, performed data analysis and visualization using Python and assisted businesses in making financial decisions
- Created 7 dashboards in ServiceNow for ticket performance of sub-systems to monitor and optimize business processes, increasing breach ticket resolution efficiency by 31%
- Implemented user tickets and data remediation processes, investigated data anomalies, and supported error queue data manipulation for ClearView system by using SQL Developer
Business Intelligence Intern
Adonis Auto Group
05.2022 - 07.2022
- Connected MySQL with Python to capture data and calculate 10 KPI metrics for monthly reports. Provided data-driven marketing recommendations by assessing sales performance
- Leveraged PowerBI to produce dynamic dashboards, tracked car loans and floating interests grouped by regions, quarters, and tranches and built comparison graphs for each metric over 3 time frames
- Conducted competitive research and addressed operational inefficiencies to identify improvements
Data Analyst Intern
Nielsen
12.2019 - 03.2020
- Analyzed and processed 1500+ Unilever stores' data in MySQL and Excel to identify patterns of sales and customer interactions and staff work performance metrics
- Collaborated with Nielsen's customer development department to conduct competitive analysis and interpretation, initiated data-driven recommendation, led to notable enhanced staff productivity
Education
M.S - Information Studies
University of Texas At Austin
Austin, TX12.2022
Bachelor of Business Administration -
Beijing Language And Culture University
Beijing, China07.2020
Skills
- Technical : SQL, Python, PowerBI, Tableau, Power Automate, ServiceNow, Figma
- Project Management : Agile, GitHub, Jira, Confluence, Smartsheet
Additional Information
Worked as the co-founder of TianXuan Educational Workshop, focusing on information dissemination on social media and educational consulting service. Helped 100+ students to apply successfully for master's degrees in the US and UK.
Timeline
Business Analyst Remote
Aramark
01.2023 - Current
IT Compliance Analyst Intern
Boehringer Ingelheim
07.2022 - 12.2022
Business Intelligence Intern
Adonis Auto Group
05.2022 - 07.2022
Data Analyst Intern
Nielsen
12.2019 - 03.2020
M.S - Information Studies
University of Texas At Austin
Bachelor of Business Administration -
Beijing Language And Culture University
Similar Profiles
Joanna CuevasJoanna Cuevas
Food Service Worker at AramarkFood Service Worker at Aramark
Jonathan BasilioJonathan Basilio
Food Specialist Supervisor at AramarkFood Specialist Supervisor at Aramark
Annie FerreiraAnnie Ferreira
Barista at AramarkBarista at Aramark
Alivia BloomfieldAlivia Bloomfield
Food Service Worker at AramarkFood Service Worker at Aramark
Monika CorriveauMonika Corriveau
Business Analyst Remote at Aistori Inc.Business Analyst Remote at Aistori Inc.