Sql Server .Net Core
Resume:
Akshay
*******.***@*****.***
Summary:
Over 12 years of IT experience with analyzing, designing, development of Internet, Intranet, Client Server, and Object-Oriented applications built in .NET and VC++ with other modern cutting-edge technologies.
Extensive working experience in Microsoft .NET 4.7.x,4.5,4.0, 3.5, and 2.0, Entity Framework 4.0, with C# and VB.Net, .Net Core (6.0,5.0,3.1/2.0), ASP.Net MVC 5.0, WCF, LINQ, Web Services, JavaScript, jQuery, Telerik User Interface (Kendo UI), JSON, Angular JS, ReactJS 16.x, Redux, HTML, XML, Web API, Node.js, Webpack, Microservices, Micro Front End (MFE), BFF, CoreUI, CQRS and SQL Server 2014/2016/2022.
Extensive experience on Angular and ReactJs as front-end frameworks, to create views to hook up models to DOM and synchronize data with server as Single Page Application (SPA).
Design, implement, and manage scalable cloud infrastructure on Microsoft Azure.
Worked on Redux for state management, React JSX, Hooks, elements, components, props etc.,
Actively involved in Migrating applications from Dot Net 4.0 to Dot Net 7.0, classic to Azure cloud and AWS deployment.
Proficient in Object Oriented Analysis and Design, strong Object-Oriented Programming skills using Visio. Experience in handling various backend data sources like MS SQL Server, MS Access 2010, Oracle, and XML Data source.
Experience in working with Angular 13.x/9.x/2.x modules, services, templates, directives, services, and dependency injection to create a SPA.
Actively involved in Migrating applications from Dot Net 4.0 to Dot Net 7.0, classic to Azure cloud and AWS deployment.
Develop and maintain CI/CD pipelines using Azure DevOps to automate deployment processes.
Utilize Azure Resource Manager (ARM) templates and terraform for infrastructure as code implementations.
TECHNICAL SKILLS:
Internet Technologies
Microsoft .NET framework, ASP.NET MVC 5.0/4.0/3.0, MVVM, ASP.NET
Web forms, Classic ASP, WPF, AJAX, ASP, .NET Core 6.0/5.0/3.x/2.x, Micro Services, IIS Web Server, WPF, WCF Services.
Programming Languages
C, C++, C#, SQL, Python, T-SQL, PL/SQL, VC++ and VB 6.0.
Distributed Technologies
Restful, Web API, WCF and SOAP.
Database
Azure Cosmos, MS Access MS SQL Server 2008/2014/2016, Oracle 11g.
Database Access
Technologies
Entity Framework, LINQ to Entities, LINQ to SQL, ADO.NET.
UI Technologies
HTML5, Bootstrap 4.0/3.0/3.3, Typescript 4.x/2.x, CSS3, XML, JavaScript, jQuery,
React JS, Micro Front End (MFE), BFF (Backend for Frontend), Core UI, Node.js, Webpack, AngularJS 1.x, PHP, Jasmine, Karma, Angular
13.x/9.x/7.x/6.x/4.x/2.0, WebSockets.
Tools and Technologies
JIRA, MS Visio, SQL Server Management Studio, SQL Server Data Tool,
Visual Studio 2022/2019/2017/2015/2013/ 2012/2010/2008, Visual Studio Code, Okta, Mulesoft, ZAP and Version One.
Design Tools
UML, Visio 2000 for enterprise architects.
Version Control and
Installation Tools
Bit Bucket, GitHub, PVCS, Visual Source Safe, Tortoise SVN, MS Team
Foundation Server and HPOO.
Reporting Tools
Crystal Reports, SSIS, SSRS.
SDLC Model
WaterFall, Kanban and Agile.
Operating Systems
Windows 10/8/7/2000/XP/NT/98, UNIX, LINUX.
Cloud Platform
Microsoft Azure,AWS.
Log Analytics Tools
Dynatrace, Stackify, Splunk, PRTG
Build Tools
Docker, Jenkins and GitHub
Other Tools
ReSharper, Splunk, Swagger, Soap UI, Postman, SonarQube
Professional Experience:
Akkodis/ICF,(REMOTE) Jan 2025 to Present
.Net Full stack Developer
Project: CSPDC Survey Systems
Led Development of a Scalable Web Application using .NET 8 Core and C# for backend services, React.js, and Bootstrap for frontend, ensuring a seamless, responsive, and performant user experience across devices.
Architected and Implemented Role-Based Access Control (RBAC), establishing a secure and flexible system for managing user roles and permissions at various levels within the application, improving user access management and security.
Created Typescript reusable components and services to consume REST API's using Component-based architecture provided by Angular 4/5.
Integrated Multi-Factor Authentication (MFA) using industry-standard protocols (e.g., Google Authenticator, Auth0, or AWS Cognito), significantly enhancing application security and reducing unauthorized access.
Employed Database-First Approach with SQL Server, generating and managing database schemas through Entity Framework, ensuring efficient data access and streamlined development processes.
Configured AWS SES (Simple Email Service) to handle all transactional email communication, such as account notifications and password resets, improving user interaction and engagement.
Containerized the Application Using Docker and deployed it to AWS Cloud, optimizing application portability, scalability, and resource management in production environments.
Implement TypeScript in conjunction with .NET-based APIs, ensuring that the frontend communicates with backend services effectively, often via REST APIs or GraphQL.
Utilized AWS Elastic Beanstalk and ECS for container orchestration and management, ensuring high availability, fault tolerance, and ease of application scaling within the cloud infrastructure.
Developed RESTful APIs and integrated them with the frontend to allow dynamic data exchange between client and server, ensuring seamless, real-time updates and interactions.
Implemented Automated Testing and CI/CD Pipelines using tools like AWS CodePipeline or GitLab CI, allowing for continuous delivery and rapid iteration on features with minimal downtime.
Collaborated with cross-functional teams including UI/UX designers, front-end developers, and DevOps engineers to deliver features in an agile environment, improving communication and project turnaround times.
Develop and maintain backend APIs using ASP.NET Core or other .NET technologies, integrating them with frontend TypeScript code as needed.
Optimized Application Performance by identifying and addressing bottlenecks in both frontend and backend, implementing best practices in code optimization and efficient resource utilization.
Monitored Application Health and Logs using AWS CloudWatch and other monitoring tools to ensure high availability and resolve production issues proactively.
Ensured Compliance with Security Standards including data encryption at rest and in transit, secure API access, and adherence to best practices for authentication and authorization.
Provided Documentation and Knowledge Sharing to ensure seamless onboarding for new developers and maintain detailed project documentation for future reference and compliance.
Environment: MVC3/2, MVVM, C, CSS, HTML, ADO.NET, Linq, Entity Framework, Visual Studio 2010, J-Query,Java Script, Web Services, SQL Server Reporting Services SSRS, SSIS and T-SQL SQL Server 2008, XML, XSL/XSLT.
Patterson Companies, Mendota Heights, MN (REMOTE) Aug 2022 to Dec 2024
Lead .net Full stack Developer
Project: E-commerce Web Applications
Built decoupled, distributed Microservice-based architecture for the E-commerce ecosystem to handle purchase ordering, tracking, and reporting.
Implemented numerous frontend components using the React Micro Front End (MFE) application with Core UI.
Implemented high performing grids like jqGrid for displaying JSON data from server side MVC controllers.
Develop and maintain web applications using C#, ASP.Net, Web Services, WCF,WPF, SQL Server 2016, HTML5, JavaScript, jQuery, andCSS3.
Development of windows application forms using C#.Net and designed front-end forms using Microsoft Adorner.
Ensure smooth integration between frontend and backend, managing the flow of data between the TypeScript-based frontend and .NET APIs.
Design and developed various view and partial view using Object Oriented JavaScript, Bootstrap, JSON, jQuery, Ajax Helpers, Angular and Node.js.
Developed real-time data streaming solutions between MySQL and .NET systems using Kafka or RabbitMQ.
Provide guidance and support developers to implement Azure SQL deployment with service tiers or scaling resources, Connectivity, Backup and Restore, Performance and Query Execution, Azure Security, Privacy and Compliance and Authentications.
Design and develop modern cloud-optimized ASP.NET Core enterprise web applications which are lightweight and modular, with built-in support for dependency injection, enabling greater testability and maintainability.
Implemented autocomplete textbox functionality in MVC. jQuery validation and MVC unobtrusive validation were used to validate form fields, used custom error pages when needed.
Designed robust communication strategies between microservices using gRPC, HTTP, and message brokers like Kafka or Azure Service Bus.
Did performance tuning, optimized the query execution using SQL database adviser and tracking the Database operation (INSERT, UPDATE, DELETE) using Change Data Capture (CDC).
Closely worked with Application using React.JS and Node.js libraries NPM, gulp directories to generate desired view and flux to root the URLs properly.
Developed and maintained robust applications using C# in .NET, emphasizing performance, scalability, and maintainability.
Built data pipelines to transfer transactional MySQL data to data lakes or warehouses for analytical processing.
Worked on JavaScript frameworks (Angular JS, Node JS) to augment browser-based applications with MVC capability.
Used various WPF controls, Telerik controls, developed User Controls to design custom UI to meet the requirements and to increase the ease of use for customers.
Designed and developed RESTful APIs using ASP.NET Core to enable secure and efficient communication between applications.
Implement error handling mechanisms both in TypeScript (on the frontend) and .NET (on the backend) to ensure smooth application performance.
Used RESTful Microservices using .Net Core, to manage the isolation of DB interactions.
Design and develop and test HTML5, CSS3, Bootstrap, JavaScript, jQuery and React.JS that meets accessibility and web browser standards for website.
Integrated DynamoDB with other AWS services, such as Lambda, S3, and Redshift, to build comprehensive data pipelines and ETL processes.
Container management using Docker by writing Docker files and setting up the automated build on Docker HUB and installing and configuring Kubernetes. Utilized Kubernetes and Docker for the runtime environment of the CI/CD system to build, test deploy.
Develop various screens for the front end using React JS and used various predefined components from NPM (Node Package Manager) and Redux libraries.
Worked with modules like MongoDB and mongoose for database persistence using Node JS to interact with mongo db.
Developed loosely coupled application using WPF, C#, MVVM pattern, LINQ, dependency Injection container Unity Container, NHibernate.
Maintenance of a risk application, developed in C# and ASP.NET MVC, and using NHibernate as its Object Relational Mapping (ORM) framework.
Wrote robust unit and integration tests for .NET applications accessing MySQL using Moq or NUnit.
Developed robust, scalable, and secure applications using C# in the .NET framework.
Orchestrated ETL operations for efficient data movement between connectors using Azure Data Factory.
Involved in writing application-level code to interact with APIs, Web Services using JavaScript, AJAX, JSON, XML, AngularJS, Node JS and jQuery.
Working in a Test-Driven Development environment, leveraging QA automation test suite to provide Unit tests and integration tests for all new functionality.
Environment: .Net Core 3.1, MVC 5.0, Angular 9.x, GitHub, SonarQube, Dyna Trace, SQL Server 2016, Swagger, T- SQL, Node.js, React JS,Core UI, Web API, Okta, XUnit, ReSharper, MSTest, Docker, Kubernetes, LINUX, and Azure DevOps.
U.S. Bank Corp, Minneapolis, MN Jan 2020 to July 2022
Lead .net Full stack Developer
Project 1: Online Banking Web Applications
This project is about upgrading the existing US Bank’s Online Banking application with Latest Frameworks. The existing Online Web Applications compose Authentication, Bill Pay, Money Movement and Mobile Banking.
Internally liaise on enterprise AWS migration, DB migration, offshore resource Oracle forms work and timeline deliverables.
Successfully utilized code-first approach to design the database in the .NET environment by using, C# in the ASP.MVC5 environment.
Utilized AngularJS to achieve the client-side elements Hide, Show, Event Handling and AJAX Call on JSON response, and implemented Angular’ s jqLite to achieve SOM manipulation.
Developed the code to send the automated emails from NodeJS when an action is performed on front-end Angular view pages.
Efficiently implemented Data and control templates to dynamically change the behavior and appearance of the UI Control using XAML for WPF application.
Used async/await in both TypeScript and C# for non-blocking operations, especially when handling API calls or heavy computation tasks.
Ensured secure data transmission between microservices by configuring HTTPS and enabling mutual TLS.
Develop and implement database connection layers using .NET frameworks like Entity Framework or ADO.NET.
Worked on cross browser web application using ReactJS with Redux, Redux Forms, ES6, HTML5, Sass and Bootstrap. And have experience on working with React Router for developing Single Page Applications (SPAs).
Worked on using ReactJS components, Forms, Events, and Router.
Involved in UI Designing, Development and Testing of Web Forms using ASP.Net, C#, XML, ADO.Net and .NET Framework.
Integrated Redux with React to handle large chunks of data for better performance.
Deployed and configured Elastic search, Log stash and Kibana (ELK) for log analytics, full text search, application monitoring in integration with Lambda and CloudWatch.
Implemented continuous integration pipelines for MySQL schema changes in .NET projects using GitHub Actions or Jenkins.
Implemented authentication and SQL Cache Dependency in WCF Services and Configure TCP Protocol, Transport Level Security in WCF Service. Implemented Windows Authentication in WCF to consume the Service as application is used in intranet.
The application was designed and developed using ASP.NET MVC, Razor and ASP.NET WEB API technologies in an end-to-end service-oriented architecture running in the cloud
Involved in implementation of RESTFUL web service APIs using Node js, which were consumed by making AJAX calls and JSON as data exchanging tool.
Developed business logic using C#.NET, used the developed data layer class extensively for database related transactions.
Design and developed web pages using Javascript, React, Redux, HTML5, CSS3 that meets highest standards in latest design and user experience.
Developed responsive, type-safe frontend applications using TypeScript and frameworks such as React or Angular, improving code maintainability and reducing runtime errors by 30%.
Deployed and managed microservices clusters using Kubernetes, Docker Swarm, or OpenShift.
Conducted workshops on optimizing MySQL queries and database design for .NET development teams.
Part of the application architecture group, handling all architectural concerns for the modernization of Rest APIs on AWS platform using Microsoft ASP.net Core implementation.
Designed and developed tool for recruiters that helps in hiring process (Resource Management) using C#.NET, ASP. Net MVC and deployed into App Service in Azure.
Integrated TypeScript with ASP.NET Core backend APIs, ensuring seamless data flow between frontend and backend, resulting in a 40% improvement in data consistency
Worked in a major application upgrade from .NET framework 3.5 to 4.7.2 that included WCF services, WPF and Database objects.
Used Platform as a Service with AWS Elastic Beanstalk to host Node.js and used Infrastructure as a Service with AWS Elastic Compute Cloud (EC2) to host Angular application.
Environment: .NET Framework 4.7.2, C#, ASP.NET, MVC, jQuery, HTML, CSS3, JavaScript, Sencha Touch, TFS, AngularJS, Node.js, SQL Server, T-SQL, Gulp, React JS, Redux, Lambda, HPOO, JIRA, Splunk, LINUX, and Azure DevOps.
Project 2: Phoenix Web Application (IBM FileNet Content Navigator)
In this project, it is for managing consumer loan business processes using the Phoenix Web Application. The existing business processes used IBM FileNet Content Navigator. IBM developed software to help enterprises manage their content and business processes. The FileNet P8 platform, their flagship system, is a framework for developing custom enterprise systems, offering much functionality out of the box and capable of being customized to manage a specific business process.
Implemented CRUD operations using $http service to call Web API methods and REST API Documentation Using Swagger UI. Used Entity framework with AutoMapper for mapping entities to Database objects.
Configured security features for the application using Form Based Authentication and Role Based Authorization using C# and ASP.NET.
Used a microservice architecture, with Node.js-based services interacting through REST endpoints. Deployed services to AWS in containers using EKS.
Designed and implemented Azure Event Hub to move on-premises data to the Azure cloud platform.
Created ETL Transformation scripts in DBT. Worked on Utilization platform where Data from multiple sources is ingested into AWS S3/ Redshift and transformed using PySpark scripts in Data Bricks.
Design and develop Web Applications and services using different technologies and programming languages such as C#, Java Script, Angular 8, SQL.
Migrated applications to a Dockerized MySQL setup to support containerized .NET microservices.
Designing, developing and testing the web application by using the HTML5, CSS3, Bootstrap, React.js and Redux, Node.js and Express.
Created ASP.NET pages using C#.NET for middle-tier processing of client requests with ADO.NET interfaces for database and implemented stored procedures .
Worked with ECMAScript 6 features. For the build of JSX and ES2015(ES6) Babel used webpack.
Integrated existing APIs to Azure API management to get all the attributes like security, usage plans, throttling, analytics, monitoring, and alerts.
Silverlight application development using WCF services ADO.NET entity framework using LINQ . WPF Browser and Desktop applications with WCF ADO.NET entity framework using LINQ .
Utilized Bootstrap and to develop a reactive website from a static JavaScript, Node JS, Bootstrap, Semantic UI, RESTful API, jQuery existing code base.
Integrated MySQL with Hadoop or Spark for big data processing workflows in .NET applications.
Part of the application architecture group, handling all architectural concerns for the modernization of Rest APIs on Azure platform using Microsoft ASP.net Core implementation.
Developed Java-based microservices using Spring Boot for data processing and integration tasks within the AWS environment.
Created a web application deployment using Visual Studio Team Service in DEV, IT, UAT and PROD environment.
Used various libraries of JavaScript like AngularJS, jQuery, Node.js. and identify all NPM modules to available in Nexus Repository to build and deploy code successfully.
Participated in daily standups and actively Involved in Agile Scrum Development by monthly basis.
Environment: .NET Framework 4.7.x, C#, ASP.Net Core, MVC, Angular 7.x, VMware Clarity, Ngxs, Redux, TFS, Oracle, Jasmine, Karma, Node.js, TypeScript, ReactJS, ReSharper, MSTest, Swagger, Splunk, Polly, LINUX, and Azure DevOps.
Wells Fargo, Minneapolis, MN June 2017 to Dec 2019
Senior .net Full stack Developer
Project: Deployment Management and Notifications (DMaN)
Wells Fargo has a Deployment Management and Notifications System that supports the needs of the Enterprise Patching Program (EPP) and Operation teams. Its primary purpose is to help teams manage deployments of assets on the Wells Fargo LAN.
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 (SPA)
Designed and developed several user controls and custom controls that are used in the entire application using C# and ASP.NET and Implemented complex functionalities in the application using WCF services and consumed Web API services to communicate with external systems.
Enabled Cloud data architecture for IIG and migrated data from DB2 tables to various micro service apps, cloud databases AWS Aurora PostgreSQL.
Developed and maintained RESTful APIs using ASP.NET Core to serve as backend services for TypeScript-based frontend applications, ensuring seamless communication and data exchange.
Responsible for developing the Data Access Layer (Model) using ADO.NET Entity Framework Model, LINQ to Entities, UNIX, Linux and C#.
Built responsive multithreaded client and WPF frameworks from the ground up using PRISM based on Martin Fowler’s enterprise patterns for MVVM and DDD.
Automated MySQL health monitoring and alerting using Grafana and Prometheus integrated with .NET dashboards.
Integrated Redux with React to handle large chunks of data for the better performance.
Tested various server-side layers (Domain, Service) Unit Testing using the VSTS.
Participated in a collaborative team designing software and developing a Snowflake data warehouse within AWS.
Design and develop Web Applications using ASP.NET MVC 5 and C# that are used by internal users.
Created a Continuous Integration web deployment using micro service in DEV, UAT, SIT and PROD environment.
Actively Involved in Agile Scrum Development by bi-weekly basis.
Environment: .NET Framework 4.6.1, C#, ASP.NET, MVC, TFS, LINQ, ReactJS, Angular, Node.js, TypeScript, SQL Server, T-SQL, HTML, CSS3, JavaScript, JSON, ReSharper, Moq, MSTest, Swagger, Splunk and Azure DevOps.
Zurich Insurance, RCIS, Anoka, MN Sep 2015 to May 2017
Roles: .NET Consultant
Project: CIMax software
RCIS, Zurich's newest business segment, strives to cultivate strong relationships with crop insurance agents and agricultural producers across the nation. As a leading crop insurance provider and an Approved Insurance Provider (AIP) through the United States Department of Agriculture (USDA), RCIS offers insurance protection in all 50 states through a national network of approximately 3,800 professionally trained and licensed agents. Keeping track of all crop insurance business with the evolutionary CIMax software makes it extremely easy to calculate and track quotes, APH records, acreage reports, and notice of loss. Mapping services have also been updated with the addition of FarmMaps to the CIMax software.
Involved in the team right from the initial stage of requirement gathering.
Worked on Single-Page Application architecture and comfortably programmed on all the tiers in the application.
Created new modules using ASP.NET MVC, HTML 5, XML, CSS 3, jQuery, Angular JS, and Bootstrap. Design & developed several user controls and custom controls that are used in entire application using C# ASP.NET.
Developed JavaScript (jQuery) tabs and main navigation menus using CSS sprites technique.
Implemented Rest Services using node JS and C# to serve the web application with JSON data.
Successfully deployed and managed multiple releases of the web forms application, ensuring continuous integration and delivery using Azure DevOps.
Analyze and understand the existing Crystal Report design to migrate into SSRS.
Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
Responsible for design, programming, deploy and Database Unit Testing of requested Reports, coordinated with front-end for implementing logic in stored procedures & functions. Actively participated in weekly sprints & retros.
Environment: Visual Studio 2015, .NET Framework 4.6, C#, HTML 5, XML, CSS 3, JavaScript, ASP.NET, MVC 5.0, WPF, Entity Framework, ReactJs, OAuth, WEB API, VB.Net, SSRS, SSIS, WCF, SQL Server 2012, AngularJS, MSTest, TFS, BI Tools, Version One.
Indecomm Holdings Inc, St. Paul, MN June 2013 to Aug 2015
Dot Net Developer
Project: Document Management solutions (DMS)
Description: Indecomm mortgage document management solutions combine Cloud-based platforms with deep domain expertise to provide title companies and lenders with a one-stop resource for managing workflow processes in recording, lien release, assignment, post-closing, and final documents management. Indecomm's Cloud-based platforms include Viewpoint for final documents management, Dynamic Doc Hub for post-closing audit and InteleDoc Direct for e-recording.
Developed an Image Management System to handle recorded Mortgage documents and customer daily image import process automated using Windows Service.
Designed and implemented application using C#, ASP.NET MVC 4.0 with Razor View Engine, jQuery, AJAX, HTML5, JavaScript, HTML5, CSS3 and Bootstrap
Develop geographic-based performance evaluation to improve title agent & correspondent lender communication.
Integrated exception handling and logging feature using ELMAH and log4net.
Integrated security monitoring and alerting tools (e.g., ELK stack, Azure Security Center) to proactively detect and respond to security incidents.
Designed & developed key parts of a large enterprise business process/workflow management application for ACH Workflow application using WWF.
Worked on AWS components such as Elastic Search, EMR, Athena SNS, CDK, Step Function, SQS, Cloud Formation, Secret Manager, Snowflake.
Created Web APIs using ASP.NET Web API allow new web/client projects to leverage reusable data. This has allowed significant data reuse amongst disparate systems. The following APIs have been created: Home Loan Information, Agents Information, and User Information.
Created WCF Services and all the db transactions from clients were mediated through these services for additional data security. Development of Web forms, User Controls using MVC pattern.
Deployed services to Azure Kubernetes Services using Azure CI/CD pipeline and containerized applications.
EBS volumes as per instance type in different availability zones & multiple regions in AWS.
Implement User authentication to restrict the users from accessing configuration parameters of the functional test.
Created test cases to automate and perform functional testing of the front-end using Selenium (IDE and Web Driver). Performed Mobile testing, performance testing and Cross Browser testing for web application using Selenium. Collaborated and Led various UAT and Prod Releases on a weekly and bi- weekly basis depending on schedule.
Environment: .NET Framework 4.5, VB.Net, Classic ASP, C#, ASP.NET, MVC 5.0, HTML 5, XML, CSS, JavaScript, WPF, jQuery, AngularJS, TFS, SQL Server 2008/2012, T-SQL, Entity Framework, MSTest, Node.js, Bootstrap, Sass/Less, Web API.
Contact this candidate