Summary
Overview
Work History
Education
Skills
Timeline
Generic

LAKSHMI AJITH

Auckland,AUK

Summary

Research Assistant at the University of Otago with experience across data analysis, engineering, and database management. Master’s graduate in Business Data Science, skilled in designing and managing data pipelines, cleaning and transforming large datasets, and conducting exploratory analysis to uncover actionable insights. Proficient in SQL, Python, and multiple database technologies, with hands-on experience in data visualisation, ETL processes, and performance optimisation. Adept at managing data workflows from preparation through analysis to support business decision-making.

Overview

4
4
years of professional experience

Work History

Research Assistant

Department of Physics, University of Otago
Dunedin North, Dunedin
08.2025 - Current
  • Extended studentship research and project work on household energy consumption into advanced research, focusing on automation and scalability.
  • Processed and cleaned large-scale datasets and optimised workflows to handle long-term, high-frequency energy records.
  • Built Python-based automated pipelines and integrated self-learning algorithms to improve reproducibility and accelerate end-to-end data analysis workflows.
  • Enhanced machine learning models developed during the studentship, applying advanced methods to refine detection of faulty appliances and irregular consumption behaviours.

Summer Studentship

University of Otago
Dunedin North, Dunedin
12.2024 - 02.2025
  • Performed large-scale analysis of half-hourly energy consumption datasets to identify patterns, anomalies, and irregular usage behaviour.
  • Designed and implemented Python-based workflows for data preprocessing, cleaning, and integration from multiple sources.
  • Applied statistical techniques and machine learning methods for anomaly detection and pattern recognition.
  • Created interactive dashboards and visualisations to communicate insights and support data-driven decision-making.

Data Scientist Intern

SolarZero
Eden Terrace, Auckland
11.2024 - 11.2024
  • Conducted exploratory data analysis (EDA) using Python to identify patterns and trends in large energy consumption datasets.
  • Generated summary reports highlighting key insights from data exploration activities.
  • Designed clear, insightful visualisations to support decision-making and communicate findings.
  • Performed data wrangling, cleaning, and statistical modelling in Python to prepare datasets for deeper analysis.

System Engineer

Tata Consultancy Services
Kerala, India
02.2022 - 06.2024
  • Designed, developed, and maintained RESTful APIs for enterprise applications, integrating with PostgreSQL and Oracle PL/SQL databases.
  • Created and optimised complex SQL queries, stored procedures, and functions for high-performance data retrieval and processing.
  • Developed and monitored Kafka-based data pipelines to handle real-time and batch data processing.
  • Collaborated with cross-functional teams to ensure data integrity, secure data transfer, and seamless API integration.
  • Conducted performance tuning, database query optimisation, and troubleshooting to improve system efficiency.
  • Implemented automated testing using JUnit and adhered to secure coding practices with Fortify.

Education

Master of Science - Business Data Science

University of Otago
Dunedin, NZ
07-2025

Skills

  • Languages and Programming : Python, SQL, Java R, Julia, SAS
  • Data Analysis and Visualisation: Power BI, Matplotlib, Seaborn, Plotly
  • Databases and Data Warehousing: PostgreSQL, MySQL, Oracle PL/SQL, MongoDB, OrientDB, Snowflake
  • Tools and Platforms: Jupyter Notebook, Visual Studio Code, MS Office Suite (Word, PowerPoint, Excel
  • Cloud Platforms: Azure

Timeline

Research Assistant

Department of Physics, University of Otago
08.2025 - Current

Summer Studentship

University of Otago
12.2024 - 02.2025

Data Scientist Intern

SolarZero
11.2024 - 11.2024

System Engineer

Tata Consultancy Services
02.2022 - 06.2024

Master of Science - Business Data Science

University of Otago

Similar Profiles

CREATE PROFILE
LAKSHMI AJITH