Nitin Gupta

Data Analyst

Noida / Gurugram 2+ yrs exp 85 · Excellent

About

2.5+ years of experience as a Data Analyst / MIS Analyst, specializing in MIS reporting, data cleaning, and dashboard development using SQL, Power BI, and Advanced Excel. Demonstrated success in collecting and validating large datasets, building automated trackers and dashboards, and publishing daily, weekly, and monthly MIS reports with accuracy. Proficient in MySQL, Power BI (Power Query, DAX), and Excel (Pivot Tables, VLOOKUP, INDEX-MATCH), with a proven ability to turn data trends into actionable insights for management and stakeholders. Effectively collaborated with sales, operations, and compliance teams to gather data, validate records, and maintain audit-ready documentation.

Skills & Expertise (30)

Power BI Advanced

8.0/10

Years Exp

MS Excel Advanced

8.0/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Dashboard Development Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Trend Analysis Intermediate

7.0/10

Years Exp

Web Scraping Intermediate

6.5/10

Years Exp

KPI Tracking Intermediate

6.5/10

Years Exp

Formulas Index-match VLOOKUP Pivot Tables Power BI Service MIS Reporting Dashboards DAX Power Query Market Research CTEs Subqueries Window Functions Stored Procedures MySql Technical Documentation Audit Readiness process automation Stakeholder Reporting Data Modeling Ad-Hoc Reporting validation

Work Experience

Data Analyst

Alibaba / TradeFinders

May 2025 - Dec 2025

Performed web scraping, lead generation, and market research across sourcing platforms and social media to acquire B2B leads. Cleaned, validated, and managed large datasets in Microsoft Excel, preparing daily and weekly reports for sales teams. Prepared daily, weekly, and monthly MIS reports for management, tracking lead pipeline and sales performance. Designed and maintained automated Excel dashboards and trackers to streamline reporting and reduce manual effort. Analysed data trends across lead sources and conversions, presenting actionable insights to management. Coordinated lead assignment, follow-ups, and status tracking with sales and operations teams, and maintained operations databases for accurate lead and sales tracking.

KYC Analyst

WazirX

Jan 2023 - Dec 2024

Reviewed customer documents to assess account risk, ensure KYC regulatory adherence, and flag high-risk accounts for investigation. Managed large datasets in Excel, tracked KYC compliance, and generated risk reports using Pivot Tables and VLOOKUP. Prepared daily, weekly, and monthly MIS reports on KYC and compliance status for management review. Designed and maintained automated Excel trackers and dashboards to monitor onboarding and compliance status. Analysed KYC and risk trends, presenting actionable insights to management to support decision-making. Streamlined customer onboarding and coordinated with operations teams for data collection and validation. Maintained compliance databases and documentation, ensuring accuracy, consistency, and audit-readiness.