Mohd Zaid Ahmad

Business Analyst

Kanpur 0+ yrs exp 87 · Excellent

About

Detail-oriented BBA graduate with internship experience in business analysis, MIS reporting, transaction processing, document validation, operational support, and data management. Proficient in Advanced Excel, SQL, record verification, and process documentation, with a strong focus on data integrity, SLA adherence, quality assurance, and operational excellence. Experienced in managing structured business data, workflow management, data reconciliation, maintaining reporting accuracy, and supporting process improvement in fast-paced environments. Lean Six Sigma Green Belt (AIGPE) certified, with strong analytical, problem-solving, root cause analysis, and continuous improvement skills. Completed industry simulations with McKinsey, BCG, and Deloitte, available for Immediate joining.

Skills & Expertise (37)

Pivot Tables Intermediate

6.5/10

Years Exp

VLOOKUP Intermediate

6.5/10

Years Exp

XLOOKUP Intermediate

6.5/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Conditional Formatting Intermediate

6.5/10

Years Exp

Data Cleansing Intermediate

6.5/10

Years Exp

Advanced Excel Intermediate

6.5/10

Years Exp

Data Analysis Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Business Analysis Intermediate

6.0/10

Years Exp

Data Management Intermediate

6.0/10

Years Exp

Data Auditing Intermediate

6.0/10

Years Exp

SQL Intermediate

5.5/10

Years Exp

Stakeholder Management Intermediate

5.5/10

Years Exp

Microsoft PowerPoint Microsoft Word Microsoft Outlook Microsoft Excel Turnaround Time SLA Adherence Quality assurance Process Documentation workflow management AI Tools Transaction Processing Decision Support performance reporting Trend Analysis Data Reconciliation Data Integrity KPI Reporting MIS Reporting COUNTIF SUMIF COUNT If Sorting & Filtering

Work Experience

Business Analyst Intern

Merchit Technologies

May 2025 - Jul 2025

Performed data analysis and performance reporting using Advanced Excel (Pivot Tables, VLOOKUP, XLOOKUP) and Power BI to track 6–8 KPIs while maintaining data accuracy while meeting SLA requirements. Identified process improvement opportunities through data cleansing and trend analysis, improving workflow efficiency by 15–20% and implementing corrective actions to support timely report delivery. Prepared KPI reports and operational metrics for leadership, supporting performance monitoring and business decision-making, collaborated with cross-functional teams to resolve reporting issues and ensure timely delivery.

Human Resources Intern

Cook N Klean – Cnear

Sep 2024 - Nov 2024

Executed high-volume data entry, documentation, records filing, and document verification while ensuring data accuracy and compliance; drafted 25+ job descriptions, screened 60+ candidates and produced formal HR documents while maintaining audit trail standards. Built candidate tracking sheets using Advanced Excel (Pivot Tables, VLOOKUP, Data Validation); performed document validation, records verification, quality assurance checks; identified process gaps and implemented corrective actions. Demonstrated ownership and prioritization; provided team training; received a formal recommendation from HR leadership for data accuracy, quality assurance standards, and commitment to excellence.

Business Outreach Intern

FlippySustainables

Jul 2024 - Sep 2024

Maintained 30+ CRM records by performing data validation and data cleansing, ensuring accurate documentation and confidentiality and data integrity. Prepared professional client communications for 3–5 business segments, supporting stakeholder engagement and improving communication. Coordinated follow-ups and team communication through Microsoft Outlook and Teams, supporting timely execution of business outreach activities across 3–5 market segments.

Business Analyst Intern

Hilfee

Mar 2024 - Jun 2024

Prepared MIS reports, dashboards, and business presentations to track 10+ KPIs using Power BI. Performed data validation and quality checks, reducing manual reporting time by 30–40% through report automation. Conducted 5 market research studies and 3 competitor analyses, delivering reporting insights and variance analysis to senior stakeholders through PowerPoint presentations. Identified workflow improvement opportunities using AI-assisted tools and Advanced Excel (VLOOKUP), improving reporting productivity by 25% and developed SOPs to standardize reporting processes.