What I've Been Working On
Dimensional Data Modeling with DBT - Jukebox Inc.
Developed a production-ready analytics pipeline using Snowflake and dbt to consolidate raw events, separate installation fees from recurring royalties, and deliver self-service insights with robust testing and snapshots.
DBT
SQL
Snowflake
GitHub
Building an End-to-End Data Pipeline for Analyzing Northwind Database using API Integration, PostgreSQL, DBT, and Tableau
Developed an end-to-end data pipeline using Northwind database API, PostgreSQL, DBT, and Tableau for seamless data extraction, transformation, and visualization.
Python,
SQL
DBT
Jinja
Tableau
Ad Campaign Analytics: Driving Revenue through Data Insights
I developed an interactive dashboard to analyze and visualize key metrics from an ad campaign. Leveraging Python and data visualization tools, I extracted valuable insights on earnings, eCPM, impressions, CTR, and unmatched request rates over a three-year period.
Figma
Tableau
Customer Churn Prediction using Classification Models
I developed classification models to predict customer churn. By analyzing customer behavior data, I identified customers who are likely to churn and used these insights to inform retention strategies and improve customer loyalty.
Python
Scikit-Learn
Pandas
Matplotlib
Digital Gender Gap Analysis
Analysis of digital gender gap in multiple countries reveals significant disparities in access, usage, and skills. Women face barriers like limited internet access and lower digital literacy, resulting in a substantial gender divide in the digital world.
Python
Scikit-Learn
Pandas
Matplotlib
120 Years of Nobel
Explore the legacy of Nobel Prize winners using Python libraries for data analysis. Uncover insights, patterns, and trends through visualizations and data-driven storytelling. Join me on this journey of discovery as we celebrate human excellence and unravel the compelling stories behind the Nobel.
Python
Pandas
Matplotlib
Hackerrank SQL Challenges
This project involved successfully solving the HackerRank SQL challenges, demonstrating my proficiency in SQL query writing, database manipulation, and problem-solving skills. Through this challenging and rewarding experience, I honed my SQL expertise and expanded my data-related skillset.
SQL
T-SQL
Toy Data Analysis
A breakdown of revenue drivers by store location for toy sales.
Google Cloud Platform
BigQuery
Looker Studio
New Year Resolution EDA
An exploratory data analysis (EDA) of New Year resolutions made on Twitter in 2015.
BigQuery
SQL
Figma
Tableau
Sentiment Analysis of Earnings Transcripts
This project involves the analysis of sentiment in earnings conference call transcripts of various companies. The goal is to extract insights and understand how different companies are perceived based on the sentiment within their transcript.
Python
TextBlob
Seaborn
Sentiment Analysis