- Build internally- and externally-facing reports & QA tools using Microsoft Excel, Google Sheets, and SQL to drive optimizations and informed decision-making. Reporting ranges from weekly media performance to media mix model (MMM) and multi-touch attribution (MTA) model inputs- Identify, explore, and integrate key data sources dynamically to develop internal data warehouse using tools such as Adverity, Google Cloud Platform (Storage, BigQuery, Data Studio)- Facilitate cross-functional communication & data governance to identify common issues and provide recommendations on data acquisition process to improve central data accuracy

- Downloaded weekly media delivery & performance data from digital media platforms and providers (The Trade Desk, Google Ads, Campaign Manager 360, Display & Video 360)- Constructed and maintained media performance and executive summary dashboards powered by live data on Google Data Studio to present the data in the most easily consumable way, and surfaced key insights from the data for further analysis and action- Spearheaded data integrity by maintaining and improving existing data analysis tools for reporting and automation

Predicting Success at Vestiaire Collective• Utilizing behavioral data on sellers to maximize their chances of making a sale• Found 51% of active users were offline for over 384 days, and 79% made no purchases/sales this period, driving down user retention and total sales. Concluded number of followers, number of products listed, and accurate product descriptions are crucial to making a sale.• Tools Used: Python, Excel, TableauPonpare: Analyzing Japan’s Coupon Hub• Comparing user demographics in Tokyo to identify business drivers and marketing focus• Discovered the middle-aged demographic accounts for 16,015, or 60%, of total sales. Women made 36% more purchases than men, generating roughly ¥6,000,000 more in revenue.• Tools Used: SQL, Python, Excel, Tableau, StatisticsAirbnb + COVID: Where Do You Go from Here?• Analyzing Airbnb short-term rental data in NYC• Found an 89% decrease in bookings from March 2020 - July 2020 due to COVID-19. About 64% of recommended listings fall below average price for Airbnb’s in borough of Manhattan, ranging from as low as $31/night to as much as $2000/night.• Tools Used: Python, Excel, TableauWho’s Accountable? A Project for the NYCLU• A team analysis on decades’ worth of NYPD Civilian Complaint data• Discovered that of ~33,000 (35%) active duty officers with above-average amounts of complaints against them, there was an overall 229% increase in promotions across ranks within a 35-year span.• Tools Used: Python, Excel, TableauAnalyzing the Viewer Habits of the U.S. and U.K.• Comparing international YouTube viewer habits for trending videos across genre• Discovered ~25% of U.S. views attributed to Entertainment, while Music accounted for ~75% in the U.K. News & Politics, Nonprofits & Activism the least viewed/most negatively received in both countries.• Tools Used: SQL, PostgreSQL, PgAdmin, Tableau

• Streamlined and managed the tax document distribution process for AI Funds via email and internal Case Management helpdesk application• Collected and reviewed time-sensitive client tax documentation to ensure compliance and due diligence regarding CRS and FATCA reporting standards• Developed written announcements across departments (AI Operations, AI Investor Relations, Tax Operations, and Product Management) to Financial Advisors regarding updates to investments, distributions, tender windows, and availability of fund tax documentation• Collaborated with Financial Advisors to remediate subscription documents on behalf of the fund(s) or Tax Operations team• Compiled weekly statistics of inbound and outbound calls, gauging overall call volume for the AI Investor Relations management team

• Completed daily administrative tasks including regularly updating constituent profiles on Raiser’s Edge database • Managed ticket sales for business program events online and over the phone in addition to answering event queries• Compiled ticket sales information into sales batches and spreadsheets for Finance department• Aided with event logistics, from registration to breakdown, as well as ushering and guiding Q&A sessions • Built sample business-related programs for executive review

• Assisted Programming staff during high-level events with reception and registration, setup and breakdown as well as created program materials• Researched confirmed and prospective guests, including building sample business-related programs for executive review• Became familiar with corporate member firms and the benefits of corporate membership • Maintained and updated corporate membership records in Raiser’s Edge as needed

• Conducted external competitor evaluation on companies such as TaskRabbit and Handy, influencing company business strategy and expansion• Provided business related data collection, analysis, and reporting using tools such as Google Analytics• Collected data on household income and the labor market made for more effective analysis and targeting of potential customers• Made extensive use of social media platforms to advertise, effectively increasing company site traffic and user base by over 30% in two months• Completed other day to day administrative tasks as required to meet business needs and priorities