Sql Server Management

William Sagayaraj.T

Specialization: Microsoft Technologies(SQL)

Mail ID: *******.******@*****.***

Mobile: +91-978*******.

Career Objective:

I want to work in a friendly environment where I can put my hard earned skills and talents to practice and to pursue a career in the field of information technology that offers me an opportunity for the career growth.

Job Description:

• 2 .4 years of extensive experience in software development(SQL DEVELOPER) using Microsoft Technologies

• Experience of SQL SERVER 2005 Database Programming i.e., Transact-SQL (including Stored procedures, Functions, Views).

• Responsibilities implementing database objects (Package, procedures, functions, triggers)

• Business/domain knowledge in Education.

• Experience in developing Reports using Crystal reports 10/XI, Crystal Enterprise and integrating with the Front-end applications.

• Experience in generating reports using SSRS 2005.

• Experience in implementing User Accessibility Compliance for the application.

• Hardworking, enthusiastic and highly committed to the growth and success of the organization.

• Very quick and efficient in solving complex technical issues.

• Possess good work ethics and high-level of integrity.

• Leadership, project management and time management

• Understanding business data relationships

Career Achievements

• Experience working on and deploying a diverse set of computer technologies and platforms including Microsoft Operating Systems and applications.

• A firm understanding of Business Analysis, Project Management concepts, tools and industry standards.

• Strong experience in analyzing and defining business processes.

• Hands-on experience with the installation, configuration and management of Oracle 8i, 9i and Microsoft SQL Server 2005 databases running on various versions of Windows platforms.

• Experience in projects with superior analytical, organizational and planning and presentation skills.

• Advanced knowledge of Software Development Life Cycle phase, Agile Development and Six Sigma Methodology.

• Solid hands on Experience in network design and topology, setting up VLANS on Cisco Switches, using VLSM and cabling.

• Solid hands on Experience in the installation and configuration of Cisco Routers and Switches and applying various protocols including TCP/IP.

Experience:

• Mindlogicx Infratec Ltd, Bangalore since November 2009 Present as Product Support Associate.

Assignment 1

Project Title : IntelliCAS

Client : ANNA University, Coimbatore.

Organization : Mindlogicx Infratec Ltd.

Duration : Nov-2009 Present

Role : Analysis, Development

Language : Crystal Reports, SQL Server 2005,, SSRS ,ASP.NET ,

Team Size : 8

Description:

IntelliCAS is a unique Certificate Authentication System under which the certificates issued to the candidates by the client will be authenticated by the company through a Global Access Code (GAC) along with security hologram / smart label. Using GAC which is a unique ID, for each certificate, the credentials of the candidate may be checked and validated from the global database maintained by our partner agency that has their presence in about 140 countries worldwide.

By this system each student will have a unique Global Access Code (GAC) which the prospective employer can verify from the global data base. The employer will be able to get complete data about the student including his marks, performance analysis and validation of the data. By this the issue of handling fake resume can also be effectively handled

Responsibilities:

• Analyze and Design the components based on defined specifications

• Preparation of Unit Test Plans and verification of functional specifications and review of deliverables

• Participated work assignment and estimation efforts required for design, code and testing

• Design of Database tables and creating SQL stored procedures

• Design and develop user specific reports using Crystal Reports

• Designing the various charts representing data for financial needs of the business using Crystal Reports.

• Penetration Testing of the application (Checking Sql Injections, Evaluating User Input, HTML Encoding, validating Hidden fields, view state Information)

Assignment 2

Project Title : intelliEXAMS

Client : ANNA University, Coimbatore.

Organization : Mindlogicx Infra tec Ltd., Bangalore.

Duration : Nov-2009 Present

Role : Analysis, Development

Language : SQL Server 2005,Crystal Reports, , ASP.NET,

Team Size : 10

Description:

IntelliEXAMS, the Examination Management System, is the benchmark in new-age education delivery systems and set the knowledge revolution in motion. It leverages the power of technology and facilitates the conduct of fool-proof examination, reduce turn-around time, enhance accuracy of evaluation and manage vast amounts of data in a distributed environment.

The Examination Management System (EMS) has a simple and easy to use web-based centralized user interface and a well-defined database-centric schema for storing, retrieving, managing and aggregating examination objects. The question papers are delivered in a highly secured manner with 128-bit encryption technology. Effective reports are generated to know the details about examinations conducted, examination centre details, fee details, candidate details, cost and budget details, etc.The system is robust enough to handle large amount of data. Also the system is equipped with proper back up disaster recovery plan. The system can be deployed in universities, large corporate, banks, etc., for online examinations, mass recruitment and for skills up gradation tests.

Responsibilities:

• Taking care of the Database design and implementation.

• Implementation and maintenance of database security.

• Responsible for analysis, design and development of the system.

• Developed stored procedures for data extraction.

• Implemented cursor techniques.

• Implemented CTE techniques largely for reports.

• Design and development of user specific reports using Crystal Reports and SSRS.

• Analyzing the functional specifications and user Requirement Documents.

Education:

• Master of Computer Applications,DJ Academy of Managerial Excellence, ( 73% ) , Coimbatore.

• Bachelor of Science in Physics, St.Joseph college, ( 68.88% ), Trichy.

• Intermediate (10+2) – Board of Intermediate Education, ( 82% ) , Salem.

• SSLC (10) – Board of Secondary School Education, ( 78% ), Salem.

Technical Skills:

• Databases : SQL Server 2005, Oracle (9i,10g Express),MySql.

• Languages : ASP.NET 2.0

• Web Technologies : HTML,CSS,Java Script,PHP.

• Operating Systems : Windows 2000, XP, Vista.

• Additional Knowledge : SSRS, Crystal Reports

• Fields of Interest : OOPS, RDBMS Concepts.

Personal Profile:

Father’s Name : Thomas Paulraj.R

Date of Birth : 12-07-1985

Marital Status : Single

Alternative mail ID : *******.******@*****.***

References : Available upon request.

Place :COIMBATORE (WILLIAM SAGAYARAJ.T)

Date :22-03-2012

Contact this candidate