profile-pic

Atanu Basu

20 years of IT experience with specialization in Data warehousing & Cloud technologies across industry domains like Telecom, Banking & Finance, Life Science & Healthcare, Energy & Resource, Retail & CPG

8+ years of relevant experience as Solution/Data Architect on Snowflake, Azure, AWS, GCP Cloud platforms with designing solutions using ETL/ELT tools such as IICS, Matillion, Fivetran, Dbt & data visualization tools such as Tableau, Power BI & Sigma .

Proficient in requirement gathering, analysis, architecture design, data modelling, defining data migration strategies & development. Worked on Pre-sales activities. Delivered several RFPs for different customers across the globe.

  • Role

    Principal Architect / Administrator

  • Years of Experience

    20.2 years

Skillsets

  • SQL
  • PostgreSQL
  • Power BI
  • PyCharm
  • PySpark
  • Python
  • Redshift
  • ServiceNow
  • Sigma
  • Snowflake
  • Pl/sql
  • Tableau
  • Terraform
  • Unix Shell Scripting
  • YAML
  • Google Bigquery
  • Jenkins
  • SQLDBM
  • Synapse Analytics
  • dbt
  • Airflow
  • Amazon RDS
  • AWS
  • AWS Glue
  • Azure
  • Azure Data Factory
  • Azure SQL DB
  • Databricks
  • Aginity
  • erwin
  • Fivetran
  • GCP
  • Gitlabs
  • Informatica
  • Jira
  • Matillion
  • Microsoft Visio

Professional Summary

20.2Years
  • Apr, 2024 - Present1 yr 6 months

    Principal Architect / Administrator

    Securonix
  • Feb, 2023 - Apr, 20241 yr 2 months

    Solution Architect / Data Architect

    Kipi.bi
  • Oct, 2020 - Feb, 20232 yr 4 months

    Cloud Solution Architect / Data Architect

    Tata Consultancy Services
  • Apr, 2009 - Jan, 2010 9 months

    Senior Oracle Developer / Data Architect

    Web Development Company
  • Jan, 2010 - Nov, 20144 yr 10 months

    Teradata Developer / DBA

    IBM India
  • Nov, 2014 - Oct, 20205 yr 11 months

    Cloud Data Engineer

    Cognizant Technology Solutions
  • Aug, 2007 - Mar, 20091 yr 7 months

    Oracle & Unix Developer

    Nelito Systems
  • Dec, 2006 - Aug, 2007 8 months

    Oracle Apps 11i Consultant

    SAPL
  • Aug, 2005 - Nov, 20061 yr 3 months

    Oracle SQL, PL/SQL Developer

    Descon

Work History

20.2Years

Principal Architect / Administrator

Securonix
Apr, 2024 - Present1 yr 6 months
    Designed and developed the Snowflake platform to capture customer logs, analyze and inform if there is any threat or risk in real time. Developed database objects, stored procedures, functions, tasks, streams to ingest data into Snowflake and enable fast query processing on petabyte scale. Setup and managed Multi-cluster Virtual Warehouses (Standard, Snowpark optimized) for ingestion and query processes. Designed and implemented RBAC (Role based access control). Managed OrgAdmin with 15+ Production & Non-production Accounts. Developed Snowpipe to ingest data from AWS S3 & Azure storage. Developed External tables, Iceberg tables to query AWS S3 data. Load & Unload process for huge datasets. DR account setup. Followed Agile methodology for enhancements. Interacted with customers to resolve issues. Implemented performance improvements and cost optimization. Developed Snowsight dashboards for monitoring data usage, billing, query performance, storage, and compute.

Solution Architect / Data Architect

Kipi.bi
Feb, 2023 - Apr, 20241 yr 2 months

Cloud Solution Architect / Data Architect

Tata Consultancy Services
Oct, 2020 - Feb, 20232 yr 4 months

Cloud Data Engineer

Cognizant Technology Solutions
Nov, 2014 - Oct, 20205 yr 11 months

Teradata Developer / DBA

IBM India
Jan, 2010 - Nov, 20144 yr 10 months

Senior Oracle Developer / Data Architect

Web Development Company
Apr, 2009 - Jan, 2010 9 months

Oracle & Unix Developer

Nelito Systems
Aug, 2007 - Mar, 20091 yr 7 months

Oracle Apps 11i Consultant

SAPL
Dec, 2006 - Aug, 2007 8 months

Oracle SQL, PL/SQL Developer

Descon
Aug, 2005 - Nov, 20061 yr 3 months

Education

  • Bachelors in Mathematics Honors

    The University of Burdwan (2001)

  • Master of Computer Application

    U.P Technical University (2005)

  • Master of Business Administration (MBA-IT)

    Sikkim Manipal University (DE) (2010)