Associate Marketing Data Specialist
𝗦𝗮𝘃𝗲𝗱 𝟵𝟱% 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴 𝘁𝗶𝗺𝗲 𝘄𝗶𝘁𝗵 𝗣𝘆𝘁𝗵𝗼𝗻 𝗮𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝗳𝗼𝗿 𝗰𝗹𝗲𝗮𝗻𝗶𝗻𝗴 𝗿𝗲𝗮𝗹-𝘁𝗶𝗺𝗲 𝗱𝗮𝘁𝗮 𝗶𝗻 𝘀𝘂𝗽𝗽𝗼𝗿𝘁 𝗼𝗳 𝗿𝗲𝗽𝗼𝗿𝘁𝗶𝗻𝗴• Cleaned vast amounts of online behavioral data with Python pandas to create csv files• Utilized Power Query for the ETL process and Power Pivot and Excel to create dashboards and reports to monitor progress on execution of marketing strategies𝗗𝗲𝘀𝗶𝗴𝗻𝗲𝗱 𝗮𝗻𝗱 𝗯𝘂𝗶𝗹𝘁 𝟯 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱𝘀 𝘄𝗶𝘁𝗵𝗶𝗻 𝗮 𝟭-𝗺𝗼𝗻𝘁𝗵 𝘁𝗶𝗺𝗲𝗳𝗿𝗮𝗺𝗲• Identified business requirements and information needs for internal dashboard end users and aligned the discovered expectations with available data• Designed and created prototypes for dashboards to quickly iterate upon, with regular check-ins on expectation fulfillment• Developed and successfully launched 3 artistic Power BI dashboards that meet business requirements𝗪𝗿𝗮𝗻𝗴𝗹𝗲𝗱 𝗮𝗻𝗱 𝗮𝗻𝗮𝗹𝘆𝘇𝗲𝗱 𝗺𝗶𝗹𝗹𝗶𝗼𝗻𝘀 𝗼𝗳 𝗿𝗼𝘄𝘀 𝗼𝗳 𝘀𝗮𝗹𝗲𝘀/𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗱𝗮𝘁𝗮 𝘂𝘀𝗶𝗻𝗴 𝗮𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗘𝘅𝗰𝗲𝗹 𝘀𝗸𝗶𝗹𝗹𝘀 𝗮𝗻𝗱 𝗣𝘆𝘁𝗵𝗼𝗻• Wrote M code (Power Query) to customize and automate the ETL process of the vaccine stock tracker• Analyzed and visualized the effect of a marketing campaign spanning over 3 months using Python pandas, matplotlib, seaborn