Sql Server .Net Core

Professional Skills:

Around * Plus years of IT experience in developing, maintaining web and client/server applications, object-oriented programming, system analysis and design using Microsoft Technologies.

Client/Server N-tier Architecture based on Microsoft .NET technologies and SQL Server in various business domains like finance, retail, health care, publishing, telecom and web-based applications.

Experience in Microsoft .NET Technologies under Visual Studio, .NET Framework, architectures in C#.NET, ASP.NET MVC, .Net Core, Microservices, Docker, ADO.NET, LINQ, Entity Framework, Web API, WPF, WinForms, WCF, XML, Mongo DB and Microsoft SQL Server.

Experience in developing UI using JavaScript, J Query, Ajax, React JS, HTML5, XML, Angular JS, Angular 2, Angular 6/8/11, Blazor Web Assembly and CSS.

Experience in writing complex Database Queries, stored procedures, Tables, Views, Indexes, Triggers, User Defined Functions, SQL Joins and performance-based query writing, functions, triggers using MS SQL Server, TSQL and PL/SQL and Oracle 11g PL/SQL relational databases.

Experience in working with different object-oriented programming techniques like inheritance, polymorphism, interface and encapsulation.

Good experience in developing applications with SOAP and RESTful Web Services.

Experience in designing and implementing infrastructure as code and CI/CD pipeline for deployments of large-scale web applications. Good Experience in Developing Applications using Microservices and monolithic architecture.

Experience with GIT, TFS, Microsoft Visual Source Safe (VSS), SVN and Azure Devops.

Proficient in Object Oriented Design/Development (OOD), Object Oriented Analysis and Design (OOAD), Model View Control (MVC) design pattern and Test-Driven Development (TDD).

Proficiency in Agile and Waterfall development methodologies.

Experience in developing Use Cases, Sequence Diagrams, and Class Diagrams in UML.

Technical skills:

Programming Languages

C#, VB.NET, SQL, T-SQL and PL/SQL.

Web Skills

ASP.NET 4.0/ 3.5/ 2.0/1.1, .NET 4.0/3.0, ASP.NET Web API, .Net Core 2.1/5.0, MVVM, HTML, HTML5, JavaScript, CSS, CSS3, React JS, Integration Testing, IoC, NUnit Testing, Jira, Micro Services, TDD, AJAX, Entity Framework, LINQ, Blazor, Micro Services, GIT, CI/CD Pipelines, Knockout, Angular JS, Angular 2/6/8/11/13, Typescript, J Query, Bootstrap.

XML Technologies

XML, SOAP and RESTful Web Services

Relational Databases

SQL Server 2018, 2016,2012/2010/2005/2000, and Oracle 10g/0i/8i.

Operating Systems

Windows Server 2010,2008R2/2003, Windows 7/Vista/XP/98

Reporting Tools

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

Version Control Tools

TFS, VSTS, Git and SVN

Client: Commonwealth of Pennsylvania

Role: Senior .NET Developer

Duration: December 2019 – Present

Description: The Division of Weights and Measures focuses on one core objective: making sure Pennsylvania consumers get what they paid for. Every dollar matter, which is why the Weights and Measures Division has staff working across the state to protect consumers, businesses and manufacturers from unfair business practices and assure equity in the marketplace.

Responsibilities:

Involved in all phases of project lifecycle SDLC i.e. requirement gathering, analysis, design, application development and testing for the project.

Designed and Developed the Web Application using C#, ASP.NET Core, VB.NET(VB6), AJAX and ADO.NET.

Developed web pages and validated these pages using ASP.NET and JavaScript.

Wrote T-SQL queries, T-SQL Stored Procedures and Triggers, which will execute against SQL Server 2016 database to extract the appropriate data for each report.

Developed Restful Services using Web API .Net core and writing interoperable and reusable services using WCF and Web API.

Used ASP. NET Core 2.1 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.

Implemented LINQ query operations like Grouping, Ordering and Filtering.

Designed and implemented the application using Microservice Architecture for its various distinct advantages like loose coupling and design patterns.

Worked on Angular 6/8/11/13 Templates, directives, Routing and navigation, Components, Services, Pipes and Data Binding.

Designed and developed Entity Framework 2.0 code-first approach with repository-pattern based backend and used Restful and Web API as transition and communication technology to client-side.

Setup development environment using latest Blazor .Net with Asp .Net Core 3.0.

Involved in complete application stack in Amazon Web Service(AWS) like EC2, S3 Bucket.

Designed the framework in C# based on repository pattern to access the Mongo DB.

Implemented design patterns Singleton, Factory, MVC, IoC/DI etc.

Implemented client-side Interface using React JS. Build stable React components and stand-alone functions to be added to any future pages. Used React-Router to turn application into Single Page Application.

Created PL/SQL coding stored procedures, packages, indexes, Transactions, Triggers.

Worked in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts also Created SSIS packages with Error handling, notifications and package configurations.

Experienced in consuming data from RESTful Web Services using JSON and used Postman for testing the Web Services.

Environment: Visual Studio 2013,2019,2022 SQL Server 2012,2016, 2018, MVC, C#, ASP.Net, .Net Core 2.1,5.0, PL/SQL, Angular 6/8/11/13, Type Script, Micro Services, GIT, Blazor, Json, Unit Testing, JavaScript, XML, Bootstrap, IIS 7.0, AJAX, Azure Devops, Jira, LINQ, WPF, WCF, Agile, AWS, Entity Framework, WinForms, Mongo DB, NUnit, HTML, CSS, SSIS, SSRS.

Client: IBM

Role: .NET Developer

Duration: October 2018 – December 2019

Location-East Lansing, MI

Description: Aumentum is one of the divisions of Tax and Accounting departments in Thomson Reuters, which provides software to governments to manage revenue generation through land and property. It had a web application for property valuation and management; we did enhancements to the existing web forms.

Responsibilities:

Developed the user interface using ASP.NET, C# .NET Microsoft .NET framework and designed UI using CSS, HTML, and JavaScript.

Design and development of user interface using ASP.NET, VB.Net, HTML, and JavaScript.

Implemented new designs, porting and styling legacy pages, integrating J Query plugins, converting static forms into Ajax overlays.

Developed Web Services using RESTful to retrieve data for client side.

Used WCF for developing the services and exposed them using SOAP & Http protocols.

Business Logic has been implemented using the concepts of secure coding features and Object-Oriented programming (OOP) with Code behind language C#.

Used Angular JS, Angular 2/6 for Client-side validations while rendering JSON validation errors in the backend.

Implemented changes to the communication interface between the mainframe and web space which added new client data fields and indicators while verifying incoming back-end data against the front-end.

Developed Angular 2 Template driven forms and Model driven forms builder by using ngModel.

Created Stored Procedures, Tables and Views in the database using MS SQL.

Implemented Data Access Layer using Entity Framework to get and update data.

Designed and implemented Data access layers using LINQ for XML Data

Used grid views for displaying and modifying the data from the database.

Worked with Oracle 11g for data management i.e.; for data updating, data deleting and to enter new data.

Implemented application state using view state, session variables and query strings.

Extensively worked with web parts and web controls.

Used TFS (Team Foundation Server) for version control and to maintain consistency with the remote team members.

Environment: ASP.NET 4.0, ASP.NET, ADO.NET, Visual Studio 2012, C#, RESTful Web services, XML, XAML, HTML, DHTML, Angular JS, Angular 2, Spec flow, Java Script, Bitbucket, J Query, Azure, LINQ, SQL-Server 2012, Oracle 11g, Rad controls, TFS.

Client: Humana

Role: .NET Developer

Duration: September 2016 – September 2018

Location- Remote

Description: Humana makes it easy to find the best Medicare plans for everyone. Humana is third largest Insurance carrier in USA. It offers various health insurance plans to its members. Many providers have tied with Humana for their service.

Responsibilities:

Working in Agile Methodologies for rapid development and regular adaption to the varying requirements and continuous delivery of the working software.

Provides support, development and enhancement solutions for web applications using ASP.NET MVC 5, ASP.NET Web APIs, Code First Migrations, Entity Framework, AngularJS, Angular 5.0+ (currently 8), HTML, CSS, JavaScript, Typescript and SQL.

Experience in writing complex Database Queries, stored procedures, Tables, Views, Indexes, Triggers, User Defined Functions, SQL Joins and performance-based query writing, functions, triggers using MS SQL Server.

Experienced in consuming data from RESTful Web Services using JSON and used Postman for testing the Web Services.

Experience in generating Custom Reports and different types of Tabular, Matrix and distributed reports in multiple formats using Crystal Reports and SQL Server Reporting Services (SSRS).

Created Azure functions, Azure event grid, table storage and Azure Que storage.

Designed SOAP messages used in WCF to transfer information. Created interfaces in C# to communicate through the WCF services.

Extensively involved in Angular JS, J Query UI and jQuery to add functionalities and effects like Infinite scroll bar, Slider bar, Draggable/Droppable and Resizable.

Environment: ASP.NET 4.0, ADO.NET, Visual Studio 2012, C#, Angular JS, Java Script, J Query, Azure, RESTful Web services, HTML, CSS, SQL-Server 2012, Oracle 11g, TFS.

Client: Annex IT Solutions

Role: .NET Developer

Duration: June 2012 to June 2014

Location-Hyderabad, India

Description: Annex IT Solutions is an offshore software development company catering client across the globe. They mainly focus in developing custom, scalable & secure web applications leveraging outsourcing and offshore value advantage.

Responsibilities:

Designed and developed various abstract classes, interfaces, classes to develop a business logic layer using C#, ASP.NET, ADO.NET.

HTML and CSS are used for developing web pages, maintained the code behind using ASP.NET with C#.

JavaScript, AJAX and J Query are developed for dynamic page updates and for maintaining the client-side functionality.

Used JavaScript, AJAX and J Query for dynamic page updates and client-side validations.

Highly worked on ADO.NET for developing core data layers for the distributed applications.

SQL server 2005/2008 is used for designing and creating the database using normalization techniques.

Creating stored procedures, views, functions and triggers in SQL server 2005 and 20008.

Migrated data from Microsoft SQL Server 2005 to Microsoft SQL Server 2008.

Involved Unit Testing, Integration Testing in a regular basis to improve the performance of the application.

Found issues including security vulnerabilities and fixed them after discussion with team members.

Experience in tracking changes with GIT.

implemented application with using of C#, ASP.NET, ADO. NET, HTML, CSS, AJAX and WinForms.

Conducted code reviews with team members, participated in other team members' code reviews.

Environment: ASP.NET 3.5, Visual Studio 2008, WinForms, GIT, SQL Server 2005, SQL Server 2008, HTML, XML, CSS, WPF, WCF, JavaScript, C#, Crystal Reports, IIS6.0

Education –

Masters – Wilmington University, Delaware/ Computer Science / 2016

Bachelors – JNT University, Hyderabad, India / Computer Science / 2011

Contact this candidate