Sambit kumar Dash | Data Analyst at Deloitte USI

Sambit kumar Dash

Data Analyst at Deloitte USI

Based in Bengaluru

About

I bring two years of experience working with Python and advanced SQL, along with in-depth knowledge of statistical analysis, testing, product analysis, and Tableau. I am deeply passionate about these skill sets and continually seek to enhance them through ongoing upskilling efforts. Additionally, I have applied these skills in practical projects, further solidifying my proficiency.

Skills

Projects

SwiftServe: Optimizing Delivery Time Estimation in Intra-City Logistics

Led data preprocessing, visualization,and regression modeling for Porter's delivery time estimation project.Cleaned and engineered features,identified outliers, and optimized neural network architectures.Achieved substantial accuracy improvements through rigorous evaluation and hyperparameter tuning

Time Series Analysis and Forecasting:

Conducted forecasting for 145k Wikipedia pages over a span of 550 days to optimize ad placement strategies. Utilized ARIMA and SARIMAX models, achieving a Mean Absolute Percentage Error (MAPE) in the 4-8% range. Explored and preprocessed data meticulously to ensure the accuracy and reliability.

OTT Content Analysis

Developed a comprehensive Tableau dashboard for analyzing Netflix's global content distribution. The dashboard provides insightful visualizations on genre distribution, classification between movies and TV shows, and a breakdown of total content by country. By leveraging interactive charts and graph

Experience

2022

Data Analyst

Worked on automating sql query generation for more than 200 tables using python which increased efficiency by 50% Generate complex and efficient query to transform data based on clients requiremnets Designed and developed workflows for data flow in databricks across different stagesusing python,pyspark. Worked on building connection between python sql and salesforce for efficient and smooth data flow.

Education

2018-2022

Bachelor's of Technology

Bachelor's of Technology in Electrical and Electronics Engineering