Sql Server Manager

LIJO THOMAS

***** ****** ***, ****** ******, MD

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

240-***-****, Status: Green Card/Permanent Residence.

SUMMARY

. Extensive experience in Software Analysis, Design, Development,

Testing, Implementation and Documentation.

. Strong Data Modeling, Logical and Physical Database Design.

. Strong skills in front-end and back-end development using SQL Server

2005, T-SQL, MS Access Forms, VBA.

. Strong Skills in creating reports using SSRS 2005.

. Good Knowledge of ASP.net 2.0, XML, HTML, Java Script, Visual

Studio.Net.

SKILLS

RDBMS: Oracle 7.3, SQL Server 2000, SQL Server 2005, SQL

Server 2008

GUI Tools: Developer 2000, Microsoft Forms

Web Tools: Asp.net, HTML, XML, JavaScript

Development Tools: Visual Studio.Net

Languages: C#, VB.net, C, T-SQL, Java, PL/SQL, COBOL,

FoxPro, Dbase

Operating Systems: Windows XP/98/95

Web Server: IIS

Reporting Tools: SSRS 2005

EDUCATION

. Master of Computer Applications

Mysore University, India

. Bachelor of Mathematics

Calicut University, India

. Asp.net Level I and Level II

Montgomery County College, MD

PROFESSIONAL EXPERIENCE

United Air Temp, Lorton, VA (April 2006 to Present)

Sales and Installation of HVAC Equipments

Overview: Sales and Installation program was developed to help salesman,

administration and installation staffs to manage different stages of

equipment sale and installation. Upon sale of equipment, the Installation

entry screen allows salesman to enter customer information, details of the

equipment that they sold, quantity and sold price. The administration staff

evaluates the sales and then assigns a job id to uniquely identify the

sales. The installation staffs verify the equipments list and Assign

required licenses to get from city and county. Once the licenses are

approved from the county, the program prints front page and break down

sheet for the technicians to perform job. The Program automatically

calculates salesman's regular commissions, PM Commissions, overage

adjustments and sales lead source commissions.

Role and responsibilities:

. Gathered business and technical requirements

. Developed Data Model

. Developed Queries

. Developed Forms

. Wrote Code

. Developed Reports

. Tested Applications

Environment: SQL Server 2005, MS Access forms, VBA

Stored procedures using SQL Server 2008

Overview: I created and modified stored procedures for almost 20 tables for

CRUD operations using SQL Server 2008. These stored procedures are used in

shopping car application. The stored procedures check records before

inserting new record or updating new record.

Employee Management Database

Overview: Employee Management Database was developed to collect and manage

United Air Temp employee's information such as 401K, Insurance, Tools,

Vehicle assigned, Education, Certification, Address, and Contact

Information. This application is used by HR staff to daily to update

employee information.

Role and responsibilities:

. Gathered business and technical requirements

. Developed Data Model

. Developed Queries

. Developed Forms

. Wrote Code

. Developed Reports

. Tested Applications

Environment: SQL Server 2005, MS Access forms, VBA

Recruiting System

Overview: Recruiting system was developed to track applicants who have

applied for jobs at United Air Temp. It stores applicant details including

contact details, the position they applied for, department in which they

are seeking position, etc. The system then distributes the application to

the concerned department in which they are seeking position and allow each

department head to analyze the application and contact the applicant. The

department head has the option to set the applicant for an interview or

place the applicant on-hold or reserve the applicant for later or reject

the application. After the interview, based on the applicant's performance

the department head has the option to hire the applicant or set a second

interview or reject the applicant. If the applicant does not show up, user

can assigns him another interview date.

Role and responsibilities:

. Gathered business and technical requirements

. Developed Data Model

. Developed Queries

. Developed Forms

. Wrote Code

. Developed Reports

. Tested Applications

Environment: SQL Server 2005, MS Access forms, VBA

Stock Order System

Overview: Stock Order system is used by the branch managers to request

parts needed regularly by technicians and is used by the purchase manager

to process the request, order the parts and track the order. The system

collects information of the parts needed from branch manager. Using

assigned vendor priority for the parts, system processes the request.

During the process, the system groups the request by purchase order number

which is then presented to the purchase manager. The purchase manager has

the option to review the request, approve or disapprove quantity or request

and then place order for the parts. The branch manager has the option to

track the status of the order throughout the process. System takes care of

back order request also.

Role and responsibilities:

. Gathered business and technical requirements

. Developed Data Model

. Developed Forms

. Created Queries

. Wrote Code

. Developed Reports

. Tested Applications

Environment: SQL Server 2005, MS Access forms, VBA

Return Call Program

Overview: This program allows to order and purchase custom parts for the

customer. The application tracks all the stages of the process. Once a

customer calls for repair of any unit, the system pulls out all the details

about the customer. This detail includes the name, address and contact of

the customer, details of all units owned by the customer, and type of

service contract with the customer. The system assigns a technician to go

to the customer and check the unit. If technician needs parts to fix the

unit, he contacts dispatch people and they enter details about the parts

needed. After entering all details the system forwards the request to the

purchasing department

The purchasing department can pull the name of the part and the vendors

supplying the part. Based on the service contract of the customer, the part

is either ordered immediately or send for customer approval. In case, the

request does not have complete information, the order can be put on hold

and completed at a latter date. The application tracks all these stages of

the process. The status of all the transactions can be viewed in real-time.

Role and responsibilities:

. Gathered business and technical requirements

. Developed Data Model

. Developed Forms

. Created Queries

. Wrote Code

. Developed Reports

. Tested Applications

Environment: SQL Server 2005, MS Access forms, VBA

Howard University, Washington DC

Database Developer

Overview: I designed department website which was database driven. The

database included details of faculties, their research interest, names and

details of the students, syllabus, class starting date, class time,

building name and room number, course books, list of call class notes, home

works, project details for each course, exam dates, marks of each student

in each paper, etc.

Role and responsibilities:

. Gathered business and technical requirements

. Developed Data Model

. Created tables, Set primary and foreign key

Environment: SQL Server 2005

Howard University, Washington DC

Personal web site

Overview: This personal web site was developed using HTML, JAVASCRIPT and

CSS. The pages included Home page, Biographical Page, Resume Page, Photo

Gallery Page, Projects Page, Quotes Page, Link Page and Contact Information

Page. The home page contained four categories: a map of my home

state/country, a picture of my home state/country, a brief background

summary of my home state/country, and a link to other web pages to navigate

in detail about my home state/ country. Biographical Page contained a brief

autobiography. The Resume Page had a copy of my resume along with links to

both WORD and PDF version of my resume. The Photo Gallery showed my

favorite photos. The Projects Page shows a summary of some of the projects

I have completed. The Quotes Page has a list of my favorite quotes. The

Links page contains a list of my favorite websites. The Contact Information

page contained my contact information.

Braton BioTech Inc

Overview: I was involved in developing web pages to update company web site

and installed and repaired computers. I worked along with manager to run

NIH research reagent repository contracted by Braton biotech. Used Web

Enabled BSI system to track records of reagents, to pull reagents and

insert reagents. Reviewed request for reagents from different companies and

made decisions about request.

QSoft Systems, Bangalore, India

Resource Consulting System

Overview: Resource Consulting System (RCS) was developed for handling

manpower requirements. This Application has an updated database of

candidates who have been carefully scrutinized, for various areas of

functional capabilities. This ensures the best-suited candidates both in

terms of specifications and budgets. The candidates are screened thoroughly

as per selection criteria like interviews, technical tests etc by a well-

qualified personnel in specific areas.

Role & Responsibilities:

. Analyzed the business and system requirements.

. Designed the Data Model, application system and prepared the

specifications for programming.

. Developed application for the complete life cycle of the hedge

product with the available databases and tools.

. Coded stored procedures and PL/SQL for these modules.

. Created tables, views for the application database.

. Designed and developed the User interfaces using Developer 2000.

. Created reports using reports 2.5.

. Production support for the system.

Environment: Oracle 7, Developer 2000, Reports 2.5, Windows NT.

Contact this candidate