Data Analyst Power Bi

JIAYI (YISA) WU

****.**.****@*****.*** 226-***-**** 30 Shore Breeze Dr, Toronto, ON Linkedin

HIGHLIGHT

Detail-oriented Data Analyst with expertise in business intelligence, data visualization, and reporting solutions. Experienced in designing and maintaining Power BI dashboards, integrating diverse data sources, and driving operational efficiency through actionable insights. Adept at collaborating with business partners to translate data needs into technical solutions that align with business objectives. Passionate about fostering innovation and continuous process improvement in data-driven environments. SKILLS

● Technical Expertise: SQL, Python, R, Tableau, Power BI, Looker Studio, Spark, Google Cloud Platform, AWS, Excel/VBA

● Specialized Skills: Data Visualization, ETL Process, Agil Project Management, Communication & Presentation EDUCATION

Master of Data Analytics, Western University, London, ON 2024/09 - Expected 2025/08 Bachelor of Science, University of Toronto, Toronto, ON 2019/08 - 2023/06 Double Major in Statistics and Economics, graduated with Honors PROFESSIONAL EXPERIENCE

Data Analyst, OpenTeam.AI, Toronto, ON 2024/03 – 2024/08

● Designed and maintained interactive Power BI dashboards, integrating data from multiple sources, improving visibility into real-time sales trends, and driving a 20% increase in client subscriptions.

● Built and optimized a customer master table on Google BigQuery, reducing data processing time by 25% and supporting enhanced tiered fee analysis and rebate calculations.

● Collaborated with cross-functional teams to define business requirements and deliver insights through data visualization and segmentation analysis, driving a 100% growth in new client engagement within 4 months. Data Analyst Intern, Industrial and Commercial Bank of China, Shanghai, CN 2023/05 - 2023/12

● Built and maintained structured datasets, reducing processing time by 25%, to support fraud detection algorithms

● Conducted financial data analyses using Excel & SQL, resolving over 2,000 records for fraud prevention, ensuring data integrity

● Developed, compared, and implemented machine learning models for fraud detection and classification, achieving a 13% Precision improvement and enabling regulatory compliance

● Further enhanced model performance by utilizing SMOTE technique to resolve imbalanced training and testing data sets, resulted in ~12% improvement in the model performance

● Designed actionable data visualizations in Tableau, enabling proactive fraud risk management monitoring and alerting system Assurance Practice Intern, PWC Inc., Shanghai, CN 2020/12 - 2021/01

● Automated the source data validation processing using Python & SQL, identified and resolved over 800 data issues

● Streamlined data preprocessing with Python, integrating data from 30+ sources into 3 master tables for auditing

● Collaborated with cross-functional teams, including accountants and clients, extracted key financial information from bank statements, validated with client provided information, and presented discrepancies and findings to senior management team Business Intelligence Intern, Baneks Inc., Toronto, ON 2019/06 - 2020/06

● Spearheaded market research by conducting users survey targeting at international students and new immigrants, collected over 4000 user data points and identified the best channel for the highest click-through rate

● Designed and executed A/B testing regarding new features release, monitored KPI metrics and identified the opportunity for user click thru rate enhancement

● Analyzed and visualized survey result data in Excel and R, discovered valuable trends in average exchange amounts and preferred channels, enabled data-driven strategies that contributed to the App's resounding success with a 4.5-star rating VOLUNTEER ACTIVITIES

Industry Research Project Leader, ETC Investment Association 2022/02 - 2023/02

● Led cross-functional teams in conducting segmentation analysis to identify high-risk financial transactions

● Organized training sessions for 500+ students on fraud prevention strategies and cybersecurity fundamentals

Contact this candidate