pallavi pp
Senior Data Analyst
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)
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