Summary
Overview
Work History
Education
Skills
Skills Inventory
Personal Information
Disclaimer
Technical Summary
Timeline
SeniorSoftwareEngineer

R RAJASEKAR

Senior Software Engineer
Kundrathur

Summary

Having overall Nearly 9 + years of programming experience in Oracle PLSQL Development, Pro C and Unix environment. Also having experience Talend ETL components.

Overview

10
10
years of professional experience
2013
2013
years of post-secondary education

Work History

Senior Software Engineer

Renault Nissan
05.2021 - Current
  • Sales and Distribution Working on the Parts order processing having three sets of module RPS, PNE and Rparts. RPS is full of Renault car parts order processing. PNE is for wheel order process application. To order a wheel alone with different manufacturers will use this particular part of application along with most of batches will be at Pro c batches.
  • Analysing and Developed for Manipulating for database based on requirements using of talend tool components.
  • Developed the Proc programs and analysis pgms and functions based on the requirements needs.
  • Analysing a pro c programs any issue came, having experience support Tool of Chipre to resolving the support related issues.
  • Created database tables and procedures and function for the code requires.
  • Devloped the PS, UTP, Code Review documents after Completing the code based on the requirement.
  • Tested the code in UT As well as in UAT, After the code was completed.

Associate Consultant

CITIBANK-INDIA
10.2016 - 03.2021
  • Citi Bank -India (ABF) - Assests based finance, it is the loan based module used to booking and maintain the loan details of Citibank Customers. It will be maintain with two set of database Gilscfil and Gilsgcib. Booking loan details will be through by the CDL(City dealer Application) will be maintained in Gilsgcib, And booking loan individually then it will maintained in Gills Database. In backend it will loaded into database and the further loan maintain proecess will be worked on. Currently working on the enhancement project of adding aadhaar and guarantor details of the customers.
  • GST: Worked for the GST enhancement through the same Asset domain. Which was launched by the Indian govt, migrated from exiting tax system to new tax system CGST, IGST, SGST.
  • Developed the Proc programs, multiple functions based on the requirements needs.
  • Devloped the Napt Based programs, it is the tool used as a front screen to view the customer details.
  • Created database tables and procedures and function for the code requires.
  • Devloped the PS, UTP, Code Review documents after Completing the code based on the requirement.
  • Tested the code in UT As well as in UAT, After the code was completed.

PLSQL Developer/Software Engineer

Consumer Activation
09.2015 - 09.2016
  • Consumer Activation Harness the collective power of consumer segmentation, demographics, lifestyle and behavioral insights for better marketing planning, consumer acquisition, cross selling and retention programs. Segmentation can be used beyond your internal departments to empower your advertising agency, media buyers, direct mail house, research providers and franchisees.
  • Developing program specification based on Functional specifications.
  • Developed PL/SQL Packages, procedures, functions, ensure integrity of loaded data, based on pre-defined Requirements.
  • Created database tables and indexes.
  • Creating the shell Scripting for the subprograms, depends upon the requirement and worked on the limited unixcmds.
  • Developing user documentation and process flow of the profile if Requires.

Education

Bachelor of Engineering -

S.K.R Engineering College
Poonamallee, Chennai

Skills

SQL

Skills Inventory

  • SQL, PLSQL, Unix, Pro
  • C, Talend, Oracle 11g, SQL
  • Plus, SQL Developer, PL/SQL Developer, Notepad ++, Talend ETL Tool

Personal Information

  • Date of Birth: 02/22/92
  • Marital Status: Single

Disclaimer

I hereby declare that the information furnished above is true to the best of my knowledge. I consider myself familiar with these aspects. I am also confident of my ability to work in a team.

Technical Summary

  • Created Schema objects like Tables, Constraints, Views, Indexes, Sequences, Synonyms.
  • Experience includes in Cursors, Ref Cursors, Anonymous blocks, Triggers.
  • Strong Experience in SQL & PL/SQL (Procedures, Functions and Packages etc.)
  • Effectively made use of Table Partitioning, Analytical functions, External and Query Re-write.
  • Loaded Data into Oracle Database Tables using SQL
  • Loader.
  • Experience in Collections, Dynamic SQL and Materialized Views.
  • Knowledge in Report generation using UTL.
  • Experience in Unix cmds and Shell scripting.
  • Have working Experience in Pro C language as a Developer.
  • Developed the Proc programs with multiple functions, created a napt based tool based on the requirements needs.
  • Worked extensively Exception handling, knowledge in SDLC.
  • Expertise in using tools such as Sql
  • Plus, PLSQL Developer and SQL Developer.
  • Having Knowledge experience in Talend Tool. Analyzing and Developed for Manipulating for database based on requirements using of components.
  • Creating New Talend Jobs, Analyzing the issue and Increasing of performance of Jobs By query tunings using of PGsql.
  • Worked Through of AWS to GCP migration pipeline platforms, Upstream and downstream from GCP Buckets.

Timeline

Senior Software Engineer

Renault Nissan
05.2021 - Current

Associate Consultant

CITIBANK-INDIA
10.2016 - 03.2021

PLSQL Developer/Software Engineer

Consumer Activation
09.2015 - 09.2016

Bachelor of Engineering -

S.K.R Engineering College
R RAJASEKARSenior Software Engineer