Subhrajit Das
Snowflake Developer
Bengaluru
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
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
Timeline
Snowflake Developer
Etzel Technologies
06.2021 - 07.2024
Senior Software Engineer
CIWIN Systems Private Ltd.
10.2012 - 10.2019
B.Tech -
Biju Pattnaik Technical University