Back to Developers
pallavi pp

pallavi pp

Senior Data Analyst

Pune, Maharashtra, India 3+ yrs exp 87 ยท Excellent

About

Data Analyst with 4+ years of experience in data analytics, web automation, machine learning, and web scraping. Experienced in transforming raw data into actionable insights using Python, SQL, Excel, Tableau, and VBA. Skilled in data extraction, cleaning, transformation, ETL workflows, dashboard development, automation, and machine learning. Adept at solving business problems through data-driven decision-making and collaborating with cross-functional teams.

Skills & Expertise (18)

Python Advanced
8.0/10
3.5
Years Exp
Pandas Advanced
8.0/10
3.5
Years Exp
Microsoft Excel Advanced
8.0/10
3.5
Years Exp
Data Cleaning Advanced
8.0/10
3.5
Years Exp
Data Wrangling Advanced
8.0/10
3.5
Years Exp
Exploratory data analysis Advanced
8.0/10
3.5
Years Exp
SQL Advanced
7.5/10
3.5
Years Exp
Selenium Advanced
7.5/10
3.5
Years Exp
Tableau Advanced
7.5/10
3.5
Years Exp
Classification Intermediate
7.5/10
3.5
Years Exp
Regression Intermediate
7.5/10
3.5
Years Exp
Clustering Intermediate
7.0/10
3.5
Years Exp
Model Optimization Intermediate
7.0/10
3.5
Years Exp
NumPy Intermediate
7.0/10
3.5
Years Exp
Matplotlib Intermediate
7.0/10
3.5
Years Exp
Beautiful Soup Intermediate
7.0/10
3.5
Years Exp
VBA Intermediate
6.5/10
3.5
Years Exp
Scrapy Intermediate
6.5/10
3.5
Years Exp

Work Experience

Senior Data Analyst

Aimleap

Apr 2023 - Dec 2023

Analyzed large and complex datasets using Python, SQL, Pandas, and Excel to identify trends, patterns, and business insights. Performed data extraction, cleaning, transformation, and validation from multiple internal and external data sources. Developed and maintained ETL workflows to prepare reliable datasets for reporting and analytics. Created interactive Tableau dashboards and KPI reports to monitor business performance and support management decision-making. Automated repetitive data-processing and reporting activities using Python, VBA, and Selenium, reducing manual effort and processing time. Performed exploratory data analysis (EDA) and statistical analysis to identify customer behavior, sales trends, and data quality issues. Built and evaluated machine learning models for business use cases such as sales forecasting and customer behavior analysis. Developed automated data-quality checks and validation rules to identify missing, duplicate, inconsistent, or incorrect data. Worked with stakeholders to understand business requirements, define analytical objectives, and translate requirements into data-driven solutions. Prepared analytical reports and presented findings, trends, and recommendations to business and project teams. Automated web-data collection using Selenium, Beautiful Soup, and Scrapy, followed by data cleaning and structured analysis. Troubleshot data and reporting issues and optimized existing workflows to improve accuracy, reliability, and efficiency.

Data Analyst

Syneotek Software Solutions

Jun 2020 - Mar 2023

Collected and extracted data from multiple web sources using Selenium and Beautiful Soup. Cleaned, transformed, and validated raw data using Python, Pandas, and Excel for reporting and analysis. Developed automated workflows using Python, Selenium, VBA, and Excel to reduce repetitive manual activities. Prepared recurring MIS reports, analytical reports, and business summaries for stakeholders. Created Excel-based dashboards and reports to track business KPIs and operational performance. Performed data analysis to identify trends, inconsistencies, and opportunities for process improvement. Implemented data-validation and quality-check processes to improve the accuracy and consistency of reporting data. Maintained and enhanced existing automation scripts based on changing business requirements. Worked with team members and stakeholders to understand requirements and deliver data and reporting solutions within timelines. Documented automation processes, data workflows, and reporting procedures for operational continuity.

Education

Bachelor of Engineering - Savitribai Phule Pune University

- ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 12/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 87/100

Profile Overview

Member sinceOct 2026