Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Senior Engineer
AstraZenecaSenior Engineer
May. 2018Chennai Area, IndiaAs Senior Data Engineer, orchestrated the transformation logic using DBT in Snowflake, streamlining data processes and ensuring high-quality outputs for stakeholders; developed and maintained custom DBT macros and models, setting the standard for data engineering workflows. Spearheaded the optimization of data storage solutions, selecting between HDFS and cloud-based options, and integrated AWS Kinesis and Lambda; led the design and automation of ETL workflows using Apache Spark and Airflow, enhancing the reliability and efficiency of data pipelines. In a leadership role, mentored the data engineering team on DBT best practices, fostering a culture of excellence; led the migration to cloud-based data integration, designed ETLs using Apache Spark and Airflow, and managed a team of 5 data engineers, collaborating with management to build high-performing analytical models.
Senior Consultant
CenturyLinkSenior Consultant
Sep. 2017 - May. 2018Bengaluru, Karnataka, IndiaAs a Senior Spark Data Engineer in AWS, architected resilient data pipelines using AWS Kinesis and Lambda, transforming raw data into actionable insights and ensuring high scalability. Specializing in HANA, designed and optimized star schema data models, employing denormalization and strategic join strategies, enabling efficient data retrieval and empowering data-driven decision-making.
SAP Analytics Consultant
Deloitte India (Offices of the US)SAP Analytics Consultant
May. 2013 - Aug. 2017Bengaluru Area, IndiaDesign and develop efficient data models using Native HANA features, optimizing database structures, tables, and indexes for high performance and scalability; adhere to data governance standards to maintain integrity and security, while applying data warehousing principles and dimensional modeling techniques to create effective star or snowflake schema designs for supporting reporting and analytics. Skillfully develop, maintain, and monitor data pipelines and ETL processes to ensure quality data flows into Native HANA from various sources; collaborate with data analysts and scientists to meet their specific requirements, while proactively identifying and resolving performance bottlenecks through index optimization and query plan analysis, and actively engaging in interdisciplinary team collaboration to maintain code quality and best practices.
Senior Software Engineer
NTT DATA AmericasSenior Software Engineer
Sep. 2010 - Apr. 2013Chennai Area, IndiaCollaborate with stakeholders to design OLAP data models in SAP BW using Ralph Kimball's approach; develop data marts with optimized DSOs and Info-Cubes, and manage the configuration of Data Stores, ensuring efficient data storage and retrieval.
ResMed

Requests

Touchpoint image
0
Personal Pitch
Lead Data Engineer with dbt & Snowflake, AWS
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like Madhavan on Intch
IT
1027651 people
15
Business process lead @ Tata consultancy Services
212
AI Marketing Automation and Digital Strategist @ GV Shri
22
Founder @ Accession
ITData Engineer
74929 people
17
Senior QA Automation Engineer @ Luxoft
18
Founder & CEO @ GVM Technologies LLC
19
Data Engineer @ EY