RAJMOHAN SELVARASU

Mobile: +91-848*******

Email: ac6m6j@r.postjobfree.com

Professional profile:

Having 3.6 years of relevant experience in Oracle SQL, PL/SQL development.

Strong working knowledge of SQL and PL/SQL best practices.

Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.

Good exposure in Constraints, Joins and sub queries.

Having good exposure on SQL LOADER.

Good experience in developing Stored Procedures, Functions, Triggers, views, Cursors, Packages.

Good exposure on Exception handling as well.

Good Exposure on Bulk collections and Bulk Binding.

Having Basic knowledge in UNIX.

Technical Summary:

OPERATING SYSTEM : Windows, UNIX.

LANGUAGES : SQL, PL/SQL, Basic of Unix.

RDBMS : ORACLE-10g/11g.

TOOLS : PLSQL DEVELOPER, SQL DEVELOPER,SQL PLUS,TOAD.

Work experience:

Working as a Software Engineer in Thincle Soft Technologies, Chennai from (JANUARY-2015 to till date).

Professional Experience:

Project Name : Freight Forward Tracker.

Duration : Jan 2017 to May 2018.

Client : Emarat Maritime, Dubai.

Description:

This project is designed and developed for Shipping Company Maritime based in Dubai. It is a leading carrier in gulf region for providing containerized transportation across the world and this project is in the production. Main purpose of this project is to providing service package information’s such as fetching routing, no routing, non-serviceable, port to port freight rate including surcharge components for tenders. It helps Trade management unit to quote easily competitive freight rates for tenders in order to acquire large businesses.

Roles and Responsibilities:

Created Database Objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursors and Ref Cursor.

Analysis and designing Database as per the client requirements.

Wrote PL/SQL and Oracle reports to support upper management requests.

Documented the Software Requirement Specifications.

Understanding the requirements and carrying out impact analysis.

Involved in modifying various existing procedures and functions according to the new business needs.

Performed exception handling for data that did not conform to the required format.

Developed other database objects such as indexes and views when needed.

Interacted with onsite coordinator/clients for requirement gathering and effective analysis.

Project Name : UK - Telecom OS

Duration : Oct 2015 to Dec 2016.

Client : Entanet.

Description:

This project is designed and developed for Telecom Company. It provides telephonic and broadband services. Purpose of this application is to support their Employees for their Day to day Release, Delivery Order processing requirements, Customer Payment Details. We are using two modules one is OSS and another one is BSS. Here OSS to analyze which service providers suitable for their customer locations.

Responsibilities:

Collected User Requirements by participating in meetings and studying existing System

Created database objects like tables, views, Sequences, Synonyms, stored procedures, function, packages, Cursor.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Implementing the report logic using Stored Procedures and functions in Oracle.

Personal Details

Father Name : A. SELVARASU.

Marital Status : Single.

Date of Birth : 25-03-1990.

Passport Number : K1660296(Date of expiry 28/10/2022).

Languages known : English, Tamil.

Education Profile

B.E (Computer Science and Engineering) 2012, Srinivasan Engineering College, Perambalur.

Date : RAJMOHAN SELVARASU

Place :

Contact this candidate