Swayam Prakash Pradhan

Data Analyst

Bengaluru, India 1+ yrs exp 83 · Excellent

About

Data Analyst with 1.6 years of experience in Power BI dashboard development, SQL-based data analysis, reporting automation, and business analytics. Skilled in SQL, Python, Excel, Power BI, Power Query, and SQL Server, with experience in ETL workflows, KPI reporting, data cleaning, and stakeholder reporting. Experienced in automating reports, developing interactive dashboards, analyzing business trends, and delivering data-driven insights to support business decisions.

Skills & Expertise (37)

Excel Advanced

8.0/10

1.6

Years Exp

Power BI Advanced

8.0/10

1.6

Years Exp

SQL Intermediate

7.5/10

1.6

Years Exp

Data Cleaning Intermediate

7.5/10

1.6

Years Exp

Python Intermediate

7.5/10

1.6

Years Exp

ETL workflows Intermediate

7.5/10

1.6

Years Exp

MySql Intermediate

7.0/10

1.6

Years Exp

SQL Server Intermediate

7.0/10

1.6

Years Exp

KPI Reporting Intermediate

7.0/10

1.6

Years Exp

Data Validation Intermediate

7.0/10

1.6

Years Exp

Pandas Intermediate

7.0/10

1.6

Years Exp

NumPy Intermediate

6.5/10

1.6

Years Exp

DAX Intermediate

6.5/10

1.6

Years Exp

Matplotlib Intermediate

6.0/10

1.6

Years Exp

Seaborn Intermediate

6.0/10

1.6

Years Exp

Business Insights EDA RFM Segmentation Power Query Conditional Formatting Index-match VLOOKUP Trend Analysis XLOOKUP Pivot Tables Tableau Slicers KPI Dashboards Calculated Columns Task Automation Aggregations LAG RANK Window Functions CTEs Subqueries Joins

Work Experience

Data Analyst

Mediafirewall AI

Sep 2024 - Apr 2026

Designed and maintained interactive Power BI dashboards to track SLA compliance, KPIs, and incident volumes, improving transparency and supporting real-time decision-making for clients. Automated daily Excel-based reports using Python scripts, SQL queries, and Windows Task Scheduler, eliminating repetitive manual work and saving 4–5 hours per day. Built end-to-end ETL workflows using Power Query and SQL Server, enabling live data connections and improving data consistency across reports. Created and presented governance decks with key performance metrics, trend analysis, and visual insights to senior stakeholders during regular review meetings. Collaborated with business and technical teams to gather requirements, perform data analysis, and deliver actionable insights aligned with business objectives.