Sql Server Data

CURRICULUM - VITAE

Narayana .SJ E-mail:

**.********@*****.***

Mobile: 900-***-****

OBJECTIVE

To take up opportunity and shape it to perfection. To be efficient and

effective in whatever endeavors I undertake and prove myself worth.

Diligence and honesty is what I aim to practice.

In General

Over 2 years 10 Months of general computer experience with Tata Consultancy

services, extensive experience in installing, maintaining and

troubleshooting Windows systems, Networking, Database, knowledgeable in

computer hardware and various devices.

Professional Summary:

. Currently Working as Assyst administrator and share point

administrator for one of the retail project. This includes PLSQL, SQL

(Oracle 9i), Database maintenance and administration.

. Worked as Call monitoring (Quality Analyst) for about representative

for 8 months for one of the other Project in TCS. Working with Crystal

reports and SQL query analyzer 2000.

. Also worked as Desktop Support engineer, where used to take remote of

small servers located remotely and resolve the issue for them.

. Have experienced in handling Change requests and Telecom Queries in

the same retail project.

Work Experience:

Managing Crystal reports:

Crystal Reports is a reporting tool and a business intelligence

application, which helps you to present the data in an effective and

customer friendly manner.

Suppose the data in Assyst. If someone wants to analyze how many calls are

logged by Service Desk, you can either get it from Assyst, or you can get

it by Querying the database.

But in both cases, the data is really difficult to interpret by Business

users. So to convert the raw data into a format which is suitable for

Business Analysis, by including the fields which are required, and

excluding the fields not required, which graphical formatting, you need

Crystal Reports.

Using Crystal Reports you can:

a) Connect to a variety of data sources (including Microsoft Excel

spreadsheets, Oracle databases etc)

b) Format the data in a tabular / graphical manner, with pie charts, bar

graphs etc

c) Include formula fields apply formatting to the data, even include VB

codes

d) Export the data in a variety of formats (MS WORD, PDF, Excel etc)

Basically, you need the following:

a) Crystal reports v10

b) ODBC Connection to the database where you want to get the data from

(there are other methods of connectivity also)

Once you open Crystal Reports, you can use the Report building wizard,

which will go step by step, and lets you do the following:

a) Choose a report template

b) Lets you select the database and the database tables from which you

want to get the data

c) Lets you select conditions based on which to extract the data (unions,

where clauses in SQL)

d) Lets you apply formatting, and formulae's on the data

ASSYST 6.0 Administrator

Assyst is application tool helps in logging tickets, also worked in ht

backend of Assyst, updated data through SQL query processing, Alter and

Maintain Assyst front end and back end Database .

. Creating Assyst user ID's for various departments in front end

application to dealing it as Database Group for database ID creation.

. Keeping Assyst database up to date in terms of records in different

table like (New store, New end user, Item,Category,User groups, User

permissions, Mapping of item with respective category, Mapping the

relevant script for helpdesk, Alert message for critical item and user

etc)

. Keeping the hardware and software version up to date in terms of store

equipment, server hardware etc. Store equipment details are sent by

SSI as and when required.

. Keeping track of store closure and discontinue them in Assyst.

. Querying all the call details for SD teams (SD IT Security, SDDSG,

SDSTSG) for period reporting and service management requirement.

. Configuring Assyst SLA for different service departments and supplier.

Monitoring the SLA escalation alert processor running in nt0asst2

server.

. Monitoring wincor link and other external job processors running in

nt0assp1 server in office hours (OOH-OSG). Assyst Admin is responsible

for logging a call with Axios in case any major problem in wincor

link.

. Monitoring Assyst import processor, auto logged calls and reassign

application running in the 5SBJW1J server in office hours (OOH-OSG).

Assyst Admin is responsible for logging a call with Axios in case any

major issue.

. Customizing Assyst for new service improvement requirement. (ex:-

Reassign auto logged calls using Assyst Aim, Escalation alerts, NFF

CTR calls, smart mail etc)

. Preparing Assyst Aim Header files for bulk data upload for specific

requirement.

As SQL DBA:

. To maintain the accuracy of the data

. Handling Client Queries & Requests and Reassignments & Editing of

Special Requests like New Data Additions/Corrections/Explanations,

. To create and maintain user manuals and technical documentation as

required.

. Preparation of Financial Reports and Crystal reports.

. Designing and Administrating Database servers like MS SQL Server,

Oracle 9i & and MS Access.

. To maintain all the data base regarding assets and entitlements and to

analyze the data for better CRM.

Roles and Responsibilities:

. It's focused towards providing L1 and L2 technical support for daily

activities like Database support, Network, Supplier management,

assistance in all the day-to-day functioning of business.

. Implementing Service Improvement Process

. Providing L2 support for support center

. Working to contribute to process review and improvement.

. Knowledge sharing

. Training activities.

. Be on top in Process Knowledge.

. Effective Communication Skills

. Good Technical Competence.

. Avoid Absenteeism of the team members.

. Regulate staffing (make alternate arrangement during criticalities)

. Have an ownership on everything that happens during their shift

. Proper shift handover to the next team on shift.

. Building everlasting Team acceptance

. Maintain consistent team performance

. Suggest innovative methods to improvise team performance

. Ensure the reports reach on time

. A good team player and a team motivator.

Educational Qualifications:

Degree and Institute Summery

Date

S.S.L.C Sri Sathya Sai Loka Seva Passed out with 84%

Institutions,

Muddenahalli

Diploma in Nettur technical training Computers Engineering, Passed

Computer foundation. ( N.T.T.F) out with 78%.

Engineering.

Sikkim Manipal Distance 6th Semester under

BCA education progression.

Technical Expertise:

Languages : Visual Basic 6.0 and Unix/Linux Shell

script, HTML and C, C++

Packages : SQL2000 query analyzer, Oracle 9i.

MS Office, Outlook, Micro Media Flash and Dream Weaver

Skill set :

MS SQL Server

a) Installing SQL server 2000 & 2003 server and Client tools.

b) Simple recovery.

c) Customizing Disabling SQL query analyzer.

d) Create Back up device ( GUI )

e) Attach and Detach SQL servers 2000 with different database.

f) Working with SQL server enterprise manager.

Oracle 9i:

a) Installation of Oracle on 1).Linux (both Server and Client) and

2).Windows (both Server and Client).

b) Creation of database.

c) Managing Oracle instance.

1) Creating and maintain

X) Undo files

Xi) Redo files

xii) Control files

2 Creating and Managing indexes and undo data

d) SQL tuning.

e) Usage of locking mechanism.

f) Sizing and re sizing the SGA components

Operating Systems:

a) Operation system and Its concepts.

b) Installation of Windows 2000, 2003, XP.

1) Installation of DNS servers.

2) Installation of DHCP servers.

c) Installation of Windows servers (Client) 2003, 2005.

d) Linux (Red hat).

e) Linux (Suse).

Hardware/Networking :

a) Assembling of PC and Troubleshooting and Maintaining PC.

b) Troubleshooting the Lexmark Printers.

c) Cisco router maintenance. (remote servers )

d) Doing Switch reboots as and when needed.

Personal Information:

Name : Narayana .SJ

Father Name : Jayaram. SN

DOB : Sep -06-1988

Permanent Address : C/O S.N Jayaram

Canara Coffee Works

T.B Road, Opt to Town Police station

Shidlaghatta, Chikkballapur(D)

Mobile No :+91-900*******

Residence No :+91- 80 - 26604410

Languages Known :English, Hindi, Kannada, Telgu,

Tamil and German A+.

CO-CURRICULAR ACTIVITIES

a) Professional yoga practitioner.

b) Cyclist.

c) Drawing, Water painting.

d) Music (Guitar Beginner).

e) Photography.

f) Photo editing (Adobe and New Versions of Photoshop).

Declaration

I hereby declare that all the above said information is true to the best of

my knowledge.

Thanking You

Place: Bengaluru

Date: 08-May-2010 Signature

( Narayana.SJ )[pic]

Contact this candidate