● Utilize Tableau Prep and Python to automate recurring portions of departmentalworkflow and generate new reports● Worked under tight departmental and regulatory deadlines to adhere to firm reportingschedules and standards● Regularly perform data cleansing and analysis on data sets from all across the firm invarying size and quality

● Utilized SQL and Tableau to design and administer reports for analysis of both the loanportfolio and the underlying collateral of securities● Developed policies and procedures for periodic risk monitoring in accordance with bothregulatory and audit requirements● Performed portfolio analysis on $30 Billion in marketable securities of all different assettypes to preemptively identify and mitigate risks

● Performed portfolio review and securities analysis during underwriting to assess thequality of potential collateral and make adjustments as needed● Underwrote complex loans by reviewing business and trust documentation as well asperforming credit review on individual applicants for lending purposes● Maintained a high level of performance in order to meet deadlines and satisfydepartmental KPIs