Learn Data Skills
Beta
Tomasz Rogalski

Tomasz Rogalski

Analyst

Citigroup | Poland, Warsaw

Technologies

My Portfolio Highlights

My New Course

Understanding Data Science

My New Course

Understanding Data Science

Statistical wizard, casting spells of significance on data experiments.

My Work

Take a look at my latest work.

course

Data Manipulation in SQL

course

PostgreSQL Summary Stats and Window Functions

course

Intermediate SQL Queries

course

Understanding Data Science

course

Analysis in Excel

course

Data Manipulation in SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Understanding Data Science
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Nordea | Apr 2024 - Sep 2024

Business Data Analyst

AML/KYC/System Migration - working with Data Strategy team on data migration - providing analysis of the data from SQL databases - building dashboard in PowerBI showing requested values - presenting findings to stakeholders - working on profiling of data - Jira/Kanban environment
Show More

Citi | Jun 2023 - Apr 2024

Business Analyst

AML/KYC/Technology Team - working with AML Technology Investigation Team, being a contact person between developers and testers team when testing new releases in UAT - working in UNIX, Autosys, Jira and SQL Oracle environments - running jobs in Autosys application, sharing logs and JILs when needed - running queries necessary to perform test case/user story for dev and test team - sharing ETL logs from UNIX environment

Citi | Jul 2020 - Jun 2023

Business Analyst

Operational Risk - testing and developing a new (critical)application designed for a risk operations team (working in UAT environment to check for possible errors in PROD) - daily monitoring and investigation of margin limit breaches based on VAR and MTM calculations - making an annual test of application - checking VAR calculation correctness - cooperation with the risk monitoring team and senior management - helping to implement Power BI Reporting Tool in the application - creating procedures and developing tools used for daily reporting - liaising between technology teams of Citi and 3rd party company developing application - contacting with data owners - handling daily reports for senior management - submitting errors found in the application based on daily use - being a contact person with 3rd party company developing the application(creating and leading calls)

Citi | Nov 2019 - Jul 2020

Risk Analyst

- checking Data Demand Forms for their correctness and quality - working directly with Managing Director and Senior Vice President of Risk department, handling all data trackers and ad-hoc reports - taking care of shared drive and SharePoint - working on monthly NFA report for US regulator - creating TOP50 reports, working with big excel datasheets

Citi | May 2018 - Nov 2019

Data Quality Analyst

- leading Mortgages, Personal Loans, and Securitization products - making sure that US regulators get proper data - working in an SQL environment - working with scorecards to assure the correctness of data sent from data processors to the newly created main system - working with data models and data owners - submitting IMRs and CAPs to correct any anomalies in data

Elavon Financial Services DAC | Mar 2017 - Apr 2018

Quality Control Analyst

Newly established position in team serving the biggest customers in company. Creating and analyzing reports for rates, fees and pricing program correctness in the system. Pricing change supervision on Premier customer accounts. Creating procedure. Obtaining reports using Web Focus and other internal reporting programs. Controlling newly opening Premier accounts. Creating and editing tests for Premier team members

Elavon Financial Services DAC | Apr 2016 - Feb 2017

Onboarding/AML/KYC Specialist

Onboarding of new customer applications (from whole Europe with only 4.72% error rate from 01.04.2016) Checking new applications for risk exposure, the correctness of documentation, and perform AML/KYC verification. Member of Quality Control Team responsible for critical for the company process iZettle. Participation in KPMG audit process. Conducting training and mentoring for new hires. Member of Talk to Us team taking care of employee issues. Contact with polish and foreign sales representatives.

Tact Group Oy | Oct 2014 - Feb 2016

Business Analyst

Verifying and analyzing credit applications (including documents sent by customer in manual process). Participation in decision making process regarding business and products. Preparing and analyzing reports for Country Manager and CEO. Being a contact with IR responsible for CRM system development. Creating procedures and pricing rules.

Pocztylion Arka PTE-S.A. | Sep 2009 - Jun 2014

Senior Customer Service Representative

Processing applications, new agreements, and complaints. Handling the process of withdrawing contracts. Customer service via phone, email and personal. Collaborating with Marketing and Sales team, helping them with creating and calculations in Excel.

My Education

Take a look at my formal education

Master's degree, Business PsychologyWyższa Szkoła Finansów i Zarządzania w Warszawie | 2009

About Me

Tomasz Rogalski

Hello, I'm looking to increase my data analyst skills here, like SQL, tableu and maybe Python in the future.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free