Sourav Kundu

• Project Delivery – Worked in the Non-Financial Risk Management, and delivered 5+ products built from scratch with requirements gathering, data cleaning & wrangling, Statistical Analysis & Data Visualization
• Experience in managing risk across the organization from the Non financial risk domain, involving Issues, Incidents, Risks, Controls, Rectifications, Remediation, Test Plans, Test Results, Business Profiles etc.

Key Projects:

Project 1: Creation of "Make Brighter Happen: A Customer Impact" product

• Objective: To help the Bank achieve the ambitious customer goal of getting NPS score of 30+ in 3years

Project 2: Building of "Issues Operational" product

• Objective: To help the Group in improving compliance with the Issue Management standards & automatically assess an Issue's compliance with the IMS

Project 3: Creation of a "Pipeline View" product

• Objective: To track due dates for a range of Non Financial Risk items to support the identification of hotspots & mitigation of bottlenecks, forecasting for the next 3 months and many more.

Project 4: Build of "Operational Risk Trend Analysis" using Narrative Science Quill

• Objective: To automate the NFRC reporting, manage & track key metrics that require intervention and action, deep-dive analysis using AI driven text narratives to identify insights using text language.

• Project Delivery – Responsible for client engagement, requirements gathering, data warehouse building, Statistical Analysis, Tableau Analytical Dashboards delivery to stake holders and other analytical analysis using R, Tableau, SQL Server, Hive QL etc
• Automation of Tableau Dashboards Refresh – Complete end-to-end automation of dashboards refresh and reports to clients and other stakeholders.

Key Projects:

Project 1: Creation and Delivery of Tableau Analytical Dashboards

• Objective: Creation and Delivery of Tableau Analytical dashboards from data warehouse consisting of 20+ data sources such as WD sales, RA, HHP, TV Media, Digital Media, Radio, Print, Outdoor, Brand Track, e-commerce, Fill Rate Out of Stock and Freshness, and Outlet data

Project 2: ITC Store on Wheels Analysis

• Objective: Help Supply Chain and Logistics Team to target Apartments in six metros to increase sales, based on inputs provided with geo-coded location data laid over containment zones

Project 3: Distribution Opportunities for Focused Planning and Growth

• Objective: Identifying the true potential of the brand at Branch level using Linear Regression and analysing the impact of increase in count of outlets or the Per Dealer Offtake to drive the growth in Sales & revise plan according to the numbers obtained in the subsequent quarters

Project 4: Geographical Analysis Impact of Covid on Supply to Outlets and understand the sales

• Objective: Identify Outlets and WD’s falling under the containment zones obtained as geo-coded polygons and points, determining the percentage area covered under the Covid zones, and finding correlation with sales.

Project 5: Clustering Analysis to segment outlets selling Chocolates and generate insights

• Objective: Classify outlets selling chocolates to different clusters to target growing outlets providing consistent and higher sales, understand how many outlets lost and revise strategies for growth

• Responsible for delivery of end-to-end CRM application as a Business Analyst

Key Projects:

Project 1: CRM solution of end to end Sales in Salesforce Platform – Business Analyst

• Objective: To understand, develop and deliver a CRM solution for end to end sales, starting from conversion of Leads to Accounts, Order, Billing and Invoicing, Business Reporting.

Project 2: Case Automation and Management in Salesforce Platform – Business Analyst

• Objective: Co-ordination with Business Team, QA Team, and Development Team to get requirement, understood, Review and Preparation of Test Scenarios and Test Cases on the User Stories for respective Sprints for Delivery of Case Management Application Automation.

9.55 GPA/CGPA

• Final Grade: 86%

• Final Grade: 90%