Sumit Pal

About Sumit Pal

As a skilled leader, successfully managed and inspired a dynamic team of data engineers to create a world-class data warehousing solution. My expertise lies in the design of efficient data ingestion frameworks, the identification and implementation of the right tools to optimize the data platform for BI teams and the seamless execution of complex data migrations and business process implementations.With a comprehensive understanding of current processes spearheaded initiatives to improve automation, develop data migration plans and refine current business processes to maximize operational efficiency. Customer Analytics and Business Analytics :As a seasoned professional in the B2C domain, I specialize in analyzing customer behaviors and preferences to enhance their engagement with businesses. Extensive experience in customer segmentation and generating insights for retail customers, with a focus on increasing their footprints, retention rates and overall customer lifecycle. I excel in identifying the most effective methods for offering the right products through the right channels and at the right times to drive optimal results.BigQuery:As a key team member, successfully facilitated the migration of the Customer\'s Enterprise Data Warehouse (EDW) from Teradata to Google BigQuery. I led a team responsible for the conversion of legacy SQL codes and integration of existing reports with the new platform & automation routine reporting processes within the Google BigQuery env.Campaign Management :Proficient in managing user privileges, creating catalogs, and setting parameters for various purposes, designing and executing sample campaigns. Adept at monitoring databases, writing PL/SQL code for various uses, and ensuring backup of both application and database. Skilled in fine-tuning flowcharts for campaigns to optimize output and setting parameters to improve performance.Areas of expertise- Project/Stakeholder/ Vendor management with a focus on delivering high-quality results- Evaluating and implementing generative AI projects to drive innovation and achieve business goals- Engaging business users and analyzing their requirements to deliver effective solutions- Utilizing AWS services for data warehousing, with a focus on data quality and effective data & document migration- Developing ETL/ELT processes and utilizing tools such as PowerBI, Tableau, and BigQuery for descriptive analytics and customer insights- Expertise in Unica Campaign, Unica Detect, Unica eMessage, Oracle PL/SQL, Teradata, and MongoDB for data management and analysis

Experience

1. Director

   Ambit Private Limited

   Nov 2025 — Present · South Mumbai, IN

   Data Platform Initiatives, Leadership, Process Automation, Helping Business for Growth

Education

• University of Calcutta

  B.Tech, Radiophysics & Electronics

  2002 — 2005

• University of Calcutta

  Bachelor's degree, Physics

  1999 — 2002

Skills

• Data Warehousing
• Performance Tuning
• Business Intelligence
• Customer Analytics
• Unica Campaign
• Sdlc
• Solution Architecture
• Sql Server
• Oracle
• Requirements Analysis
• Sybase Iq
• Databases
• Analytics
• Unica
• Software Project Management
• Microsoft Sql Server
• Tableau
• Pl/Sql
• R
• Mongodb
• Etl
• Unica Affinium Campaign
• Business Analysis
• Sql
• Informatica