Agata Guziur

PROFESSIONAL SUMMARY Highly driven and ambitious individual, who embraces change, with extensive experience in management accounting and reporting. Strong understanding of supply and retail environment with good commercial awareness. Key abilities are strong analytical and problem-solving skills. Comfortable with raw data mining and analysing large data sets. Also passionate about new system implementation and data modeling. Self-starter, always looking to improve and grow in both professional and personal life. WORK HISTORY 05/2021 - Current Varian Front End Developer, Power BI • Leading the development of a customer facing Power BI solution; prototype of which has been showcased at ASTRO 2021; the biggest Radiation Oncology conference in the USA. • Design of a new Azure SQL database and a star schema to support development of the customer facing solution. • Coordination and planning of technical testing for the database and reporting. • Leading the data quality testing. • Working closely with the inhouse UX designer to deliver the best UX and UI for the PBI solution. • Design and implementation of the appropriate geographical hierarchy in Sales Force, to support set up of security model for the customer facing solution. • Implementation of Power BI embedded solution and security model around it. • Design and implementation of power Apps as part of the customer facing product. 01/2019 - 05/2021 Greggs PLC Power BI Analyst • Participation in the new data warehouse and data model design for Retail, Commercial and Purchasing. • Regular evaluation of the content of the new data warehouse to ensure that Business needs are being met. • Leading the analysis required for legacy system decommissioning. • Prototyping, design, and deployment of the new Power BI reports for desktop and mobile. • Working closely with consultants to deliver product which complies with collected Business requirements. • Coaching of new team members and helping to set their training and development objectives. • Participating in and organising workshops with stakeholders to evaluate their reporting needs and translating business requirements into technical ones. • Maintenance and curation of the existing Oracle and SAP Business Object reports. 01/2017 - 01/2019 Greggs PLC Retail Capital Investment Analyst • Supporting Property Director, Retail Director, Heads of Retail and Head of Business Development. • Monthly and quarterly attendance and presentation at Investment and Property Board. • Budgeting and Forecasting for retail capital spend requirements. • Monitoring and reporting capital spend by activity type, New Shops, Refits, Re-sites. (C. £40M per annum) • Analysing and monitoring ROI on major retail capital projects. • Finance lead in 3rd Generation Shop development forum. • Developing the Equipment Lifecycle process and standardisation across different equipment categories; Working with maintenance to set replacement cycles for asset classes on a ‘whole life cost' basis. • Investment appraisal for sales enhancing equipment rollouts. 01/2015 - 01/2017 Greggs PLC Purchasing Finance Business Partner • Supporting Commercial Director; Head of Purchasing and Trading Team. • Quarterly attendance at the Trading Board. • Tracking, budgeting, forecasting, and reporting Internal cost inflation and profit margin at quarterly board meetings. • Accounting for rebates and automation of rebates processing in SAP; completion of the monthly and annual balance sheet and P&L reconciliation (Managing c. £4M budget). • Tracking “step-change” financial benefits. • New product costing down to raw material level and profitability evaluation. • Leading SAP costing module implementation. Working closely with external SAP consultants as the finance representative. Formalising new business processes, writing standard procedures and training finance and data team members to ensure successful deployment of the system. 01/2013 - 01/2015 Greggs PLC Commercial and Trading Finance Analyst