Sql Server .Net

SRIRAM SAKINALA

Email: ******.********@*****.*** Phone: 469-***-****

Professional Summary:

Over 4+ years of experience in design, development and testing of web applications using C#, ASP.NET Web Forms, ASP.NET MVC, ADO.NET, Entity Framework, JavaScript, JQuery, AngularJS, HTML5, CSS3, Bootstrap and SQL Server (2005/2008/2012)

Worked with Agile methodologies, waterfall methodologies and Test-Driven Development. Developed customized behaviours using scripting languages like jQuery, JavaScript, AngularJS

Working with Angular JS MVC architecture and also working with features like directives, views, scope, modules, dependency injection, factories, services and controllers.

Experience with ORM technologies like Entity Framework using Database First, Code First Approach.

Extensive experience and good practical knowledge on creating, managing and using database objects like Joins, Triggers Cursors, user defined data types and functions Stored Procedures, Functions and Indexes in SQL Server.

Implemented ADO.Net data access techniques i.e. SQL Connection Objects, SQL Command Objects, DataSet Objects, DataReader Objects and DataAdapter Objects using DataGrid and DataList in ADO.Net

Consumed some external Windows Communication Foundation (WCF) Services to write logs to the database.

Experience in data integration using SSIS

Implemented Restful services using ASP.NET Web API and Extensive experience of developing Web Services (SOAP and XML)

Expertise in creating views, partial views, strongly typed views, sections, and areas in ASP.NET MVC.

Proficient in Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction, Encapsulation and Polymorphism.

Proficient in Web Programming to enhance user experience using JavaScript, jQuery, Bootstrap, HTML5, AJAX, AJAX Toolkit and CSS3.

Experience in version control using Team Foundation Server (TFS), Microsoft Visual Source Safe (VSS) and Tortoise SVN.

Technical Summary:

Operating Systems :

Windows 2008/7/XP

Microsoft Technologies :

ASP.NET, C# NET, Ajax, Web Forms, MVC, ADO.NET, Entity Framework, Razor

Web Technologies :

HTML5, CSS3, XML, JavaScript, JQuery, AngularJS, Ajax, Bootstrap, SOAP, JSON

Scripting Languages :

JavaScript, AngularJS

Languages :

C#, SQL Server

Databases :

MS SQL Server 2005/2008/2012, Oracle

Web Servers :

IIS 7.5/7.0/6.0

IDE :

Visual Studio 2015/2013/2012/2010

Version Management :

TFS, SVN, Git

Web Services :

WebAPI,WCF, SOAP

Professional Experience:

JDA Software, Hyderabad Jan 2015-Dec 2015

Software Engineer Int

Description:

Open Access is a space and category management tool for creating and managing planograms and floorplans. Open Access is the web interface for viewing and editing the planograms and floorplans, downloading the required documents and layouts.

Module # 2: Developing Category Knowledge Base OA

Responsibilities

Used MVC (model-view-controller) architecture based development for creating Views and Partial Views – UI and middle tier for various modules.

Implemented Angular JS ngResource services to interact with Web API Restful services.

Implemented Angular JS Routing to create Dynamic Views and Navigation Menu.

Implemented Angular Grid using ngGrid module and added customized behaviour like

Inline editing using Angular Directives.

Utilized Angular JS Form validation techniques for client side validations before page post request.

Developed View-Models in order to restrict the controllers to control the dataflow between the model and view.

Design and building of Restful services using ASP.NET Web API

Designed and Developed Logic to Implement Versioning and Security to Web API Controllers.

Implemented Entity Framework and LINQ to interact with database objects and perform CRUD Operations.

Implemented Angular directives for DOM manipulation and Implemented Controllers and Scope objects for two way data binding.

Implemented Angular transclude functionality for consistent look.

Developed ASP.NET MVC Grid and Custom helpers to display data and add custom events and handlers.

Developed Model classes and added Data Annotations to provide server side validations.

Developed MVC Custom Action and Result Filters to add extra processing logic.

Environment: Net Framework 4.0, C#.Net, Visual Studio 2012, ASP.NET 4.0, MVC, JavaScript, AJAX, jQuery, HTML 5, IIS, XML, SOAP, SQL Server 2012, LINQ, TFS.

Module # 1: Developing Intactix Knowledge Base Open Access July 2014-Jan 2015

Responsibilities

Developed HTTP Exception Modules, AntiCSRF and Authentication Modules based on .NET Security features

Implemented Publish Subscribe Design Patterns to enable communication between User Controls.

Implemented Code to develop ASP.NET dynamic controls and Save State Information using Page Life Cycle events.

Implemented Multicast delegates to handle Post back events and render User Controls.

Developed and designed various classes in C# .NET to render dynamic pages using Reflection.

Used TFS for the purpose of project tracking and Source Control.

Used various XMLserialization mechanism for serializing and deserializing custom classes and structures.

Used ADO.NET objects to retrieve data and LINQ to manipulate data from the database.

Developed and Designed C# classes to perform Asynchronous operations using .NET

Task API.

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

javaScript.

Used JQuery UI libraries to develop UI controls like modal dialog and Widget Controls.

Implemented Bootstrap for responsive UI design, so that application can be used from various browsers with devices like computer, tablets, mobiles.

Implemented HTML5 Drag and Drop events to provide a dynamic details view of objects.

Designed and developed WCF Web Services and configured our WCF Services with appropriate endpoints for consuming them in the web application.

Environment: Net Framework 4.0, C#.Net, Visual Studio 2012, ASP.NET 4.0, MVC, JavaScript, AJAX, jQuery, HTML 5, IIS, XML, SOAP, SQL Server 2012, LINQ, TFS.

Sumtotal Systems, Hyderabad

Software Design Engineer-1

Description:

SumTotal learning management system (LMS) solutions help the clients to build a complete platform for developing more competitive employee skills and Open Activity Architecture which lets the clients effortlessly create business-specific workflows and complex curriculums. This Application Maintains all the training details of the employees in an organization and lets the managers & Administrators to assess their direct reporters and to assign new learning activities to employees based on the skills they have to acquire. LMS allows the employees to get the 360 degree review on their skill sets which improve the productivity of individual in the organizations.

Module # 2: Developing Learning Management Web Parts April 2013 – July 2014

Responsibilities:

Developed Authentication modules based on .NET Security features such as Forms-based Authentication and Role-based Authorization.

Understanding the functional requirements, studying the system specifications and designing the Object Model for the software using Object Oriented Techniques with the 3 - tier architecture

Performed extensive Data Binding with various Server Controls like Grid View.

Implemented Ajax Control Toolkit extenders to extend the flexibility of ASP.NET Controls.

Developed presentation layer using Server-controls, HTML Controls, User Controls and Custom Controls.

Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set and Data Table for consistent access to SQL data sources

Created Views and Partial Views – UI and middle tier for various modules using C#, MVC 3 (Razor View Engine), AJAX, jQuery, HTML, CSS.

Used SVN Tortoise for the purpose of project tracking and Source Control

Developed complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User

Defined Functions to implement the business logic.

Implemented business logic as .NET Framework assemblies using C#.NET.

Developed View-Models in order to restrict the controllers to control the dataflow between the model and view.

Environment: .NET 3.5; C#; Visual Studio 2005/2008; SQL Server Management Studio 2005/2008; ADO.NET; SQL Profiler

Module # 1: Developing Training Management Module ELMS Oct 2011-March 2013

Responsibilities:

Designed and developed the necessary front end screens and involved in Database design.

Designed the custom application pages using ASP.NET, HTML, JavaScript and AJAX with C#.NET as code behind.

Implemented ADO.Net SQL Client objects like Command, Data Adapter, Dataset, and Data Reader for database connection and executed database queries to interact with SQL Server database.

Developed Web Services to encapsulate business logic components to be used in a

Distributed environment using C#.Net and exposed them through SOAP and XML.

Master Pages were developed and used for uniformity and CSS were coded and used for implementing themes.

Developed complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.

Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.

Developed SQL Scripts using correlated queries and complex joins on related tables to identify the data corruptions on Production Database.

Involved in performance tuning of SQL Queries and Stored Procedure by creating indexes on tables and optimizing the queries.

Analysing the Customer Defects by debugging the Stored Procedures and tables in the Database and providing them the Hotfixes (patches) in order to fix their Defects.

Troubleshooting & debugging the DB Stored Procedures and C# code (using visual studio) to find out the root cause of the defects and fixing them in the core Product by modifying the code appropriately.

Designed and developed front end GUI using Windows forms (Win Forms) using C#.

Environment: .NET 3.5; C#; Visual Studio 2005/2008; SQL Server Management Studio 2005/2008; ADO.NET; SQL Profiler

Education details:

Master of Computer and Information Sciences (MCIS) December 2016

Southern Arkansas University Magnolia, Arkansas GPA: 3.9

Bachelor of Technology (B.tech) May 2011

National Institute of Technology - Bhopal, India GPA: 3.3

Contact this candidate