John Wilson
@johnwilson4
Data Analyst turning SQL, Python, R, and BI tools into actionable insights.
What I'm looking for
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
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%.
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.
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
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.
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.
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.
Availability
Location
Authorized to work in
Job categories
Interested in hiring John?
You can contact John and 90k+ other talented remote workers on Himalayas.
Message JohnFind 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!
