Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Halifax, NS, Canada
Salary:
70000
Posted:
October 14, 2014

Contact this candidate

Resume:

Vikas Pasricha

** ********** ***

Dartmouth- B*W 0A2

Ph: 902-***-****

acgdil@r.postjobfree.com

P rofessional Summary

4+ Experience as effective team member in all stages of application development life cycle

including requirements, logical and physical architecture modeling, design, development,

testing, implementation, maintenance and support.

Strong knowledge of Object Oriented Design Methodologies for reusability

Hands on experience in developing applications in .NET framework 3.5/4.0/4.5, C#, ASP.Net,

AJAX, ADO.Net, JQUERY, XML

Excellent hands on experience in Web Services using SOAP, WSDL and Schemas XSD with

strong skills in understanding and implementing Service Oriented Architecture (SOA)

Extensive experience in architecture, design and development of Client-Server and Distributed

Web Applications with ASP.NET MVC 3.0, 3-Tire and N-Tire Architecture

Extensive experience in Database design, SQL Server/T-SQL, Stored Procedures

Excellent experience in writing Data Access Layers using ADO.net Entity Framework and LINQ to

SQL

Good experience with Agile Development and better understanding of MVC, PRISM and MVVM

patterns.

Comprehensive knowledge in NUnit and .Net Framework Unit Testing

Designed and developed, and implemented applications for the A utomotive, Environmental

Services and Manufacturing industries for both public and private sectors

T echnical Skills

Core Skills: C#, ASP/ASP.NET 2.0/3.5, SQL, OOPS, GUI design, WCF, SOAP and

RESTful Web Services

Web Technologies: ASP.Net, MVC 4.0, JavaScript, AJAX, SOAP, HTML/DHTML/XHTML,

CSS, IIS

Databases Technologies: MS Access 2003, Microsoft SQL Server 2005/2008/2010, Oracle

7.x/8.x/9i/10g/11g, MySQL, ADO.Net, LINQ to SQL

Frameworks .Net Framework 3.5/4.0/4.5, Entity Framework

IDE Visual Studio 2005/2008/2010, Dream Weaver

Design Patterns: 3-Tier, N-Tier, MVC, PRISM, MVVM, SOA

Development Methodologies: Test Driven Development (TDD), Agile development, Scrum

Tools/Technology: NUnit, SVN, TFS, MKS, SQL Server Management Studio 2005/2008,

Visual SourceSafe 6.0, SQL Profiler, Adobe Photoshop, DevExpress

XtraReports, Infragestics

Version Control: Team Foundation Server (TFS), MKS, Visual Source Safe, SVN

A cademic Credentials

MACS(Master in Applied Computer Science) Dalhousie University Halifax, NS, Canada

B.E.(Bachelor in Engineering) in Computer Career Institute of Faridabad, India

Science Technology and Management

(CITM)

1 Page

P rofessional Experience

Work as System Development Specialist in Xerox Government Systems, LLC

Dartmouth- CANADA from January 2013 to till date

Land Record Management System (LRMS)

Responsibilities:

Working with a talented team of developers and business analysts to create new solutions

to support and implement Tax Calculation and Billing engines for Land Record

Management System using C# and ADO.Net

Involved in Requirements gathering, Conceptual Design, Analysis, and Detail design,

Development and System Testing

Using agile methodologies for planning, estimating, and creating solutions desi gned to

meet the business needs

Performing code inspections and refactor code to meet standards

Implemented graphical user interface (GUI) using WPF and Win Forms

Implemented data access and business l ogic to meet client requirement

Created Business Logic Layer & Data Access Layers to implement the MVC architecture

Responsible for developing WCF Service (SOAP and Restful) Libraries to exchange data

between Desktop and Central Application and implement business logic

Created DAL (Data Access Layers) to establish database conn ectivity and data

manipulation

Involved in performance tuning of the application by creating various database Indexes

and optimizing database queries

Implemented Multithreading Concepts using TPL to improve the application Performance

Handled Run Time Errors & Design Time Errors by implementing approp riate Error

handlers in C#.Net

Developed tools in C# for creating SQL Scripts form Physical Layer of entity framework to

create database schema and a tool that load raw data for test development

Performed data load and integration using SSIS complete that allows to copy and convert

the legacy data into current system

Customize entity relationships and mappings

Implemented test cases using NUnit

Implement agile scrum methodology in application development

Technologies:

C#, MVC, WPF, WCF (SOAP, RESTful), ADO.Net, Entity Framework, TPL, SQL Server 2012 and

Orcale 11g, VSS 2012, SSIS, NUnit, DevExpress Reporting, Infragestics Controls

Worked as Sr. Software Engineer and Team Lead in E-Centric Solutions Pvt. Ltd.,

Delhi- INDIA from January 2010 to August 2011

www.msmetraining.gov.in

Responsibilities:

Increased performance for troublesome manipulations by up to 40% by optimizing client -

side JavaScript, reducing the number of round -trips to the server by moving calculati ons

where traffic would be reduced, and optimizing stored procedures and indexes. For

analysis purpose I used Red Gate Profiler for performance and memory profiler and SQL

profiler

Worked on Agile methodology for the development of the application

2 Page

Wrote stored procedures and triggers for firing DML queries to the SQL Server database

Design and developed C# components for implementing business logic in the middle tier

in 3-tier application interacting with SQL Server database using ADO.Net

Converted the existing Associate Database system to meet the new requirements and

utilized the various class libraries

Design and implement the GUI (ASP.Net), WebForm controls using CSS, JavaScript,

jQuery and Ajax

Developed user controls (.ascx files) like page last update

Created master pages to maintain uniformity throughout the application

Handled C# features such as Exception Handling, and Custom Error Messages

Used JavaScript and ASP.NET Validation Controls to carry out validation in the application

Coordinate and resolve problem tickets, support end users with application issues, data

issues and apply fixes as needed

Troubleshooting any Database related issues, .Net related configurations

Participate in Active Code Review

Carried out unit testing using NUnit

Technologies:

ASP.Net 3.5, C#, SQL Server 2008,VSS 2008, ADO.Net, NUnit, JQuery, AJAX, Microsoft

Enterprise Library, ANT Red Gate Performance Profiler, SQL Profiler,

Project: State cooperative Banking

Responsibilities:

Coding in C# sharp for various (Admin as well as user) module by using MVC pattern

Designed database, stored procedure and functions for various functionality

Developed WCF services to enable effective communication in SOA

Implementation of client side validations using JQuery and ASP.NET M VC Validation

implemented at Controller level

Programmed Data Access Layer using ADO.NET which involved in accessing data from the

Database using disconnected Architecture

Design and develop multi-threaded ad-hoc database driven web/win applications and

tools to support said applications to meet company needs in a timely fashion.

Design and distribute documentation to instruct users on how to utilize web and win base

apps in person and or over the phone

Design Functional Specification documentation on softw are application developed by staff

and myself

Develop complex SQL (utilizing T-SQL) procedures that migrate and pump data from

multiple data sources i.e. (vendor files, XML, flat database files, Excel spreadsheets e tc.)

to a centralize data store

Develop database driven web sites utilizing two and three tier paradigms

Involved in AJAX validation and Reports generation using Report Viewer Control

Technologies:

ASP.Net 3.5, C#,IIS 7.5, MVC, WCF, LINQ, AJAX, Report Viewer and SQL Server 2008, VSS

2008

Rajiv Gandhi Udyami Mitra Yojana (www.rgumy.nic.in)

Responsibilities:

Reports generated using Report Viewer Control

3 Page

Developed Custom Controls to enhance the Functionality to meet user requirements like

GridView control with exporting to Excel and Custom Dropdown List control with auto

complete

Responsible for configuring the reports in various environments and troubleshooting the

installation issues

Worked on validation controls in ASP.Net such as the Required Field Va lidator, Compare

Validator, and Range Validator controls to validate the contents of the web pages

Technologies:

ASP.Net 2.0,C#, SQL Server 2005, Report Viewer Control, AJAX

Worked as Software Developer in ScalerCode Technologies Pvt. Ltd., Delhi- INDIA

from August 2008 to September 2009

Projects /Web applications:

Simple Install (A window based C# Application) (C#,XML)

www.bqlub.com (ASP.Net 2.0, ADO.Net, C#, SQL server 2005)

Salary Management System (Intranet Application, VB.Net, ASP.Net 2.)

Responsibilities:

Used N-tier architecture and coded using C#

Wrote store procedures and triggers in SQL Server 2005

Active Code review participation

Participates in the design and development of databases, writing stored procedures,

triggers, views, complex queries and cursors.

Made changes in existing Code as per user requirements

Worked as a Programmer in HCL Infosystem, Noida- INDIA from November 2006

to October 2007

Socio-Economic Data Mart and Reporting (C#, ASP.Net, ETL, Cognos Reportnet)

Responsibilities:

Understand Existing ASP.Net based application

Involved in the design of Data Cube using Cognos Datawarehousing tool

Designed database table, stored procedure and functions for various functionality

Create Data cube and cognos report using reportnet

A cademic Research/ Project

MFE (Mandatory Field Editor) for Medusa Medical Technologies Inc., Halifax,

Canada as a Research Assistant in Dalhousie University (VB6, C#, ASP.Net, VSS 2010,

SQL Server 2008, JQuery, AJAX)

Search Engine using No SQL as a Programmer (PHP, Apache Server, GDBM, JQuery)

Build inverted indices of the words using weighted scheme in the Vector Space model, used

cosine similarity measure for ordering the search query results

Portfolio/References on Request Available for Relocation

4 Page



Contact this candidate