<Mayuran />

Hello there 👋, I am

Mayuran

I turn messy datasets into clear insights — dashboards and analysis that help teams decide faster.

Hire me Download CV
Ganeshalingam Mayuran, data analyst

2+

Years hands-on with data

4

End-to-end analytics projects

2

Internships completed

10+

Tools & technologies

About me

An analyst who loves the messy part

Enthusiastic and self-motivated Data Analyst with hands-on experience in Python, SQL, Power BI and Jupyter Notebook. Skilled in data cleaning, exploratory analysis and building interactive dashboards that generate actionable business insights. I enjoy interpreting complex datasets, spotting trends and supporting data-driven decision making.

Currently based in Wellawatte, Colombo, Sri Lanka, I work across Python, SQL and Power BI — from cleaning raw data and engineering features to shipping dashboards that people actually use.

Toolkit

Skills & technologies

Languages

PythonSQL

Analysis & Visualisation

Power BIJupyter NotebookPandasNumPyMatplotlibSeaborn

Databases

PostgreSQLMySQLMongoDB

Tools & Platforms

GitHubPostmanFigma

Career

Where I've worked

Data Analytics Intern · International Water Management Institute (IWMI)

Apr 2026 – Sep 2026
  • Built automated Python (Pandas, NumPy) data pipelines to clean, transform and merge 40 years (1986–2025) of environmental and water-quality data across 94 monitoring sites.
  • Engineered 100+ predictor variables using aggregation and statistical techniques, and extracted and validated large-scale historical time-series data from multiple public sources.
  • Performed data quality checks, missing-value treatment, EDA, statistical analysis and visualisations to identify trends, patterns and outliers.
  • Developed an interactive analytical dashboard, documented data processing and QA methodologies, and collaborated with a cross-regional team using GitHub.

Intern Software Engineer · Gamage Recruiters (Pvt) Ltd

Feb 2025 – Aug 2025
  • Developed React pages and Node.js APIs to improve user flow and system functionality.
  • Implemented JWT authentication to increase security and protect user data.
  • Integrated the Google Maps API to capture and display user locations accurately.
  • Automated email notifications with Nodemailer and built recruiter statistics charts with Recharts.
  • Improved the UI with Tailwind CSS and resolved bugs across API calls, charts and map markers.
  • Used Git for version control to collaborate effectively and maintain clean code.

Selected work

Projects

Customer Shopping Behavior Analysis

Analysed 3,900 customer purchases to surface spending patterns, segments and product preferences.

  • Data cleaning and feature engineering in Python (Pandas, NumPy).
  • Business-focused SQL analysis in PostgreSQL to segment customers and evaluate revenue trends.
  • Interactive Power BI dashboard covering segments, discount usage and top products.
PythonPostgreSQLPower BIJupyter

Regional Sales Analysis

Five years of U.S. regional sales data turned into an executive view of revenue, profit and channels.

  • Merged and normalised multiple datasets with Python preprocessing.
  • EDA on seasonal trends, top products and channel-wise profitability.
  • Power BI dashboard supporting data-driven sales strategy.
PythonMatplotlibSeabornPower BI

Banking Risk Analysis

Customer banking data assessed for risk level to support smarter loan approval decisions.

  • Engineered meaningful financial risk indicators from raw customer data.
  • EDA uncovering segments and correlations that impact loan defaults.
  • Power BI dashboards visualising risk profiles for banking decisions.
PythonPandasPower BI

Pizza Sales Analysis

Historical pizza sales explored in SQL Server and Excel to measure performance and ordering behaviour.

  • KPIs for revenue, average order value, orders and pizzas per order.
  • Daily and hourly trend analysis to find peak demand windows.
  • Interactive Excel dashboard with pivot tables and visuals.
MS SQL ServerExcel

Background

Education & certifications

Education

BSc (Hons) in Information Technology

Sri Lanka Institute of Information Technology (SLIIT)

2021 – 2025

General Education – Grade 1 to Advanced Level

Royal College, Colombo

2006 – 2019

Certifications

  • Agile Methodology — Simplilearn
  • Programming Basics — Great Learning
  • Software Testing — Great Learning

Contact

Let's build something with data

Open to data analyst and analytics engineering roles, freelance dashboards and collaborations. The fastest way to reach me is email.

ganeshalingammayuran05@gmail.comConnect on LinkedIn