Divya Hirapara - Data Analyst

Summary

Analytical and detail-driven Data Analyst with hands-on experience in SQL, Python, Google BigQuery, and Tableau. Skilled in transforming raw data into actionable insights through data cleaning, visualization, and reporting. Strong foundation in database querying, data modeling, and business intelligence.

Overview

1

year of professional experience

Work History

Data Analyst

IThouch Solution

Ahmedabad, Gujarat, India

09.2022 - 01.2024

Executed data extraction, transformation, and loading (ETL) tasks using complex SQL queries and stored procedures in MySQL Server, streamlining automated data pipelines for recurring business reports.
Queried and processed large-scale structured datasets in Google BigQuery using standard SQL, optimizing performance through partitioning and query tuning.
Designed and deployed dynamic Tableau dashboards to visualize KPIs, operational metrics, and trend analyses for non-technical stakeholders and business leaders.
Applied data wrangling techniques using Pandas and NumPy to clean, merge, reshape, and aggregate raw datasets for analysis-ready output.
Built ad hoc reporting solutions using Excel pivot tables, VLOOKUPs, and conditional logic to respond to time-sensitive business queries.
Collaborated with cross-functional teams to gather data requirements, translate business needs into technical specifications, and validate outputs.
Documented data workflows, SQL logic, and reporting structures to ensure reproducibility, data integrity, and knowledge transfer across teams.
Contributed to the improvement of internal data governance, schema design, and data modeling practices to increase analytical reliability and compliance.

Education

Master of Science - Information Technology

Asia Pacific International College

Sydney, Australia

12-2025

Bachelor of Science - Computer Application

LJ College of Computer Application