J. Andrew Hipolit
Washington, DC 20009
*******@*****.***
WORK EXPERIENCE
Independent Community Bankers of America, 1615 L St NW, Washington, DC 20036
Assistant Vice President, Policy, Research, and Advocacy, June 2022-February 2024
o Analyze bank call report and other data as it related to legislative and regulatory actions for our bankers
o Analyze key macroeconomic releases and Federal Reserve decisions for our staff and bankers
DC Department of Health, 899 North Capitol Street, NE, Washington, DC 20002
Investigator/Contact Tracer, June 2020-June 2022
o Assist citizens who have tested positive using customer service skills to develop rapport
o Mentor a new member of the team; teach the system and provide feedback on their calls
Member of Data Integrity Team, November 2020-April 2021
o Create SalesForce case files from external lists; provide coding assistance on data accuracy
Ready for Next (Communities) / Think Collectively, Remote
Data Consultant, April 2020-February 2025
o Develop a weighted economic risk summary statistic for 50 largest US cities and 50 states
o Code an automated Qualtrics survey about city characteristics
Evercore ISI / ISI, 1130 Connecticut Avenue, NW, Washington, DC 20036
Global Policy & Central Bank Strategy Team, Senior Associate / Associate, May 2014-October 2019
o Respond to client, sales team, and leadership requests on topics including macroeconomics, monetary policy, financial markets, central banks, politics / polling, taxes, regulations, tariffs / trade
o Provide data visualizations, statistical analysis, research, editing, fact-checking, writing support, publishing, and content advice to the three analysts (Monetary/Fiscal/Political) on behalf our clients
o Analyze public / market data as well as remarks by public officials; calculate spreads/forward rates; create indices/decompositions and lit reviews; summarize statistical methodologies for our clients
Georgetown University Med Center, 4000 Reservoir Rd. NW, Bldg D, Washington, DC 20007
Office of Medical Center Finance, Administrative Assistant 3, July 2012-May 2014
o Lead a working group on the Mobile Device Management transition and write the new policy
o Run the Certified Research Administrator training course
Office of Communications, Comms Specialist, June 2008-2012; Intern, Summer 2006 and 2007
o Support the GUMC Strategic Planning Initiative / working groups
o Manage online content for the GUMC homepage and other GUMC web sites
EDUCATION
Georgetown University Public Policy Institute, DC, MPP, May 2013; GPA: 3.80
The College of William and Mary, Williamsburg, VA, BA, Govt & History, May 2008
SKILLS
o Proficient in Stata Statistical Software, Microsoft Office suite (including Excel), Power BI, Bloomberg terminal, S&P Market Intelligence, Haver / DataInsight database, Adobe Acrobat / Photoshop, SalesForce, SharePoint, Qualtrics, HTML and CMS. Have used Python for data extraction.
o Passed the FINRA Series 7 General Securities Representative Examination & the Series 63