RESUME
Ilayaraja V
E-mail:*************@******.***
Mobile: +91-967*******
Carrier Objective:
To obtain a challenging position to utilize my skills and abilities by taking up new
responsibilities and work dedicatedly for upheaval of the organization and myself.
Summary:
2 year of experience in SQL development.
Back up for DBA.(Learning MS SQL Server DBA Activities).
Knowledge in Database administration activities like database creation, maintenance,
space management, management of log file & data files, taking database backups and
restoring.
Currently generating Analytics Reports for Airtel to all over India.
Good Knowledge in Mathematics.
Strong in SQL Statements,Transact SQL,Stored Procedure,Function and Trigger.
Good Knowledge in Telecom Domain.
Ability to learn quickly and easily adopt new environment.
Interpersonal Skills with the ability to work as an individual and as a team player.
Academic Performance:
B.E in Computer Science Engineering (2007 – 2011) with 74.8%
Sengunthar Engineering College, Tiruchengode, Namakkal(DT).
Completed 12th Standard (2007) with 66.5% From Govt Hr Sec School,
Karapattu,Krishnagiri(DT).
Completed 10th Standard (2005) with 65% From Govt Hr Sec School,
Karapattu,Krishnagiri(DT).
Technical Exposure:
Languages : SQL, PL/SQL,JAVA
Databases : MS SQL server2008
Experience:
Working as SQL Developer with FIRSTSOURCE SOLUTIONS Ltd - Chennai,
July 2011 to till date.
Current Role:
Get training for SQL DBA For last 5 months
Designing and maintaining projects databases using MS SQL Server; ensured
accuracy of information and automated numerous functions.
Maintaining Overall Telecom Base and Generating critical Reports.
Analyzing the modules & designing.
Generating Dashboards through Excel files.
Projects:
Client : Bharti Airtel Ltd, Pan India
Role : SQL Developer
Environment : SQL Server 2008
Aim:
Mobile Number Portability.
The responsibilities of customers requests for hour wise.
•
MNP Intender dashboard.
To find the overall count of request port in/port out .
•
MNP User dashboard
To display the successive count of port in/port out.
•
MNP Rejection Audit.
To check the proper functioning of port out. If any error the data count will be sent.
•
E bill CWN-MO & FL.
It checks how the bill is sent to customer. Either in email or in CD is preferable.
•
CTA Calling.
If customer bill is generated it identifies the due date and the amount.
•
E bill Penetration MO & FL.
To find the bill for platinum solitary customer and if it is to be sent in email the count
•
will be added.
E mail User Penetration MO & FL.
It checks whether the platinum solitary has an email id or not.
•
Executive Summary.
The overall performance and status for postpaid & Fixed line customers.
•
Start Stop Paper.
It provides bill if started after validating the user and stops the service if needed.
•
BNRVSCSV.
To check whether bill is generated or not. If any queries user can post their requirements
•
here in the dump.
Responsibilities:
Developing Query and stored procedure.
Query tuning for high performance.
Personal profile:
Father’s Name : Mr.J.Vedi
Date of Birth : 01-May-1990
Sex : Male
Nationality : India
Linguistic Proficiency : Tamil & English
Current Address : No-4/25 Rathinam Garden,
V.G.P Salai,West Saidapet,
Chennai-600017.
Declaration:
I hereby declare that the information furnished above is true to the best of my
knowledge.
Place:
Date: (Ilayaraja V)