Open To Work
Souvik Ghosh
Kolkata
Summary
Results-driven Senior Consultant with expertise in Azure Databricks, PySpark, and SQL. Proven track record of optimizing data pipelines and delivering actionable insights to enhance decision-making.
Overview
7
7
years of professional experience
2
2
Certifications
Work History
Senior Consultant
Deloitte
Kolkata
01.2022 - Current
- Optimized Azure Databricks notebooks and SQL-based pipelines, improving notebook performance by 30–40% and reducing overall pipeline runtime by nearly 50%, enabling faster and more efficient data delivery.
- Developed scalable end-to-end data pipelines using Azure Databricks, Azure Data Factory, PySpark, SQL, and Delta Lake across medallion architecture layers, delivering Inventory, Sales, and Finance data solutions with key KPI handling including GSV, TMI, BMI, and OVH.
- Analyzed large and complex datasets to generate actionable insights and support strategic decision-making for business stakeholders and clients.
- Collaborated with cross-functional teams including business, analytics, and engineering stakeholders to improve operational processes, streamline data workflows, and enhance reporting reliability.
System Engineer
Tata Consultancy Services
Kolkata
02.2019 - 01.2022
- Designed and optimized materialized views and relational database objects to improve reporting efficiency, data availability, and query performance for leave-related operations.
- Collaborated with business and functional teams to translate leave policy requirements into database logic, enhancing data accuracy, validation, and system reliability.
- Developed and maintained Oracle PL/SQL stored procedures, packages, and complex SQL queries to support the Employee Leave Management module and its backend data processing workflows.
Education
Bachelor of Technology - Electrical, Electronics And Communications Engineering
Future Institute of Engineering And Management
Kolkata09-2017
Skills
- Azure Databricks
- PySpark
- Azure Data Factory
- SQL
- Delta Lake
- Data warehousing
- Data analysis
Languages
English
Proficient (C2)
C2
Bengali
Native
Native
Hindi
Intermediate (B1)
B1
Certification
Azure Data Engineer Associate DP 203
Work Preference
Job Search Status
Open to workSalary Range
₹45000/yr - ₹200000/yrTimeline
Senior Consultant
Deloitte
01.2022 - Current
System Engineer
Tata Consultancy Services
02.2019 - 01.2022
Bachelor of Technology - Electrical, Electronics And Communications Engineering
Future Institute of Engineering And Management