Sql Server Management
Resume:
TIJO THOMAS Mobile: +91-953*******
E-mail:
**************@*****.**.**
Career Objective
To accomplish a challenging career in the corporate world where I can
prove my skills and
Strengths, which also provides me an ample career growth along with the
growth of the
Organization
Summary of Experience
1. 1 year and 6 months of experience in MS SQL Server 2005.
2. Worked on an onsite project at Medanta Hospital for a period of three
month.
3. Strong knowledge/skills in SQL Server.
. Worked on multiple projects with different teams
Skill Set
Operating Systems : Windows 98/2000/NT, XP,Vista,Windows 7.
Programming Languages : ASP.Net, C#, C, C++
Databases : SQL Server 2000/2005/2008.
Certification
Completed a course in MS SQL Server 2005 administration from Silicon
India
.
Scholastic Records
> M.C.A from Bangalore University June 2009
> Bachelor Of Electronics & Physics from M.G UNIVERSITY
> Pre-University BOARD OF SECONDARY EDUCATION, KERALA
> SSLC from BOARD OF SECONDARY EDUCATION, KERALA
Working Experience
Professional Experience:
Working as a Software Engineer with Techsmith Software Systems from
7th September 2009 to till date.
Role : MS SQL DBA
Responsibilities:
SQL Server 2005 Admin, Taking backups, Restore etc.
SQL server Installation and Up gradation.
Implementing the solution at customer sites (partial/complete).
Responsible for troubleshooting problems that are raised by the
customers from the Database side.
Responsible for handling the Change Requests as raised by the
clients
Responsible for leading a team of support engineers for product
implementation and support at customer sites.
Generate UDR through SQL queries.
Writing SQL Queries Such as Trigger, Stored Procedure, View etc.
Scheduling SQL Jobs.
Creating Indexes and Query optimization.
.
Project Details:
TP-POSPRO:- (Level 3 Support)
This is the Point of Sale software and will handle the store
operations from a small store with a single register to stores with
over ten registers easily. Like all the Suite products TP-POSPRO has
a multi level security system with encrypted passwords along with
relevant audit trails to protect the data. Product lookups, customer
Information gathering and Bar code scanning are all features of this
solution.
Environment: VB, SQL Server 2005.
Client: Chain Medical shops (Guardian, Surya, Global).
Role:
Database Installation
Maintaining Databases.
Back-Up and restore.
Writing complex queries such as trigger, stored procedure etc.
CSMS: -(Level 3 Support)
This is the comprehensive centralized sales, inventory and financial
management software for chain stores. It is the powerful yet not
expensive solution that will handle the requirements of managing a
chain of two pharmacies to more than 100 stores.
Environment VB, SQL Server 2005.
Client: Chain Medical shops (Guardian, Surya, Global).
Role:
Database Installation
Maintaining Databases.
Back-Up and restore.
Writing complex queries such as trigger, stored procedure etc.
RESTORM: - (Level 3 Support)
This is the centralized inventory and sales management OLAP server
of the suite. All online inventory transactions are updated into
RESTORM to provide a comprehensive analytical look at institution
wide information. This runs on MS SQL Server and is utilized for
Management Information, Decision Making and Planning. It also
supports the deployment of Plug Ins so as to enhance the service
offerings of the organization.
Environment VB, SQL Server 2005.
Client: Chain Medical shops (Guardian, Surya, Global).
Role:
Database Installation
Maintaining Databases.
Back-Up and restore.
Writing complex queries such as trigger, stored procedure etc.
TP-WH: - (Level 3 Support)
This is a very similar application to the TpPOSPro with the enhanced
facilities that are required for Warehouse management. It has built
in features to track products, allocation and picking of products
for dispatch to various stores. Barcode printing, Purchase Order
Tracking, Margin Tracking and a host of reports are available for
the smooth functioning of the warehouse.
Environment VB, SQL Server 2005.
Client: Chain Medical shops (Guardian, Surya, Global).
Role:
Database Installation
Maintaining Databases.
Back-Up and restore.
Writing complex queries such as trigger, stored procedure etc.
TP-POSPRO PLUS: - (Level 3 Support)
This software is used to automate the pharmacy works of a Hospital.
Environment VB, SQL Server 2005.
Client: MEDANTA Hospital.
Role:
Database Installation
Maintaining Databases.
Back-Up and restore.
Writing complex queries such as trigger, stored procedure etc.
Curriculum Projects
Project "Hospital Management System"
Description Hospital Management System is software developed for a
hospital, which automates the entire functioning of the
organization.
Environment VB.net, SQL Server 2000.
Project "Online Mobile Showroom"
Description Online mobile showroom is an online mobile buying web
site.
Environment ASP.net, SQL Server 2005
Project "Textile Shop Automation"
Description Textile shop automation is an application which
automates the entire functioning of a textile shop,
which includes the details of the employees .
Environment C#, SQL Server 2005.
Project "Learning Management System"
Description Learning Management system is an application which helps
students to learn different subjects online.
Environment ASP.net, SQL Server 2005.
Personal Details
Name : Tijo Thomas.
Fathers Name : Thomas Thomas.
Nationality : Indian
Date of Birth : 30-05-1986
Passport No : G4776455
Permanent Address : Payyampallil(H),Vellayamkudy
P.O,Suvarnagiri,Idukki(DST).
Kerala, Pin: 685515
Current Address : Techsmith Software Pvt.Ltd,P.T.Usha Road,Kunhalu
Place, 4th Floor
Ernakulam Cochin-11, Kerala
Hobbies : Playing cricket and listening to music
Languages Known : English,Hindi and Malayalam.
Declaration:
I hereby declare that the above-mentioned
information is correct up to my knowledge and I bear the responsibility for
the correctness of the above-mentioned particulars.
(Tijo Thomas)
Contact this candidate