Resume

Sign in

Operator Sql

Location:
Maharashtra, India
Salary:
400000/-PA
Posted:
October 12, 2016

Contact this candidate

Kapil Rajput

Email: acw0s1@r.postjobfree.com

Address: SR NO 131/1, RAJYOG SOCIETY,

NEAR GANESH MANDIR

Warje, Pune-411058.

Mobile no: +91-901-***-****

+91-973-***-****

LinkedIn Link: https://www.linkedin.com/profile/view?id=358686673&trk=nav_responsive_tab_profile

Career Objective

Willing to work as a team player in challenging and creative environment to prove my skills and abilities by being innovative and to be a cause for the best results to enhance the knowlesgeous qualities with growth in the organization.

Academic Details

Degree /Course

Institute

University / Board

Year of Passing

Percentage

B.E. (I.T)

SSBT’S College Of Engineering And Technology,Jalgaon

NMU

2013-14

57.6%

Diploma(I.T)

H.S.C.

Smt. Sharchandrika Suresh Patil institute of tech, Chopda

ASC college, Chopda.

Dist-Jalgaon

MSBTE

Nasik

2009-10

2005-06

65.00%

57.33%

S.S.C.

Pratap Vidya Mandir, Chopda. Dist-Jalgaon

Nasik

2003-04

52.40%

Technical Skills

Languages : C, C++

Technology : UNIX, SQL, PL- SQL, Oracle, BMC Remedy.

OS : windows 8/7/Vista/XP, Unix/Linux

Tools : MS Office

Key skills : DDL, DML, DQL commands, Queries, Sub queries, Triggers,

Procedure.

Work experience :

Name of the company

Designation

Duration from

Duration To

Web Development Company Pvt. Ltd. deputed to client IBM India Pvt. Ltd

Trainee - Database Administrator

16th Feb 2015

Till date

Project Details

Project Name : Vodafone Essar Ltd for supporting NPG Application

Duration : From 16th Feb

Primary roles : Trainee - Database Administrator

Technologies : Oracle-, SQL, UNIX, NPG, PL-SQL

Project description:

MNP (Mobile Number Portability) is related to the routing of calls or mobile messages (SMS, MMS) to a number once it has been ported. There are various flavors of call routing implementation across the globe. Network operator makes copies of CDB and queries it to find out which network to send a call to. This is also known as All Call Query (ACQ) and is highly efficient and scalable.

Service providers and carriers who route messages and voice calls to MNP-enabled countries might use HLR query services to find out the correct network of a mobile phone number.

Roles & responsibilities:

Analysis and documentation of in MNP Port In / Port out request and other flows which can

Be handled through NPG.

Developed daily reports to find out the pending Port In / Port out request from Vodafone as

Recipient and as donor operator.

Reconciliation of discrepancy cases and rejected Vodafone as Donor and Recipient operator.

Develop and review artifacts (code, documents and unit test scripts) and conduct self and

Peer reviews developing the SQL Queries for generating the reports based on clients

Requirement.

Resolving the tickets on the BMC remedy tool for different kind of issues

Checking the logs in the Application servers.

Training and Certifications

Completed C# and Asp.net course from Itpreneuer technology, pune.

Completed Sql, Pl-Sql course from Itpreneuer technology, pune.

Extra-Curricular Activities

Participate in Latex report workshop in Engineering.

Two times state level volley ball runner up.

Personal Profile

Name : Kapil Rajput

Father’s Name : Jayantilal Rajput

Date of Birth : 9th Nov 1988

Gender : Male

Marital status : single

Nationality : Indian

Languages Known : English, Hindi, and Marathi.

Hobbies : Playing Volleyball, Listening music, debating on current political issues.

Permanent Address : C/O Jayantilal Rajput, Near Shitalnath math, Gujarali, Tal-Chopda,

Dist. Jalgaon-425107

Contact Number - +91-901-***-****

+91-973-***-****

Email ID - acw0s1@r.postjobfree.com

Declaration

I, hereby affirm that the above mentioned information furnished by me is correct to the best of my Knowledge.

Place: Pune

Date: Kapil J. Rajput



Contact this candidate