Andrea Bertels Email & Phone Number

Cincinnati Area, Ky

New York, Ny

Greater New York City Area

- Field data requests and conduct analysis on NYC’s economy for senior officials in City Hall and NYCEDC, often under tight deadlines; summarize data-driven insights via memos and PowerPoint presentations under the direction of NYCEDC’s Chief Economist.- Identify compelling topics, neighborhoods, and industries to produce regular reports for NYCEDC’s website, including the Trends & Insights series and the monthly Economic Snapshot. - Collaborate on interdepartmental effort between Research, Compliance, and Management Information Systems to complete the Annual Investment Projects report, which estimates job creation, costs, and benefits for 600 active NYCEDC projects.- Use Excel, Access, and Stata to obtain and interpret large datasets on NYC jobs and businesses from a variety of public and private sources, including the U.S. Census Bureau, U.S. Bureau of Labor Statistics, New York State Department of Labor, CoStar, McGraw-Hill Construction, and Cushman & Wakefield.

Greater New York City Area

New York, Ny

- Departmental Research Assistant, Microeconomics for International Affairs (Fall 2011)- Teaching Assistant, Macroeconomics for International Affairs (Spring 2012)

New York, Ny

- Managed and coordinated deliverables from over 30 research contributors for a global microscope on microfinance business environments, which scored 55 countries on 11 qualitative indicators.- Defined quantitative variables and gathered data for various custom research projects, including a green cities index, a labor flexibility study, and a women’s economic opportunity index.

Chicago, Il

- Formulated, developed, and managed 4 to 6 events a month on a wide range of business and economic issues, including rapid-response panels on the financial crisis and the Focus on China series.- Researched, invited, and managed appropriate expert speakers, sourced from the public, private, academic, and non-profit sectors, as well as top foreign and U.S. government leaders.- Managed teams of 5 to 15 staff members to execute necessary event functions, such as registration, seating, and VIP receptions, for programs with audiences as large as 400 people.

Chicago, Il

- Traveled weekly to client site in Long Island to test human resources functionalities as part of a project team for three releases of SAP, a type of enterprise resource planning software.- Led the human resources SAP testing team of 6 people, consisting of resources in both United States and India, and delivered status reports on results and defect resolution to project management.

Milwaukee, Wi

- Collaborated to plan the 7th Annual Trade Policy Conference, which focused on trade and investment in the Arab Gulf States and featured speeches by the Ambassador of Bahrain and Congressman Paul Ryan.- Assisted with logistical planning and economic and cultural research for business missions to China and India, as well as the visit of the Chinese ambassador to Milwaukee.

Washington, D.C.

Analyzed the appropriateness of American companies’ requests for U.S. government advocacy as they competed against foreign firms for international contracts.

Honors Bs, International Business And Economics

Mia, International Finance And Economic Policy

Activities and Societies: Managing Editor, Journal of International Affairs; International Finance and Economic Policy Concentration.