MUGUNTHAN PAULRAYAN

DUBAI ,UNITED ARAN EMITAES

Summary

Proactive and driven individual 3 years of experience in Oracle SQL and PL/SQL development, specializing in stored procedures, functions, triggers, packages, and performance tuning. Proficient in REST API integration and skilled in requirement gathering, SDLC phases, and client interaction. Experienced in unit testing and defect resolution using Jira and Git.

Overview

years of professional experience

years of post-secondary education

Work history

Junior Associate

KGISL Technologies Pvt Ltd

Coimbatore , India

02.2022 - 03.2025

Designed and optimized complex SQL queries, joins, views, and indexes to improve system performance.
Implemented triggers and constraints to maintain data integrity and enforce business rules.
Developed performance-tuned PL/SQL scripts for large-scale data migration, transformation, and loading (ETL).
Worked with bulk collect, FORALL, and dynamic SQL to handle high-volume data efficiently
Coordinated with QA teams to prepare test cases and test data for validating stored procedures.
Supported version control and release management of database objects.
Experienced with SQL Developer, Golden Benthic and Oracle Forms & Reports for development and monitoring.
Applied Agile methodologies for sprint-based deliveries
Used Git for version control of PL/SQL codebase

Education

Bachelor of Technology - Information Technology

Anna University

India

08.2017 - 05.2021

Skills

Programming Languages : Oracle PL/SQL, SQL
Database Tools : SQL Developer, Golden Benthic, PL Edit

Databases : Oracle 10g, 11g, 12c (SQL & PL/SQL), D2K (Forms & Reports 6i, 10g, 11g, 12c)

Accomplishments

Project: NSURE

Clients: MCIS, HNB, NGI, SALAMA, LOLC, CAMLIFE

Technologies: Oracle PL/SQL, SQL, Oracle Forms (11g, 12c)

Timeline