이재우 Email & Phone Number

Seoul, South Korea

Seoul, South Korea

- Analysis of Facebook Ad Manager and Google Analytics Data to provide useful marketing data analyticsFormulated MySQL queries using Redash and AWS Athena to analyze discrepancies between Google Analytics and Facebook Ad Manager data - Analyzed all aspects of marketing and advertising data and how they can be used for further analysis Research on various brands from various industries to formulate a more efficient and creative advertising project development - Presentation on the ways to gain more clients as a startup advertising agency business - Wrote company introductory message for direct sales channel (freelancer websites) such as Kmong - Formulated Automated Amazon AWS Cloudwatch Log Error Reporting Function to Slack messenger system using AWS Lambda Python programming and Slack API

Seoul, South Korea

Assisted for the Cosmetics and Logistics Industry Insight Reports “EY Cosmetics Insight Report 2019”, “EY Logistics Insight Report 2019” (published 09.2019) - Analyzed conglomerates’ Annual Reports and Investor Relation materials including quarterly financials and market shares for general industry information and up-to-date trends - Provided market forecast with plain data analysis and reengineering 3rd party data such as Statista, Euromonitor, IBIS World, and Frost & Sullivan - Organized on-demand raw data into a well-visualized graph and chart through Excel and Powerpoint - Provided quick, on-the-spot, and accurate research when necessary - Translated/wrote emails to CFO, CEO, and head of research centers for in-depth company data and information - Organized and Wrote and industry Insight Report “EY Industry Insights Report” weekly briefings - Organized and delivered future research topics and to-do lists to all members of the Industry report team - Analyzed videos and articles related to new and trending logistics and cosmetics technologies - Provided insights and suggestions to page-headers and body information

Seoul, South Korea

James's Beer Storage (Naver Blog) - Gained over 2,200 followers - Introduced more than 300 domestic and international beers, building database with various data fields such as color, flavor, scent, and etc. for on-demand recommendations for visitors and starters

Yeoncheon-Gun, Gyeonggi-Do, Korea