Hi there, I'm Nikunj Mistry! 👋

Aspiring Data Analyst and Data Engineer with a knack for turning raw data into meaningful insights. Welcome to my digital portfolio!

About Me

• 💼 Work Experience:

  • Data Analyst Intern at NeenOPal
    CURRENT
    • Writing BigQuery scripts to develop dimension tables for a GA dashboard, enabling data integration from Google Analytics to Power BI for a US client project.
    • Working on an internal project, which involves building an ETL pipeline using AWS services.

• 💼 Work Experience:

  • Data Analyst Intern at Tamasha
    June 2023 - Sep 2023
    • Developed dashboards for revenue, deposit tracking, and game-specific analytics.
    • Managed cashback processes and automated weekly cashback reports.
    • Resolved technical glitches and addressed customer queries.
    • Automated user churn reports to optimize marketing strategies.

🛠 Skills

• Databases: PostgreSQL, MySQL, MongoDB, SQLAlchemy
• Web Technologies: Web 2.0, Bootstrap, Flask, Quart
• Big Data Tools: PySpark, ETL, Data Modelling, Data Analysis
• Cloud: AWS (Intermediate), GCP Big Query (Advanced), Snowflake (Beginning), DBT (Intermediate), Prefect
• Other Tools: Git, Anaconda, Colab, Figma, Power BI, Wix
• Coding Platforms: Leetcode (Highest Rating: 1903), CodeChef (Highest Rating: 1561), Solved 500+ SQL Problems

💡 Projects

Air Data Pipeline

Build an ETL pipeline for daily record fetch due to rate limit in free tier account.

SqlUnlocker

Access all LeetCode SQL questions and solutions, including locked ones.

Pokemon Dashboard

Extracted data from PokeAPI and visualized it using Power BI.

🏆 Achievements

• SQL Advanced Certification
• Google Analytics Certification
• CollegePythonExpo - Top 11
• Celestial-Data-O-Thon - Top 200
• Leetcode Global Rank: 8862

🌐 Connect with Me

• Email: nikunjmistry1000@gmail.com
• Phone: +91-9004256895

---

Feel free to reach out if you want to collaborate on a project or just want to chat about data science and engineering!