Amit Shah

Senior Data Analyst - Grab - Bangalore

(2025-10)

Partnered with Product, Growth, Risk, and Engineering teams to define source data requirements, perform data mapping, and build scalable PySpark, Python, SQL, and Hive pipelines for payments, transaction analytics, and enterprise reporting, ensuring high data quality and governance standards.
Designed and optimized ETL/data migration workflows using PySpark, SQL, and AWS (S3, Glue, Redshift), performing data validation, data reconciliation, and root cause analysis to support reliable migration of large-scale transactional datasets and business-critical analytics.
Built automated Power BI and IBM Cognos dashboards on Snowflake using dimensional data models & dbt, delivering insights into customer activation, transaction success, fraud monitoring, operational risk, and business performance while collaborating in Agile SDLC using JIRA and Confluence.
Mentored a small analytics team and partnered with cross-functional stakeholders to deliver enterprise data solutions, implementing change management, governance controls, and continuous improvements that enhanced data accuracy, reporting reliability, and operational efficiency.

Lead Product & Marketing Analyst - Lowe's - Bangalore

(2024-12 - 2025-10)

Performed end-to-end source data analysis using PySpark, Python, SQL, Snowflake, and AWS (S3, Redshift) to process large-scale web and app datasets, supporting ETL/ELT pipelines, data validation, data reconciliation, and data quality & governance, resulting in a 12% improvement in conversion rate.
Designed and optimized scalable PySpark and SQL transformation pipelines with dbt, integrating multiple enterprise data sources through data mapping and dimensional modeling (Star & Snowflake Schema) to deliver trusted analytical datasets and business insights.
Built automated Power BI dashboards for real-time monitoring of customer acquisition, engagement, conversion, pricing, and revenue KPIs while partnering with Product, Marketing, and Engineering teams to gather requirements, manage stakeholders, and ensure data accuracy through robust governance controls.
Collaborated within Agile SDLC using JIRA and Confluence, performing business analysis, root cause analysis, and change management while mentoring junior analysts and delivering scalable analytics solutions for enterprise reporting and strategic decision-making.

Organisation Analyst - LSEG (London Stock Exchange Group)

(2023-10 - 2024-12)

Developed 30+ enterprise analytics solutions using PySpark, SQL, Python, Alteryx, and ETL pipelines, integrating data across HR and Financial Services domains while supporting data migration, source data analysis, data mapping, data validation, and data quality & governance for enterprise reporting.
Designed and maintained scalable data models and analytical datasets for workforce planning, recruiting, compensation, and performance analytics, collaborating with stakeholders supporting Party/Client, Market Data, Trade, Settlements, Instrument & Pricing, and Credit Risk domains to ensure consistent data governance and reporting standards.
Built executive dashboards and automated reporting solutions using SQL and Python, improving data-driven decision-making by 25%, while performing business analysis, requirements gathering, root cause analysis, and data reconciliation across multiple enterprise systems.
Worked within Agile SDLC using JIRA and Confluence, leveraging PySpark, Spark Scala, and enterprise ETL frameworks to process large datasets, support change and release management, and mentor a small delivery-focused analytics team while ensuring compliance with governance and quality standards.

Assistant Manager - Data Analytics - Paytm Payments Bank - Bangalore

(2022-04 - 2023-10)

Partnered with Business, Product, Risk, and Payments teams to perform source data analysis, data mapping, and business analysis using PySpark, Hive, SQL, and Python, supporting customer onboarding, payment transactions, and enterprise data migration initiatives while ensuring data quality and governance.
Developed scalable ETL/data migration pipelines using PySpark, Hive, and SQL, performing data validation, data reconciliation, and master data management for large-scale payments, customer, and transactional datasets, ensuring compliance with banking and regulatory standards.
Built automated Power BI & IBM Cognos dashboards & KPI reports tracking customer acquisition, onboarding, retention, transaction success, portfolio performance, & risk analytics, enabling stakeholders to monitor business performance and make data-driven decisions through accurate, governed data.
Collaborated within Agile SDLC using JIRA and Confluence, leading cross-functional analytics initiatives, conducting requirements gathering, root cause analysis, and change management while mentoring junior analysts and delivering high-quality enterprise analytics solutions that improved customer retention by 32% YoY.

Data Analyst - FITTR - Bangalore

(2020-11 - 2022-04)

Performed source data analysis using PySpark, SQL, Python, and MySQL across 10+ enterprise projects, integrating data from multiple sources through ETL pipelines, data mapping, data validation, and data quality & governance processes to identify operational improvement opportunities of 15%.
Built and automated interactive dashboards using Power BI, Tableau, DOMO, Python, and SQL, delivering real-time insights into campaign performance, customer engagement, and business KPIs while ensuring data accuracy, reconciliation, and enterprise reporting standards.
Partnered with cross-functional stakeholders to conduct business analysis, requirements gathering, root cause analysis, and process optimization, leveraging Agile SDLC, JIRA, and Confluence to deliver scalable analytics solutions and improve reporting efficiency by 40%.

Catalog Lead - Amazon

(2017-06 - 2020-11)

Catalog and Seller Integration: Collaborated with Category, Business, and Engineering teams to perform source data analysis, data mapping, and master data management for large-scale catalog and seller datasets using PySpark, SQL (AWS), Python, PostgreSQL, SQL Server, and MySQL, ensuring high data quality and governance standards across enterprise platforms.
Developed scalable ETL/data migration and data validation processes to onboard high-volume seller and catalog data, performing data reconciliation, anomaly detection, and root cause analysis to improve data accuracy, operational efficiency, and customer experience.
Built automated dashboards and analytical solutions using SQL, Python, Advanced Excel (VBA), and enterprise databases to monitor business KPIs, identify trends, and deliver actionable insights while partnering with stakeholders through Agile SDLC, JIRA, and Confluence.
Led a delivery-focused team supporting catalog operations and business analytics, driving business analysis, requirements gathering, change management, and continuous process improvements while ensuring timely delivery of high-quality enterprise data solutions.

About