Summary
Overview
Work History
Education
Skills
Accomplishments
Projects
Hobbies and Interests
Languages
Timeline
Generic

Maharajan Pandian

Chennai

Summary

I am a Business-focused Data Engineer with over 3 years of experience in building scalable data pipelines and optimizing ETL workflows, complemented by more than a decade in data analytics. I specialize in SQL, Python, and cloud solutions like Azure and Snowflake, aiming to deliver efficient data-driven solutions. My skills bridge the gap between technical implementation and business needs, ensuring reliable data availability for optimization and decision-making.

Overview

10
10
years of professional experience

Work History

Data Engineer

Corium Trends Private Limited
Chennai
10.2017 - 07.2021
  • Company Overview: An analytics company focused on customer insights and data solutions
  • Developed a Customer Analytics Data Model using SQL & Snowflake, implementing a Star Schema
  • Created interactive Power BI dashboards connected to Snowflake
  • Wrote DAX expressions for KPIs such as Customer Churn Rate and Sales Growth Analysis
  • Optimized Snowflake queries using clustering, partitioning, and result caching
  • Implemented Row-Level Security – RLS in Power BI
  • Automated data refreshes and report distribution using Power BI Service
  • Collaborated with analysts and stakeholders to refine dashboard designs
  • An analytics company focused on customer insights and data solutions

Data Reporting & Analysis Executive

Future Group/Planet Sports
Chennai
06.2011 - 03.2014
  • Company Overview: A multi-retail and e-commerce group in the country
  • Managed and maintained large datasets in Excel, ensuring accuracy for reporting
  • Developed dynamic dashboards using Pivot Tables, VLOOKUP, INDEX–MATCH
  • Automated data cleaning and transformation using Power Query and Excel VBA Macros
  • Conducted data validation and reconciliation, identifying and fixing discrepancies
  • Designed forecasting models using Excel charts and slicers
  • Scheduled and distributed daily, weekly, and monthly reports to stakeholders
  • A multi-retail and e-commerce group in the country

Data Engineer

Sanchu Animal Hospital
Chennai
08.2021 - 01.1970
  • Company Overview: A leading animal hospital providing quality veterinary services
  • Extracted data from various sources such as databases, APIs, and file systems
  • Implemented data quality measures to detect and handle missing, duplicate, or inconsistent data
  • Developed ETL pipelines using Apache Spark and PySpark
  • Performed data aggregation and summarization for business insights
  • Ensured database management best practices, including indexing and partitioning
  • Implemented monitoring tools and logging mechanisms for pipeline performance
  • Regularly optimized data workflows for scalability and efficiency
  • A leading animal hospital providing quality veterinary services

Education

Master - Data Engineering with Big Data and Cloud Analytics

IITM
01.1970

Bachelor of Arts - English Literature

University of Madras
01.1970

Skills

  • Programming: SQL, Python, Pyspark
  • Data Engineering: Databricks, Snowflake, Apache Spark, ETL Pipelines,
  • Cloud Platforms: Azure Data Services, AWS Glue,
  • Business Intelligence: Power BI, DAX, Data Modeling,
  • Tools: Git, GitHub, Excel VBA, Power Query, Airflow

Accomplishments

Your Achievement, Describe what you did and the impact it had.

Projects

Enhancing E-Commerce Agility with Advanced ETL Pipeline, 01/01/70, 01/01/70, A project focused on creating an advanced ETL pipeline for e-commerce agility., Built a Streamlit web app for the Order and Returns teams to upload data files., Set up AWS Lambda triggers to invoke AWS Glue ETL jobs for data transformation., Stored processed data in Redshift, with optional querying via Athena., Designed AWS Step Functions to orchestrate the pipeline., Configured SNS notifications for execution status updates. Social Media Hashtag Trend Analyzer Application, 01/01/70, 01/01/70, A web application that analyzes social media hashtag trends., Built a user-friendly interface for composing posts with hashtags., Used AWS Lambda to process posts and store data in DynamoDB., Implemented real-time trending hashtags with dynamic updates.

Hobbies and Interests

Career Interest / Passion

Languages

Language, Beginner

Timeline

Data Engineer

Sanchu Animal Hospital
08.2021 - 01.1970

Data Engineer

Corium Trends Private Limited
10.2017 - 07.2021

Data Reporting & Analysis Executive

Future Group/Planet Sports
06.2011 - 03.2014

Master - Data Engineering with Big Data and Cloud Analytics

IITM

Bachelor of Arts - English Literature

University of Madras
Maharajan Pandian