Software Development Engineer

SOORIYA.V

South Street, Nattuchalai

E-mail: *******.*.**@*****.***

Phone: +91-971*******

CAREER SUMMARY

* ***** ** ********** ** SQL, PL/SQL design, development, and support. Resolved various customer queries.

Involved in all phases of the SDLC (Software Development Life Cycle) including analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.

Proficient in understanding overall system functionalities and deploying data into system databases effectively using SQL and PL/SQL.

Strong knowledge of Procedures, Functions, Sequences, Views, Synonyms, Triggers, Packages, and Exception Handling using PL/SQL.

Expertise in debugging queries and performance tuning.

Extensive experience with Ref cursors, Bulk Collect, Collections, and Dynamic SQL.

Familiarity with PL/SQL Tables, Packages, and Pragma Autonomous Transactions.

Basic knowledge of UNIX commands and working with PL/SQL collections.

Skilled in creating DDL, DML, analytical functions, virtual columns, indexes, subqueries, joins, group functions.

Experience in developing Views, Materialized views, External Tables, Indexes and sequences

Bulk Binds, Bulk Collect, Creation of global temporary tables

Exposure in using Analytical Functions, Exception handling, SQLLoader

TECHNICAL SKILLS

Databases: Oracle 10g, 11g (SQL & PL/SQL)

Database Tools: Toad

Operating Systems: Windows 2003/XP/7/8/10

EMPLOYMENT DETAILS

ProV Infotech, Chennai – Software Engineer (September 2018 - April 2020)

ArisGlobal – Associate Consultant (May 2020 - May 2021)

IBM India Pvt Ltd – PL/SQL Developer (May 2021 - May 2022)

Capgemini – Associate Consultant (May 2022 - Present)

PROJECT DETAILS

Project #1

Company: ProV Infotech Systems

Title: IFS Managed Services (Development and Support)

Duration: September 2018 - April 2020

Domain: Industrial and Finance

Environment: Oracle PL/SQL, SQL, IFS Apps9 Technology, IFS Standardized C# Technology

Responsibilities:

Created entities consisting of keys and attributes related to parent and foreign keys.

Designed enumerations and constraints as flags for attributes and developed state diagrams for workflow.

Created utilities for DML operations with public, private, and protected access specifiers.

Overrode default utilities to implement custom procedures, functions, and cursors, incorporating sequences for various entities.

Created and customized forms in Visual Studio and connected them with entity attributes using Dataset toolbox.

Monitored database servers and performed backups/restorations using Data Pump and offline backups.

Supported tickets (L1, L2, L3) using ServiceNow, ensuring SLA adherence.

Worked with functional flows like procurement, sales, and invoices.

Project #2

Company: Aris Global Solutions Pvt Ltd

Title: LSSRM

Duration: May 2020 - May 2021

Domain: Pharma

Environment: Oracle PL/SQL, SQL

Responsibilities:

Analyzed and resolved cases using Oracle PL/SQL.

Managed schema attachment and decommissioning processes.

Conducted database upgrade activities and created SRF/RFC documents for SOP.

Handled tickets in JIRA while maintaining SLA.

Dealing with Various Workflows case studies and applying SQL concepts over there

Execution of IQS for Various functions

Handling and administering the functional flow of the customer schema

Project #3

Company: IBM India Pvt Ltd

Title: RED

Duration: May 2021 - May 2022

Domain: Logistics

Environment: Oracle PL/SQL, SQL

Responsibilities:

Analysing and Resolving the cases assigned to me with help of Oracle PLSQL

Understanding the business scope and applications for development

oUnderstanding the incidents and solving it in given time

oMaintaining the SLA and company’s productivity

Using various PLSQL skills in development of application products

oCreated various procedures,functions,packages,triggers etc

oUsed cursors,collections,exception handlings to maintain data

oUsed various sql concepts in developing queries

oInvolved in Debugging Querries and Perfomance tuning etc

Project #4

Company: Capgemini

Title: Imperial Brands

Duration: June 2023 - Dec 2023

Domain: JDA Demand

Environment: Oracle PL/SQL, SQL

Responsibilities:

Provided technical support for JDA Demand.

Created and modified PL/SQL procedures and functions to meet business needs.

Worked on bulk data collection and binding processes.

Project #5

Title: Boeing

Duration: July 2024 - Nov 2024

Domain: Spare Part Management (SPM)

Responsibilities:

Gained knowledge in spare part management, including demand creation and inventory optimization.

Created and modified SQL queries using PL/SQL procedures and functions.

DECLARATION

I hereby declare that the above information is true to the best of my knowledge.

(SOORIYA.V)

Contact this candidate