Business Analyst, SQL Power BI ERP Data Reporting

Qiushi(Ashley) Zhao

Business Analyst SQL · Power BI · ERP · Data Reporting

540-***-**** **************@*****.*** linkedin.com/in/qiushiz Pittsburgh, PA Business Analyst with 4 years of experience in incentive tracking, pricing analysis, and SQL-based financial reporting. Proficient in Excel and Power BI, with experience in SAP and Oracle ERP environments. Skilled in identifying performance trends, supporting contract compliance, and collaborating across teams to deliver insights. WORK EXPERIENCE Business Systems Analyst Mar 2024 – Present

ZZY Consulting Inc.Pittsburgh, PA

● Built 300+ Excel dashboards and Power BI visualizations to track KPIs, improving data-driven decision speed by 20%

● Managed data collection methods using SQL queries, increasing data analysis efficiency by 15%

● Supported ERP system updates and data migration, ensuring 99% accuracy for operational analyses ERP Analyst Mar 2023 – Dec 2023

HAND Enterprise Solution Co. Ann Arbor, MI

● Automated financial processes using Oracle Cloud ERP, reducing manual tasks by 25% and ensuring audit-ready workflows

● Partnered with 8 teams to implement SAP S/4HANA solutions, enhancing supply chain efficiency by 20%

● Processed 10,000+ data points in SQL Server to generate actionable financial reports Data Systems Analyst Oct 2022 – Apr 2023

Grand Valley State University Allendale, MI

● Designed 20+ Tableau dashboards to monitor faculty salaries and budgeting metrics, streamlining resource allocation for departmental planning

● Analyzed 10,000+ library data points using Python to optimize assessment workflows, reducing manual analysis time by 15%

● Administered MySQL faculty database, ensuring accuracy in payroll and budgeting data while maintaining audit-ready records

Business Intelligence Intern Jun 2022 – Aug 2022

University of Michigan Ann Arbor, MI

● Conducted SQL analysis of customer purchase patterns, driving targeted promotions and achieving a 12% increase in sales

● Created Power BI dashboards to track order fulfillment KPIs, cutting decision-making time by 25%

● Partnered with marketing and finance teams to align promotional strategies with inventory data, enhancing customer satisfaction by 15%

EDUCATION University of Michigan Aug 2021 – Dec 2023

M.S. In Information Science (GPA: 3.83/4.0) Ann Arbor, MI Virginia Tech Aug 2017 – Dec 2020

B.S. In Business Information Technology Blacksburg, VA SKILLS Data Analytics & Visualization: Excel (Advanced), Tableau, Power BI, Python Database Management: MySQL, Oracle, SQL Server

ERP & Procurement Systems: Oracle ERP, SAP Coupa Methodologies: KPI Tracking & Reporting, Process Automation, ETL, Data Integrity Operations: Financial Reporting, Audit Support, Cross-Functional Collaboration CERTIFICATION Graduate Certificate in Health Informatics University of Michigan 2023

Contact this candidate