Paweł Szulc
Development
Silesia, Poland
Skills
Data Analysis
About
Pawe Szulc's skills align with System Developers and Analysts (Information and Communication Technology). Pawe also has skills associated with Database Specialists (Information and Communication Technology). Pawe Szulc has 15 years of work experience.
View more
Work Experience
Data Operations Analyst Developer
C&F
November 2022 - January 2024
- Participated in Pfizer data integration project responsible for: * Business analysis - gathering and understanding business requirements through Jira tasks and meetings. * Data analysis - data mining in sources and down-streams, changing logic, finding KPIs - constantly using Snowflake SQL environment. * Development - data modelling: adding new tables/columns, new country waves, calculating impact of changes, branch merging to weekly releases using Microsoft Visual Studio and GitHub Actions. * Testing & QA automation - building "past data snapshot vs current data" tests to detect source data blow-up/vanishing, pre/post release testing * Reporting & Visualization for data operations team using Power Bi * Fixing UC4 Ripple processes (Alation) * Writing technical documentation and release notes in Confluence
Data Analyst
3Soft
July 2018 - September 2022
- * in last two years participated in development and data integration projects for e-commerce customers with 3Soft product "Occubee" - application designed for sales forecasting, demand management and stock replenishment. Worked on data extraction, transformation, mapping. Built and test processes, solved and reported problems * 3-4 years ago participated in data integration project for retail customer related to sales forecasting based on Big Data and Machine Learning. Audited customer data, solved and reported problems, worked closely with Data Science and DevOps on developing product improvements, verified data before rollouts * supported deployed projects, stayed in contact with customer country coordinators. Developed and maintain reports and presentations in PowerBi for various teams
Business Process Analyst in purchasing department
Rockwell Automation
May 2013 - June 2018
- * explored data, looking for data and industry trends to help develop a picture of where the company stands in the industry, where they can improve and where they can reduce costs * created daily, weekly and monthly automated reports for purchasing department * reported on spend, cost savings, usage, store valuation, stock holding, usage projections, forecasts, invoice reconciliation * created visualizations for management using Power BI * maintained purchasing department's internal database (Access, later MSSMS) * created facilitation tools using VBA for purchasing team * supported CPRO/Agility purchasing system * mentored and trained two data interns which become permanent
Procurement officer
Rockwell Automation
September 2010 - April 2013
- * responsible for reviewing requests and authorizing the purchase of goods and services, technical supplies and equipment * maintained quotes, vendors, indirect material prices * prepared weekly reports on all procurements products records of PR, PO and invoice * negotiated prices with suppliers for indirect goods and services * maintained stock levels for customer plants in Peterborough and Peterlee * maintained the database of suppliers
Technical support specialist
Rockwell Automation
June 2008 - August 2010
- * provided high-quality service to US customers of Rockwell Automation Software (software activation) * prepared on-line technical guidelines on most-common software and network related issues (knowledge base)
Education
