Back to Developers
Pappu Yadav

Pappu Yadav

Data Analyst

Kolkata, India
74
Profile Score

About

Results-driven professional with over 3 years of experience in data analytics, operations, and reporting. Skilled in Advanced Excel (Pivot Tables, Macros, VBA), Power BI, SQL, and Python with a strong background in OPEX process improvement and MIS reporting. Adept at designing dashboards, analyzing performance metrics, and supporting data-driven decision-making to improve operational efficiency. Known for accuracy, analytical thinking, and delivering timely business insights.

Skills & Expertise (9)

Advanced Excel (VLOOKUP, Pivot Tables, Macros, VBA) Intermediate
7.5/10
1
Years Exp
Power BI Dashboard Development Intermediate
7.3/10
1
Years Exp
SQL (Joins, Stored Procedures, Query Optimization) Intermediate
7.3/10
1
Years Exp
Stakeholder & Team Collaboration Intermediate
7.2/10
1
Years Exp
MIS Reporting & Data Analysis Intermediate
7.1/10
1
Years Exp
Data Cleansing, Auditing, and Validation Intermediate
7.1/10
1
Years Exp
Performance Metrics & KPI Tracking Intermediate
7.0/10
1
Years Exp
Process Standardization (OPEX Implementation) Intermediate
6.9/10
1
Years Exp
Python Beginner
6.0/10

Work Experience

Manual Tester

Wipro

May 2022 - Feb 2023

Conducted functional and regression testing for internal software systems. Documented test cases, tracked defects, and collaborated with development teams to improve accuracy and performance.

Supply Chain Analyst

Wipro

Mar 2023 - Aug 2023

Monitored procurement and logistics data to identify cost-saving opportunities. Automated repetitive Excel-based reporting tasks using formulas and macros, reducing manual effort by 40%. Assisted in standardizing operational processes aligned with OPEX principles.

Data Analyst

Wipro

Feb 2023 - Present

Designed and automated MIS reports and dashboards in Excel and Power BI to track efficiency, utilization, and performance metrics. Optimized SQL queries for faster data extraction and improved report accuracy by 25–30%. Conducted data validation and audits to ensure quality and consistency in business reports. Supported OPEX standardization initiatives by documenting workflows and improving reporting templates. Partnered with stakeholders to analyze supply chain performance, leading to measurable cost reduction.

Education

Bachelor’s Degree in Computer Science and Engineering - Amritsar College of Engineering and Technology

2018 - 2022 · Afghanistan

Senior Secondary (Class 12) - ABDULLAH M INT College

2016 - 2018 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 14/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 74/100

Profile Overview

Member sinceFeb 2026

Skills (9)

Advanced Excel (VLOOKUP, Pivot Tables, Macros, VBA) Power BI Dashboard Development SQL (Joins, Stored Procedures, Query Optimization) Stakeholder & Team Collaboration MIS Reporting & Data Analysis Data Cleansing, Auditing, and Validation Performance Metrics & KPI Tracking Process Standardization (OPEX Implementation) Python