Baban Biswas

Snowflake Architect

Extensive knowledge in designing Snowflake Datawarehouses

Extensive experience in automation through shell scripting Extensive knowledge on migrating Databases

Kolkata, West Bengal

983*******

adnnpi@r.postjobfree.com

https://github.com/babanbis

was/

www.linkedin.com/in/babanbi

swas

EXPERIENCE

Tata Consultancy Services Ltd, Kolkata— Snowflake

Architect

July 2018 - PRESENT

EDUCATION

Kalyani Government Engineering College, West Bengal — Bachelor of Technology in Information Technology

2014 - 2018

PROJECTS

Project Name — Snowflake Data Warehouse Design and

Implementation

Summary :

>Have overall 2.5+ years of experience in designing and implementing Snowflake data warehouse..

>Created several snowflake databases along with other required objects in Database.

>Implemented security policies in such a way that a compact access hierarchy is maintained.

>Have extensive experience in implementing snowflake task.

>Have su cient knowledge in implementing snowflake stream object.

>Have extensive knowledge in snowpipe.

>Have required knowledge in query tuning.

>Have extensive knowledge in connecting Informatica ETL tool and Microsoft PowerBI tool with Snowflake.

>Have experience in installing Snowsql in linux server.

>Have knowledge in AWS/Azure in respect of Snowflake. SKILLS

Snowflake

SQL

Unix Shell Scripting

DB2

Python

Javascript

HTML

CSS

Couchbase

Tools

Snowflake Web Portal

Snowpipe

Snowsql

AWS

Microsoft Azure

Toad

Informatica Power Center

Microsoft Power BI

Various DB2 Tools

Operating System

Unix/Linux

Windows

>Have extensive knowledge in making connections from Python Client API to Snowflake account.

>Have extensive knowledge in creating stored procedures and User Defined Functions/ User Defined Table Functions.

>Have experience in creating data pipelines in snowflakes.

>Guaranteed seamless flow of data so that there is no instance of failure.

>Designed the database in such a way that it always kept performance high.

>Automated various manual jobs using shell script so that minimum time is incurred in implementing all the required day to day activities. Experience in Other Databases/Datawarehouses :.

> Have extensive experience in IBM DB2 as well.

> Have experience in Couchbase as well.

>Have knowledge in NOSQL also.

>Have knowledge in MongoDB as well.

Personal Project

PickYourCamp - It is a

website where people can

write about any tourist palace.

Technology Used

Express Framework

Node.js

EJS

MongoDB

Bootstrap

Website Link :

https://whispering-atoll-7114

2.herokuapp.com/campgroun

ds

Github link

https://github.com/babanbis

was/CampSite

Language Known

English

Bengali

Hindi

Date of Birth

19th March, 1994

Contact this candidate