Sai kumar Kumar

Data Analyst

Pronix Inc

Nov 2024 - Jun 2026

Built and maintained interactive Power BI dashboards for sales, inventory, customer, marketing, and loan portfolio reporting. Created DAX measures, drill-through reports, and dynamic filters to help business users analyse data more effectively. Validated large customer, transaction, and financial datasets by identifying missing values, duplicate records, and data inconsistencies before publishing reports, ensuring accurate and reliable business reporting. Wrote SQL queries and Python scripts to extract, clean, and transform raw data for reporting. Used Power Query to prepare datasets and support automated data refresh processes. Analysed customer behaviour, campaign performance, and business trends to identify improvement opportunities. Shared insights with stakeholders to support data-driven decision-making. Designed star schema data models and developed DAX measures for time intelligence, KPI reporting, growth analysis, and performance comparisons while optimizing Power BI models for faster report performance. Created ad-hoc reports and dashboards based on changing business requirements, working closely with stakeholders to deliver timely insights and customized analyses. Collaborated with sales, marketing, finance, and business teams to understand reporting requirements, define KPIs, and integrate data from multiple sources into meaningful dashboards. Developed an interactive Power BI dashboard to monitor loan portfolio performance using SQL Server data. Designed a star schema data model, validated data using SQL, and created DAX measures for MTD, Month-over-Month growth, Good Loan %, Bad Loan %, and other lending KPIs to support portfolio analysis.