Shruti Dhokiya

Data Analyst

Rajkot, Gujarat, India 1+ yrs exp 84 · Excellent

About

Data Analyst with hands-on experience applying SQL, Excel, Power BI, Tableau, and Google Analytics for data collection, cleaning, validation, analysis, and reporting. Skilled in transforming raw data into meaningful insights through Power Query, DAX, Excel Pivot Tables, and Power BI dashboards, enabling effective KPI tracking and business reporting. Proficient in querying and working with relational databases including MySQL, PostgreSQL, and Microsoft SQL Server, using JOINs, CTEs, aggregations, and subqueries. Strong foundation in Data Cleaning, Data Modeling, Data Visualization, KPI Analysis, and Trend Analysis, with the ability to translate business requirements into clear analytical insights.

Skills & Expertise (26)

Data Validation Intermediate

6.5/10

Years Exp

GitHub Intermediate

6.5/10

Years Exp

Git Intermediate

6.5/10

Years Exp

Google Analytics Intermediate

6.5/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

Microsoft Excel Intermediate

6.5/10

Years Exp

Microsoft SQL Server Intermediate

6.5/10

Years Exp

Postgresql Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

KPI Reporting Intermediate

6.5/10

Years Exp

Dashboard Development Intermediate

6.5/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Data Modeling Intermediate

6.5/10

Years Exp

Power Query Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Python Intermediate

6.5/10

Years Exp

JavaScript Intermediate

6.5/10

Years Exp

CSS Intermediate

6.5/10

Years Exp

HTML Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Trend Analysis Intermediate

6.5/10

Years Exp

KPI Analysis Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Codex Beginner

4.5/10

Cursor Beginner

4.5/10

Claude Beginner

4.5/10

Work Experience

Data Analyst

I TECHNO PEAK

Jun 2025 - Present

Designed and implemented a data collection framework using Google Analytics and SQL to capture user behavior data and support website optimization and reporting. Conducted exploratory data analysis and visualization using Tableau, identifying key trends and patterns in customer behavior and website usage. Performed data cleaning, transformation, and validation using Excel and Power BI to improve data accuracy and reliability for reporting and analysis. Collaborated with cross-functional teams to gather, preprocess, clean, and wrangle data from multiple sources for analytical requirements. Conducted data analysis sessions with stakeholders, translating analytical findings and technical concepts into actionable business insights.

FrontEnd Developer – Web UI

IGTR – Rajkot

Dec 2024 - May 2025

Developed responsive and user-friendly Web UI interfaces using HTML, CSS, and JavaScript, focusing on clean layouts, reusable components, and consistent cross-browser behavior. Implemented interactive web elements and client-side functionality using JavaScript, including form validation, dynamic content handling, and user interactions. Translated UI requirements and design specifications into structured web pages using HTML5 and CSS3, maintaining responsive layouts across different screen sizes. Debugged and resolved UI issues related to layout, responsiveness, styling, and JavaScript functionality while collaborating with team members during development and testing.