Summary
Overview
Work History
Education
Skills
Languages
Accomplishments
Timeline
Generic

Yogaraj M

chennai

Summary

6 years of experience in Oracle database, SQL, PL/SQL, involving database design, application development, implementation, quality testing, statistical analysis, and support. Develop and maintain PL/SQL procedures, functions, triggers, and packages to support database applications and business requirements. Experience in developing and testing PL/SQL stored procedures, packages, and triggers. Created database objects like tables, views, synonyms, and indexes.

Extensively wrote SQL queries (subseries, correlated subqueries, and join conditions). Involved in designing and developing reports. Involved in integrated reporting capability. Knowledge of Oracle 11g, 12c, and 19c database architecture. Expert in handling multiple projects. Strong understanding of IT project management terms.

Presentation and facilitation.

Overview

7
7
years of professional experience

Work History

IT Analyst

TCS
Chennai
02.2023 - Current
  • Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
  • Reviewed project requirements to identify customer expectations and resources needed to meet goals.
  • Developed and maintained PL/SQL scripts for data retrieval and manipulation.
  • Optimized existing queries to enhance performance and reduce execution time.
  • Created documentation for processes, procedures, and system changes related to PL/SQL development.
  • Created scripts to automate daily tasks such as backup jobs and scheduled jobs.
  • Experience in PL/SQL programming in Oracle 9i.
  • Performed debugging of existing PLSQL code as part of bug fixing activities.
  • Developed stored procedures, functions and packages using PLSQL to support the application development needs.
  • Optimized SQL queries for better performance by analyzing execution plans and query optimization techniques.

Lead Engineer

HCL Tech
Chennai
07.2019 - 01.2023
  • Coordinated with the front-end design team to provide them with the necessary stored procedures, packages, and insight into the data.
  • Created database objects such as tables, views, synonyms, indexes, and sequences. Created database objects: Tables, Views, Indexes, Sequences, Synonyms, procedures, and packages.
  • Created the PL/SQL packages, procedures, and functions.
  • Created and managed database objects such as tables, views, indexes, sequences, synonyms, procedures, and packages.
  • Created the PL/SQL packages, procedures, and functions, applying the business logic to load the data to relevant tables.
  • Extensively worked on cursors, ref cursors, nested conditional statements, co-related sub-queries, and DB links.
  • Tuning the PL/SQL procedures and packages, and modifying the code accordingly to improve performance.

Systems Engineer

thirty two health care pvt ltd
Chennai
06.2018 - 06.2019
  • Trained team members on system operations, maintenance, and troubleshooting procedures.
  • Generated technical reports for customers.
  • Maintain all clinical data from the moc-doc.

Education

Bachelor of Engineering - Computer Science

Shri Sapthagiri Institution of Technology
Ocheri
05-2018

Skills

  • Performance tuning
  • Triggers and functions
  • Partitioning and indexing
  • Error handling and debugging
  • SQL query optimization
  • Query optimization
  • Query execution plans
  • Stored procedures
  • Complex query design
  • Business requirements analysis

Languages

Tamil
First Language
English
Intermediate (B1)
B1

Accomplishments

  • I received the Best Performance Award twice in 2024
  • Client side, I got appreciation

Timeline

IT Analyst

TCS
02.2023 - Current

Lead Engineer

HCL Tech
07.2019 - 01.2023

Systems Engineer

thirty two health care pvt ltd
06.2018 - 06.2019

Bachelor of Engineering - Computer Science

Shri Sapthagiri Institution of Technology
Yogaraj M