Madh Sudhan
Tech Lead
Bengaluru, madhu
Summary
Democratising Data | SDE @ Myntra Process oriented Data Engineer with 8+ years of experience in Data Warehousing, Business Intelligence Data Analytics & Big Data Eco system.Well-versed in analysing customer behaviour of various products like DDP, Bifrost, Bounty, Jobvite, BM42, Live sales, HRD sales etc., and have successfully helped in business decisions for customer growth in Ecommerce giant.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
3
3
Languages
Work History
Senior Data Enginner
Myntra
Bangalore
08.2018 - 09.2022
- India's Biggest Ecommerce Fashion Giant
- Performing extract, transform and load from multitude of customer's enterprise data sources and ingested to ADW(Commerce and
- Clickstream clusters),SingleStore, Azure Blob and S3 using Pentaho, Python, Spark SQL and Hive
- Major contribution in Azure Migration project from AWS Redshift to ADW and cloud storage from S3 to Azure blob
- Achieved quality and availability of data across stakeholders post migration and making one of the longest successful projects in Myntra
- Managed 12+ HRD Sale events like EORS(End of Reason Sale), Big Fashion Day and performed various tasks like scaling up clusters,Load tests of (orders ~30k OPM,revenue 200+CR/day,events,clicks), setting up critical checks, GM debugging, adding anomaly detection in critical data sets and setting up real time revenue/sales dashboards
- Multi-tenancy project of merging two e-commerce fashion giant's (Jabong & Myntra ) to form Multi-tenant warehouse which is biggest onboarding for Myntra
- Performed necessary data mapping consisting of almost half a trillion of lines in a core revenue sales pipeline fact core item
- Implemented impacted changes to DWH due to cross platform initiatives like Card tokenization, Multi Seller Sku, CND ,DOPE, FBM/PPMP and onboarding brands like H&M, Marks&Spencer, Urbanic & Noon as B2B
- Build self-service data serving (DDP) & reporting capabilities product (UDP) using technologies such as ADW,Redshift, Pentaho, Python,
- SingleStore, Hive, Azure blob, S3
- Contributed in developing and maintaining Business Metrics and Live Sales Report - answers critical live metrics: Revenue, Orders, Gross
- Margin, ASP, Top performing Brand/Article type,Acquisition, Discount, Ageing etc., both the reports are powered to teams like
- Storefront, Category, Marketplace, Data Science, CEO, CTO ,VP etc
- Completely owned the financial month end closing unit(MEC) of Myntra - end to end for all data requirements by providing insights to across teams like Product, Inventory, Account receivables , Account Payables, Business Finance and delivered useful financial reconciliation reports like Sales revenue, Seller settlement, Inventory movement,Closing stocks, etc
- Achievements : Financial Intelligence : Built veracity checks on all the critical data metrics to smoothen the Month End closing books to finish within CD1/2 without any breaches that helped leadership team to get insights on Financial books by 1st of every month
- Organised,modularised and parallelised the batch processing pipeline of core data set of sales-revenue (FOCI) by reducing the runtime to 50% that profited low latency for business metric reports to across customer's and also minimised the Commerce DWH cluster utilisation
- Achievements/Tasks
- Madhusudhan N
Senior Data Engineer
ORGANIZATIONS, Myntra
08.2018 - 08.2022
Data Engineer Harman
04.2017 - 08.2018
- Involved in Requirement Analysis, ETL development, Data Mapping and Data Integration Services
- Executed Python files to generate POM (Project Object Model) file for mappings
- Developed Python scripts to automate various daily, weekly, quarterly reports and share across the teams
- Reporting and Visualization of data for Customer success for organization strategies through developing the variety of Custom reports with Tableau Analytics
- Understanding business requirements and translating them to technical specifications, interpret data, analyse results using statistical techniques and provide ongoing reports
- Coordinating with different teams like product management, digital marketing, developers, CEO, sales & marketing etc., and provide the required insights of the customers.
Data Engineer
Harman
03.2017 - 08.2018
ETL Developer & Data Analyst
Capgemini - Ciena DWBI Client & Motorola
01.2014 - 04.2017
- Involved in Requirement Analysis, ETL development, Data Mapping and Data Integration Services
- Subject area expertise for Ciena Workday unit that involves managing the worker data for the Ciena and generating reports to different vendors like Demand Planning, Sales Forecast, Sunlife Retirement and JK charity
- Delivered POCs on retail data migration and Networking analytics to showcase the ability of MPP Datawarehousing
- Developed ETL mappings using Informatica Powercenter to move data from multiple sources like flat files, oracle tables into a common target area: Staging, Data Warehouse, and involved in performance tuning by optimising the sources, targets, mappings and sessions for
- Ciena & Motorola client
- Implemented to capture the slow changing data for the different vendors like Workday by implementing SCD type 1/type 2 ETL code
- Underwent training on Oracle 10g, Core Java, Data warehousing concepts, Informatica Powercenter, Big data concepts, Talend 5.4.
ETL Developer and Data Analyst
Capgemini
01.2014 - 03.2017
Education
Graduate in Bachelor of Engineering -
Visvesvaraya Technological University
08.2009 - 09.2013
Certification
MPP Datawarehousing Azure Data Warehouse MSSQL Redshift SIngleStoreDB(Inmemory) Business Intelligence
Timeline
Senior Data Enginner
Myntra
08.2018 - 09.2022
Senior Data Engineer
ORGANIZATIONS, Myntra
08.2018 - 08.2022
Data Engineer Harman
04.2017 - 08.2018
Data Engineer
Harman
03.2017 - 08.2018
ETL Developer & Data Analyst
Capgemini - Ciena DWBI Client & Motorola
01.2014 - 04.2017
ETL Developer and Data Analyst
Capgemini
01.2014 - 03.2017
Graduate in Bachelor of Engineering -
Visvesvaraya Technological University
08.2009 - 09.2013
Similar Profiles
Sujit JoshieeSujit Joshiee
Senior Manager – Business Insights & Analytics at MyntraSenior Manager – Business Insights & Analytics at Myntra
VINAY M SVINAY M S
Head of Operations & Account Management at MyntraHead of Operations & Account Management at Myntra
Rakshaan Rishaad RabbaniRakshaan Rishaad Rabbani
Manager, Men's Casual Wear Buying at MyntraManager, Men's Casual Wear Buying at Myntra
Gaurav GuptaGaurav Gupta
Associate Architect at MyntraAssociate Architect at Myntra
Sidharth Kumar SinghSidharth Kumar Singh
Manager at CONTINENTAL ENGINES LTDManager at CONTINENTAL ENGINES LTD