Transforming Data into Strategic Insights

I help organizations harness the power of their data through scalable cloud architecture, intelligent pipelines, and analytics solutions that drive measurable business outcomes.

Explore Projects
Data Engineer Portrait

About Me

Passionate data engineer with expertise in designing, implementing, and optimizing data solutions on the Azure cloud platform. I specialize in building scalable ETL/ELT pipelines, data warehousing, and implementing solutions that turn raw data into actionable insights.

6+

Projects Completed

4+

Happy Clients

4.5

Years Experience

6

Certifications

Professional Certifications

Microsoft
Microsoft Azure Fundamentals badge

Microsoft Azure Fundamentals

AZ-900

Microsoft
Azure Data Fundamentals badge

Azure Data Fundamentals

DP-900

Databricks
Databricks Fundamentals badge

Databricks Fundamentals

Databricks
Generative AI Fundamentals badge

Generative AI Fundamentals

Databricks
Azure Databricks Platform Architect badge

Azure Databricks Platform Architect

Apache
Apache Airflow Fundamentals badge

Apache Airflow Fundamentals

Professional Journey

I transform raw data into gold! ✨ Check out how I've helped below companies discover hidden insights and make smarter choices that really matter.

RWS Moravia India Private Limited

Senior Data Engineer | Technical Lead

Jan 2024 - Present
Show Details

BinaryERP Technologies India Private Limited

Junior Data Engineer

Mar 2021 - Dec 2023
Show Details

Capgemini Technology Services India Limited

Associate Data Engineer

Mar 2018 - Mar 2021
Show Details

Technical Expertise

A snapshot of the technologies and practices I utilize to build modern, scalable data solutions.

Select a skill category

Click any category above to explore my expertise

Services Offered

End-to-end data engineering solutions to help you harness the power of your data and transform it into strategic business advantages.

Data Architecture Design

Strategic design of data architectures tailored to your business needs, leveraging Azure's cloud capabilities for scalability and performance.

ETL/ELT Pipeline Development

Building robust data integration pipelines using Azure Data Factory, Databricks, and other modern tools to transform raw data into valuable insights.

Data Warehouse Modernization

Upgrading legacy data warehouses to modern Azure Synapse Analytics, improving performance, scalability, and analytics capabilities.

Real-time Analytics Solutions

Implementing streaming analytics with Azure Event Hubs, Stream Analytics, and Power BI for real-time business intelligence and monitoring.

Data Governance & Security

Establishing robust data governance frameworks and implementing security measures to ensure compliance with regulatory requirements.

ML & AI Integration

Incorporating machine learning and AI capabilities into your data platform using Azure ML services for predictive analytics and intelligent insights.

Featured Projects

Explore some of my recent data engineering projects that showcase my expertise in Azure cloud solutions and data transformation.

Google Data Migration

Seamlessly migrated 15+ TB of Google API data from MongoDB to Azure SQL Server with zero data loss, resulting in a 28% reduction in operational costs.

Azure Data FactoryAzure DatabricksPySparkMongoDBAzure SQL

Cloud Migration PoC

Spearheaded a proof of concept for on-premises data migration using innovative incremental load patterns, cutting migration time by 40% while enhancing data accessibility.

Azure Data FactoryAzure DatabricksETL PipelinesIncremental Loading

HR & Finance Data Integration

Designed over 100 interactive reports with sophisticated multi-tier data models, boosting data accessibility by 40% and slashing query response times by 35%.

Power BIAzure DatabricksAzure Data FactoryData Modeling

ERP Lease Management

Streamlined lease management data models from Dynamics 365, cutting data modification times by 30% and significantly boosting overall system performance.

D365 F&OAzure Data FactoryData ModelingETL Pipelines

Enterprise Lease Data Migration

Orchestrated the transition of critical enterprise data from on-premises systems to the cloud, implementing automated transformation processes that reduced migration time by 25%.

Azure Data FactoryAzure SQL DatabaseData MigrationETL Automation

Automated Financial Reporting

Created dynamic financial dashboards that seamlessly integrated data from multiple sources, eliminating manual reporting processes and saving 25% of staff time.

Power BIAzure SQL DatabaseFinancial ReportingData Integration

Testimonials

Don't just take my word for it — hear what clients and colleagues have to say about my expertise and the impact of my work.

Working with Swarnava has been amazing! He's not just technically brilliant with Azure data services, but also a great team player.

PS

Priya Sharma

Consultant

Capgemini Technology Services India Limited

Swarnava is the kind of colleague everyone wants on their team. During our data warehouse project, he explained complex concepts in simple terms and always made time to help others. His practical approach saved our project when we hit roadblocks.

VP

Vikram Patel

Senior Software Developer

Binary Stream

I've worked with many consultants, but Swarnava stands out for his genuine passion for solving problems. He doesn't just deliver technical solutions - he takes time to understand our business needs first. Plus, he's fun to work with even during tight deadlines!

AD

Ananya Desai

Project Manager

Capgemini Technology Services India Limited

Ready to Transform Your Data Operations?

Let's collaborate to build modern, scalable, and efficient data solutions on cloud that drive real business value.

Get In Touch

Interested in working together? Let's discuss how I can help transform your data into actionable insights.

Contact Information

Location

Kolkata, West Bengal, India

Connect with me

Send a Message