Amit Magdum
Bengaluru,India
Summary
Analytics specialist with hands-on experience across ESG, HR, Talent Management, Sales and Finance data. Strong foundation in data modelling, performance analysis and turning complex information into clear, stakeholder-focused insights. Proven track record of shaping data stories that guide better decisions, raising data literacy within teams and building automated, reliable processes that cut manual work. Collaborative by nature and comfortable working with both technical and non-technical partners to help them reach outcomes that are meaningful, measurable and aligned to real business needs.
Overview
6
6
years of professional experience
1
1
Certification
Work history
ESG/CSR Data Analyst
Version 1
Bengaluru
04.2023 - 11.2025
- Designed and maintained data models and Power BI dashboards across environmental, social and diversity metrics, improving accuracy and visibility of organisational reporting.
- Partnered with ESG and DACoE teams to analyse expense patterns, travel behaviour and supplier data, generating insights that supported planning and optimisation.
- Automated recurring reporting using Python and Power Automate, reducing monthly reporting effort by more than 70 percent.
- Built SQL queries and Power Query transformations to standardise multi-source data from Kantata, Atlas, BambooHR, SmartRecruiters, TalentGuard and SustainIQ for consolidated analytics..
- Collaborated with cross-functional teams to deliver executive-level dashboards that tracked progress against KPIs and sustainability goals.
- Supported data governance by establishing consistent master data rules, improving data accuracy across systems.
- Contributed to process efficiency by testing, documenting, and improving reporting templates and dashboards.
- Worked on Synapse & Fabric to create data pipelines and manage dataflows for centralised ESG data storage and analytics.
Data Analyst
Robert Bosch
Bengaluru
06.2021 - 03.2023
- Created automated dashboards and reports to monitor operational metrics using Python and Power BI.
- Developed SQL-based ETL workflows that enhanced data reliability and minimised manual preparation.
- Delivered actionable insights through KPI trend analysis and monthly summary reports for leadership.
- Led initiatives that automated processes, resulting in 70% reduction in recurring reporting tasks.
Software Engineer
Dexcel Electronics Designs
Bengaluru
07.2019 - 03.2021
- Developed secure payment application utilising Bluetooth Low Energy, NFC, and MasterCard.
- Created and tested software solutions for IoT and payment systems.
- Conducted data analysis using Python to validate performance outcomes.
- Delivered automation for test cases which cut testing time by around 60 percent.
Education
Master of Technology - Computer Science with Specialisation in Big Data and IoT
PES University
Bengaluru, KarnatakaSkills
- Data Analysis & Reporting: Building interactive dashboards and automated reports in Power BI and Excel, KPI and trend analysis, performance monitoring
- Data Engineering & Automation: SQL, Python (pandas, numpy), Power Query, ETL pipelines, SharePoint & Excel automation with Power Automate & Python scripting
- Data Modelling: Star schema design, data validation, data integration, metadata management, master data mapping
- Systems & Tools: Power BI, Excel (Power Query, PivotTables, DAX), Azure, Fabric (Lakehouse), NetSuite, Kantata, Egencia, FREENOW, SharePoint, SustainIQ for carbon reporting, SmartRecruiters for hiring and leavers, TalentGuards for CPD promotions data
- Soft Skills: Stakeholder collaboration, documentation, process improvement, Agile methodology, problem-solving
- Data Platforms: Synapse & Fabric (Lakehouse), SharePoint, NetSuite, Kantata, SustainIQ, SmartRecruiters, TalentGuard, BambooHR
Certification
- Advanced Excel & Data Analytics - Udemy Business
- Power BI & DAX - LinkedIn Learning
- SQL for Analysts - Coursera
- Machine Learning A-Z: Hands-On Python & R In Data Science - Udemy
- Synapse & Fabric (self-learning projects)
Publication
Contactless Transaction Using Wearable Ring with Biometric Fingerprint Security Feature (Springer, 2021)
Selected Dashboards I Have Built
- Some of the Power BI dashboard links: (Please let me know if you face any access issues)
- Diversity Info Dashboard 1 - Diversity Pillar Sample - Power BI
- Travel - WFH & Commute Survey 2024 - Power BI
- ESG High Level Dashboard Sample - Power BI
- Diversity Info - India Region Dashboard - Power BI
- Hired vs Leavers - Hired vs Leavers Dashboard Sample - Power BI
Timeline
ESG/CSR Data Analyst
Version 1
04.2023 - 11.2025
Data Analyst
Robert Bosch
06.2021 - 03.2023
Software Engineer
Dexcel Electronics Designs
07.2019 - 03.2021
Master of Technology - Computer Science with Specialisation in Big Data and IoT
PES University