Summary
Work History
Education
Skills
Certification
Generic
Mengdi Xu

Mengdi Xu

Spokane,WA

Summary

Data Analyst with 4+ years of experience specializing in SQL, Python, and Tableau, specializing in data pipeline automation, dashboard development, and ETL workflows. Adept at transforming raw data into actionable insights, improving business performance, operational efficiency, and decision-making.

Work History

Data Analyst Intern

United Nations
10.2024 - Current
  • Optimized data-to-insight workflows by enhancing a data pipeline for fact pack automation, reducing the time from data extraction by the presentation
  • Developed a Node.js website for dataset selection and downloads, automated chart generation with Think-Cell, and integrated APIs for seamless data retrieval
  • Automated data processing for World Bank updates using a Python script that downloads, decompresses, validates, transforms, and uploads data into an Azure database, improving data accuracy and reducing manual effort
  • Developed interactive Power BI dashboards for senior UN managers, improving real-time situational awareness of key global issues, including economic trends, conflict analysis, and human rights monitoring
  • Enhanced the data pipeline by integrating new datasets, improving the front-end UX, and optimizing Azure-based retrieval, reducing data processing time by 30%
  • Enhanced reporting efficiency by adding a module that retrieves, processes, and visualizes data, automatically generating PowerPoint reports with Think-Cell for high-impact presentations to UN leadership

Digital Asset Specialist

DirecTV
12.2021 - 12.2023
  • Increased the on-time on-air rate from 73% to 80% by developing an automated monitoring system for digital asset distribution on an Open Video system using Kibana, Python, and Postman, improving content availability and reducing delays
  • Analyzed key 4K, SVOD, and TVOD KPIs, identifying trends in processing times and on-air accuracy, leading to a 35% reduction in late content deliveries through work optimizations
  • Automated monthly digital asset inventory pipeline with a Python and SQL-based pipeline (MySQL and Oracle), reducing late or missing video titles by 80% and improving content tracking accuracy
  • Cut error detection time by 40% by designing an automated monitoring system using Python, Postman, and Kibana, leading to faster issue resolution and improved system reliability
  • Enhanced team efficiency by developing detailed runbooks, operational manuals, and workflow documentation, ensuring consistency in execution and reducing operational errors

Data Analyst Intern

Blue Cross Blue Shield
01.2021 - 11.2021
  • Ensured data accuracy and integrity by writing complex SQL queries to validate data consistency across MySQL and other databases, reducing discrepancies in critical healthcare datasets
  • Automated data validation testing using SQL procedures and Python scripts, increasing efficiency and reducing manual verification time by 20%
  • Performed in-depth data profiling and analysis using Python and R, identifying trends in claims processing, patient demographics, and cost utilization to support data-driven decision-making
  • Developed interactive Tableau dashboards with action filters, parameters, and calculated sets, enabling senior leadership to track key healthcare performance metrics, such as patient outcomes and operational efficiency
  • Transformed raw e-commerce data into structured datasets, improving the accuracy of predictive analytics models and enhancing financial reporting
  • Facilitated cross-team collaboration in an agile environment, working with data engineers and business analysts to optimize ETL workflows and improve report generation time by 15%
  • Streamlined reporting automation by building customized Tableau dashboards (pie charts, bar graphs, trend analysis) and integrating scheduled reporting on Tableau Server, ensuring real-time updates for stakeholders

Data Analyst Intern

Dell Technologies
08.2017 - 07.2018
  • Utilized Agile methodologies to streamline project workflows, enhancing team efficiency and delivery
  • Created complex SQL queries for data validation, ensuring data integrity across platforms
  • Developed and optimized MySQL stored procedures, enhancing query performance and data retrieval speeds, leading to a 15% improvement in reporting efficiency
  • Designed interactive Tableau dashboards customized for internal stakeholders and clients, improving data visibility and decision-making
  • Automated operational monitoring by implementing Python-based notification tools, reducing manual oversight and improving system reliability

Education

Doctorate of Information Technology - Information Technology

Trine University
Detroit, MI
05-2028

Master of Science - Data Analytics

University of Pittsburgh
Pittsburgh, PA
05.2021

Master of Public Administration - Policy Research and Analysis

University of Pittsburgh
Pittsburgh, PA
05.2021

Skills

  • Python
  • Java
  • GO
  • JavaScript
  • R
  • Pandas
  • NumPy
  • Matplotlib
  • Tidyverse
  • STATA
  • MySQL
  • Oracle
  • AWS
  • S3
  • Excel
  • Pivot Table
  • VBA
  • Power Query
  • ServiceNow
  • Jira
  • Agile
  • SDLC
  • Linux
  • Tableau
  • Power BI

Certification

  • Tableau Desktop Specialist
  • Microsoft Certified: Power BI Data Analyst Associate

Similar Profiles

CREATE PROFILE
Mengdi Xu