Kalaiarasan Rajendran

CLIENT NAME: CITI BANK

Duration: Sep 2022 – Till date

CITI Divestiture Data Management – CITI Bank

Role: Oracle PL/SQL Developer / Production Support

Roles & Responsibilities

Worked in Divestiture project for migration of 13 countries to Buyer Bank.

Designed and developed the data transition model to be adopted.

Developed and modified packages, functions, and stored procedures for data conversions.

Developed materialized views for data replication in distributed environments.

Wrote SQL and PL/SQL programs required to retrieve data.

Created indexes on tables to improve performance by eliminating full table scans.

Created views for hiding actual tables and reducing complexity of large queries.

Worked in rotational shifts and handled L2 & L3 production support activities.

Developed complex database objects like Stored Procedures, Functions, and Packages using SQL and PL/SQL.

June 2018 – August 2022

Analyzed and converted business requirements into technical requirements, followed by designing and implementing solutions.

Involved in resolving production problems for applications, and ensured support SLAs were met.

Participated in the complete software development lifecycle, including planning, analysis, design, development, testing, and implementation.

Coordinated with front-end teams to provide required stored procedures, packages, and data insights.

Designed and implemented T-SQL queries for reporting and complex solution development.

Created optimal technical solutions to user needs through in-depth system analysis.

CLIENT NAME: City Super

Duration: June 2020 – Aug 2022

Designed and implemented extract, transformation, and load processes, programs, and scripts.

Worked on SQL*Loader to load data from flat files obtained from various facilities daily.

Gathered requirements from Business Analysts and cross-functional teams for application enhancements.

Used bulk collections for better performance and easy retrieval of data by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL stored procedures, functions, and packages for moving data from the staging area to the data mart.

Created records, tables, and collections (nested tables and arrays) for improving query performance.

-

CLIENT NAME: AIG United Guaranty Insurance.

Duration: August 2018 – May 2020

Developed stored procedures, functions, database triggers, and packages to access databases from front-end screens.

Wrote SQL, PL/SQL, and SQL*Plus programs using cursors and exception handling.

Participated in planning, analysis, design, development, testing, and implementation activities.