Data Analyst with strength in SQL, Python, Excel, and Power BI. Gathers, cleans, and validates data from multiple sources, then turns it into KPI reporting, dashboards, and weekly management insights. Supports ETL and reporting workflows by resolving data quality issues and automating recurring analysis.
Hi, I’m
POONAM MEHARE
Data Analyst
pune,Maharashtra
Summary
Overview
4
years of professional experience
Work History
CapgeminiPune
Data Analyst
02.2023 - Current
Job overview
- Gathered, cleaned, and validated large datasets from multiple business sources using SQL and Python, enhancing data integrity for analysis.
- Perform exploratory data analysis (EDA) to identify patterns, trends, and business opportunities.
- Created reusable SQL queries, views, and stored procedures to streamline reporting and analytics processes.
- Created reusable SQL queries, views, and stored procedures, streamlining reporting and analytics processes for improved efficiency.
- Perform data validation and ensure high data accuracy across reporting systems.
- Prepared weekly and monthly management reports, delivering accurate data insights to support executive decision-making.
- Support ETL processes by identifying and resolving data quality issues.
- Automate Excel reports using Power Query and advanced Excel functions, reducing manual effort.
- Document business logic, dashboard specifications, and reporting processes.
Education
Vidyabharati MahavidyalayaAmravati
Bachelors of Science from Computer Science
06.2016
University Overview
Sant Gadge Baba Amravati UniversityAmravati
Masters of Science from Physics
05.2018
University Overview
Skills
SQL query optimization
Python programming
Microsoft Excel
Power BI
Power Query
Data analysis
Data visualization
Dashboard development
learning new skills ,singing, meditation
learning new skills ,singing, meditation
A dedicated person towards work and learning new technologies to improve myself day by day.
Timeline
Data Analyst
Capgemini
02.2023 - Current
Vidyabharati Mahavidyalaya
Bachelors of Science from Computer Science
Sant Gadge Baba Amravati University
Masters of Science from Physics