Deepanshu Kaushik

Designed, implemented, and scheduled ETL pipelines using Airflow for fetching data from 5+ APIs for a marketing dashboard project. Implemented Airflow integration with AWS and Snowflake across 4 data projects, resulting in a 40% increase in team productivity. Used SQL in Snowflake for data pre-processing and aggregation, which was utilized to create marketing dashboards using Tableau. Developed marketing dashboards for 4 key clients to visualize brand’s impact via Share of Voice and Share of Market across media channels, leading to a 20% improvement in client satisfaction and retention.

Led a team of 10 members for “Analyzing Air Quality in Gurugram Using Machine Learning” to develop AQI prediction models. Collected data from 4 stations and developed an AQI calculation strategy and ensured its accuracy, achieved a matching rate of 92%. Developed machine learning models and hosted the optimized model as a FastAPI application.

Utilized Python, R and Excel for Statistics projects and created Statistics academic content for textbooks and courses. Worked on Descriptive, Inferential and Predictive Statistics, Parametric & Non-parametric distributions etc.

Mapped HS codes for over 1500 products using LOOKUPS and evaluated trend in sales data via statistical analyses using Python, Excel and Tableau and identified top 5 profitable countries for business exports and designed the Tableau dashboards. Analysed Goa’s trade data to recommend to the Goa government the important industrial sectors in Goa under Vibrant Goa 2019.