Piotr is available for hire
Hire PiotrPiotr Pietruszka
Verified Expert in Engineering
Database Developer
Location
Kraków, Poland
Toptal Member Since
February 5, 2021
Piotr是一名数据库开发人员，在商业智能项目中拥有12年的后端和前端开发经验. 他设计并开发了SQL ETL作业，将欧洲航天局的一个财务系统从Oracle迁移到SAP. Piotr excels in Oracle databases, SQL, ETL processes development, and the creation of high-quality reports. 三年多来，他一直致力于大数据项目，并使用Apache Spark技术构建数据管道.
Portfolio
Teamstand
Amazon Web Services (AWS), Data Modeling
Brown Brothers Harriman
大数据、Hadoop、Spark、SQL、Java、Spring、Solr、Cloudera、OpenShift、Docker...
Brown Brothers Harriman
IBM Cognos, SQL, Data Visualization
Experience
Availability
Part-time
Preferred Environment
Ab Initio, Talend, IBM Cognos, Qlik Sense, Oracle, Amazon Web Services (AWS)， Spark SQL
The most amazing...
...我参与的项目是LivingWallet应用程序，它可以跟踪私人投资，并对投资者-资产组合产生有用的见解.
Work Experience
Configuration Specialist
2021 - 2022
Teamstand
- 配置多个数据库租户，以满足特定业务领域(项目管理)的客户需求, task collaboration).
- 与产品开发主管沟通，将业务需求转化为工作应用程序配置.
- Supported SQL code deployments into Acceptance and Prod environments.
Technologies: Amazon Web Services (AWS), Data Modeling
Data Engineer
2018 - 2020
Brown Brothers Harriman
- 开发了一个自助数据湖平台，使公司多个部门能够登录和分析他们的数据. 该解决方案基于运行在Cloudera on -premises平台上的Hadoop和Apache Spark.
- Assisted with POC projects to evaluate and compare Big Data tools (Scoop, Kafka Connect, Spark) in terms of data ingestion capabilities. 将超过120GB的公司数据加载到Apache Ignite数据库中，并运行复杂的SQL查询来测试性能.
- Deployed over 20 Java and Python applications into Redhat OpenShift cluster. 使用Jenkins和OpenShift插件开发了一个通用的CI/CD管道，以机载新应用程序.
Technologies: 大数据、Hadoop、Spark、SQL、Java、Spring、Solr、Cloudera、OpenShift、Docker, Data Pipelines, Data Architecture, Snowflake
BI Developer
2016 - 2018
Brown Brothers Harriman
- Developed financial reports for the Custody and Foreign Exchange departments. Transaction and balance statements were sent to the clients daily. The transaction data volume was over 1,5 billion records which was challenging from a performance perspective.
- 与基础设施团队合作，向生产系统交付报告，同时维护公司的SDLC最佳实践.
- 为高层管理人员制作了Qlik Sense仪表板和数据演示，提供了对P公司的洞察&L analysis.
Technologies: IBM Cognos, SQL, Data Visualization
Software Engineer
2014 - 2015
EPAM Systems
- 开发PL/SQL ETL流程来加载数据集市，以满足金融机构的合规性目的. Worked in cross-functional Scrum team to provide implementation, test scripts, documentation and deployment scripts.
- 参与客户端的实现，将新版本部署到生产环境中. 这包括在UAT测试期间提供帮助，并在每次发布之前提供测试证据和所需的文档.
- Created high-level interactive dashboards for top management in QlikView 11. The analytic platform was used to verify corporate data about over 67,在50个国家的000名员工核实任何违反预先定义的合规政策的行为.
Technologies: QlikView 11, Oracle PL/SQL, ETL, Data Engineering
Senior Software Engineer
2010 - 2014
Informatica
- 参与数据仓库全生命周期项目，为欧洲某大型化工公司构建BI平台. 这包括旨在满足销售报告需求的数据仓库设计, stock and forecasting areas.
- Migrated legacy ETL scripts into IBM DataStage ETL tool. 需要将填充事务表的几个SQL脚本迁移到ETL工具作业中. During this process an additional auditing and monitoring layer was added.
- 在微策略报告工具中为销售部门制作高质量的报告. The sales fact table contained over 400 million records; therefore, some of the self-service analysis was based on OLAP cube, which was refreshed daily.
- 开发Ab Initio作业，根据客户规范将POS事务文件从分隔符解码/编码为XML格式. The ETL job was processing over 10,每天从多个存储中获取000个文件，并应用复杂的业务和数据清理规则.
Technologies: MicroStrategy, IBM InfoSphere (DataStage), Ab Initio, ETL, Data Engineering, Star Schema
Senior Software Engineer
2007 - 2009
Accenture
- Assisted in maintenance for the energy company's data warehouse, monitored execution of Oracle Warehouse Builder ETL jobs, and produced data quality scripts to verify DWH integrity. 设法应用性能调优修复，将加载时间从4小时减少到1小时.5 hours.
- 参与了一个最大的Internet的CRM和供应系统的SOA集成项目, mobile, and TV providers in the Netherlands. 由于这种实现，客户可以显著缩短服务的交付时间.
- 设计和开发SQL ETL作业，将欧洲航天局的财务系统从Oracle迁移到SAP. 该项目涉及设计复杂的ETL规则，并与SAP专家密切合作以满足功能需求.
Technologies: SQL, Service-oriented Architecture (SOA), Oracle Warehouse Builder (OWB), ETL, Data Engineering
Experience
LivingWallet
http://github.com/pete-parsley/livingwalletLivingWallet is a private investment and finance tracking application. 它允许用户手动输入他/她所做的所有投资/支出交易. Optionally, 可以使用批处理作业从银行系统和股票市场加载多个事务. 所有定价信息都是根据交易日期货币汇率自动计算的. 每日余额是使用从时间序列数据库读取数据的Spark作业来计算的. The application provides a web UI based on the Thymeleaf template engine. It also enables interactive data analysis using Qlik Sense Tool.
DataSandbox
Datasandbox.pl是一个技术博客，我写这个博客是为了分享知识和文档，更好地消化我在数据工程领域学到的东西. 在这里，我探索了新的工具，并描述了我目前在空闲时间从事的项目.
Crypto Market Web Scraping App
创建了一个Java应用程序，从网页和REST API中收集加密货币数据，并加载到HDFS. 该应用程序计划每天运行，并摄取超过1500种加密货币的数据. The data was then loaded into a Hive database and analyzed with SQL queries. The data visualization layer was built using Apache Zeppelin Notebook.
Skills
Languages
SQL, Java, Java 8, Snowflake
Paradigms
数据库开发、数据库设计、面向服务的体系结构(SOA)
Storage
关系数据库，数据库，数据管道，Oracle PL/SQL, InfluxDB, HDFS, Apache Hive
Other
BI Reports, Data Engineering, Big Data, MicroStrategy, Software Engineering, Data Visualization, Data Architecture, Data Modeling, Star Schema, Data Analytics, Springbot
Frameworks
Spark, Hadoop, Spring
Tools
Qlik Sense, IBM Cognos, Ab Initio, Talend ETL, IBM InfoSphere (DataStage), Oracle Warehouse Builder (OWB), Spark SQL, Grafana, Solr, Cloudera
Platforms
Oracle、Docker、Talend、红帽OpenShift、QlikView 11、OpenShift、亚马逊网络服务(AWS)
Libraries/APIs
REST APIs
Education
2006 - 2006
计算机工程交流项目(论文项目:人工智能)
Universite de Technologie de Belfort-Montbeliard - Belfort, France
2001 - 2006
Master's Degree in Information Systems Engineering
AGH University of Science and Technology - Krakow, Poland
Certifications
FEBRUARY 2019 - PRESENT
Big Data Certification
Edureka
JANUARY 2015 - PRESENT
Oracle SQL Expert
Oracle
Collaboration That Works
How to Work with Toptal
在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.
1
Share your needs
在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2
Choose your talent
在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring