savan kumar

Data Analyst

Noida, Uttar Pradesh 1+ yrs exp 83 · Excellent

About

Analytical and detail-oriented Data Analyst with proven experience in data cleaning, modeling, visualization, and reporting to support data-driven decision-making. Skilled in Power BI, Excel, and SQL for creating dynamic dashboards, generating actionable insights, and optimizing business processes. Adept at trend analysis, forecasting, and process automation, with a strong ability to translate complex data into clear business recommendations.

Skills & Expertise (25)

Power Query Intermediate

7.4/10

0.5

Years Exp

Data Cleaning Intermediate

7.4/10

0.5

Years Exp

Transformation Intermediate

7.4/10

0.5

Years Exp

validation Intermediate

7.4/10

0.5

Years Exp

SQL query writing Intermediate

7.4/10

0.5

Years Exp

Power BI Intermediate

7.4/10

0.5

Years Exp

Pivot Tables Intermediate

7.4/10

0.5

Years Exp

VLOOKUP Intermediate

7.4/10

0.5

Years Exp

KPI Tracking Intermediate

6.2/10

0.5

Years Exp

Excel Dashboards Intermediate

6.2/10

0.5

Years Exp

DAX Intermediate

6.2/10

0.5

Years Exp

correlation analysis Intermediate

6.2/10

0.5

Years Exp

Trend Identification Intermediate

6.2/10

0.5

Years Exp

Forecasting Intermediate

6.2/10

0.5

Years Exp

Critical thinking Intermediate

6.2/10

0.5

Years Exp

stakeholder communication Intermediate

6.2/10

0.5

Years Exp

Problem-solving Intermediate

6.2/10

0.5

Years Exp

Advanced Formulas Intermediate

6.2/10

0.5

Years Exp

Index-match Intermediate

6.2/10

0.5

Years Exp

Data optimization Intermediate

6.2/10

0.5

Years Exp

Aggregations Intermediate

6.2/10

0.5

Years Exp

Joins Intermediate

6.2/10

0.5

Years Exp

ETL Intermediate

6.2/10

0.5

Years Exp

Report Scheduling Intermediate

6.2/10

0.5

Years Exp

Excel Macros Intermediate

6.2/10

0.5

Years Exp

Work Experience

Data Analyst

Paytm Payments Bank

Apr 2025 - Present

Designed and maintained Power BI dashboards tracking KPIs across sales, operations, and customer engagement. Extracted and analyzed large datasets using SQL to uncover insights, optimize workflows, and identify anomalies. Automated weekly and monthly reporting processes, reducing report preparation time by 40%. Collaborated with cross-functional teams to deliver insights that improved operational efficiency by 15%. Developed trend analysis and forecasting models to support strategic decision-making.

Data Analyst Intern

Power Data Analytics

Jan 2025 - Mar 2025

Collected, cleaned, and validated large datasets, ensuring data accuracy before reporting. Built interactive Power BI dashboards for sales performance and customer trend analysis. Used Excel Power Query and SQL to automate recurring reports, saving 10+ hours of manual work per week. Delivered data-driven insights in stakeholder presentations, enhancing decision-making effectiveness.