Software Developer Sql Server

Prashanth Kondra

Email: *****************@*****.*** Contact: 561-***-****

Professional Summary:

Over 7+ years of experience, as a software developer, in Functional specifications, Analysis, Design, Modelling, Development, Configuration, Management and implementation of various web applications including health care, banking and finance projects.

Demonstrated proficiency in development using Microsoft.NET technologies like ASP.Net, C#, VB.Net, ADO.Net, Web Services, MVC, AJAX, Windows Services, WCF Services, OOPS, XML, XSLT, HTML, SOAP, LINQ Text Editor, MS IIS. DHTML, Vb-script, VSS, JavaScript, SQL Server.

Experience in designing web pages using HTML, JavaScript, HTML, CSS and jQuery, Angular JS, AJAX, Bootstrap and JSON, Node JS, UML.

Strong Experience in Web Forms and Win Forms applications with .NET Framework … and Visual Studio.

Strong Microsoft Technologies in the fields of Win - forms, Web-forms, Web Services using ASP.Net … VB.Net, C#, MVC, Entity framework, Angular JS, ADO.NET AJAX, LINQ, WCF, WPF, Silverlight 2.0/3.0 using Microsoft .Net Framework.

Strong experience in developing Web Applications using Visual Studio 2005 / 2008/2012/2013/2015/2017/2019/2022 .NET Framework using ASP.NET, C#.NET, VB.NET, WCF, WPF, ADO.NET, SQL Server 2000/ 2005/2008/2012/2014/2016/2017/2019/2022, JavaScript, VBScript.

Building and maintaining systems in Windows Azure for development and production systems. This applies to standard VMs as well as other Azure services.

Experience of working with Azure Monitoring, Data Factory, Traffic Manager, Service Bus, Key Vault.

Working Experience on Azure Storage, Azure Cosmos Db, Azure SQL API and in different PaaS Solutions with Web, and worker Roles and Azure Web Apps.

Experience in creating Views, Partial Views, and Sections etc. In ASP.NET MVC, and Created the Controllers and Controller Actions, Filters, Routing using ASP.NET MVC.

Strong experience on MS SQL Server … using SQL, MS SQL, SSIS and T-SQL. Have worked on ETL using SSIS and DTS packages.

Experience building and publishing reusable NuGet packages for internal and external use

Strong working knowledge of RxJS, NgRx Store, and Redux for session and state management in Angular application.

Hands-on experience with Angular UI testing frameworks such as Cypress, Protractor, Jasmine, and Mocha Familiar with Google Cloud Platform (GCP) services including Cloud Run, GKE, and BigQuery

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using Angular JS and getting the Data back as JSON and parsing it onto the UI.

Working with RDBMS includes MS SQL Server … Oracle 8i, 9i, 10g, 11g, 12c and MS-Access.

Excellent skill in data modeling and implementing tables, views, stored procedures, functions, schemas, and Triggers using T-SQL Queries and PL/SQL.

Good application deployment experience on Windows and on other platforms like UNIX, Solaris.

Design & implement end-to-end automation of infrastructure and continuous delivery of the applications by integrating Cloud Formation scripts, Jenkins, Ansible and AWS.

Designed large numbers of WPF Forms and used XAML for the same.

Involved in development of projects using SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS)

Good experience with Agile (SCRUM) methodology, Waterfall and Test-driven development.

Leveraged strong Azure expertise in developing and managing Azure Applications, orchestrating data workflows with Azure Data Factory (ADF) and Pipelines, and integrating services using Azure Functions, Event Hub, Event Grid, and Service Bus for robust data processing and real-time event handling.

Exposure in Requirement Analysis, Architecture & Design Documentation, Reviews, System Development, System Testing, System Implementation, User Documentation.

Experience in configuration and version management using Sub Version (SVN), Team Foundation Server (TFS), GIT and defect tracking tools like JIRA, Visual Studio Team Services, Database projects.

Experience in Creating dashboards in JIRA,

Experience in using JIRA gadgets, Proficient in leveraging JIRA gadgets such as charts, filters, and statistics to streamline reporting processes and enhance project tracking capabilities.

Experience in Microsoft Excel, Extensive experience in using Microsoft Excel for data analysis, reporting, and visualization, including pivot tables, VLOOKUP, macros, and complex formulas to automate workflows and improve data accuracy.

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

Very Good experience in handling clients & meeting their requirements and willing to adapt to new technologies/work environments, well organized team player with good analytical and leadership skills. In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, functions, user-defined data type, procedures etc.

Proficiency in working with databases like Oracle, MySQL, MongoDB, NoSQL.

Experience in using testing Tools JUnit, Selenium, Cucumber/Gherkin.

Expertise in database modeling and development using SQL, T-SQL and PL/SQL in Oracle and SQL Server environments.

Exposure to Oracle, DB2, and MySQL databases in developing applications using SQL Scripts, Stored Procedures.

Technical Skills:

Programming Languages: C#, JavaScript, Typescript, Visual Basic (VB .NET)

Front-end Technologies: Angular, HTML, CSS, Bootstrap, React

.NET Technologies: .NET Web API, Entity Framework, MVC, WCF, ADO .NET, WPF, LINQ

Database technologies: MS SQL Server, Mongo DB

Cloud Technologies: AWS (Lambda, S3, Step functions, CloudWatch, DynamoDB, Oracle Cloud

Tools: GitHub, TFS, Visual Studio, VS Code, Azure DevOps

Software Methodologies: Agile, Waterfall

Search Services: SharePoint, Solar, Lucene

Reporting Tools: Crystal Reports, SSRS

Professional Experience May 2023 to Present

Client: United Postal Service, New Jersey

Full stack .NET Developer

Developed and deployed an application on Azure Cloud, leveraging services like Service Bus, Message Queues, and Redis Cache for communication and data storage.

Responsible for developing UI pages using jQuery, AJAX, JSON and UITK Tool.

Used Angular as framework to create Single Page Applications which can bind data to views and synchronize data with server.

Created Web API (REST), WCF web services and OData services for implementing business logic in an n-tier architecture.

Wrote Complex nested queries, stored procedures (T-SQL), Triggers, Functions, and Indexes to improve the throughput of application using optimized queries in SQL server, and further used Entity Framework to communicate with database.

Managed server configurations, including IIS setup, Windows servers and IIS deployments to ensure optimal performance.

Developed and integrated REST APIs, elevating data exchange efficiency through seamless AJAX calls.

Contributed to both front-end Angular 7 and back-end Web API development.

Developed front-end Angular component, modules, directives and services to implement task management system.

Used HTML5, CSS3, and Bootstrap4 to develop front-end responsive UI.

Improved template with Angular Material table and other third-party libraries such as Angular font awesome.

Created stored procedures for updating and retrieving data from SQL server 2017.

Involved in Design, Development of Web Forms using ASP.NET, MVC, C#, JQuery, XML, and .NET Framework.

Built Web based and service-oriented platforms using Microsoft .NET technologies (C#, ASP.Net, MVC, Web API, and Entity Framework)

Amazon Web Services (AWS), Agile, cloud and Deployment provide recommendation and monitoring the task in infrastructure, product management data, and data conjunction with manager.

Built a distributed system, integrating multiple AWS services – Lambda, API Gateway, DynamoDB, S3, Cloud Watch, SQS and SNS achieving 86% reductions in cost and space.

Efficiently transformed a daily influx of 230K JSON records to CSV utilizing AWS Athena, providing valuable insights to stakeholders.

Implemented Angular template-driven form and reactive form to generate dynamic form which can interact with users.

Collaborated with Architecture team to implement data encryption and secure data transmission, leveraging API Gateways and Okta Authentication aligning with OWASP standards to fortify application security.

Worked on ASP. NET MVC Grid Controls that include Repeater, user controls for reusable components in the application.

Developed and published internal NuGet packages for common logging, validation, and authentication modules, enabling reusability across multiple .NET Core microservices and reducing redundant code by 30%.

Maintained versioned NuGet libraries in Azure Artifacts to streamline package management and CI/CD pipelines, ensuring consistent deployments across development, staging, and production environments.

Created and managed serverless Function Apps, Web APIs, and CI/CD Pipelines on Azure Cloud.

Designed and implemented a scalable data integration solution using Azure Data Factory (ADF) to streamline ETL processes, enhancing data accessibility and reducing processing time by 30% for business intelligence reporting.

Adopted a Test-Driven Development (TDD) approach by writing unit tests in NUnit and integration tests in Postman before implementing business logic, resulting in a 25% reduction in production defects.

Implemented automated test suites with NUnit and Moq to validate service layers and REST API endpoints, ensuring high code coverage and early defect detection during CI/CD pipelines

Integrated SQL Azure database with Active Directory for enhanced security and user management.

Implemented ADO.NET and Entity Framework for data access and manipulation.

Environment: Angular 14/16, Bootstrap3, HTML5, CSS3, Typescript, Web API, C#, Microsoft SQL Server 2017, EntityFramework 6, Azure DevOps, Git and Postman, AWS, SQL Server

Client: Comcast – Chennai, India June 2020 – July 2022 Full stack .NET Developer

Designed Single Page Applications (SPA) using AngularJS, HTML5, CSS3, and Bootstrap to help the responsiveness of web page with custom CSS3 style sheet.

Implemented 3 robust and secure web applications including desktop and mobile, driving a 40% decrease in resolution time for customer service requests within 14 months.

Expertise in designing and implementing User Interface layer using HTML5, CSS3, Bootstrap 4 and some other third-party libraries.

Created Web API Controllers (Web API 2) in ASP.NET Core to build, maintain Restful (XML, JSON) services and consume the API's client side using AngularJS data binding.

Supported and maintained legacy WinForms applications, making necessary updates and enhancements.

Mobilized micro services architecture using .NET core and Docker, enabling service discovery and load balancing with Kubernetes which enhanced application availability and reduced downtime by 70%.

Engineered an Angular application leveraging AWS CloudWatch, Lambda, DynamoDB, S3 to quantify application analytics.

Used WCF services for communicating with other application components and WPF to develop the Graphical Representation of filtered bugs.

Provided inputs for architecting, implementing a Service Oriented Architecture (SOA) for the application development group.

Developed and maintained Windows desktop applications using .NET Core, WinForms for UI design, functionality, Methodologies included MVVM.

Integrated legacy system with .NET Core application, utilizing WCF and RESTful APIs. Migrated critical functionalities, resulting in 45% less maintenance effort and improved system performance.

Developed an event-driven architecture leveraging Azure Functions, Event Grid, and Service Bus to automate data workflows, resulting in improved system responsiveness and real-time data processing capabilities for critical applications

Designed and built multidimensional cubes and tabular models using SQL Server Analysis Services (SSAS) to provide users with interactive and insightful data analysis capabilities.

Environment: .NET Framework 4.0, Visual Studio 2015, C# 5, ASP.NET 4.0, MVC 4, SignalR 2, ADO.NET, Entity Framework 6.0, SQL Server 2014, AWS, Oracle 11g, LINQ, RESTful API, WCF 4.0, HTML5, CSS3, AngularJS 1.3/1.4, AJAX, jQuery, Bootstrap, IIS 7.0, JSON, MS Test, Azure, Agile, Jenkins, TFS and Git

Client: Amex Software Solutions, India June 2017 – May 2020

.NET Developer

Employed caching strategies to improve application performance, resulting in a 15% reduction in database calls and increased response time for 1500 concurrent users.

Spearheaded the use of Razor pages and Entity Framework to solve complex tasks, resulting in a remarkable 60% improvement in application performance.

Implemented custom controls and user controls in WinForms to meet application requirements and improve UI consistency.

Implemented RESTful APIs using ASP.NET Web API, enabling seamless integration between systems and an increase in data exchange efficiency by 35%.

Unified AngularJS and TypeScript to enrich the front-end functionality of an ASP.NET MVC application, resulting in reduction in page load time and better user experience.

Implemented effective build and release strategies using Octopus Deploy and Azure DevOps, reducing deployment time.

Created database objects using SQL Server including complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications

Collaborated with database administrators to fine-tune EF-generated SQL queries, improving database query performance, and minimizing resource consumption.

Proficiently managed work items and source code using DevOps, ensuring streamlined collaboration within the agile team.

Leveraged Angular forms, validation to create user-friendly and data-driven input forms, enhancing data integrity, user experience.

Working on Web API for FHIR (Fast Healthcare Interoperability Resources) HL7 healthcare specification.

Designed and implemented unit tests using N-Unit for application testing and used Postman to test API calls.

Involved in projects involving C, C++, Java, .NET C# and SQL-Server.

Mobile application development utilizing Sencha Touch JavaScript API Framework

Developed web applications using Spring MVC, jQuery, HTML5, Bootstrap for Virtual Infotech Inc.

Designed user interface and web pages using CSS, HTML and jQuery.

Written business logic using C# and ASP.NET in MVC Architecture.

Written stored procedures for database to manage the data.

Environment: C#, C++, ASP.NET, HTML, VB.Net, Kendo UI, XML, jQuery, CSS, SQL Server 2008/2010, ADO.NET, Visual studio 2010/2012, REST, GIT, JavaScript, WCF, SOAP Web services.

Education :Masters in Computer Science and Engineering from Florida Atlantic University August 2022 - Dec 2023

Contact this candidate