Jyoti Rawat

Data Analyst

86 Agency•  January 2024 - Present

Cleaned and joined 5+ datasets using SQL to address key business questions. Analyzed 200,000+ customer transactions with SQL, identifying trends to optimize marketing. Created complex SQL queries to answer 10+ critical business questions. Developed 5 Power BI dashboards with KPIs for real-time tracking. Analyzed e-commerce data for 3+ clients, providing insights on pricing and customer behavior. Conducted customer behavior analysis in retail using Python (NumPy, Pandas, Matplotlib). Performed EDA for the credit card industry, uncovering trends in purchases and returns.

Junior Data Analyst

Valuesec Technology•  April 2022 - December 2023

Cleaned and formatted 35,000+ rows of data using Excel and SQL, improving data quality by 20%. Created pivot reports and dashboards for 3+ clients, reducing churn by 10%. Analyzed customer behavior for 5+ retail clients using SQL, optimizing sales strategies. Answered 10+ business questions with SQL, boosting client revenue by 30%. Developed reports and dashboards in Excel, enhancing decision-making efficiency by 25%.