Krzysztof Piotrowski
Data Engineer at ALTEN Polska- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
polski Native or bilingual proficiency
-
angielski Limited working proficiency
-
niemiecki Elementary proficiency
Topline Score
Bio
Credentials
-
Modeling Data Warehouse with Data Vault 2.0
UdemyNov, 2022- Nov, 2024 -
Exam 761: Querying Data with Transact-SQL
MicrosoftApr, 2019- Nov, 2024 -
AWS Certified Solutions Architect – Associate
Amazon Web Services (AWS)Mar, 2023- Nov, 2024 -
98-364:MTA: Database Fundamentals
Certiport - A Pearson VUE Business -
Hands On Snowflake - WebUI Essentials
Snowflake -
MOS 77-728: MOS: Microsoft Office Excel 2016 Expert: Interpreting Data for Insights
Certiport - A Pearson VUE Business
Experience
-
ALTEN Polska
-
Poland
-
IT Services and IT Consulting
-
300 - 400 Employee
-
Data Engineer
-
May 2020 - Present
Role: Data Engineer (for world leader in tobacco industry), reporting to DE manager Project: "Manufacturing", analysis of losses and stops in production lines Tasks: - creating and developing Data Warehouse tables (using Snowflake/Wherescape RED) - data models validation (in close cooperation with Data Architect and Business Analysts) - queries performance optimization - mentoring new team members Technologies and architecture: Snowflake, Wherescape RED, Wherescape 3D, Data Vault 2.0, Power BI Show less
-
-
-
Fundacja inCanto
-
Poland
-
Civic and Social Organizations
-
1 - 100 Employee
-
Volunteers coordinator
-
Mar 2021 - Present
Role: volunteers coordinator Resposibilities: - recruiting volunteers to ensure service for foundation's events - scheduling volunteers' work - providing guidance for volunteers to complete tasks in line with requirements - organizing events and meetings for volunteers Role: volunteers coordinator Resposibilities: - recruiting volunteers to ensure service for foundation's events - scheduling volunteers' work - providing guidance for volunteers to complete tasks in line with requirements - organizing events and meetings for volunteers
-
-
-
Onwelo
-
Poland
-
IT Services and IT Consulting
-
400 - 500 Employee
-
Data Analyst
-
Oct 2019 - Mar 2020
Role: data analyst, reporting to data architectProject: migration of existing MS SQL Server analytical solution to new, Snowflake-based platform hosted in AWS for betting and gambling industryKey responsibilities:- review and technical description of data sources and ETL flows of existing BI solution- close cooperation with data architects to gather requirements- analysis reported bugs and suggesting improvements and fixesTools and technologies: MS SQL, SSIS, TFS, Confluence, JIRA Show less
-
-
DWH Developer
-
Jul 2019 - Sep 2019
Role: Data Engineer, reporting to Project ManagerProject: maintenance and development of Data LakeKey responsibilities: - development of tables and viewsTools and technologies: Teradata, Informatica PC, SVN
-
-
-
ITMAGINATION
-
IT Services and IT Consulting
-
200 - 300 Employee
-
Data Developer
-
Dec 2018 - Apr 2019
Role: T-SQL Developer, reporting to Data Management Team Manager Project: data migration in banking sector Key responsibilities: - creating stored procedures and functions - close cooperation with business analysts Tools and technologies: MS SQL, MDS Role: T-SQL Developer, reporting to Data Management Team Manager Project: data migration in banking sector Key responsibilities: - creating stored procedures and functions - close cooperation with business analysts Tools and technologies: MS SQL, MDS
-
-
-
Soneta producent enova365
-
Poland
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Junior BI consultant
-
Aug 2017 - Nov 2018
Role: BI Consulting, reporting to Project Manager Project: development of BI module of enova365 ERP system Key responsibilities: - support for Partners implementing enova365 ERP BI - creating and maintaining data models - creating dashboards - preparing and conducting trainings for enova365 Partners, - participation in database tuning activities Tools and technologies: MS SQL, Power BI, TFS, internal documenting tools Role: BI Consulting, reporting to Project Manager Project: development of BI module of enova365 ERP system Key responsibilities: - support for Partners implementing enova365 ERP BI - creating and maintaining data models - creating dashboards - preparing and conducting trainings for enova365 Partners, - participation in database tuning activities Tools and technologies: MS SQL, Power BI, TFS, internal documenting tools
-
-
-
Alfa Laval
-
Sweden
-
Industrial Machinery Manufacturing
-
700 & Above Employee
-
Order handler
-
Aug 2015 - Jul 2017
Role: internal customer service, reporting to Team Manager Key resposibilities: - handling Customer's orders (creating CO in system, sending Order Acknowledgements, order status monitoring) - responding to Customer's requests - operating in ERP Movex system - cooperation with Logistics Dept concerning shipment status - cooperation with Planning Dept regarding adjusting delivery dates to current production plans and in-house manufactured components availability - cooperation with Engineering Dept concerning special orders handling and getting answers for Customer's technical requests - cooperation with Purchasing Dept concerning purchased components availability - claim shipments coordination Show less
-
-
-
Welcome Airport Services Sp. z o. o.
-
Poland
-
Airlines and Aviation
-
200 - 300 Employee
-
Senior PRM Agent
-
Apr 2014 - Jul 2015
Role: handling for passengers with reduced mobility Responsibilities: - handling for passengers with reduced mobility at the airport - daily tasks coordination of PRM Assistance - preparing daily passenger's service plan - handling for passengers with UM status (Unaccompanied Minor) - recording statistics of provided services, preparing monthly sum-up reports Role: handling for passengers with reduced mobility Responsibilities: - handling for passengers with reduced mobility at the airport - daily tasks coordination of PRM Assistance - preparing daily passenger's service plan - handling for passengers with UM status (Unaccompanied Minor) - recording statistics of provided services, preparing monthly sum-up reports
-
-
-
BBS Obserwator
-
Poland
-
Market Research
-
1 - 100 Employee
-
CATI pollster
-
Oct 2012 - Mar 2014
-
-
Education
-
Wyższa Szkoła Ekonomii i Informatyki w Krakowie
Bachelor of Science (BSc), Information Technology and Econometrics -
University of Agriculture in Krakow
Master of Science (MSc), Management and Production Engineering -
University of Agriculture in Krakow
Bachelor of Science (BSc), Management and Production Engineering