Yiru Zhang

Yiru Zhang

Business Data Analyst Intern
Canada

About Me

Advanced Proficiency in SQL, MySQL, SQL Studio, Microsoft Office, Tableau, Power BI & Python (basic level)
• Passionate Data-Driven Business Analyst with 1+ year of experience in Accounting, Financial report…

Experience

Business Data Analyst Intern

Norton Tech, Waterloo, ON
Sep 2022 - Oct 2022 · 1 month

Elicited and maintained business requirements documentation (BRD).
Translated imperative objectives into comprehensive project plans including requirements, milestones, and key stakeholders’ responsibilities.
Assisted strategy execution, tracked project status, and provided regular updates to project stakeholders.
Established two-way working relationships with internal partners and supported communication for application and system integration, development, and deployment.
Participated in testing, validating, and creating artifacts to assist deployment of solutions to production environment.
Supported development of automated self-serve dashboards using Tableau.
Provided highlighted Key Performance Indicators (KPI) such as customer segmentation, sales, customer preference, and other financials.
Conducted 10+ ad-hoc requests in MySQL.
Presented visualized reports using Power BI to support marketing strategies.
Supported portfolio analysis using analytical concepts such as supply and demand analysis, product design, customer acquisition, revenue model, and competitor/SWOT analysis.
Performed regular checks for industry latest features, best practices, and advancements that could be impactful.

Operations Analyst

NYU Snackhut Corporation, Waterloo, ON
Sep 2019 - Dec 2019 · 3 months

Established Excel model by utilizing data generated from Sales Team.
Developed insightful sales reports and presentation to aid management decisions.
Built periodic financial reports via Excel and provided maintenance on a regular basis to ensure smooth process.
Delivered customer services through answering numerous calls on daily basis.
Understood customer needs and proactively addressed concerns.
Delivered assistance in a timely and effective manner.

Skills

Financial Analysis Financial Reporting Budgeting and Forecasting Data Model Project Control SQL MySQL SQL Studio Microsoft Office Tableau Power BI Python Accounting Financial reporting Budgeting Forecasting Economic Modelling Project Management Agile Capital Markets Communication Quick Learner Innovation Problem-Solving Collaboration Critical Thinking Excel Business requirements documentation Project planning Stakeholder management Application integration System integration Testing Validation KPI dashboards Marketing research Historical sales analysis Revenue modeling Competitor analysis Portfolio analysis Supply and demand analysis Product design Customer acquisition SWOT analysis Data cleaning Random forest KNN Multilinear regression ETL QA Feature engineering Model selection Performance assessment Deployment Reporting
Report this Profile?