Data Analyst Engineer

Pratiksha Dange

Boston, MA 202-****-*** ******************@*****.*** LinkedIn GitHub

Education

George Washington University May 2025

Master of Science in Data Science, Washington, DC GPA: 3.71 Rashtrasant Tukdoji Maharaj Nagpur University May 2018 Bachelor of Engineering in Computer Engineering, Nagpur, India GPA: 3.55 Skills

Languages: Python, R, SQL

Libraries: Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn, Statsmodels Databases: MySQL, PostgreSQL, SQL Server, BigQuery BI/Visualization Tools: Tableau, Power BI, Looker Studio, MS Excel, Google Sheets Cloud Platforms: GCP (BigQuery, Data Studio), Azure (ADF, SQL DB) SDLC: Agile, Scrum, Waterfall

Experience

Data Engineer Jul 2022 – Jul 2023

Colgate-Palmolive Mumbai, India

• Analyzed SAP portal usage with Google Analytics to identify high-value content and reduce clutter by 40%.

• Led user behavior analysis using Google Analytics 4 (GA4) to inform personalized portal features, boosting engagement for 20K+ employees.

• Built SQL pipelines in BigQuery to automate content prioritization and migration, reducing manual effort by 60%.

• Designed interactive dashboards in Looker Studio by integrating BigQuery and Sheets data, empowering leadership to track KPIs and portal engagement across regions.

Sr. Data Analyst Jan 2021 – Jul 2022

Accenture Mumbai, India

• Directed data validation for a 10 TB SAP-to-Azure migration, ensuring 100% data integrity and zero downtime.

• Analyzed large datasets using Python and Excel to uncover operational bottlenecks, providing actionable insights that reduced reporting delays by 20%.

• Resolved critical data issues across 7 global environments by leading cross-functional debugging sessions, improving system stability and user confidence.

Data Analyst Jan 2019 – Jan 2021

Accenture Mumbai, India

• Optimized MySQL databases for 35+ portals by indexing slow queries, reducing data retrieval time by 40% and boosting dashboard performance.

• Led a 10TB SAP-to-Azure migration by building SQL validation scripts and reconciliation checks, ensuring 100% data accuracy and zero downtime.

• Created Excel and interactive Tableau reports for business stakeholders, streamlining performance tracking and reducing manual reporting time by 25%.

Projects

World Bank University Data Fellows: Just Energy Transition Link Jan 2025 – Apr 2025

• Cleaned and analyzed land tenure data from multiple sources across 84 countries to identify high-risk regions for targeted World Bank interventions.

• Built interactive dashboards in Tableau to visualize land insecurity hotspots, enabling data-driven policy decisions. GitHub Gems: Driving Open-Source Investments with Data Link Sep 2024 – Oct 2024

• Built an end-to-end ETL pipeline using Python, dbt, and DuckDB to transform 244K+ GitHub event records into structured datasets, enabling insights into open-source activity.

• Improved pipeline efficiency by 30% by optimizing SQL with Jinja macros and resolving data quality issues during transformation.

Asteroid Hazard Classification Link Nov 2023 – Dec 2023

• Performed Exploratory Data Analysis (EDA) and statistical analysis on NASA’s dataset of 4,000+ Near-Earth Objects

(NEOs) using R, identifying key features to classify hazardous asteroids and support data-driven risk assessment.

• Built predictive models using Logistic Regression, Random Forest, and SVM to classify hazardous asteroids and support risk assessment.

Contact this candidate