Project Sql Server

Naveen David

Curriculum Vitae

Personal Details

Name Naveen David

Mobile +64-020*-****-***

Email **********@*****.***

Address Auckland, New Zealand

Career Objective

A skilled software developer with near 7 years in .NET and SQL server

experience. It is my goal to build my knowledge, skills and abilities in

software development to that of a senior level. I believe I can offer an

employer immediate value.

Skills matrix

1 - Basic, 10 - Very Proficient

Technology Proficiency (scale 1 - Experience

10)

Asp.net 2.0 7 4 years 4 months

Asp.net 3.5 7 1 year 8 months

Asp.net 4.0 6 1 year

C# 7 6 years 10 months

Web services 4 3 months

Ajax Controls 6.5 4.5 years

JavaScript 5 3 years

jQuery 3 4 months

SQL Server Reporting 1 1 month

services 05

SQL Server 2005/2008 R2 7 4 years 10 months, 2

years

CSS 7 6 years 6.5 month

Report viewer 3 2 months

Html 8 6 years 11 months

Analysis 2 3 years 10 months

SOA architecture 9 6 years

Agile development 7 6 years

Visual Source Safe 7 4 years 4 months

IIS 7, IIS 6 5 10 months, 4 months

Visual Studio 2008 (TFS) 6 1 year 7 months

Visual Studio 2010 (TFS) 6 11 months

dot Net Nuke 4.7 (CMS) 3 4 months

dot Net Nuke 6 (CMS) 6 3 months

Employment History

IHC (Intellectually Handicapped Children) - Government organization

Position - Senior Developer and Business Analyst

14 May 2013 - 31 October 2013 (5 month Contract)

Key tasks

Major upgrade to Complaints Website, end to end analysis and development

Analysis of dot net Nuke 4.7 intranet and recommendations made as whether

to upgrade or to switch to a Web Application.

Improving current websites hanging off the Intranet

Fixing bugs and developing user requests for various websites in the

intranet

Set up of Visual Source Safe to store code

Set up of Team Foundation Server

Agility CIS - Corporate

Position - Web developer

7 January 2013 - 5 April 2013(3 month Contract)

Key tasks

Developing website to technical specification of BA

C#, .NET Nuke development

Some SQL script modification/debugging

Testing of code

Debugging website issues on Client server and local servers

Deployment on Testing environment and on Client server with IIS 7

New Zealand Tertiary College - Private company

Position - .Net developer

August 2006 - October 2012 (6 years)

Key tasks

Requirements gathering

Technical specification writing

C#, ASP .NET Code full end to end development

Stored procedure and other SQL server scripting

Testing

Training of new developers

Auckland University of Technology

Position - Programming Exercise Marker

February 2005 - July 2005

Key tasks included:

Individually checked student exercises against criteria, awarded marks

appropriately and returned to lecturer in charge.

Electoral Office

Position - Election Officer

2005

Key tasks included:

Communicating instructions for voting

Counting of voting papers

Overseeing voting process

Educational Qualifications

Auckland University of Technology BCIS and BBUS conjoint degree

July 2002 - April 2006 Bachelor of Computer and

Information Sciences -

Major - Software development

Bachelor of Business - Major - Management

Auckland University of Technology Certificate in Introductory Computing

(Distinction)

July 2002 - July 2002 Relevant Papers

Communication

Programming

Mathematics

Statistics

Papatoetoe High School

1995 - 2001

Key projects

IHC (Intellectually Handicapped)

Project - Travel Form

Technologies used: C#, ASP.NET, SQL Server 2005, .Net Nuke 4.7, jQuery,

Javascript, Ajax controls, Linq, Entity Framework and Web services

Project length: 5 weeks

This is project involved designing and building a website which allowed

users to be assigned to Cost centres (departments). This involved:

Creating and Editing of Cost centres

Creating and editing of Cost centre managers

Assigning General Managers to Cost Centres

Removing of General Managers from Cost Centres

Creating and Editing General Manager's managers

I started this project as I recognised the company had a majority of Cost

Centre related requests. The website content was quite rich and easy to

use through a Google-like search and animation via jQuery. I created all

the images in Paint.Net from buttons to images for various controls.

Project - Complaints Website

Technologies used: C#, ASP.NET, SQL Server 2005 and .Net Nuke 4.7

Project length: 7 weeks

This is project involved upgrading the current Complaints website to

include a serious issues section. This would record serious issues that

needed to be reported the government or internally investigated. This

project involved talking to 3 stakeholders and determining how the current

Complaints system was recorded and coming up with ideas, project plan,

Technical Specifications, SQL server scripts, database design, development

and Testing.

Agility CIS

Project - People Energy

Technologies used: C#, ASP.NET, SQL Server 2008 R2, jQuery, Web services

and .Net Nuke 6

Project length: 2 - 3 months

This is project involved making a website for a power company called People

Energy which is based in Melbourne, Australia. The users of the website

can choose a plan, enter personal details, contact details, credit card

details and power appliances used in their home. The user could register

as a Business customer or Residential customer. In short we created a

prospecting website. There was a fair bit of jQuery used to show and hide

controls. There were a lot of Web services used to retrieve, create and

update data.

New Zealand Tertiary College

All of these projects had front end and back end development as part of the

project.

Project 8: Resource Room

Technologies used: C#, ASP.NET, SQL Server 2008 and Ajax controls

Project length: 2- 3 weeks

This functionality allowed users to view, upload/download and delete

resources such as PDF's etc; whatever file type was specified in the

administration screens. However permission to view, upload/download and

delete resources was all done based on the roles that were in our current

system. The roles could be turned off and on and the maximum file size

could be changed by administration users.

Project 7: Study guide versioning

Technologies used: C#, ASP.NET, XML, SQL Server 2008 and Ajax controls

Project length: 3 months

This involved a complex versioning system of course material (Study

Guides).

The Study Guide was contained within database tables in XML form. This

functionality would allow users to version individual sections, subsections

or individual elements. The key advantage of this project was to have a

base Study Guide which the following Study Guide versions referenced,

avoiding duplicate creation of Sections, Subsections and Elements.

Project 6: Reports using report viewer control

Technologies used: C#, ASP.NET, Report viewer control, SQL Server 2008

Project length: 1 week

I have created several reports using the C# .Net report viewer control. I

wrote database stored procedures to retrieve the data. The reports were in

relation to Students and Lecturers Assessment statistics.

Project 5: Reflective task attachments

Technologies used: C#, ASP.NET, HTML and CSS

Project length: 1 week

Reflective task attachments are part of the Classroom component of the

Content management system. The Classroom component contains course

content. Here students can read their course content and add

comments/attachments to reflective tasks.

My task was to allow students to add/remove and view attachments for each

reflective task. I created a control to do this. The complexity arose

because there were update panels. This meant a student was not able use

the file upload control. Therefore I used an iFrame which contained my

reflective task attachment control. Further complexity arose when multiple

Reflective tasks were 'opened', attachments added and then saved. It was

next to impossible to know which Reflective tasks attachment was being

displayed, deleted or added as iFrames were involved. With an idea from a

colleague I worked on a solution so that a query string was passed into

each individual iFrame so that it was possible to track which Reflective

task to display, delete or add an attachment to.

Project 4: Field practice

Technologies used: C#, ASP.NET, SQL Server 2005, HTML and CSS

Project length: 4 months

Field practice is a component which is used to assess NZTC's student's

hands-on practical skills.

A field practice administrator allocator assigns a 'visit' to a lecturer.

The lecturer then logs in online and can checks/uncheck learning outcomes

and assessment criteria, which the student has achieved for that visit.

Students can login and can view what assessment criteria they have passed

and which needs to be reassessed along with any comments by the visiting

lecturer.

The complexity in this grew as multiple lecturers could visit the same

student and make comments, check assessment criteria and learning outcomes.

This meant that each individual lecturer's visit had to be maintained

separately i.e. if lecturer 1 checked four assessment criteria on their

visit and the lecturer 2 made the second visit lecturer 2 could not undo

the changes lecturer 1 had made.

This has been the largest and longest task I have accomplished at NZTC.

This involved digging up an older version of field practice, getting the

code to work with the correct database and making this available for review

for my manager and for the Designer. Once reviewed I completely redesigned

the database structure as there were many unneeded tables and many tables

were missing for the new design. I then wrote the code based on the new

design and tested the functionality.

Project 3: PC induction page

Technologies used: C#, ASP.NET, HTML, CSS and JavaScript

Project length: 1 week

When a user logs in for the first time on their computer a system check is

done to make sure, JavaScript, Cookies, Java, Flash and Adobe Acrobat are

installed. The users Internet browser and computer operating system were

also retrieved. This involved a lot of JavaScript some basic and others

complex.

Project 2: Configured automated testing

Technologies used: : C#, C, XML, Selenium (automated testing tool java

based), CCNET and SQL Reporting Services 2005

Project length: 2 weeks

I worked on configuring CCNET so that we could run our Automated Testing

automatically without being on the premises. I then automated the process

to read the Automated Testing Pass/Fail output and to move it into a

Database. An SQL report was then automatically uploaded to the server.

There wasn't much documentation for this project on the Internet. My

colleague and I had to piece information on the internet to get CCNET to

retrieve our Code, compile it and to run the Automated Tests. The next

difficult bit which I did by myself was getting RSBuild to automatically

upload the report to the server. This involved using the language C which

I had never used before.

The diagram below explains the work done for automated testing

Project 1: Media Gallery

Technologies used: C#, ASP.NET, HTML, SQL Server 2005, CSS, JavaScript and

Ajax controls

The Media gallery is a web based repository which stores video files, image

files and documents. The intention of this Component was to allow users to

upload/download, search and view content. The intention was to sell this

along with the Content management system that NZTC was building.

Step 1: Requirements gathering

I had to research to see what and how current repositories were storing and

displaying content. I looked at Flickr and Kodak. The main intention was

to find the most user friendly approach as we were building the Media

gallery for low tech users. Once I gathered ideas on how to proceed I made

basic mock-ups of the web pages required.

Step 2: Analysis and Specification creation

Next I created Technical Specifications for the various components of the

Media gallery for example viewing Items specification, Authorisation

specifications (Items that the user uploaded need to be filtered for

inappropriate content), Search specifications both Advanced searching and

basic searching. All in all I created about 40 Technical specifications;

the specifications entailed a Business process and System walkthrough.

Database tables and revised screen shots were also included but not in all

specifications.

Step 3: Database design

I had to review the current database tables and made required changes.

Stored procedures have been written to implement the CRUD functions.

Step 4: Coding

I finally went on the developing the web pages. This was done in .Net 2.0.

There was some minor JavaScript included in this component. This was used

in the drop down menus.

Step 5: Testing

This involved manual testing of the components. This was later tested by

the tester and bugs were fixed in the Media gallery component.

Other Relevant Skills

Computing Ability to use MS Project, MS Word, MS Excel, MS PowerPoint, MS

Access, Pascal, Java, MySql, Experience in setting up SQL Reporting

services, practice with NUnit and WATIN testing software and have used a

little Umbraco.

Leadership While studying at AUT I have been in the position of leading

various teams. Both in IT and in the Business part of my degree.

For the IT part of my degree. I lead 3 teams over the course of 3

semesters, each team had about 4 - 5 people.

For the Business part of my degree I was the leader for ProActiv

which is a SIFE program. My team consisted of about 7 people.

http://sifeaut.org.nz/

Knowledge in Business and IT I have studied both business and IT.

Therefore I have awareness of both fields.

Other Languages Japanese

Interests/Voluntary Work

Interests

Foosball, Table tennis, Tennis, Fishing, Travel, Guitar, Piano and Church.

Voluntary work

Assisted at Chosen Valley Christian Camp as a leader - Looked after

kids for 5 days while they did various activities. I

have helped out for 12 camps.

Student mentor at AUT (Auckland University of Technology) - Supported

first year students and assisted at student orientation for 2 semesters

Contact this candidate