Soham Dasgupta

About Soham Dasgupta

Data as a Service(DaaS) focussed Data Platforms Engineer with a strong Data Analytics background. Currently developing a Metric management platform utilizing universal semantic layer that powers data requirements for Applications, Agents(Text2SemanticLayer2Insights) and Analytics(dashboards/decks).Other recent project include 1) vending federated data Analytics using an API on Native AWS and 2) building an Organic Search dashboard utilizing Druid/Superset stack.Tech Stack - Spark, Python, Java/Scala, Typescript(CDK), SQL, Apache Airflow, Flink, Druid, Superset, Docker(Containerization), dbt, Metricflow, Trino, Bedrock(Knowledge Bases, Agent and AgentCore), ECS, Fargate

Experience

1. Data Engineer Ii - Platforms

   Amazon

   Dec 2022 — Present · Bengaluru, IN

   Facilitating Organisation wide metric centralization using Low code/No Code Data Engineering on a secure Data Estuary to enable federated querying at Amazon scale.Notable projects include deploying/optimizing a medium sized(70 nodes) Trino in EMR cluster to query Iceberg tables in S3 with focus on Data Security using LakeFormation, ACLs and Writing a complete CDK application to deploy/ orchestrate dbt/metricflow for production DaaS use cases

Education

• Aditya Academy Senior Secondary

  AISSE, Languages Science Social Studies Mathematics Physical Education

  2005 — 2010

• Indira Gandhi National Open University

  Post Graduate Diploma in Applied Statistics, Statistics

  2019 — 2020

• Sudhir Memorial Institute

  AISSE, Pure Science with Biology

  2010 — 2012

• West Bengal University of Technology, Kolkata

  Bachelor of Technology (B.Tech.)

  2012 — 2016

Skills

• Microsoft Office
• Construction
• Amazon Redshift
• Database Management System (Dbms)
• Staad-Pro
• Concrete
• Microsoft Sql Server
• Adobe Photoshop
• Vba Scripting
• Structural Analysis
• Risk Investigations
• Structural Engineering
• Tableau
• Powerbi
• Engineering
• Reinforced Concrete
• Civil Engineering
• Management
• Java
• Transact-Sql (T-Sql)
• Regression Analysis
• Microsoft Excel
• Autocad
• Surveying
• Structured Query Language
• Fraud Investigations
• Advanced Ms Excel
• Pl/Sql