Roger fretelli

Build sales-forecasting and site-selection models for franchise expansion, capturing store density, win rate, cannibalization and synergy effects; use difference-in-differences to measure causal impact of new openings. Develop supply-chain algorithms including delivery route optimization and search and recommendation strategies.

Integrated the middle platform with third-party systems via Java Spring APIs and XXL-Job scheduling, removing data silos; automated key workflows with RPA. Built site-selection datasets covering ~1,000 shopping malls from public platforms, with feature engineering for location models.

Built the data platform from scratch, including a data warehouse integrating ERP, CRM and external macro data, deployed on Linux, Kubernetes and DolphinScheduler. Developed machine-learning site-selection models for expansion cities, supporting network restructuring that contributed to a 30% cost reduction.

Built sales and budget dashboards using Spring Boot and Vue.js, replacing manual Excel reporting. Automated finance and operations data consolidation with RPA, increasing management review frequency from once to three times per week.

Built an ML order-forecasting model linked to warehouse, logistics and sales-order systems, plus a material-substitution engine and web-based production scheduling. Cut inventory days on hand from about 360 to 180 and reduced working capital tied up in materials from RMB 130M to RMB 80M.

Managed two hybrid funds end to end, including research, trading and investor roadshows. Built quantitative investment models from scratch and DCF-based financial models supporting strategy allocation and index futures and options arbitrage.

Conducted industry research, financial analysis, valuation and on-site due diligence on listed companies; authored industry and company reports supporting investment decisions.

Completed a Master of Economics in Economic Statistics part-time while working full-time.

Earned a Bachelor of Economics in Financial Engineering.