Sql Server Development .Net Engineer Experience

HARPREET SEKHON

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

780-***-****

An accomplished System Analyst specializing in Object Oriented Design and Analysis with extensive experience in the full life cycle of the software design process including requirements definition, prototyping, proof of concept, design, interface implementation, testing and maintenance.

Summary of Qualifications

.NET Programmer with 3+ years of experience in object-oriented design, development, process methodologies and database designing.

Worked extensively in databases using SQL Server 2005/2008, PL/SQL.

Extensive development experience in technologies like C#, VB.NET, ASP.NET, WinForms, ADO.NET, Crystal Reports and XML.

Expertise in development and implementation of small and large-scale projects in .NET Framework

Experience in SDLC, Agile methodology process.

Expertise in Preparing business block diagrams involving Class Diagram, Object Diagram and ER Diagram to Translate Requirements into Technical Specifications using MS Word, Power Point, UML, MS Visio

Worked on diverse platforms like Windows, Linux/Unix.

Education

• Three years Diploma in Computer Engineering.

(Punjab State Board of Technical Education and Industrial Training)

Technical Expertise

Languages C#, VB.NET, ASP.NET, PL/SQL, JavaScript, Visual Basic 6, VB Script, XML, HTML.

Frameworks IBatis.NET1.7, .NET Framework 2.0, 3.5 & Infragistics 10.3

Reporting Tools Crystal Reports.

IDE/Tools Microsoft Visual Studio 2005/2008, NUnit.

Testing Unit Testing, NUnit

RDBMS/ Databases SQL Server, MS Access.

Web/App Servers Internet information Server (IIS) 6.0/5.0.

Operating Systems Windows XP, Windows 7, Windows 2000.

Version Control VSS and TFS.

Professional Experience

Department Of Energy, Government of Alberta June 2011 – Till Date

Edmonton CANADA

Role: C# Programmer

OASIS: The Oil Sands Administrative and Strategic Information System project will meet the anticipated growth of oil sands projects and provide the necessary information for the Oil Sands Strategy and Operations Division to manage and carry out its mandate.

Phase 1 of OASIS enabled Oil Sands Project (OSR) operators to create and submit OSR Project Applications online, through the Department’s web based client interface, the Electronic Transfer System (ETS).

Phase 2 of OASIS is now in development phase. This phase encompasses the reporting and calculation of oil sands royalty. Changes will be with respect to the submission, validation and tracking of royalty and related information.

Responsibilities:

• Development of reporting module.

• Involved in gathering business requirements and preparing the BUC and SUC.

• Developing SQL queries and stored procedures.

• Resolve the issues and fixing bugs.

• Involved in OASIS System migration.

• Involved in Updating the OASIS documents in Share Point Server 2010.

• Unit Testing.

Environment: C#, WinForm, IBatis.NET 1.7, XML, Infragistics 10.3, SQL SERVER 2008, VS 2008/2010, Crystal Reports, VSS and TFS.

NetSoft Technologies July 2010 – May 2011

Role: System Analyst

PAS: PAS - Payroll & Accounting System is a web based Accounting application. It enables Financial users to generate the Payrolls and accounting for their employees in the centralized system. This application consists of couple of sub modules for tracking their client’s information. I was involved in designing and developing the different modules by using SQL Server & C# technologies.

Responsibilities:

• Functional & Detailed designing of the Payroll module.

• Work with C# and SQL server to develop the Payroll module.

• Development of reporting module.

• Developing SQL queries and stored procedures.

• Unit Testing.

Environment: C#, ASP.NET, Infragistics 10.3, XML, SQL SERVER 2008, VS 2008, Crystal Reports, VSS

Online Survey April 2009 – June 2010

Role: Senior Software Engineer

Online Survey: Online Survey application allows new users to get registered with the site and subscribe to the dynamic subscription plans. Online payment integration is used for payments through Credit card. The registered users are able to create unlimited online surveys. Using the Admin tool, administrator is able to manage the features like Customers account profiles, post online payments (credit card and Manual Check), reset passwords, create new sale plans, trouble shoot surveys created, Survey Managing, Email Directory Settings, Import data from outlook, Manage site Layout, Report Exports, Sales Plan Structure, Managing User Payment Account, Managing User Registration Form Field display Settings.

Major Features:

• Using Dundas Chart for analyzing user’s responses.

• Administrator can add/modify Survey templates for Users.

• Automatic email warning for Users regarding their accounts.

• Auto refilling of Users accounts.

Responsibilities:

• Major Involvement in designing, development & testing.

• Interaction with Client regarding requirement gathering.

• Responsible for writing business logic for using Dundas Chart.

• Responsible for designing & Implementation End to End Framework.

• Responsible for database designing, optimizing queries.

• Analyzing issue, providing resolution and tracking them to closure with application testing.

Environment: C#, ASP.NET, SQL SERVER, WINXP, VSS.

Contact this candidate