Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
Overland Park, KS
Posted:
February 14, 2024

Contact this candidate

Resume:

KAVYA VITTA

Full-Stack .Net Developer

ad3mun@r.postjobfree.com

251-***-****

PROFESSIONAL SUMMARY:

IT professional with around 10 years of experience in Application Architecture, Analyzing, Design, Development, Testing and Deployment of Web and Windows based client/server, enterprise level 3 tier, n-tier distributed architecture using Microsoft Technologies.

Expertise in working with different project delivery models such as Waterfall model, Iteration model and Agile (Scrum) methodologies.

Experience in Microsoft technologies, such as .Net Core (1.0/2.2/3.1), .Net 5.0, .NET Framework (4.6/4.5/4.0), ASP.NET, C#, VB.NET, Web Services, WCF, WPF, LINQ, IIS, ADO.NET, SharePoint 2010/2013.

Technical expertise in Microsoft Technologies in .Net Framework such as C#, VB.Net, ASP.NET CORE.Net, ASP.NET CORE.Net MVC Framework, XML, XAML, AJAX, SQL Server, ADO.NET, LINQ, Entity framework, Windows services WPF, SQL Server, Oracle IIS, Azure.

Proficiency in different services like Web Services, WCF Restful, WCFSOAP based services and Web API's with OAuth, OWIN and Token based authorization for security.

Strong knowledge in making an effective UI for Website using Angular, HTML5, CSS3, Bootstrap, JavaScript, Typescript, Knockout and jQuery.

Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using Crystal Reports and SQL Server Reporting Services (SSRS).

Proficient in developing robust and scalable web applications using ASP.NET Web Forms, leveraging extensive knowledge of server-side controls, data binding, and state management to deliver responsive and feature-rich user interfaces.

Have knowledge of SQL server ETL development, by using SQL server integration services (SSIS) and creating packages, configuration file and scheduling them through SQL Server Agent.

Extensive work experience in using unit testing frameworks MS Testing, Unit and X Unit with help the Mocking.

Experienced on Web Forms architecture, optimizing post back events and mastering the control event model.

Experienced on automating the generation of API documentation using Swagger tools, streamlining the update process and reducing manual effort.

Handled and resolved JIRA tickets raised for the bugs/issued in testing and production environments.

Resilient in adapting to new technologies, work environments with strong communication, collaboration & team building skills. Experience in developing web services WCF (rest based and soap based), Web API and used third party tools like SoapUI, Http Debugger and Fiddler for debugging the services.

Extensive experience in using Visual Studio for .NET application development, leveraging its comprehensive features for efficient coding, debugging, and testing.

Experience implementing asynchronous operations using .NET and RabbitMQ to exchange the data between Microservices by Raising/Publishing Events and Subscribing them.

Developed RESTful APIs using ASP.NET Core, utilizing JSON for data exchange between front-end and back-end systems.

Experience with Team Foundation Server and GIT as source control for versioning and collaboration.

Worked in the Agile Scrum SDLC Process with daily scrum calls, sprint planning's and retrospective meetings.

Experience in database design, writing SQL queries, stored procedures, Indexes to optimize search performance, triggers and views using SQL Server.

TECHNICAL SKILLS:

.Net Technologies

.Net Framework 5.0/4.5/4.0/3.5, ASP.NET CORE, ASP.Net, MVC 3.0/4.0, Entity framework, LINQ to SQL, LINQ to Object, ADO.Net, Web Forms, Web Services, WEB APIs, WCF, WPF, Azure, Windows forms, WCF, WPF, IIS 10/8.5/7.5/ 7.0 and SharePoint 2013/2010.

Programming

C, C++, C#.NET 8/7/6/5/4, VB.NET.

Web Technologies

HTML5, XML, JavaScript, jQuery, Angular 4,8,9,11,12,13,14, ado, JSON, CSS3, Knockout, Bootstrap, AJAX, Typescript, AngularJS2.

Development tools

Visual studio 2017/2015/2013/2010/2008, Visual studio Code, MS Office 2019/2016/2013/2010, SQL server management Studio.

Database

SQL Server 2008/2005/2016/2000 (T-SQL), Oracle 11g/10g/9i/8i (PL/SQL), MS Access.

Protocols

SOAP, SSL, FTP, TCP/IP, HTTP.

Enterprise Servers

IIS 7.0/6.0/5.0, Content Management Server.

Operating Systems

Windows 10/8/7/XP/2000/NT/ME/98/2003, Vista, Unix.

Reporting Tools

Crystal Reports, SSRS, RDLC Reports, MS Access.

Version Control

Team Foundation Server (TFS), GitHub, Bitbucket, Visual Source Safe (VSS)

PROFESSIONAL EXPERIENCE:

Client: Ryder Systems, Miami, FL December 2021- Present

Role: Sr. Full-Stack .Net Developer

Roles and Responsibilities:

Experienced on creating REST APIs in .net with C# and .Net Core technology (Core MVC and .Net Core).

Worked on creating asynchronous and synchronous operations using Microservice orchestration architecture to support the CRUD operations through Restful APIs.

Designed and developed Entity Framework database-first approach with Repository-Pattern based backend and used RESTful and Web API as transaction and communication technology to the client-side.

Developed microservices using ASP.NET Core, capitalizing on its lightweight, high-performance, and modular architecture.

Worked with MS SQL Server, SSRS and SSIS.

Worked with Integrating enterprise content management tools like OpenText ECM to manage all the documents being uploaded from the application.

Created TypeScript reusable components and services to consume REST API's using Component based architecture provided by angular.

Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions and Triggers, and responsible for SQL queries optimization and performance.

Developed the applications using .Net Core, Microservices, and API-driven development.

Worked with Azure Functions, Containers, Blobs and used HTTP Triggers.

Worked on developing interactive and user-friendly web forms using ASP.NET Web Forms framework.

Designed and implemented scalable and resilient cloud solutions using Microsoft Azure services such as Azure App Service, Azure Functions, and Azure Kubernetes Service (AKS).

Proficient in creating WCF services, configuring endpoints, and defining service contracts for seamless communication between different applications and platforms.

Developed modern, responsive web applications using HTML5, CSS3,JavaScript,Angular and Knockout ensuring cross-browser compatibility and adherence to web standards.

Experience in optimizing LINQ queries by considering factors like database indexes, query optimization techniques, and efficient use of LINQ operators to enhance performance and used LINQ to JSON for querying and manipulating JSON data, enabling smooth integration with web services and APIs.

Experience in web application development using ASP.NET web forms (Master page, user controls, validation controls and AJAX extensions) and ASP.NET MVC (Razor view engine, View, partial view, models and layout view), Web services, Windows communication foundation (WCF), ASP.NET Web API.

Worked on developing API Endpoints to fetch the vehicle information and create, modify, delete appointments and creating salesforce and Biz talk notifications for this we have used synchronous and asynchronous implementation based on the scenario.

Worked on developing scalable web applications using the MVC design pattern, with expertise in the ASP.NET MVC framework.

Implemented data cleansing and transformation techniques within SSIS packages to ensure data quality and consistency across systems.

Implemented AJAX Toolkit to enhance user interfaces, improving asynchronous operations and user interactivity.

Experienced in designing and implementing service-oriented architectures (SOA) for distributed systems using .NET technologies.

Worked on integrating Oracle databases with .NET applications using Entity Framework, ensuring efficient data operations.

Utilized entity-relationship diagrams (ERDs) and data modeling techniques to capture and represent relationships between entities, ensuring data integrity and consistency.

Worked on deploying .NET applications across multiple environments in Azure, including development, staging, and production, ensuring consistent and reliable releases.

Developed interactive and visually appealing dashboards and reports using Power BI Desktop, enabling data-driven decision-making for stakeholders.

Using GitHub as a source code repository and implementing CI/CD builds in TFS and Azure DevOps.

Writing unit-tests in C# using X-Unit and Implemented TDD architecture.

Worked on optimizing web form performance through techniques like bundling and minification of CSS and JavaScript files, reducing page load times.

Designed and developed responsive and engaging web experiences using Adobe Experience Manager (AEM) components, templates, and client libraries.

Developed custom SSIS components and tasks using .NET programming languages to extend the functionality of SSIS and meet unique business requirements.

Worked on creating interactive and visually appealing reports by leveraging SSRS features such as tables, matrices, charts, and gauges.

Utilized Visual Studio for writing clean, efficient, and well-documented code in C#, VB.NET, and other .NET languages.

Worked with Granicus Integration with .Net core 3.1, .Net 5.0 and .Net 6 applications for sending Email, SMS notification, receive any alerts, receive confirmation notifications etc. along with live tracking.

Strong understanding of interoperability concepts and experience in integrating WCF services with other technologies, such as ASP.NET, SOAP, or RESTful APIs.

Worked on Azure service Bus and Azure messaging queues using Azure functions and different triggers.

Environment: .NET Framework 4.6, ASP.NET, .NET Core 2.0/ 2.1/3.1 .Net 5.0, .Net 6, Entity Framework Core 3.1, 6, Visual Studio 2019, 2022, SQL Server 2019, C#, Azure,HTML5, CSS3, Angular, JavaScript, Typescript, Knockout, WCF, Web forms, RESTFUL, Rest API, SSRS, SSIS, OAuth, Okta single sign-On, Postman, MS-Unit, LINQ, IIS, Swagger UI, Aspose, Word, MS Dynamics CRM, OpenText, Azure DevOps, TFS, GitHub.

Client: F&G, Des Moines, Iowa. May 2021- Nov 2021

Role: Sr.Net Developer

Responsibilities:

Developed secure and high-performance RESTful APIs in C# and .NET Core, implementing authentication, optimization, and documentation best practices, while collaborating with cross-functional teams and ensuring code quality through reviews and testing.

Implemented the Repository Pattern and Unit of Work for efficient data persistence in microservices, ensuring separation of concerns, data integrity, and scalability, while also conducting testing, error handling, and documentation.

Implemented OpenText ECM solutions for efficient document management, workflow automation, and data security, while also providing user training and support for seamless system adoption.

Created and integrated RESTful APIs with Angular front-end applications, ensuring seamless data retrieval and management while implementing authentication mechanisms like OAuth2 and JWT for security.

Developed applications using .NET Core, Microservices, and API-driven development to create scalable and modular solutions for complex business requirements.

Worked on writing complex SQL queries and stored procedures to retrieve data from various data sources, including relational databases, data warehouses, and OLAP cubes, to populate SSRS reports.

Worked on integrating ASP.NET Web API with MVC applications to build RESTful services catering to modern web and mobile applications.

Worked on integrated Bootstrap with major JavaScript libraries and frameworks like jQuery, Angular.

Worked on creating and optimizing Entity Data Models (EDM) against Oracle schemas, leveraging Code-First and Database-First approaches.

Conducted usability testing and gathered user feedback to iteratively improve the design and functionality of web forms and developed custom controls and user controls in ASP.NET Web Forms to encapsulate complex UI elements and enhance code reusability.

Developed cross-platform mobile applications using Ionic framework, combining HTML5, CSS3, and JavaScript with Angular for native-like performance and user experience.

Designed and developed Entity Framework Code-First approach with Repository-Pattern based backend and used RESTful and Web API as transaction and communication technology to the client-side.

Provided support and troubleshooting for SSIS packages, identifying, resolving issues related to data transformation, package execution, and connectivity.

Experienced in developing scalable web applications using the MVC design pattern, with expertise in the ASP.NET MVC framework.

Utilized AEM (Adobe Experience Manager) designer to create and customize interactive forms and documents, integrating with backend systems for data capture and processing.

Implemented data storage solutions using Azure Storage services, including Blob storage, Table storage, and Azure SQL Database, ensuring secure and reliable data storage and retrieval.

Designed and implemented relational database schemas using SQL Server Management Studio (SSMS) or other database management tools, ensuring efficient storage and retrieval of data.

Proficient in writing expressive and concise LINQ queries to perform complex data operations on collections, databases, XML, and other data sources.

Experienced in using WCF routing capabilities to build scalable and flexible distributed architectures, enabling dynamic message routing and load balancing.

Utilized Power Query in Power BI to connect to various data sources, including SQL Server databases, Excel files, web services, and APIs, for data extraction and transformation.

Proficient in using Entity Framework to create and manage database models, including entities, relationships, and constraints.

Managed GitHub repositories and orchestrated CI/CD pipelines in TFS and Azure DevOps, leveraging Git workflows, build automation, deployment strategies, and security scanning for efficient development, testing, and deployment processes.

Worked on data-binding mechanisms in Web Forms, streamlining CRUD operations and database connectivity.

Worked on Integrating .NET microservices with NoSQL databases like MongoDB and Cassandra for scalable data storage and retrieval.

Managed source code using Visual Studio’s seamless integration with version control systems like Git, TFS, and SVN.

Utilized SOA patterns like Service Chaining, Message Routing, and Service Composition to address complex business scenarios.

Documented API endpoints comprehensively using Swagger and validated API functionality while inspecting JSON responses with Postman, ensuring clear documentation and reliable data interactions.

Integrated Okta single sign-on (SSO) seamlessly for Angular applications and .NET projects, enhancing user authentication and security with a unified and secure user experience.

Proficient in crafting complex SQL queries with multiple table joins, designing and optimizing Stored Procedures, Functions, and Triggers for database efficiency, and responsible for SQL query optimization and performance tuning to ensure seamless data operations.

Rewriting the complete Annual Registration (AR) which is in vb.Net to .Net Core.

Environment: .NET Framework 4.6, .NET Core 2.0/ 2.1/3.1 .Net 5.0, Entity Framework Core 3.1, Visual Studio 2019, SQL Server 2016, C#, Microservices, Rest API, WCF, Web Forms, Angular 8/9/10, Bootstrap, ASP.NET Core SignalR, Okta single sign-On, Granicus, SSRS, SSIS, Open Text ECM, Rabbit MQ, Signal R, CSS3, HTML5, Javascript, Typescript, Postman, N-Unit, LINQ, IIS, OpenText, Swagger UI, Aspose.PDF.

Client: Badger Daylighting Corp, Indianapolis Nov 2019 - April 2021

Role: Senior .Net Developer

Responsibilities:

Involved in the Software Development Life Cycle (SDLC) for the documentation, designing, and development phase of the System.

Worked on Agile methodology which includes Daily Scrum meetings, Sprint Planning and Retrospective meetings.

Working with several Sever controls to meet the client requirements, Implementing the business logic using C#.Net and handled the data transactions using ADO.NET.

Programming ADO.NET for communication between application and database, using extensively Data Grid, Data Set, Data Table, Data Views, Data Adapter and Data Readers to render data.

Experienced in implementing CRUD (Create, Read, Update, Delete) operations using Entity Framework, simplifying data access and reducing boilerplate code.

Implemented error handling and logging mechanisms within SSIS packages to capture and handle data integration exceptions, ensuring data integrity and providing visibility into package execution.

Worked on creating parameterized reports in SSRS, allowing end-users to customize report outputs based on their specific criteria and preferences.

Implemented efficient querying using LINQ to Entities against Oracle, optimizing performance and reducing data fetch times.

Contributed to open-source projects and developer communities, sharing knowledge and best practices related to front-end development with HTML5, CSS3, JavaScript, Typescript, Knockout and Angular.

Designed and optimized database queries and stored procedures to improve the performance of data-driven web forms

Worked on integrated Swagger for designing, documenting, and testing RESTful APIs in .NET applications, enhancing API usability and accessibility.

Created responsive and mobile-first Angular web designs using frameworks like Bootstrap and Angular Material.

Developed and deployed scalable .NET web applications on Azure App Services, achieving 99.95% uptime and streamlined CI/CD integration with Azure DevOps.

Worked on designing and deploying ASP.NET Web Forms applications, with a strong grasp on state management techniques like View State and Session State.

Worked on specializing performance tuning of .NET applications, identifying and rectifying inefficiencies to enhance system responsiveness and throughput.

Experienced in the Model-View-Controller (MVC) design pattern for scalable web application development.

Working on SQL Server database by creating complex stored procedures, tables and user-defined tables.

Involving in unit testing and written various N-Unit test methods for testing the application.

Extensively used JavaScript functions, jQuery to make client-side validations and used AJAX calls wherever necessary for auto filing fields and performing asynchronous calls to back-end services (WCF and Web API's).

Optimized the performance of .NET applications using Telerik/Kendo UI controls, ensuring fast loading times and smooth user interactions.

Implemented automated tests using MS Test, NUnit, and xUnit frameworks within Visual Studio, ensuring robust and error-free code.

Extensively used XML and JSON Serialization for transferring the data from controller to view.

Created WCF REST Services and used different bindings to make it available to different types of clients.

Developed ASP.NET CORE.Net Web API controllers that were involved in implementation of service layer, data object layer components and provided security using OWIN authorization.

Created and maintained database objects like complex Stored Procedures, Packages, Triggers, Tables (with Indexes), DML, DDL and User Defined Functions and Views in SQL server.

Dessigned and developed Stored Procedures, functions and views, used SQL Server 2012 as database.

Used SQL Profiler in SQL Server 2012 to diagnose the performance of Database and optimize the queries.

Environment: .Net Framework 4.5/4.6/4.8, Visual Studio 2013/2015, C#, ASP.NET, EXT Js 6.6, EXT Js 6.0, Entity Framework 5.0 WCF, Web API, LINQ to Entities, SSRS, C++, Java Script, jQuery, AJAX, Web Forms, Power Bi, Bootstrap, HTML5, CSS3, JavaScript, Typescript, Angular, XML, UNIT Test, Mock (Moq), NUNIT, TFS, RDLC, Sql Server2012.

Client: County of Ventura, CA July 2018 - Oct 2019

Role: .Net Developer

Responsibilities:

Involved in the Software Development Life Cycle (SDLC) for the documentation, designing, and development phase of the System.

Implemented ASP.NET CORE MVC 5.0 framework for the development of the application and created Data Access Layer, Business Logic Layer Classes using C# and .Net 4.6.

Extensively used JavaScript functions, jQuery to make client-side validations and used AJAX calls wherever necessary for auto filing fields and performing asynchronous calls to back-end services (WCF &Web API's).

Extensively used XML and JSON Serialization for transferring the data from controller to view.

Worked with Angular 2.0 using Typescript such as Building Nested components, interpolation, data binding & creating pipes, building, testing and deploying with CLI and other JavaScript frameworks likes jQuery, Nodejs.

Worked on rewriting the complete Web Tax (online Payment System) which is in vb.Net to C#.Net and ASP .NET Core using HTML, CSS, JavaScript, Bootstrap, jQuery and AJAX.

Created WCF REST Services and used different bindings to make it available to different types of clients.

Developed ASP.NET CORE.Net Web API controllers that were involved in implementation of service layer, data object layer components and provided security using OWIN authorization.

Proficient in writing unit tests and integration tests for Entity Framework-based data access layers using frameworks such as N-Unit or X-Unit, ensuring code quality and reliability.

Designed and developed SSIS packages to automate data extraction, transformation, and loading (ETL) processes, ensuring efficient data flow and integrity within the organization's data warehouse.

Worked on Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Leveraged jQuery for page scripting, AJAX calls, JSON and XML for passing objects from Controller to View and vice versa.

Worked on analytical Tax calculation logics for the reporting using C# through SSRS.

Strong knowledge of SSRS report deployment and management processes, including configuring report servers, scheduling report generation, and managing report subscriptions.

Worked on defining and maintaining API specifications using Swagger, ensuring clear and concise documentation of API endpoints, request/response structures, and authentication methods.

Experience in utilizing LINQ query syntax within Entity Framework's LINQ to Entities, enabling seamless integration of database querying and manipulation in ORM-based applications.

Designed and developed Stored Procedures, functions and views, Used SQL Server 2012 as database.

Used the SQL Profiler in SQL Server 2012 to diagnose the performance of the Database and optimize the queries.

Created and maintained database objects like complex Stored Procedures, Packages, Triggers, Tables (with Indexes), DML, DDL and User Defined Functions and Views in SQL server.

Performed unit testing for all the modules by mocking different layers of the application and worked with N Unit test using Mock (Moq) objects.

Deployed application into Azure cloud Server by creating Azure cloud SQL server by setting up Continuous Integration, Continuous Deployment from TFS.

Environment: .Net Framework 4.6, Visual Studio 2013/2015, C#, ASP.NET CORE.NET MVC 5.0, Entity Framework 5.0 WCF, Web API, LINQ to Entities, C++, Java Script, jQuery, microservices AJAX, Angular 2.0, Bootstrap, HTML5, CSS3, JavaScript, Typescript, Angular, UNIT Test, Mock (Moq), NUNIT, AWS, SSRS, Sql Server 2012, TFS.

Client: Publicis Sapient, Bangalore, India April 2017- June 2018

Role: .Net Developer

Responsibilities:

Used ASP.NET, Entity Framework and SQL-statements to develop database connections.

Followed MVC architecture and developed ASP.NET, MVC 4.0 application using C#, WCF, Generics, Code First Approach in Entity Framework 6 and UI in Razor View Engine.

Developed REST APIs that allow sophisticated, effective, and low-cost application integration and multi-tier web applications with the use of Web Services using ASP.NET Web API.

Developed very responsive, elegant UI views for web pages using the Bootstrap and CSS Frameworks.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Used advanced level of HTML, XHTML, AJAX, and jQuery, Knockout JS and Bootstrap for designing rich user interface.

Worked with ASP.NET, HTML, CSS, and JavaScript.

Created and validated Views, Models and Controllers of MVC Framework and implemented features of security, testing of application.

Implemented best practices in error handling and exception management, reducing application crashes and unhandled exceptions.

Worked with TPL for asynchronous programming and used Event based asynchronous pattern.

Used JavaScript extensively to enhance the UI and to make application looks more dynamic and to perform client-side validations.

Managed complex build configurations and transformed files for different deployment environments using Visual Studio.

Implemented XML Web Services in C# based on SOAP protocols using XML and XSLT extensively for data transfers.

Reports are generated by using SSRS and configured SQL Server Integration Services (SSIS) for Scheduling data backup.

Environment: Visual Studio 2012, .Net Framework 4.5, C#, ASP.NET, HTML, CSS, WCF, Web API, WPF, MVVM, SOAP, XML, LINQ, Oracle 10g, Unit Testing, SSRS, JIRA, GIT, AWS.

Client: PSR IT Services, Hyderabad, India June 2014 – March 2017

Role: Software Developer

Responsibilities:

Worked on Agile methodology this includes Daily Scrum meetings, Sprint Planning and Retrospective meetings.

Worked with MS SQL Server, SSRS, SSIS and IIS.

Implemented client-side validations/scripting using jQuery and AJAX.

Maintaining records in excel spread sheets and exported data into SQL Server Database.

Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources.

Designed Graphical User Interface (GUI) using ASP.NET MVC and coded the business logic using C# [MVC Controllers.

Deployment of Classic ASP.NET and MVC .Net Applications using different application pools on web server as a single Intranet Application.

Developed dynamic browser UI functionality using HTML, JavaScript, and CSS.

Coordinated with team members using Visual Studio Live Share for real-time collaborative coding and debugging.

Used ASP.NET web form controls such as Grid View, List View, etc. for displaying data.

Developed REST APIs that allow sophisticated, effective, and low-cost application integration and multi-tier web applications with the use of Web Services using ASP. Net Web API.

Extensively used datasets, Data table and Data view to retrieve and manipulate data and display it in an ASP.NET CORE.NET page.

Extensively used XML and JSON Serialization for transferring the data from controller to view.

Environment: .Net Framework 4.6, Visual Studio 2013/2015, C#, ASP.NET MVC 5.0, Entity Framework 5.0 WCF, Web API, LINQ to Entities, C++, Java Script, jQuery, AJAX, Angular 2.0, Bootstrap, HTML5, CSS3, XML, UNIT Test, Mock (Moq), NUNIT, SSRS, Sql Server2012, JIRA, TFS.



Contact this candidate