back to CSS Capstone schedule

UWB Logo

Computer Science and Software Engineering Capstone Presentations

Fall Quarter

December 18, 2020

 

Elhadj Diallo

"Software Engineering Internship at Goldman Sachs"

(Goldman Sachs)

 

Faculty Advisor: Dr. Arkady Retik

 

 

 

Abstract

Due to the 2008 financial crisis, the Fed required all banks holding companies to report their loans so that they can perform

some internal stress testing to check their economic stabilities, to help prevent future economic crisis. The Fed use those

tests to check whether big firms have enough capital to give loans and also check whether those firms are following the

internal regulation rules and laws. My internship project was to design and automate the sourcing of some internal

Goldman Sachs loans to generate a specific report that are required to be submitted to the Fed. This is important because

controllers (clients) used to spend several hours to complete those reports manually, and with the population of those loans

growing, automating their sourcing save controllers time, reduce human error and eliminate the manual intervention where

it is possible.

 

The first step in automating the sourcing of these loans was to research the paths of all reportable attributes that are

required by this loan within the data base. To accomplish that, I work closely with my controllers (clients) to get a validation

of all the attributes necessary to be reported. Performance and accuracy are generally at odds with each other, so finding

all reportable attributes is very important.

 

Once paths of all reportable attributes were found, the next step was to design and code that technique with the help of an

internal meta modeling web IDE and java code base. I wrote different type of queries that helps source the data from the

data base and updated my java code base to be able to call the JSON file to run the refiner and generate a reportable

report. Testing was performed both unit test manually fed to the functions, and with automated testing from the GS data

base.

 

Also involved with this project was the used of Kanban agile SDLC, including project updates, learning financial background

used for this loan, sprint updates, writing reports, and participating in meetings with scrum masters and updating my project

progress to inform the team of the project evolution.

This project was successfully completed by the end of my internship. I was able to obtain a user acceptance testing (UAT)

and gained a sign off from my customers which led me to migrate the program into production and generated reports for

the Fed.

 

 

 

 

 

 

 

 

 

 

 

Updated December 15, 2020