Jingchi Wei
Hong Kong
Summary
Data Analyst/Data Scientist with 2+ years of professional experience, demonstrating a strong ability in data management, Python, SQL, and PowerBI. Known for leadership and communication skills, this professional excels in driving business growth through meticulous analysis and optimization of complex data sets. Proven track record in delivering cost-saving solutions, exceeding expectations, and innovating workflow processes. Enthusiastically ready to apply these skills to new challenges and opportunities.
Overview
2
2
years of professional experience
Work History
Data Analyst
Adonis Partners
08.2022 - 10.2023
- Directed creation and implementation of global data management framework (encompassing data ownership, critical data elements, and data quality), including comprehensive documentation for team members. This initiative significantly improved data organization, clarity, and accessibility, leading to enhanced decision-making, operational efficiency, regulatory compliance, and fostering collaboration across departments.
- Spearheaded end-to-end data management at Adonis Partners, collaborating seamlessly with cross-functional teams to define and meet diverse client data requirements. Ensured precision in data acquisition, cleaning, and reorganization, setting foundation for impactful analyses.
- Analyzed data to identify root causes of problems and recommended corrective actions via SQL and Python. Achieved substantial cost savings for our client, up to $3 million in fiscal year, through data-driven solutions.
- Collaborated closely with stakeholders and clients' VPs to identify business needs and data sources. Innovated and developed PowerBI dashboards from inception, providing clients with in-depth business insights into project and workflow progress, employment trends, and actionable business intelligence. Internally, streamlined processes by creating dashboards tracking consultants' billable working days. Continually enhanced and automated dashboards, saving 20 hours work per week for data and HR teams.
- Led a groundbreaking Green Belt project, overseeing migration from GSuite to MS365 of all data elements, including emails, documents, calendars, and forms. Collaborated with external ventures, reported directly to CEO and CTO, and ensured effective communication with all employees. Post-migration surveys confirmed significant improvements in working efficiency, collaboration, and data security, reinforcing long-term organizational value.
Business Analyst
Chestnut Residence (University Of Toronto)
08.2021 - 08.2022
- Collected, cleaned, and analyzed past 3-year data in hospitality industry in Ontario via SQL and Python to build relational databases and determine competitive rates. Identified strategies to improve hotel services, and recommended competitive pricing to manager.
- Built and automated dashboards using PowerBI for business KPIs and business insights that reduced manual reporting by 3 hours weekly.
- Generated consumable, appropriate data reports on weekly basis. Communicated meaningful results with different departments to support data-based decisions and largely improved operational efficiency.
- Conducted market research on emerging trends in hospitality industry, providing insights and recommendations to optimize revenue streams and enhance customer satisfaction for Chestnut Residence.
- Identified key performance indicators (KPIs) related to customer satisfaction and revenue generation specific to Chestnut Residence. Developed performance tracking methods and reports to monitor these KPIs regularly, allowing for timely adjustments and improvements in service delivery and financial performance.
Data Analyst Intern
Bytedance (Company of TikTok)
05.2021 - 08.2021
- Designed and implemented A/B experiments and surveys for online educational content that improved conversion rate by 15 basis points and reduced churn by 10 basis points
- Collected, cleaned, and analyzed data on all online educational videos using SQL & Python to evaluate content performance and identify any current issues; used data-driven methods and generated weekly data reports for PMs, which drove operational performance and enhanced efficiency
- Collaborated with other 2 data analysts to design and implement dashboard via PowerBI on content performance and population portfolio. Leveraged automation and saved 3+ hours a week.
- Generated data reports via Excel and prepared presentations through Microsoft Powerpoint on weekly basis to share data-driven insights with PM and other departments
- Conducted market research and competitor analysis to identify trends and opportunities in online educational content market, and provided recommendations for content improvements and strategies to stay ahead of competition.
Education
Bachelor of Science - Double Major in Statistics And Psychology
University of Toronto
Toronto, Ontario, Canada06.2022
Skills
- SQL
- Python (Numpy, Panda, SciPy)
- PowerBI
- Microsoft Excel
- R
- Microsoft Powerpoint
- HTML/CSS
- Communication
- Organization Skills
- Leadership
- Data Models
- Data Management
- Problem Solving
- Product Management
- Workflow Optimization
- Quantitative Analytics
Timeline
Data Analyst
Adonis Partners
08.2022 - 10.2023
Business Analyst
Chestnut Residence (University Of Toronto)
08.2021 - 08.2022
Data Analyst Intern
Bytedance (Company of TikTok)
05.2021 - 08.2021
Bachelor of Science - Double Major in Statistics And Psychology
University of Toronto
Similar Profiles
KOMAL DARPANKOMAL DARPAN
CASHIER / CUSTOMER SERVICE REPRESENTATIVE at AdonisCASHIER / CUSTOMER SERVICE REPRESENTATIVE at Adonis
Anthony PageAnthony Page
Client Care Coordinator at Adonis Health (Henry Meds)Client Care Coordinator at Adonis Health (Henry Meds)
Mariia ZaikaMariia Zaika
Intern at microbiology laboratory at Adonis UAIntern at microbiology laboratory at Adonis UA
Yannes LamYannes Lam
Hostess Lead at The Steak House, Regent Hong KongHostess Lead at The Steak House, Regent Hong Kong
Marc YanMarc Yan
Sales Manager at AUB LtdSales Manager at AUB Ltd