Summary
Overview
Work History
Education
Skills
Timeline
Generic

Swetha M

Bengaluru

Summary

Results-driven Data Engineer/Data Analyst with experience in data pipelines, dashboard development, and maritime operations. Proficient in Python, SQL, Power BI, and CouchDB, with a focus on vessel performance, spare management, and cross-functional collaboration for data-driven decision-making.

Overview

2
2
years of professional experience

Work History

Data Engineer

MISC Group
10.2024 - Current
  • Improved system performance by 20% by authoring 15 complex SQL queries for maintenance reports.
  • Designed and automated Power BI dashboards for vessel performance monitoring by integrating MySQL and Excel data sources; collaborated with cross-functional teams to streamline reporting workflows, reduce manual effort, and enable faster decision-making for fleet management
  • Improved operational efficiency by 15% using Shore Portal for transformation report generation.
  • Collaborated with the DevOps team to containerize applications using Docker, enhancing scalability and deployment efficiency.

Data Engineer

MagellanX
08.2023 - 09.2024
  • Architected Python-based ETL pipelines using Apache Airflow for data synchronization between vessel PostgreSQL databases and cloud servers.
  • Designed and implemented automated data migration framework between on-premises and cloud systems to enhance operational workflows.
  • Designed and implemented robust PostgreSQL database architecture encompassing 70= tables, significantly enhancing data integrity and migration efficiency.
  • Built automated email scheduling system in metabase to ensure timely client communications and follow-ups.
  • Designed and implemented database schemas for multiple tables; created SQL queries for data processing and analysis tailored to backend developer requirements.
  • Generated comprehensive client report through efficient conversion of CouchDB JSON data to CSV format, leveraging advanced Excel functions to optimize purchase order tracking systems and streamline the check-in process workflow.

Associate Data Analyst

Mindmax Technologies
02.2023 - 07.2023
  • Developed a retail analytics dashboard tracking 200= stores' data, cutting reporting time 75% through automated data processing and visualization.
  • Automated daily reporting processes using Python and Pandas, eliminating 20 hours of weekly manual effort.
  • Collaborated with retail clients to understand business requirements and deliver tailored analytical solutions.
  • Successfully delivered data integration projects worth $1.2M by implementing scalable architecture.

Education

M.Tech - Big Data Analytics

SRM Institute of Science And Technology
Chennai ,India
04-2023

B.E - ECE

PSNA College of Engineering & Technology
Dindigul, India
09-2020

Skills

    Data Analytics & Visualization: Power BI, Excel, Tableau

    Programming & Scripting: Python (Pandas, NumPy), SQL

    Databases: MySQL, PostgreSQL, MS SQL Server, CouchDB

    Data Engineering: ETL development, Data modeling, Data pipelines

    Data Integration: API-based data ingestion, CouchDB replication

    Cloud & Tools: CouchDB (cloud/local), Jupyter Notebook, Git, Postman

Timeline

Data Engineer

MISC Group
10.2024 - Current

Data Engineer

MagellanX
08.2023 - 09.2024

Associate Data Analyst

Mindmax Technologies
02.2023 - 07.2023

M.Tech - Big Data Analytics

SRM Institute of Science And Technology

B.E - ECE

PSNA College of Engineering & Technology
Swetha M