Patryk Banasik

• Built and maintained ETL/ELT data pipelines for Product Control (market, trade, and reference data).
• Implemented SQL-based BAU changes in PALMS covering Permitted Instruments, trading restrictions, and hierarchy updates.
• Owned data quality controls (validations, reconciliations, anomaly detection) and performed root-cause analysis of breaks.
• Defined and maintained Financial Product records in databases (instrument attributes, mappings, classification rules).
• Validated instrument eligibility against Permitted Instruments lists; identified misclassifications and coordinated fixes with business/IT.
• Shifted calculations to the database layer (SQL) to improve performance, consistency, and reproducibility of outputs.
• Supported releases via UAT/DEV testing; raised defects and recommended enhancements to developers.
• Documented data lineage and control rules to support governance, audit readiness, and change management.

Achievements:

• Delivered 40+ database projects covering updates, enhancements, migrations, and structural improvements across Product Control datasets.
• Identified and mapped 30+ financial instruments across multiple databases, enabling accurate classification of several thousand trades and significantly reducing the volume of unidentified trades, improving downstream reporting and control effectiveness.
• Onboarded 4 new processes for illiquid products into BAU operations, including data setup, control checks, and stakeholder handover, improving coverage and consistency of Product Control workflows.

• Conducted Fair Value Adjustment (FVA) and Independent Price Verification (IPV) assessments for complex financial instruments.
• Implemented valuation methodologies and enhanced control processes to mitigate financial risk.
• Automated data analysis processes using Python, VBA, and SQL, improving accuracy and efficiency.

Achievements:

• Automated over 20 processes using Python, VBA, and SQL, significantly enhancing individual and team efficiency.
• Transitioned three processes from manual Excel templates to dedicated software solutions, improving accuracy and reducing manual workload.
• Updated over 10 process instructions to align with modern tools and methodologies.

• Managed daily and monthly counterparty credit risk and collateral processes for diverse portfolios.
• Developed advanced VBA macros and templates to optimize analysis and reporting workflows.
• Analyzed financial data using external sources (Bloomberg, Reuters (Refinitiv), GLEIF) to identify counterparties and mitigate risks.

Achievements:

• Awarded Choose to Own It. Automated the retrieval of over 20 interest rates for the monthly process from Bloomberg using VBA Macros, significantly increasing efficiency and accuracy.

• Oversaw collateral management processes, ensuring compliance with global regulatory standards.
• Monitored and resolved interest/fees discrepancies, maintaining operational integrity.
• Conducted detailed risk assessments across diverse industries and markets.

Achievements:

Awarded Above and Beyond for resolving 98% of Collateral Interest Breaks within a year.

• Responded efficiently and accurately to guest complaints.
• Managed a team of 30-40 employees across four departments.
• Coordinated daily operations for Front of the House and Back of the House in a fast-paced environment.
• Organized and managed shifts during high-pressure situations.

Achievements:

• Best BPE 2017 award for maintaining high standards of service and operations.
• Cafe of the Year 2018 for exceptional quality of service, products, and audit performance.