Md Farzan

Data Analyst

Noida, Uttar Pradesh, India 3+ yrs exp 93 · Outstanding

About

Data Analytics professional with 3 years of experience in operational analysis, performance monitoring, data reporting, and business process optimization within enterprise environments. Proficient in Microsoft SQL Server (T-SQL), Power BI, Python (Pandas, NumPy, Matplotlib, Seaborn, SciPy, and Scikit-learn), Advanced Excel, and Power Query. Experienced in data cleaning, ETL, Exploratory Data Analysis (EDA), dashboard development, KPI reporting, Root Cause Analysis (RCA), and transforming complex datasets into actionable business insights. Passionate about leveraging data to support business decisions and drive continuous process improvement.

Skills & Expertise (42)

Exploratory data analysis Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Dashboard Development Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Advanced Excel Intermediate

7.5/10

Years Exp

Pandas Intermediate

7.5/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Pivot Tables Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Power Query Intermediate

7.5/10

Years Exp

scikit-learn Intermediate

7.0/10

Years Exp

Matplotlib Intermediate

7.0/10

Years Exp

XLOOKUP Intermediate

7.0/10

Years Exp

VLOOKUP Intermediate

7.0/10

Years Exp

Index-match Intermediate

7.0/10

Years Exp

Conditional Formatting Intermediate

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Statistical Analysis Intermediate

7.0/10

Years Exp

Root Cause Analysis Intermediate

7.0/10

Years Exp

Trend Analysis Intermediate

7.0/10

Years Exp

Data Transformation Intermediate

7.0/10

Years Exp

Business Reporting Intermediate

7.0/10

Years Exp

Process Improvement Intermediate

7.0/10

Years Exp

Seaborn Intermediate

7.0/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

Data Modeling Intermediate

7.0/10

Years Exp

KPI Reporting Intermediate

7.0/10

Years Exp

NumPy Intermediate

7.0/10

Years Exp

SciPy Intermediate

7.0/10

Years Exp

Microsoft SQL Server Intermediate

6.8/10

Years Exp

Views Intermediate

6.5/10

Years Exp

Stored Procedures Intermediate

6.5/10

Years Exp

Window Functions Intermediate

6.5/10

Years Exp

Common Table Expressions Intermediate

6.5/10

Years Exp

Subqueries Intermediate

6.5/10

Years Exp

Joins Intermediate

6.5/10

Years Exp

Power BI Service Intermediate

6.0/10

Years Exp

ETL Intermediate

6.0/10

Years Exp

ServiceNow Intermediate

6.0/10

Years Exp

GitHub Intermediate

6.0/10

Years Exp

RLS

Work Experience

Analyst

HCLTech

Sep 2022 - Jun 2026

Analyzed operational and incident data for Cisco collaboration devices to identify recurring issues, performance trends, and root causes across global enterprise environments. Developed interactive Power BI dashboards to track KPIs including device downtime, software upgrade impact, location-wise incidents, and issue frequency across 15,000+ Cisco collaboration devices, enabling data-driven decisions that reduced repeat incidents by 20%. Performed Root Cause Analysis (RCA) using operational data and ServiceNow records to support faster issue resolution and improve service reliability. Delivered weekly KPI reports and trend analysis to team leads and managers, enabling data-driven decisions for SLA adherence and process improvement. Prioritized monitoring of business-critical devices used by executive leadership, improving incident response and minimizing service disruption.