Think. Build. Create.

Analyzed 24 months of ERP purchasing data across five material categories by volume, price and supplier and tracked 12 months of commodity trends in Qlik Sense.

Built a Power BI pricing matrix covering five marine-equipment competitors and 20+ SKUs across three growth markets.

Analyzed full-year P&L and transactions for a leading listed e-commerce client under US GAAP, decomposing quarterly marketing-rate trends and connecting sales-return volatility to distribution and service-fee economics.

Completed inventory counts and book-to-physical checks at five stores and tested roughly 300 source documents across procurement, expenses and fixed assets.

Followed up on 15+ bilingual confirmations and drafted 10+ workpapers with exception summaries.

Structured 2026 mid-year research on discount snacks, on-demand retail and overseas expansion into a demand–competition–efficiency–company framework and produced supporting datasets, visualizations and draft sections.

Independently prepared earnings analyses for Baiya and Chongqing Department Store, decomposing performance by product, channel, region and expense efficiency while maintaining earnings forecasts and relative valuation models.

Connected an AI agent to iFinD MCP for source retrieval, data collection and synthesis, while manually validating key data, assumptions and conclusions.

Supported corporate ABS and bond due diligence and issuance, organizing workpapers around transaction parties, underlying assets, cash flows and critical milestones.

Tracked exceptions and reconciled subscription, payment and issuance materials across documents.

Verified issuers through corporate registry, credit, litigation and Wind sources and benchmarked comparable bonds / ABS by tenor, yield and credit enhancement.

Supported 2026–2028 Hong Kong Sephora expansion planning for four prestige brands, translating store rollout, sales cadence, productivity, inventory turns and new-store investment into sales, gross margin, marketing / SG&A and customer contribution.

Analyzed media, KOL livestream and campaign spend across Douyin, Tmall and JD by brand, quarter, platform and resource type, comparing NSO, TR% and ROI to support budget allocation and post-campaign review.

Used LLM-assisted VBA to automate mapping, exception diagnosis and Open PO splitting, and built an interactive web dashboard over roughly 192K records, 20 fields and 12 brands.