Data Analyst and aspiring Data Engineer · M.Sc. Data Science · Delhi, India
I turn raw data into answers people can act on: cleaning it, modelling it, testing it and putting it in front of decision-makers as dashboards. Lately I've been building the pipelines underneath, from a data lake through Spark and dbt to a tested star schema.
LinkedIn · 📧 ananyaarawt@gmail.com
A monthly batch ELT pipeline for NYC Uber and Lyft trip data. It lands raw Parquet in an S3-compatible lake, cleans and de-duplicates it with PySpark, loads PostgreSQL with an atomic per-month swap, and models a star schema in dbt guarded by 31 data tests. Airflow orchestrates it in Docker and GitHub Actions tests every push. Verified on a real run of 2M+ trips.
Tech Stack: Python • PySpark • Airflow • dbt • PostgreSQL • Docker • S3 • GitHub Actions
End-to-end analytics project analyzing 150,000+ ride bookings using Python, MySQL, and Power BI. Includes data cleaning, exploratory analysis, 30+ SQL queries, and an interactive dashboard covering revenue, booking status, vehicle performance, payment methods, and pickup locations.
Tech Stack: Python • Pandas • SQL • MySQL • Power BI
End-to-end data analytics project using Python, MySQL, and Power BI to analyze 502,416 online retail transactions. Includes data cleaning, EDA, RFM customer segmentation, SQL analysis, and an interactive Power BI dashboard.
Tech Stack: Python • Pandas • SQL • MySQL • Power BI
SQL project analyzing movie ratings, user behavior, and genre performance using the MovieLens dataset. Includes joins, aggregations, CASE statements, and window functions to answer analytical questions.
Tech Stack: SQL • MySQL
More: Sales Performance Dashboard · HR Analytics Dashboard · Netflix Data Analysis
Tech and Growth Lead (Early Hire), Ozonit · D2C skincare startup, Delhi · 11/2023 – 07/2024
- Built Excel data pipelines in Power Query that merged sales, inventory and order sheets into one auto-refreshing monthly report.
- Analyzed 250+ orders a month across 4 products to guide restock, pricing and promotion decisions.
- Grew Instagram followers 2.5x (12% month over month) and A/B tested campaign creatives against sales data.
- Languages: Python, SQL (CTEs, window functions)
- Analysis: Pandas, NumPy, EDA, data cleaning, A/B testing, RFM segmentation, KPI reporting
- Data engineering: ELT pipelines, star-schema data modeling, data warehousing, data quality testing, CI/CD with GitHub Actions
- BI and visualization: Power BI (DAX), Tableau, Excel (Power Query, Pivot Tables), Matplotlib, Seaborn
- Databases and tools: PostgreSQL, MySQL, Jupyter, Git & GitHub
M.Sc. Data Science, Chandigarh University · 2023 – 2025
B.Sc. (Hons.) Mathematics, Graphic Era Hill University · 2020 – 2023
- Google Data Analytics Professional Certificate
- SQL for Data Science
- Programming for Everybody (Python)