Rinkesh Prajapati

About

Data Analyst with 2+ years of experience in ELT/ETL pipeline development, database operations, and advanced analytics. Skilled in Advanced SQL, Python, and cloud data warehouses such as BigQuery and Snowflake, with a strong focus on performance tuning, query optimization, and data-driven decision-making.

Experience

• Data Analyst
  Blueberry Group
  Nov 2024 – Present

  • Developed interactive Power BI dashboards and optimized SQL data models, reducing manual reporting extraction time by 40%. • Led user behavior analytics by tracking operational KPIs and conversion funnels, identifying process bottlenecks to improve cross-functional team productivity. • Conducted statistical root cause analyses on recurring system anomalies, accelerating issue resolution times by 15%.

• Data Analyst Intern
  Accenture
  Feb 2024 – Sep 2024

  Engineered a unified enterprise data model in Google BigQuery integrating 7 disparate datasets, decreasing data processing latency by 20%. • Conducted rigorous exploratory data analysis on web traffic metrics, executing user segmentation and hypothesis testing to deliver product strategy recommendations.

Education

• BTech
  Chandigarh University · Chandigarh university
  Computer Science and Engineering · Oct 2020 – Jun 2024

Skills

• SQL
• Python
• Power BI
• Tableau
• MySQL
• Streamlit
• Snowflake
• Data Modeling
• ETL
• Excel
• Statistical Analysis
• BigQuery
• Performance Tuning
• Product Analytics
• Funnel Analysis
• Query Optimization
• ELT
• Indexing
• Backup & Recovery
• Roles & Access Control

Projects

• Retail Sales ETL Pipeline
  Python, Advanced SQL, Snowflake, Power BI

  Built an end-to-end ETL/ELT pipeline extracting retail data into a Snowflake data warehouse, integrating structured backup and recovery protocols to ensure data integrity. Designed scalable relational databases using fact and dimension tables, discovering through exploratory analysis that promotional campaigns drove 80% of revenue.

• Marketing Performance & ROI Analytics
  Power BI, Advanced SQL

  Developed a dynamic marketing tracker processing 100K+ ad events, utilizing Advanced SQL for aggressive query optimization and database performance tuning. Identified and mitigated an 85% funnel drop-off using window functions within a star schema architecture, executing A/B test evaluations to optimize marketing spend.

• Sports Analytics Dashboard
  Power BI, Statistical Analysis

  Engineered a comprehensive dashboard analyzing 14 years of IPL match data, specifically focusing on the Rajasthan Royals squad to evaluate long-term franchise performance. Evaluated player strike rates and bowling metrics using statistical analysis to construct optimal, aggressive playing XIs.

🗣️ Languages

• English · Professional
• hindi · Fluent

🎯 Hobbies & interests

• Cricket