AREAS OF EXPERTISE

Oracle E-Business Suite modules

Oracle Forms and Report

PERSONAL SKILLS

Problem solving

Attention to detail

PERSONAL DETAILS

IBRAHIM S M

** *, **********

Tuticorin 628002

Tamil Nadu

India

Whatsapp +965-********

Mobile : 962-***-****

Em ail:

adjzku@r.postjobfree.com

DOB : 11.12.1992

Driving license: Yes Nationality: Indian

IBRAHIM S M

Oracle developer

PERSONAL SUMMARY

A bright, talented, ambitious and self-motivated Oracle developer with a strong technical background who possesses self-discipline and the ability to work with the minimum of supervision. Able to play a key role throughout the system development / support life cycle of a project to ensure that quality solutions meet business objectives. Possessing a good team spirit, deadline orientated and having the ability to produce detailed technical specifications from client requirements.

A quick learner who can absorb new ideas and can communicate clearly and effectively. Currently looking for a opportunity to join a dynamic, ambitious, growing company and forge a career as a first class Oracle developer.

WORK EXPERIENCE

ORACLE DEVELOPER in Kuwait Insurance Company

( June, 2018 - August, 2020 )

Duties :-

Having 2+ years of Total IT experience in Customizing, Designing, Developing, unit testing and enhanced functionality in Oracle like SQL, PL/SQL on Oracle 10g /11 Database as back end under Windows.

Excellent SQL Skills, Table Creation of Views, Materialized Views, Constraints, Sequences, SQL Functions, Indexes.

Strong Knowledge in DDL and DML operations.

Created Database Objects like tables, Views, Sequences, Synonyms, Stored Procedures.

Loading data from flat files into database tables using SQL*Loader and External Tables.

Extensive experience in writing SQL queries involving Joins, Sub Queries, SQL clauses, SQL conditions and Set Operators.

Extensive experience in writing Complex queries using Analytical Functions, advanced functions like nvl, nvl2, casein Oracles.

Creating PL/SQL Packages, Procedures, and Functions for data population and updating as per project requirements.

Designed and generated reports using REF cursors.

Experience in Performance tuning using Explain Plan, Hints, Indexing, Partition and Creation of global temporary tables.

Knowledge in PLSQL Records, Exception Handling concepts and Dynamics.

Communicated issues and progress to project manager.

Provided Production Support to clients’ databases.

Fixed different bugs and change requests from time to time.

Executed EXPLAIN PLAN for SQL query optimization and tuning.

Good experience of coordinating with various teams like Deployment

SKILLS AND COMPETENCIES

Operating Systems : WINDOWS XP,UNIX.

Databases: : Oracle10g / 11g.

Languages: : SQL, PL / SQL, C#.NET.

Job Scheduling: : Autosys

Tools: : SQL Developer, SQL*Developer, Toad.

using Joins, Sub Queries to retrieve data fro

ROLES AND RESPONSIBILITIES

Analysis of project and customer requirements.

Database designing and preparation of design documents

Requirement gathering from the Business Team

Involved in design of the database, which includes, table design and their relations

Written SQL Queries using Joins, Sub Queries to retrieve data from the database.

Involved in the development backend code, create, and altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements

Perform DML, DDL Operations as per the Business requirement.

Creating views and prepares the Business Reports.

Resolved production issues by modifying backend code as and when required.

Created new database objects like stored procedures, Functions, Triggers, Indexes, packages, Join in PL/SQL.

Created Database objects like Tables, Views, indexes using Oracle Tools like PL/SQL SQL *Plus.

Written SQL Loader to load the data from flat file into oracle database table.

Sever and BMS Engineer in M/s. L&T InfoTech, Tuticorin - India

( from November, 2016 to August, 2017 )

Duties :-

Responsible for maintaining the entire infrastructure of Electronic Data Processing system (EDP).

Generating HVAC reports and planning scheduled maintenance for air-conditioning systems including PAC outdoor fan ACs, Duct ACs and Split ACs.

Following up gen-set issues and coordinating with the vendor and coming up with a suitable maintenance to prevent occurring in the future.

Solely responsible for maintaining a proper security system which includes CCTVs, fire and rodent alarms (Honeywell panels) and water leakage sensors and calibrating the system regularly.

Maintain and schedule preventive maintenance of UPS, generators and electrical feeders and compiling it on PowerDB and LiteDB software.

Running facility management checks by interacting with the team members on automation systems and ability framing building maintenance system (BMS) on electrical substation with DG maintenance.

Active support to the production team with handling the route cards and checking fabrication and machining equipment and running maintenance checks.

ACADEMIC QUALIFICATIONS

Bachelor of Engineering (Mechanical)

Anna University 2010 - 2014

Contact this candidate