Sql Server .Net

DINESH

Sr. Dot Net developer

E-Mail: ******.******@*****.***

Contact: 872-***-****

8+ Years of IT Experience in Requirement Analysis, Design, Development, Implementation of Web-based and Windows based, Client-Server and n-tier Applications.

Proficiency in Software Development Life Cycle (SDLC) and AGILE methodologies of development process such as requirement analysis & definition, prototyping, proof of concept, designing, coding, testing and implementation.

Hands-on experience in UI Design using Win Forms, Web Forms, and programming ASP.NET,C#.NET, VB.NET,ADO.NET,MVC, JavaScript, LINQ, AJAX, jQuery by using .Net Framework 4.5/4.0/3.5/3.0/2.0., HTML, Oracle 11g/10g/9i, MS SQL Server 2012/2008/2005 and ADO.NET.

Expertise in Microsoft .Net technologies C#, ASP.NET, VB.NET, ADO.NET, Angular JS, Web Services and Windows Communication Foundation (WCF) and WPF.

Good work experience in MS SQL Server 2008/2005/2000 and Oracle 11g/10g/9i. Knowledge in developing stored procedures functions and triggers using T-SQL and PL/SQL.

Extensively worked ASP.NET MVC4 applications using Database Code First Approach in Entity Framework 4.3/5.0, and UI in Razor View Engine and client side framework AngularJS, Bootstrap, HTML 5

Solid knowledge and experience with Web Forms, LINQ, CSS, AJAX, IIS, JavaScript, UI design and development, consuming and manipulating data using ADO. NET.

Proficient with WCF, Web Services using WSDL, SOAP and UDDI.

Experience in web development using HTML, XHTML, DHTML, XML, XSD, X-Path and XSLT.

Expertise in Design and Development of User Interfaces, User Controls and Custom Controls using SILVERLIGHT 3.0, 4.0 / WPF and C#.

Experience in testing tools like N-Unit, Microsoft Testing Tools.

Implemented AJAX functionality to improve the responsiveness.

Experience in working with SQL Server 2008 R2/2005/2000, Oracle 9i, databases and writing complex queries, stored procedure.

Expertise in Web-Development technologies like HTML, XHTML, CSS, ASP, XAML, XML, XSL, XSLT, JQuery, JavaScript, AJAX Control toolkit.

Conduct requirements gathering, design, development, testing and documentation for various CRM/.Net./MS Dynamics projects.

Experienced in developing web applications using .NET Framework 2.0/3.0, 3.5 and 4.0, ASP.Net, C#, ADO.Net, XML, XSLT, Java Script, HTML 4/5, CSS, jQuery, JSON, AJAX and IIS.

Experience in Object Oriented Analysis and Design methodology with strong knowledge and experience with the Design Patterns including Structural, Creational and Behavioural Patterns like Model viewer Controller (MVC).

Experience and good understanding in developing(SOA) Service Oriented Architecture, Web Services, .NET Remoting, SOAP, WSDL, UDDI and DOM.

Good hands on Graphical User Interface (GUI) Design using technologies like HTML, Silverlight, CSS, JavaScript, AJAX Controls, WPF (Windows Presentation Foundation).

Expertise using Angular JS Framework and ASP.NET Web API with ASP.NET MVC Architecture in designing web applications.

Experienced in methodologies like Agile, Waterfall and Scrum.

Strong Experience in developing applications using C, C++, C# on Windows Systems.

Enthusiastic and Quick to learn new applications and tools and willing to take individual responsibilities.

A 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.

Technical Skills:

Programming Languages

:

C#.Net (4.0/3.5/3.0),VB.NET(10.0/9.0/8.0), HTML, T-Sql, PL/SQL.

Web Technologies

:

ASP.NET 4.5/4.0/3.5/3.0/2.0, ASP.NET MVC 5.0/4.0/3.0, Silverlight 4.0/3.0, ASP.Net, Ajax 3.0/2.0, Azure, Javascript, Jquery, VB Script, AngularJS.

Xml Technologies

:

XAML, XML, XSLT, XSL, LINQ to XML.

UI Technologies

:

Winforms, WPF, Jquery UI.

IDE Tools

:

Visual Studio 2013/2012/2010/2008, Sql Server Management Studio.

Databases

:

MS SQL SERVER 2012/2008/2005/2000, Oracle 11g/10g/9i/8i,

MS Access 2010/2007/2003, Cassandra.

Reporting Tools

:

Sql Server Reporting Services (SSRS 2008/2005), Crystal Reports.

Version Control Tools

:

Visual SourceSafe (2005), Team Foundation Server (2008), SubVersion.

Modeling Tools

:

UML, MS Visio 2010/2007.

Middleware

:

WCF, ADO.NET 4.0/3.5/3.0/2.0, MSMQ, Web Services.

Servers

:

Windows Server 2008/2003/NT, Microsoft IIS (7.0/6.0/5.0/4.0).

PROFESSIONAL EXPERIENCE

Client: M&T BANK, Buffalo, NY Dec 2015 to Till date

Role: Sr.Dot Net Developer

Responsibilities:

Analyzing and understanding the business requirements documents designed by the application architects and business analysts by following AGILE methodology.

Supporting end users by analyzing and resolving production issues.

Preparing design and test summary documents for the implemented development changes and also tests summary documents.

Designed & Developed Components using C#.NET,ADO.NET

Responsible for Designing & developing Web user Controls in .NET 4.5 Framework using ASP.NET.

Development of views, models and controllers.

Implemented User Management pages like Create Users, Modify Users and Assign Roles using ASP.NET controls.

Implemented Cascading Style Sheets (CSS), HTML to attain uniformity of all web pages.

Developed complex MVC Controller, View Models and Helper methods linked to backend database.

Created Application Pools in the IIS7 to Bridge the application, where the WCF Services are called from different Projects.

Used Ajax control took kit to develop rich user interface experience.

Implemented CRUD functionality with Entity framework in ASP.NET MVC5 and implemented sorting, filtering and paging with Entity framework in MVC5/4.

Created web methods in WCF Service using .Net and added caching in WCF Service using Memory Cache.

Implemented forms based authentication to perform authentication and authorization.

Used ADO.NET and entity framework for database interaction

Developed pages using Angular JS Data-binding, Filters, Directives, and Expressions.

Client-side web development using HTML5, CSS3.

Created web methods in WCF Service using .Net and added caching in WCF Service using Memory Cache.

Worked with Team Foundation Server 2013 for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Designed and implemented Data access layers (model) using LINQ to XML, LINQ to SQL.

Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL Server 2013.

Involve in Web Service unit testing using soap UI tool.

Used TFS for maintaining versions of code.

Performed Code review and Unit testing for better performance.

Designed Web form’s input validation using the ASP.Net Input Validation Controls and dynamic features using Ajax, JavaScript and MS Enterprise Library 4.0(Validation Block)

Environment: ASP.Net MVC5/4, C#, Javascript, Ajax, JQuery, XML, NHibernate, CSS, LINQ, XML, T-SQL, WCF Services, HTML, TFS Server 2013, SQL Server 2012/2010/2008, Oracle 11g/10g, Angular JS.

Cerner Corp, Kansas City, MO Nov 2014 – Dec 2015

Sr .Net Developer

Responsibilities:

Understanding the requirements from FSD (Business Analyst) and prepared Technical Spec, Estimation, Coding and Unit Testing.

Writing complex controllers & consuming Web API methods in ASP.NET MVC 4.0.

Involved in development of Presentation Layer, Business Logic Layer, Data Access Layer and various other tiers of N-Tired application.

Designed and developed abstract classes, interfaces, classes to construct the business logic using Object Oriented Concepts.

Used Model View Controller (MVC) design pattern to develop a complex web application, ASP.NET with C# as code behind AngularJS, is used for client side validation.

Modified web services to interact with the other applications and exposed them using SOAP and HTTP.

Developed user interface screens under Visual Studio.NET 2013 using ASP.NET and C#.

Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

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

Created Application Pools in the IIS7 to Bridge the application, where the WCF Services are called from different Projects.

.Net Framework 4.5/4.0/3.5/3.0, Windows Communication Foundation (WCF) and ASP.NET and new C# 4.0 features like LINQ, Entity Frame Work and NHibernate.

Involved in user validations and authentications through LDAP (Lightweight Directory Access Protocol).

Worked with Team Foundation Server 2013 for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

Designed Graphical User Interface (GUI) using Layout Pages, HTML, HTML 5 JavaScript and CSS.

Create SQL based reports using SQL Server Reporting Services (SSRS) with parameters and stored procedures.

Involved in writing queries, Indexes, triggers, views, functions, stored procedures in Transact SQL and PL/SQL using SQL Server 2000/2005/2008/2012, Oracle 11g/10g/9i.

Extensively Worked on Agile and Scrum methodology.

Coded and created Stored Procedures for performing repetitive tasks in updating related tables using SQL Server 2012.

Implemented Eager Loading and Explicit Loading, Compiled queries, Immediate Execution to improve performance to LINQ to Entities.

Sending Email alerts based on specific templates after transactions.

Performing peer code reviews.

Environment: Visual Studio 2013, C# 4.0, .Net Framework 4.5/4.0, ASP.NET MVC, Entity Frame Work 4.5/4.0/3.5/3.0, ADO.NET, LINQ, GUI, HTML, WCF, TFS, XML, AngularJS, Oracle 11g/10g/9i, SOAP, SQL Developer, AJAX, XSLT, SSRS, SQL Server 2012, Windows Server 2008/2008R/2005.

Michaels Stores Inc. Irving, TX Jun 2013 – Oct 2014

Sr .Net Developer

Responsibilities:

Involved in Sprint planning, Demo and Agile Scrum meetings. Had to interact and work with the offshore team in Costa Rica, gather status updates, assign tasks for the day and co-ordinate with the Hybris, ES and DB teams’ onsite.

Developed Enterprise Service (ES) layer which is a RESTFul service layer. ES acts as a bridge between the Hybris UI and the SQL database layer.

Effectively involved in various stages of SDLC (Agile) Development methodology.

Developed screens on Client/Server Applications.

Created Views on UI by utilizing MVC 4, created View models and wrote client side validations using AJAX, JQuery.

Developed Applications using VB.Net, .NET Framework 3.5, Object Oriented Principles and n-tier architecture.

Designed, developed and trouble-shoot the application using advanced Microsoft technologies such as ASP.NET MVC 3/4, JavaScript, JQuery, AJAX, HTML Razor, XML, WCF and CSS using Agile development practices and OOPs.

Leveraged AngularJS for scripting, AJAX calls and JSON and XML for passing objects from Controller to View and vice versa.

Used Windows Azure to store the Images in the blob, Creating Worker Roles, Instances

Designed Graphical User Interface for various web pages using AJAX, HTML, CSS, JavaScript and SILVERLIGHT.

Created RestFul services using web API to interact with business layer.

Used ADO.NET Entity Framework for abstracting data stored in Database.

Developed and consumed WCF series (ASP.NET 3.5) to achieve service oriented architecture and communication between heterogeneous applications.

Used ASP.NET and C# for the front end presentation and Server Side Processing.

Developed Web Services for obtaining structured data for financial information.

Developed client side validation and dynamic UI using JavaScript and HTML5 and DHTML.

SQL Server 2005 Enterprise Manager was used to create objects like tables, stored procedures, etc.

Experienced in other RDBMS like Oracle (SQL, PL/SQL, Forms, win forms, web forms and Reports).

Developed design patterns such as Singleton pattern for application reuse and extensibility.

Designed WCF the front end using XAML Browser WPF and SILVERLIGHT for Rich UI.

Utilized XAML WCF, WPF based Event Handlers.

Developed XML Web Services and WCF services common for various applications using .NET Framework.

Designed and implemented test cases and involved in Unit testing documentation.

Performed MVC Unit testing to ensure the application functioned as per the design and requirement.

Developed Role based Security to authorize member to a specific role.

Designed and developed ASP.NET web application(C# code).

Developed class Libraries using C#.NET to implement Business Logic.

Involved in using DI framework, LINQ and Entity Framework.

Developed runtime animations using MS SILVERLIGHT 3.0 using MS expression Blend 2 SP1.

Developed the SILVERLIGHT application on Model-View-View Model (MVVM) design pattern.

Involved in e-commerce web applications.

Integrating procedural steps and process with technical requirements and system functions to assure successful delivery of work has been done.

Heavily used LINQ to SQL to retrieve data about Customers and Transactions.

Participated in code review.

Environment:ASP.NET, C#, VB.NET, ADO.NET, MVC 3/4, Visual Studio 2013/2012/2010, SQL server 2008, T-SQL, Oracle 11g/10g/9i, ADO.NET entity framework, .NET Framework 4.0, Azure, AJAX, XML, XSLT, JavaScript, JQuery, AngularJS, SOAP, Web Service, Web API, WCF 3.0, SOA, SILVERLIGHT 4, XAML, HTML, LINQ, IIS 6.0,TFS, API, FILENET, Load Balance and Clustering.

Proximedics, Pittsburgh, PA Nov 2011 - May 2013

.Net developer

Responsibilities:

Interfacing with business for analyzing business processes and creating business/functional requirements documents for the same.

Creating design prototypes, site navigation and layout of content for the application

Coding modules in C# to develop pages (Web Forms) for the application. Used master pages, web server controls, web user controls, validation controls, AJAX and JavaScript/JQuery.

Worked on supporting existing Application and gathering requirements from business and working with them to design according to the requirement.

Used the current build to get the latest version of the development that is done every day and worked on that development.

Resolved some of the web page errors that are obtained while running the web page.

Worked on the serialization of the objects on all the pages of the Application.

Worked on de-serialization of all the serialized objects that are occurred while serializing the objects in the web pages.

Worked on testing all the Pages of the project by using the testing tools.

Developed User Interface using C#.

Used Microsoft silver light technology to get the rich user interface.

Developed WPF application using Control Templates, Data Templates, Bindings, Converters, Routed Events, Command bindings, Commands and new features like LINQ and lambda expressions.

Develop applications using C#, design patterns, OO methods, stored procedures, and TSQL.

Participated in Test Driven Development (TDD) in developing a WPF application in Agile (SCRUM) environment strictly following the MVVM pattern.

Developed XML based .Net assemblies using C#.

Used Team Foundation Server (TFS) to manage changes to the source code.

Handled Run Time Errors & Design Time Errors by implementing appropriate custom Error Handlers.

Worked on unit, testing integration testing.

Created and consumed WCF Web Services to expose the application functionality for different applications running inside the company & outside, implementing a Service Oriented Architecture (SOA).

Applied the business logic to approve client’s policy and made it available to the WPF front-end by implementing WCF services.

Worked with LINQ and Entity Framework.

Developed custom reports using SSRS.

Used SQL Server Integration Services (SSIS) to solve complex business problems by copying or downloading files, sending e-mail messages in response to events.

Using Subversion for storage of files of application and version control

Involved in optimization of .NET applications and improving system and database performance.

Environment: Visual Studio 2010, WPF, WCF, C#, VB.NET, .Net Framework 3.5/4.0, Oracle 10g/9i, SQL Server 2008, Framework, AJAX, Java Script, SSIS, XML, TFS..

Sonata Software, Bangalore, India Oct 2009 - Oct 2011

.Net Developer

Responsibilities:

Worked in an agile Environment to deliver higher-quality software far more rapidly.

Involved in development of Web Forms, Classes using C# that incorporates both N-tier architecture and database connectivity.

Used Silverlight banners, Buttons, etc for enhanced user experience.

The web GUI was built using Silverlight, XAML, HTML, DHTML, Web Forms classes and AJAX control for providing a consistent look and their individual states persisted across sessions, thus saving individual preferences and providing a smooth navigation experience.

Developed ASP.Net pages using ASP.NET, web form controls, Custom user Controls, HTML server controls in C#.

Created event driven Web Forms using ASP.NET and implemented form validation using Validation controls using both Custom validation and JavaScript was written for Client side validations and also used the new validation controls in VS 2008/2010.

Enhanced and developed UI functionality using ASP.NET (3.0/2.0), HTML, and XML.

Used Silverlight Layout Panels and Control Templates for Customization.

Developed Web Services and invoking them by using XML SOAP and WSDL tool for creating proxy classes.

Designed & Deployed SQL Server Integration Services (SSIS) packages for updating the PO and Sales records from Excel to SQL database. Implemented check-points, scheduled using SQL Server Agent.

Expertise in Winforms applications, ASP.NET, XML, ADO.NET and TFS.

Implemented the SQL automation from VSTS2008 tool using ADO.net connections

Used Web Services (SOAP, WSDL) for communicating with other application and components.

Created CSS files to be applied to various web forms on the web pages.

Generated Crystal Reports for Job purpose.

Extensively used Web Services, SOAP, XML and XSL to expose the reports to facilitate information sharing.

Used Visual Studio.NET 2005 IDE to design the forms, develop and debug the application.

Involved in building a rich web experiences using JavaScript.

Deployed web application on Internet Information Server for production.

Used Ajax tool kit, Multi views, regular expressions, regular expression validates, user search controls

Extensively used ADO.NET, XML In Order to get the high level performance for the web controls.

Created Crystal reports on the web page by accessing the database.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL-SQL in Development and Production environment for SQL 2008/2010.

Environment: Visual Studio 2008/2010, C#, COM, ASP.Net 3.0/2.0, ADO.Net, XML, SQL 2008/2010,Visual Source Safe, IIS6.0, Windows Server 2003, Web Services, SOAP, Web Forms, CSS, Silverlight 1.0, Team foundation Server, VSTS2008.

Vsplash Techlabs Pvt Ltd, Hyderabad India Jul 2007 – Sep 2009

Software Engineer

Responsibilities:

Involved in analysis (policy & business rules) design and development using Agile methodology (N-tier).

Extensively used UML diagrams for designing the system based on the business rules.

Extensively worked on web forms to provide login credentials for agents.

Created XAML based browser application for agents to navigate between pages, insert client data and retrieve the result.

Developed user controls in (Controls) WPF to enrich the application interface.

Extensively worked on Windows services hosted on IIS to provide interaction between web form and policy rules.

Worked on XML, XSLT, WSDL to provide communication between presentation layer and application layer.

Extensively worked on ADO.Net entity framework to provide CRUD operations on policy holder’s data.

Created Data Access Layer for storing and fetching approved data from the database.

Used Asp.Net Validation, Validation Summary and Custom controls for validating entered field data by agents before submitting.

Used Crystal reports to represent calculated data in a format that is easy to interpret and distribute.

Created custom test cases for testing system reliability and also conducted training sessions for users.

Environment: C#, .Net Framework 3.5,VS 2008, IIS, ADO.Net, MS SQL Server, WPF, XML, XSLT,WSDML, UML, N-tier, Agile, Crystal Reports

Contact this candidate