Roman Penza
Data Engineer at Methods Analytics- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Microsoft Certified: Azure Data Fundamentals
MicrosoftFeb, 2023- Nov, 2024 -
Learning Docker
LinkedInOct, 2022- Nov, 2024 -
Apache PySpark by Example
LinkedInSep, 2022- Nov, 2024 -
Async Python Foundations: Applied Concepts
LinkedInSep, 2022- Nov, 2024 -
Data Engineering Foundations
LinkedInSep, 2022- Nov, 2024 -
Hands On Essentials - Data Warehouse
SnowflakeSep, 2022- Nov, 2024 -
PostgreSQL Essential Training
LinkedInSep, 2022- Nov, 2024 -
Unit Testing in Python
LinkedInSep, 2022- Nov, 2024 -
Data Analysis Using PySpark
CourseraNov, 2020- Nov, 2024 -
Google IT Automation Professional Certificate
CourseraNov, 2020- Nov, 2024 -
Introduction to Agile Training
NHS DigitalOct, 2019- Nov, 2024 -
Learning Python
LinkedInSep, 2018- Nov, 2024 -
Programming Foundations: Object-Oriented Design
LinkedInSep, 2018- Nov, 2024 -
Strategic Thinking
LinkedInSep, 2018- Nov, 2024 -
Machine Learning A-Z™: Hands-On Python & R In Data Science
UdemyAug, 2018- Nov, 2024 -
The Complete Oracle SQL Certification Course
UdemyAug, 2018- Nov, 2024 -
Microsoft Certified: Azure Data Engineer Associate
MicrosoftJul, 2023- Nov, 2024
Experience
-
Methods Analytics
-
United Kingdom
-
Information Technology & Services
-
1 - 100 Employee
-
Data Engineer
-
Jan 2023 - Present
-
-
-
EPAM Systems
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Software Engineer
-
Sep 2022 - Nov 2022
-
-
-
NewDay
-
United Kingdom
-
Financial Services
-
700 & Above Employee
-
Business Intelligence Engineer
-
Feb 2021 - Aug 2022
-Automating BI report production (daily, weekly and monthly) using Python and scheduled in Airflow -Working with Big Data in SQL on Dremio platform -Maintain current Python code base and develop new Python functions and classes for BI -Deliver reports in customer-friendly format (Excel, Power BI, Tableau) -Automating BI report production (daily, weekly and monthly) using Python and scheduled in Airflow -Working with Big Data in SQL on Dremio platform -Maintain current Python code base and develop new Python functions and classes for BI -Deliver reports in customer-friendly format (Excel, Power BI, Tableau)
-
-
-
NHS Digital
-
United Kingdom
-
Hospitals and Health Care
-
700 & Above Employee
-
Data Science Graduate Trainee
-
Sep 2019 - Feb 2021
Key software skills: • Python (pandas, pyspark, sklearn). IDEs - Spyder, DataBricks, Jupyter, VS Code. • SQL (SSMS, DataBricks) • Power BI Description: • Worked with large mental health monthly publication datasets and analysed through Python. Provided data check scripts for the team. Automated one of the key publication processes using Python. • Implemented predictive and outlier detection machine learning algorithms using polynomial regression on large sets of time-series and panel data in Python. • Attended Introduction to Agile Training, completed Edward Jenner Leadership programme. • Worked with Big Data through DataBricks using ANSI SQL and PySpark. Extracted the data through AWS S3. • Provided Power BI visualisations for 111 Online team to help track Covid-19. Show less
-
-
-
University of York
-
United Kingdom
-
Higher Education
-
700 & Above Employee
-
Student Ambassador
-
Jun 2018 - Jul 2018
-
-
Third Year Economics Representative
-
Oct 2017 - Jun 2018
• Have been elected to this role by obtaining the majority of votes among third year students• Collected and represented student feedback • Regularly attended departmental meetings with academic staff
-
-
-
York Conferences and Events
-
United Kingdom
-
Events Services
-
1 - 100 Employee
-
Conference Office Support Assistant
-
Jul 2017 - Sep 2017
• Duties included: registering guests in the Kinetics system, guest check-in and check-out, welcome talks, room spot-checks, preparation of conference rooms and helping guests with any kind of issues • Team work and cooperation with managers was essential for achieving common goal • Learned how to present myself in the best way and be attractive • Duties included: registering guests in the Kinetics system, guest check-in and check-out, welcome talks, room spot-checks, preparation of conference rooms and helping guests with any kind of issues • Team work and cooperation with managers was essential for achieving common goal • Learned how to present myself in the best way and be attractive
-
-
-
University of York
-
United Kingdom
-
Higher Education
-
700 & Above Employee
-
Secretary at a Student Society
-
Oct 2016 - Jun 2017
-
-
-
Sollers
-
Aktobe, Kazakhstan
-
Summer Intern
-
Jun 2016 - Aug 2016
• Worked as a part of the accountancy team to produce monthly and weekly production cost of concrete goods • Attained special training to use the required “1C: Entherprise” software • Gained a lot of experience working with Microsoft Office packages and especially Excel tables, which involved complicated formulas • Had an opportunity to look at how business operates from the inside • Learned to be up to date with constantly changing business environment • Worked as a part of the accountancy team to produce monthly and weekly production cost of concrete goods • Attained special training to use the required “1C: Entherprise” software • Gained a lot of experience working with Microsoft Office packages and especially Excel tables, which involved complicated formulas • Had an opportunity to look at how business operates from the inside • Learned to be up to date with constantly changing business environment
-
-
Education
-
University of York
Master's degree, Financial Engineering -
University of York
Bachelor's degree, Economics and Econometrics