Sql Server Technical Support

L I L IAN NGAARA

*** * *** ***** ****, Apt ***, Ardmore, Pa, 19003 Tel 484-***-**** e-mail r ******@*****.***

S U M MARY OF QUAL I F ICAT IONS

Database Skills

• Installed Structured Query Language (SQL) Server 2008 R2

• Created a database for a bank in SQL server

• Created several tables for the bank database and showed their various

a tt ributes

• Defined the primary and foreign keys for each table

• Showed the various relationships between the tables; one to many,

many to many

• Run query commands to display information in a table or several tables

• Expertise in developing SQL codes th rough various procedures,

f unctions and packages to implement the business logics of database

• Excellent backend skills in creating SQL objects like Tables, Stored

P rocedures, Views, user defined data types and functions

• Designed databases for different projects and resolve database issues,

such as data constraints, defaults

• Used SSRS to create reports

P rogramming Skills

• Designed websites using HTML, XHTML, XML languages

h ttp://www.personal.psu.edu/lmn5130/IST240/IST240.html

• Used the XML Validator tool to ensure the XML document run without

e rrors

http://www.personal.psu.edu/lmn5130/IST240/completed%20midterm

%20project/cd_catalog.html

• Developed a program in C++ for calculating pay for employees. By

using functions, and if statements, the program was able to calculate

t he pay for each employee every week according to the hours worked

Technical Skills

Operating Systems Windows 7, XP/Vista/2000/Server 2003/2008, Mac OS,

W indows 8

Languages C++, HTML, CSS, XML, XHTML, SQL, UN IX

Networking Setup of LANS and WANS

RDBMS SQL Server 2005, 2008

O thers Visio Studio, Perl Scripts, Microsoft Office 2007 &

2010, Document Management System, SpiceWorks,

C rystal Reports 2011, SSRS, Microsoft Project.

ED UCAT ION

• Cumulative GPA: 3.62/4.00 – Dean’s L ist

• Bs. in Information Science and Technology, Spring 2012, Penn State

U niversity, Brandywine Campus

CERT I F ICAT IONS

• MCSE 2000

• A+

ACH I EVE M E N TS AND AWARDS

• Received two certificates of recognition in outstanding academic

achievement

• Received the John E. and Judith F. Baillis Endowed Scholarship Award

for 2010-2012

E MP LOYME N T

The Pennsylvania State University October 2012 – Dec 2012- Contract

• Installed wireless 2.0 on students and staff laptops

• Was in charge of students workers in the IT Department

• Ghost Imaging

• Set up VLAN

• Supported Mobile devices- IPhone, Ipad, Android

• Provided technical support over the phone

• Installed system software, antivi rus, and applications programs

• Assisted in video conferences

• Assisted students and faculty to setup up the projectors

• Assisted staff to share their calendar on the university collaboration

suite

The Pennsylvania State University May 2010 – May 2012

• Installed VPN on students and staff laptops

• Supported Mobile devices- IPhone, Ipad, Android

• Provided technical support over the phone. Five to ten phone calls in a

day

• Installed system software, antivi rus, and application programs

• Assisted in video conferences

• Assisted student and faculty to setup up the projectors

• Assisted staff and faculty in Outlook recovery

• Set up a database for salvage using phpMyAdmin and using MySQL to

r un queries

• Provided t raining to staff, students, and faculty on how to use

M icrosoft Office Applications and also VPN

Com T wenty One L td Located in Nai robi, Kenya (July 2004 – August

2006)

• Planned, designed, installed and developed new computer systems for

t he company

• Installed and maintained printers

• Revamped existing computer systems for new tasks such as print

servers

• Networked computer systems with others

• Tested and debugged new or revamped computer systems and the

networks on which they communicated

• Created user accounts for users in the Active Di rectory

• Diagnosed network problems

• Provided customer support to Com Twenty One L td. Clients on what

software, hardware to purchase for their laptops or PC’s for the Pacsoft

A pplication

LANGUAGES

• English (Proficient)

• Kiswahili (Proficient)

Contact this candidate