Summary
Overview
Work History
Education
Skills
Accomplishments
Affiliations
Certification
Languages
Interests
Timeline
Training Conducted
Personal Details
Publications
Generic
Kishore Kumar Samanta

Kishore Kumar Samanta

Delaware,USA

Summary

Have worked as application consultant and system architect in the Different Banking applications at TCS vendor side for CITI bank north America as client.

12+ years’ experience in trade applications ,Payment systems, Ledger Systems and core banking domain. Involved in User requirement understanding and analysis and designing projects using ETL tools, Big Data cluster assisted by relevant programming languages, writing the low level design on the basis of the high level design derived from requirements, ensuring deployment of new codes successfully by coordinating with OPS and customer Management team.

Centralization of banking data under Big data cluster by designing Spark framework

Is the primary current initiative. along with supporting Python automation on legacy codes migrations .
Have 2+ years experience on Agentic RAG solution based chatbots. Have worked on Legacy codes like C++ , Pro C* ,Sybase and OracleSql. Have Database DM experience for ETL tools like Abinitio along with AWS cloud orchestration.

Apart from core data technology experiences, have certification for Agile methodology
Certified Generative AI with LLM on AWS.

Certified Pyspark Databricks developer.

Certified AWS developer associate

Overview

13
13
years of professional experience
36
36
Certification

Work History

Data Architect

Tata Consultancy Services
06.2023 - Current
  • Designing big data framework architecture for recon finance reports and datalake ingestions
  • Analysis of Trade data for partners systems.
  • Preparing Functional Specifications.
  • Developing and enhancement of the application as per client request.
  • Implement Agentic RAG solution via openshift4 POD orchestration and implement new age CDIC pipelines
  • Project: Citi Institutional Consumer Group(ICG)- Trade System aims to automate enterprise reporting needs by building an big data Information conformance. This would improve the Business Intelligence and Process Management capabilities of various systems within Citi. Mainly Trade loans are reconciled against different parameters identified through intensive Data analysis on Hadoop cloudera and oracle hosted datasets
  • Carried out the following activities:
  • Design & Development of end-to-end Big data applications, Prepare the LLD and estimation documents for the new development
  • Consolidated data modelling and mapping
  • Performance tuning of the Code, Migrate the Code to different releases.
  • Unit testing and bug fixing of the application for L3 modification.
  • Automating few processes through Python Programs
  • Finance reconciliation for Monthly reports
  • Using Framework components in different applications reconciliation
  • Hardware: Windows 10 based Cloud network
  • Operating System: Windows 10, UNIX, LINUX-REHL7
  • Languages: Python, Scala, UNIX Shell Script, Hive/impala, Sybase, Autosys, PL/SQL,Po C
  • SQR
  • Special Software: INTELIJ, PYCharm, Starbrust Tectia Client, Git bash, Oracle sql developer, Bitbucket, Udeploy, OCP4
  • Project Location: Delaware, United states

Consultant Programmer (Data Warehousing Specialist)

Citi Bank NA
01.2019 - 06.2023
  • Requirement Analysis of different source systems.
  • Migration of legacy application to Flex platform
  • Preparing Functional Specifications.
  • Developing and enhancement of the application as per client request.
  • Unit testing and bug fixing of the application for L3 modification.
  • Change coordination.
  • Co-ordinate with the involved team and resolving the issues raised by them.
  • Automating few processes through scripts
  • Finance management for daily ledger reports
  • Project: Citi Institutional Consumer Group(ICG)-Treasury Trade Solution(TTS) aims to automate enterprise reporting needs by building an Information Warehouse. This would improve the Business Intelligence and Process Management capabilities of various systems within Citi. ETL (Extraction Transformation and Loading) works as a data transformation layer interfacing between various source and downstream systems. Processes are developed using ETL techs.
  • Carried out the following activities:
  • Requirement Analysis from the Business Users on a regular basis
  • Bi-weekly Change co-ordination
  • Design & Development of end-to-end ETL applications, Prepare the LLD and estimation documents for the new development
  • Performance tuning of the Code, Migrate the Code to different releases.
  • Perform ETL Software Upgrades, ETL capacity planning and responses, ETL source code control management
  • Unit Testing the Graphs once development is complete
  • Developing and Using Framework components in different applications
  • Hardware: Windows XP/7 based PC
  • Operating System: Windows XP/7, UNIX, LINUX-REHL7
  • Languages: UNIX Shell Script, SQL, Sybase, Oracle, Autosys, PL/SQL,Po C
  • SQR
  • Special Software: Tectia Client, Git bash, Talend studio, Bitbucket, Udeploy
  • Project Location: Delaware, United states

Analyst Programmer (Data Warehousing Specialist)

Citi Group
12.2013 - 12.2018
  • Requirement Analysis of different source systems.
  • Preparing higher level and lower level design document for the requirement
  • Preparing Functional Specifications.
  • Developing and enhancement of the application as per client request.
  • Unit testing and bug fixing of the application.
  • Preparation of Use-cases.
  • Co-ordinate with the involved team and resolving the issues raised by them.
  • Automating few processes through scripts
  • Engage GIW Framework components to different applications
  • Developing PI/SQL framework
  • Project: Citi Institutional Consumer Group(ICG)-Treasury Trade Solution(TTS) aims to automate enterprise reporting needs by building an Global Information Warehouse(GIW). This would improve the Business Intelligence and Process Management capabilities of various systems within Citi. ETL (Extraction Transformation and Loading) works as a data transformation layer interfacing between various source and downstream systems. Processes are developed using ab initio and Unix technologies.
  • Carried out the following activities:
  • Requirement Analysis from the Business Users on a regular basis
  • Design & Development of end-to-end ETL applications, Prepare the LLD and estimation documents for the new development
  • Performance tuning of the Code, Migrate the Code to different releases.
  • Perform ETL Software Upgrades, ETL capacity planning and responses, ETL source code control management
  • Unit Testing the Graphs once development is complete
  • Developing and Using Framework components in different applications
  • Hardware: Windows XP/7 based PC
  • Operating System: Windows XP/7, UNIX
  • Languages: UNIX Shell Script, SQL, Ab-Initio (3.1.1.10), Oracle, Autosys, PL/SQL,Po C
  • Special Software: Tectia Client, SQL Developer
  • Project Location: Kolkata, India

Trainee

TCS Internal
01.2013 - 04.2013
  • Software development process life cycle.
  • Requirements engineering.
  • System design overview.
  • Review, code walkthrough and Inspections.
  • Testing and debugging.
  • Software maintenance.
  • Object oriented methodologies, DBMS, UNIX.
  • Soft skills – personal grooming, working in teams effectively, Effective Presentation.
  • Stream Training –Unix,C++
  • Project: The TCS Initial Learning Program focuses on enhancing the Technical as well the soft skills of the Associates. This program mainly constitutes of two phases, one being the Common Training phase which has the curriculum to enhance the basic analytic and logical skills of the associate. It also focuses on the improving the Communication skills by means of presentations, Group Discussions etc. The second phase constitutes of the Stream Training which focuses on mastering a particular technology. The entire program grooms the associate in the perfect way to handle the corporate world.
  • Carried out the following activities:
  • Code designs as per the Case Studies Provided.
  • Enhancing communication skills and etiquettes.
  • Develop various codes based on the Case study Analysis and design.
  • Hardware: Windows XP based PC
  • Operating System: Windows XP, UNIX
  • Languages: UNIX Shell Script, Oracle, SQLPlus
  • Special Software: Oracle, Visual Studio
  • Project Location: Hyderabad, India

Education

Bachelor of Technology - Electronics & Communication Engineering

West Bengal University of Technology
Kolkata, West Bengal
01.2012

Skills

  • Operating systems: Windows, UNIX, LINUX
  • Programming Languages: Spark, Scala, Hive, Impala, Python, pySpark, Unix Shell Scripting, Hyperion, Sybase, C, PL/SQL, C, Pro C
  • Special Software: Langgraph, Langchain, VertexAI and openai orchestrations of Agentic AI, Starbrust, ANACONDA, Mssql Studio ETL Tool-ABINITIO, SQL Developer, DB vizualizer Autosys, AWS, Mongodb and Chroma Db CLI

Accomplishments

Recieved Best team award in 2024

Recieved AI-spark recognition 2025

Recieved Employee of the quarter in 2023

Recieved Employee of the month few times.

Recieved Multiple Client Appreciations over the Career

Affiliations

NA

Certification

Certified Generative AI with LLM on AWS.

Certified Pyspark Databricks developer.

Certified AWS developer associate

Certified Snoflake core

Languages

English
Full Professional
Hindi
Native or Bilingual
Bengali
Native or Bilingual

Interests

To See what yet awaits within beautiful nature Love Longdrives and hikes through Natural wornders

Leisure time would like to enjoy some digital entertainments, soul gaming or a gentle friendly gossip

Timeline

Data Architect

Tata Consultancy Services
06.2023 - Current

Consultant Programmer (Data Warehousing Specialist)

Citi Bank NA
01.2019 - 06.2023

Analyst Programmer (Data Warehousing Specialist)

Citi Group
12.2013 - 12.2018

Trainee

TCS Internal
01.2013 - 04.2013

Bachelor of Technology - Electronics & Communication Engineering

West Bengal University of Technology

Training Conducted

  • 2015 UNIX Training TCS Associates Kolkata TCS
  • 2014 Ab Initio Basic Training TCS Associates Kolkata TCS
  • 2025 Generative AI with LLM certification USA AWS
  • 2025 Pyspark developer certification USA Databricks
  • 2024 AWS associate developer certification USA AWS
  • 2023 Generative AI with large language model USA Databricks
  • 2021 Continuous deployment USA TCS
  • 2014 Unix E2 Kolkata TCS
  • 2014 Ab Initio E1 Kolkata TCS
  • 2014 Data Warehouse Concept Kolkata TCS
  • 2013 Core Banking Solution Hyderabad TCS

Personal Details

  • Date of Birth: OCT 22, 1990
  • Sex: Male
  • Nationality: Indian
  • Marital Status: Married
  • Date of Joining: Jan 21, 2013
  • Designation: Associate Consultant
  • Location: Delaware, USA
  • Passport Details: passport number : V9374361
  • Issued at place on date : Washington DC, 18th Feb, 2022
  • Valid up to date : 17th Feb, 2032
  • Driving License license number : 2102130
  • Issued at place on date : 10th Oct, 2024
  • Valid up to date : 14th Apr, 2026

Publications

NA