
Linqi Chen
Audit Assistant

Connect with Linqi Chen to Send Message
Connect
Connect with Linqi Chen to Send Message
ConnectTimeline
About me
Data Analytics Student @ Columbia University | UC Irvine Alum | Seeking for Business Analyst, Data Analyst, or Business Intelligence Analyst full-time positions
Education

Shenzhen Foreign Languages School
2016 - 2019
UC Irvine
2019 - 2023Bachelor of Arts - BA Business/Managerial Economics 3.923/4Major: Business EconomicsMinors: Management, Statistics

Columbia University
2023 - 2024Master of Science - MS Applied Analytics
Experience

BDO China-SHU LUN PAN Certified Public Accountants LLP
Jul 2019 - Aug 2019Audit Assistant- Participated in the mid-year audit of Yuhetian Environmental Development Group Co., Ltd. with the team- Assisted in completing the calculation of the discounted cash flow of the loan, completed the customer’s annual audit work, and helped improve the efficiency of teamwork- Collected the decrease in bad loans to each branch of the company and the cause of abnormal conditions

Shenzhen DATANG Computer Co., ltd.
Sept 2020 - Nov 2020Business Analytics Intern- Collaborated in refining sales plans through meticulous sales feedback collection and comprehensive market performance reviews. Employed data visualization tools such as Tableau to analyze sales trends and patterns.- Utilized statistical analysis techniques to optimize sales scopes and targets, offering decision-making support to relevant departments. Weekly market situation reports informed superiors, leading to responsive and agile strategies.- Responsible for sales forecast management and contributed to designated sales plans, resulting in an 8% increase in revenue from overseas online sales.- Pioneered innovative promotional initiatives utilizing A/B testing techniques to amplify platform engagement, resulting in a notable 15% surge in customer retention rates. Show less

Meta
May 2021 - Jul 2021Extern- Completed 10 case studies with metrics, including # followers, # likes, video time, type, and reviews from different platforms to find inspiration for the industry- Cleaned data with Excel, performed math modeling, and visualized in charts to predict the rating to select the top 3 attractive influencers- Created communications strategy based on best practices for outreach, value propositions, and coordination processes for influencers- Summarized with case studies focusing on how companies within the industry utilized IG stories and Facebook Live to grow their brand Show less

Vinno Capital Co.
Jul 2021 - Aug 2021Business Analytics Intern- Documented the company's strategic trajectory, product specifics, customer base, operational metrics, and founder's background, providing valuable insights for informed decision-making.- Orchestrated the collection of daily industry investment updates and structured financing data using web scraping to yield detailed industry analysis reports.- Utilized Excel & Python for a comprehensive start-up comparison, leveraging statistical regression models to assess the correlation between efficiency improvements and other factors such as technology barriers, team size, and so on. Show less

UC Irvine
Jul 2021 - Jun 2023Undergraduate Research Assistant Leader, Economics Department
Global AI
Jun 2023 - Aug 2023Data Analyst Intern- Employed Python to scrape merchant review data from Google, increasing the data collection efficiency by 15% and enhancing data organization through the implementation of keyword-based one-hot encoding.- Performed NLP-based sentiment analysis on scraped reviews to identify target merchants. Designed and implemented a relational SQL database to streamline client interactions through efficient data access and query capabilities.- Applied advanced analytical techniques like sparsity analysis, regression, and time-series modeling to predict stock trends. Visualized data using Tableau to deliver valuable insights to investors through descriptive and predictive reports. Show less

Global ESG Leadership Association
Sept 2023 - May 2024Member of Global Development and Research Center
28ish
May 2024 - Aug 2024Data Analyst Intern
Ryder System, Inc.
Sept 2024 - Dec 2024Student Data ScientistCollaborated with Ryder’s Data Science team to develop a comprehensive machine learning solution focused on optimizing monthly maintenance cost forecasting. Key contributions include:- Conducted extensive exploratory data analysis using R and Python to uncover critical patterns and trends within maintenance cost data.- Designed, developed, and fine-tuned Time Series and Random Forest models, as well as ETS (Exponential Smoothing State Space Model) processes, to enhance forecast accuracy and adaptability to varying data patterns.- Created a user-friendly API interface that enables seamless access and interaction with cost projection results, empowering stakeholders to make data-driven decisions. Show less
Licenses & Certifications
- View certificate

Paragon One General v2
Paragon OneJul 2021 - View certificate

Google Analytics for Beginners
GoogleAug 2023
Honors & Awards
- Awarded to Linqi ChenPhi Beta Kappa Membership Mu Chapter of UC Irvine May 2023 Awarded for outstanding distinction, characterized by broad cultural interests, scholarly achievement, and good character.
Recommendations

Abimbola cole kai-lewis, phd
ETHNOMUSICOLOGY | PROGRAM DESIGN | ADMINISTRATIONNew York City Metropolitan Area
Cyril rosin
Senior Catalog LeadTamil Nadu, India
Anusha tej
Member of Talent Acquisition at Akamai Technologies. (Share your resume at Hiring@akamai.com to expl...Bengaluru, Karnataka, India
Mehmet ayten
Co-Founder / Mam Endüstriyel Müh.Makina Tic.Ltd.Şti. (Adana Bölge Kaeser Kompresörleri Yetkili Distr...Adana, Türkiye
Jackie zizane
Deputy Chief of Party and Trade Facilitation expert at International Business Initiatives Inc (IBI).Gasabo District, Kigali City, Rwanda
Lebron fernando
Security Manager at Northwest Medical CenterPompano Beach, Florida, United States
Eunjeong cho
UNDP | Korea University | Environmental HealthBangkok, Bangkok City, Thailand
Beatrice mingazzini
Content Producer Junior presso SpindoxMilan, Lombardy, Italy
Wendy wang
Associate Product Manager at TTY BiopharmTaipei City, Taipei City, Taiwan
T vijay
Chemical EngineerChennai, Tamil Nadu, India
Veronika pál-ágfalvi
.Vecsés, Pest, Hungary
Alioune tabane
Cardiologue-Rythmologue interventionnel-USIC-Medecin du sport- SG du syndicat des médecins privés du...Département de M'bour, Thiès Region, Senegal
Shrinil parekh
Java developerAhmedabad, Gujarat, India
Eliziane gomes
Assistente de negócios - Sicredi / Acadêmica de Eng de ProduçãoSorriso, Mato Grosso, Brazil
Priyanshu gupta
Data Analyst @ ARDEM Data Services | Problem SolvingLondon, Ontario, Canada
Ricardo topete moncada
Director Comercial en CMI Real EstateCuajimalpa de Morelos, Mexico City, Mexico
Abdul azeez jabeer, mrics
Senior Commercial/Contracts Manager | Chartered Surveyor | Red Sea GlobalRiyadh, Saudi Arabia
Nicholas batchelder
Private InvestigatorWaldport, Oregon, United States
Beverly steensen
Rebate Specialist at Concordance Healthcare SolutionsTiffin, Ohio, United States
Ravichandran vaidhyanathan
Lead PMO at SHELL INDIA MARKETS PRIVATE LIMITEDBangalore Urban, Karnataka, India
...