I am a data architect and engineer delivering scalable data and analytics solutions across healthcare and aviation, with deep expertise in cloud, ETL, and BI platforms. I am experienced in Medallion architecture for data migration and analytics workflows. I collaborate with clients and cross-functional teams in Agile environments to deliver actionable insights, improve efficiency, and drive business outcomes.

Madhan Raj Ramasamy

I am a data architect and engineer delivering scalable data and analytics solutions across healthcare and aviation, with deep expertise in cloud, ETL, and BI platforms. I am experienced in Medallion architecture for data migration and analytics workflows. I collaborate with clients and cross-functional teams in Agile environments to deliver actionable insights, improve efficiency, and drive business outcomes.

Available to hire

I am a data architect and engineer delivering scalable data and analytics solutions across healthcare and aviation, with deep expertise in cloud, ETL, and BI platforms. I am experienced in Medallion architecture for data migration and analytics workflows.

I collaborate with clients and cross-functional teams in Agile environments to deliver actionable insights, improve efficiency, and drive business outcomes.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
See more

Language

English
Fluent
Tamil
Fluent

Work Experience

Senior Data Analyst at SA Health
September 12, 2022 - November 11, 2025
Supports digital transformation initiatives focusing on PBS data, clinical reporting, and regulatory compliance. Redesigned PBS data ingestion to improve maintainability and scalability; migrated 25+ SSIS packages to SSISDB Catalog; optimized 35+ SSRS/Power BI reports; automated FOI reporting to ensure 100% accuracy and reduced manual effort.
Solution Consultant / Architect at Ramco Systems Australia
April 8, 2016 - September 12, 2022
Led ERP data migrations, improved reconciliation, and delivered high-performance analytics. Reduced migration downtime by 40% through optimized ETL/staging and load processes; designed Power BI reports from SSAS models; deployed Medallion-architecture aligned pipelines; migrated on-prem ERP to AWS for better scalability and cost efficiency.
Senior Specialist (Domain Consultant) at Wipro Technologies Ltd.
June 1, 2010 - May 31, 2011
Supported global airline migration projects and provided business advisory on logistics/transportation, mentoring teams in logistics design principles and functional improvements.
Senior Technical Consultant at Ramco Systems Ltd.
July 11, 2011 - April 7, 2016
Delivered end-to-end ERP implementations and data migrations for US-based aviation clients; reduced downtime by 40% during Cobham/Columbia transitions; designed offline ERP data exchange using CDC; migrated historical data into Data Vaults for audit/compliance; provided on-site post-go-live support and SQL administration; earned client recognition.
Senior Systems Analyst at Ramco Systems Ltd.
June 1, 2004 - June 1, 2010
Led ERP data migrations and aviation logistics solutions for global clients; reduced Pinnacle Airlines migration time by 85% with advanced SQL scripting; provided onsite warranty support for 20 months; received multiple client awards for project success.

Education

Bachelor of Electrical & Electronics Engineering at India
September 1, 1997 - May 31, 2001

Qualifications

Microsoft Certified: Fabric Data Engineer Associate (DP-700)
August 17, 2025 - November 11, 2025
Microsoft Certified: Data Fundamentals (DP-900)
January 11, 2030 - November 11, 2025
Microsoft Certified: Azure Fundamentals (AZ-900)
January 11, 2030 - November 11, 2025

Industry Experience

Healthcare, Transportation & Logistics, Government, Professional Services, Software & Internet

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate
Intermediate
Intermediate
See more