Post Job Free
Sign in

.Net Developer Sql Server

Location:
Fuquay-Varina, NC
Posted:
June 05, 2024

Contact this candidate

Resume:

RAJ K

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

Sr .Net Developer

Phone: +1-623-***-****

PROFESSIONAL SUMMARY:

●10+ years of experience as a dedicated .NET Full Stack Developer, covering all aspects of the Software Development Lifecycle (SDLC), from initial design to deployment.

●Proficient in Object-Oriented Design/Development, Object-Oriented Analysis and Design (OOAD), and Model View Control (MVC) design patterns.

●In-depth understanding of SOLID Principles and Object-Oriented Programming (OOPS) Principles, including Encapsulation, Inheritance, Polymorphism, and Abstraction.

●Extensive experience in designing and developing software applications using C#.NET, VB.Net, .NET Core, Microservices, ASP.NET Web Forms, ASP.NET MVC, ADO.NET, AJAX, WCF, Web Services, SOAP and RESTful Services, Entity Framework, SQL Server, Angular 11, React.JS, TypeScript, Bootstrap, Node.js, jQuery, and JavaScript.

●Experienced with the Model View Controller (MVC) framework and Entity Framework.

●Extensive experience using SQL Management Studio and SQL Server Business Intelligence solutions such as SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services).

●Experienced in using Web Server IIS 7.5/7.0/6.0 for application deployment, and configuring PHP, MySQL, and WAMP/MAMP servers.

●Expertise in SDLC phases, utilizing JIRA for issue/bug management, GitHub for version control, and Microsoft Azure for web app deployment.

●Strong backend development skills using SQL Server, MongoDB, MongoDB Atlas Cloud, .NET Web API, NodeJS, Express, and JWT.

●Worked for DevOps Platform team responsible for specialization areas related to Chef for Cloud Automation.

●API integration proficiency, employing API Keys for identity verification and implementing Token-based security for Web API requests.

●Developed applications using the MVVM pattern in C# and WPF, and mobile applications with the Cordova/Ionic framework in AngularJS.

●Worked on ASP.NET MVC Applications using Database First/Code First approaches in EF (Entity Framework) and client-side frameworks such as Angular 11/8/7/6.0/4.0/2.0, Bootstrap, React.JS, Redux, CSS3, and HTML5.

●Extensive knowledge of Microsoft .NET Design Patterns, including Dependency Injection (DI), Singleton, MVVM, and MVC.

●Actively involved in the architecture of the DevOps platform and cloud solutions.

●Experience working with Microsoft's Platform as a Service (PaaS) to create applications and cloud services using the Windows Azure platform, as well as cloud computing applications using Azure and AWS.

●Experienced in ORM by using Entity Framework for scaffolding, LINQ to SQL, and LINQ to Objects.

●Extensive experience with complex queries in MySQL, MS SQL, PostgreSQL, ORACLE, and NoSQL (MongoDB), and database optimization through normalization, indexing, views, foreign keys, joins, triggers, and stored procedures.

●Adept at Unit Testing using Unit test, Selenium, and Cypress for comprehensive component testing.

●Skilled in developing Single Page Applications (SPAs) using the MEAN Stack (MongoDB, ExpressJS, NodeJS, and React, Angular 2+ in Typescript).

●Experienced using Kendo-React designer Components and React Hooks such as UseState, useEffect, useRef, useCallback, etc.

●JavaScript coding expertise, including projects with Google V8 Engine and FireFox SpiderMonkey interpreters.

●Proficient in TypeScript/JavaScript for managing asynchronous events and RESTful API Services on the Angular frontend, and utilizing Angular CLI for enhanced user shell interaction.

●Expertise in using Razor View Engine for effective data object storage and passage between controllers and views in ASP.NET MVC.

●Strong experience in implementing Object-Relational Mapping using Entity Framework.

●Experienced with .NET features such as Inheritance, Polymorphism, Interfaces, Events & Delegates, Generics & Collections, Multithreading, Exception Handling, and Tracing.

●Experienced with Test Driven Development (TDD) and familiar with Cloud Development, deploying VMs using Azure and GCP.

●Proven track record of effective collaboration using JIRA, GitHub, and Trello within AGILE frameworks, including release meetings, stand-ups, code reviews, and pair programming.

TECHNICAL SKILLS:

Programming Languages

C#.NET, VB.NET, JavaScript, AJAX, VB Script, VB6, C, C++, SQL, PLSQL

.NET Technologies

Web Forms, Win Forms, Web Service, ASP.NET, ADO.NET, LINQ, .NET Core 6/3.1/2.2, Restful, Web API 2.0, MVC 6/5/4, WCF, SOAP

Web Technologies

HTML5, CSS, jQuery, JavaScript, Knockout.JS, Ext.JS, Bootstrap 4, TypeScript, Angular 11/6/2, React.JS, Redux

ORM Tools

Entity Framework

Cloud Technologies

Microsoft Azure, AWS

Third Party Tools

DevExpress, Kendo UI, Telerik Rad Controls for ASP.NET AJAX, Node

Development Tools

Visual Studio 2022/2019/2017/2015, Visual Studio Code, Git, Bitbucket

Version Control

Team Foundation Server (TFS), Bitbucket, Stash, GIT, SVN, Visual Source Safe (VSS)

Reporting Tools

Crystal Reports, SQL Server Reporting Services (SSRS)

Databases

SQL Server 2022/2016/2014/2012, MySQL, MongoDB, PostgreSQL

Operating Systems

Windows, Linux, Mac OS

WORK EXPERIENCE:

Sallie Mae - Indianapolis, IN May 2023 – Till date

Sr .Net Developer

Responsibilities:

●Contributed to all stages of the Software Development Life Cycle (SDLC), including requirements gathering, design, development, testing, documentation, and deployment.

●Leveraged Visual Studio and VS Code IDEs for development tasks.

●Engaged in component development using CSS, JavaScript, jQuery, and Angular 11.

●Managed Asynchronous events and RESTful API Services in TypeScript/JavaScript for the Angular frontend, employing design concepts like Promises, Observables, Higher Order Functions, Arrow functions, Async Await, and Callback Functions.

●Utilized RESTful web services for dynamic web page development and implemented business logic using object-oriented programming (OOP) concepts.

●Developed a .NET Core 6 Web API based on departmental requirements and specifications.

●Designed Microsoft SQL databases, creating stored procedures, functions, views, and triggers to streamline front-end SQL queries and enforce entity relationships.

●Developed and enhanced .NET Web API endpoints for consumption by Angular 11 components.

●Implemented a RESTful API server using Node.js.

●Managed Cloud/On Premises environments, automated the provisioning of VM’s, patching, software installs, deployments and part of DevOps team in troubleshooting and fixing issues.

●Proficient with Angular CLI for creating components, services, pipes, and directives, and employed bash script to streamline Angular CLI operations with user shell interaction.

●Utilized Razor View Engine for data storage and passing between controllers and views, employing various methods including ViewData, ViewBag, and ViewModels.

●Conducted front-end development using HTML, CSS, ASP.NET, and Razor View Engine.

●Involved in back-end development using C#, .NET Core, and Entity Framework Core.

●Managed version control and source code repository using GitHub.

●Created SQL databases using SQL Server Management Studio.

●Optimized RDBMS by normalizing tables, indexing, using views, foreign keys, joins, triggers, and stored procedures.

●Implemented Ado.Net Database First Approach to create Entity Models and DbContext.

●Utilized Repository Pattern for work order logic implementation.

●Applied Data Filtering and LINQ to sort and filter data.

●Implemented Filters for default actions and user authorization.

●Provided database connectivity using Entity Framework Core 6.0 and LINQ, designing stored procedures and views.

●Enhanced SharePoint Lists and Libraries functionalities and event receivers.

●Configured Windows SharePoint Search and monitored content database sizes.

●Executed Model Binding and request verification in Razor Pages for secure form data submission and added JavaScript functionality with Bootstrap and CSS.

●Passed data from .NET Core Framework to Razor View Engine using View Bag, View Model, and Temp Data.

●Implemented a search bar for work order filtering.

●Designed and implemented for fully automated Server build management, monitoring and deployment using DevOps Technologies like Chef, Ansible.

●Installed, configured, and maintained CodeIgniter, PHP, Apache, and MySQL on AWS Cloud Servers.

●Contributed to application design and core development.

●Developed XML classes for data loading from server-deployed XML files.

●Utilized ASP.NET Core and AJAX frameworks for creating efficient, interactive web applications.

●Designed and developed web pages using HTML, CSS, Ajax controls, and XML.

●Collaborated with Agile teams using JIRA project management software.

●Deployed applications and data servers using Azure app services and Azure SQL server.

●Employed Git for version control.

●Participated in daily SCRUM calls.

Environment: C#, ASP.NET Core, Visual Studio, VS Code, CSS, JavaScript, jQuery, Angular 11, TypeScript, RESTful web services, .NET Core 6, Microsoft SQL, Node.js, Angular CLI, Razor, HTML, ASP.NET, C#, .NET Core, Entity Framework Core, GitHub, ADO.NET, Repository Pattern, LINQ, Filters, SharePoint, Bootstrap, CodeIgniter, PHP, Apache, MySQL, AWS Cloud Servers, ASP.NET Core, AJAX, XML, Azure app services, Azure SQL server, Git, JIRA.

Freedom Mortgage - Marlton, NJ Oct 2021 – April 2023

.Net developer

Responsibilities:

●Created and deployed new reusable components for web-based applications utilizing React, CSS, and JavaScript.

●Developed an interface for the Web Service API to retrieve gift card objects from various companies within the ASP.NET Core API Backend.

●Leveraged advanced ASP.NET Core MVC concepts such as models, providers, and filters for backend development.

●Designed databases in Microsoft SQL, crafting stored procedures, functions, views, and triggers to streamline front-end SQL queries and enforce entity relationships.

●Generated server-side PL/SQL scripts for data manipulation and validation, including materialized views for remote instances.

●Extended parameters for User Object Models employing object-oriented programming principles: Encapsulation, Inheritance, Polymorphism, and Abstraction.

●Architected and implemented ASP.NET Core Web API using C#, Entity Framework, and SQL Server.

●Collaborated on API-driven microservices developed with .NET Core 6.

●Engineered microservices for business components utilizing the .NET framework and .NET Core 6.

●Designed and implemented logging and monitoring solutions for microservices using Fluentd.

●Designed and integrated XML web services into microservices architecture.

●Deployed JWT token-based authentication to secure the .NET Core 6 Web API and manage user authorization.

●Proficient in using Azure DevOps Services for project management tasks, source code repository, continuous integration and deployment.

●Optimized website performance through a server-client architecture using React, creating a Single Page Application (SPA) to shift rendering load from server to client for dynamic web applications.

●Implemented advanced features like virtual DOM, server-side rendering, lazy loading, and uni-directional data flow.

●Ensured feature implementation aligns with coding standards of .NET, AWS, Azure, focusing on performance and memory utilization.

●Enhanced security measures utilizing Authentication Tokens.

●Utilized Fetch API or Axios for HTTP data retrieval from the server, executing CRUD operations.

●Prioritized performance maintainability through regular Code Review and Refactoring, leveraging Dependency Injection and exception handling.

●Integrated Kendo-React designer components to elevate user interface functionality and user-friendliness.

●Employed Controlled and Uncontrolled Components for state management, leveraging Array Destructuring features.

●Managed application state using React Hooks such as UseState, useEffect, useRef, useCallback, etc.

●Collaborated with React props to enhance component reusability and configurability.

●Implemented React Event Handlers including On Click, OnAbort, OnAnimationEnd, OnAuxClick, etc.

●Utilized React CLI to streamline component creation, services, package installation, and application organization.

●Contributed to RESTful API creation using ASP.NET Core and C#, validating API endpoints with Postman and SSMS.

●Implemented Azure DevOps Services for project management tasks, source code repository, continuous integration and deployment.

●Enabled CORS on the Web API to permit cross-domain access.

●Developed Stored Procedures, User-Defined Functions, and Triggers on SQL Server.

●Utilized TFS for version control and Microsoft Team for project management.

●Designed and developed CRMs in ASP.NET utilizing C#.

●Implemented MVVM pattern for application development within an Agile methodology.

●Contributed to an Agile Scrum environment for Software Development Lifecycle (SDLC).

Environment: React, CSS, JavaScript, ASP.NET Core API, Microsoft SQL, PL/SQL, Object-Oriented Programming, C#, Entity Framework, .NET Core 6, Microservices, Fluentd, XML web services, JWT tokens, SPA, Virtual DOM, Fetch API, Axios, Kendo-React, React Hooks (useState, useEffect, useRef, useCallback), React props, React Event Handlers, React CLI, Postman, SSMS, CORS, TFS, Microsoft Team, MVVM, Agile Scrum.

NantHealth - San Antonio, TX March 2020 – Sept 2021

Full stack .Net developer

Responsibilities:

●Participated in the full project life cycle, from requirements gathering to transition, utilizing Agile Methodology.

●Worked within two-week sprints in an Agile/Scrum environment.

●Designed and developed web applications using C#, ASP.NET MVC 5, ASP.NET Core, WCF, Web API 2, ADO.NET, and Oracle Database.

●Extensively used C#.NET to implement complex business logic according to business requirements and established back-end connectivity using ADO.NET.

●Developed RESTful services with Web API 2 and used Swagger for global enterprise-level API management.

●Involved in migrating applications from ASP.NET MVC 4 to ASP.NET Core 3.0.

●Developed stored procedures, functions, views, cursors, triggers, and sequences in Oracle 12c.

●Utilized Microsoft technologies for project development, including Visual Studio 2015, .Net Framework 4.5, C# 4.5, and GIT & TFS.

●Implemented web services using the Windows Communication Foundation (WCF) methodology.

●Employed JSON for data transmission between the server and web applications as an alternative to XML serialization.

●Implemented CRUD functionality with Entity Framework in ASP.NET MVC and incorporated sorting, filtering, and paging with Entity Framework Code First in MVC using SQL Server 2014.

●Developed REST APIs to facilitate sophisticated, effective, and low-cost application integration, along with multi-tier web applications using ASP.Net Web API.

●Used Data Contract as the standard mechanism in WCF for serializing .NET object types into XML.

●Created tables and stored procedures for DB2 Purge and archival activities.

●Installed and maintained (checked logs and manually ran) Windows applications.

●Performed DOM manipulations, created templates, directives, factories, controllers, and established two-way data binding using Angular 6.

●Developed UI applications using HTML, Kendo, Aspose, jQuery, AJAX, JSON, Bootstrap, Angular 6, and JavaScript.

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

●Utilized Kendo UI controls such as grid, panel, date picker, combo box, validation, dropdown, and autocomplete throughout the application.

●Developed user interfaces using PHP, Bootstrap, Ajax, jQuery, HTML, and CSS.

●Used Visual Studio 2015/.NET Core Framework to implement business logic.

●Developed RESTful services and managed MySQL databases over the web.

●Created ICommand pattern for MVVM model and implemented business logic layer and data access layers to adhere to MVC architecture.

●Performed unit testing using MS Unit Test to ensure code quality and reliability.

●Used Android Studio Emulator and XCode Emulator for emulating and debugging Android and iOS apps, respectively.

●Designed and developed mobile web apps as well as Android and iOS applications.

●Conducted build and release management activities across various environments for the project.

●Made AJAX calls for UI interactions to controller actions using Angular 6 and retrieved data as JSON, parsing it onto the UI.

●Maintained versions of source code using GIT repository and TFS.

●Coded UI framework for unit testing.

Environment: Visual Studio, .Net Framework 4.5, C#, WCF, JSON, Entity Framework, SQL Server, ASP.Net Web API, DB2, HTML, Kendo, Aspose, jQuery, AJAX, Bootstrap, Angular 6, JavaScript, GIT, TFS.

Charles Schwab - Chicago, IL April 2018 – Feb 2020

Software Engineer

Responsibilities:

●Participated in all phases of the Project Life Cycle, including system analysis based on architectural considerations.

●Designed the Graphical User Interface (GUI) using ASP.Net MVC 3 & 4, HTML, and JavaScript.

●Utilized WCF for interoperability with other platforms, technologies, and custom solutions.

●Implemented the backend of the application in C#.NET, utilizing object-oriented features such as classes, interfaces, inheritance, and polymorphism.

●Designed and developed abstract classes, interfaces, and classes to construct business logic in the Model and Data Access Layer using C#.Net.

●Developed front-end applications using Windows Presentation Foundation (WPF).

●Contributed to UI design and development using ASP.NET, HTML5, jQuery, and AJAX.

●Conducted CRUD operations with WCF REST services using WebGet and WebInvoke.

●Created a reusable framework for the application using the ASP.NET MVC Framework 3.5 & 4.0.

●Developed Razor views with strongly typed view models, helpers, partial views, and employed technologies such as ASP.NET MVC4, HTML5, Bootstrap, CSS3, Angular JS, C#, Visual Studio, Telerik, and Kendo controls.

●Implemented the MVVM pattern for WPF application development.

●Developed Partial Views, Master Pages, Strongly Typed Views, and Complex Views.

●Implemented GET and POST actions using Controller actions, caching with Action Filters, and Child actions in the Controller, returning Razor HTML to the View through Action Results.

●Utilized jQuery for client-side validations and event handling.

●Collaborated with Development, QA, and Release management teams as needed.

●Worked with ASP.NET Web Forms, Web Services, State Management, Caching features, and configured optimizations and security for the web application.

●Demonstrated proficiency in table/query design, report design, and automation using VB.Net modules.

●Developed system services for a Service-Oriented Architecture (SOA) application platform, utilized by all web applications through WCF services.

●Used bindings to control the construction of the Windows Communication Foundation (WCF) channel stack at runtime.

●Responsible for writing Back-End Procedures using SQL Server and PL/SQL.

●Developed code to call web services/APIs, fetch data, and populate UI using jQuery/AJAX.

●Created Web Services and invoked them using XML SOAP and WSDL for creating proxy classes.

●Effectively used jQuery for traversing HTML documents, event handling, and AJAX interactions.

●Applied LINQ to Entities for efficient data retrieval in a Just-In-Time manner.

●Wrote Queries, Views, User-Defined Functions, Stored Procedures, and Triggers in SQL Server for data manipulation.

●Created Tabular Reports, Matrix Reports, Parameterized Reports, Sub-reports using SQL Server Reporting Services, and developed ad-hoc reports using Report Builder.

●Conducted unit testing of the application and addressed debugging issues.

●Used Team Foundation Server (TFS) for source control, reporting, check-in policies, build scheduling, and project tracking.

●Implemented Application Insights Azure for application monitoring.

Environment: Visual Studio, .NET Framework 4.5, C#, GIT & TFS, (WCF), JSON, ASP.NET MVC 3 & 4, HTML, JavaScript, LINQ, Bootstrap, CSS3, Angular JS, Telerik & Kendo controls, ASP.NET Web Forms, Web Services, SQL Server, PL/SQL, JQUERY/AJAX, XML SOAP, WSDL, Application Insights Azure.

Solvios Technology – Ahmedabad, India Jan 2016 – Sept 2017

.Net Developer

Responsibilities

●Designed and developed the architecture, Web UI, business layer domain model, UML class, and sequence diagrams for the Renewals, Company, Regulator, and Filing subsystems using ASP.NET, C#, Oracle, Hibernate, and Spring.NET.

●Created data access classes to streamline database interactions and enhance system performance.

●Developed materials and presentations for conducting training sessions for the entire application development department.

●Focused on process and code improvements, leveraging design best practices and tools to create a configurable and extensible UI for future reuse, thereby reducing development time.

●Developed user interfaces using classic ASP, ASP.NET, ADO.NET, and Code Behind modules. Worked with the Model View Controller (MVC) design pattern to enhance UI design.

●Implemented new functionalities following the open/close design pattern, Inversion of Control (IoC), and Dependency Injection (DI).

●Created service contracts, data contracts, and operation contracts using C#.

●Developed SSIS packages to pull data from external systems, facilitating data integration.

●Worked extensively with the Knockout JS framework for client-side scripting.

●Created controllers and views, passing models to controllers from WCF.

●Developed RESTful Web APIs to expose analytics data to clients and implemented global-level authentication using message handlers in Web API.

●Utilized Web API routing prefixes on controllers and implemented a custom controller factory for dynamic attribute invocation.

●Worked with Automapper to map between entity models and custom view models, implementing custom resolvers for Automapper.

●Utilized Entity Framework EDMX and the hibernate ORM tool for creating database objects.

●Updated and tracked tasks using VersionOne Scrum Project Management tool for effective sprint burn-down.

●Collaborated with business analysts and management to evaluate business requirements and processes, recommending infrastructural and application solutions.

●Migrated web pages from ASP.NET 3.5 to 4.0, focusing on security aspects such as Cross Site Scripting (XSS), SQL Injection prevention, database security, and code access security.

●Actively involved in the design of the database, functional analysis using UML class and sequence diagrams, and user interface design.

●Implemented custom role-based user authentication and authorization using Windows Integrated Security, Active Directory/LDAP services, and custom user roles and permissions in SQL Server.

●Developed ASP.NET web services for accessing LDAP for user permissions.

●Applied Domain-Driven Design (DDD), Test-Driven Development (TDD), and Agile methodologies for developing core C# business classes.

●Applied business validations and rules using ASP.NET validation controls and C# business rules classes.

●Utilized C# LINQ with Lambda expressions for concise and efficient code processing.

●Developed web pages using Visual Studio 2010, ASP.NET 3.5 web forms, C# 3.0, and ADO.NET 3.5.

●Created pages and views in SiteCore 6.6 Content Management System (CMS).

●Created unit test projects in NUnit for business rules testing and applied Continuous Integration (CI) using Cruise Control and TFS build servers, integrating C# unit tests execution into the CI build process.

Environment: Microsoft ASP.NET 4.0/3.5, MVC3/4, Entity Framework EDMX, Visual C 4.0/3.0, LINQ, Visual Studio 2010/ 2012, TFS, WCF, Web API, Web Services, Windows Server, SQL Server, IIS 6.0, NUnit, NHibernate, Spring.NET, jQuery, ReSharper, Reflector, Agile/Scrum.

Technoduces Info Solutions Pvt. Ltd. – Tamil Nadu, India June 2013 – Dec 2015

.Net Developer

Responsibilities

●Designed and developed integration modules with third-party credit bureaus and LoanSafe using ASP.NET, HTML, JavaScript, and XML.

●Developed client programs for consuming web services, enabling seamless integration and data exchange.

●Coded and scripted in C#, ASP.NET, SQL, and JavaScript within a multi-tiered web-based .NET Framework 3.5 and SQL Server environment.

●Built mid-tier web services to retrieve data from the data layer and feed it to presentation layers in ASP.NET pages and Windows applications.

●Developed rich front-end user interfaces using AJAX controls, Silverlight 4.0, Expression Blend, and XAML.

●Created website navigation using the Accordion feature in the AJAX control toolkit.

●Implemented GridView controls to display data in a well-organized manner with sorting and paging functionalities.

●Customized web controls within GridView item templates to enhance user interaction and data presentation.

●Developed a message center for the LMS to facilitate communication between users and applications, with filtering and message counting capabilities.

●Utilized .NET reflection to retrieve class information and bind it to DataTables.

●Wrote triggers for table updates and deletions, loading historical data into history tables.

●Developed a web page enabling users to run external programs directly from the web interface.

●Wrote stored procedures for various functionalities, including updating start/end dates of components and retrieving loan details.

●Added JavaScript code to handle multi-click events on buttons, ensuring smooth user interactions and confirmation messages for critical actions like deletions.

●Constructed classes and implementations to encapsulate data by class objects instead of using datasets.

●Utilized DOM manipulation with JavaScript to update and manipulate ASP.NET web server controls dynamically.

●Designed and developed screens for mortgage broker and loan officer hierarchies, along with admin ASP.NET pages using Visual Studio.NET.

●Developed a real-time underwriting module to automatically approve or deny loans based on predefined criteria.

●Customized merchant setups for new merchants and storefronts.

●Provided maintenance and support for the LMS system, ensuring its smooth operation and functionality.

●Enhanced data conversion products and managed the import of loan data from old systems to new ones, ensuring data consistency and balancing between LMS and the old system.

●Developed web services for application processing and approval engines.

●Created and updated mobile pages using Xamarin Forms for cross-platform mobile applications, enhancing the accessibility and usability of the system on various devices.

Environment: Microsoft ASP.NET 4.0/3.5, Visual C 4.0/3.0, Silverlight, LINQ, AJAX toolkit, Visual Studio 2010, TFS, WCF, Web Services, Windows Server, SQL Server, IIS 6.0, NUnit, Enterprise Library, Xamarin, jQuery, ReSharper, Reflector, Agile/Scrum.



Contact this candidate