Work Preference
Summary
Overview
Work History
Education
Skills
Work Availability
Software
Languages
Interests
Timeline

Subhrajit Das

Snowflake Developer
Bengaluru
The way to get started is to quit talking and begin doing.
Walt Disney

Work Preference

Work Type

Full TimeContract Work

Location Preference

On-SiteRemoteHybrid

Important To Me

Work-life balanceCompany CultureFlexible work hoursPersonal development programsWork from home option

Summary

Diligent Data Analyst with background in software development, proficient in delivering high-quality code and collaborating on innovative projects. Successfully contributed to multiple agile teams, enhancing product functionality and user experience. Demonstrated expertise in problem-solving and debugging complex issues.

Overview

12
12
years of professional experience
2
2
Languages

Work History

Snowflake Developer

Etzel Technologies
06.2021 - 07.2024
  • Project Title: Canadian Imperial Bank of Commerce (CIBC-Banking Application)
  • Team Size: 15
  • Operating System: Windows 11
  • Scripting Languages: Python (Pandas, NumPy)
  • Cloud Computing: Azure (SQL DB), Snowflake, AWS
  • Duration: July 2021 to July 2024
  • Project Description:
  • This application deals with lending services in the bank. It is one of the main services in the bank. The bank is providing lending services to customers in various categories such as personal loans, Housing loans, vehicle loans, Educational loans, top up loans etc.
  • The details of each loan product are stored in the database as a table loan product. Each Product is uniquely identified with a product id according to details If the inquiry is eligible then loan calculator starts the calculation of loan amount and intimates to the inquiry through the given email and also displays on the screen instantly and generating an unique loan request Id which used during loan application
  • The Following Modules Describes the bank.
  • Loan Products.
  • Loan Requests.
  • Loan Application.
  • Loan Sanction.
  • Roles and Responsibilities:
  • Optimized SQL queries, reducing execution times by 25% and improving system performance.
  • Developed scripts to manage data partitioning, improving data retrieval speeds by 20%.
  • Assisted in migration of 10TB of data to Snowflake on AWS, achieving a 30% reduction in data access times.
  • Worked on developing data models, resulting in improved data accuracy and integrity.
  • Automated data backup processes, diminishing downtime and enhancing data recovery capabilities.
  • Collaborated with cross-functional teams to strategize and execute database schemas, enhancing data integrity and reducing redundancy by 50%.

Senior Software Engineer

CIWIN Systems Private Ltd.
10.2012 - 10.2019
  • Project Title: Global Recruitment System
  • Team Size: 10
  • Operating System: Windows 7
  • Environment: Core Java, Oracle 11g
  • Duration: November 2012 to November 2017
  • Roles and Responsibilities:
  • Requirement gathering from the Business Team and worked according to the CRUsed advanced SQL techniques (FOR ALL, BULK COLLECT) to improve performance.
    Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions,
    Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.
    Involved in modifying various existing packages, Procedures, functions, triggers according to the
    new business needs.
    Wrote SQL Queries using Joins, Sub Queries and correlated sub-Queries to retrieve data from the
    database.
    Fine-tuned procedures/SQL queries for maximum efficiency in various databases using TKPROF and
    generated AWR Reports.
    Involved in peer-to-peer code reviews.
    Testing of code functionality and Interfaces using testing environment.
  • Project Title: CITI Bank-CPB (Europe, Middle East, Africa)
  • Team Size: 15
  • Operating System: Windows 10
  • Database: Oracle 12c, MySQL
  • Duration: December 2017 to October 2019
  • Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.
  • Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
  • Wrote SQL Queries using Joins, Sub Queries and correlated sub-Queries to retrieve data from the database.
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using TKPROF and generated AWR Reports.
  • Involved in peer-to-peer code reviews.
  • Testing of code functionality and Interfaces using testing environment.

Education

B.Tech -

Biju Pattnaik Technical University
01.2008

Skills

Data Warehousing: Snowflake, ETL, OLAP

Programming/Languages: Python (Pandas, NumPy), SQL, MySQL

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Software

Snowflake

Advance SQL

AWS

Languages

English
Advanced (C1)
Hindi
Advanced (C1)

Interests

Reading

Timeline

Snowflake Developer - Etzel Technologies
06.2021 - 07.2024
Senior Software Engineer - CIWIN Systems Private Ltd.
10.2012 - 10.2019
Biju Pattnaik Technical University - B.Tech,
Subhrajit DasSnowflake Developer