Subrat Kumar

Data Analyst

India 4+ yrs exp 89 · Excellent

About

Business-focused Data Analyst with 4+ years of experience collecting, cleaning, and analysing complex datasets to generate actionable insights for strategy, operations, and decision-making. Strong SQL proficiency for data extraction, transformation, and analysis. Advanced Excel skills for data analysis and reporting. Experienced developing Power BI and Tableau interactive dashboards and KPI reports across Finance, Sales, and Operations. Python proficiency for EDA, statistical analysis, and reporting automation. Defines, tracks, and reports KPIs; performs data validation and quality checks; investigates discrepancies; forecasts trends; and automates repetitive reporting. Clear communicator presents findings to technical and non-technical stakeholders confidently. Experienced working with cross-functional teams across business, product, finance, and operations.

Skills & Expertise (50)

SQL Advanced

8.3/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Python Advanced

7.8/10

Years Exp

Tableau Advanced

7.5/10

Years Exp

Data Quality Advanced

7.5/10

Years Exp

Excel Advanced

7.0/10

Years Exp

KPI Reporting Advanced

7.0/10

Years Exp

Pandas Advanced

7.0/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

scikit-learn Intermediate

6.0/10

Years Exp

KPI Definition Filters Window Functions CTEs Matplotlib Seaborn EDA Statistical Analysis Trend Analysis Parameters Python scripts Power Automate Flows Microsoft Fabric Qlik Sense Alteryx Git Jira Agile Scrum MATCH Stored Procedures Views Query Optimisation MS SQL Server Oracle MySql Snowflake XLOOKUP INDEX Subqueries PivotTables Power Query Power Pivot Conditional Formatting Aggregations RLS Power BI Service Calculated Fields LOD Expressions

Work Experience

Data Scientist

Dynpro India Pvt Ltd

Feb 2026 - Jun 2026

Collect, consolidate, clean, and analyse data from multiple sources identify trends, patterns, anomalies, and business opportunities; provide actionable data-driven recommendations to stakeholders. Write optimised SQL queries for data extraction and analysis; develop and maintain Power BI and Tableau dashboards; create daily, weekly, monthly, and ad-hoc reports. Define, track, and report KPIs and business performance metrics across Finance and Operations support management with data-backed insights for strategic decisions. Perform data validation and quality checks investigate discrepancies, ensure accuracy, completeness, and consistency; maintain governance and documentation standards. Automate repetitive reporting and data preparation using Python scripts and Power Automate; support data engineers on data availability and reporting requirements. Present analytical findings to technical and non-technical stakeholders; collaborate cross-functionally with business, product, and operations teams.

Software Developer – Analytics & BI

Mobile Programming.com LLP

Aug 2024 - Feb 2026

Collected, consolidated, cleaned, and analysed large datasets (1M+ rows) from SQL Server, Snowflake, REST APIs, and Excel identified trends and patterns across Finance, Sales, and Operations; generated 12+ actionable recommendations adopted by leadership. Wrote efficient, optimised SQL across SQL Server, and Snowflake complex joins, CTEs, window functions, stored procedures; reduced query execution time by 40%. Developed and maintained 15+ Power BI and 5+ Tableau interactive dashboards and KPI reports daily, weekly, and monthly performance reporting for 150+ cross-functional stakeholders. Defined, tracked, and reported KPIs and business metrics collaborated with Finance, Sales, and Operations teams to establish and measure performance indicators. Performed data validation and quality checks cross-system SQL reconciliation across 10+ sources maintained <2% error rate; investigated and resolved data discrepancies proactively. Used Python (Pandas, NumPy, Scikit-learn) for EDA, statistical trend analysis, forecasting, and ML model development; surfaced outputs in Power BI for business consumption. Automated repetitive reporting Python scripts and Power Automate workflows saved 20+ hours of weekly manual effort; Fabric Pipelines for data pipeline automation. Used advanced Excel (XLOOKUP, PivotTables, Power Query, nested formulas) for operational analysis and supplementary ad-hoc reporting. Presented findings to technical and non-technical audiences in structured, audience-appropriate formats; maintained dashboard, dataset, and reporting documentation throughout.

Associate Consultant – Analytics & BI

Avensys Consulting

Jun 2022 - Aug 2024

Collected, cleaned, and analysed complex datasets for 8+ BFSI and retail clients Power BI/Tableau dashboards, SQL-based analysis, KPI reporting, data quality checks, and automated reporting workflows. Investigated data discrepancies and resolved quality issues across multiple source systems; maintained documentation and governance standards across all engagements. Presented insights to both technical and non-technical client stakeholders; collaborated with data engineers on data availability and reporting requirements.

BI Developer

Team Computers

Dec 2021 - May 2022

Collected and analysed business data; wrote SQL for extraction; built Power BI/Tableau dashboards; defined KPIs; validated data quality; automated reporting; documented analytical solutions.