Evan Pfeffer Email & Phone Number

Washington, District Of Columbia, United States

Washington Dc-Baltimore Area

Washington Dc-Baltimore Area

• Responsible for a residential solar loan purchasing program and consumer credit loan purchasing program.• Duties included monitoring credit performance, writing quarterly reports, interfacing with program partners, and building out Excel workbooks for each program. • Built out reports in Excel to make sure that loans in my portfolio met risk adjusted criteria (RAC), third-party credit origination policies, concentration limits, and due diligence reporting standards. • Serving on the Climate Risk Work Group, which is tasked with measuring the bank’s physical and transition risk exposure to climate change.• Development of credit performance reporting using PowerBI and PostgreSQL.• Automated program reporting for my programs and did various data collection efforts for my group using Python and SQLite. • Created templates for quarterly reporting memos and procedures manuals used by all programs in the group.

Washington, United States

• Helped students with Python related assignments and projects during office hours• Taught students the basics of programming in Python and how to use Pandas' library• Wrote reference code for lessons and review sessions

• Built a network graph of bank loans using Networkx Python library• Wrote code to match firm names using binary search tree and the RapidFuzz Library • Wrote a python script to collect subsidiary data from over 100 thousand corporate 10k filings on the SEC website• Set-up a local MySQL server to store the +20.5 million rows of data collected• Created a python script to clean and extract data for academic study• Developed an algorithm to match job postings with employee occupations

Washington D.C. Metro Area

• Developed a workforce management computer application that allowed management to assign employees to tasks that fit their specific skill set• Pitched my workforce management computer application to both the division and executive level management • Submitted a report on future application development and my recommendations to the assistant commissioner upon request• To initiated compliance, took part in a business impact analysis of every division within revenue collection management segment of the bureau

Washington D.C. Metro Area

• Gained insight into the legislative process by conducted research projects, attended committee hearings and briefings, and helped staffers organize early versions of the latest tax bill for mark-up by the Ways and Means Committee