SUBHASISH DUTTA
KOLKATA
Summary
Seasoned IT professional with over 18 years of experience in application development, support, and solution design on modern data analytics platforms. Expertise in Azure platform design to create a comprehensive customer 360-degree view while effectively resolving design challenges. Proven track record in managing data quality across the end-to-end journey and providing architectural support for RFI and RFP tasks. Strong leadership demonstrated as a Service Delivery Manager, successfully implementing change requests and performance improvements across diverse teams.
Overview
18
18
years of professional experience
Work History
Advisory Data Engineer Consultant
IBM India Pvt. Ltd.
10.2022 - Current
- Engagement: Focused on key use cases including Safety Stock Optimization (SSO), Inventory Projection Report (IPR), and Digital Value Stream Mapping (dVSM)
- Project Description: Migration of legacy system modules to GSK's Common Data Model, aligned with the CO-2.0 platform
- This platform ensures accessible, usable data for users and data scientists to develop tailored business models
- SSO for Vx and Rx: Implementation of Safety Stock Optimizer (SSO) to refine safety stock levels using forecast error, supply volatility, and segment-based service level analysis for Rx and Vx supply chains
- IPR: Development of an IPR Analytics solution to present inventory projections in a filtered tabular format, leveraging SAP ECC/APO data
- It provides daily, weekly, and monthly stock views by supplier and location, incorporating goods receipt, available dates, and MRP data
- DVSM: Introduction of Digital Value Stream Maps (dVSM) for automated, scalable end-to-end value stream mapping to drive supply chain optimization
- Responsibilities: Understand use case requirements and KPIs, develop high- and low-level architectures, conduct project assessments and cost optimization, perform data modelling per Common Data Model guidelines, attend Architecture Review Board (ARB) calls for approvals, build and execute unit testing, manage production rollout
- Technology/Tools: Azure Databricks (PySpark), Spark-SQL, Azure Data Lake Service, Power BI, GitHub, and ADO
Advisory Data Engineer Consultant
IBM India Pvt. Ltd.
10.2022 - 12.2022
- Engagement: Pharma Sustainability data and analytics roadmap design and development [Client name: Glaxo Smith Kline Pharmaceuticals Ltd]
- Project Description: GSK has formulated an Environmental Social Governance ('ESG') strategy, determining appropriate performance metrics and reporting prerequisites
- They now aim to articulate and create scenarios for a forthcoming platform dedicated to managing ESG data and conducting analytics
- Responsibilities: Understand the use case requirement and Report KPIs, high- and low-level architecture development, project assessments and cost optimization, data modeling as per Common Data Model guideline, build and unit testing
- Technology/Tools: Azure Databricks (pyspark), Spark-SQL, Azure Data Lake Service, Power BI for reporting, ADO
Associate Consultant
Tata Consultancy Services
01.2021 - 10.2022
- Engagement: 2L & 3L Production Support and Enhancement/Improvement [Client name: Glaxo SmithKline Pharmaceuticals Ltd]
- Project Description: Production and platform support (2L & 3L) of Couple of modules that are running in different environments with different frameworks
- Also, enhancement of platform as well as existing business with impact analysis
- Responsibilities: User story assessment and scope analysis based on the support point of view, involved in Sprint planning to create and estimate the tasks, participate in Project plan and effort estimations, gather business requirements and design the development and change process, working on implementation plan with soundless & issueless production roll out to achieve timely delivery process
- Technology/Tools: ADF V2, Azure Databricks (pyspark), Spark-SQL, Azure SQL Managed instances, Azure Data Lake Service, Power BI reporting, ADO, SAP Log-On, Service-Now
Senior Consultant
Infosys Limited
10.2018 - 01.2021
- Engagement: DB migration from On-Premises data to Azure Cloud [Client name: British Petroleum]
- Project Description: Edward Migration Project: EDWARD is a data warehouse environment, designed to centrally manage the various data feeds for workstation, consumption and compliance reporting runs on On-Premises BP SQL Server, that was migrated to Azure Cloud Environment in SQL Managed instances
- Responsibilities: Project assessment, design, and Plan for migration from On-Prem to Azure Cloud Environment, discuss details project workflow with BP Service manager, SMEs' and existing stakeholders to understand and design scope of the projects based on the strict deadline along with Resource planning in different phases
- Technology/Tools: ADF V2, Azure Databricks (pyspark), Spark-SQL, Azure SQL Managed instances, Azure Data Lake Service, Power BI reporting, ADO
Senior Consultant
Infosys Limited
11.2018 - 08.2019
- Engagement: Security Implementation for the HR Module in Cloudera Data Lake [Client: British Petroleum]
- Project Description: The project involves securing and integrating data from upstream systems (e.g., Workday, Kenexa) into BP's Cloudera Data Lake via file gateway protocols
- Responsibilities: Analyse client and project requirements (functional and non-functional) by reviewing documentation and collaborating with Business Analysts/SMEs to prepare system requirement documents and support design, development, and testing phases
- Tools Used: Cloudera Data Lake (CDH 5.13), Hive, Spark-SQL, Oozie, Pipeline, VSTS, Jenkins
Tech Lead
Tech Mahindra Ltd
03.2016 - 09.2018
- Engagement: IPCG2(IP Clear Global) Live Issue handling
- [Client name: British Telecom]
- Project Description: Analysis the live issues for BT IP Connect Global 2 Order journey and Could Connect Direct Products and identify the RAC for existing and new problem
- Responsibilities: Working on IPCG2 L2C E2E Design area supporting the different component team with design/architectural directions and queries, analysing the design related issue and queries in the production environment and provide tactical / strategic fix of design related issues in BT GS area
Tech Lead
Tech Mahindra Ltd
03.2015 - 03.2016
- Engagement: Orion Managed IP Migration (BT End-to-End Design) [Client name: British Telecom]
- Project Description: There is a Legacy order-handling system called ORION that contains inventory and order details for a few different BT GS products
- Responsibilities: Data quality of MIP inventories in Orion was analyzed for more than 900 customers and underlying sites & services
Tech Lead
Tech Mahindra Ltd
03.2010 - 02.2015
- Engagement: Tier II and Tier III production Support as Team Lead for BT-Global Services - Inventory Management [Client name: British Telecom]
- Project Description: This project is a data distribution hub that gathers information from one or more systems and provides aggregated data in any form or shape desired
- Responsibilities: DQ management is the processes of checking the quality of the data as well as analysis the error occurred when huge amount of data is moving from different schema undergone in different extraction processes
Software Engineer
R S Software (India) Ltd
07.2007 - 02.2010
- Engagement: Application Development & Maintenance Support for Management Information System Business Support group (BSG Dashboard) System and Report Generation
- Project Description: The objective of this application is to develop, maintenance and support various internal activities
- Technologies used in this project are Oracle 10G, and SQL Developer, Toad, IIS Server & ASP .Net, Java Script, HTML
Education
Masters - computer application
West Bengal University of Technology
Bachelor of Science - Computer Application
University of Kolkata
Skills
- Generative AI
- Cloud data integration
- Data pipeline development
- Data modeling
- AZURE Storage
- Azure Databricks
- Azure Data Factory (Gen 2)
- SPARK
- Py-Spark
- Spark-SQL
- HIVE
- SQL
- PL/SQL
- Snowflakes
Technical Summary
AZURE Storage, Azure Databricks, Azure Data Factory(Gen 2), Azure SQL MI, Hadoop 2.0 Framework, SPARK, HIVE, Talend ETL, SQL, PL/SQL, PySpark, Spark-SQL, Oracle 10G, SQL DB (MI), SQL-DWH, Snowflakes
Personal Information
- Pan Number: ANQPD0149J
- Passport Number: P9316950
- NSR Itpin : 841166383898
- Date of Birth: 01/08/82
- Gender: Male
- Nationality: Indian
- Marital Status: Separated
Languages
English
First Language
Bengali
Proficient (C2)
C2
Hindi
Elementary (A2)
A2
References
References available upon request.
Timeline
Advisory Data Engineer Consultant
IBM India Pvt. Ltd.
10.2022 - Current
Advisory Data Engineer Consultant
IBM India Pvt. Ltd.
10.2022 - 12.2022
Associate Consultant
Tata Consultancy Services
01.2021 - 10.2022
Senior Consultant
Infosys Limited
11.2018 - 08.2019
Senior Consultant
Infosys Limited
10.2018 - 01.2021
Tech Lead
Tech Mahindra Ltd
03.2016 - 09.2018
Tech Lead
Tech Mahindra Ltd
03.2015 - 03.2016
Tech Lead
Tech Mahindra Ltd
03.2010 - 02.2015
Software Engineer
R S Software (India) Ltd
07.2007 - 02.2010
Masters - computer application
West Bengal University of Technology
Bachelor of Science - Computer Application
University of Kolkata
Similar Profiles
Pallavi Kumar Pallavi Kumar null
NA at IBM India Pvt Ltd, Bangalore IBM India PNA at IBM India Pvt Ltd, Bangalore IBM India P
Shruti PaintalShruti Paintal
SERVICE INTERGRATION MANAGER at Kyndryl India Pvt Ltd and IBM India Pvt LTDSERVICE INTERGRATION MANAGER at Kyndryl India Pvt Ltd and IBM India Pvt LTD
Akhila ShilpaAkhila Shilpa
Senior Project Manager at IBM India Pvt Ltd/ Kyndryl India Pvt LtdSenior Project Manager at IBM India Pvt Ltd/ Kyndryl India Pvt Ltd
Sudhir NigamSudhir Nigam
Senior Lead, Software Architecture (Automation Architect) at Kyndryl India Pvt Ltd (IBM India Pvt. Ltd.)Senior Lead, Software Architecture (Automation Architect) at Kyndryl India Pvt Ltd (IBM India Pvt. Ltd.)
ASWINI KUMAR SHARMAASWINI KUMAR SHARMA
Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.