AI Email-to-Task
Summarizes incoming emails, extracts follow-ups, and creates tasks for ongoing tracking across the Business Analyst team.
Generative AI · Workflow automation · Team adoption
Portfolio
Max builds quiet, well-made data systems.
Business Intelligence Analyst in New York. I turn business questions into trusted analytics, useful tools, and AI-powered workflows that teams use every day.
- Location
- New York, US
- Focus
- Business analytics · Data systems
- Approach
- Understand · Build · Validate · Adopt
My colors
YEP, THAT'S ME
Scroll
Introduction
I like systems just like the way I live —
simple on the surface, considered underneath.
I'm a Business Intelligence Analyst at Vida Shoes International, working across consumer and retail operations. I translate questions about sales, margins, inventory, and returns into clear metrics and useful tools — from self-service Power BI dashboards to Python applications.
Reliable answers start beneath the dashboard. I work with stakeholders and engineering partners to define business rules, validate reporting data, and deliver a Microsoft Fabric migration. I also built and continue to enhance a DuckDB lakehouse for everyday analytical work.
I'm bringing AI into workflows people actually use: email summaries and follow-up tasks for our BA team, plus Python automations built with departmental stakeholders. My work runs from requirements and development through validation, training, and adoption.
Skillset
Selected Projects
Evidence-Checked AI Analyst
A personal project: an LLM answers questions over a SQL archive using only 11 fixed, read-only tools. Every number it cites is checked against the query results before the answer is shown, with a full trace of the SQL behind it.
LLM tool calling · Python · SQLite · Evidence checks
Source on GitHub ↗Operational DuckDB Lakehouse
Built and continue to enhance a version-controlled lakehouse: Python ingestion and transformation across eight data sources, reusable business logic, and validation for analytical work.
DuckDB · Python · SQL · Git
Sanitized source on GitHub ↗Analytics People Can Use
A centralized Power BI hub with 15 dashboards for 100+ users. Standardized reporting, row-level security, and training helped reduce ad-hoc reporting requests by 60%.
Power BI · DAX · Self-service analytics
Fabric Migration & Validation
Lead business requirements and validation with external engineering partners, defining Gold-layer business logic for 200+ reporting fields and aligning outputs with financial reporting requirements.
Microsoft Fabric · Business rules · Data validation
Executive Reporting Workflows
Version-controlled Python and SQL workflows automate four recurring C-suite reports, eliminating approximately 50 hours of manual preparation per month.
Python · SQL · ETL
Inventory Anomaly Detection
A Python and Streamlit application that surfaces inventory lifecycle anomalies and asset inefficiencies for business review and investigation.
Python · Streamlit · Inventory analytics
Resume
YANCHENG “MAX” XIANG
yancheng.xiang@hotmail.com(631) 913-5470
Business Intelligence Analyst with retail and consumer experience translating business needs into actionable insights, self-service analytics, and automated workflows. Hands-on experience in SQL, Python, Power BI, Microsoft Fabric, ETL, data governance, and generative AI-assisted development. Partners with cross-functional stakeholders to improve data integrity, deliver reusable analytics tools, and drive adoption of AI-enabled workflows.
Skills
Analytics & Programming: SQL / T-SQL, Python (Pandas, NumPy, Streamlit), DAX, Power Query
Business Intelligence & Data: Power BI, Tableau, Microsoft Fabric, DuckDB, ETL, Data Modeling, Data Validation, Data Governance, Self-Service Analytics
AI & Automation: Claude Code, LLM, Generative AI, AI-Assisted Development, Prompt-Driven Workflow Automation
Professional Experience
Vida Shoes InternationalNew York, NY
Business Intelligence AnalystMay 2024 – Present
- Commercial Analytics & Business Insights: Partner with 10+ stakeholders across Finance, Planning, Operations, E-commerce, and Production to translate sales, gross margin, inventory, order, and shipment questions into actionable analytics supporting management reporting across $400M+ annual revenue.
- Inventory Anomaly Detection & Cost Optimization: Analyzed inventory-turn performance to identify slow-moving SKUs, segmented inventory by aging buckets, and quantified monthly carrying costs across 113K+ pairs, identifying over $2.5M in inventory investment exposure; presented actionable recommendations to leadership that informed inventory and assortment decisions.
- End-to-End Self-Service BI Delivery: Owned the full lifecycle of a centralized Power BI analytics hub, from stakeholder requirements gathering and solution design through development, data validation/UAT, deployment, and user training; delivered 15 dashboards serving 100+ users and reduced ad-hoc reporting requests by 60%.
- AI Enablement & Process Automation: Partner with departmental directors to identify repetitive business processes and design, develop, test and deploy 6 AI-enabled workflows and Python automations, with multiple solutions adopted for recurring operational use, saving approximately 10 hours of manual work per week.
- Lakehouse & Analytics Engineering: Built and continue to enhance a version-controlled DuckDB medallion lakehouse integrating 8 data sources through Python-based ingestion and transformation, reusable business logic, and data validation to support Power BI analysis and ongoing LLM-based self-service analytics agent prototyping.
- LLM-Powered Workflow Automation: Built LLM-powered email-to-task workflows that summarize incoming emails, extract actionable tasks, and support ongoing task tracking in planner across the Business Analyst team.
- Executive Reporting Automation: Developed version-controlled Python, SQL, and ETL workflows to automate 4 recurring C-suite reports, reducing data latency by 80% and eliminating approximately 50 hours of manual processing per month.
- Fabric Migration & Data Validation: Lead business requirements gathering and validation for a Microsoft Fabric migration, partnering with external data-engineering consultants to define Gold-layer business logic for 200+ reporting fields and align analytics outputs with financial reporting requirements.
Graham WindhamBrooklyn, NY
Performance Analyst (Contract)Dec 2023 – Jun 2024
- Automated Workforce Reporting: Integrated Power BI with SharePoint to build 3 operational dashboards; established daily refresh schedules to provide real-time visibility into workforce metrics.
- DAX & Query Optimization: Refactored complex DAX measures and optimized Direct Query connections; reduced dashboard load times by 30%, significantly enhancing user experience.
- Cross-Functional Analytics Delivery: Partnered with department heads across four departments to gather business requirements, prioritize enhancements, and roll out self-service analytics solutions, delivering 14 stakeholder-driven improvements.
Education
Simon Business School, University of RochesterRochester, NY
M.S. in Business Analytics (STEM-Certified Program)Dec 2023
Stony Brook UniversityStony Brook, NY
M.B.A in MarketingMay 2022
B.A. in Economics, Minor in Applied Math and StatisticsMay 2020
Contact
Want the longer version?
Say hi →