Pratyay Modi

Data Engineer/Architecht

Location: Berlin, Germany
E-mail: hi@prat.io
Phone: +49 (0) 176 2140 9166
Website: prat.io
linkedin: linkedin

I bring over a decade of experience in Data architecture, building data warehouses, pipelines, visualizations, as well as stakeholder and people management. Having started before the advent of the cloud era, I've witnessed the field evolve from spreadsheet-based reporting to big data platforms in the cloud and picked up a diverse skill set and domain knowledge in Healthcare, Finance, Real Estate, Retail, SaaS, and Online Gaming.

Work

Vivy GmbH

Head of Business Intelligence

Oct 2022 - Present

Data strategy & Governance, Stakeholder management, OKR Planning and mentoring.

  • Planning of OKR reporting strategy linking key results of cross functional teams.
  • Collaborating with legal & compliance teams for data collection policies.
  • Planning the data product requirements with stakeholders and clients.

Vivy GmbH

Sr. Data Engineer, Business Intelligence

Oct 2021 - Sep 2022

Setting up a DWH & ETL strategy for processing health data without compromising user privacy.

  • Setup the data lake, warehouse and pipelines from scratch.
  • Designed anonymised data collection policies for user behaviour and health data.
  • Deployed Cookieless web analytics and short link analytics.
  • Dashboards on Metabase & Looker.
  • Data modelling with Kimball methodoloy for Self service analytics.

Betpawa

Sr. Data Engineer, Business Intelligence

Jun 2017 - Sep 2021

As one of the first members of the data team I deployed the data warehouse with AWS EMR.

  • Created behavioural cohorts for churn prediction using Amazon EMR
  • Built a self service account reconciliation system for Xero
  • Developed Slackbots for ad-hoc queries and reporting with Redshift & Clickhouse
  • Financial reports for the Investors and share holders

Inventorum

Data Engineer, Business Intelligence

Feb 2014 - May 2017

Deployed a warehouse from scratch with Airflow, dbt and RedShift visualized on Tableau.

  • Prepared Investor reports for MRR, LTV and Churn prediction.
  • Integrated statistics from different sales and marketing channels to reduce the monthly marketing costs upto 20%.
  • Slackbot for live reporting of Sales, Payments and Churns.

Tata Consultancy Services

Data Administrator

Apr 2011 - Apr 2013

I Joined as a Data engineer and quickly pivoted to managing reporting and stakeholder management.

  • Setup the reporting infrastrucute for report generation and delivery.
  • Collection of requirements and delivery of reports to the stakeholders.

Education

European University Viadrina

Masters in Business Informatics

Apr 2013 - May 2015

Skills

Engineering

Airflow dbt dagster sqlmesh Meltano Airbyte Apache Kafka pySpark Databricks AWS Glue AWS Athena AWS EMR AWS Lambda AWS Step Functions AWS S3

Databases

Redshift Clickhouse BigQuery Snowflake DynamoDB MongoDB PostgreSQL SQL Server

Visualization Tools

Tableau Metabase Power BI Qliksense Streamlit Quicksight Qliksense

Programming Languages

SQL Python Javascript

Web Analytics

Google Analytics(GA4) Google Tag Manager(GTM) Adobe Analytics Mixpanel Appsflyer Matomo Plausible Firebase

Devops

AWS GCP Azure Kubernetes Docker Jenkins Github Actions Ansible Terraform

Languages

English (Native/Bilingual) German (B1)

Interests

Exercise

Running Hiking

Reading

Science fiction History Plays