A R I N D A M M I T R A
****************@*****.*** +91-983******* HOWRAH, WEST BENGAL, INDIA
Professional Summary
Dynamic Lead BI Developer with 22 years of experience in Business Intelligence, Data Engineering, and Project Management. Proven expertise in optimizing ETL pipelines, migrating on-premises systems to Azure and leading cross-functional teams to deliver scalable, high-impact data solutions. Skilled in SQL Server, ETL, Azure Data Factory, SSIS, Power BI and Dimensional Data Modelling with a strong focus on stakeholder collaboration, project success, and continuous improvement. Professional Skills
ETL & Data Integration: Azure Data Factory, SSIS
Databases: SQL Server, Azure SQL Database, Mongo DB (NoSQL)
Data Visualization & Analytics: Power BI, MDX, SSAS, SSRS
Cloud & Big Data: Azure Cloud, Databricks
Project Management & Tools: Jira, Git
Data Modelling: Dimensional Data Modelling, Data Warehousing Professional Experience
CISIVE INDIA (P) LTD, New Delhi
Lead BI Developer 08/2022 – 05/2025
Communicated with stakeholders to assess project feasibility and align deliverables with business goals.
Developed and optimized ETL pipelines using Azure Data Factory, reducing data processing time by 25%.
Led the migration of on-premises databases to Azure SQL Database, enhancing scalability and reducing infrastructure costs.
Designed and analysed dimensional data models and created SSIS packages for seamless data integration.
LANCESOFT INDIA (P) LTD, Bangalore
Technical Project Manager 08/2021 – 06/2022
Translated business requirements into actionable project plans and milestones.
Managed project scheduling and task assignment using Jira.
Delivered interactive data visualizations using Power BI, improving decision-making efficiency.
HEXPLORA LLC, Kolkata
Senior MSBI Developer 02/2021 – 08/2021
Database modelling, design, and issue resolution.
Conducted data loading activities for enterprise data warehouses.
Designed Power BI dashboards to enhance operational insights. BLU COCOON DIGITAL (P) LTD, Kolkata
Data Modeller & Database Engineer 07/2020 – 02/2021
Gathered and analysed requirements for data solutions.
Designed and implemented data models and database architectures.
Oversaw data migration activities to ensure accuracy and integrity. GAMUT INFOSYSTEMS LTD, Kolkata
Senior Software Engineer 03/2019 – 06/2020
Managed team performance and project deliverables.
Delivered analytical dashboards for CRM and payroll systems.
Monitored new development activities for potential system-wide impacts. DCG DATACORE SYSTEMS (P) LTD, Kolkata
Senior Software Engineer 01/2016 – 03/2019
Designed databases, SSIS packages, and SSAS cubes.
Monitored full and incremental data loads via SQL Server job scheduling. INLAND WORLD LOGISTICS (P) LTD, Kolkata
Senior Software Developer 12/2006 – 01/2016
Designed databases and SSIS packages for enterprise applications.
Developed reports to support operational and management needs. AMBEE ENGINEERING (P) LTD, Kolkata
Software Developer 12/2004 – 12/2006
Developed SSIS packages and designed databases for business reporting.
Created reports to improve organizational decision-making. Key Projects
Operational Data Mart and Analytics
Environment: SQL Server 2016, Azure Cloud, Azure Data Factory, Power BI
Designed and implemented medallion architecture to migrate on-premises data to Azure SQL.
Created data marts for employment, education, and healthcare, enabling advanced analytics.
Delivered Power BI dashboards for stakeholders to make informed decisions. Data Governance and Analytics
Environment: SQL Server 2016, SSDT 2019, SSIS, Alteryx, Power BI
Ensured high data quality and regulatory compliance through advanced data governance processes.
Developed risk rating models and visualized insights through Power BI dashboards. HEX Care Management
Environment: SQL Server 2016, SSDT 2017, SSIS, SSAS, Power BI
Built a data-driven care management system for physicians and care managers to track patient interventions and progress.
Education & Certifications
Purdue University, USA – Post Graduate Program in Data Analytics, 2022
ICFAI University, India – Master of Business Administration (MBA), 2018
University of Calcutta, Kolkata – Bachelor of Science, 1996
CMC Limited, Kolkata – Diploma in Oracle & PowerBuilder, 1998
Vidyasagar Academy, Kolkata – Diploma in Software Technology, 1995 Languages
English, Hindi, Bengali