Sanjai Kanna B C

I am Sanjai Kanna B C, currently honing my skills as a Data Engineering & Automation Intern at Chennai Metro Rail Ltd. My journey is marked by a strong sense of accountability and ambition, driving me to take on challenges with an assertive and approachable demeanor. I thrive in autonomous environments where I can contribute meaningfully while fostering collaboration among my peers.

Experience

Data Science Intern

CreditMantri · Jun 2026 – Present

Not yet confirmed

• Query and transform large-scale customer, bureau, campaign, call, and product data using PostgreSQL for analytics and feature engineering.
• Perform exploratory data analysis (EDA), feature engineering, and data preprocessing to support customer propensity and classification modeling.
• Automate recurring MIS reports using SQL, Python, and R to improve reporting efficiency and reduce manual effort.

C

Data Engineering & Automation Intern

Chennai Metro Rail Ltd. · Dec 2025 – Present

Not yet confirmed

• Processed and reconciled high-volume financial transaction and settlement datasets ranging from 4 lakh to 20+ lakh records for 30-day aggregation cycles.
• Developed Python-based automation scripts to validate, merge, and reconcile multi-source datasets, implementing discrepancy detection.
• Automated reconciliation workflows, reducing cycle time from 1 working day to under 5 minutes.
• Deployed reusable Python-based automation solutions adopted by team members.

A

Fundamental Analysis Intern

Absolute Broking Pvt. Ltd. · May 2025 – Present

Not yet confirmed

• Collected financial statement data of listed IT companies for comparative analysis.
• Computed financial ratios for evaluating profitability and leverage metrics.
• Ranked companies based on selected financial indicators for fundamental comparison.

A

Data Visualization Intern

Antontech Pvt. Ltd. · May 2024 – Present

Not yet confirmed

• Processed vendor invoice data within STIBO to convert supplier formats into standardized structures.
• Reviewed and updated system-loaded invoice records for accuracy and compliance.
• Transformed datasets using Power Query and developed DAX measures for reporting.
• Developed Power BI dashboards to support business reporting.

Data Engineering & Automation

Chennai Metro Rail Limited · Dec 2025 – Jan 2026

Not yet confirmed

• Built Python-based internal automation tools to ingest and validate multi-source Excel/CSV transaction and settlement datasets used in reconciliation workflows.
• Implemented reconciliation and validation logic using set operations, joins, vectorized computations, and pivot aggregations across multiple datasets.
• Automated previously manual processes, reducing data merging and validation time from ~2 hours to under a minute per run, based on user feedback.

Fundamental Analysis

Absolute Broking Pvt Ltd · May 2025 – Jun 2025

Not yet confirmed

• Analyzed financial statements of 5 Indian IT companies, computing and comparing 10+ key performance ratios using Excel.
• Built Excel-based comparison sheets covering profitability, valuation, and leverage metrics across multiple companies to support
• fundamental analysis.

A

Data Visualization

Antontech Private Limited · May 2024 – Jun 2024

Not yet confirmed

• Processed and standardised vendor invoice to standardises invoice for Blackwoods Australia
• Performed data modelling and transformation using Power Query, defined relationships between tables, and created DAX calculated columns and measures.
• Built Power BI reports, handling visual selection, formatting, filters, and interactive elements for recurring business reporting.