•Responsible for providing data analysis that focused on improving user experience and optimizing user retention.•Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions and common table expressions to track user activity metrics such as retention rate and daily active user. Optimized existing queries to run faster on large dataset.•Designed and maintained MySQL databases and created pipelines using user-defined functions and stored procedures for daily reporting tasks.•Developed dashboards in Tableau and present data to track KPIs and product performance using data from various sources such as MS Excel, AWS S3, AWS RDS, AWS Redshift.•Spotted and analyze trends in user activity data, identify underperformed user segmentation report insight to stakeholders.•Designed metrics for A/B testing, creating dashboards in Tableau to monitor test processes, analyzing test results, interpret and give recommendations to stakeholders.•Performed statistical analysis such as hypothesis testing causal inference and Bayesian analysis.•Communicated between the business, product manager and data engineers to ensure the data quality.•Developed Python scripts to automate data validation and data cleaning processes such as deduplicating and checking data consistency using Pandas.

•Developed a customer churn prediction model using Python, achieving an 84% accuracy rate with logistic regression, SVM, Decision Trees, and Naïve Bayes algorithms.•Managed, updated, and manipulated report structures using advanced Excel functions such as Pivot Tables and V-Lookups.•Utilized DAX functions to create measures and calculated fields for logical data visualization and used Power Query to transform data.•Implemented Tableau for visualizations including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, and reference lines.•Created T-SQL Stored Procedures, User-Defined Functions, Indexes, Views, and Triggers; wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived Tables, and Common Table Expressions (CTEs).•Experienced in an Agile environment, participating in daily standups, weekly sprints, backlog grooming, and defining test scenarios and strategies.

•Participated in various stages of data handling, including collection, cleaning, and preprocessing, to facilitate analysis and modeling endeavors. •Performed statistical analysis and hypothesis testing to assess business performance and pinpoint potential areas for enhancement. Engineered Python scripts to automate data processing operations, enhancing overall workflow efficiency. •Contributed to crafting and executing data visualization dashboards using Power BI for internal reporting objectives. •Aided in crafting presentations and reports that encapsulated critical insights and recommendations derived from data analysis initiatives. •Communicated key findings from data to multiple stakeholders to facilitate data-driven decisions using tools MS PowerPoint Tableau and Jupyter Notebook.•Queried data from MySQL database and validated and detected inconsistent data using Python packages Pandas and NumPy.