PROFILE:
Experienced Data Analyst with a demonstrated history of working in the fast-paced marketing and advertising industry. Developed strong business skills in Operations, Querying, Reporting and Project Management.
EXPERIENCE:
DATA ANALYST, INTEGRATED LOGISTICS MANAGEMENT CORPORATION, Mar ’17 – Jun ‘17
ILM Corp offers a boutique and hands-on shipping service primarily focused on importers, ensuring timely delivery and always including a personal touch.
– Set up RDBMS infrastructure and populated with company data, utilizing Google BigQuery.
– Leveraged SQL to combine multiple data-mined sources into actionable sales leads.
– Created a python program to automate web-scraping processes. – Provided Ad Hoc Operational support to Sales staff.
– Kept track of Operational and Sales progress and reported back key metrics to improve efficiency.
DATA ANALYST INTERN, VIANT INC., May ’16 – Dec ‘16
Founded in 1999, Viant owns and operates several leading digital and ad technology media companies, including Specific Media, Adelphic, and Myspace. It is a member of the Xumo join venture and was acquired by Time Inc.
– Utilized SQL to query databases for campaigning metrics in Google BigQuery.
– Modified and bug fixed Tableau dashboards. Pulled and shared Tableau data with Operations and Sales teams.
– Revamped from scratch a widely-used Tableau dashboard.
– Added and removed employee access to RDBMS when required.
– Handled Ad-hoc avails requests from the Sales Team
CORPORATE OFFICE ADMINISTRATOR, ROCKET FUEL INC., Sep ’12 – Apr ‘15
Founded in 2008, Rocket Fuel Inc. uses a predictive marketing platform that leverages artificial intelligence and machine learning to optimize customer digital advertising campaigns.
– Managed multiple employee service programs. This included HQ lunch and dinner programs (for 400 headcount) and planning/executing HQ events (Happy Hours, Holiday Parties, charity events, etc).
– One-year internship with the Accounts Payable Department focused on budget accrual and statement categorization.
– Administrated Real Estate Software for all company locations. Coordinated with Legal, Finance and Facilities teams.
– Successfully shipped high-value server racks and computer systems internationally.
EDUCATION:
University of California, Irvine; Irvine, CA – Bachelor’s Degree – Economics with an emphasis in Mathematics
SKILLS:
– Technical: SQL through Google BigQuery, Tableau Dashboard creation and maintenance, Python, Cyberduck, Centerstone, ComScore, Nielsen, Experian, data mining, campaign analytics
– Administrative: Interdepartmental teamwork and collaboration, Microsoft Suite (Advanced Excel, Outlook, Word), Google Suite (Gmail, Drive, GBQ), budgeting and accruals, vendor management, creative problem-solving.
PAST PROJECTS:
– Created an automated Python web-scraping program.
– Leveraged Tableau linked to SQL server to create and update reporting views
– Overhaul of Lunch and Dinner services in HQ office for fiscal efficiency.
– Assisted in planning and execution of new company HQ buildout as well as local regional offices.
– Planned an official Matchcounts competition.
Education
-
June 2017
B.A. Economics at University of California, Irvine
-
Strong emphasis on Mathematics and Quantitative Economics
Experience
-
Mar ’17 – Jun ‘17
Data Analyst at Integrated Logistics Management Corporation
-
– Set up RDBMS infrastructure and populated with company data, utilizing Google BigQuery.
– Leveraged SQL to combine multiple data-mined sources into actionable sales leads.
– Created a python program to automate web-scraping processes.
– Provided Ad Hoc Operational support to Sales staff.
– Kept track of Operational and Sales progress and reported back key metrics to improve efficiency. -
May ’16 – Dec ‘16
Data Analyst Intern at Viant Inc.
-
– Utilized SQL to query databases for campaigning metrics in Google BigQuery.
– Modified and bug fixed Tableau dashboards. Pulled and shared Tableau data with Operations and Sales teams.
– Revamped from scratch a widely-used Tableau dashboard.
– Added and removed employee access to RDBMS when required.
– Handled Ad-hoc avails requests from the Sales Team -
Sep ’12 – Apr ‘15
Corporate Office Administrator at Rocket Fuel Inc.
-
– Managed multiple employee service programs. This included HQ lunch and dinner programs (for 400 headcount) and planning/executing HQ events (Happy Hours, Holiday Parties, charity events, etc).
– One-year internship with the Accounts Payable Department focused on budget accrual and statement categorization.
– Administrated Real Estate Software for all company locations. Coordinated with Legal, Finance and Facilities teams.
– Successfully shipped high-value server racks and computer systems internationally.
To contact this candidate email [email protected]