Data Analytics - ERP & Financial Systems Specialist

Yanguang (Joe) Zhou

+1-626-***-**** ********@******.***.*** LinkedIn

EDUCATION

CARNEGIE MELLON UNIVERSITY Pittsburgh, PA

Master of Science in Business Analytics – (STEM Major: Information Technology) 05/24 UNIVERSITY OF CALIFORNIA, SAN DIEGO San Diego, CA

Bachelor of Science in Probability & Statistics 09/18 SKILLS

● Workday Pro Record to Report Certification: Financial Management for Administrators, Financial Accounting for Administrators, Platform for Administrators, EIB, Reporting, and Adaptive Planning.

● Data Analytics & Programming: Python, R, SAS, and SQL for data manipulation, analysis, and automation

(ETL).

● Dashboarding & Reporting: Power BI and Tableau for data visualization, interactive dashboards, and business intelligence reporting.

● Statistical Modeling & Machine Learning: building and deploying Regression Models, Predictive Analytics, and Deep Learning models using PyTorch for data-driven decision-making.

● Other Tools: Hyperion Essbase Administration Services, Oracle Enterprise Performance Management, Azure DevOps Server

EXPERIENCE

City of Tucson Tucson, AZ

Business Analyst ( Workday ERP) 12/24 – Current

● Financial Systems & ERP Implementation: Assisted with the maintenance, upgrades, and integrations of financial systems, collaborating with IT and Finance teams on UAT, troubleshooting, and system enhancements.

● Business Process Optimization: Analyzed financial workflows, identified inefficiencies, and implemented updated business process strategies to streamline operations and improve efficiency.

● Project Management & System Enhancements: Supported ERP upgrades and process improvement initiatives, ensuring successful implementations and enhancements to financial reporting.

● Data Analysis & Reporting: Interpreted complex financial data to identify trends and discrepancies, building custom financial reports and dashboards to support strategic decision-making. First National Bank FNB Corporation Pittsburgh, PA IT Business Solutions Intern 05/24 – 08/24

● Anti-Money Laundering (AML) Project: Developed a deep understanding of AML processes and business rules, analyzing and interpreting SAS code to define risk metrics and lines of business (LOB).

● Data Management: Leveraged SQL on SQL Server Management Studio to develop AML solutions, ensuring data integrity and quality by validating results from SAS systems.

● ETL Implementation & Automation: Designed and implemented ETL/ELT processes using SSIS, creating automated workflows, and maintaining databases and servers.

● Dashboard & Reporting: Constructed dynamic AML dashboards in Power BI, enabling real-time monitoring of key risk metrics.

CORE Center for Organ Recovery & Education Pittsburgh, PA Analyst (Capstone Project)01/24 – 05/24

● Industry Research: Developed foundational market research perspectives for the organ donor and recovery industry, focusing on industrial trends and developments.

● Data Collection: Conducted comprehensive interviews with department employees to assess organizational capabilities and capacity.

● Workforce Analysis: Created a workforce capacity model using Tableau to inform strategic decisions regarding staff expansion or reduction.

XINSHUN LLC Denver, CO

Private Business Owner 10/19 – 08/23

● Financial Management: Developed and managed budgets, generated income and expense reports, and ensured compliance by updating tax and license documents for a personal health business.

● Marketing Analysis: Designed and implemented business strategies to attract new customers, increase store traffic, and boost profitability through customer and price analysis.

● Relationship Management: Addressed customer complaints and concerns professionally, fostering strong customer relationships and ensuring high levels of satisfaction. Royal Business Bank Los Angeles, CA

Risk Management Assistant 04/19 - 06/19

● Due Diligence: Updated, reviewed, and tracked Vendor Management contracts to ensure compliance with internal policies and government regulations.

● Compliance Monitoring: Prepared detailed reports by collecting, analyzing, and summarizing data for compliance purposes, including HMDA, Reg B loan tracking logs, flood insurance tickler logs, and mortgage lending activities.

ADDITIONAL

● Chinese (Mandarin)

U.S. Citizen

Contact this candidate