Alston Zeng

Conducted in-depth analysis of transactional data from over 30,000 smallholder farmers to identify patterns in transaction volume and size across farmer segments. • Simulated a 20% reduction in transaction frequency among “Very Low” and “Low” quantity farmers to assess its impact on transaction size and operational efficiency. • Built interactive Tableau dashboards to visualize changes in transaction size distribution and transaction count per farmer before and after simulation. • Applied data sampling and filtering techniques (e.g., using INDEX() logic in Tableau) to simulate behavior while preserving statistical distribution integrity. • Uncovered insights suggesting that incentivizing fewer, larger transactions could streamline operations without significantly impacting total volume. • Collaborated closely with team/advisor(s) to validate assumptions and iterate on visual storytelling for stakeholder presentations.

Monitored interbank lending rates (e.g. SHIBOR) and short-term investment product yields; supported fund allocation with real-time data. • Prepared daily and weekly liquidity reports using Excel (pivot tables, VLOOKUP) and automated portions with VBA, reducing reporting time by 25%. • Built rate tracking dashboards using Excel and Power BI to visualize interest rate spreads and counterparty positions. • Supported analysts in identifying short-term arbitrage opportunities by analyzing rate differentials and transaction timing.