Pankaj Suryawanshi

Data Analyst

Pune, India 2+ yrs exp 86 · Excellent

About

Data Analyst with nearly 3 years of experience building automated ETL pipelines, robust data models, and high-quality data foundations. Proven ability to collaborate with cross-functional teams and business SMEs to translate complex business needs into actionable, high-integrity data solutions that drive strategic decisions.

Skills & Expertise (36)

English Advanced

8.0/10

Years Exp

Hindi Advanced

7.0/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Python Intermediate

6.8/10

Years Exp

MS SQL Server Intermediate

6.5/10

Years Exp

Jupyter Notebook Intermediate

6.5/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

Data Analysis Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.5/10

Years Exp

Advanced Excel Intermediate

6.5/10

Years Exp

Cleaning Intermediate

6.5/10

Years Exp

ETL Intermediate

6.5/10

Years Exp

Marathi Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

Data Blending Intermediate

6.0/10

Years Exp

Alteryx Intermediate

6.0/10

Years Exp

Jira Intermediate

6.0/10

Years Exp

Git Intermediate

6.0/10

Years Exp

Regression Intermediate

5.5/10

Years Exp

ER diagrams Intermediate

5.5/10

Years Exp

AWS Intermediate

5.5/10

Years Exp

Matplotlib Intermediate

5.5/10

Years Exp

RFM Analysis Intermediate

5.5/10

Years Exp

Hypothesis Testing Intermediate

5.5/10

Years Exp

Clustering Intermediate

5.5/10

Years Exp

Seaborn Beginner

5.0/10

0.5

Years Exp

Oracle Beginner

5.0/10

0.5

Years Exp

Lambda Beginner

5.0/10

0.5

Years Exp

Athena Beginner

5.0/10

0.5

Years Exp

Star Schema Beginner

5.0/10

0.5

Years Exp

Snowflake Schema Beginner

5.0/10

0.5

Years Exp

scikit-learn Beginner

5.0/10

0.5

Years Exp

Databricks Beginner

5.0/10

0.5

Years Exp

Python (Pandas, NumPy, SciPy)

Work Experience

Data Analyst

Grace Infosoft Pvt Ltd

Feb 2024 - Present

Built an interactive Power BI dashboard for region-wise performance tracking. Enabled real-time KPI monitoring (sales, profit, return rate, average order value). Provided drill-down capabilities by category, sub-category, customer segment, and ship mode. Partnered with business SMEs to gather requirements and define data structures for accurate mapping and sourcing. Designed and managed automated Alteryx ETL workflows and data validation pipelines, ensuring high-quality, clean, and optimized data layers for downstream network analytics and reporting. Developed robust database schemas using SQL and Python to extract, transform, and model complex datasets, resulting in a 15% boost in strategic business revenue. Led data quality checks and root-cause analysis to cut operational errors by 18%, using UAT to validate data across environments. Formulated and automated interactive Power BI and Tableau KPI dashboards; presented technical findings, scalability recommendations, and progress updates clearly to business leaders and stakeholders.

Data Science Intern

Flip Robo Technologies

Jul 2022 - Jan 2023

Processed, cleansed, and analyzed datasets containing up to 1 million records, identifying operational trends and pattern distributions to drive optimization initiatives. Maintained a 99% data accuracy rate by implementing strict validation protocols, ensuring high standards of data quality, completeness, and end-to-end security. Designed impactful data visualizations using Python and statistical tools, simplifying complex datasets to aid diverse stakeholders in achieving a 15% increase in data-driven decisions.