Olga Smolianinova
Offer Olga work on your next project.
Private message
Offer work
Kropivnitskiy,
Ukraine
3 months 1 day back
available for hire
age 22 years
on the service 8 months 26 days
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Русский: advanced
English: intermediate
中文: elementary
Skills and abilities
Programming
-
AI & Machine Learning
from 34 USD for project
-
Databases & SQL
from 18 USD for project
-
Python
from 23 USD for project
Design & art
-
Infographics
from 11 USD for project
- Interface Design (UI/UX)
Services
-
AI Consulting
from 17 USD for hour
-
Data Processing
from 14 USD for project
- Enterprise Resource Planning (ERP)
-
Tuition
from 11 USD for hour
Portfolio
-
Consumer Loan Portfolio Analysis and Risk Assessment
Databases & SQL
Stack: #PostgreeSQL #sqllite , Microsoft #Excel #PowerQuery
What was done:
Data Processing ( #etl ): Cleaned and structured a "raw" dataset (German Credit Data) of 1000 records.
… #PostgreeSQL: Wrote a series of queries using CTE, and Case When to segment customers by risk level, age, and loan purpose.
Excel Modeling: Built an automated table using XLOOKUP and IFS functions to decipher categorical codes. After that, pivot tables were created to calculate the average check and the percentage of defaulted loans by housing conditions and professions.
An analytical report has been generated that identifies the highest-risk segments of borrowers (for example, young people with education loans), which allows for optimizing credit policy.
-
Superstore Sales Dashboard
Data Processing
Interactive dashboard for monitoring retail sales performance
Data modeling: Converting a "flat" sales table (Superstore #dataset) into a relational model using the "Star" schema (Star Schema), highlighting individual product directories and customers.
… #DAX calculations: Developed a system of business #econometrics (Measures ), including:
#KPI : Total Revenue, Profit Margin %, Average Order Value.
Time Intelligence: Comparing sales of the current period with the previous year.
#visualisation : Created an interactive #DashBoards using cartograms, line graphs, and doughnut #charts . Report Page Tooltips were also used to deeply detail #Statistics for each region without overloading the main screen. A Color Blind Friendly color scheme was used for the dashboard, for better perception of information.
Result: A management tool was created that allows instantly assess profitability by category and region in real time.
#PowerBI #Tableau #PowerQuery #DAX #etl