MANISH Kumar singh

Business Intelligence Analyst & Power BI Developer

Ghaziabad, India 5+ yrs exp 90 · Outstanding

About

Business Intelligence Analyst & Power BI Developer with 5+ years of experience in data analytics, business operations reporting, and dashboard development. Skilled in designing scalable Power BI dashboards and SQL-based analytics solutions to monitor operational performance, service metrics, and business KPIs across enterprise systems. Experienced in transforming complex datasets into actionable insights that support sales operations, forecasting accuracy, and data-driven decision making. Strong background in data modeling, KPI development, and performance optimization with proven ability to collaborate with finance, operations, and cross-functional stakeholders to improve reporting processes and operational efficiency.

Skills & Expertise (81)

Power BI Expert

9.2/10

Years Exp

Advanced DAX Advanced

8.6/10

Years Exp

Data Visualization Advanced

8.4/10

Years Exp

Multi-Source Data Integration Requirement gathering Evaluation & Adoption of AI Tools Reporting Acceleration Insight Automation Requirement Summarization Data Profiling DAX/SQL Generation OpenAI GPT Microsoft Copilot Sales & Operational Performance Analysis Workflow Automation Flat File Integration API Integration Gateway Management Scheduled Refresh SharePoint Integration Power Apps Power Automate Incident Trend Analysis QA Validation security Version Control Dataset Governance Workspace & Role-Based Access Management Power BI Service Administration Operational KPI dashboards Process governance reporting Service performance monitoring KPI Definition Technical Documentation Root Cause Analysis Ad-hoc Analysis MIS Reporting Revenue & Business Performance Reporting UAT Support Agile/Sprint Methodology Stakeholder Management Incident Trend Analysis RLS Advanced SQL Data Blending Dashboards Tableau Gateway Configuration Deployment Pipelines Apps Power BI Service Executive & Operational Dashboard Design T-SQL Performance Optimization Dataflows Power Query Hierarchies Drill-through KPIs Time intelligence Calculation Groups Semantic Models Large Dataset Handling Service Performance Reporting Process Performance Analysis Operational KPI Monitoring Data Normalization Surrogate Keys Fact-Dimension Design Snowflake Schema Star Schema Dimensional Data Modeling Continuous Improvement Analytics Complex Joins Indexing Execution Plan Analysis Query Optimization Data Extraction Stored Procedures Window Functions CTEs

Work Experience

Business Intelligence Analyst

Renesas Electronics

Dec 2024 - Present

Designed and maintained Power BI dashboards and semantic models tracking revenue performance, operational KPIs, and business metrics to support leadership decision-making. Partnered with finance, sales operations, and cross-functional stakeholders to define KPIs, validate data accuracy, and ensure reporting aligned with business requirements. Performed trend analysis and root cause analysis to identify operational issues and recommend process improvements. Built Power BI dashboards monitoring operational performance, service metrics, and process KPIs, enabling teams to identify trends and improve operational efficiency. Developed complex SQL queries using CTEs and window functions to analyze large datasets and support operational and financial reporting. Built interactive dashboards enabling teams to monitor business performance, identify trends, and perform root-cause analysis for operational issues. Optimized dataset performance by improving data models, reducing cardinality, and implementing incremental refresh strategies. Implemented time intelligence metrics (MOM, YOY, YTD) and enhanced data models using optimized relationships and hierarchies. Supported data governance, RLS implementation, and dataset lifecycle management within Power BI Service environments. Performed data validation, reconciliation, and governance checks to ensure accuracy and reliability of reporting datasets. Collaborated with stakeholders to deliver executive dashboards and presentations highlighting KPI performance, operational risks, and improvement opportunities.

Senior Executive – Business Intelligence

Moglix

Oct 2023 - Feb 2024

Designed and deployed interactive Power BI dashboards analyzing sales performance, revenue trends, and operational KPIs for executive leadership. Built optimized star-schema data models improving reporting performance and dashboard usability. Developed reusable datasets supporting self-service analytics and operational reporting. Automated recurring reports using Power Automate, reducing manual effort by 35% and improving reporting efficiency. Delivered data-driven insights supporting operational decision-making and performance improvement initiatives.

Analyst

Shop Clues

Jan 2020 - Sep 2023

Extracted, transformed, and modeled large datasets using SQL for Power BI reporting solutions. Developed dashboards tracking marketing, operations, and workforce KPIs used by mid and senior leadership. Optimized reporting workflows reduce turnaround time by 25%. Conducted trend and variance analysis to identify performance gaps and improvement opportunities. Worked in an agile environment with business stakeholders to refine reporting requirements. Improved reporting turnaround time by streamlining data preparation and refreshing processes.