.Net Core Sql Server

ABOUT ME

Over *+ years of Software lifecycle experience in Application Software Design, Development, Implementation, Support, and Administration.

Worked on several projects with clients like Premera Blue Cross, Centene, UPS, Thrivent and Hancock Whitney Bank.

PRIYANKA

SENIOR DOT NET DEVELOPER

WORK EXPERIENCE

PREMERA BLUE CROSS

Feb 2024 - Present

Senior Dot NET Developer

Celina, Texas, 75009,

United States of America 281-***-****

********.*******@*****.***

Extensive experience in developing Web-based applications and Client/Server applications using C#.NET, JavaScript, jQuery, LINQ, AJAX and CSS, WCF, REST Services, Angular 2.0,4.0,6.0, .Net Core,

.Net JavaScript, jQuery, LINQ, AJAX and CSS, WCF, REST

Services, Angular 2.0,4.0,6.0, .Net Core, .Net Core MVC, jQuery, React, SQL Server, Vue.js

Strong Working experience in HTML5, CSS3, Bootstrap.

Experience in Using Dynamic CSS like SCSS, and LESS.

Utilized Python for backend scripting to automate routine tasks, reducing manual effort by 20%.

Resolved complex UI challenges, using the latest technologies such as ASP.net, RESTful APIs, HTML5, SCSS, and jQuery.

Experience in Responsive Web Design using Bootstrap CSS, SCSS, and Custom CSS.

End to End exposure in handling client-side validation and experience using jQuery and JavaScript.

Built Single-Page Web Application from scratch, leveraging Angular, React JS, Vue JS, and Typescript. Strong working knowledge of all phases of the Software Development Lifecycle (SDLC) from Analysis & Design to Testing & Implementation.

Strong working knowledge of Object-Oriented Programming techniques.

Extensive experience in SQL Server Database design, Database maintenance, developing T- SQL queries, stored procedures, and

Developed robust VB.NET and C# applications, leveraging ASP.NET Core for building scalable and highperformance RESTful APIs. Designed and implemented Web API endpoints using Entity Framework and LINQ, ensuring efficient data retrieval and manipulation. Utilized HTML5 and CSS3 to create responsive and visually appealing user interfaces. Integrated Angular and JavaScript for front-end development. Worked with Oracle databases, implementing data access and manipulation tasks.

Deployed applications on Azure Cloud, utilizing services such as Azure Data Factory (ADF) for efficient data processing and transfer. Implemented Windows Communication Foundation (WCF) and Windows Presentation Foundation (WPF) to develop scalable and user-friendly desktop applications. Integrated Python libraries such as Pandas and NumPy for data processing and analysis, enabling actionable insights. Configured and maintained ELK (Elasticsearch, Logstash, Kibana) stack for log analysis and monitoring purposes. Integrated Kaha for real-time event streaming, enhancing applications' overall performance and responsiveness. Implemented the project using Agile Methodology and SCRUM Implementation, Participated in Team Design sessions and interacting with Business Analysts in gathering requirements, collaborated with Quality Assurant at the time of QA Testing of the Application. Created code and built solutions from relevant information as per requirements for development and maintenance projects. This C# .NET MVC web application utilized extensive skills in ASP.NET Core 2.0, MVC, Web API, Entity Framework, LINQ etc. Worked on this web application project using front end frameworks like Angular 6 with Bootstrap and Node.js. Added features to existing front end applications using React.js and other frameworks like JavaScript, Kendo Ul and jQuery. Developed web pages using HTML, Cascading Style Sheets (CSS) and JavaScript for creating controls. Angular 6 was used for leveraging resources for all data access, encapsulating URLs and standardizing data access interfaces.

Have designed and created user defined functions and stored procedures using SQL Server 2017. And Fine-tuned queries and indexing of tables for better performance. Handled the Report Module of the application using SQL Server Reporting Services (SSRS). Involved in test cases preparation and performed Unit Testing. Performed End-to-End Testing and troubleshooting, debugging and integration. Hands on Experience with Azure DevOps/Team Foundation Server, GIT for version controlling. Worked on TFS Environment for Source Code Control and have created Branches to work on different versions of the project for Continuous Integration and Testing. Responsible for enhancement and maintenance of existing applications and extensively worked in production support. Implemented and managed Continuous Deployment (CI/CD) pipelines using Jenkins. Orchestrated containerization using Docker and container orchestration using Kubernetes, enhancing application scalability and maintainability. Collaborated with development teams using GitHub for version control and code collaboration. Produced reports utilizing SQL Server Reporting Services (SSRS) and .

triggers in SQL Server 2005 to 2014.

Strong Knowledge of cross- browser Compatibility Issues and Support.

Experience in usage of Source Control and Version Control tools Team Foundation Server (TFS), Perforce.

Designed and maintained SQL databases, ensuring data integrity and security.

Extensive Experience in requirements gathering including business requirements and system requirements,

System Analysis and Design, Code Generation, Testing, Implementation, and maintenance of various business applications. Working knowledge of XML- related technologies including XML, XSL, and XSD, Dynamic XSLT templates and mapped from XSD Schemas.

Experience in .NET security features such as Authentication (Windows-based Authentication, Forms-based Authentication) and Authorization (Authorizing Users and Roles).

Experience in developing SSIS packages and Developed reports in Crystal Reports, SSRS. Involved in the entire lifecycle of the project. And the ability to handle modules Independently. Implemented Auto Mapper functionality in the project for mapping Business and Entity Objects.

Implemented Entity Framework Code First with Database approaches.

Highly motivated to take initiative and have excellent People Management Skills.

Strong debugging and problem- solving skills with an excellent understanding of system development methodologies, techniques, and tools.

Experience in Web Bundling, Trans piling of applications by using WEB PACKS.

Have Experience in working in Agile Methodology.

Exposure to Azure Technologies, deploying and maintaining applications in the Cloud.

Working experience in Pre- Rendering Single Page

CENTENE

April 2022 – Jan 2024

UPS

Mar 2021 - Mar 2022

THRIVENT

June 2019 - Feb 2021

Senior .Net Developer

Involved in software development lifecycle (SDLC) from requirements gathering to deployment, utilizing .NET Core, C#, and ASP.NET to deliver robust applications. Implemented Model- View-Controller (MVC) architecture and GraphQL APIs for efficient data retrieval and manipulation. Leveraged LINQ and Entity Framework (EF Core) for seamless data access and database integration with SQL Server and MongoDB. Designed and deployed microservices-based solutions on Azure, utilizing Azure services such as Azure App Service, Azure Storage, and Azure Service Bus. Integrated Azure Active Directory (AzureAD) for secure application authentication and authorization. Crafted responsive and visually appealing user interfaces using HTML5, CSS3, JavaScript, and AJAX. Developed components and pages with Blazor and Razor, providing a rich interactive user experience. Utilized Bootstrap and React to enhance front-end development and ensure cross-browser compatibility.

Participated in code reviews, providing feedback to team members and adhering to coding standards. Orchestrated infrastructure as code using Terraform to automate provisioning and management of resources. Conducted unit testing with NUnit to validate application functionality and maintain code quality. Managed web server configurations and deployments using Internet Information Services (IIS) on both on-premises and Azure environments. Implemented CI/CD pipelines using Azure DevOps for automated build, test, and deployment processes.

Containerized applications using Docker for efficient deployment and scaling in Kubernetes clusters. Leveraged Snowflake for cloud-based data warehousing and analytics solutions.

Manipulated XML data and transformed it using XSLT for various integration requirements. Collaborated with team members using VS Code and GitHub for version control and monitored application performance using

.Net Developer

Involved in the Design and Development stages of the Software Development Life Cycle for the project.

Designed and developed the User Interface in ASP.NET. Used ADO to interact with the database using appropriate cursors and lock types.

Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set, and Data Table to access SQL data sources consistently.

Used Object Oriented Programming (OOP) techniques and created classes (C#.NET) for database access.

Extensively worked on front-end MVC framework. Used LINQ for updating data through C#.

Developed web services for the system using .NET (SOAP/XML). Created and consumed WCF Services; Responsible for writing complex business logic.

Designed and developed UI using ASP.NET, HTML, JavaScript, Jquery, CSS, and AJAX.

Written Complex Queries and Stored Procedures to validate the data and execute the desired results.

Involved in unit testing, integration testing, and system testing. Created reports using SSRS and deployed them to the Web Console, where Business users can easily access them.

Involved in bug fixes to the application and documenting the changes.

.Net Developer

•Developed web applications using ASP.Net MVC. Designed User interface using HTML, CSS, Jquery, AJAX, JSON, Angular JS, and JavaScript.

HANCOCK WHITNEY BANK

April 2016 - May 2019

• Developed solutions for diverse programming scenarios in C#, employing object-oriented Programming (OOP) concepts.

•Worked on routing to load controller type using MVC and Web APIs for reaching appropriate action in the web application.

•Used ADO.Net objects like Data Reader, Dataset, and Data Adapter to access SQL data sources consistently.

•Used Visual Studio Re-Sharper utility for interactive and dynamic development.

•Developed SQL queries, functions, Store procedures, and Triggers in SQL Server.

•Used MVC with Razor View Engine to design and develop the application.

•Implementing the data access layer using the Entity Framework Code First approach and writing queries using LINQ to Entity for data retrieval.

•Involved in Web service development (XML, SOAP, WSDL). Worked on XSLT to transform XML into HTML.

•Tested the application per the test cases and business logic using unit and functional tests.

•Fixed the bugs and coordinated with the team on various issues. Used GIT for Version Control.

•Troubleshoot Reporting services using SSRS and Crystal Report across various environments.

•Worked in an Agile environment where we followed all methodologies: Daily stand-up meetings, Spring planning, Sprint review, and Demo sessions.

.Net Developer

•Deployment of Application on Test and Production server.

•Involved in development life cycle, from design phase to implementation phase, testing and deployment. Followed Agile Methodology to produce high Quality software and satisfy the customers.

•Used ADO.NET objects such as Data Reader, Data Adapter and Dataset to object data source fetch and handle user data.

•Used Model View Controller (MVC) architectural Design Patterns for the development of the product.

•Designed and developed the user interface for various tools and implemented ASP.NET validation controls, JavaScript, JQuery, CSS for server and client-side validations respectively.

•Used LINQ and ADO.NET for developing data access layers.

•Created Database objects like Tables, Stored Procedures and Triggers in MS SQL Server.

•Worked with data migration. Used tools like MS SQL Server integration services (SSIS) in transferring data from one database to another.

•Made full use of .NET object oriented features(C#), event handling, error handling, caching and security features.

•Used JQuery UI controls, Templates and Widgets to Support the UI.

•Developed Web Services, which can be used by a number of clients in getting useful data.

•Used Azure Data Factory to design logic app for processing analysis service cubes.

•Designed, coded and modified applications by using ASP.Net.

EDUCATION: Bachelor’s of Engineering Graduate in the year 2009 – 2013 from Anna University, India

Contact this candidate