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