Skip to main content
John WilsonJW
Open to opportunities

John Wilson

@johnwilson4

Data Analyst turning SQL, Python, R, and BI tools into actionable insights.

India
Message

What I'm looking for

I’m looking for a role where I can apply SQL, Python/R, and BI dashboards to deliver actionable insights. I want ownership of data cleaning, EDA, and KPI reporting, collaborate with stakeholders, and keep improving through practical, data-driven work.

I’m a Data Analyst with a strong foundation in SQL, R, Excel, and Tableau, and I use Python to clean, transform, and analyze data. I focus on turning messy data into clear findings that support better business decisions.

At Decode Data Academy, I 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%. I also ran end-to-end exploratory data analysis on 300+ student records to identify trends, outliers, and performance metrics.

I built multi-page Power BI dashboards using DAX, slicers, and dynamic filters to visualize KPIs, reducing manual reporting effort by 40%. I then generated insights by identifying low-performing student segments and presented findings to stakeholders to enable data-driven decision-making.

Before that, I worked as a trainee/intern at Magnum Group on the Government e-Marketplace (GeM) platform, supporting product listings, order processing, and basic data tracking. I also interned at Bhopal District Court, managing and organizing large volumes of case-related data and extracting key information—strengthening my accuracy, detail-orientation, and structured thinking. I’m committed to continuous learning through certifications like the Google Data Analytics Professional Certificate and full-stack data analytics training.

Experience

Work history, roles, and key accomplishments

DA

Data Analytics Intern

Decode Data Academy

Jan 2025 - Jan 2026 (1 year)

Performed data cleaning and preprocessing on structured datasets of 50K+ records, reducing null and inconsistent entries by 30%. Built multi-page Power BI dashboards and conducted EDA on 300+ student records to identify trends and support stakeholder decision-making, cutting manual reporting effort by 40%.

BC

Data Analyst Intern

Bhopal District Court

Jan 2023 - Jan 2024 (1 year)

Managed and organized large volumes of case-related data and legal documentation for efficient retrieval. Extracted key information from case files and maintained structured records to ensure accuracy, consistency, and data integrity.

MG

Data Analytics Trainee Intern

Magnum Group

Jan 2024 - Present (2 years 5 months)

Supported work on the Government e-Marketplace (GeM) platform by assisting with product listings and order processing while handling basic data tracking and reporting tasks.

Education

Degrees, certifications, and relevant coursework

DA

Decode Data Academy

Full Stack Data Analytics Certification, Data Analytics

2025 - 2026

Completed a Full Stack Data Analytics Certification from 2025 to 2026, covering ETL, data scraping, cleaning, transformation, statistics, and visualization with Power BI and Python.

CO

Coursera

Google Data Analytics Professional Certificate, Data Analytics

Completed the Google Data Analytics Professional Certificate in 2025, covering Excel, SQL (BigQuery), R programming, and Tableau.

NU

National Law Institute University

B.A. LL.B. (Hons.), Law

2015 - 2022

Completed B.A. LL.B. (Hons.) from 2015 to 2022 at National Law Institute University in Bhopal, India.

Tech stack

Software and tools used professionally

Find your dream job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan