Divya Hirapara
RoseHill,,NSW
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
1
year of professional experience
Work History
Data Analyst
IThouch Solution
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, Australia12-2025
Bachelor of Science - Computer Application
LJ College of Computer Application
Ahmedabad, Gujarat, India09-2020
Skills
- Languages: Python, SQL, R
- Libraries & Packages: Pandas, NumPy
- Databases: MySQL, SQL Server
- Cloud & Data Warehousing: Google BigQuery, Snowflake
- Data Visualization: Tableau, Microsoft Excel
- Development Tools: Visual Studio Code, PyCharm
- Methodologies: SDLC, Agile, Waterfall
- Operating Systems: Windows, Linux
Timeline
Data Analyst
IThouch Solution
09.2022 - 01.2024
Master of Science - Information Technology
Asia Pacific International College
Bachelor of Science - Computer Application
LJ College of Computer Application
Similar Profiles
Kapil ThukralKapil Thukral
AR Analyst at ACS Solution (now Innova Solution)AR Analyst at ACS Solution (now Innova Solution)
STELLA.B STELLA.B null
Human Resources Intern at Accevia Global Solution Private SolutionHuman Resources Intern at Accevia Global Solution Private Solution
Girish Kant AryaGirish Kant Arya
Control Room Engineer at M/S O&M Solution M/S O & M SolutionControl Room Engineer at M/S O&M Solution M/S O & M Solution
Lucy PetithLucy Petith
Hospitality and Stable Hand Assistant at Silverdale FarmHospitality and Stable Hand Assistant at Silverdale Farm
Bradley AttardBradley Attard
Regional Performance Manager (Sales) - NSW & QLD at WISE EmploymentRegional Performance Manager (Sales) - NSW & QLD at WISE Employment