Summary
Overview
Work History
Education
Skills
Certification
Websites
Extracurricular Activities
Timeline
Generic
AAREKH RANA

AAREKH RANA

Data scientist
Dublin

Summary

Data Scientist with 4+ years of experience in building data pipelines, automation, and dashboarding across telecom and e-commerce. Skilled in temporal data analysis, A/B testing, and KPI tracking using Power BI, Python, SQL, Snowflake, and PySpark. Proven ability to collaborate cross-functionally with engineering and product teams.

Overview

4
4
years of professional experience

Work History

Freelance Data Scientist

WP Media Nordic AB
Remote / Sweden
04.2024 - 10.2024
  • Analyzed weekly temporal clickstream and product data from Azure Blob using Python and Snowflake, delivering insights on product engagement trends.
  • Created Power BI dashboards using DAX to visualize funnel performance and calculate key KPIs for stakeholders.
  • Enhanced ETL processes via SSIS and Python, improving data processing speed and quality by 25%.
  • Applied clustering, A/B testing, and hypothesis testing to derive actionable insights and optimize marketing strategies.
  • Partnered with product and analytics teams to develop scalable models, and ensure alignment with business objectives.
  • Documented data pipelines and transformation logic to support cross-team collaboration and future scalability.

Data Analyst

Ookla
Remote
08.2021 - 07.2023
  • Processed temporal telecom performance data (speed, latency, packet loss) to track regional trends and generate market insights.
  • Automated end-to-end data workflows using Python, Pandas, and pandasql to clean, merge, and analyze timestamped test records, reducing manual effort by 80%, minimizing errors by 95%, and saving over 15 hours per week.
  • Built SQL reports using CTEs, LAG(), RANK(), and CASE logic to support internal KPI tracking and regional performance comparisons.
  • Delivered client-facing reports and dashboards using Matplotlib, Seaborn, and in-house tools for telecom giants like Verizon, AT&T, and Vodafone.
  • Migrated the analytics codebase from R to Python, improving maintainability and enabling team-wide standardization.
  • Collaborated with product and engineering teams to validate data accuracy, define KPIs, and improve cross-functional reporting quality.

Data Scientist

Amsys Infocom Pvt. Ltd
India
08.2019 - 08.2021
  • Built facial recognition and cheat-detection systems using OpenCV and scikit-learn for educational clients.
  • Developed image classification pipelines and real-time alert mechanisms for compliance monitoring.
  • Designed interactive Power BI dashboards for executive reporting and HR analytics.
  • Conducted A/B testing to evaluate different detection algorithm variants.

Analyst

Infoscope Solutions
India
10.2016 - 05.2017
  • Created automated Excel dashboards and reports using SQL-driven backends.
  • Supported data validation and consistency checks for high-quality daily deliverables.

Education

MSc - Computing (AI)

Ireland
Ireland
01-2024

MCA - Data Science

India
India
01-2022

BCA -

India
India
01-2019

Skills

  • Languages: Python, SQL, R
  • Platforms: Azure, Snowflake, PySpark, Databricks
  • Techniques: A/B Testing, KPI Analysis, Feature Engineering, Data Pre-processing, ETL processes, Statistical analysis
  • Tools: Power BI, SSIS, Git, JIRA, Excel
  • Data Types: Temporal Data, Clickstream, Telecom Network Data

Certification

  • LLM Engineering (Udemy)
  • Data Science (DataTrained)
  • Hadoop (IBM)
  • RHCSA (Red Hat)

Extracurricular Activities

Vice captain – cricket team at DCU and VIT

Theatre acting – performed in university stage productions at VIT

Timeline

Freelance Data Scientist

WP Media Nordic AB
04.2024 - 10.2024

Data Analyst

Ookla
08.2021 - 07.2023

Data Scientist

Amsys Infocom Pvt. Ltd
08.2019 - 08.2021

Analyst

Infoscope Solutions
10.2016 - 05.2017

MSc - Computing (AI)

Ireland

MCA - Data Science

India

BCA -

India

Similar Profiles

CREATE PROFILE
AAREKH RANAData scientist