Looking for a job

Piotr Stalmach

@piotrstalmach

Data quality engineer at Essilor Optical Laboratory Poland who automated data imports and improved product mapping from 20% to 80%.

Poland

Message

At Essilor Optical Laboratory Poland, I govern reference data quality and the worldwide data Portal, helping engineering, production, marketing, and sales teams work with reliable data. I developed Python scripts that reduced human error by 10% and eliminated 404 errors from the Portal, and improved technical-to-commercial product mapping from 20% to 80%.

At Doktor Marchewka, I advanced from Logistics and Quality Manager through Customer Service Manager to Chief Technical Officer as the chain grew from 8 to 87 shops. I used data analysis to reduce warranty claims from 6% to under 2%, and created processes and materials that supported colleagues across the business. I also ran meshwizard.eu, a niche online shop, and at Różowe Okulary coordinated the rebranding and reopening of 12 optical shops.

Experience

Work history, roles, and key accomplishments

Current

Senior Master Data Quality Engineer

Current

Essilor Optical Laboratory Poland

Jan 2021 - Present (5 years 10 months)

Responsible for reference data quality, coherency, and product mapping and lifecycle for production and controlling. Trained 150+ employees, wrote internal procedures, and developed automation scripts to improve data governance.

Excel MS SQL Server HTML CSS VBA Python Power BI Data Governance Process Mapping BPMN

Owner

meshwizard.eu

Jan 2013 - Dec 2023 (10 years 11 months)

Created and managed a niche online shop in Prestashop, managed MySQL database for inventory and sales tracking, and wrote blogs and articles for European magazines.

PrestaShop MySQL Ecommerce Content Writing Social Media

Operations Managing Consultant

Różowe Okulary

Jan 2020 - Dec 2021 (1 year 11 months)

Coordinated rebranding and reopening of 12 optical shops, including restocking, IT, CRM, and data systems, ensuring day one business reporting with cost-effective tools.

CRM Data Systems Process Implementation Project Coordination

Chief Technical Officer, Customer Service Manager, Logistics and Quality Manager

Doktor Marchewka

Jan 2014 - Dec 2020 (6 years 11 months)

Scaled from 8 to 87 shops, developed from Logistics and Quality Manager to CTO. Optimized data processes, reduced warranty claims from 6% to under 2%, and coordinated launch of e-learning and incident tracking platforms.

Data Analysis Process Optimization Team Leadership E Learning GDPR Ecommerce Procurement Logistics Customer Service

Optical Laboratory Manager

World Optic Group

Jan 2011 - Dec 2014 (3 years 11 months)

Managed everyday operations of the Optical Edging Laboratory, facilitated supplier changes, and implemented a CRM system to improve data quality and reporting.

CRM Data Quality Reporting Sales Analysis Laboratory management

Education

Degrees, certifications, and relevant coursework

Warsaw University of Technology

M.Sc., Automation and Robotics

2004 - 2011

M.Sc. in Automation and Robotics with a major in Photonics Engineering - Optics in Science and Technology (with Erasmus Mundus). Thesis on image data analysis of refracted light patterns using Visual C++.