Looking for a job

sonu prajapati

@sonuprajapati

Message

BI & Reporting Analyst at Vibgyor Group of Schools, creating KPI dashboards and automating recurring reports.

India

Message

At Vibgyor Group of Schools, I design and maintain interactive dashboards to track business KPIs, analyse datasets, and support strategic decisions. I also automate recurring reports and perform trend analysis, forecasting, and performance tracking.

Previously, I designed Power BI dashboards and data models at Tech Mahindra Ltd. and delivered BI reporting at NCR Corporation Pvt. Ltd. My project work includes dashboards for pizza sales, bike sharing, bank loans, and car sales, using SQL, Power BI, and Excel.

Experience

Work history, roles, and key accomplishments

Current

Sr. BI & Reporting Analyst

Current

Vibgyor Group of Schools

Jul 2025 - Present (1 year 3 months)

Design and maintain interactive dashboards to track business KPIs. Analyse large datasets to generate actionable insights and automate recurring reports.

Power BI SQL Dashboard Design Data Analysis Report Automation Trend Analysis Forecasting

Current

BI & Reporting Analyst

Current

Vibgyor Group of Schools

Nov 2023 - Present (2 years 11 months)

Built Power BI dashboards for school operations leadership, enabling KPI monitoring across multiple locations. Wrote complex SQL queries and automated MIS reports using Excel Macros.

Power BI SQL MSSQL Excel Macros VBA Data Ingestion BULK INSERT KPI Monitoring

Sr. Business Data Analyst – BI

Tech Mahindra Ltd.

Jul 2022 - Oct 2023 (1 year 3 months)

Designed a C-level performance review dashboard in Power BI, consolidating KPIs from multiple business units. Built data models with DAX measures and maintained MSSQL databases.

Power BI DAX Data Modeling MSSQL SQL Database Optimization Self Service Analytics

BI Analyst

NCR Corporation Pvt. Ltd.

Dec 2017 - Jun 2022 (4 years 6 months)

Delivered end-to-end BI reporting using SAP and Advanced Excel for Telecom and Finance clients. Built Power BI dashboards with KPI cards, trend charts, and drill-through filters.

SAP Excel Power BI KPI Dashboards Reporting Data Accuracy

MIS Executive

Aptech Pvt. Ltd.

May 2016 - Nov 2017 (1 year 6 months)

Managed daily/weekly MIS reporting in Advanced Excel using Pivot Tables, VLOOKUP, SUMIFS, and COUNTIFS for KPI tracking. Standardized reporting templates to reduce errors.

Excel Pivot Tables V Lookups Sumifs COUNTIFS MIS Reporting KPI Tracking