Pawan chauhan
Data Analyst
Greater Noida
Summary
Detail-oriented Data Analyst with 1.7 years of experience in market research, specializing in data validation, data modeling, dashboard creation, and analytical reporting. Skilled in Advanced Excel, Power BI, SPSS, and PostgreSQL with strong problem-solving abilities and experience handling large datasets. Currently seeking a Data Analyst role after a career break with updated skills and hands-on project knowledge.
Overview
1
1
year of professional experience
2
2
Certifications
4
4
years of post-secondary education
Work History
Data Analyst
Dynata
02.2022 - 08.2023
- Performed data validation and ensured accuracy/consistency across market research datasets.
- Conducted data modeling and pattern analysis for client-focused insights.
- Built interactive dashboards using Excel and Power BI to visualize survey results.
- Used advanced Excel formulas (VLOOKUP/Nested formulas, Pivot Tables, Macros) for automation.
- Worked with SPSS for statistical checks and output generation.
- Collaborated with project managers to deliver analysis within tight timelines.
Education
Bachelor of Technology - Computer Science
Galgotias University
Greater Noida, India 08.2017 - 08.2021
Skills
Power BI: DAX, Measures, Data Modeling, Power Query, Dashboards
Excel (Advanced): Pivot Tables, VLOOKUP/Nested Formulas, Charts, Macros
SQL (PostgreSQL): Joins, Aggregations, Window Functions
SPSS: Data cleaning, statistical analysis
Data Analysis: Data validation, modeling, insights generation
Tools: Excel, Power BI, SPSS, PostgreSQL
Certification
Microsoft Power BI – SkillCourse - Gained hands-on experience in data modeling, DAX, Power Query, and interactive dashboard creation.
Timeline
Data Analyst
Dynata
02.2022 - 08.2023
Bachelor of Technology - Computer Science
Galgotias University
08.2017 - 08.2021