Oleksandr Pykhtin
Offer Oleksandr work on your next project.
Private message
Offer work
Zvenigorodka,
Ukraine
1 day 10 hours back
available for hire
on the service 1 day 11 hours
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
English: pre-intermediate
Skills and abilities
Portfolio
-
9 USD Model for client assessment (scoring) for loan issuance in Excel
Data Processing
In this project, I implemented an automated model for assessing the financial reliability of clients and making decisions regarding loan issuance based on input data (age, average monthly income, employment status, marital status, loan amount, and term).
What was done within the project:
… Data structuring: A clear and understandable form was created for entering the client's initial questionnaire data.
Logical algorithms and formulas: A system of automatic assessment was set up through logical functions (IF, AND, OR), which determine the relative sizes of the loan, risk categories for repayment, and the social status of the borrower.
Automation of decisions: The final summary of the model was programmed, which automatically issues a verdict (Approval of payment or Denial) based on a combination of factors.
The work demonstrates my skills in data analysis, building financial-logical models, and the ability to automate routine calculations in spreadsheets.
#Excel #Spreadsheets