Analyst, Data Analytics

• Oct 2022 - Present

- Build, modify and QA bi-weekly, monthly and quarterly dashboard reports using Excel, PowerPoint and Tableau to provide insights into campaign KPI trends for internal cross-functional teams and major pharmaceutical clients - Track, extract and QA a variety of advertising KPIs from GA, SA360, CM360 and Facebook Ads Manager on a bi-weekly basis for use by partner WPP agencies on collaborative projects - Clean, merge and dedupe multiple datasets in internal database containing identifiers of potential physician targets for campaigns by using Python - Participate in UAT for future development of and improvements to company software - Handle file transfers containing personally identifiable information (PII) to/from third-party companies and pharmaceutical clients in accordance with strict data privacy and confidentiality regulations relating to HIPAA Show less

Associate Analyst, Data Analytics - CMI Media Group

• Aug 2021 - Sep 2022

Corporate Research Intern

• Sep 2019 - Dec 2019

- Organized and constructed databases from scratch for Linear Television team using data gathered from research of key information of 20 years of original TV programming for major golf and tennis championships and college football matches across various cable and broadcast networks to help keep track of programs and create programming reports that inform ViacomCBS Domestic Media Networks (formerly Viacom Media Networks) executive management from various departments of historical performance of sports programming in key metrics of audience viewership across the competitive TV landscape to help improve programming strategy and advertisement revenue as well as impressions forecasting for the benefit of ViacomCBS’s stakeholders - Created data dashboards by compiling and analyzing data pulled from Nielsen ratings reports using media reporting software such as StarTrak and Microsoft Excel functions such as VLOOKUP and IndexMatch to help transform numbers into dynamic tables that can tell stories about TV content consumption across various audience demographics Show less

Data Analytics Virtual Intern

• Jun 2019 - Aug 2019

• Analyzed database of 1000+ customer’s demographics, addresses and transactions of Australian-based motor vehicle accessories manufacturer to assess risks, manage costs and find best solutions to help grow their business • Completed three modules of Data Quality Assessments, Data Insights and Presentations by creating data dashboards, utilizing data visualization software such as Tableau and parsing customer data stored in Excel files using Python • Analyzed database of 1000+ customer’s demographics, addresses and transactions of Australian-based motor vehicle accessories manufacturer to assess risks, manage costs and find best solutions to help grow their business • Completed three modules of Data Quality Assessments, Data Insights and Presentations by creating data dashboards, utilizing data visualization software such as Tableau and parsing customer data stored in Excel files using Python

Volunteer Office Assistant

• May 2015 - May 2019

• Collaborated and cooperated with team of ASPCA Operations managers from different departments to effectively support operations and client services through multitasking on various administrative projects • Prepared documentation for 4000+ adopters that increases adoption business and sales while meeting deadlines • Independently managed confidential credentials of ASPCA clients and 800+ volunteers in internal database • Collaborated and cooperated with team of ASPCA Operations managers from different departments to effectively support operations and client services through multitasking on various administrative projects • Prepared documentation for 4000+ adopters that increases adoption business and sales while meeting deadlines • Independently managed confidential credentials of ASPCA clients and 800+ volunteers in internal database