Fidan Shiraliyeva

Data Analyst @Chalhoub Group

Toronto, ON, CA

Efficient Frontier Portfolio Optimization - Python* Built an efficient frontier model in Python using five years of historical equity data to quantify risk–return tradeoffs across 10+ global stocks.* Applied mean–variance optimization and integrated a custom R&D-to-Revenue factor for pharmaceutical companies to test innovation-linked risk premiums.* Incorporated Sharpe ratio analysis to identify optimal portfolios and visualized efficient asset allocations using Matplotlib.Pharmaceutical Revenue Analysis – Python, SQL, Tableau* Automated data extraction and transformation workflows in Python across five large revenue reports, cutting manual preparation time by 2–3 hours per dataset.* Queried and cleaned datasets using SQL to consolidate multi-year pharmaceutical revenue (2020–2024) across 50+ drugs and therapeutic classes.* Developed Tableau dashboards visualizing revenue trends to highlight top-performing drugs