Kolkata, West Bengal, India
MDM Team Lead with 15+ years of IT experience - 5 years of hands-on Master Data Management and Data Quality work (profiling, cleansing, enrichment, validation, and standardization across product, business location/store master, item master, and HR/store manager domains), and 10+ years in SQL Server Database Administration on Azure. Lead and manage a team of 4-6 members with end-to-end ownership of MDM delivery, while remaining hands-on across data integration and data quality work, and act as the primary client point of contact for technical and functional MDM queries. Currently expanding Data Governance knowledge through structured learning. Collaborate closely with project managers, business teams, and technical stakeholders, contributing an MDM perspective to requirement discussions and configuration decisions within Dell Boomi Master Data Hub, integrating sources including Dynamics AX 2009, Dynamics CRM, MDS, SuccessFactors, SharePoint, and PIM/LIB. Strong expertise in Azure cloud technologies, SQL Server administration, performance tuning, capacity planning, HA/DR (Always On AG, Log Shipping, Transactional Replication), database migrations, and large-scale OLTP/OLAP environments. Skilled in data analysis using SQL, Python, and Excel, with hands-on experience across Azure DevOps, Azure Databricks, Jira, SSIS, and SSAS. Worked onsite with European clients on MDM delivery and team coordination. Core Competencies Master Data Management (MDM) - Data Profiling, Cleansing, Enrichment, Validation, Standardization, Data Cataloging Dell Boomi (Master Data Hub, AtomSphere Integration, API Management) SQL Server Administration - Performance Tuning, Capacity Planning, HA/DR (Always On AG, Log Shipping, Transactional Replication) Azure SQL Database, Azure Databricks, Azure DevOps, Database Migration (BACPAC, DMA) Data Quality Standards, Cross-Functional Collaboration, Exposure to Data Governance Practices SQL, Python, Excel, SSIS, SSAS, Jira
⦁ Lead and manage a team of 4-6 members, with formal performance management responsibility - allocating work across data integration, data quality, and domain management activities, reviewing deliverables, and taking end-to-end ownership of MDM delivery while remaining hands-on in execution. ⦁ Act as the primary point of contact for the client on technical and functional MDM queries, providing direct clarification and resolution. ⦁ Performed data assessment, profiling, cleansing, enrichment, and validation as part of enterprise Master Data Management initiatives. ⦁ Contributed to defining data quality standards and remediation processes for assigned business domains, coordinating with data stewards to apply established frameworks for resolving data quality issues. ⦁ Implemented and administered Master Data Hub solutions on Dell Boomi, integrating master data from source systems including Microsoft Dynamics AX 2009, Microsoft Dynamics CRM, Microsoft Master Data Services (MDS), SuccessFactors, SharePoint, and PIM/LIB systems, covering product, business location (store master), item master, and HR (store manager) domains. ⦁ Ensured master data exposed via Dell Boomi API Management was accurate and reliable for downstream applications consuming each domain's data. ⦁ Collaborated closely with project managers, business teams, and technical stakeholders throughout requirement discussions and configuration decisions, contributing an MDM perspective and coordinating implementation within Dell Boomi Master Data Hub. ⦁ Coordinated with cross-functional teams on data integration and migration tasks, supporting broader data governance initiatives through participation in stakeholder discussions and review meetings. ⦁ Worked onsite in Europe (Dec 2022 - Jul 2024), supporting MDM delivery and day-to-day team coordination.
⦁ Database administration and development for very large and complex databases in SQL Server 2017/2016 (Windows and Linux). ⦁ Designed, developed, implemented, and maintained Azure SQL Database environments. ⦁ Assessed and migrated on-premises SQL Server to Azure SQL Database (PaaS) using BACPAC and DMA. ⦁ Migrated on-premises SQL Server to Azure IaaS with HA/DR (Multi-subnet Always On Availability Group). ⦁ Performed production database administration, server configuration, performance tuning, capacity planning, maintenance, and troubleshooting. ⦁ Performed data analysis using Python, SQL, and Excel.
Installation, configuration, maintenance, and administration of SQL Server 2008, 2005, and 2000. Upgraded and migrated database servers. Implemented and managed DR and HA solutions using Log Shipping. Created maintenance plans for index defragmentation, re-indexing, and statistics updates. Created jobs, Database Mail Agent, and scheduled DTS and SSIS packages. Performed integrity checks using the database maintenance plan wizard and DBCC utilities. Managed database backups, restoration, and security.
Installed and configured database servers. Performed database maintenance, tuning, and purging. Supported application developers on application databases. Upgraded and migrated database servers. Managed database backups, restoration, and security. Wrote SQL scripts and queries.