Headline

Data Analyst | SQL, Python, Statistics & Machine Learning | Pandas, NumPy, Scikit-learn | Power BI, Tableau | AWS, Azure | Generative AI

About

I don't just analyze data — I find the story hiding inside it. I'm Pawan Kumar Yadav, a Data Analyst with hands-on experience in Python, SQL, Power BI, and machine learning. I'm currently working as a Data Analyst at Ducat India and completed my MCA from AKTU Lucknow, where I spent most of my time building real projects rather than just reading textbooks. What I've actually built and done: → Trained an ML classification model with 85%+ accuracy for a Medical Recommendation System → Analyzed Diwali sales data in Python to surface customer trends and seasonal patterns → Worked with Dockerized PostgreSQL for data synchronization and backup management → Completed IBM training in Python, ML & AI — certified in Data Concepts & ML (IBM), SQL (HackerRank), Git & GitHub Right now, I'm at Ducat India as a Data Analyst, working with real datasets, building dashboards, and writing SQL queries that actually answer business questions — not just homework problems. If you're a recruiter, hiring manager, or fellow data enthusiast — let's connect. I'm open to full-time Data Analyst roles (Noida/Delhi NCR or remote). If you want to see my work, check my GitHub below.

Location

Noida

Work experience

Data Analyst at So.Infotech PrivateLimited.,Noida(Up), Apr 2026 - Present · 4 mos, Noida, Uttar Pradesh, India, Working as a Data Analyst at Ducat India, applying Python, SQL, and Power BI to real business datasets. • Analyze structured datasets using Python (Pandas, NumPy) to identify trends, outliers, and actionable patterns • Write complex SQL queries against PostgreSQL databases to extract, transform, and aggregate business data • Build and maintain Power BI dashboards tracking KPIs for internal teams and stakeholders • Automate repetitive data reporting tasks using Python scripts, reducing manual effort by 40%

Data Analyst at IBM, Sep 2024 - Sep 2024 · 1 mo, Lucknow, Completed an intensive 1-month IBM training program covering Python, Machine Learning, and AI fundamentals. • Practiced end-to-end ML workflows: data preprocessing, feature engineering, model training, and evaluation • Applied supervised learning algorithms using Scikit-learn on structured datasets • Completed certified training in Data Concepts and Machine Learning, issued by IBM (Jan 2024) • Gained hands-on exposure to AI tools and cloud-based data workflows

Training Specialist at IBM, Sep 2024 - Sep 2024 · 1 mo

Artificial Intelligence Intern at IBM, Aug 2024 - Sep 2024 · 2 mos, Lucknow, Completed an intensive 1-month IBM training program covering Python, Machine Learning, and AI fundamentals. • Practiced end-to-end ML workflows: data preprocessing, feature engineering, model training, and evaluation • Applied supervised learning algorithms using Scikit-learn on structured datasets • Completed certified training in Data Concepts and Machine Learning, issued by IBM (Jan 2024) • Gained hands-on exposure to AI tools and cloud-based data workflows

Education

Master of Computer Applications - MCA, Computer Application, Dr. A.P.J. Abdul Kalam Technical University (AKTU), Lucknow

O level, Computer and Information Sciences and Support Services, NEILIT