Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Windsor, ON, Canada
Posted:
January 27, 2015

Contact this candidate

Resume:

Aditya Kumar Soma

647-***-****

acn1g5@r.postjobfree.com

SUMMARY

. Over 5 years of Information Technology experience in requirement

analysis, design, development and testing of client/server and n-tier

architecture applications.

. Extensive knowledge of Client/Server and Web based applications using

Visual Basic, C#, ASP.Net 4.5/4.0/3.5, Web Services, AJAX and SQL-Server

2008/2012.

. Exposure to .NET Framework 1.1/2.0/3.0/3.5/4.0.

. Working knowledge of ASP.NET MVC pattern: Controller Actions, View

Engine, HTML Helper methods, Entity Framework Model and the Windows

Workflow Foundation.

. Strong experience of application development utilizing WCF, XAML, WPF,

LINQ and Visual Studio 2008/2010.

. Strong experience in writing SQL statements, stored procedures,

Functions, Views, Triggers of SQL Server 2003, 2005, 2008, Oracle 9i/10g,

MS-Access and MYSQL databases.

. Experience in developing applications using Service Oriented

Architectures (SOA) and Model View Controller (MVC).

. Have hands on experience with web technologies including HTML5, HTML,

CSS3, JavaScript, AJAX and JQuery.

. Excellent experience in Creating, Consuming and Publishing XML Web

Services (SOAP, WSDL, UDDI) using .NET Framework and Solid understanding

of Service Oriented Architectures.

. Experience on working with Windows Communication Foundation (WCF) and

windows presentation framework (WPF) .NET 3.5/4.0

. Familiar with MS SharePoint.

. Strong analytical and problem-solving skills coupled with excellent

written, verbal and interpersonal communication skills.

. Ability to conceptualize, document, and communicate project ideas and

plans.

. Very good team player with strong ability to learn and adapt new skills

and makes efforts to do the work at hand and manage time effectively.

EDUCATION

. Bachelor of Technology in Electronics and Communication Engineering -

Jawaharlal Nehru Technological University, Hyderabad, India.

TECHNICAL SKILLS

. Net Technologies VB.Net, ASP.Net, C#, .Net Framework

1.1/2.0/3.5/4.0/4.5, ADO.Net, Web Services,

SOAP, IIS, WCF/WPF/Silverlight, ASP.Net MVC

2.0/3.0/4.0, Windows Application, Windows

Service, TFS, AJAX, LINQ, Entity Framework,

Enterprise Library

Programming Languages C#.NET, VB, Java, C

Web Application Development HTML, DHTML, XML

Script Languages VBScript, JavaScript, JQuery

Operating Systems Windows NT/2000/XP,7

Databases MS-Access, Oracle 9.i, and MS-SQL Server

2005/2008/2012

Developing Tools Visual Studio 2003/2005/2008/2010

EXPERIENCE

1. Wireless Ronin, Windsor, ON Apr

2014 - Till Date

.NET Developer

ISHOWROOM is an Automotive Dealership application with which vehicle

purchase contracts (Deals) are prepared and signed and additional services

(including insurance and extended warranties) may be offered to the

purchaser. The application calculates the associated sales taxes, finance

charges and the resulting total sale price and monthly payment for the

various types of vehicle contracts. Other functionality includes Side-by-

Side comparisons, customer quotes and used vehicle appraisals.

Responsibilities:

. Involved in Requirement Analysis, gathering, Low Level Design, Coding

and Integration.

. Responsible for designing and developing the Application using ASP.Net

MVC 4.0, Razor Syntaxes, Razor view engine.

. Responsible for developing the Data Access Layer (Model) using ADO.Net

Entity Framework Model, LINQ to Entities, and C#.

. Responsible for designing and developing the UI using HTML 5, CSS 3.0,

JQuery, JavaScript.

. Responsible for developing the reusable Components on UI(Views) by

developing the Partial Views, View starts, and reusable components for

implementing the business rules with C# and OOPS Concepts.

. Responsible for making AJAX Calls for the UI Interactions to the

Controller Actions using JQuery and getting the Data back as JSON and

parsing it onto the UI.

. Responsible for designing and developing the Business Layer Component

using C#.

. Responsible for developing the Data Access Layer (Model) using ADO.Net

Entity Framework Model, LINQ to Entities, and C#.

. Responsible for writing the Actions in the Controllers which implement

the Business Rules and which act as a mediator between UI (View) and

Database (Model).

. Responsible for designing and developing the database objects like

Tables, Views, and Complex T-SQL statements, Stored Procedures

involving Joins and using Temporary Tables, UDF(User Defined

Functions)

. Worked in SQL database Optimization, and implementing the Performance

tuning steps on the Data Retrieval Queries.

. Responsible for publishing and consuming the WCF Services.

. Created Stored Procedures, Functions, Views and Triggers in MS-SQL

database using T-SQL for regulate and maintain complex data.

. Involved in daily and weekly SCRUM meetings to discuss various aspects

of the code related to individual modules.

. Worked on Microsoft Team Foundation Server for version control,

individual task status and Database

Use of Time: 50% Backend, 40% Frontend, 10% Testing.

Environment: Visual Studio .NET 2012, .NET Framework 4.0 & 4.5, WCF,

ASP.Net MVC, JQuery, ADO.Net Entity Framework, SSRS, HTML, DHTML,

JavaScript, C#, SQL Server 2012,Agile Scrum Methodologies, TFS 2012.

2. Assiniboine Credit Union, Winnipeg, MB FEB

2013 - Apr 2014

.NET Developer

Assiniboine credit union Company provides a full range of banking services

to individual and commercial clients. Its services include deposits,

savings, loans, credit, investment assistance, life insurance, trade

finance, money transfer and remittance, and Internet banking.

The developed application is an Intranet application that takes care of

banks day to day activities like Payments, Account openings, Check current

balances, Verify withdrawals, Deposits, Transactions, View loan details

like interest rates, Account Statements etc.

Responsibilities:

. Participated in Design reviews, Architecture reviews, Code Reviews and

proposed solutions to the business problems

. Involved in analyzing and gathering requirements of each and every

project from Business Analysts.

. Developed cross browser compatible, customer facing online application

based on 3 -Tier architecture

. Developed windows application using WPF and build forms using XML.

. Worked on AGILE software development methodology where the team is

involved in the SCRUM AGILE management framework.

. Created web pages using MVC 3.0 razor views for responsive user

interfaces.

. Experienced in building applications after the conversion from MVC 3.0

to 4.0 version using Asp.net MVC 4.0 framework.

. Involved in designing user forms, web pages, interfaces using HTML5,

CSS3, XHTML, Web server Controls.

. Extensively used CSS and Implemented Master pages for consistent look

for web pages.

. Created WCF Services responsible for communicating and providing real

time data from integrated server to Client Application.

. Developed web-services using WCF to provide access to business

functions to other applications.

. Implemented WPF Composite Events to publish and subscribe different

Events and employed multithreading techniques.

. Developed XML Web Services using WCF, C#.NET with multiple bindings

and address and hosted them on IIS and tested them by generating the

proxy class files based on the web services and consumed in web

application

. Created web applications using AJAX for responsive user interfaces and

more efficient client server communication.

. Extensively used LINQ Objects to query the objects based on

requirement

. Constructed Data Access Layer with ADO.Net and Entity Framework

. Created and modified existing Stored Procedures

. Involved in Database Designing, Views and Stored Procedures in SQL

Server 2012

. Developed the test plan, test conditions and test cases to be used

in testing based on business requirements, technical

specifications. Tested the application using NUnit testing

. Used Team Foundation Server (TFS) for integration, maintenance and

Security of code

. Created user access control to restrict users based on user roles

. Involved in Unit testing and Integration testing with other modules

. Involved in Software Development Life Cycle(SDLC)

Use of Time: 50% Backend, 30% Frontend, 20% Testing.

Environment: C#, ASP.NET 4.0, Entity Framework 4.0, Visual Studio

2008/2010, MVC 4.0, ADO.NET, HTML5, DHTML, XML, XSL,XSD,SOAP, Web Services,

CSS3, SQL Server 2008/2012, AJAX, MS Visio, NUnit, TFS, LINQ, WCF.

3. PRICEMETRIX INC, Toronto, ON

DEC 2011 - JAN 2013

.NET Developer

Operational Project Planning System (OPPlan) is a web application,

developing for maintaining the information of the operational and research

projects done in different divisions of the department. This system has

different modules and sections, which were developed in different phases.

Responsibilities:

. Prepared design documents (sequence diagrams) and wire frames using

Microsoft Visio.

. Involved in various phases like Development, Testing, Implementation

. Validating all the User's Inputs through JavaScript and VB extensively

used AJAX toolkit controls

. Designed and developed ASP.NET GUI for user interface using Master

Pages.

. Created the User controls and worked on custom controls for the

presentation layer.

. Used user controls for having uniform look and uniform functionality

of the controls.

. Created Web forms and user controls using AJAX toolkit.

. Extensively used CSS and Implemented Master pages for consistent look

for web pages.

. Used JQuery to perform client side validations and Dom elements

manipulations.

. Invoked Web services from client side using JQuery AJAX syntax.

. Worked on the third party tools, Telerik RadControls such as the

RadGrid, RadTree, and RadUploader etc. Also used the telerik skins for

the theme of the website.

. Worked on SQL Server 2008 to maintain the user table and the data and

Creation of Data layer includes writing stored procedures and views

. Developing XML Web Services in C# and SOAP for information exchange

across applications

. Developed a new WCF service to get the information from the database

. Worked with LINQ to SQL to build data access layer to connect to SQL

Server to perform crud operations.

. Created SQL store procedures for complex business logic.

. Performed Unit test, Integration test, Regression test, Load test and

Platform test.

. Versioning tool used is Team Foundation Server (TFS)

Use of Time: 50% Backend, 40% Frontend, 10% Testing.

Environment: Visual Studio .NET 2010, ASP.NET 4.0, HTML, AJAX, .NET

Framework 4.0, MS SQL Server 2008, TFS, Telerik controls, MS Visio.

4. MASS MUTUAL FINANCIAL GROUP, CT, USA

OCT 2009 - DEC 2011

.NET Developer/Analyst

Worked on an internal application where the users can access the

functionalities of the interface only when they are given the proper access

privileges. Different Modules of the application include members, groups,

agencies, brokers, and carriers, Accounting, Reports and Administration.

Responsibilities:

. Involved in analyzing requirements and data provided by the Business

Analysts.

. Developed data access layer that supports connections to multiple

databases using ADO.NET.

. Implemented business logic using Object Oriented Programming.

. Created Validations and roles for different users to access the

application.

. Used server side Web API in order to transfer data/messages via HTTP.

. Designed reusable classes, implemented those classes using VB.NET in

building the desktop application.

. Designed and Developed Web Forms using ASP.NET controls, C#, and HTML to

facilitate the registered users.

. Used visual source safe for source code maintenance.

. Coordinating between onsite and offshore team as an onsite coordinator.

. Handled production issues involving real-time application problems.

. Designed SSIS Packages to transfer data between servers, load data into

database, archive data file from different DBMSs using SQL Server

Management Studio on SQL Server 2005 environment, and deploy the data.

. Designed reports using Crystal Reports and SSRS.

. Interacted with the Business Users to document the existing application.

. Defined workflow to support life cycle of presentation unit and

supporting production database or application problems.

. Use Case and Object Design activities are being done with UML and source

code is being managed with Visual Source Safe (VSS).

. Used Visual Source Safe 6.0 for version control.

. Writing test cases for unit and integration level for a single module.

. Wrote Unit tests for the code that was developed as part of strict

programming guidelines.

Use of Time: 40% Backend, 50% Frontend, 10% Testing.

Environment: Visual Studio, VB.NET, Win Forms, SQL Server 2005, ADO.NET,

HTML, XML, API, Stored Procedures, Crystal Reports, VSS 6.0.

5. MERRILL LYNCH, INDIA

DEC 2008 - SEP 2009

Software Developer

Merrill Lynch, GCAR Elections.

The GCAR Elections utility is a web based system that will allow for the

creation, capture, management, processing and archiving elections on

corporate actions events. Additionally, the utility is being built to be

utilized as a facility for users to provide an indication to the corporate

actions area as to how they intend to address any short position

liabilities.

Responsibilities:

. Based on the requirement use to Analyze and involved in designing and

development.

. Designed and developed web services in C#.

. Created Custom Web Controls like Grid View and Calendar in C#.

. Used JavaScript and Validation Controls for validating the controls.

. Used C# to write all the middle business layer logic.

. Created XML database of all different frequency levels.

. Involved in creating Tables, Stored procedures using Cursors, Joins in

SQL Server 2005.

. Documented the entire Web Services project and some of the other

Modules.

. Involved in Unit Testing and Integrated Testing

Use of Time: 20% Backend, 60% Frontend, 20% Testing.

Environment: C#.Net, ASP.Net .Net Framework 2.0, ADO.NET, SQL Server 2005,

DB2, Visual Studio.NET, JavaScript, XML, Windows NT/XP.



Contact this candidate