Summary
Overview
Work History
Education
Skills
Languages
Timeline
SeniorSoftwareEngineer
Abraham I

Abraham I

Chennai

Summary

Experienced Senior Software Engineer at Epsilon specializing in Oracle SQL and PL/SQL, effectively employing database management tools to achieve project goals. Proven track record of collaborating within teams to ensure quality deliverables and efficient workflows. Dedicated to fostering innovation and enhancing software development methodologies.

Overview

8
8
years of professional experience

Work History

Senior Software Engineer

Epsilon
Bengaluru
08.2022 - Current
  • Optimized PL/SQL code to enhance performance of database applications.
  • Managed complex database structures, ensuring data integrity and accessibility.
  • Streamlined data retrieval through advanced indexing and query optimizations.
  • Collaborated with cross-functional teams to develop efficient database solutions.
  • Utilized Service Now for incident and change management to facilitate project execution.
  • Designed SQL batch processing for automated job execution, reducing reliance on traditional applications.
  • Oversaw scheduled jobs executing SQL scripts for data transformation and reporting.
  • Enhanced batch script performance by implementing robust error handling and logging.

Software Engineer

Boss Techno Solutions
Chennai
05.2017 - 07.2022
  • Coordinated with front-end UI developer team to deliver necessary insights on stored procedures and packages.
  • Created indexes on tables to enhance data retrieval speed and improve database performance.
  • Developed database objects including tables, views, materialized views, procedures, and packages using SQL Developer and TOAD.
  • Crafted complex queries utilizing subqueries, unions, intersects, and aliases for advanced data manipulation.
  • Designed records, tables, and collections to optimize query performance by minimizing context switching.
  • Implemented extensive exception handling to facilitate debugging and improve error message display in applications.
  • Demonstrated expertise in PL/SQL with proficiency in DML, DDL, stored procedures, views, triggers, cursors, sequences, and synonyms.

Education

B. TECH - Information Technology

Anna University
Chennai
05-2015

Skills

  • Oracle SQL and PL/SQL
  • Oracle 11g/12c/19c
  • UNIX shell scripting
  • Database management tools
  • Version control systems
  • Issue tracking software

Languages

Tamil
First Language
English
Upper Intermediate (B2)
B2

Timeline

Senior Software Engineer

Epsilon
08.2022 - Current

Software Engineer

Boss Techno Solutions
05.2017 - 07.2022

B. TECH - Information Technology

Anna University

Similar Profiles

CREATE PROFILE
Abraham I