Data Analyst Analysis

Mengxia Zhang

617-***-**** *****.*****@************.***

Newton, MA 02460

Skills

SQL (SQL Server, MySQL)

Python (Pandas, NumPy, Matplotlib)

Tableau / Power BI

Excel (Functions, Pivot Tables, Macro)

BI: ETL, Data Modeling, Data Retrieval & Organization, Statistical Analytics & Data Interpretation, Pattern Recognition, Data Visualization

PM: Agile & DevOps, SDLC, PRD, User Stories, Product Roadmap, Requirement Prioritization

Certificate

Google Business Intelligence Professional Certificate Introduction to Microsoft Azure Cloud Service

Work Experience

Data Analyst – YTO Express (Logistics) Co., Ltd. – Shanghai, China Sep 2017 - Aug 2021

●Developed and optimized SQL queries for efficient data retrieving, cleansing, organization, and interpretation.

●Built automated analytics ETL pipelines with SQL and Excel for generating routine reports.

●Created Dashboards and Reports to provide real-time insights into business KPIs to support decision-making.

●Conducted ad-hoc data analysis with SQL across business volumes, financials, and customer information.

●Monitored corporate quality control data, including customer complaints, and resolved issues through root cause analysis, resulting in a 25% improvement in quality control.

●Mentored less experienced analysts and interns in data cleaning, analyzing, and visualization.

Product Owner – YTO Express (Logistics) Co., Ltd. – Shanghai, China Oct 2017 - Dec 2018

●Gathered stakeholders’ requirements and translated them into actionable user stories to ensure stakeholders buy-in.

●Acted as a liaison between IT and Business teams, overseeing project progress and resolving ad hoc issues.

●Achieved 98% of project goals by organizing two-week sprints and effectively communicating the product vision to engineers within the given timelines.

Teaching Assistant – Northeastern University – Boston, MA Jul 2023 - Dec 2023

●Collaborated with the instructor to revamp lectures for the course "Accounting and Budgetary Systems for Engineers".

●Provided support to students during TA hours, addressing their questions and concerns related to course materials.

●Assisted in grading assignments and quizzes, offering constructive feedback to encourage student improvement.

●Contributed to the design of course materials, including assignments and quizzes, to enhance the learning experience.

●Acted as a liaison between students and the professor, promoting an efficient and positive learning environment.

Projects

Microsoft Azure – Course Project – Boston, MA Jul 2022 – Aug 2022

Conducted in-depth analysis of Microsoft Azure Cloud Services, including resource utilization, cloud platform performance, and cost allocation to identify areas for improvement and optimization.

Developed a detailed SWOT analysis and Scorecard for Microsoft Azure platform.

Performed Azure Cloud cost analysis, including detailed breakdowns, allocation analysis, and generated estimated cost reports.

Delivered a comprehensive Project Requirement Document (PRD) for Microsoft Azure

Covid Analysis – Personal Project (Portfolio Projects) – Boston, MA Apr 2023 – May 2023

●Gathered data from government websites and used Excel to clean and organize the raw data.

●Utilized SQL for in-depth exploratory data analysis of COVID-19 cases, mortality, testing rates, and other variables to uncover characteristics and trends.

●Optimized reporting process by using aggregating, filtering, and windows functions.

Education

Master Of Science in Information Systems –Northeastern University –Boston, MA Sep 2021 – May 2023

Core courses: Project Management; Software Quality Control; Accounting & Budget for Engineers; Application Development (Java)

Bachelor Of Arts in Logistics Management –Southeast University Chenxian College –Nanjing, China Sep 2012 – Jun 2016

Core courses: Statistics; Advanced Mathematics; Business Analytics; Operations & Supply Chain Management; International Business

Contact this candidate