John Wilson

Data Analyst with strong foundations in SQL, R, Excel, and Tableau. Skilled in Python (Pandas, NumPy, Matplotlib) for data manipulation. Skilled in data cleaning, exploratory analysis, and building dashboards to generate actionable insights. Possess an analytical mindset with a commitment to continuous learning and applying data-driven solutions to business and financial problems.

Data Analytics Intern at Decode Data Academy (2025-01 – 2026-12)

• Performed data cleaning and preprocessing on structured datasets of 50K+ records using Python and SQL, improving data quality and reducing null/inconsistent entries by 30%.
• Conducted end-to-end exploratory data analysis (EDA) on 300+ student records from multiple competitive coding contests to identify trends, outliers, and performance metrics.
• Developed multi-page Power BI dashboards using DAX, slicers, and dynamic filters to visualize KPIs, reducing manual reporting effort by 40%.
• Generated business insights by identifying low-performing student segments and presented findings to stakeholders, supporting data-driven decision-making.

Trainee / Intern at Magnum Group (2024-01 – 2024-12)

• Worked on Government e-Marketplace (GeM) platform, understanding procurement and data workflows.
• Supported product listings and order processing activities.
• Handled basic data tracking and reporting tasks.

Intern at Bhopal District Court (2023-01 – 2024-12)

• Managed and organized large volumes of case-related data and legal documentation for efficient retrieval.
• Reviewed case files to extract key information, strengthening analytical and detail-oriented skills.
• Maintained structured records ensuring accuracy, consistency, and data integrity.
• Developed a systematic approach to handling unstructured information and documentation.

B.A. LL.B (Hons.) – National Law Institute University (2015-01 – 2022-12)