Post Job Free

Resume

Sign in

.Net Sql Server

Location:
Hyderabad, Telangana, India
Posted:
July 25, 2016

Contact this candidate

Resume:

Venkat

Senior .Net Developer

732-***-****

acvu5k@r.postjobfree.com

Summary

Seven (7) years of experience in Analysis, Design, Implementation and Testing of Client/Server, Web and Windows based application using Microsoft .NET Framework 4.5/3.5/2.0/1.0, C#.NET, ASP.NET, ADO.NET, VB 6.0, ASP.NET MVC, Entity Framework, AJAX, Angular JS, JavaScript, JQuery.

Hands on experience with Visual studio 2005/2008/2010/2012, VSTS, SQL Server 2000/2005/2008/2012 projects and Extensive experience with Visual Studio 2005/2008/2010/2012 /2015, VSTS, SQL Server 2000/2005/2008/2012 projects and .NET Framework 1.1/2.0/3.5/4.0 for the development of software class libraries, middleware Business Logic Layer (BLL), Data Access Layer (DAL) and User Interface (UI) components.

Exercised various phases of Software Development Life Cycle.

Experience in Testing and Implementation of Client/Server applications using C# and SQL Server with N-Tier development environment.

Experience in designing, developing and updating Web-Forms and Win-Forms using Technologies like HTML, XML, CSS, C#, AJAX, ASP .NET

Experience in consuming, building and implementing Web Services using SOAP protocols.

Experience in data accessing including using Data Adapter, Data Reader and Data Set, Entity Framework in ADO.NET and Language Integrated Query (LINQ), LINQ to SQL and LINQ to Object.

Good experience in ASP.NET 4.5, ASPX, Java Script, HTML, DHTML, IIS and CSS.

Extensive Experience in writing Stored Procedures and User Defined Functions in SQL Server 2000/2005/2008 R2/2012.

Skilled in creating Services and Endpoints using Windows Communication Foundation (WCF).

Experience on Windows Presentation Foundation (WPF).

Good Working Experience of SQL, T-SQL, PL/SQL, Stored Procedures, Constraints, Cursors Functions, Triggers, Views, Indexes and User Defined Functions, SQL Server 2000/2005/2008 R2/2012.

Experience on Windows Presentation Foundation (WPF).

Experience of developing application frameworks and understanding of enterprise application frameworks like ASP.NET MVC and Angular JS.

Experience in working with WebAPI (REST Service).

Strong knowledge in Object Oriented Analysis& Design and Object Relational mapping (ORM) methodologies.

Extensive experience in software development methodologies including Agile (Scrum), Test-driven development (TDD) and Waterfall methodologies.

Skilled in usage of designing tools like Microsoft Visio, Microsoft Excel.

Experience working in Source Control VSF and TFS 2010.

Excellent verbal and written communication skills, a super works ethic, and the ability to work well in a team or individual environment and also extensive mentoring experience.

Capable of demonstrating good interpersonal, presentation, analytical and problem solving skills.

Ability to quickly adapt to changes, enhancements, and new technologies. Ability to understand technical aspects of the assigned program/projects.

Technical Skills

Programming Frameworks

.NET 4.5/4.0/3.5/2.0/1.0, ASP.NET MVC 4.0/5.0, WCF, ADO.NET, WPF, Visual Studio.NET Framework 2005/2008/2010/2013

Programming Languages

C#.NET, VB. NET, ADO.NET, VB 6.0, AJAX, ASP. NET, MVC, Angular JS, JQuery,WCF Service, Web API

Web Technologies

ASP. NET, HTML, DHTML, XML, SOAP, JavaScript, CSS, LINQ, LINQ to SQL

Reporting Tools

Crystal Reports, SSRS

Databases

SQL Server 2005/2008/2012, MYSQL, Oracle 9i/11g, MS-Access

Operating Systems

Windows

Automated Build

Plug-in’s using MSBuild, VSF, TFS 2010,Autosys R11,

Application Servers

Microsoft IIS 5.0/6.0/7.0, Windows Server 2008/2003/NT

Education

Bachelor of Technology, Information Technology, A.N.U, India.

Work Experience

Canon USA INC, Jamesburg, NJ Oct 2015 - Present

Senior .Net Developer

Responsibilities:

Involved in development of Service Layer, Data Access Layer, Business Layer, Presentation Layer and different layers of N-tier Applications.

Designed different parts using C#.NET languages and built on n-tier architecture with extensive use of Object Oriented Programming Techniques.

Creating ASP.NET pages and class libraries containing code for business and data accessing logic for C#.NET.

Developed applications and UI designs using HTML5, CSS3, JQuery, Java Script, Ajax and Angular JS.

Created the Data access layer and Data access objects using ADO.NET Entity frame work and LINQ to reduce impedance mismatch.

Used Session State, View State, Cookies and Query Strings to persist and transfer data between pages.

Design and implemented Rich Interactive UI screens using ASP.NET, AJAX and performed data manipulations using Entity Framework.

Involved in working with Server side State Management Techniques like Session state to maintain state between ASP.NET pages.

Implementing Data Access Layer (DAL) and access the data using the Entity Framework.

Implementing business logic's in server side, and integrating Data Access Layer (DAL) with Business Logic Layer (BLL).

Performed CRUD operations with WCF Restful services using Web-Get, Web-Invoke.

Designed and implemented the service layer using the custom HTTP handler which supports both XML and JSON for request/response.

Used Web API from front-end to make HTTP to the controller and Bootstrap frame work for unresponsive Web pages.

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

Worked with SQL server in designing and developing persistence layer and worked with ADO.NET in developing database objects and querying the databases.

Creating and developing Stored Procedures, Functions, Views, Indexes, Triggers, Cursors, XML, Joins, user defined data types and other Complex Queries using Server 2008/2005 & Oracle 11g/9i.

Greatly involved in the development life cycle, from the design phase to the implementation phase, testing and deployment. Used the MVC design pattern.

Developed SOA using Windows Communication Foundation (WCF) for the client request and response.

Extensively worked with Controllers, Directives, Scope, Model and Modules in angular JS

Extensively worked on Consuming, Calling, Transmitting and Processing WCF Services.

Developed WCF Web services, APIs, and other back end components.

Environment:- ASP.NET,MVC 4.0, .NET Framework 4.5, C#, ASP.NET, ADO.NET, Entity Framework 5.0, HTML 5,CSS3, JQuery and ASP.NET, AJAX, JSON, XML, XAML, XSLT, IIS, WPF, WCF, SQL Server 2008, SSIS, SSRS, LINQ, Windows 7

Hughes Network System, Gaithersburg MD Aug 2014 – Sep 15

Senior .Net Developer

Responsibilities:

Developed applications based on departmental requirements and specifications.

Applied Model View Controller pattern for developing the web application.

Used client and server side validation, better session management and powerful data access management using ASP.NET MVC (4.0).

Implemented role base security, customizable workflows for each user based on the user's role and implemented forms Authentication and Authorization to provide security for application.

Used Silverlight 4.0 for developing frontend UI.

Used WPF for developing the Model View ViewModel (MVVM) pattern.

Involved in creating WCF REST services for various policies and benefits, and consumed them into the web application.

Working with the application in SOA (Service Oriented Architecture) by implementing WCF (Windows Communication Foundation) services.

Used Entity framework 4.0 data first approach to create classes mapped to database entities.

Participated in database modeling and development using SQL Server Stored procedures and Functions.

Developed and Maintained Several Modules such as Applications Portal Listing, Access Log -My Access and All Access, Users Management, Users List, Manage Users Permissions, Application Management, Applications List, Manage App Permissions, Manage Template Permissions and Authentication/Authorization Access Control System using C#.NET and ASP.NET in the .NET Framework 4.0.

Performed CRUD operations with ADO.NET by using SQL server backend.

Involved in Architecture specification design, External design and Solution design. Created wireframes using VISIO

Prepared and executed test scenarios to test the functionality of the application.

Effectively used Team Foundation Server (TFS) 2010 to manage projects throughout their lifecycle.

Involved in resolving operational problems and system failures by directing and performing system audits, analyzing problems and developed clear, concise methods for resolution.

Involved in unit testing, Feature testing and regression testing, bug tracking and defect management.

Used AGILE methodology (SCRUM) for the development.

Environment: Visual Studio 2010, .NET Framework 4.0, ASP.NET 4.0, C#.NET, WCF, WPF, MVC 4.0, SQL Server 2008, ADO.NET, Java Script, IIS 7.0, Silverlight 4.0, NUnit, AJAX, XML, TFS, Windows 7.

FedEx Corporation, Memphis, TN Feb 2013 – July 2014

.Net Developer

Responsibilities:

Used Scrum development methodology for the application.

Designed the Win form UI screens using WPF and XAML.

Developed product using ASP.NET, JavaScript, ADO.NET, C#, AJAX, Web services as per coding standards.

Developed a Service Contract, Operation Contract and Data Contract for the WCF service.

Implemented and consumed WCF services.

Identified the database entities and generated by the ADO.NET Entity Data model.

Implemented Data Access using Entity Framework Code First approach with LINQ queries.

Used LINQ to Entity for querying the database.

Extensively used Partial Classes, Generics, Interfaces and Object-Oriented concepts for developing the application.

Implemented paging of the grids using skip and take to handle large data from the database.

Created Stored Procedures, functions, views, complex queries to perform business rules on the database side.

Used SQL Server Business Intelligence Development Studio for modifying the SSRS reports.

Used Filezilla for downloading the backup and restoring the database.

Involved in executed test scenarios to test the functionality of the application.

Worked with Subversion version control tool for source code maintenance.

Involved in bug fixing.

Environment: Microsoft Visual Studio 2010, .NET Framework 3.5, C#.NET, ADO.NET Entity Framework, LINQ, WCF, WPF, XAML, AJAX, Microsoft SQL Server 2008 R2, FileZilla FTP Client, Subversion Version Control, Windows 7.

Array Bio-pharma, Boulder, CO Nov 2011 – Feb 2013

.Net developer

Responsibilities:

Involved in the complete SDLC of this intranet web application.

Involved in the Design of GUI using ASP.NET and business logic using C#

Used CSS for a unified look and feel of the application

Performed validations on Web Forms using .NET Validation Controls and also JavaScript

Created various Master pages to ensure reusability and designed Administrator Pages to handle overall application

Developed the web application in C# employing effective use of Web forms

Involved in design of Database Architecture

Implemented Optimized Stored Procedures, Database Triggers, Views, and Indexes using T-SQL in SQL Server 2005

Excellent experience in designing the .NET XML web services for data synchronization as well as file transfer and emailing utilities

Developed WCF services and implemented data contract attributes

Effectively used various State Management Techniques offered by ASP.NET

Used the ADO.NET SqlClient Objects like SqlConnection, SqlCommand, SqlDataReader and SqlDataAdapter and Dataset object in the Data Access Layer to fetch the data from the SQL Server 2005 database

Developed applications and UI designs using HTML, CSS, JQuery, Java Script and Angular JS.

Used Gridview, Dataset, Listview, Formview Panels and Data Reader to retrieve, display and manipulate data

Involved in the development life cycle, from the design phase to the implementation phase, testing and deployment using MVC design pattern.

Used ADO.NET components such as Data Adapter, Data Reader and Dataset

Used Microsoft Visual Source Safe for version control

Participated along with team and the Project Manager in various client meetings to discuss progress of the project

Generated complex and detailed reports using Crystal Report

Involved in unit testing using .Net unit testing framework.

Responsible for debugging and fixing bugs

Involved in support and maintenance

Developed code documents and user documents

Environment:-ASP.NET 4.0, ADO.NET, SQL Server 2008, Windows 7, WCF Services, Web Services, MVC, XML, CSS, JQuery, JavaScript, Angular JS, UML, IIS, Crystal Report, .Net unit testing, VSS, Visual studio 2010.

Apollo Hospitals, India May 2010 – Oct 2011

Software Engineer

Responsibilities:

Documented the Screen specification document and Design Document by using MS Visio

Prepared Application Prototypes using HTML

Developed application using ASP.NET, C#, JavaScript and unit testing of the software components.

Developed classes for consuming web services by using XML Web Services

Designed and developed WCF services for various card servicing functionalities using C# in .NET 3.0/3.5.

Developed number of Back-End SQL Procedures, functions.

Developed complex stored procedures and created complex views using joins for robust and faster retrieval of data using SQL Server 2008.

Created SSIS packages for Forum Analytics to production, schedule them to run on routine basis and monitor error log for errors.

Developed complex reports in SQL Server Reporting Services (SSRS) For Employee Benefit, Payment and Health Insurance using SQL Server 2008.

Used AJAX to speed up the performance of the application.

Develop Interface Components and bug fixes for existing website

Responsible for developing the web services that are responsible for get the Customer information based on the given Billing number.

Used DCOM for implementing the COM interoperability.

Involved in preparation of unit test cases.

Prepared Test Plan, Test scripts and Test conditions for system and Integration testing

Followed the SDLC guidelines and ISO standards in all the phases of the work and conducted quality reviews to ensure adherence to process standards throughout the Project life cycle

Environment: ASP.NET, C#.NET, Windows 7, SQL Server 2008, Visual Studio 2008, HTML, XML Web Services, WCF, MS Visio, AJAX, DCOM

Sonata Software, India July 2008 – May 2010

Software Engineer

Responsibilities:

Responsible for gathering the requirements, design and analysis of the client specifications.

Used front end web development tools like CSS, JavaScript, DHTML, and JQuery.

Used C# .Net and ASP .Net to design and develop the User Interface.

Worked with Custom Controls, Validation Controls, Web Controls, Html Server Controls, and Data Grids.

Created ASP.NET pages, which gathers input from GUI components and stores them into database.

Developed C# components to implement the business logic, consumed instances of these using ASP.NET.

Used LINQ to query against strongly typed collections of object and various data source, XML documents, Web services, ADO.NET Objects and Entity Framework.

Handle Cross Browsers Issues by working on Master Pages, style sheets, various client side interfacing using DOM standards.

Developed a module for XML input/output processing, third party input processing (Web Services, C#).

Involved in developing Web Services using C#.

Involved in the development of back-end stored procedures using TSQL, which were accessed by the ADO.net components from the business layer and in turn by ASP.net pages.

Involved in developing user controls.

Used ADO.Net objects such as Dataset, Data Adapter and Data Reader to create generic secure and reusable data access component.

Created and tested data driven Unit tests for the web application using Visual Studio 2008.

Interacted with the clients to understand their requirements.

Environment: C#, ADO.NET, ASP.Net, C.S.S, DHTML, JQuery, SQL Server2008, XML, SOAP, Windows XP



Contact this candidate