![Jakub Daszkiewicz, Developer in Gdańsk, Poland](http://assets.toptal.io/images?url=http%3A%2F%2Fbs-uploads.toptal.io%2Fblackfish-uploads%2Ftalent%2F662674%2Fpicture%2Foptimized%2Fhuge-ea27792c3307dbf6f93b6d7f81aa3120.jpg&width=524)
Jakub Daszkiewicz
Verified Expert in Engineering
Data Engineer and Developer
Jakub is passionate about the intersection of finance—including cryptocurrencies—and computer domains. Thanks to this expertise, he has worked with several large banks in the UK, Austria, and Poland to optimize processes and reduce their time from hours to minutes by tuning large SQL queries. He has spent most of his professional life in development and customer support. Jakub thoroughly enjoys digging into database-related data (logs, locks, and query plans) to identify what can be approved.
Portfolio
Experience
Availability
Preferred Environment
Unix, Windows, Eclipse, IntelliJ IDEA, Linux
The most amazing...
...thing I've developed is a system, including the whole database model, to manage investment and pension funds in one of the largest custodian banks in Poland.
Work Experience
Data Engineer
Pfizer - PGS Operations Insights
- Migrated all ETL jobs from Amazon Redshift to Snowflake during the migration period in May 2023.
- Tuned all processes in the PostgreSQL capacity planner database.
- Implemented several AWK tools to facilitate access to UDH data for business users.
Senior Developer and BI Specialist
Hapag-Lloyd
- Refactored the whole Aurora (MySQL) database, which was not performing well enough to work with the web application processing hundreds of millions of rows.
- Optimized huge data warehouse DB2 queries, querying and joining tables with billions of rows.
- Reorganized ETL pipelines, ensuring availability and continuity of the data pipeline process.
- Created new fact and dimension tables for newly added KPIs using the Kimball methodology.
Senior Lead Developer
Finastra
- Defined data structure and relationships to represent regulatory-related banking requirements imposed on banks after the financial crisis in 2008.
- Defined ETL pipelines to enable importing data from external systems, so users do not need to enter it manually.
- Improved the integration tests environment by more than 300%.
- Integrated all types of market data from the external system into the new system, including quotes, zero and yield curves, volatility surfaces, and swaption cubes.
- Resolved several performance-related database issues where complex processes over time increased to several hours. Understood the financial domain and code and suggested changes to fix it.
- Gathered business users' requirements and implemented an entirely new functionality and micro-hedging requested by our customer, Austria Bank.
- Implemented regulatory regulations around Basel III—risk-weighted assets.
Lead Developer
Reuters/Misys
- Resolved several performance-related database issues for customers in the product.
- Improved database performance for the largest customer in the UK. Suggested several changes to the structures of some indexes, modified some queries in the system, and sped up the system.
- Integrated external systems with the product. During the integration, a lot of ETL needed to be done. Bash, sed, and AWK were used intensively.
Senior Lead Developer
Prokom
- Designed the whole database model for the largest custodian bank in Poland to manage investment and pension funds.
- Implemented modules to calculate NAV and other related indicators.
- Implemented a module to manage and control various limits imposed on investment funds.
- Created Crystal Reports reports generating documents required by regulatory institutions.
- Developed a module to extract transaction data from incoming SWIFT messages.
Experience
Fusion Risk
The system was used to calculate in real-time the current risk exposure of all the branches in a bank. It was very flexible. The system was using embedded domain-specific language allowing banks to specify very detailed, customized processing allowing discounting and amortizing all the cash flows of each and every financial transaction registered in the system.
Promak-Fundusze
Education
Specialized Master's Degree in Finance Management and Banking Relations
École Supérieure de Commerce - Rouen, France
Master of Science Degree in Finance and Banking
University of Gdansk - Gdansk, Poland
Master's Degree in Computer Science
Technical University of Gdansk - Gdansk, Poland
Certifications
DA-100: Analyzing and Visualizing Data with Power BI
Microsoft
Azure Administrator AZ-103
Microsoft
Oracle Certified Professional, Java EE 5 Business Component Developer
Oracle
FRM - Financial Risk Manager (GARP ID: 1023320)
GARP
Oracle Certified Programmer Java 11
Oracle
Skills
Libraries/APIs
Pandas
Tools
Qlik Sense, Informatica ETL, Microsoft Power BI
Paradigms
ETL, Scrum, Database Design
Languages
Sed, AWK, SQL, Python, Objective-C, Bash Script
Storage
Oracle SQL, PostgreSQL, Microsoft SQL Server, IBM Informix, MySQL, IBM Db2
Platforms
Linux, Oracle, Windows, Unix, QlikView
Frameworks
JavaScriptCore
Other
Data Engineering, IFRS 9, Scalability, DAX
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring