Lida Sun
Montreal,QC
Summary
Prudent Business Intelligence Analyst with 5 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
6
6
years of professional experience
Work History
BI Analyst
Avanquest
09.2021 - Current
- Plan and execute business intelligence/analytics projects by collaborating with business partners, data engineering, and data visualization teams, conduct regular data quality audits and analyses to ensure the accuracy and reliability of data and reports delivered to stakeholders, maintaining a high standard of data integrity and trustworthiness
- Evaluate and optimize marketing campaigns through A/B test analytics: engaged in an A/B test on two different email marketing campaigns, varying the subject lines and call-to-action buttons. Implementing these changes across all campaigns led to a significant increase in overall engagement and conversion rates
- Exercising advanced knowledge of SQL to extract critical information and business value from data spread across multiple databases and data formats, ensuring comprehensive analysis and actionable insights. Reduced report turnaround times by automating manual procedures through the implementation of efficient ETL workflows
- Provide advanced analytics support, including trend analysis and ad-hoc data projects, to uncover insights and propose solutions that drive marketing effectiveness and identify growth opportunities: proficient in statistics and key performance indicators (KPIs), including Lifetime Value (LTV) and Churn
- Bridged communication gaps between technical and non-technical stakeholders by translating complex data concepts into easily understood terms, fostering a shared understanding of project goals and objectives
Data Analyst
MindGeek
01.2019 - 01.2021
- Monitored and established early to lifetime Member Value (MV) for a game platform Nutaku, suggesting future trends through forecasting techniques to influence company-wide customer acquisition strategy and sales budget setting ($50 Million)
- Created Member Value database on Excel, visualization data by Power BI, data pulling through SQL queries; automated reports (VBA) for recurring delivery and rapid creation of new reports
- Conducted ad-hoc analysis to facilitate communication between Sales, Product, and Accounting/Finance Departments, providing timely analysis on requests such as problem sourcing, incident influence, and KPI investigation
- Analyzed A/B tests, manipulated databases (PowerPivot, SQL), and extracted/mined/visualized data (Cube, Excel, MYSQL, Power BI)
- Generated weekly, monthly, and yearly business reports with historical data from multiple internal and external databases, including product analysis, customer-related analysis, and user behavior analysis.
Education
Master of Science in Marketing -
John Molson Business School
Montreal, QCSkills
- Microsoft Packages
- Power BI
- SQL
- Google Analytics
- Project Management
- CRM platforms
- A/B tests
- Confluence/Jira
- Database relationship
- VBA
- Pivot tables
- Business intelligence tools
- Business Analysis
- Data Visualization
- DAX
- Data Modeling
- Big Query
- ETL development
Languages
English
Full Professional
Chinese (Mandarin)
Native or Bilingual
Timeline
BI Analyst
Avanquest
09.2021 - Current
Data Analyst
MindGeek
01.2019 - 01.2021
Master of Science in Marketing -
John Molson Business School
Similar Profiles
Marcio MelgarecoMarcio Melgareco
Project Manager / Agile Coach at AvanquestProject Manager / Agile Coach at Avanquest
Rajan TakiarRajan Takiar
Product Manager | Product Owner at AvanquestProduct Manager | Product Owner at Avanquest
Anzhelika KlimukAnzhelika Klimuk
Technical Sales Representative at Avanquest Pdfforge GmbHTechnical Sales Representative at Avanquest Pdfforge GmbH