Sql Server .Net

Samba Siva

Sr.Net Developer

Contact Details: C2C

Name: Sambasiva Rao

Mail ID: *****************@*****.***

Phone :862-***-****

Professional Summary:

8+ years of IT experience with exceptional skills in Analysis, Design and Development of high scalable Multi-tiered Web Applications, Distributed Applications and Web Services using Microsoft Technologies in Finance, Banking, Telecom and Healthcare domains.

Expertise in developing Web-based and Windows-based applications using C#, VB.NET, ASP.NET,AJAX, UML, JavaScript, VBScript, XML, CSS, AngularJS, DevEx 11.1.8, SQL-Server 2010/2008/2005, Oracle 11g/10g/9i and Visual Studio 2010/2008/2005.

Hands-on experience inC#, MVC, ASP.NET 2.0/3.5/4.0, WEB API, WPF (Windows Presentation Foundation), Silverlight, MVVM, WCF (Windows Communication Foundation), Angular JS, LINQ, Entity Framework, SQL SERVER 2008

Extensive experience in developing User Interfaces using Bootstrap 3.2, AngularJS, ASP.NET, AJAX, JQuery, XML, HTML5/DHTML, CSS, JavaScript and AngularJS and Backbone.

Experience with ORM and its related components Entity Framework 4.3/5.0/6.0, Language-Integrated Query (LINQ)and retrieve data from different data sources (LINQ to Objects, LINQ to XML, and LINQ to SQL), ASP.NET Providers and Typed Datasets.

Experience in implementing the MVC 3.0/4.0/5.0 design pattern to standardize the application architecture.

Extensive experience in design and development of MVC and Web Form applications.

Good Experience in MVC framework to reduce the complexity and to get full control over the behavior of the application.

Extensive working experiencewith different methodologies like Agile (Scrum), Test-driven development (TDD) and Waterfall methodologies.

Very Good Experience in creating and consuming web services and WCF SOAP, REST, WEB API services.

Expertise in Developing WCF Services that implement the Service-Oriented Architecture (SOA).

Worked extensively on server controls and implemented various user controls using both C# and VB. NET.

Extensively worked ASP.NET MVC4applications 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.

Extensively workedon AngularJS framework in ASP pages to run as Offline Application in browser that avoid IIS dependency installation and configuration.

Expertise in developingAngularJS as the development framework to build a single-page application.

Worked directly with the Azure Product team in tracking and resolving defects.

Experience in database design and implementing Administration and database objects like stored procedures, functions, triggers and constraints.

Extensive experience in.NET using C#, ASP.NET, VB.NET, ADO, Web Forms and Web Controls.

Hands on experience using Source Code Control Systems like Microsoft Visual Source Safe and Microsoft Team Foundation Server.

Ability to prioritize tasks/Multitask and execute them to perfection and able to work in a high pressure environment and capable of working in a team and as an individual.

Excellent Interpersonal and Communication skills coupled with strong technical and problem solving capabilities.

Technical Skills:

Programming Languages : C#.Net(4.5/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, MVC 5.0/4.0/3.0, Ajax 3.0/2.0, Javascript, Jquery,AngularJS, VB Script, Bootstrap, Backbone, HTML5, CSS3

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

UI Technologies : Winforms,WPF, MVVM.

IDE Tools : Visual Studio 2013/2012/2010, DevExpress, SQL Server Management Studio, Expression Blend (4.0/3.0)

Database : SQL Server 2008/2005/2000(T-SQL), Oracle 11g/10g/9i (PL/SQL), MS Access.

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

Enterprise Servers : Microsoft IIS(7.0/6.0/5.0),Windows Server 2008/2003/NT

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

Middleware : WCF, ADO.NET 4.0/3.5/3.0/2.0, MSMQ, Web Services,Web API, LINQ, LINQ to XML, LINQ to ENTITIES, Enterprise Library.

Design concepts : Design patterns, UML,MS Visio 2010/2007.

Project Summary:

Client:Tiffany & Co.,Parsippany, NJ Oct 2015-till Date

Role: .Net Developer

Responsibilities:

Worked with Business Analyst's and Project managers to drive out requirements and implemented an elegant solution to the task at hand.

Used JavaScript, Angular, Bootstrap, Backbone, HTML5, and CSS3 for frontend development.

Used Web API as an ideal platform in building Restful applications on .NET Framework.

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

Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

Implemented View Model patterns/ in creating and managing Views, Partial Views, View Models, Web APIs using ASP.NET MVC, Custom Error Pages.

Created AngularJS Controllers, Scope, Model, view, Services, Factory etc., which Isolate scopes perform operations in UI.

Implemented Entity Framework Code First Approach with Repository Pattern and its implementation over the Business and Presentation layers.

Implemented Entity Framework Migrations to enforce the frequent changes in Conceputal layer changes to database.

Created and consumedASP.NET Web services and implemented REST full Web API/WCF services for service layer, created Action filters and Exception filters to implement REST API.

Enterprise n-tier software agent using Windows Communication Foundation (WCF) web service hosted on IIS.

Created Stored Procedures, Functions, and Triggers using T-SQL in SQL Server 2008 to insert, update, and delete data inside tables.

Development of enterprise reports by pulling data from various sources and presenting in SQL Server Reporting Services (SSRS).

Extensively used DevEx 11.1.8 for information gathering.

Built Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.

Responsible for maintaining versions of source code using Team Foundation Server.

Prepared WCF Service layer to handle client-service interaction. Involved package creation and deployment.

Created & hosted WCF Services and also used different bindings to make it available to different types of clients

Leveraged WCF mechanisms like sessioning, Instance management, and concurrency to make our services more robust and scalable

Created the link servers to pull the data from different data sources and used them in the stored procedure which will be executing on the scheduled basis through SQL agent

Created automatically running stored procedures for day-end operation using SQL Server agent

Created new tables, wrote stored procedures for applications and some user defined functions

Responsible in developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL server 2012. Involved in Troubleshooting and Debugging of the application within stipulated time.

Created automated Unit test plans and performed Unit testing modules according to the requirements and development standards with NUnit testing.

Environment:Visual Studio 2013/2012, C#, ASP.NET MVC 5.0/4.0, Entity Framework 6.0/4.3, WCF, WEB API, TFS 2013, AngularJS, Backbone, JQuery, Microsoft Enterprise Library, IIS 7.0, HTML 5, DOM, DHTML, XHTML, Rest Web Services, LINQ to Entities,Microsoft Windows Azure, SQL Server 2008 R2.

Client: Cydcor, Agoura Hills, CA. April2014- Aug 2015

Role: Sr.Net Developer

Responsibilities:

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

Developed screens on Client/Server Applications.

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

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

Implemented and consumed Web Services using WCF.

Developed and maintained Web Forms with ASP.Net, Angular JS, Silverlight, IIS 7.0/6.0./5.0 and C#.Net.

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

Built Data Sync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure.

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.

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 class Libraries using C#.NET to implement Business Logic.

Involved in using DI framework, LINQ and Entity Framework.

Design and develop Databases, Tables, Stored procedures, triggers, cursors SQL Server.

Developed complex stored procedures using temporary tables and loops using SQL and PL/SQL.

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

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

Environment:ASP.NET, C#, VB.NET, ADO.NET, Visual Studio 2013/2012/2010, Microsoft Windows Azure, SQL server 2008, T-SQL, ADO.NET entity framework, .NET Framework 3.5/4.0, AJAX, XML, XSLT, JavaScript, SOAP, Angular JS, Web Service, Web API, WCF 3.0, SOA, SILVERLIGHT.

Client: Home Depot, Atlanta, GA Sept 2012 – Mar 2014

Role: Sr.Net Developer

Responsibilities:

Used AngularJS framework for validating the required fields and check the duplicate records in client side validation.

Developed cross browser compatible, customer facing online application based on N–Tier Architecture.

Dealt with Bootstrap to present the application in a visually appealing manner and to render customer information as users were adding details to their profile.

Generated business objects in DAL layer to implement more functionality in Entities.

Used Interfaces, Delegates, Generics and Collections in the business logic layer.

Maintaining the version of the project in Team Foundation Server (TFS) by merging the module developed with latest version in TFS.

Designed and developed Services using WCF and also leveraged WCF security mechanism at transport level with windows authentication type for our intranet applications.

Implemented debugging and exception logging mechanisms modules for WCF services which will be used in Business to Business services to save time and cost.

Implemented various endpoints to establish communication with multiple transport protocols.

Implemented Layouts and partial view to maintain the consistent look and feel for Razor Web pages.

Implemented Controllers and Actionresults and Custom Action Filters and Routing Mechanisms.

Implemented Custom httphelpers and strong typed helpers in Views.

Providing Release Management and Build Automation with TFS 2013 Build Automation.

Responsible for Automated Staging Server Version Deployment to Production.

Writing Stored Procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages SQL Scripts.

Creating – Tables, Indexes, Views, User defined functions, Triggers, Parameterized Stored Procedures, Constraints and Roles.

Developed procedures and functions for business &data transactions with Error Handling.

Used Re-Sharper and Style Cop for code enhancement Designed and coded application components in an Agile environment.

Environment: .NET Framework 4.0, Visual Studio 2012, ASP.NET 4.0, C# 4.5, HTML, CSS, WCF, SOAP UI, XML, LINQ, SQL Server 2008, SSRS, ORACLE11G, PL/SQL and TFS.

Client:Intense Technologies Limited May 2010 – Sept 2012

Role: .Net Programmer

Responsibilities:

Involved in Analysis, Design, Coding, and Testing and maintenance phase of modules of software life cycle.

Designed and developed complete front-end application using VB.NET Web Forms.

Developed the components for middle tier (Business Layer) using VB.NET.

Designed web forms by implementing CSS, HTML and JavaScript.

Created User Controls for the header and footer of the website which appears in all the pages.

Worked extensively on web forms and data binding controls like data list and drop down boxes. Used pagination and sorting features of data grid in reports.

Designed and developed stored procedures and User defined functions SQL Server Database. Implemented role based security and customizable workflows based on a user's role.

Created queries and stored procedures in the SQL Server Database

Implemented validation using ASP.NET validation controls.

Extensively worked on ADO.NET objects.

Environment:ASP.NET 2.0, ADO.NET, C#, VB.NET 2005, .NET Framework 2.0, XML, MS SQL Server 2000, SQL, IIS6.0, WINDOWS 2000, SSRS 2005.

Client: Manhar Solutions, Hyderabad, India Mar 2008 – Apr2010

Role: Software Engineer

Responsibilities:

Responsible for Analysis, Design and Development.

Analysis and design for the enhancement of the system.

Handling Production issues and modifying the code according to the requirement.

Developed C# code for the project.

Engaged in development of web pages using ASP.NET, HTML, CSS and UI enhancement coding.

Designed and created the database for the tool.

Programmed ADO.NET for communication between application and the SQL Server.

Wrote stored procedures to handle data manipulations using TSQL.

Wrote test cases and performed regressiontesting.

Giving the production support and maintenance.

Bug fixing based on issue generated by the client.

Involved in Unit & Functional Testing.

Environment: VisualStudio.Net 2003, .Net Framework 1.1, C#, ASP.Net, ADO.Net, SQL Server 2005, IIS 5.0 CSS and VSS.

Contact this candidate