Data Analyst

Junhak Lee ********@*****.***

Los Angeles, CA 714-***-****

Dedicated analyst with background in Economics and Mathematics; seeking opportunity to leverage my experience as an accomplished digital marketing and web operations analyst at a dot-com company.

TECHNICAL SKILLS & APPLICATIONS

Analytics: Tableau, Adobe Omniture Ad Hoc, Google Tag Manager

Digital Marketing: Google AdWords, Doubleclick, Marin, Bing Ads, Yahoo Gemini, Facebook Business, etc.

General: Excel, Word, Powerpoint, Eviews

Languages and Databases: Python, SQL, PostgreSQL, MySQL, SQLite

Libraries: SQLAlchemy, Selenium, BeautifulSoup, pandas, openpyxl, etc.

Web: HTML, CSS, Bootstrap, jQuery, ReactJS, Webpack, Flask, Django

Tools, Systems, and Deployment: Git, Linux Ubuntu, Windows, Heroku, VPS, nginx, etc.

PROFESSIONAL EXPERIENCE

Data Analyst at Cars.com, Santa Monica, CA 01/2015 – Present

Develop, automate, and streamline tooling and reports using Excel, Python, and SQL.

●Handle ad-hoc requests by writing complex SQL queries on demand

●Wrote tools to automate, scale, and optimize paid marketing campaigns and manual processes

●Develop and tools used to survey competitive landscape data across search engines

●Work with Product managers to help define and clarify requirements for internal reporting tooling

●Manage paid channel tracking and tagging through Google Tag Manager to leverage audience data to be able to better target and optimize current marketing efforts

Analytics Associate at Cars.com, Santa Monica, CA 03/2014 – 12/2014

Provided operational analysis and support to help increase business’s top-line.

●Maintained, monitored, and optimized backend lead operations based on changing business strategies

●Managed weekly and monthly reports to provide continuous insights and updates to senior directors

●Provided analytical support to a large and successful initiative to increase online traffic 30%, revenue 25%, while maintaining healthy gross margins and exceeding gross profit forecast month-over-month

●Identified, documented, and automated processes in SEM campaign management

●Launched, managed, and optimized SEM campaigns via continuous A/B testing of ad content modification

PERSONAL PROJECTS

Ktown-app github.com/jlee7737/k7own

●Classified listings site like Craigslist targeting local Korean-speaking residents with a more modern, mobile-responsive, platform agnostic UI experience using Bootstrap, custom CSS(LESS), and jQuery

Volunteer Match Non-Profit

●Helped build/upgrade existing web only interface to a fully mobile-responsive webpage using Bootstrap and custom CSS for a non-profit mobile game organization

Selenium Autoposter

●Created an autoposter dedicated for a simple online marketplace to regularly post and make sure handful of client’s posts were visible and up to date

Linear Regression Population Forecast Model

●Used MATLAB and multiple data sources acquired using Python web scraping to dynamically model world population based on several primary and secondary factors as a final project for class assignment

EDUCATION

University of Southern California, Los Angeles, CA 2010 – 2014

B.A. Economics, Minor in Mathematical Finance

Programming Coursework: C++, Web Development, Database Development

Contact this candidate