Sql Server Software Development

Umamaheswar Reddy Kalluru

Ph: +1-513-***-**** Email: ******************@*****.***

Executive Summary:

4+ years of experience in software development life cycle involving Requirement analysis, Design, Development, Coding, Testing, Maintenance, and implementation of various applications based on Web Applications, and Business Solutions using C#.NET, .NET 6.0/3.1, ASP.NET MVC, ASP.NET Web Forms, Entity Framework, Entity Framework, Core, LINQ, SQL Server, Angular 4/6/12/14, Azure, Visual Studio 2022,2019 and Visual Studio Code.

Extensive experience in .NET applications based on Object Oriented Programming (OOPS), Internet Technologies, Web based, Client/S erver, N-tier, and Service Oriented Architecture (SOA).

Hands-on experience in developing API-based applications or Microservices, enabling seamless communication between software components and systems.

Experience in building and deploying applications to containerized (Docker) environments, optimizing resource utilization and deployment efficiency.

In-depth knowledge in working with attribute routing, data serialization, model binding, in WEB API and .NET Microservices.

Extensively worked with Object Relation mapping tool Entity Framework Core Code First and Database First approaches and Migrations, LINQ, Lazy Loading, Eager Loading, and Change Tracker API, CRUD operations, Configurations, Migrations, performance, and Integrity of data features.

Implemented authentication and authorization mechanisms using JWT, OAuth 2.0, ASP.NET Core Identity, Identity server, and OpenID Connect, ensuring secure access to web applications.

Strong skilled in Web API application using .NET 6 using C# with Dependency Injection and Web API controllers and methods, handling logging and error using SeriLog and application insights.

Implemented unit tests and integration tests automation using XUnit, MOQ, NUnit, and Selenium web driver to ensure code quality and functionality.

Experienced in Designing, Configuring, and deploying Micro Services and multiple web applications, implementing the Azure Stack such as Resource Groups, Compute, Azure SQL.

Experienced in XML Web Services (SOAP, WSDL and UDDI), Service Oriented Architecture [SOA] concepts using .NET Framework.

Experience in development and implementation of Windows Communication Foundation (WCF), and responsible for developing WCF based Service, Data, Fault and Message Contracts and services.

Hands on experience with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) using SQL.

Strong analytical and conceptual skills in database related work primarily creating complex Stored Procedures, Views, Triggers, Functions, T-SQL, Indexes, Cursors, Performance Tuning using SQL Profiler.

Used versioning control tools using Azure DevOps, Git Hub, Microsoft Team Foundation Server (TFS) 2012/2010/2008) for version controlling of the Application.

Performed Unit Testing (using N-Unit), Integration Testing, Performance Testing and System Testing.

Technical Skills:

Programming Languages

C#.Net, SQL, JavaScript, Java

Web Technologies

ASP.NET 4.5/4.0/3.5/3.0/2.0, ASP.NET CORE, ASP.NET MVC 5.0/4.0/3,0, Silverlight 4.0/3.0, WCF, WPF, ADO.NET, LINQ, ADO.NET, Entity Framework, Angular JS, REST API and SOAP, AJAX, JavaScript, jQuery, NHibernate, Bootstrap, LINQ, Web Services, Web API, Knockout JS, VBScript.

UI Technologies

Angular, React, Win forms, WPF.

Scripting Languages

Java Script, AJAX, jQuery

Markup Languages

HTML, HTML5, DHTML, XML

Databases

MS SQL Server 2005/2010/2008/2012/2018, MYSQL & ORACLE 9,10C,11G,12C

DB Migration Tools

Microsoft SQL Integration Services (SSIS 2008 / 2012 / 2014 / 2016)

DB Reporting Tools

SQL Server Reporting Services (SSRS 2008 / 2005), Crystal Reports (2010/9/8.5/8)

Versioning Tools

Git Lab, Visual Source Safe (VSS), Team Foundation Server, Tortoise SVN, GitHub, Git Bucket, SVN.

.NET SDK Frameworks

.Net Framework 4.8/4.0/3.5/3.0/2.0, .Net Core 8/7/6/5/3.0/2.0

Development Tools

Microsoft Visual Studio .NET 2002/2003/2005/2008/2010/2012/2015/2018, Visual Studio Code, JetBrains Rider, JetBrains ReSharper, PyCharm

Operating Systems

Windows XP/Vista/7/10/11, Windows 2003/2008/2012/2016/2019 Server, UNIX, Linux, PC Hardware, Operating Systems/APIs

Web servers

IIS 5.0/6.0/7.0/8.5/10, Kestrel Server

Windows Apps Development

WCF

Cloud technologies

AWS – EC2, S3, Microsoft Azure

Modeling Tools

UML, MS Visio 2010/2007

Professional Experience:

Client: Capital Group - Plano, TX - July 2023 - Oct 2024.

Role: .NET Developer

Description: The application was for Online Banking. The application provides client account information like account summaries, account details, monthly statements, balance transfers, accrued interest, check ordering, loan application, credit cards and financial services. More alerts and correspondence were created to enhance the online banking experience of the customers. Transactions were done using batches and web services. This was a conversion project from the legacy application to a more enhanced version.

Roles and Responsibilities:

Actively participated in Agile Scrum Methodology, attending daily stand-up meetings to track project progress and address any issues.

Implemented CRUD functionality with Entity framework Core Code First and implemented sorting, filtering, and paging with Entity Framework Code First Core in MVC.

Created Angular 14 Services and make it custom, self-contained, reusable, and testable to retrieve/add/update/delete data from Web API through HTTP GET/POST/PUT/DELETE by using Angular/cli and Dependency Injection to some components to bind view template.

Created TypeScript reusable components and services to consume REST APIs, leveraging Angular component-based architecture.

Implemented Angular Router for enabling navigation between views in the application.

Developed some dynamic dictionaries using C#.net, .Net Core 3.1 for easy lookups of item dimensions values which results in faster performance.

Implemented WEB API Services for CRUD operations with HTTP verbs GET POST, PUT, PATCH and DELETE.

Used Http Response Exception to handle the exceptions in Web API and customized the Exceptions using Exception Filters and registered them at the Action Level.

Built Angular 14 components, UI services to consume REST services using component-based architecture provided by Angular 14.

Experience Implementing MVC Core Design Pattern using Angular 14 and Bootstrap to style a cross-browser compatible web page to create and execute Unit testing and Integration Test using NUnit.

Used Microservice architecture, based services interacting through combination of REST and leveraging Azure to build, test and deploy Identity Microservices. Integrated Azure Storage Library in Visual Studio with .Net.

Responsible for designing and implementing Azure Functions according to the application requirements and understanding the triggers (HTTP, Timer, Queue, etc.) that activate the functions and define the appropriate function signatures and bindings.

Developed JWT Token based authentication to secure the ASP.NET Core Web API and provide authorization to different users.

Extensively involved & supported the Production bugs which are assigned through JIRA and then reproduce or replicate the behavior of the defect, discussing more on bugs with QA’s and PO’s and try to resolve it as it meets the business requirements.

Extensively worked with JIRA for the agile sprint boards for the user stories assigning and tracking the tasks for the productive work towards achieving the deliverables.

Utilized Bootstrap to create visually appealing and responsive websites and web applications, enhancing user experience.

Utilized Entity Framework core to work with domain-specific objects and properties, abstracting database complexities for developers.

Created stored procedures, functions, and triggers using SQL and T-SQL in SQL Server 2008, optimizing data retrieval and binding processes.

Developed complex SQL queries and optimized stored procedures, enhancing application performance by 40%.

To perform a broad range of data migration tasks, SQL Server Integration Services (SSIS) which is a component of the Microsoft SQL Server database software that can be used.

It is used in unit testing to isolate your class under test from its dependencies and ensure that the proper methods on the dependent objects are being called by MOQ.

Environment: NET Core, C#, VB.Net, Microsoft Visual Studio 2019, HTML5, Angular 14, JavaScript, ADO.NET Entity Framework, Bootstrap, RESTFUL Web Services, SOA, Web API, WCF Services, MS SQL Server 2012, SSIS, IIS 6.0, Azure DevOps, JIRA Dashboard.

Client: State of OHIO- ODH-Programmer 4 - Aug 2022 to June 2023

Project : Persnet web application

Role: .Net Developer

Description:

As a key contributor to the Persnet web application, I played an instrumental role in enhancing its functionality to streamline employee management processes. The application is a comprehensive tool for managing employee details, their supervisors, and onboarding for new hires. My contributions focused on developing robust features that improved user efficiency and operational workflows.

Roles and Responsibilities:

Designed systems and database applications, coding and writing specifications by using knowledge of C# and VB Programming.

Leveraged Angular9 custom Services and Pipes to handle Dependency Injection and data transformation, contributing to maintainable and efficient code.

Constructed Angular9 components and UI services that effectively consumed REST services, following the Component-based architecture principles.

Extended NgRx to support lazy-loaded feature modules, maintaining separate stores for different application features.

Integrated NgRx Router Store to manage router-related state, enabling route-specific data retrieval and navigation.

Implemented View Model patterns in creating and managing Views, Partial Views, View Models, and Web APIs using ASP.Net MVC.

Designed and implemented a feature that allows hiring managers to assign job codes to new hires effortlessly.

Ensured the solution was scalable and intuitive, reducing errors and saving time during the onboarding process.

Collaborated with stakeholders to gather requirements and ensure alignment with business needs.

Developed an end-to-end solution for managing and assigning assets to new hires.

Asset selection: Enabled HR personnel to choose appropriate assets based on the employee's role.

Job code linking: Integrated the selected job codes and assets to ensure accurate allocation.

Streamlined workflow: Created a user-friendly interface for linking assets and job codes to employee profiles with minimal steps.

The feature improved organizational efficiency and accountability in asset management.

Creating RESTFUL services using Web API, built HTTP services and formatted responses using web API media type formatter to JSON.

Used Microsoft Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC application using HTML5 and Razor view

Used ASP.Net Web API 2 for HTTP-based RESTful Services using JSON message format achieving usage of less bandwidth for server communication.

Created and maintained database objects like complex Stored Procedures, Views, User Defined Functions, Triggers, Cursors, Tables, SQL Joins, and T-SQL Statements in SQL Server 2016 for Inserting/Updating/Deleting the data into the relational tables.

Extensively used Sql Server Reporting Services (SSRS) for generating reports populated by data in databases and developed various stored procedures for the data retrieval from the database and generating different reports using SSRS.

Performed unit testing using N-Unit Site plugged into Visual Studio on every new version before sending it for User Acceptance Test.

Actively participated in the Software Development Life Cycle, including requirements analysis, architectural design, and documentation creation.

Performed coding, debugging, modifying, and developing computer applications and systems.

Environment: ASP.Net 3.0, VB.NET, .Net Core1.0, Visual Studio 2015-2017, AngularJS, ADO.Net, HTML, WCF, WPF, XML, SOAP, Web Services, SQL Server 2012, SQL Server Integration Services, Oracle 11g, TFS, CSS, AJAX, Kendo UI and jQuery.

Soft Team Solutions Private Limited - Chennai, India - Mar 2020 – July 2021

Role: .Net Developer

Description: Soft Team Solutions Private Limited serving as an administrator in the individual health insurance markets and is committed to offering an exceptional level of quality services. As a Developer involved in creating windows and web applications and development of Framework for Web applications for the new insurance policy, policy cancellation and details of the policy holders.

Roles and Responsibilities:

Experience in various phases of Software Development Life Cycle (SDLC) such as Analysis, Design, Development, Deployment and Maintenance of web applications.

Worked on development and implementation of Displaying the Quintets property information in members site both in old (classic) and new design (MAR).

Worked on restoring the existing functionality for Prearrival DRI properties and Email Functionality depending on the type of reservation both in classic and MAR.

Experience working with Oracle database design and development, writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers and User Defined Functions.

Used angular 4 for developing applications using HTTP client module for REST calls and jQuery to process JSON and XML then providing them to components that are in need.

Experience in building SPA using Angular framework, very good experience in developing Angular 4.

Worked with Angular 4 custom directives, components, modules, pipes, services, and routing.

Wrote unit tests using Jasmine, Karma NUnit, Postman.

Worked on LINQ queries and ORM tools like Entity framework to exchange data between web services and database objects.

Worked on migration from classic to MAR design of “Valued Getaway” Utilizing Services and Factories with dependency injection (DI) in ASP.NET MVC, HTML, CSS, JavaScript etc. both for Web and Mobile version.

Implemented Angular Routing and navigation, components, and services.

On members site various links, fields, logics, and loan information on financial services page used Harland database, I have worked on moving the database from Harland to Northridge.

Worked extensively on Database design and development using advanced SQL, including Dynamic SQL, Transact-SQL, Stored Procedures, Indexes, Triggers with tools such as MySQL and SQL Server Management Studio 2008/2012.

Developed and provided the team with the data layer functionality using entity framework to connect to database and fetch data.

Worked on Bug Fixing of application on all modules (Rentals, Destination Exchange, Members, Payments etc.)

Environment: Visual Studio.NET 2017/2015, C#, ASP.Net, Micro Services, Web API’s, GIT, .Net Framework 4.5, .Net Core OOP’s, Entity Framework 6.0/4.3, Angular 9, LINQ, WCF, TFS 2013, IIS 7.0. HTML, HTML5, DOM, Bootstrap, SOA, Ajax, JSON, Oracle, SQL Server 2016.

Client: NetSol Technologies Limited, India - Aug 2018 - Aug 2019

Role: .Net Developer

Description: NetSol Technologies is an IT solutions company. It is an information technology consulting, services, and business process outsourcing organization. I have gained extensive experience as an IT engineer and had an opportunity to work on multiple projects involving scripting, coding, testing, web development, windows application development, and DOORS administration.

Roles and Responsibilities:

Used 3-tier architecture for Presentation, Business, and Data Access layers.

Involved in the design of the Use Case Diagrams and class diagrams using Microsoft Visio.

Proficiency in Software Development Life Cycle (SDLC) and Agile methodologies of development process such as requirement analysis amp; definition, prototyping, proof of concept, designing, coding, testing and implementation.

Participated in the whole life cycle of the project including design phase of the project, which was designed using ASP, VB.NET and ADO.Net.

Responsible for designing web pages using VB.NET, ASP.NET, JavaScript, jQuery, and HTML controls.

Designed and implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information.

Used ASP.Net 3.5 AJAX Server Control and toolkit to asynchronously retrieve data from server for a better performance and an increase in interactive animation on web pages.

Developed desktop application using.NET (using Microsoft reactive extension libraries).

Worked on UI to make the updates for all the state-specific and generic application types present in the project using VB.NET, ASP.NET MVC, HTML 5 and CSS3.

Web Forms is used to standardize the user interface across the entire application, apart from using CSS1 for consistent look and feel.

Worked on optimizing the ASP.Net web pages using C# and SQL Server 2008 R2/2008 stored procedures to call the application from the database.

Used ADO.NET objects Data Sets, Data Reader, Data Adapter to effectively communicate with SQL Server Database.

Created Web Methods using Web Service and deployed the Web Service on IIS in the production server.

Developed UI using JavaScript, HTML, CSS, JavaScript validations and XML.

Used Unit testing to simulate different case scenarios to catch potential bugs.

Environment: Microsoft Visio, C#.net, ADO.Net, ASP.Net, Microsoft Visual Studio.NET 2010, JavaScript, HTML, CSS, XML, IIS 5.0, Server 2008 R2/2008, VB.NET Web Services, Web Forms, Microsoft Unit Testing

Educational Qualification:

Bachelor of Computer Science & Engineering from Maharishi Markandeshwar University, Ambala, Haryana, India.

Master of Computer Science & Engineering from University of Cincinnati, Cincinnati, Ohio

Contact this candidate