Sergio Llobet Email & Phone Number

Pamplona, Es

County Dublin, Ireland

• Develop a scalable, automated reporting framework to enable channel and P&L owners to analysebusiness performance and identify commercial trends.• Ensure P&L performance trends are communicated and contextualised and opportunities for growth areidentified (across pricing, merchandising, sort order, and digital marketing initiatives) and prioritised.• Communicate trading outcomes, and the drivers of trading outcomes to key stakeholders; adapt and tailorcommunication style… Show more • Develop a scalable, automated reporting framework to enable channel and P&L owners to analysebusiness performance and identify commercial trends.• Ensure P&L performance trends are communicated and contextualised and opportunities for growth areidentified (across pricing, merchandising, sort order, and digital marketing initiatives) and prioritised.• Communicate trading outcomes, and the drivers of trading outcomes to key stakeholders; adapt and tailorcommunication style and depth to ensure stakeholder can interpret key messages• Conduct regular P&L performance “deep dives” on selected partner groups, delivering actionable insightsfor performance improvement, ensuring learnings are shared across the Commercial Analyst team.• Work with the P&L and Data Science to ensure test initiatives are implemented according to best practice,enabling actionable insights and interpreted correctly.• Create complex database objects like tables, views, procedures and functions with Snowflake and SQL Server to support reporting infrastructure and maintain data efficiently.• Build and publish customized interactive Tableau Desktop reports and dashboards, report scheduling using Tableau server. Show less

County Dublin, Ireland

• Analyse B2C Channels performance, ensure trends are communicated and contextualised, and opportunities for growth are identified and translated into actions in order to maximise profit and develop sustainable growth.• Communicate detailed trading outcomes and their key drivers through weekly/monthly narratives to wider audience (B2C Team, Insights Team CFO), ensuring stakeholders can interpret key messages.• Develop a scalable, automated reporting framework to support all the B2C… Show more • Analyse B2C Channels performance, ensure trends are communicated and contextualised, and opportunities for growth are identified and translated into actions in order to maximise profit and develop sustainable growth.• Communicate detailed trading outcomes and their key drivers through weekly/monthly narratives to wider audience (B2C Team, Insights Team CFO), ensuring stakeholders can interpret key messages.• Develop a scalable, automated reporting framework to support all the B2C Online Marketing Channels, which help identify trends and their drivers in a clear and easy way, enabling actionable insights.• Ensure data is reliable, comes from one data source and matches across all available reports in B2C.• Maintain and support complex SQL coding solutions both on SQL Server and Amazon Redshift to ensure the data is a) understood and b) validated/accurate for use in decision making.• Setting performance targets for PPC channels, outlining risk and opportunity for stretched targets. Show less

County Dublin, Ireland

· Develop complex reports, data visualizations and dashboards using Tableau Desktop· Create database objects (tables, views, procedures) using SQL Server · Analyse PPC channel performance (ROI, Sales) on a daily basis· Identify main drivers of performance, and take/suggest actions to improve it· Liaise with different departments for growth and performance improvement opportunities· Proactive approach to… Show more · Develop complex reports, data visualizations and dashboards using Tableau Desktop· Create database objects (tables, views, procedures) using SQL Server · Analyse PPC channel performance (ROI, Sales) on a daily basis· Identify main drivers of performance, and take/suggest actions to improve it· Liaise with different departments for growth and performance improvement opportunities· Proactive approach to opportunities to grow revenue· Competitor Analysis within market portfolio Show less

Dublin

· Regular performance reporting· Ad text creation & testing· Account and campaign structuring· Automated and manual bid management· Performance Analysis· Conversion tracking & optimisation· Implementing and assessment of beta tests· Liaising with search engine account managers for growth and performance improvement opportunities· Keeping up-to-date with… Show more · Regular performance reporting· Ad text creation & testing· Account and campaign structuring· Automated and manual bid management· Performance Analysis· Conversion tracking & optimisation· Implementing and assessment of beta tests· Liaising with search engine account managers for growth and performance improvement opportunities· Keeping up-to-date with industry trends· Competitor Analysis and benchmarking within market portfolio· Specialist and owner of market portfolio, including proactive recommendations to rest of team for non-PPC activities· Proactive approach to opportunities to grow revenue Show less

Dublin, Ireland

Managed Google AdWords Pay Per Click (PPC) campaigns for several fashion e-commerce sites.Created extensive and detailed SEM campaign proposals for clients, encouraging them to invest in Google AdWords.Analysed clients’ online shops presence in search engines, studied their competitors situation and wrote detailed guidelines and suggestions to improve their ranking (SEO).Created customized reports with Google Analytics to calculate key performance indicators, metrics and… Show more Managed Google AdWords Pay Per Click (PPC) campaigns for several fashion e-commerce sites.Created extensive and detailed SEM campaign proposals for clients, encouraging them to invest in Google AdWords.Analysed clients’ online shops presence in search engines, studied their competitors situation and wrote detailed guidelines and suggestions to improve their ranking (SEO).Created customized reports with Google Analytics to calculate key performance indicators, metrics and trends and configured funnels in order to optimize the checkout process of e-commerce sites and reduce their shopping cart abandon rate.Suggested changes to the clients to improve their websites/online shops’ usability.Created and sent email marketing newsletter for several clients on a weekly basis.Proposed and implemented improvements to the email marketing campaigns in order better target the potential customers online.Analysed traffic coming from online marketing campaigns for performance improvement.Worked on a number of actions to increase database of newsletter subscribers.Created and implemented apps for Facebook pages. Show less

Madrid, Spain

• Manage Online Store projects to completion. - Launch of new product families in the Online Store. - Implementation of new functionalities (up-sellings and cross-sellings, new payment methods, etc.).• Update online store content in a timely manner.• Creation of sales reports, evaluate site traffic data and main KPIs, monitor marketing campaigns.• Collaborate with different departments for new online marketing campaigns.• Creation of manuals and documentation of all… Show more • Manage Online Store projects to completion. - Launch of new product families in the Online Store. - Implementation of new functionalities (up-sellings and cross-sellings, new payment methods, etc.).• Update online store content in a timely manner.• Creation of sales reports, evaluate site traffic data and main KPIs, monitor marketing campaigns.• Collaborate with different departments for new online marketing campaigns.• Creation of manuals and documentation of all the procedures involving the online store.• Provide training and technical assistance in e-commerce platform use. Show less

Dublin, Ireland

• Tracked marketing campaigns and measured results.• Produced reports and followed up on the Online Store main KPIs.• Configured online marketing promotions. • Coordinated product launches in the Online Store.• Constantly edited and updated the Online Store.

Dublin, Ireland

• Provided technical support to the Ericsson employees by phone and e-mail.• Provided remote troubleshooting support (using VNC, PuTTY and OpenSSH).• Administered Windows 2000 Server trough Active Directory.• Met the customer satisfaction reaching the SLA (Service Level Agreement).• Logged issues (calls and e-mails) in the Help Desk database.• Dispatched work to other teams when needed.

Dublin, Ireland

• Hardware assembling (I-Series and Z-Series servers).

Pamplona, Spain

• Developed C# libraries (.dll).• Produced image editing software based on the .NET platform and other Windows applications.

San Sebastian, Spain

• Provided network maintenance and support.• Administered Windows 2000 Server trough Active Directory.• Gave software support to teachers and other university employees.• Installed and configured workstations under Windows XP, 2000 and Linux Red Hat.• Managed Hard Disk images using PXE (Rembo Wizard).• Hardware maintenance and computer assembling.

Msc In Computer Science, Computer Science

Education record