Sql Server .Net

Sudheer K

(.Net Developer)

Email: acz9c9@r.postjobfree.com

Phone: +1-804-***-****

Professional Summary:

Over 6+ years of experience as Full stack developer in .NET and related web technologies, JavaScript frameworks with emphasis in Healthcare and telecom domain. Experience in Design, Development, Implementation and Testing of Web Applications, Windows Applications and Client-Server in multiple Platforms.

Experience in SQL and NoSQL databases. Proficiency in writing PL/SQL in both SQL Server and Oracle. Participated in query optimization and performance tuning sessions while writing stored procedures Experience in MongoDB NoSQL.

Experience designing and developing Winforms and Webforms and used Delegates and Events to establish communication between the Winforms.

Strong understanding of OOPS concepts and design implementations using UML.

Proficiency in .NET languages C#, VB.NET, web technologies ASP.NET (Web Forms and MVC), and Win Forms, WPF.

Experience in developing web-centric applications using JavaScript framework AngularJS, HTML5, JQuery, AJAX, Bootstrap, CSS. Experience hosting web applications in IIS, developing applications using the ASP.NET MVC.

Proficient in creating and consuming WCF, WebApi services and Node JS. Adept with the SOAP and REST services. Implemented Windows services.

Extensively implemented and consumed WEB API 1 and WEB API 2 versions, used HTTP methods (verbs-GET, PUT, POST, PATCH, DELETE) to do CRUD operations, supporting JSON or/and XML data exchange formats and also implemented Security, Caching features.

Extensive experience in development and optimizing of Queries using SQL Query Analyzer, Stored Procedures and Triggers.

Extensive experience in ORM, Entity Framework Code First, Database First approaches, implemented the Features Security, Performance, CRUD operations and Migrations etc.

Expertise on ADO.NET components such as Datasets, Data Adapter, Data Reader, Data View, Data Table.

Worked in Agile SDLC methodology, SCRUM framework and Test driven development (TDD) based on story points.

Developing and creating PHP applications as per the specifications and troubleshooting the problems with PHP and other web technologies.

Experience in UI, Components, Classes, Methods, and Functions for the application and also Functionalities such as Data retrieval using disconnected record sets, using ADO.NET, ASP.NET, Windows Forms, Web Forms, Server controls.

Experience in implementing Sitecore security and Sitecore search extension. Developed search appliance using Sitecore content search tools.

Familiar in updating, accessing and version controlling the code using Team Foundation Server (TFS), sub-version, Github and Gitlab. Did continuous integration using TeamCity and Jenkins

Experience in application design based on MVC, Factory, singleton, repository and IOC design Patterns and also implemented Controllers and Controller Actions, Filters, Routing.

Extensive Experience in Implementing View, Model, Controller and View model by using ASP.Net MVC Framework 5.0/4.0/3.0.

Experience developing Single Page Web Applications using Angular JS, Node JS and Backbone JS.

Coordinate with QA teams during testing and deployment and production support team during deployments and post production validation.

Hands on experience in UI technologies with Node JS, Angular JS and Bootstrap and Experience in unit testing JavaScript code with Jasmine.

Used Window azure to deploy the application on cloud and managing the session.

Called the restful Web API web service calls for POST, PUT, DELETE and GET methods.

Used Versata business rule designer for implementing business rules and developed application pages in versata as per technical requirements.

Used Backbone.js and ReactJS to create Controllers to handle events triggered by clients and send request to server.

Very well acquainted with the OOPS concepts like Inheritance, Polymorphism, Abstraction and encapsulation.

Used AngularJS framework to create a Single Page Application (SPA) which can bind data to specific views and synchronize data with server.

Responsible for all client side UI Validation and implementing business logic based on user selection using AngularJS, Bootstrap and Restful services.

Expertise in building Web Services using WSDL, UDDI, SOAP Protocol and consuming/publishing Web services Designed, modeled and architected enterprise n-tier software agent using WCF web service.

Expertise in implementing SOA using WCF technology developed and consumed WCF services with features versioning, security, optimization and reliability.

Experienced working with MS-SSIS and MS-SSRS for the data integration and data reporting services. Knowledge of creating reports with Crystal Reports 9/10.

Experience in web development using XML, XSD, X-Path and XSLT. Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SQL Server Integration Services (SSIS), BCP and DTS utility.

Hands on experience in working with development of Stored Procedures, Queries, Indexes, Triggers and Views using SQL Server 2008 and T-SQL.

Experience in interacting with Clients and Users for gathering requirements. Involved in writing Test plans, Test cases and interacted with business users to conduct User Acceptance Testing (UAT)

Valuable team player with Excellent Communication skills, Trouble shooting skills with ability to Learn and adapt to new technologies quickly.

Educational Qualifications:

Bachelor’s in computer science from Osmania University, India.

Technical Skills:

Programming Languages:

C#.NET, Visual Basic.NET, C, C++, Java, PHP, TSQL, PL/SQL

. NET Technologies:

ASP.NET, ADO.NET, VB.NET, LINQ, Ajax, Web Services, Silverlight, WPF, Prism.

Development Tools:

MS Visual Studio.NET 2013,2012, 2010/2008, Microsoft office suite, Sitecore CMS

Design Patterns:

MVVM, MVC

Reporting Tools:

MS-SQL Server Reporting Services (SSRS), Crystal Report

Database SQL Server:

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Web Servers:

I Microsoft IIS (5.0/6.0, 7.0, 7.5), Windows Server 2008/2003.

Web Technologies:

ASP, VB Script, JavaScript, HTML, DHTML, JSON, XML, Bootstrap, JQuery, Angular Js, Node Js, ReactJS,Knockout.js, Windows Azure, CSS.

Database:

MS-SQL Server 2012/2008/2005, Oracle, MS-Access 2000, MySQL

Operating System:

Windows 2000, XP Pro, UNIX.

Professional Experience:

CareCentrix, FL Nov 2015 – Till Date

Role: .Net Developer/Web Developer

Responsibilities:

Implemented MVC design pattern for developing the Web Application and used MVC5 application using Razor syntax for view engine and also used C# for the back end.

Implemented the DAL using the Entity Framework 4 Code-First paradigm, developed Controllers for the corresponding views.

Developed the application using ASP.NET MVC 4.0/5.0 with Razor syntax, C#.NET, AJAX, JQuery, JSON, HTML, JavaScript, Bootstrap and CSS.

Independently worked on developing document handler using the HTML5 Canvas.

Developed and Consumed XML Web Services (SOAP) and also involved in creating web site pages using ASP.net, AJAX, JavaScript, AngularJs, JQuery, HTML, and CSS.

Created the Editor and Display templates for MVC controls, designed UI pages with Razor views and partial views and have experience with AngularJs in two way data binding.

Used Web Api and also Telerik Grid Controls and also developed Web Api MVC4 application using C# .Net

Used Master Pages, shared layouts, CSS & Themes for the consistent look of the application

Created View models to encapsulate all models and classes used on the different views for a more organized, structured, and clean code.

Used JavaScript, AngularJS and AJAX technologies for front end user input validations and Restful web service calls.

Created WCF Services responsible for communicating and providing real time data from integrated server to Client Application.

Used Generics, Lambda Expressions, Extension Methods, LINQ to SQL, LINQ to Objects and consumed JSON objects to Views and partial Views for the UI layer.

Utilized Bootstrap CSS framework for the responsive display, cross browser functionality and for multiple devices compatibility

Developed rich client interface using WPF and extensively used WPF page layouts, creating custom controls.

Outstanding knowledge in Responsive Web Applications using CSS3 Media Queries and CSS Bootstrap.

Generated various reports using Microsoft SQL Server Reporting Services (SSRS), developed reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS) and also used Datasets for the SSRS reports.

Developed code to validate the user credentials for authenticating user to access the WCF service.

Improvised user experience using JQuery. Used JQuery event handling mechanism to dynamically assign events on web controls

Involved in writing complex SQL Statements, Views and Stored Procedures, Indexes to validate data and ensure system integrity and security Written LINQ functions for data access.

Developed test-driven development (TDD) strategy guiding use of the N-unit testing framework.

Used Team Foundation Server (TFS) for continuous integration and version control and used Fiddler to debug web request and responses and tracking all projects for seamless releases for Project Management System JIRA.

Participated in periodic technical reviews of various modules and developed schema to improve them

Actively participated in Scrum meetings of the project implemented in agile project management methodology.

Provided implementation support by attending defect and UAT meetings and participating in pilot/launch activities.

Environment: C#.net, ASP.NET MVC 5.0., TDD,.Net Framework 4.5/4.0, ADO.NET, SQL 2012, HTML, Angular Js, node js, Visual Studio 2013, MVC, XML, OOP, WCF, Web API,WPF, JIRA, SQL Server 2012, Agile.

T.Rowe_Price, Maryland Aug 2014 – Sep 2015

Role: UI Developer/.Net developer

Responsibilities:

Involved in gathering the requirements, analysis, design & development of the project and designed, developed and enhanced the application using .net framework 4.0 and visual studio 2012.

Used VB.NET and ADO.NET to define and implement Business Logic Layer and Data Access Layer.

Experienced in Developing and Enhancing Web forms, Master Pages, User Controls and Custom Controls by using HTML, CSS, and Asp.Net Controls.

Developed Bootstrap responsive web application pages using Angular-JS services, controllers and directives for front end UI and consumed REST web service API.

Implemented Server and Client side validations using ASP.NET MVC validation controls and JavaScript.

Development of various reports by pulling data from various sources using SQL Server Reporting Services (SSRS).

Involved in coding the various modules of the project in MVC, C# and Sitecore 7.1. Integration of the application.

Involved in integrating Sitecore with .NET for templates, layout, sub-layout, controls, control rendering, placeholder and content.

Used Backbone.js and ReactJS to create Controllers to handle events triggered by clients and send request to server.

Strong working knowledge of Rich UI applications based on latest UI technologies, libraries and frameworks.

Responsible for making Asp.net Web API calls using restful services with HTTP verbs which includes GET, POST, PUT, DELETE.

Used ReactJS to create views to hook up models to the DOM and synchronize data with server as a Single Page Application (SPA)

Used Visual Source Safe (VSS) for all the source code control among the whole team members.

Used Team Foundation Server (TFS) for Version Control, Team build, Project Management, Data Collection and Reporting.

Designed and developed several SQL Server stored procedures, functions and triggers for all the DML functionality for the web site.

Designed and built reliable, highly scalable, agile and flexible systems using an expressive query language using MongoDB.

Worked with version controller Team Foundation Server (TFS) for maintaining history of source-code and project documents.

Extensively worked with Forms Authentication and successfully implemented login mechanism for different levels and roles of users.

Worked on calling web methods (server side) from client side using Ajax page methods of script manager control.

Made extensive use of the Data grid objects to showcase the data and also for the user to be able to edit data and implemented LINQ to perform optimized database operations

Enhanced the applications performance by constantly monitoring the queries by running Execution plans and query optimization techniques in SQL server.

Worked with testing team to fix the bugs as part of bug life cycle and Production support and also involved in the Unit and Integration testing.

Environment: ASP.Net MVC 4.0, VB.NET, HTML, CSS, XML, AJAX, ADO.NET, Site Core, Web API, Type script WCF, JavaScript, Bootstrap, Mongo DB, VSS, SSRS, IIS, Team Foundation Sever, ReactJS,Visual Studio 2012

CMC limited, Hyderabad, India Sep 2013 -July 2014

Role: Software developer

Responsibilities:

Working through all phases of the application software development lifecycle (SDLC) including design, development, testing and deployment.

Involved in gathering business and technical requirements from both formal and sessions informal.

Used C#.net to create application and to insert records into database and developed & maintained Web Forms with C#.Net.

Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings based on this.

Experience in using Azure App Service as a cloud platform to build and deploy test and prototype systems.

Worked with XML and generated XSD, used XML validation and displayed the error log messages and also involved in using XML and XSLT Transformations.

Developed and consumed web services through Ajax, JQuery, SOAP and XML/WCF and used of Web Services and WCF Services for information sharing.

Created custom directives, decorators, and services using Angular-JS to interface with REST services.

Used Angular-JS form validations to validate the forms and used various Angular directives such as ng-app, ng-controller, ng-model, ng-bind, ng-show, ng-hide, ng-if etc.

Created SELECT, UPDATE and INSERT queries to update and insert the data into Informix tables and also developed service class in WCF service to get the XML nodes and store it in the database.

Developed business logic in the web-service to send the order details from the demand ware and also provide alert for new orders.

Use Bootstrap components like Grids, Wells, Tables, Dropdowns and Pagination to make the webpage responsive.

Involved in the hooking up the jQuery fusion charts to the grid for bar-charts, pie-charts etc. to show the monthly Gross revenue.

Integrate RESTful API requests and responses using JSON objects. Use AngularJS HTTP service to consume APIs in front-end.

Creation of an Intranet Portal using DotNetNuke, coding in VB.Net

Developed interfaces for passing data to and from demand ware and extensively worked with Informix database.

Write Functions and Stored Procedures for database operations and developed and used User controls and Custom controls in the application.

Involved in debugging, bug fixing & QA support, Used Agile SCRUM methodology for application development.

Environment: C#, Visual Studio 2010, DotNetNuke, Angular Framework, JQuery, WCF, Angular-Js, IIS, XML, XSD, XSLT, Informix, SQL Server 2008.

Bharti Airtel Ltd, Bangalore, India Dec 2011 – Aug 2013

Role: .Net developer

Responsibilities:

Involved in the development of dynamic ASPX web pages, retrieved data using ADO.Net with C#.Net.

Implemented technologies like HTML, Java Script and AJAX for rich UI experience and performed Forms Based Authentication and ensured Role Based Authorization.

Used CSS to obtain the uniformity throughout the application and created Charts using ASP.NET Chart Controls.

Written SQL Queries, Stored Procedures and Triggers for data Retrieval and data Insertion.

Developed and used User controls and Custom controls in the application.

Extensively used Web controls such as Grid view and Data list to populate the records for presentation layer

Implemented Server Side and Client Side validation modules using Validation Controls and JavaScript.

Develop web pages using C#.Net, ASP.Net, JavaScript in MS Visual Studio2008 and 2012 with Oracle, SQL as backend for data collection.

Implemented AJAX features to reduce full post back, for improving the efficiency and interactivity across web applications.

Created various stored procedures and triggers for data processing.

Extensively used Data Adapter and Dataset to access database and also involved in Documentation, Unit Testing and Integration Testing.

Participated in collaborative team environment with Team Foundation Server to create pages and created custom electronic Discovery operations reports with Crystal Report XIII

Participated in meetings with Business users and with other project teams to ensure that the volatile business requirements reflect in the project development.

Environment: Visual Studio .NET 2008, .NET Framework 3.5, WPF, ASP.NET 3.5, C#, ADO.NET, AJAX, JavaScript, CSS, Team Foundation Server, XML, Windows Presentation Forms, SQL Server 2008.

Automotive Property Consultancy Ltd., India Aug 2010 - Nov 2011

Role: .NET Developer

Responsibilities:

Developed web-based applications using ASP.NET written in VB.NET.

Read excel file using OLEDB class and retrieve data to Data table.

Analyzed and designed new WPF application using MVVM and Repository pattern, from design to completion.

Used Delegates and Events to establish communication between the Winforms. Designed and developed and developing webforms and Winforms

Admin can login into the system and retrieve from different excel sheet, Web forms with the filter and print options.

Made use of Data Grid control for paging and sorting of data in ASP.NET Web forms to view the excel data.

Download PDF using the response object and Data View, Data Table classes are used to retrieved and filter data.

Written Queries using 2SQL Statements, Views, User Defined Functions, Stored Procedures, Triggers in SQL Server 2008 for inserting/Updating/Deleting the data into the relational tables.

Created user level security in reports to allow restricted viewing to users of different levels and implemented data driven subscriptions using SSRS.

Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation using LINQ.

Used ASP.Net page pattern to add functionality to individual pages such as to accept input from the page request, invoke the requested actions on the controller.

Works with the Yahoo Finance stock quotes using YQL and jQuery. Spread Sheet settings for the Numeric and Date format for filter and Graph.

Used Versata business rule designer for implementing business-rules.

Developed Windows Forms (Win Forms) based upon the client request and Implemented graphical user interface (GUI) for web forms.

Created and maintained database objects like complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins.

Web based solutions for the Google graph report generation based on the given values.

Environment: .Net Framework 3.5, Versata, WPF, MS Visual Studio 2008, ADO.NET, Win Forms, C#.NET, VB.NET, ASP.NET, Google graph, SQL, Excel Sheet.

Contact this candidate