MUKESH. K ac6nu0@r.postjobfree.com

+91-894*******

Proficiency Forte:

Having 3 years of Progressive and Dynamic experience in Oracle SQL & PL/SQL development.

Having good experience in IT industry in broad range of functions & Involved in development project.

Worked in creating SQL objects like Tables, Views, Sequence, Synonyms and indexes.

Having better understanding in Joins, Sub Query and Constraints.

Having good knowledge in SQL Functions and Group functions.

Created Sequence, Synonyms, Indexes and Views.

Having basic Knowledge in SQL Loader to upload the information into the database and using UTL_FILE packages write data to files.

Worked in SQL Statements like DDL, DML and TCL.

Basic knowledge in DCL.

Used Pseudo columns, Analytical functions.

Created and worked with Stored Procedures, Stored Functions & Packages.

Used cursor and Exception handling while writing the Stored Procedure.

Having better understanding in PL/SQL advanced concepts like Collections, Bulk collect & Ref cursor .

Having better understanding in Trigger.

Expertise in using tools such as SQL Developer, SQL*Plus.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Professional Synopsis:

Presently working as a Software Engineer in Geniune IT solution from

Aug 2015 to present date.

Technical Summary:

Project Domain : Telecom.

Primary skills : Oracle 11g (SQL & PL/SQL).

Database Version : Oracle 10g/11g.

Development Tools : Oracle SQL Developer, SQL*PLUS.

Operating System : Windows & Basic Unix.

Title : XLN communication, Duration: Jan 16 to till date.

UK - Telecom OSS.

Role : PL/SQL Developer.

Description:

This project is designed and developed for Telecom Company called XLN Telecom Ltd located in London. Which is a telephony and broad band internet service provider and this project is in the production. 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. I am currently working in Operational Support System here customer care maintain all the details about customers and their records.

Roles & Responsibility:

Analysis and designing Database as per the user requirements.

Wrote complex queries to do analysis work and generate reports to validate the results produced.

Wrote stored procedures for user requests Performed Capacity planning, Forecasting, Database design analysis and design.

Writing complex Stored Procedures, Functions, Packages, Triggers and views.

Developed, implemented and monitored data load procedures.

Used SQL Loader to load data into the tables.

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

Developed user documentation for modules also responsible testing of applications.

Environment: Oracle 10g, SQL*PLUS, SQL Developer.

Academic Details:

•Completed B.E -Mechanical Engineering from Muthayammal Engineering College in Rasipuram(2015) with 7.7 CGPA.

•Completed 12th in MAM.Hr.Sec.School,Mettur with 84.4%.

•Completed 10th in Govt.Boys.Hr.Sec.School,Jalakandapuram With 85%.

DECLARATION

I do hereby declare that the particulars of information and facts stated herein above are true, correct and complete to the best of my knowledge and belief.

(Mukesh kandan sevi)

Contact this candidate