Deal Advisory & Strategy Analytics Intern
New York, Ny, Us
• Extracted, transformed, and visualized transit ridership, higher education, and international economic indicator data through Excel, Alteryx, and a Power BI analytics model, respectively, to drive insights on current trends in these public sector industries, increasing modeled KPI count from 3 to 7.• Utilizing SQL Server Management Studio and Alteryx, provided consulting services for an equity carve-out, specifically to classify the parent company’s income statement and balance sheet metrics to either remain as a part of the parent company or transfer into the spin-off company’s financial statements for over 15 million transactions across the previous 5 years of operation.