Having 3+ years of IT experience as an ORACLE PL/SQL Developer
* *****’ experience on oracle HRMS Tech-functional consultant
Involved in Requirement Gathering, analysis, Design, Development, Unit Testing Production Deployment & Support.
Good experience in software industry in the analysis, design, development and implementation of full life cycle Data Migrations.
Expertise in SQL and PL/SQL programming, developing complex code units.
Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for
Retrieving, manipulating, checking and migrating complex data sets in Oracle.
Experience in data migration/conversation using SQL*Loader
Experience in Data migration using import and export
A good understanding of UNIX.
Having good experience on Client Interaction and Presentation Skills.
Can assist in developing and implementing new technologies.
Ability to work independently in a client facing role and having aptitude for learning new subjects and mastering them and strong team player.
Ability to build effective relationships with colleagues, regional tech teams
HRMS Modules > Oracle Human Resources (HR).
> Oracle Payroll,Oracle Self-Service Human Resources (SSHR).
>Oracle HRMS Intelligence (HRMSi),Oracle Learning Management.
>Oracle Time & Labor (OTL).
Working as Software Developer MAC suwaikh from mar 2018 to till date.
Worked as oracle developer jtc Kuwait from Nov2014-Dec2017
Worked as Oracle Tech-functional Consultant for ACC W.L.L Sep2011-oct2014
Windows 7/2000/ XP
SQL, PL/SQL, Java and UNIX.
SQL Developer, PL/SQL Developer, TOAD, SQL* Loader
Oracle Forms & reports : 6i/10g/11c
Good Experience in Interfaces and Conversions
Proficiency in writing stored Procedures, Reports and Forms.
Proficiency with D2K (Forms 6i, 10g, 11g & Reports).
Good knowledge on SQL * Loader.
Good knowledge on SQL * PLUS (9i and 10g).
Post Graduate: Currently doing M.sc IT from BHARATHIAR UNIVERSITY Coimbatore INDIA.
Bachelor Degree from Sri Venkateswara University Tiruathi A.P.India in the year 2000, passed with 70%.
Inter (MPC) from Sri Sv Junior college.Tirupathi A.P. India. In the year 1997 passed with 81.40%.
SSC from Brilliant High school in the year 1996 passed with 70%.
Roles & Responsibilities oracle developer
Understand the existing application, gathering new requirements, and business rules.
Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.
Developed various backend application programs, such as views, functions, Procedures, Packages using SQL and PL/SQL languages.
I prepared Unit test cases for Business purpose
Created Views on multiple Tables.
Performed unit level testing.
Worked on CRs assigned by onshore team.
Development of Code based on the approved Technical Specifications.
Migrated data from flat files to tables using SQL*loader.
Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
Developed Stored Procedures, Functions and Packages.
Created Views on multiple Tables.
Created indexes on some columns of tables to increase the application's performance.
Responsible for SQL tuning and optimization using explain plan and also responsible for writing test plans and unit testing for the application modules.
Analyzing tables and indexes for performance tuning.
Worked with Global Temporary Tables.
Date of Birth Marital Status Nationality Languages Known
: 16th June 1980
: English, Arabic, Hindi and Tamil
18 no Transferable visa/ Holding Kuwait Driving License
I hereby declare, that all the information provided above is absolutely true of my knowledge and belief.
PLACE : Kuwait (mohd ismail)