Ishan Negi

Business Analyst

Profile Score

About

Data-driven Business Analyst with 1.8+ years of experience in SQL-driven analysis, advanced Excel, and dashboard development. Proven ability to clean, analyze, and visualize data to uncover trends and drive business decisions. Strong in data validation, KPI tracking, and building scalable reporting systems using Excel, SQL, and Tableau.

Skills & Expertise (26)

SQL Advanced

8.2/10

Years Exp

Tableau Intermediate

7.5/10

Years Exp

Excel Advanced

7.0/10

Years Exp

Pivot Tables MS Office Google Sheets Jira Data Reconciliation Trend Analysis KPI Analysis Gap Analysis data mapping Data Validation Automation Index-match XLOOKUP Google Cloud Platform Filters KPI Tracking Dashboards validation Data Extraction Aggregations CTEs Joins BigQuery

Work Experience

Business Analyst

Tech2globe

Sep 2024 - Jan 2026

Performed data mapping and gap analysis across multiple datasets, identifying inconsistencies and aligning business requirements with data structures. Wrote complex SQL queries (joins, CTEs, aggregations) to extract, transform, and validate data, improving data accuracy and reducing discrepancies in reporting. Consolidated data findings into structured reports and dashboards, providing an end-to-end view of business metrics and requirements. Collaborated closely with business stakeholders to clarify data requirements, define KPIs, and ensure alignment with reporting outputs. Built Tableau dashboards enabling real-time KPI tracking, improving visibility and decision-making for stakeholders. Designed Excel-based reporting systems and automated workflows, reducing manual effort by ~30% and improving reporting efficiency. Conducted detailed data validation and reconciliation, ensuring high data quality across reporting pipelines. Delivered ad-hoc data analysis and investigations, supporting quick turnaround on business queries and issue resolution. Documented data logic, transformations, and reporting structures, ensuring clear traceability and knowledge transfer.

Business Analyst Intern

Tech2Globe Web Solutions

Mar 2024 - Aug 2024

Assisted in data mapping and requirement analysis for reporting use cases. Cleaned and structured raw datasets, improving data readiness for analysis and reporting. Built Excel dashboards to track KPIs, enhancing stakeholder visibility. Supported SQL-based data extraction and validation tasks. Collaborated with teams to ensure alignment between data outputs and business expectations.