Prateek Sachdeva

Understand the product requirement, analysing data with Optimized SQL Queries to execute Data Analysis using Google BigQuery Console & transforming into actionable Insights. Developed Ad-hoc analysis reports like Churn Analysis, Progression Analysis, Monetization Reports by defining Key Performance Metrics (KPIs) in player data, causing reduction in user churn rate by 13%. Performed Impact Analysis, Economy Analysis, A/B Testing, Segmentation and root cause analysis to analyse player behaviour, resulting in increased retention by 15%. Utilized Google Analytics to track user behaviour and identify trends in user engagement & retention leading to 20% rise in conversions.

Gathered high quality insights from transactional SMS data by making Regular expressions, performed data labelling for transactional SMS data which helped in making predictors for modelling and to increase the data extraction rate from 24% to 30%. Gathered insights from the data which helped in developing intelligence to identify the credit-worthiness of customers by underwriting them and presenting reports of their credit history. Worked on projects by performing multiple analysis aiming to increase the credit approval rate and to decrease the credit risk by 40%.

Developed multiple machine-learning models employing both supervised and unsupervised learning techniques. Gained proficiency in SQL and Python programming and utilized them for data manipulation, data visualization in Power BI and Tableau. Gained expertise in EDA, feature engineering and successfully implemented machine learning algorithms to solve real-world problems.

Produced actionable insights by creating ad-hoc reports through data analysis and visualization using Excel. Developed a product dashboard with Excel pivot tables and VLOOKUP to monitor and enhance overall progress. Involved in collecting, cleaning,validating and finding abnormal activities (outliers) in the data.