C# Sql Server

Prem Chand P

PROFESSIONAL SUMMARY:

• Over **+ years of experience in designing, developing, and testing N - Tier Client/Server Web-based Applications using Microsoft .NET Framework and SQL Server with Agile and Waterfall Development Methodology.

• Outstanding .NET Full-Stack Developer with proven expertise in all phases of SDLC.

• Expert in Microsoft Technologies like C#, ASP.NET 5.0/4.5/4.0, MVC 5.0/4.0, Entity Framework 6.0/5.0/4.0, ADO.NET, SQL Server 2014/2012/2008 R2, WCF 4.5/4.0, Web API Restful Services, IIS 7.0/6.0.

• Led the development of a high-performance backend system using C# and .NET to support a retail platform, optimizing for scalability and high availability.

• Designed and implemented backend components within a distributed system architecture, ensuring reliability and fault tolerance across services.

• Expert in developing data layer using Entity Framework, ADO.NET, and LINQ.

• Strong experience in creating and consuming Restful and SOAP Web Services.

• Strong experience in developing SQL queries, functions, stored procedures, triggers, and views.

• Expertise in developing applications using .NET 4.5/4.0/3.5, C#.Net, ASP.Net, VB.Net, ADO.Net, WPF, XAML, HTML5, JavaScript, JQuery, Angular, AJAX, and CSS3.

• Worked closely with frontend and operations teams to ensure smooth system integration and continuous improvement through Agile methodologies.

• Leveraged AWS services (such as Lambda, RDS, and S3) to architect and deploy scalable solutions, improving performance and reducing downtime for a financial system.

• Proficient in Vanilla JavaScript for developing interactive and dynamic web applications.

• Worked as Full stack C# developer with front end UI experience in technologies including XAML, HTML, CSS, Bootstrap, Kendo UI, Angular.js, Node JS, Backbone JS, Marionette.js, Ext JS, Razor, JQuery and JavaScript.

• Extensive experience using JavaScript to create dynamic, responsive user interfaces and developing frontend components with Angular, ensuring seamless data interaction with backend services.

• Adept in integrating JavaScript and Angular with .NET Core for building full-stack solutions, ensuring secure handling of sensitive healthcare data.

• Solid understanding of frontend development using HTML5, CSS3, and JavaScript frameworks, creating user-centric applications for healthcare professionals.

• Experience in design patterns, Async, Func, Action, Lambdas, LINQ, Generics, Parallels with C#, SOLID best practices with C#.

• Strong experience in unit testing tools of JavaScript framework like Karma, Jasmine and Protractor for Angular, Mocha and Chai for React JS.

• Experience in Creating the CI/CD Azure DevOps Pipeline for the .net, java & UI based Web Applications.

• Conducted extensive performance tuning of SQL queries and backend services, resulting in a significant improvement in response times and overall system performance.

• Developed a web application using Angular 12 as front - end and using Web API to receive and pass data to back-end.

• Good experience in Amazon Web Services (AWS) environment and good knowledge of AWS services with Docker and Jenkins experience.

• Expertise in Object Oriented Design Blazor and Programming using technologies like Visual Studio 2017/2015 .Net, ADO.NET, SQL Server for web development.

• Expert in RDBMS include SQL Server 2014/2012/2008 R2 and Oracle 11g.

• Proficient in storing and exchanging data using XML and JSON formats.

• Extensive experience in developing UI screens using HTML5, CSS3, JavaScript.

• Strong ability in Responsive Web Design using JQuery, AJAX, Bootstrap.

• Experience in Repository Patterns and POO patterns such MVC and MVVM with C#.

• Proven ability in reports development and business intelligence solution using SSRS and SSIS.

• Excellent experience in OOPS and Design Patterns like Singleton, Factory, etc. & UML.

• Created Angular 12 components, implemented Interpolation, Input Variables, Bootstrapping, NgFor, NgIf, Router Outlet, event binding, and decorators.

• Experience in creating loosely coupled classes using Dependency Injection.

• Designed and developed distributed backend solutions for a healthcare platform, ensuring scalability and high availability across multiple locations.

• Experienced in MVC and MVVM design pattern.

• Ensured the development of financial systems with robust disaster recovery and high availability, adhering to industry compliance standards.

• Good experience in React JS for creating interactive UI's using one-way Data flow, Virtual DOM, JSX, React Native concepts

• Experience in Micro Services with .NET Core with REST Web API and SOAP Web services using Microsoft technologies.

• Experience with Test-Driven Development (TDD) like N-Unit testing frameworks and MS unit Tests

• Experience in database design and development using SQL Azure, Microsoft SQL

• Strong experience in Test-driven development using MS Unit Testing and NUnit.

• Knowledge of deploying and implementing Cloud solutions using Microsoft Azure.

• Knowledge of using Continuous Integration/Continuous Deployment (CI/CD) tools as Jenkins.

• Solid experience in developing WCF Services using C#, SOAP, UDDI and XML.

• Experience in version control with Git & TFS 2015/2013/2012.

• Experience in bug tracking, issue tracking using JIRA.

• Self-motivated team player with a passion for solving analytical problems and thirst for new technologies.

TECHNICAL SKILLS:

Programming Languages

C#, .Net Core, Core Object oriented principles, JAVA, VB.NET, MVC, Web Services, WCF, WPF, SQL, T-SQL.

Web Technologies

ASP.NET, HTML5, SASS/LESS, CSS3, DHTML, XML, XSL, SOAP, REST, WSDL, AJAX, JSON, web sockets, Java Script, Razor, VB Script.

JavaScript Libraries

JQuery, Angular JS, Angular 2.0,4,6,9,Bootstrap,Javascript,Typescript

Middle Tier

Internet Information Server 6.0/7.0, ADO.NET, NHibernate, Entity Framework 6.0

Databases & BI Tools

MS Access, SQL Server 2008 R2/2012/2014, MySQL Workbench, DB2, SSIS, SSRS

Operating Systems

Windows XP/Vista, Windows 7, Linux

GUI Tools

Microsoft Visual studio 2010/2012/2013/2015, SQL Server /2008 R2/2012/2014, N-Unit 2.5/2.6, Install shield 2011, Wise installation studio 7.0.

Version Control tools

SVN, TFS, GIT

Design tools

IBM Rational Rose, MS Visio.

Unit Testing

NUnit, White box testing, Black box Testing

PROFESSIONAL EXPERIENCE:

Client : TJX Companies - Boston, MA Role : Sr. Full Stack .Net Developer Feb 2023 – Till Date

Responsibilities:

• Worked in Agile Scrum methodology and delivered accepted functionality in each sprint.

• Played key role in feature implementation and enhancement, code refactoring and defect fixing.

• Designed and developed Hybrid-Single Page Application using C# 5.0, .NET Framework 4.5, ASP.NET MVC 5, and Angular JS.

• Efficiently used Angular 10+ to develop the front-end and built backend with .NET Core Web API

• Consumed SOAP APIs from enterprise Blazor customer system and Restful APIs provided by other applications in the portfolio, also created W&C Restful APIs.

• Participated in UI design with Master Pages in MVC 5 and improved layout with HTML5, Bootstrap, and CSS3.

• Led the development of a high-performance backend system using C# and .NET to support a retail platform, optimizing for scalability and high availability to handle a large volume of transactions.

• Developed web application using .Net Core 2.0 framework. Used Entity Framework ORM as repository layer to connect to database. Implemented LINQ queries to perform CRUD operations.

• Experienced in DOM manipulation using Vanilla JavaScript for creating dynamic user interfaces.

• Used Angular JS, JavaScript to develop templates, controllers, and directives.

• Used Require JS JavaScript library to dynamically load ASP.NET bundles.

• Development level experience in Microsoft Azure, ASP.NET, ASP, and C #.NET, Web Services, WCF, ASP.NET Web API, ADO.NET, JavaScript, JQuery, Angular JS, Bootstrap, PowerShell, CSS, HTML, UML and XML.

• Implemented effective performance tuning strategies to optimize SQL queries and improve the overall speed and efficiency of the backend system.

• Extensively used Material UI for all the component designs in the react app to maintain a standardized experience throughout the application along with the customized stylings.

• Used Math.net library to implement methods and algorithms for numerical computations.

• Provided database connectivity using Entity Framework 6.0, LINQ, designed stored procedures and views at the back end.

• Implemented client-side Interface using React JS. Build stable React components and stand-alone functions to be added to any future pages.

• Extensive experience working with HTML, JavaScript, .NET Core 2.0, jQuery, Angular Js 2/4/5, Typescript.

• Designed and implemented distributed systems that ensured reliability and fault tolerance across multiple services, meeting the demands of the retail environment.

• Utilized containerization with Docker to streamline deployment processes, improving system flexibility and making it easier to scale across different environments.

• Designing and Developing Micro-services that are highly scalable, fault-tolerant using .Net Core.

• Implemented Services by using HttpClientModule in Angular 14 for making the API calls and inject data into the required components.

• Developed a retail management system using Angular and JavaScript, enabling store managers to manage inventory, sales, and customer orders in real-time.

• Designed dynamic product catalog pages using Angular components, providing a responsive and interactive experience for both desktop and mobile users.

• Implemented RxJS for efficient data handling in real-time, ensuring quick updates to inventory levels and order status without page reloads.

• Worked on Azure Cloud Service application and developed Web, Worker roles.

• Contributed in data migration from Oracle DB to SQL Server using PL/SQL and T-SQL.

• Generated data migration and transformation using SSIS, and built reports with SSRS.

• Developed the application using WPF, C#, MVVM, XAML, Entity Framework, Visual Studio 2015/2017.

• Design and development of Server Side Rendered Progressive Web Applications built with ReactJS, Next.js, Node.js, Firebase and Material - UI using HTTPS, Web App Manifests, Service Workers and browser APIs.

• Involved in full stack development which involves HTML, CSS, Angular, Kendo UI, Web API, Entity framework, SQL server, SSIS & SSRS.

• Designed Graphical User Interface (GUI) in C#, VB.Net, ASP.Net, AJAX, Webforms.

• Developing Web APIs in .Net Core 2.1 platforms and consume in web-based application, consume 3rd part APIs to interact with check scanning & depositing process.

• Migrated databases from SQL Server to Azure SQL Server.

• Used JSON web token to do user authentication and secure information exchange.

• Used Dapper for Object relational mapping (ORM).

• Designing WPF Forms, Custom Controls and User Controls using XAML language for interactive UI.

• Using Microsoft Technologies for the project development such as Visual Studio 2017/15, .Net framework 4.7.2, C# 4.7.2, SQL Server 2017/16 and TFS 2018.

• Development was done using agile methodology with daily scrums, paired programming using TDD and continuous integration Blazor using the SDLC process.

• Developing Windows Communication Foundation services (WCF) Used Team Foundation Server (TFS).

• Working in MVC 4, JQuery, C#, and VB.Net, JavaScript, CSS, JSON, Razor Engine and View designs.

• Worked on React JS Virtual DOM and React Views, rendering using components which contains additional components called custom HTML tags.

• Made use of several .NET AJAX controls to render the content dynamically on Webpages which are developed using C#.

• Using JIRA to tacking tickets and log works. Write unit tests for the already developed C# project having thousands of lines of code.

• Designed unit testing module with NUnit to test the application performance and availability

• Heavily involved in code review, build and deployment with GIT, Jenkins.

Environment: .NET Framework 4.5, .Net Core, Visual Studio 2015, C# 5.0, VB.Net, ASP.NET 4.5, MVC 5.0, Entity Framework 6.0, Azure, Web API 2, React JS, JIRA, SQL Server 2014, HTML5, CSS3, JavaScript, Angular JS 1.5, AJAX, IIS 7, LINQ, SSIS, SSRS, Git, Agile, Jenkins, NUnit.

Client : Principal Financial Group, Des Moines, IA

Role : Sr. Full Stack .Net Developer Sep 2021 – Jan 2023

Responsibilities:

• Developed Business Tier using C# 5.0 to implement classes and methods for business logic.

• Designed, developed, and enhanced the application using .NET Framework 4.0 and MVC 4.

• Developed Razor views with strongly typed view models, helpers and partial views using ASP.NET MVC 4 to display required news and data on Dow-Sync’s Display section.

• Used Signal R and JavaScript to manage real-time data and enhance real-time chat function for Messaging section

• Worked on UI layer using Angular JS 1.3/1.4 HTML5, CSS3, and Bootstrap to build rich, flexible and user interactive web pages.

• Used Material UI, Angular Material and Resin Rendition controls for Drag-and-Drop, Widgets, Menus, User Interface and Forms.

• Reconciled exposure, price and MTM between Endur V14 and Allegro, Endur V9 and other legacy systems

• Consumed Web API Restful for building Service-Oriented Application hosted by IIS 7.0.

• Created WCF service using HTTP and SOAP protocol and maintained existing web services.

• Used SQL Server 2014 as data repository used LINQ to SQL together with Entity Framework 6.0 writing data access classes, stored procedures, triggers, views to capture and modify data.

• Architected and deployed cloud-based solutions for a financial system using AWS services like Lambda, RDS, and S3, improving performance and ensuring scalability to handle high transaction volumes.

• Led the development of a real-time trading platform in the finance sector, using Angular and JavaScript to display live stock prices, trade status, and market data.

• Integrated REST APIs from a .NET Core backend to securely fetch real-time trading data, ensuring compliance with financial regulations and industry standards.

• Developed real-time charts and graphs using JavaScript libraries, such as Chart.js, to visually represent stock trends, helping traders make informed decisions.

• Utilized Angular 8+ and Web API to develop a Web Application

• Designed and developed a full-stack funding website based on Node.js, ReactJS, Next.JS, Wordpress, and Slim Framework.

• Designing WPF Forms, Custom Controls and User Controls using XAML language for interactive UI.

• Collaborated with business analysts and technical teams to meet stringent compliance standards, ensuring that all solutions adhered to industry regulations, such as GDPR and PCI-DSS.

•

• Designed and implemented distributed systems to guarantee high availability and reliability, minimizing system downtime and ensuring the financial system met critical business needs.

• Designing and Developing Micro-services that are highly scalable, fault-tolerant using .Net Core.

• Worked in Test Driven Development (TDD) environment, wrote Unit Tests and Integration Tests.

• Worked on all the Endur feeds to make sure all V12 feeds ran properly and reconciled with V10.

• With the concept of React JS Worked on usage metrics and also end to end events tracing for analysis purpose.

• Design and development in .Net framework, Blazor ASP.Net VB.Net and JavaScript.

• Developed Web API using C#, ASP.NET and Entity Framework 6.

• Worked on Visual Studio 2015/ .Net CORE 1.0 Framework to implement Business Logic.

• Used Dow-Chat as prototype, designed and implemented functions of messaging section.

• Published and deployed Dow-Sync and services through Azure.

• Developed and maintained web application, Fond centre and Third-Party Fund Management for UBS using C#, ASP. NET, Web Services, WCF, SQL Server 2016, HTML5, jQuery, Angular 4, Web API and Ajax.

• Maintaining the Source code using Team Foundation Server (TFS) in a multi developer environment.

• Used team management and version control tools such as Azure DevOps and Git.

• Designed and implemented features using React JS, C# ASP.NET, and SQL server.

• Developed new user interface components for different modules using Kendo UI

• Involved in creating azure cloud service to store inspection data in Blob and SQL Azure

• Application Development, Implementation and Maintenance using Extensive experience in ASP. NET MVC & .NET CORE.

• Utilized Git and JIRA for version control and team project management

• Worked in MVC, JQuery, and VB.Net. Javascript, JSON, Razor Engine and View designs.

• Did R&D in Telerik Kendo UI with Angular 1, Angular 2 & 4, JavaScript.

• Use MS Test to design and develop phases of Test-Driven Development.

• Worked based on Agile SDLC.

• Used Git for version control across common source code used by developers.

Environment: .NET Framework 4.0, Visual Studio 2015, .Net Core, C# 5, ASP.NET 4.0, MVC 4, Signal R 2, ADO.NET, Entity Framework 6.0, SQL Server 2014, React JS, Oracle 11g, LINQ, Restful API, WCF 4.0, HTML5, CSS3, Angular JS 1.3/1.4, AJAX, JQuery, JIRA, T-SQL, Bootstrap, IIS 7.0, JSON, MS Test, Azure, Agile, Jenkins, TFS and Git

Client : Access Health care, Dallas, TX

Role : .Net Developer Jan 2018– Dec 2019

Responsibilities:

• Coordinated with other technical teams, laboratory researchers, and biostatisticians to ensure compatibility with modules and applications.

• Architected and implemented numerous backend web services using C#.NET.

• Used ASP.NET Forms Authentication and Role based Authorization to implement application security.

• Deploying .NET Core applications to Docker containers configuring pipeline in GitHub to build, test and deploy. NET Core applications on different servers.

• Designed and developed UI using XHTML, CSS3, JQuery and Razor Views.

• Implemented form validation using JavaScript.

• Involved WCF REST Services using JQuery AJAX.

• Developed User Interface (UI) using WPF for the better look and feel of the desktop-based application.

• Designed and developed a patient management system using Angular and JavaScript, providing healthcare professionals with a dynamic interface for managing patient records and medical history.

• Designed and developed distributed backend solutions for a healthcare platform, ensuring scalability, high availability, and reliability across multiple locations and systems.

• Developed and maintained REST APIs for seamless integration with external healthcare systems, ensuring adherence to HIPAA compliance standards and protecting sensitive patient data.

• Conducted performance tuning of SQL queries and backend services to optimize response times, ensuring fast, real-time access to critical healthcare information.

• Integrated the JavaScript frontend with a .NET Core backend, ensuring secure and efficient data exchange while maintaining compliance with HIPAA, FHIR, and HL7 regulations.

• Built secure, dynamic forms for entering patient data, using JavaScript to validate inputs and ensure compliance with healthcare standards.

• Development was done using agile methodology with daily scrums, paired programming using TDD and continuous integration using the SDLC process.

• Deploying .Net based Applications and Java based apps on IIS 6.0 and Troubleshooting .Net application issues hosted on the IIS

• Extensively used React JS, Node JS, Express, HTML, and CSS.

• Collaborated with other developers through Git and used team project management tool like JIRA.

• Led collaborative efforts with cross-functional teams to resolve technical challenges, ensuring system stability and continuous improvement in the healthcare solution.

• Implemented Azure Application Insights to store user activities and error logging.

• Used WPF of .NET for creating control templates and more appealing visual appearance.

• Using .Net Core to implement APIs, Repository and Entity Framework.

• Used SQL queries to develop Views, Functions, Triggers, and Indexes using SQL Server 2012.

• Used ADO.NET Entity Framework 5 for Blazor database access, query and manipulation.

• Used Repository Pattern and Factory pattern for reusability of Data Access Logic for all modules.

• Used VB.NET in MVC framework for front-end development.

• Developed UI pages using Angular JS 2.0, HTML5, CSS3, JavaScript, React.js, jQuery, AJAX and JSON.

• Generated data migration and transformation using SSIS.

Environment: .NET Framework 4.0, .Net Core, Visual Studio 2010, C#, ASP.NET MVC4, SQL Server 2012, Entity Framework 4.0, XHTML, CSS2, JIRA, JavaScript, JQuery, AJAX, JSON, SSIS, SSRS, TFS, IIS7

Client : Symplore Inc, India

Role : .Net Developer June 2014 –Dec 2017

Responsibilities:

• Worked with developer team for the new application development in Visual C#, ASP.NET 3.5 /Microsoft Enterprise Patterns and Practices Framework/ SQL Database, LINQ, WCF.

• Responsible for Database design, and creating of Stored Procedures, triggers to perform the Data retrieval from multiple tables using SQL Database.

• Developed ADO.NET Entity Framework to use relational data with a data service by defining a data model that maps to relational data.

• Developed web pages using Asp.Net, JavaScript for Client-Side Validation.

• Developed GUI using MS Visual Studio, ASP.NET Web Forms with Ajax controls.

• Worked with GIT, CVS, SVN and Clear case for version control.

• Deployed applications into test and production environments by using web server (IIS).

• Involved in migration projects from Classic ASP to ASP.Net using VB.Net

• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for Consistent access to SQL data source.

• Effectively used JQuery a concise JavaScript Library for traversing HTML document, event handling and AJAX interactions.

• Accessing personal data, benefits information, requests for PT and payroll, relieving HR from time-consuming data management using HCM.

• Developed Web User Controls and Custom User Controls to minimize code redundancy.

• Extensively used ASP.NET Grid View, Repeater, Details View, Tree View, Data List and Repeater controls for displaying the data in a clear format.

• Worked with ASP.NET Web Forms, State Blazor Management, caching features, configuring optimizations and securing the web application.

• Created AWS EC2 different Instance and selecting Operating System, SQL Server, and Required memory allocation for first time configuration on AWS.

• Hosted WCF service in the Respective remote AWS VM servers.

• Hosting of MVC applications in IIS and creating Cloud Instance using AWS for deployment in product environment

• Developed Unit Test Scenarios and tested Test Scenarios in Web methods using N-Unit.

Environment: ASP.NET, C#, ADO.NET, Visual Studio 2010, .NET, Agile Model, AWS, TFS, LINQ, Web Services, SOAP, Silverlight, JavaScript, Ajax, HTML, XML, SQL Server2005, MS-Access 2000, SQL server reporting Service, N-Unit.

Contact this candidate