Summary
Overview
Work History
Education
Skills
Current Role
Accolades
Timeline
Generic

Kaushik Sarkar

Kolkata

Summary

Accomplished Developer/Tech Lead with extensive experience, specializing in cloud migrations and ETL processes. Proficient in PL/SQL and AWS Cloud, I excel in problem-solving and delivering innovative data solutions, enhancing operational efficiency and driving project success in high-stakes environments.

Overview

14
14
years of professional experience

Work History

Developer/Tech Lead

Tata Consultancy Services
08.2024 - Current

Migrated application from on-premises infrastructure to cloud environment. Transferred data files using Connect Direct for seamless migration process. Executed ETL processes in cloud to prepare data for new Snowflake data lakes.

Developer/Tech Lead

Tata Consultancy Services
04.2019 - 06.2024

Transitioned application from Oracle/Unix to Microsoft technologies, resulting in greater efficiency. Constructed database structure in SQL, improving data integrity and access speed. Transformed all packages and procedures into SQL language for better performance. Established workflow control via SSIS to streamline operational tasks.
Modernized legacy controls utilizing ASP/.Net framework for enhanced functionality.

Snr. Developer

Tata Consultancy Services
06.2016 - 03.2019

Executed development of Oracle packages and procedures to support business logic in credit risk.
Authored Unix scripts to ensure effective calling mechanisms.
Served as PL/SQL Developer with an emphasis on credit risk initiatives.

Snr. Developer

Tata Consultancy Services
06.2015 - 06.2016

Created robust ETL solutions within banking finance sector for various trade data formats.
Ingested and loaded files, JSON, and APIs into database structures effectively.
Leveraged Control M for batch scheduling to optimize ETL operations.
Implemented Unix scripts to facilitate automated data processing tasks.

Developer

Tata Consultancy Services
11.2013 - 06.2015

Constructed databases aligned with application API needs, facilitating smooth interactions.
Implemented procedures that allowed APIs to extract necessary data from master database.
Employed Oracle 11i technology for efficient database design and development.
Worked collaboratively on designing strategic data transmission methods among various APIs.

Junior developer

Tata Consultancy Services
03.2012 - 05.2013

Contributed in payment and tax module development.
Focused on designing database structure for Oracle applications and Sabrix app.
Migrated existing payment calculation system from Oracle apps to Sabrix.
Designed and implemented database adjustments to support migration process.

Education

B. Tech - Electronics and Communication

Netaji Subhash Engineering College
Kolkata, West Bengal

Skills

  • Languages - Unix Shell, PL/SQL, Python, Java
  • Data warehousing and lakes
  • ETL and automation tools
  • Databases - Microsoft SQL Server, Oracle, Snowflake
  • Cloud Services- Amazon S3, Glue, Airflow, and Athena
  • Version Control - Git, GitHub
  • CI/CD Pipelines - Teamcity
  • Project Management Tool - Jira, Confluence
  • Development Tools - VS, Visual Studio, SSMS, Toad

Current Role

Technical lead | Data Engineer

Accolades

  • Oracle Certified Associate degree, 2015
  • AWS Fundamentals: Going cloud native certificate, 2021
  • TCS: On The Spot Award, 10/12, 01/13, 03/13, 02/14, 05/14, 10/15, 06/16, 12/17, 03/23
  • TCS: Star of the Month Award, 05/13, 10/14, 10/21

Timeline

Developer/Tech Lead

Tata Consultancy Services
08.2024 - Current

Developer/Tech Lead

Tata Consultancy Services
04.2019 - 06.2024

Snr. Developer

Tata Consultancy Services
06.2016 - 03.2019

Snr. Developer

Tata Consultancy Services
06.2015 - 06.2016

Developer

Tata Consultancy Services
11.2013 - 06.2015

Junior developer

Tata Consultancy Services
03.2012 - 05.2013

B. Tech - Electronics and Communication

Netaji Subhash Engineering College
Kaushik Sarkar