Immediate Joiner - Oracle SQL/PLSQL Developer

Ahmed Hussain Mobile: +91-909*******

Email:*****.**************@*****.***

Career Objective:

Seeking to make a long-term contribution to the organization as an Oracle Developer by continuously upgrading the latest technology and effectively using the available resources Professional Summary:

Having 5+ years experience with Oracle SQL and PLSQL Development with ETL process.

Having experience as an Oracle PL/SQL Development Using the Oracle Relational Database Management System (RDBMS).

Expertise in Client-Server application development using Oracle PL/SQL, SQL*PLUS, TOAD.

Excellent skills in Functions, Stored Procedures and Packages.

Experience in using Ref Cursor, Bulk collect, Pragma Autonomous Transaction, PL/SQL Collections.

Experience in Oracle creating packages, Records and PL/SQL Tables.

Creation/modification of schema objects like Packages, Procedures, Functions, Triggers, and Sequences.

Strong Proficient in SQL and creation/modification of database objects like Group Functions, Single Row Functions, Views, Index.

Automated Informatica processes to update status tables after running maps successfully

Familiar with writing Joins, Sub queries, Single row functions, Collections and Exception Handling.

Experience in SQL Query Optimization, Performance Tuning, Execution Plan Analysis, AWR Report Analysis and Index Management to improve database performance.

Data Migration using SQL*Loader and TOAD Utility.

Experience of Source Control Tools such as Bit bucket and GIT

Monitor and adjust end-to-end Informatica workflows to enhance productivity.

Familiar with Oracle Database JSON functionalities such as JSON_TABLE, JSON_OBJECT and JSON_EXISTS for JSON data processing and transformation. Technical Expertise:

Programming Language : Oracle SQL, PLSQL, Unix and Shell scripting PL/SQL Database : Oracle 9i, 10G,11G, 12c, 19c (Knowledge) Version Control : Git, Bitbucket

Tools : SQL*Plus, SQL Developer,

TOAD, Jira, Visio, Microsoft Excel, Notepad++, Control-M Professional Experience:

Worked in Socommerz Technologies Pvt Ltd at Gurugram from 07.10.2024 to 30.05.2026

Worked in Synechron Technologies Pvt Ltd at Bangalore from 12.07.2023 to 30.09.2024

Worked in Larsen and Turbo Info tech at Chennai from 22.10.2020 to 11.02.2023.

Worked in Hapag Lloyd Global Services at Chennai from 31.10.2016 to 29.02.2020. Education Qualification:

B.E(ECE) 2015 -Jaya Suriya Engineering College, Chennai. Professional Experience:

1. Client : Wells Fargo

Role : Senior software engineer

Technology : SaaS, Oracle 12c

Description:

Wells Fargo works to create positive social impact in the communities it serves by supporting housing affordability, small business growth, financial health, and a low-carbon economy.

Roles and Responsibilities:

Preparing Visio flowchart diagram and completion the task in Jira dashboard.

Prepared design and layout with all scenarios and expected results for each of the requirements through excel

Interacted with Business Analysts and developers participated in user requirement sessions to analyze and gather business requirements

Experienced in developing and optimizing complex PL/SQL Packages, Procedures, Functions, and Triggers in Oracle environments.

Experience in developing Shell scripts for database automation and batch processing; basic knowledge of Python scripting.

2. Client : Al Madina Group

Role : Software engineer

Technology : Oracle 11g, 12c

Description:

Orion is one of the ERP Process in Middle East & Africa, Orion involves the process of Enterprise Resource Planning (ERP) Manufacturing retail & Distribution, does both purchase order and sales order

Roles and Responsibilities:

By updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Performed SQL query tuning, execution plan analysis and AWR report analysis to identify and resolve performance bottlenecks.

Identifying and fixing bugs. Data correction based on requirement.

Hands-on experience in advanced SQL performance tuning, query optimization, indexing, partitioning concepts, execution plan analysis, and AWR reports.

Experience in supporting database deployments, production releases, migrations, troubleshooting, and technical documentation.

3. Client : Equifax.

Role : Software engineer.

Technology : Oracle 11g, unix, shell script

Description:

The system has centralized database to maintain all relevant information regarding Credit Information. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries.

Roles and Responsibilities:

Interact with clients to gather requirements for enhancements, design and develop code changes.

Developed enhancements and fixes for existing applications as per the business requests.

Involved in overall system testing which includes Functional testing, Integration testing.

Performed data manipulations using various informatica transformations like filter, expression, lookup, Normalizer, joiner, router, union and sorter.

Created DB objects such as Procedure, Functions, Packages, Triggers, Sequences, Views and Indexes.

Collaborated with application teams to resolve production performance issues.

Worked on database deployments, release support, and issue troubleshooting.

Optimized complex PL/SQL code and SQL queries to improve application performance.

Involved in oracle packages, Bulk collects, PL/SQL collections, Materialized views, Ref cursor and Dynamic SQL.

4. Client : Elevance Health

Role : Jr Software engineer

Technology : Oracle 10g, 11g, SQL*PLUS

Description:

This system is designed to allow users to create and submit invoices for billing, apply payments to charge, and manage patient accounts. To ensure that Pharma Care has accurate billing and accounts receivable records, SPARCS works in conjunction with HBS, the system used to create and fill orders. Roles and Responsibilities:

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Created and modified SQL*Loader scripts for data conversions.

Created procedures for Feed generation based upon partner request.

Handled error using Exception Handling extensively for the case of debugging and display the error message in the Application.

Created impact analysis documents for Prod/UAT issues and detailed design document for development.

Familiar with Control-M job scheduling and monitoring batch processes. Declaration:

I confirm that the information furnished above is true authentic to the best of my knowledge. Ahmed Hussain

Contact this candidate