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
Similar Profiles
MONINGI SHYAM SAIMONINGI SHYAM SAI
Accounts Assistant at Banana club trends private limitedAccounts Assistant at Banana club trends private limited
Aayushi ThawaniAayushi Thawani
Operations Supervisor (part Time) at Finissimo Trends Private LimitedOperations Supervisor (part Time) at Finissimo Trends Private Limited
Pawan NandwaniPawan Nandwani
Operations Manager at GGICO Trends Private LimitedOperations Manager at GGICO Trends Private Limited
Vedavalli SVedavalli S
Senior Technical Lead at Alten Calsoft LabsSenior Technical Lead at Alten Calsoft Labs
MOHAN RAJ. NMOHAN RAJ. N
Clinical Documentation Specialist at Acuity Solutions India Pvt Ltd (An IKS Health Company) | Client: Coastal MedicalClinical Documentation Specialist at Acuity Solutions India Pvt Ltd (An IKS Health Company) | Client: Coastal Medical