Sql Server .Net MVC c# WCF

Venkat A

Email: ******.*******@*****.*** Phone:**8-

***-****

• Over 5 years of software development experience in web and windows applications including requirement

gathering, analysis, design, development, integration, implementation and deployment using Microsoft .Net

Technologies.

• Experienced in design, analysis and implementation of Object-Oriented (OOP) Applications (Inheritance,

Polymorphism, Exception Handling etc) using VB.Net and C#.

• Worked with ASP.NET Web Forms, ASP.NET State Management, ASP.NET Caching, SecuringASP.NET

Web Applications.

• Worked with Visual Studio 2008/2010/2012.

• Experience in developing presentation layer using Web Forms, Windows Forms.

• Experience in 3-tier and n-tier architecture development.

• Experienced in working with iterative Agile Programming Methodologies, Waterfall methodologies,

Scrum and Test-driven development (TDD).

• Experience in Developing, Consuming and Debugging the SOAP and REST Web Services using WCF.

• Hands on experience in creating Stored Procedure, Triggers, User Defined Functions, DTS, Transaction

Management using T-SQL and PL/SQL, Code optimization and performance in databases like Oracle 11g/10g &

SQL Server 2012/2010/2008.

• Ample understanding of implementation of Silverlight 2/3/4 projects using Model-View-View Model (M-

V-VM) Pattern.

• Experience working with Windows Communication Foundation (WCF) and knowledge of WPF.

• Highly Capable of implementing Unit Tests, using N-Unit and MS Unit .

• Experienced SQL Server Reporting Services (SSRS) and Crystal Reports for report generation,

integration into .NET applications.

• Good knowledge in SQL Server Integration Services (SSIS).

• Hands on experience with Xml Technologies.

• Expertise in Web Development Tools -HTML, DHTML, XML, VBScript, JavaScript, Ajax, ASP, IIS,

VSS.

• Experience in working with LINQ to SQL.

• Extensive Experience with ORM technologies with Entity Framework Database Model first and

performance tuning in Entity Framework 6.0/5.0/4.0.

• Expertise in creating Views, Partial Views, Strongly Typed Views, Sections, Areas, Routing, etc.. in

ASP.NET MVC 4.0/3.0/2.0.

• Good experience in Exception Handling, Debugging and Tracing by which the whole picture of

application runtime can be seen and analyzed more efficiently.

• Good team spirit and organized working habits with willingness to learn new concepts.

• Quick learner and smart worker.

• Excellent Communications skills, good team player and have good Analytical capabilities. Good

organizational skills, ability to handle multiple tasks and work independently as well as in team.

Technical Skills:

Programming Languages C++, C#, VB.NET, HTML, T-SQL, PL/SQL, Fortran.

Server Scripting ASP.NET 4.5,4.0/3.5/3.0/2.0

Client scripting Java Script, JQuery, VB script

Xml Technologies XAML, XML, XDOCUMENT, XSLT, XPATH, XSL.

UI Technologies Win forms, WPF, Silver light.

IDE Tools Visual Studio 2012,2010/2008/2005, SQL Server Management Studio, Expression

Blend(4.0/3.0/2.0)

.Net Frameworks .Net Framework 4.5,,4.0/3.5/3.0/2.0

Databases MS SQL SERVER 2008/2005/2000,MSAccess 2010/2007/2003,Oracle 10g/9i/8i, DB2,

Cognos.

Reporting Tool SQL Server Reporting Services (SSRS 2008/2005), Crystal Reports (2010/9/8.5/8).

Modeling Tools UML,MS Visio 2010/2007

Version Control Tools Visual SourceSafe(2005), Subversion, Team Foundation Server(2008)

Middleware WCF, ADO.NET 4.0/3.5/3.0/2.0, MSMQ, Web Services, Enterprise Library 5.0/4.0/3.1

Servers Windows Server 2008/2003/NT, Microsoft IIS

Testing NUnit, Moq

Professional Summary:

The Cooperators - Regina, SK July 2013

– Present

.Net Developer

project : Auto Quote

Description: It's a Marketing Application for Nationwide Insurance customers. The Application consists of three main

modules, "Query", "Policy" and "Rate Quote". The Query Module is the interface with the Customers to query the

Database and generate Customizable reports. The policy module concerned the various Insurance sectors including Life,

Auto and Home Insurance. The "Rate Quote" module provided Rates and payment Terms, funding and protection

options, and coverage details for the various types of Insurance.

Responsibilities:

• Involved in gathering the requirements, analysis, design & development of the project.

• Followed Agile and Scrum Methodology to produce high Quality software.

• Used Visual studio 2012, MVC4 and razor view to build the project.

• Extensively used JQuery for client side operations like displaying popups, validations, event handling, animations,

checking and clearing session.

• Worked on HTML, JQuery, Java Script and CSS.

• Exclusively used JQgrid to display and save data, along with various JQgrid features like load once, custom

formatter, and custom alignment.

• Extensively used JQuery for client side operations like displaying popup, validations, event handling, animations,

checking and clearing session.

• Extensively used AJAX control toolkit for masking, changing information and creating dynamic controls on the

panels etc.

• Implemented and extensively used the Object Oriented programming concepts and advanced features in C#.

• Modified Web Services to interact with the other applications and exposed them using SOAP and HTTP.

• Established communication between different applications running on same/different platforms using WCF.

• Used Code First approach in the Entity Framework.

• Used LINQ to SQL extensively for extracting data from the database using Entity Framework.

• Performed complex parameterized SQL queries to multiple tables in SQL server 2012 and implemented Joins in

Stored Procedures to get the desired data by joining multiple tables in Domain layer.

• Unit tested various components of the program to make sure all the components were behaving properly.

• Mocked web API, data objects and various other components of the program to and unit testing.

• Responsible for Bug fixing.

• Designed and developed several SSIS packages to transfer the data between the different environment systems

and/or export the data to other applications.

• Team Foundation Server (TFS) was used for controlling versions and assistance in documentation and creating

Help files.

• Performed extensive Unit testing using NUnit, developed Test Plans, Test Cases.

Environment: VisualStudio2012, C#, ASP.NET 4.0/3.5, ASP.NET MVC 4.0,, Razor, JQGrid, JQuery, XAML, TFS

2010, IIS 7.0, AJAX, ADO.NET Entity Framework 5.0, LINQ, JSON, Microsoft Enterprise Library, NUNIT, SQL Server

2008 R2, Windows 7, Moq.

Coast Capital Savings Bank - Surrey, BC May2012 –

June 2013

.Net Developer

Description:

Coast Capital is a leading provider of banking and financial services like credit card management, teller services,

demand deposits, loans, Consumer credit, clearing, delinquency and line of credit. Credit card and bill payment

Management system provides online corporate credit card services to clients.

Responsibilities:

• Actively involved in Software Development Life Cycle including Analysis, Design, Implementation,

Testing and Maintenance.

• Followed Agile methodologies (Scrum) and Test Driven Development.

• Created login-based members area that displays ASP.NET pages based on access levels and assigned

Roles.

• Designed and Developed Web Forms using ASP.NET controls.

• Developed Master Pages, Custom Controls & User Controls To reduce the Complexity in User Interface

Coding and provide better look and feel.

• Implemented several controls using AJAX technology.

• Created Client side validations with JQuery selectors, Events and Server side validations with ASP.Net

3.5.

• Implemented and extensively used the advanced features in C# to develop security forms authentication.

• Developed system services SOA application platform for use by all web applications utilizing WCF

services.

• Used Database First approach in the Entity Framework.

• Used LINQ to SQL extensively for extracting data from the database using Entity Framework.

• Created Views, Triggers, Joins, Stored procedures and queries to get the data according the required

functionality.

• Implemented unit test, coverage testing and automated test using VSTS testing.

• Fixation of the bugs in the User Interface of the software.

• Designed reports using Crystal Reports and SSRS.

Environment: VisualStudio2010, C#, ASP.NET 4.0/3.5, Scheme Programming Language, EDMX, JQuery, XAML, TFS

2010, IIS 7.0, AJAX, ADO.NET Entity Framework 4.0, LINQ, XML, Microsoft Enterprise Library, NUNIT, SQL Server

2008 R2, Windows7, Moq.

FedEx, Memphis, TN April 2011-

April2012

.Net Developer

Description: This Application mainly tracks and updates the routes and customer information with complex algorithms to

calculate the shipping rates depends on selected option by customer.

Responsibilities

• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation,

Testing and Maintenance.

• Developed standalone and browser-hosting applications using WPF.

• XAML is also used to represent the visual presentation of the application.

• Created Layouts, style sheets for achieving uniformity across all the .aspx pages.

• Effectively used MVVM pattern to create the client in PRISM Framework.

• Used WPF animation and storied boards to create attractive user interfaces and appealing documents.

• Used the Windows Presentation Foundation (WPF) framework for the clear separation of the User

Interface from the Business Logic.

• Implemented and extensively used the advanced features in C# to develop security forms authentication.

• Created WCF, REST Services and also used different bindings to make it available to different level of

users.

• Leveraged WCF mechanisms like sessioning, Instance management, concurrency to make our services

more robust and scalable.

• Developed and Consumed Web Services.

• Used the LINQ to Entities, Query projections, Grouping, Entity SQL, Querying with LINQ to SQL, Eager

Loading, defining Mapping and Inheritance.

• Written Queries using T-SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in

SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

• Implemented Unit Testing, Integration Testing and System Testing using NUnit.

• Fixation of the bugs in the User Interface of the software.

Environment: VisualStudio2010, C#, ASP.NET 4.0/3.5,WPF, WCF,EDMX, JQuery, SILVERLIGHT 4.0/3.0, XAML,

TFS 2010, IIS 7.0, AJAX, ADO.NET Entity Framework 4.0, LINQ,XML,, Microsoft Enterprise Library, NUNIT, SQL

Server 2008 R2.

AK TECH Corp, Hyderabad, IN September 2009-

March 2011

. Net Developer

Project: Asset Tracking System

Description: The Asset Tracking System (ATS) was implemented to aid the Network Operations Field Work Groups. The

objects of using ATS are accurate asset management and tracking for corporate tax reporting purposes.

Responsibilities:

• Involved in full life-cycle of the project from requirements gathering to transition using Agile Methodology.

• Developed core business algorithm to create inland trips based on the availability, rail schedule info and available

rates.

• Migration of classical ASP into ASP.NET.

• Involved in designing the layout of User interface using Visio and Class diagrams using UML.

• Developed the independent WCF (Windows Communication Foundation) services and defined Service Contracts

for specific functionality in search module.

• Developed Web forms and Web Services using vb.net.

• Oracle 10g was used as a database repository and created complex stored procedures, triggers and user defined

functions to implement critical business rules.

• Designed, modeled multi-threaded, enterprise n-tier software application.

• Designed and developed Services using WCF and also leveraged WCF security mechanism at transport level with

windows authentication type for our intranet applications.

• Implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information.

• Established communication between different applications running on same/different platforms using WCF.

• Used Grid View, Data List and Repeater controls with Paging and Sorting for displaying various data on to the

page.

• Programmed ADO.NET for communication between application and database, used extensively Data Grid, Data

Set, Data Table, Data Views, Data Adapter and Data Readers to render reports.

• Developed Stored Procedures, Triggers, and Views in SQL Server 2005 for accessing the database.

• Developed many T-SQL queries to fetch data as per the business requirements with proper tuning techniques.

• Implemented and extensively used the Object Oriented programming concepts in C# and ASP. Net 3.0.

• Developed the Classes, Objects, Dataset Classes, and Methods depending upon the business requirements.

• Used ASP.NET User Controls to create wizard steps for submitting and modifying events and evaluation forms.

Involved in creating the logic for the several different modules.

• Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent as

parameter to the stored procedures.

• Implemented Serialization and Deserialization of objects.

• Developed Custom Controls which provides flexibility, reusability better deign time experience.

• Developed partial post back validations to manipulate data on web pages using AJAX.

• Developed various stored procedures for the data retrieval from the database and generating different types of

reports using SQL reporting services (SSRS).

• Used Visual Source Safe for version control of the source code along with the maintenance of the builds and the

relevant documents of the same.

• Involved in unit testing, integration testing and deployment of the application.

Environment: Visual Studio 2008, ASP.Net 3.0, ADO.NET, vb.net, XML, HTML, JavaScript, IIS 6.0, NUNIT, Visual

Source Safe, SSRS, SOAP,WCF,WPF,.NET Framework 3.0, SOA, Web services, SQL Server 2005, T-SQL, DHTML,

Windows Server 2003.

Education:

B.Tech in Computer Science, JNTU, Hyderabad, India.

Contact this candidate