Sophie Hanratty

Senior Analyst/Reporting Manager

lululemon•  August 2022 - September 2024•  Vancouver, BC

- Queried and analysed large-scale data sets, delivering actionable insights to leadership and cross-functional teams. - Managed all sales and performance reporting for North American wholesales business, continuously enhancing and automating where possible, using Excel & PowerBI. - Collaborated with executives and cross-functional teams to plan quarterly and long-term (1-5 years) revenue, sales, and budgets for North American account managers. - Analysed North American sales data to inform decision-making, AOP, business cases, and strategic planning. Built strong cross-functional partnerships with FP&A, Product, IT, BI, and Strategy to optimise reporting.

Performance Reporting Analyst, Supply Chain

Vancouver Fraser Port Authority•  July 2018 - June 2021

Developed and optimised reports using Tableau, Power BI, and Excel, acting as SME for technical reporting systems to ensure accuracy, resolve issues, and provide monthly performance insights and commentary to senior leadership, terminal operators, and rail carriers. Collaborated with technical teams to test and enhance blockchain systems, trained stakeholders, and acted as superuser and system administrator, ensuring ongoing maintenance and support. Communicated technical information clearly to non-technical stakeholders and senior leadership, bridging gaps and ensuring understanding of data and system updates.

Operations & Finance Specialist

Peaken Properties-Multiple Venues•  January 2016 - January 2018

Conducted sales and opportunity analyses and communicating with suppliers to optimise stock and maximise sales. Analysed staff and operations performance to maximise effective use of time and resources, e.g., reduced payroll administration time by 50% while making process more efficient. Accounts Payable, payroll and Analysis of weekly cash sheets and other financial documents using Excel.

Finance & Marketing Coordinator

Holy Family Community Creche•  January 2015 - January 2016

Organised various documentation and database management for non-profit crèche using Excel. Managed payroll for organisation using Sage Micropay. Handled social media and created promotional material for various events.