Post Job Free

Resume

Sign in

Sql Server Asp.Net

Location:
Charlotte, NC
Posted:
September 29, 2023

Contact this candidate

Resume:

Dilip Kumar

Mail: adz1i7@r.postjobfree.com

Phone: +1-475-***-****

Senior .Net Developer

LinkedIn: www.linkedin.com/in/dilip-kumar-86372627b

Professional Summary:

Over 9+ years of experience in software design and development using the .NET Frameworks, including ASP.NET, MVC, WEB API, Microservices, ADO.NET, SQL Server, Entity Framework, Win Forms, Web Forms, Web Services, MVVM, WPF, WCF, XAML, Ajax, LINQ, and IIS, with a focus on performance, security, scalability, and extensibility.

Experienced in a fast-paced Agile Development Environment, including SCRUM Programming.

Expertise in all stages of the SDLC (Software Development Life Cycle), encompassing the study of user requirements, analysis, design, implementation, testing, deployment, documentation, and maintenance of various stand-alone, intranet, client-server multi-tier web, and GUI software applications.

Proficient in Web Application design and development using ASP.NET, MVC, JavaScript, jQuery, Angular JS, Angular 12, Ajax, Kendo UI, HTML5, XML, and CSS3.

Designed and implemented applications using Microservices Architecture to leverage advantages like loose coupling and design patterns.

Experience in developing Restful services using the Web API framework.

Experienced in WPF, WCF development, ASP.NET Web Forms, ASP.NET State Management & ASP.NET Caching.

Skilled with the .NET Platform, Visual Studio, Microsoft SQL Server 2016, C# 4/5, and ADO.NET.

Developed Single-page responsive applications using Angular JS.

Proficient in working with Microsoft Azure cloud services such as Storage (Blob, Table, Queue), Web Sites, Web Roles, Web Apps, Azure Service Bus, Azure virtual network, SQL Azure, Data Sync, Traffic Manager, CDN, and Caching.

Extensive use of ADO.NET Data grids, Data Readers, and Datasets for Data Manipulation.

Experience with reporting tools SQL Server Reporting Services (SSRS) and Crystal Reports, including creating ETL packages using SQL Server Integration Services (SSIS) to generate reports populated by data in databases.

Proficient in using T-SQL for developing complex stored procedures, Triggers, Tables, Views, User-Defined Functions, SQL joins, Index, and query writing.

Experience in data object models like Language-Integrated Query (LINQ) and Entity Framework (EF) to retrieve and modify data and develop entity data framework services.

Skilled in using Team Foundation Server (TFS), Subversion, GIT, GitHub, and VSS for version control and collaboration.

Experience in performing Unit Testing using NUNIT and conducting Integration Testing.

Effective Team Player with excellent communication, analytical, verbal, and writing skills, along with strong management, organizational, and mentoring abilities.

Project Experience:

Client: Drug Plastics - Boyertown, PA March 2021 – till date

Role: Senior .Net Developer

Project Description:

Join as a Senior .NET Developer at Drug Plastics, leading modules for real-time plastic material tracking, predictive usage forecasting, quality control, and compliance reporting. Leverage .NET expertise to optimize operations, ensure high-quality standards, and simplify compliance with industry regulations. Create data analytics tools for informed decision-making, contributing to Drug Plastics' success in pharmaceutical and plastics manufacturing.

Responsibilities:

Developed in designing and developing front-end/user-interface (UI) of web applications using HTML 4/5/6, CSS3, DOM, JavaScript, jQuery, Angular 10, Bootstrap, AJAX, JSON, and XML: This experience can be relevant for drug plastics if there is a need for web applications in the industry. However, the technologies used should be evaluated to ensure they align with the specific requirements of drug plastics.

Design and developing Microservices for the business components using .NET framework: The relevance of this experience depends on the specific applications and systems used in the drug plastics industry. It may need further evaluation or modification to align with the industry's needs.

Designed and developed Web APIs for microservices using ASP.NET Core 6.0: Like point 3, the significance of Web APIs would depend on the applications and systems required in the drug plastics field.

Designing Web APIs as RESTful APIs for the application using .NET Core: This point can be relevant if RESTful APIs are needed to facilitate communication between different systems or applications in drug plastics.

Troubleshoot and fix issues with the services including microservices, platform services (PaaS), web, and database servers: This responsibility can be essential in ensuring the smooth functioning of applications and systems in drug plastics.

Worked on using ASP.NET Core 6.0, AJAX framework for quickly creating efficient and interactive Web applications that work across all popular browsers: Like point 2, the relevance of these technologies would depend on the specific needs in drug plastics.

Developed Razor views with strongly typed view models and helpers and partial views using ASP.NET Core 6.0 MVC5, HTML5, CSS3, and Angular, C#: This experience may be valuable for web application development in drug plastics if applicable.

Implemented Azure IAAS and PAAS services, provisioning VM’s, virtual Hard disks, deploying web apps: While Azure services can be useful in various industries, the relevance in drug plastics may vary depending on the infrastructure and requirements.

Designed and developed cloud service projects and deployed to web apps, Paas, and Iaas: This point may need further evaluation or modification to align with drug plastics, as cloud services' importance depends on the organization's setup.

Worked on creating Azure Blob for storing unstructured data in the cloud as Blobs: The significance of Azure Blob storage depends on the type and volume of data generated in drug plastics.

Implemented Azure DevOps services for project management tasks, source code repository, continuous integration, and deployment: The utilization of Azure DevOps can be beneficial in streamlining development processes in drug plastics.

Successfully developed a web application by using ASP.NET MVC 5, WEB API with Angular: If web applications are part of the drug plastics industry, this experience can be relevant.

Used View bag, View Model & Partial View to achieve data transfer in MVC architecture: This point is specific to ASP.NET MVC and may need modification to reflect relevant technologies used in drug plastics.

Wrote SQL Queries, Stored procedures, Joins using SQL Server and LINQ queries to process large collection of products, rules, and used ADO.NET Data Reader, Data Adapter, SQL Command, and Dataset for retrieving data from the database: The importance of SQL Server and related technologies would depend on the data management requirements in drug plastics.

Implemented the data access layer using Entity Framework Code First Approach: This point can be valuable if Entity Framework is used to interact with the database in drug plastics.

Developed the data layer functions using ADO.NET Entity framework to connect to the database & fetch data: Like point 16, this experience is relevant if ADO.NET Entity Framework is used.

Created Views by applying complex queries on multiple tables to create virtual tables and implemented Cursors in Stored Procedures using SQL Server: The usage of complex queries and stored procedures would depend on the specific data processing needs in drug plastics.

Implemented Joins in Stored Procedures to get the desired data by joining multiple tables in SQL Server: The application of Joins in the context of drug plastics would depend on the database structure and querying requirements.

Generated reports using SSRS as per business requirements: Reporting capabilities, such as those provided by SSRS, can be relevant in drug plastics to analyze and visualize data.

Performed Integration services using SQL Server Integration Services (SSIS): Integration services can be important for data integration and data transformation tasks in drug plastics.

Involved in Defect Causal Analysis for Testing Defects and involved in Root Cause Analysis for Prod bugs: This responsibility can be retained, as bug analysis and root cause analysis are crucial for maintaining the quality of applications in any industry.

Prepared Technical design document, use cases, Test cases, and User manuals for various projects and worked on Bug fixing issues, participated in Code reviews, and Unit testing: Documentation, testing, and bug fixing are essential activities in the development process, regardless of the industry.

Proficient in configuring, managing, and optimizing Internet Information Services (IIS) on Windows Server.

Strong troubleshooting skills to identify and resolve issues related to Windows Server and IIS.

Utilized C# generics, delegates, events, extension methods, anonymous types, and lambda expressions: These features of C# can be used to enhance code efficiency and maintainability in drug plastics applications.

Utilized using Source Code Control Systems like TFS (Team Foundation Server) and GIT: Source code control systems are critical for version control and collaboration in software development, including drug plastics applications.

Environment: ASP.Net Core 6.0, C#, MVC, WEB API, SQL Server, Visual Studio, Visual Studio Code 2018, Notepad++, XML, IIS 7.5, HTML5, CSS3, JavaScript, jQuery, Angular 12, Typescript, Redux, Fiddler, Postman, Angular, Kafka, RabbitMQ, GIT, Team Foundation Server (TFS) and Agile Methodology.

Client: Truist Banks - Atlanta, Georgia Oct 2018 – Feb 2021

Role: Senior .Net Developer

Project Description: The project is to develop and implement a robust web-based clinical trial data management system using .NET technology that facilitates seamless data collection, integration, and dissemination. The system will be designed to efficiently collect and manage data from various clinical trials, allowing for secure external system integrations and internal module configurations. By providing a user-friendly interface and effective communication channels, the project aims to support healthcare personnel across the 15 Pediatric Brain Tumor Consortium (PBTC) member institutions in effectively utilizing and contributing to the clinical trial data repository. The goal is to enhance the data management process, accelerate research efforts, and promote informed decision-making, ultimately leading to improved patient care and medical advancements.

Responsibilities:

Utilized OOP Concepts and SOLID principles in C# 4.0 to implement business logic and code behind view models.

Developed web applications using .NET Core framework.

Implemented JWT Token-based authentication to secure the ASP.NET Core Web API and provide authorization to different users.

Played a significant role in developing and hosting ASP.NET Web API.

Made use of Dependency Injection Structure and Middleware present in .NET Core framework.

Designed and developed user interfaces using ASP.NET, AJAX, JSON, C#, SQL Server, JavaScript, HTML5, and XML.

Worked with the MVC architecture to create web applications using ASP.NET and SQL Server.

Build rich user experiences using HTML5 with ASP.NET MVC Razor 5 in web applications.

Used Entity Framework & LINQ to Entities to connect to the database and perform all database transactions.

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

Designed and developed business components using ASP.NET MVC 5 for web applications.

Extensive hands-on experience in setting up, configuring, and fine-tuning Internet Information Services (IIS) on Windows Server.

Proficiency in optimizing IIS for performance, security, and scalability.

Expertise in Microsoft Azure cloud services (PaaS & IaaS).

Worked with Queues, Blobs, and Containers to persist data on Azure.

Created Databases on SQL Azure.

Collaborated directly with Azure product teams to track and resolve defects in Azure PaaS.

Used Azure DevOps services for source code repository and to build project artifacts.

Extensively used ADO.NET for retrieving, querying, and storing data from the database and used Grid View & Details View to display and manipulate data.

Worked on Complex Stored Procedures, Functions, and Triggers in SQL Server.

Created and managed SQL Server logins and users as per requirements with specific roles & permissions.

Developed SSIS Packages for data extraction and scheduled jobs to run on a daily feed basis.

Created various reports like tabular reports, matrix reports, and parameterized reports using SSRS.

Designed, developed, and deployed reports in the MS SQL Server environment using SSRS.

Extensively worked with Oracle, created DDL scripts, database objects like Tables, indexes, Synonyms, Sequences, stored procedures, and collaborated with DBAs to improve performance.

Used Angular CLI commands for productivity and global/generic building blocks.

Redesigned the main website to improve user experience and add new functionalities using Angular.

Created TypeScript reusable components and services to consume REST APIs using Component-based architecture provided by Angular.

Utilized Team Foundation Server (TFS) for source code version control.

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

Proficient in managing source code using GIT and version control best practices.

Ability to collaborate effectively with a development team using GIT for source code management.

Environment: ASP.NET 4.5, C#, MVC5, MVVM, WEB API, Visual studio 2017, XML, XAML, JSON, IIS 7.5, HTML5, CSS3, JavaScript, jQuery, Angular 2/4, MS SQL Server, LINQ, NUnit, ADO.NET, Entity Framework,,PL/SQL, Kafka, RabbitMQ, Oracle 11g/10g, Cassandra DB, Azure Devops, Agile Methodology & TFS.

Client: Mayo Clinic -Rochester MN May 2016 – Oct 2018

Role: .Net Developer

Responsibilities:

Implemented Windows Workflow Foundation (WWF) to manage long-running processes as workflows.

Implemented Web API for building RESTful Web Services.

Developed ASP.NET Web API Controllers to implement the service layer and data object layer.

Created views and partial views for UI and middle tiers of various modules using ASP.NET MVC, HTML, and CSS.

Implemented View Model and partial views in MVC, leveraging html helper classes.

Reviewed the current framework and version control system and set up Continuous Integration using automation tools like Jenkins and Stash.

Implemented Angular Router to enable navigation between views as agents perform application tasks.

Developed AngularJS framework, including MVC architectures, distinctive modules, controllers, templates, custom directives, custom filters, and resolved Angular scope issues.

Demonstrated expertise in implementing DevOps practices and principles.

Proficient in using DevOps tools and methodologies to streamline software development, deployment, and operations.

Responsible for client-side UI validation and implementing business logic based on user selections using jQuery UI and AngularJS.

Developed stored procedures, views, and automated SQL and T-SQL scripts for database maintenance, deployment, and installation using SQL Server.

Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio (SSMS).

Implemented ADO.NET to the data layer to communicate with SQL Server.

Worked with SQL Server Reporting Services (SSRS) for reporting.

Implemented ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS).

Extensively used ADO.NET Entity Framework to implement the data layer and communicate with the database.

Developed business and data access layers using C# .NET and Entity Framework.

Implemented Windows Presentation Foundation (WPF) and gained hands-on experience using SQLite.

Utilized collections, interfaces, and abstract classes to implement the project and handle exceptions.

Involved in writing test plans and test scripts for unit testing using Nunit.

Implemented ASP.NET validation controls and JavaScript validations to enforce input validations.

Worked in a Continuous Integration and testing environment using Jenkins.

Worked with GIT, including creating repositories, branching, merging, and resolving merge conflicts.

Built and published customized interactive reports and dashboards and implemented report scheduling using Tableau Server.

Environment: .NET 4.5, C#.NET, SQL Server 2012, SQL Server Management Studio (SSMS), SSRS, SSIS, ADO.NET, LINQ, WEB API’s, WCF, XML, HTML5, CSS3, JavaScript, jQuery, TFS, Bootstrap, IIS 7.5, SOA, T-SQL, MVC5, Postgres, Jenkins, oracle, Visual Studio 2013/2014&Windows Server 2008.

Company Name: Larsen & Toubro July 2014 – March 2016

Role: .Net Developer

Responsibilities:

Have developed WCF AND RESTful Services by using C# and Web API.

Developed secure login interfaces with ASP.NET Server controls.

Used various server controls like Multi View and Grid View with extensive data binding to display, page and sort multiple records.

Coding the presentation layer using WPF and service layer using Windows Communication foundation technology.

Setting up SQL Azure Firewall.

Generated reports using the SQL Server Reporting services (SSRS).

Project Data importing/exporting using serialization/de-serialization.

Developed User Interface in Razor Views.

Used WEB API Controllers which support GET, POST, PUT and DELETE.

Use ASP.NET WEB API as the platform for building RESTful applications on the .NET framework.

Create, manage SQL Server AZURE Databases.

Developed application using ASP.NET MVC 4 framework.

Used various ASP.NET MVC filters such as Authorization filter, Action filter and Authentication filter.

Created application using HTML5, AngularJS, Bootstrap for responsive design.

Developed using CSS3, C#, JAVASCRIPT, JQUERY.

Implemented business logic/rules using WCF services and integrated with the UI components.

Developed Entity framework-based database access layer using ADO.Net and Entity Framework.

Written stored procedures, triggers using T-SQL for data access from SQL Server 2008.

Used Entity Framework as ORM for binding the data to the model classes.

Designed and developed Web Pages using ASP.NET, C#.NET, HTML, JavaScript, AJAX, jQuery, CSS and Server controls.

Developed module which deals with validating user, changing passwords, and searching of information depending upon priority of user in site using ASP.NET.

Developed WCF service to be used by the ASP.NET applications.

Educational Details: B.E - Computer Science And Engineering (Anna University ). June 2010-June 2014



Contact this candidate