Sebastian Kozik

• Cooperating with clients on their business challenges
• Converting real data problems into analytics solutions
• Drawing conclusions based on a data-driven approach
• Building dashboards and visualizations for clients
• Working on a cloud DWH environment (GCP - BigQuery, Snowflake, Azure, AWS)
• Creating dashboards on multiple BI's like Tableau, PowerBI, Sigma, Looker studio
• Building models and transforming data through DBT using SQL
• Utilizing Python for correlation and logistic regression tasks
• Managing API connectors through Cloud Functions
• Participated in numerous presentations on the data-driven decisions in business

• Building SQL queries to database for extracting data;
• Building PowerBI models for risk department usage;
• Python data cleansing and wrangling;
• Visualization data in PowerBI/Tableau;
• Making presentations in PowerPoint;
• Management of risk department;
• All the responsibilities from below.

Creating internal procedures, manuals, rules for analysis and risk Department;

• Making loan calculators in VBA;
• Writing SQL queries to database;
• Preparing whole range of sale, insurance, external registers statistics and reports;
• Making risk and fraud reports;
• Creating automatization processes in Information System;
• Scorecard validation and fine-tuning;
• Calculating risk parameters like VaR, PoD, LGD;
• Preparing and calculating of profitability models;
• Creating new quality, sales, audit, fraud statistics;
• Planning/Forecasting risk and quality indicators for purpose of budgetin
• Implementation of protective nature processes into system like APR blockade, cost-limit blockade, first installment

• Analysis of applicants creditworthiness;
• Decision making process of granting loans to individuals and enterpreneurs;
• Making sales statements, statistics, graphs;
• Preparing product analysis;
• Taking part in launching new products;
• Reporting of departments results;
• Monitoring of analysis department work.