devanshu jain

PM - Data @ ICICI BANK

• Worked with various cross functional teams like sales, marketing, Legal and compliance team, Operation, and developer team to create a scalable data warehouse solution on Azure SQL Database, providing a centralized data repository for OLAP of Merchant Products.
• Developed and optimized ETL processes to migrate and transform large volumes of Transactional and Onboarding POS and Payment Gateway (PG) data from on-premises databases to Azure Data Lake, achieving a 25% reduction in processing time and enhancing data accessibility and availability for downstream analytics.
• Generated P&L Model and integrated on POWERBI for merchant loyalty program by performing customer segmentation and hence leading to 6.5 % Growth and 3.1 % retention of the merchants in 3rd Financial Quarter.
• Merchant Acquisition for different partner POS Machines using statistical analysis and marketing campaigns, Analyzed metrics and KPIs leading to a 2.1 % increment of cross-selling of QR
• Created a dashboard on PowerBI for Merchant Products like POS/QR required for the Sales team of the bank
• Integrated Power BI desktop with Microsoft Fabric using Data Pipelines from Azure data factory to deliver real-time reporting solutions for stakeholders, improving data-driven decision-making
• Predictive modelling of MCC based AAB/MAB growth using linear regression

JRF @ DRDO

• Assisted in the designand development of specialized defensevehicles for the Indian Army by developing a regression modelfor axle capacityvs speed
• Generated various BRDs and handled vendormanagement

MTech - IIT Jodhpur (2020 -22)

BTech - NIT Raipur (2011 -15)