• Led a team of two analysts ensuring timely delivery of analysis and reporting, with high quality analysis, accurate results and recommendations.• Developed and owned the corporate market sizing methodology for the Canadian legal cannabis markets, leveraging internal and public data on demographics and consumption.• Supported the international medical market sizing, working with a third party on the development of the framework and methodology for application to different countries.• Managed the application of statistical and machine learning tools to medical cannabis data for portfolio and product mix optimization.• Led the external retail data intake, analysis and reporting through data visualization tools.

• Prepared monthly and quarterly analysis and reports of supply chain performance and KPIs, including commentary to support analysis and recommendations. • Developed the revenue model and forecasts, providing support to ongoing pricing negotiations.• Worked with multiple teams across the organization to provide business context and operational explanations to the data.• Subject matter expert in data modelling, statistical analysis and third party data sources.• Worked with data extraction, compilation and analysis from online websites and structured and non-structured data sources.

• Developed segmentation strategies using regression trees applied to the delinquent accounts using observation and performance periods.• Provide governance and oversight to risk segmentation strategies and collections treatments in the markets. • Supported local teams on generating statistically driven strategies and collections models that provide actionable insights to optimize profitability via reduction of WOs and cost to collect and increasing recoveries. • Managed and automated monthly production of the Collections Dashboard across sites.

• Random selection: developed a tool for random selection with replacement and without replacement using Excel and VBA. This tool is updated and used every month to randomly select waste collectors.• Hypothesis testing and confidence intervals: applied hypothesis testing to waste studies to validate significant differences between years and between stages of the recycling process (from collections to the sorting process).• Regression analysis: applied regression analysis to revenue data to validate trends.• Arima: used R to fit arima models to commodities prices to estimate the annual revenue.• Excel and VBA modelling: created Excel models with VBA macros to compile data from websites and automatically apply business rules. This model is used by CSSA and one external service provider.• Created an Excel model using SAP Analysis for Excel, complemented with VBA macros to apply complex business rules to the calculation of revenue.• Geographical distance models: used Excel, VBA and Google Maps api to calculate the distance of more than 3000 collection sites to the processing facility. These results were used to calculate the incentive rates paid to waste collectors, according to their zones.• Sample size calculation: Calculated a recommended sample size for all waste studies to optimize the desired margin of error in relation to the budget.• Developed a recommended methodology to be applied to the calculation of sample size for the different waste studies, optimizing the marginal gain in the precision for a given sample size.

• Developed, documented and tested Excel and Visual Basic Applications macros related software applications. Developed a point of sales system and an accounting system for Small and Medium Enterprises• Trained clients on the use of the applications. Supported and facilitated the learning process of each team. • Participated in the Apps for Development contest sponsored by the World Bank, using data sets in XML

• Managed the lingerie category at the customer level keeping the space and inventory level by controlling in-Stock inventory and rotation in branded stores and clients• Analyzed the demand and prepared monthly forecasts for Head Office, creating an Excel model that allowed the reduction of the processing time from 3 days to 1 hour • Increased stock rotation for each branded store using point of sales system information. Reduced inventory stocks from 60 to 45 days by adjusting inventory levels for each Sku according to corporate policies.• Budgeted the annual expenses for retail. Set the annual inventory targets by Sku and the annual sales targets, and executed marketing strategies to achieve the strategic goals• Prepared executive reports to be presented to the Board of Directors and to the Executive Team• Designed and programed a Time Clock in VBA, with a 30% reduction of overtime hours

• Coordinated and consolidated the annual budget• Tracked the actual vs. forecasted budget and analyze the balance, income and expenses variances• Analyzed the financial performance and profitability results by consolidating at the business line level• Automated the financial statement using Excel and Macros, reducing the processing time from 2 days to 2 hours• Designed and programed an inventory control for the customs regime using Visual Basic and MS Access.• Prepared management reports for Head Office and for the Executives• Posted expenses to the General Ledger