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.

  • Updated 5 years ago

To contact this candidate email [email protected]

Contact using webmail: Gmail / AOL / Yahoo / Outlook