Robert Kudera Email & Phone Number

Katowice Metropolitan Area

SQL, Oracle, SQL Developer, DBeaver, Snowflake, Power BI,Google Analytics, Google Optimize, Data Studio, Google Tag Manager, datalayer,SalesForce, Marketing Cloud, Journey Builder, Interaction Studio,Google Analytics <-> SalesForce integration,Wordpress, Umbraco,A/B tests (end to end), experiments, CRO (conversion rate optimization),Postman, API, json, Miro, monday.com, Hotjar, Figma, draw.io, QA, Jira, agile, kanban, Teams, slack.

Remote - Katowice, Silesian District, Poland

London, United Kingdom

London, United Kingdom

London, United Kingdom

Communication with various business partners including senior stakeholders is fundamental aspect of the daily work. The role comprises wide range of data related tasks:- Created prototype dashboards in Tableau platform for CFG Globally.- Tested Alteryx with Power BI and Tableau.- Data extraction, manipulation, analysis and governance. Generation of data related documentation.- Sole responsibility for data analysis for Corporate Finance monthly newsletter and other thematic research reports published by CFG EMEA team.- Maintained and improved internal databases and helping to improve and integrate systems and processes.- Provided weekly/monthly MI reports on business performance to senior stakeholders.- Created automated solution for compendium publications (connected SQL database via Excel add-in with Word using Mail Merge feature).- UAT for internal Financial Excel add-in - worked with developers to resolve performance issues.- Recorded road map for existing data collection process and assisted with migration to automated web solution based on SQL server.- Designed front-end layout and data logic for global CFG project.- Presented to senior management (EMEA region and globally).- Created global solution for forecasting analytical units - adopted by Business Planning.

London, United Kingdom

Amazon marketplace seller in DVD, Blu-ray category.Working with WooCommerce and Magento platforms.

London, United Kingdom

Supported several departments with data analysis, reporting, accurate and timely information on stock levels and movements using Sage 200 and custom Excel reports. Created advanced report in Excel (based on SQL query) that improved visibility of 'free to sell' stock. It affected sales increase. Daily workload contained following tasks:- Creating reports and data analysis based on SQL queries to Microsoft SQL Server RDMS (familiar with SELECT, JOIN, Pivot, CTE, Derived Tables statements),- Liaising with external partner on creating customized Sage reports as required (using Report Designer and Crystal Reports) - amending reports when as required,- Using advanced Excel functions on daily basis (vlookup, pivot tables - familiar with Power Pivot Table, basic VBA skills).

London, United Kingdom

Solely responsible for day-to-day running ecommerce business.- Analyzed expenses, logistics, fulfillment and sales to achieve optimal revenue.- Researched and implemented new approach to business operation - introduced order fulfillment process – significant costs cutting solution.- Created Excel file to control stock (availability and prices) and orders - based on vlookup function.- Manipulated data feeds from suppliers and affiliate network using macros in Excel to create relevant stock feeds for amazon platform.- Uploaded and updated products in all ecommerce channels using data feeds.- Maintained smooth and professional relationship with supplier and customers.- Managed company’s accounts on amazon platforms (Germany, France) and ebay.de – stock control, processed payments, orders and provided customer service.

Remote

- Provided services for Staudt Enterprises GmbH –online retailer/wholesaler/ book publisher based in Switzerland.- Produced weekly, monthly sales reports (used Excel pivot tables).- Generated various reports as required by management.- Processed orders from all ecommerce channels - worked on Afterbuy.de System – ecommerce orders managing software.- Controlled stock levels with semi-automated Excel spread sheet.- Uploaded and updated products in all ecommerce channels using data feeds.- Prepared bank statements for accounting department with semi-automated Excel file (matched invoices with bank statement positions).- Designed, tested and implemented in-house repricing software for amazon.- Prepared and placed orders with UK suppliers.- Liaised with existing and sourced new suppliers in UK for entertainment products (DVD, CD, Blu-ray).Sep 2009 - Oct 2010 General Manager for Staudt Enterprises GmbH (branch in Poland)- Sole responsibility for running day-to-day operation.- Organized logistics operation (warehouse and office) in Poland for Staudt Enterprises GmbH.- Improved services provided by previous logistics operator (Arvato Pratteln), by adjusting it to company’s needs and for lower costs.- Located, organized and equipped warehouse and office space. Tested and sourced appropriate Inventory Management system. Liaised with tax advisers and accountants.

London, United Kingdom

- Created custom Excel reports (based on SQL queries) for Sales, Credit Control and Finance departments as required.- Prepared monthly sales analysis and travel packs for directors.- Created monthly international sales and team performance reports for Export Sales team.- First point of contact for few international customers (B2B).- Provided high standard of customer service to ensure business growth.- Dealt with queries related to orders, product, payments, price negotiations and shipping in a timely and efficient manner.- Processed orders, created invoices, worked on tight daily deadlines (cut-off times for couriers).- Interacted effectively with key contacts within company when dealt with queries: Credit Control – chased up customers for payments; Buying department – negotiated prices for bulk deals, learned basics of the buying process; Returns department – dealt with return requests.

Tychy, Silesian District, Poland

Practical degree work experience in Technology department in Delphi Automotive Poland.- Assisted in last stage of new product launch (steering column for Fiat Panda).- Conducted several different tests on prototype parts and presented results in Excel to project manager.