C# Sql Server

Swathi K Mobile: 615-***-****

Email: ***************@*****.***

Summary

•Around 6+ years of professional experience in developing and deploying the applications utilizing a variety of programming languages and in depth understanding of all the phases of developing and deploying (SDLC-Software Development Life Cycle), Client-Server and N-tier Architecture with Agile, Waterfall, Scrum.

•Prodigious working with basic MVC and all the MVC Frameworks like the 6.0/5.0, Implemented the components like the Model, Views, Partial Views, Strongly Typed Views and controller actions.

•Design and Develop applications based on .Net MVC architecture and user controls with clean C# logic and implement WCF SOAP/REST services and consume them using different communication protocols, create resource-oriented services over HTTP using Web API.

•Working knowledge of client-side functionalities with various UI and responsive components which are execution functionalities in the web applications using advanced JavaScript/UI structures like JSON, jQuery, XML, Bootstrap 3.2, AJAX, Angular 6, HTML (5/4), DHTML, XML/XSL/XSLT, JSON, CSS (3/2).

•Doyen in Database design (RDBMS), programming, implementation and development using MS SQL Server 2005/2008/2012, Oracle 11g/10g/9i, MS access, analytical and conceptual skills in database related work primarily creating complex Stored Procedure, Views, Triggers, Functions, T-SQL, Indexes, Cursors, Performance Tuning, SQL Profiler.

•Developed XML Web Services using C#, ASP.Net, ADO.Net, SOAP, XML, JSON, XSLT, WSDL, REST and UDDI for exposing the functionalities of the enterprise business components at the Business Layer. Used XML to transport and store data.

•Good understanding of AWS concepts such as S3, EC2, load balancer, Public and private subnets etc.

•Proven ability to work independently and as a part of a team with an ability to deliver within short deadlines, excellent communication, and a versatile team player with proven problem-solving skills.

TECHNICAL SKILLS

Programming Languages

C#.Net (4.0/3.5/3.0), HTML, T-SQL, PL/SQL.

Web Technologies

ASP.NET 4.7/4.5/4.0/3.5/3.0, ASP.net MVC, Ajax 3.0/2.0, JavaScript, jQuery, bootstrap, Angular 6, Node Js

IDE Tools

Visual Studio 2017/2010/2008, SQL Server Management Studio 2012/2016

.Net Frameworks

.Net Framework 4.7/4.6/4.5/4.0.

Databases

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

Reporting Tool

SQL Server Reporting Services (SSRS 2008/2005), Crystal Reports (2010/ 09/ 8.5/8)

Version Control Tools

Team Foundation Server 2018/2013, GitHub.

Middleware

Web API, WCF, ADO.NET 4.0/3.5/3.0, MSMQ, Web Services, Enterprise Library 5.0/4.0/3.1.

Servers

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

PROFESSIONAL EXPERIENCE

Client Name

Employment Development Department

Location

Sacramento, California

Duration

June 2020 – Present

Title

Software Developer

RESPONSIBILITIES:

•Used various ASP.NET web server controls, Data Controls for design and development of rich UI that include Grid and details View and for even layout design, Mobile version’s UI design and prioritized web content are designed and developed using HTML, CSS 5, Angular 6 and bootstrap 3.4.

•Using MS SQL Server conceptual skills in database related work primarily creating complex Stored Procedure, Views, Triggers, Functions, T-SQL, Indexes, Cursors, Performance Tuning, SQL Profiler.

•Worked on Development of “Manage Document Request” that consumes rest services from the backend written in .NET. Also Utilized reusable components and guards to better accommodate the complete web application.

•Created WCF services and used different bindings to make it available to different types of clients and consumed third party web services.

•Designed SOAP messages used in WCF to transfer information and create interface to communicate WCF services.

•Used LINQ to XML, LINQ to SQL, and LINQ to Objects for retrieving the data efficiently.

•Performed Unit Testing for all units in developed pages using NUnit Tool.

•Defects are logged in a tool called ALM (Application Lifecycle Management), updates regarding the status of the incidents are logged in ALM.

•Used Web API as idea platform in building Restful application on .Net Framework using SQL server as backend.

•Part of the research team to collect information on how AWS cloud would be advantage to EDD for current moving technology, solid understanding of EC2, S3, load balancer etc.

•Worked on code changes and triage related to MCO3 ‘Object reference not set to instance of object.’ and to find the root cause of the issue.

•Responsible for writing Test Scenarios, Test Plan and Test Cases based on the Functional and Technical requirements.

ENVIRONMENT: Visual Studio 2017, .Net Framework 4.7, C#, HTML, CSS, Bootstrap 3.4, angular, ASP.NET, WCF, TFS, T-SQL, SQL Server 2012, Windows 7, IIS server.

Client Name

Diamond Resorts International

Location

Orlando, Florida

Duration

May 2019 – May2020

Title

Software Developer

RESPONSIBILITIES:

•Worked on designing and developing web applications using Asp.Net MVC Views, Asp.Net MVC Partial View, Asp.Net MVC Layout, HTML5 and Bootstrap Themes, CSS, JavaScript, jQuery, Ajax, LINQ.

•Worked on development and implementation of Displaying the Quintess property information in members site both in old (classic) and new design (MAR).

•Worked on restoring the existing functionality for Prearrival DRI properties and Email Functionality depending on type of reservation both in classic and MAR.

Design and develop rich and responsive UI for Members and Rentals site using ASP.Net MVC web controls and to generate a prioritizing web content of Mobile version of application using HTML5, CSS, Bootstrap.

•Experience working with Oracle database design and development, writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers and User Defined Functions.

•Used jQuery& AJAX for enhancing the responsiveness & behavioral aspects of the web page.

•Worked on migration from classic to MAR design of “Valued Getaway” Utilizing Services and Factories with dependency injection (DI) in ASP.NET MVC, HTML, CSS, JavaScript etc. both for Web and Mobile version.

•On members site various links, fields, logics, and loan information on financial services page used Harland data base, I have worked on moving the database from Harland to Northridge.

•For SLB online owner reservations the ‘Rental Release’ as well as ‘External Exchange’ Verbiage has been set using Drupal.

•Developed various WCF SOAP/REST services and consume them using different communication protocols, create resource-oriented services over HTTP using Web API

ENVIRONMENT: Visual Studio 2017, .Net Framework 4.7, C#, HTML5, CSS3, Bootstrap 3.3, Web API, ASP.NET MVC, WCF, TFS, T-SQL, Oracle 11g, Windows 7, IIS server.

Client Name

Hilton Grand Vacations

Location

Orlando, Florida

Duration

May 2018 – May2019

Title

Software Developer

RESPONSIBILITIES:

Design and Develop Chorus applications based on .Net MVC and user controls with clean C# code-behind logic and implement WCF SOAP/REST services and consume them using different communication protocols, create resource-oriented services over HTTP using Web API.

•Used various ASP.NET web server controls, Data Controls for design and development of rich Chorus UI that include Grid and details View and for even layout design, Mobile version’s UI design and prioritized web content are designed and developed using HTML, CSS3, Telerik controls and bootstrap 3.3.

•Worked on creating a windows service and MSI package to integrate applications with RFID reader to read the RFID tags which are used by sales team.

•Worked on the development of EWorksheet to restrict SSN as a mandatory field for loan and cash deals using angular 2.

•Worked with Docker on multiple cloud providers, assisting developers in building and containerizing their applications (CI/CD), as well as deploying them on public or private clouds.

•Experience in using Angular.js to test views and to do end to end unit testing by using Continuous Integration/Continuous Deployment (CI/CD)

•Using SQL server database T-SQL queries, functions, stored procedures, triggers, and views are developed for data validations, reusability and query optimization.

•Involved in the R&D and analysis of the Chorus Application to improve the performance of the application.

•Participate in Code Reviews with team lead, quality analysts and follow best coding practices that meet the business requirements and security guidelines.

ENVIRONMENT: Visual Studio 2017, .Net Framework 4.7, C#, HTML5, CSS3, Bootstrap 3.3, ASP.NET MVC, WCF, VSTS/Git, T-SQL, Telerik Controls, SQL Server 2012, Windows 7, IIS server.

Client Name

Cognizant Technology Solutions

Location

Hyderabad, India

Duration

May’ 2013- Jan’2016

Title

.Net Developer

RESPONSIBILITIES:

•Creating the release plans, requirement documents for the scheduled releases and getting the sign off from the respective applications users.

•Used a class library (assembly) to create a Data Access Layer to organize the data well to avoid interrelated errors.

•Developed 3-tiered web-based application; extensively worked on the Business layer using C#.NET. The web layouts were developed using HTML, CSS and JavaScript.

•Assisted in the design and development of reports in SQL Server using SQL Server Reporting Services (SSRS)

• Used Git for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

•Employed C# concepts like encapsulation, inheritance, abstraction to get the required programing scenarios.

•Coding the changes/enhancements in .Net Framework 3.0 using C# and .Net languages.

•Implemented Client-Side Validations and Server-Side Validations using JavaScript and C#.

•Writing SQL stored procedures and database triggers using SQL server 2005.

ENVIRONMENT: C#.Net, ADO.NET, C#, JavaScript, SQL Server 2005, HTML, CSS, Win Forms, TFS, ASP.NET 4.5, .NET Framework 4.0, jQuery, Bootstrap, ADO.NET, Web API

Education:

Frostburg State University, MD Masters, Applied Computer Science 2016-2017

JNTUH, India B.tech, ECE 2008-2012

Contact this candidate