Péter Szerző

Worked in a London based team where created and owned advanced Tableau dashboards and their underlying data architecture showing insights on sales activity and sales performance to senior management for the entire EMEA region.

Developed complex end to end process automation solutions using VBA, Power Query and SQL. Maintained and enhanced existing Tableau dashboards.

Developed VBA tools for specific applications for example: -sending out emails with attachments from different paths, do manipulations on attachments, tracking the results -checking all excel files in given folders if they contain specific text (e.g. disclaimer) -updating macro codes for users (by VBA tool) Automated reports for clients and senior management that were produced manually before. Starting in August 2020, I divided my time between the Sales Automation and Sales Insights teams.

Brands: Shimano, Pearl Izumi, Lazer, Cube bikes and accessories. Managed the entire distributing process from strategic planning to sales. Did professional consultancy for customers. Developing and implementing a company-wide go-to-market plan, working in close collaboration with all departments to execute. Managed media coverage of the products. Specifying market requirements for current and future products by conducting market research supported by on-going visits to customers and non-customers. Did reports, plans and forecasts regularly.

Thesis: Modeling the connection of non-maturing deposit accounts and interest rates using time series analysis