Learn Data Skills
Beta
Philip Soo

Philip Soo

NA

NA

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Project

Dr. Semmelweis and the Discovery of Handwashing

My New Track

Data Scientist

Data virtuoso, transforming raw numbers into a masterpiece of understanding.

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Skyscanner | Oct 2021 - Present

Senior Product & Business Data Analyst

Provide business and product analytics support and guidance to numerous Product Managers (our internal stakeholders) within Skyscanner, supporting key workstreams in the Flight Search product. This involves close collaboration with: - engineering teams - data scientists and data engineers - senior business stakeholders Specific task and tools used include: - defining metrics and confirming data logging requirements with PMs and engineers - extracting and transforming events to create analytics datasets (PySpark/ Python, Databricks) - using datasets to produce ad hoc analyses (Databricks/Python) or dashboards for business/products metrics (SQL/Tableau) - designing, monitoring and analysing multi-variant tests (our in house experimentations platform/Databricks/Pyspark/Python)
Show More

Chubb | Dec 2019 - Sep 2021

Marketing Data Analyst

Responsible for all data marketing operations within Chubb UK’s Personal Insurance business. This involves working closely with the Marketing Director whilst managing an ecosystem of data and marketing related service providers. Specific tasks included: - Designing and maintaining a marketing dashboard, and presenting it to senior leaders - Overseeing the development and evolution of a marketing database (AWS Athena) - Developing the data strategy for our direct mailing campaigns Regularly used tools includes: AWS Athena SQL, Python (Pandas, Numpy), Jupyter Notebooks & Excel

ideal flatmate | May 2019 - Dec 2019

Data Scientist

I report directly to the two co-founders and am responsible for ensuring that data can drive business success. Specific tasks include: - Working with management and growth teams to define appropriate KPIs and targets - Designing and building reporting dashboards for staff and the board of directors - Working with the development team to improve the scope and quality of data available - Drawing insights on available business data Regularly used tools include: - MySQL, PostgreSQL (Redshift), Tableau, Google Sheets, AWS (serverless and server solutions), Python (Pandas, Numpy), Jupyter Notebooks

Jed.ai | Oct 2018 - Jan 2019

Business Growth & Strategy

Displayed strategic insight by working with CEO to clarify future roadmap through ideation, validation of AI consulting offerings and evaluation of available assets.

Panda Fintech | Jun 2018 - Aug 2018

Business Analytics Intern

Panda FinTech is a Beijing-based fin-tech startup that provides loan comparison APPs. As part of their analytics team, I was involved in: - Developing and maintaining our APP performance reporting - Analysing user behaviour - Using machine learning to carry out user segmentation Tools and methodologies used included: Amazon Redshift database, SQL and Metabase (open-source BI platform), R, Machine Learning (k-means & Hierarchical clustering)

Not for Profit | Apr 2014 - May 2018

Centre Director

Centre Director: Not-for-profit organisation, Beijing, April 2014-present • Leadership & Management: - Overseeing all aspects of the Centre: staffing, venue, finances, volunteers, regular events etc - Recruiting and managing full-time staff (4) and volunteers (15+) - Leading our management team to carry out periodic evaluation and planning to ensure we hit out targets - Oversaw significant grow in membership and revenue • Training & Coaching: - Developing staff training syllabus and delivering regular training for national staff (20+) - Preparing and delivering regular speeches and lectures about our values and mission - Successful recruited, trained and mentored a new Centre Director and a Service Line Director

Oxus Solutions | Mar 2012 - Apr 2014

Account Director / Digital Channels Consultant

Oxus Solutions was a boutique Employer Branding consultancy that helped MNCs to define, articulate and communicate their Value Position as an employer (EVP) to talent. • Employer Brand research and consulting, specifically: - Assessing of the strength of our clients’ Employer Brands versus their talent rivals’ - Designing and carrying out executive interviews, staff focus groups & talent surveys - Formulating and delivering HR marketing channels analytics reports - Writing research reports including findings, insights and proposed actions - Presenting research insights and proposed actions to clients’ C-level leadership • Oversaw the delivery of an MNC’s careers website with ATS (cloud-based recruiting software) • Client management – negotiating and agreeing proposals with new clients and repeat clients

LinLead Consultancy (Beijing) Co., Ltd | Dec 2010 - Aug 2011

Assistant Business Development Manager

• B2B Sales and Negotiation: - Responsible for B2B sales of executive education workshops and conferences - Designed and negotiated sponsorship deals for China’s first Employer Branding Summit - Displayed leadership skills in a fast-moving start-up environment, invited to become one of the firm’s partners • Training - delivered training for staff, sessions included: - Advanced Excel functions - Business writing for Chinese staff

BNY Mellon | Sep 2008 - Feb 2009

Analyst

• Project Management: managed US withholding tax audit for ‘Repackaged Assets’ deals; this involved: - Liaising with external parties (auditors, offshore-fund administrators, legal firms & investment banks) - Collaborating with internal teams (US-based tax, internal control, know your customer & client managers) - Compiling various documents for each deal to confirm its structure, tax status and counterparties • IT based: - Developed Fortran and Excel-based automation software useful to Corporate Trust - Wrote and used Visual Basic code to identify the source of account errors - Responsible for manipulating large Excel databases

BNY Mellon | Aug 2007 - Jan 2008

Analyst

Division: Global Corporate Trust, Trustee and Custodian services for repackaged debt securities • Job content as above - returned to the same role either side of overseas language study

My Education

Take a look at my formal education

N/a, Chinese as a foreign languageBeijing Language and Culture University | 2008
MEng, Civil EngineeringImperial College London | 2007

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free