Headline

Data Analyst | SQL · Python · Power BI · Advanced Excel | Fraud, Reconciliation & Financial Analytics | MCA 2026

About

I'm a data analyst (MCA, 2026) who works where data quality meets financial risk. Over a 5-month data analytics internship and hands-on projects, I've investigated discrepancies across 1M+ records, built reconciliation and fraud-detection workflows, and turned messy data into audit-ready reports. What I do day to day: • Extract, clean and validate large datasets in SQL and Python — 99%+ data accuracy maintained across 1M+ transaction records • Build automated reconciliation and exception workflows (97%+ auto-match on 9,800+ records, maker-checker controls, full audit trail) • Detect fraud-risk patterns and financial anomalies with structured, compliance-ready documentation • Quantify leakage and revenue opportunities — including a $140K revenue opportunity surfaced through KPI analysis and a ₹7.3 Lakh billing-leakage engine with 100% precision/recall vs ground truth • Deliver Power BI dashboards (DAX, Power Query) and Excel MIS that leadership can act on Core stack: SQL · Python (pandas) · Power BI · Advanced Excel · Statistics Education: MCA — APJ Abdul Kalam Technical University, Lucknow BCA — Chaudhary Charan Singh University, Meerut Certifications: Data Analytics Professional + AI (Ducat Institute) · AI for Business (HP LIFE) · SEBI & NISM Financial Literacy Quiz — Top Scorer Open to: Data Analyst / Business Analyst / Financial Analyst roles (fresher band) — India or remote.

Location

Ghaziabad

AI stack

claude code

claude

codex

deepmind

deepseek

gemini

Work experience

Data Analyst at Ducat India, Mar 2026 - Aug 2026 · 6 mos, Noida, Uttar Pradesh, India, Data analytics internship covering fraud risk analytics, financial reconciliation and sales performance reporting on 1M+ records. • Investigated data discrepancies and anomalies across multiple datasets following defined review procedures and escalation paths • Performed data-quality checks in SQL and Python on 1M+ records, resolving exceptions and maintaining clear documentation for audit purposes — 99%+ data accuracy • Reduced risk exposure by 12% through structured investigation and compliance-ready reporting • Coordinated with team members to clarify queries and resolve day-to-day issues within defined timelines

Education

Master of Computer Applications, Computational Science, Dr. A.P.J. Abdul Kalam Technical University (AKTU), Lucknow

Bachelors of Computer Applications - BCA, Computer Science, CCS (Chaudhary Charan Singh)University

Public links

github: https://github.com/Manish-Kum4r

manish-analyst.kesug.com: https://manish-analyst.kesug.com/