Elsa K.

Data Analyst

660 dollar
Freelancer
7 years
London, UNITED KINGDOM

My experience

More

The TelegraphApril 2019 - Present

Monetisation and Operational Analytics (Commercial Growth)

Projects:
- Agency Trading Statements
- Digital Rate Card
- Monthly data for digital inventory strategic report
- Pricing Tool
- PMP Deal Booking
- Programmatic Dashboard & partner datastreams
- Google Adserver log-level data (with team)
- Transform advertising operational data from SAP BusinessObjects to BigQuery

- Advertising revenue & inventory data reporting. Centralise commercial revenue data in Google Cloud for digital inventory and monetisation insights.

-Bridging between business and technical teams

- Brainstorm & build innovative solutions leveraging Cloud storage and BigQuery to empower internal teams. Work closely with finance, adops, commercial ops.

- SQL, BigQuery, Google Cloud Platform, Google Apps Script, Google Data Studio, Tableau, Excel
More

The TelegraphJune 2018 - March 2019

Digital Monetisation (Commercial Growth)
More

Lab ZeroApril 2016 - May 2018

labzero.io (July 2017)
- Product prototypes at elsakang.com
- Created portable game streaming device for PS4 and PC, prototype built based on Raspberry Pi 3.
- Portable network security hub to encrypt and anonymise wireless Internet browsing data.
eBay PowerSeller (Trading Apr 2016 - June 2017):
- Sold video game products to raise funding for projects.
More

Technang Advertising CompanyOctober 2014 - March 2016

- Transformed family business digitally to commercialise existing products for additional revenue streams and enhance efficiency.
- Increased online presence in local listings, made business more visible in search engines, added service range to reach wider customer base
More

Google Campus InternshipJune 2014 - September 2014

Startup internship with lypsso.com
More

Goldman Sachs InternshipJanuary 2013 - January 2013

Securities internship on trading floor: FICC, Credit, Equities Sales, Fund Derivatives Trading and Structuring rotations.
More

RBS InternshipJanuary 2013 - January 2013

FX Trading, DCM work shadowing
More

BNP Paribas InternshipJanuary 2012 - January 2012

Credit Value Adjustment (CVA) team on trading floor
More

Goldman Sachs InternshipJanuary 2011 - January 2011

Equities and FICC Technology

My stack

Databases

Google BigQuery

Languages

SQL, HTML, Java, JavaScript

Big Data

Big Data, Data Visualization

Others

Data analysis, Data Science

Software testing

Kali Linux

Embedded and Telecom

Raspberry Pi

Other

tableau, Database

My education and trainings

A in History, Maths, Physics, IT, Further Maths, Merit in History Advanced Extension Award, A-levels - Olchfa School, Swansea

Economics and Statistics BSc Hons - UCL2012 - 2014

Computing BEng Hons - Imperial College London2010 - 2012