.Net Developer Sql Server

Pradeep Rao Veeramaneni

Sr. Full Stack .Net Developer

Mail Id: *********************@*****.***

Contact Number: +1-402-***-****

Professional Summary:

●Highly motivated IT professional with progressively responsible experience of around 9+ years in development, testing, documentation & production support customized applications.

●Experienced in Agile & Waterfall project Methodologies for managing Project execution, planning, Sprint Planning, User Stories, Tasks, Backlogs, and Scrum Calls.

●Experience in building web applications using C#.NET, SQL Server, ASP.NET Core, ASP.NET MVC, Web API, ADO.NET, Entity Framework, HTML, CSS, JavaScript, jQuery, AngularJS, Angular, Bootstrap, Visual Studio 2022/19/15/17/13/12, React, Node, MySQL, WCF, IIS 8.5, web pack.

●Proficient comprehension and practical application of .NET Solid Principles, design patterns (Scopes like singleton pattern), Ilogger, Action Filters, Dependency Injection, DBContext, Configuring services & Configure middleware Request Delegate pipeline with use, map, run extension methods, Repository pattern (DAL), AutoMapper and DTO.

●Development of Micro-Services, APIs, and Software Apps using C#.NET, .NET CORE 3.0/2.0,.NET5.0/6.0.

●Hands-on technology experience of designing and developing software applications with Microsoft .NET Framework 4.5/4.0/3.5/3.0/2.0 using C#, ASP.NET and ADO.NET.

●Expertise in designing applications using modern architectures like Micro Services, N-Tier, Service- Oriented (SOA) and Client/Server Model.

●Skilled in developing user interfaces (UI) using various technologies, including HTML5, React JS, Silverlight, CSS3, Java Script, XML, J Query, XHTML, JSON, AJAX, TypeScript, Angular JS, Bootstrap, and Web UI applications.

●Experience in creating, consuming, and publishing traditional XML Web Services (SOAP) and Windows Communication Foundation (WCF) services, web - API (RESTful), and WPF.

●Expertise in modern web architecture using various advanced JavaScript frameworks and libraries like Node.js, React.js/Redux, React, Bootstrap, Ember.js, Responsive web design (RWD).

●Expertise in building Angular 12 and ASP.NET applications using .NET CLI and various UI tools.

●Developed Micro Services to handle business logic and make the application light weight for better performance.

●Expertise in Object Relational Mapping (ORM) frameworks like Entity Framework, LINQ.

●Experience in working with ADO.Net, Entity Framework and LINQ (LINQ to Object, LINQ to SQL, LINQ to XML, Lambda).

●Worked extensively with ADO.NET objects such as Data Adapters, Dataset, and Data Reader to interact with databases like SQL Server.

●Experience in working with the data model, writing scripts using Stored Procedures, User Defined Functions and Triggers in SQL SERVER and Oracle database.

●Developed and maintained Windows Forms applications for clients in the finance and healthcare sectors. Created Single Page web applications with rich and responsive user interface using UI technologies.

●Experienced in leveraging a diverse set of Azure services and technologies, including Azure App Service, Azure API Management, Azure Data Store, Azure Virtual Network, Azure Functions, Azure SQL, Azure Key Vault, Azure Storage, and Azure Virtual Machines. Additionally, proficient in utilizing GitHub Enterprise Cloud, Docker, and Kubernetes.

●Good Experience in automating CICD pipeline to deploy applications to multiple environments using tools like Bamboo, Azure DevOps, and PowerShell scripts.

●In-depth understanding of Object-oriented Programming concepts and Design Patterns.

●Extensive understanding on creating and managing Views, Partial Views, View Model in ASP.NET MVC.

●Expert in writing T-SQL statements for creating Tables, Indexes, Views and Constraints and stored procedures.

●Extensively worked in writing DB Connections, DB Queries, Stored Procedures, Triggers, Cursors, Exception Handlers, Crystal Reports, SSIS and SSRS.

●Experience working with XML technologies: XML, XSL, XSLT, XPATH and XML Schema for data sharing/ migration and reporting by SSIS, SSRS, and AJAX.

●Great knowledge with dependency injection using NInject and Autofac tools and native with ASP.NET Core.

●Well versed with Test Driven Development, used JUnit and Visual Studio Test Tools for Unit testing.

●Experience in working with GIT, Team Foundation Server (TFS) source control. Created new team projects under team project collections, merging and branching to support parallel development.

●Hands on Code Reviews, Change, Configuration, Release & Build Management and Administration of applications.

●Excellent communication, analytical, problem-solving skills, strong teamwork orientation, dedicated to quality output for the team or to individual assignments as required by the work environment. Willing to learn new technologies, ability to learn fast, and determined to achieve.

TECHNICAL SKILLS:

Languages

C, C#, JAVA, VB.Net, Python, COBOL, Kafka

.NET Technologies

.NET Framework 5.0, ASP.NET MVC5, ASP.NET Core 3.1,

ASP.NET Web Forms, WCF, RAZOR, BLAZOR.

Web Technologies

HTML5, CSS3, JavaScript, AJAX, jQuery, ReactJS, Angular JS,

Angular2/4/5/6/7/9/12/13, Bootstrap, WinForms, Node JS, XAML, XSL, XSLT, Kendo UI, Azure, Knockout JS.

Databases

SQL Server 2012/16/19, T-SQL, PL/SQL, ODBC, MySQL, SQL Server client management studio, MongoDB, Oracle 10g/91/81, PostgreSQL.

ORM Technologies

ADO.NET, Entity Framework, LINQ.

Cloud Technologies

Microsoft Azure, AWS.

Web Servers

IIS(Internet Information Services), SOAP, WSDL.

Testing Frameworks

Unit Testing (N-Unit and X-Unit) frameworks, MOQ Framework, MS-Test, Mocking, Visual Studio Unit Test, J unit, Jasmine, Selenium.

Web Services

Web API (Rest/Http) Services, XML, JSON

CICD Tools

Bamboo, Azure DevOps

Design Methodologies

Agile and Waterfall

Version Control

Bit Bucket, Git, TFS, VSTS

Other tools

Kafka, RabbitMQ, Postman, MS Office, JIRA, Vera Code

Professional Experience:

Client: Merck Pharma - Branchburg, NJ May 2022 – Present

Role: Senior .NET developer

Responsibilities:

●Gathered User Requirements, involved in grooming to break it into stories, and designing the acceptance criteria.

●Worked on Agile Methodology to meet timelines with quality deliverables.

●Developed web application implementing razor view engine, view, partial view, models, and layout view using ASP.NET MVC, HTML5, CSS, jQuery, RPC SignalR, Redis caching, API Gateway OCELOT, DATA LAKE Azure Blob Storage, Azure SQL, Cosmos Db and Bootstrap.

●Introduced the latest Blazor.Net with Asp.Net Core 3.0, resulting in a 20% increase in development efficiency as measured by the number of features implemented per sprint.

●Implemented data binding and templating features in Blazor, facilitating the dynamic display of data and seamless integration with backend services.

●Designed and developed UI, User Controls, and Client-Server Side Validation Controls using Web API, JavaScript, Bootstrap, Knockout JS, Angular9, AngularJS,, Redux,, Saga and Ajax.

●Involved in coding and designing using C#, XML, ADO.NET, WCF, JavaScript, Underscore JS, jQuery, HTML, and Cascading Style Sheets (CSS).

●Implemented AngularJS Controller functions, service using Controller methods to set up initial object state.

●Implemented AngularJS filters for search, sorting, pagination, and custom filters, resulting in a 30% improvement in user satisfaction metrics such as user engagement and retention.

●Designed and implemented an Angular JS framework, encompassing MVC architectures, distinct modules, controllers, templates, custom directives, custom filters, and addressing various angular scope issues.

●Used jQuery, JSON for dynamic user interface, retrieval and posting of data and Ajax to fetch data from controllers to update user data asynchronously.

●Extensively worked with LINQ provider and designed the user level application, which will build and execute a query expression for Server Side.

●Passed data between parent-child components using @Input, @Output, Event Emitter, View Child and diff types of subjects like behavior subjects.

●Utilize dedicated solutions like Azure Key Vault, environment variables, to securely store and manage connection string identities, ensuring separation of configuration from code and implementing robust access controls

●Implemented Azure Function's Queue Trigger & Service Bus, kafka, RabbitMQ or IBMMQ PUB-SUB model for efficient communication and follow-up actions, with a responsive React JS frontend for monitoring and management

●Implemented HTML Helper MVC WebGrid with JQuery for boosting the pagination performance and loaded the graphical data with JSON. Also supporting custom searching along with sorting the data with partial views.

●Utilized Angular Material, Bootstrap, and CSS3 for responsive design, leading to a 25% reduction in development time for UI/UX implementation compared to previous projects.

●Contributed to the adoption of serverless computing in Azure Cloud PAAS services, using services like App Services, Azure Service Bus, Queues, Azure Functions to build scalable, Azure key vault using Terraform, event-driven microservice architectures

●Design Authentication and Authorization using Open ID connect, Azure AD B2C, JWT.

●Using Terraform templates to automate the provisioning of Azure resources, improving deployment speed and consistency.

●Implemented JWT token authentication to secure the ASP .NET Core Web API and provide authorization to different users.

●Experience in building web applications using Angular and web APIs using GraphQL on server side.

●Experienced in fast-paced agile development including Scrum, and Test-Driven Development (TDD).

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

●Used ADO.NET and LINQ queries for retrieval of data from AZURE COSMOS DB-Mongo DB using disconnected architectures.

●Created Template driven and Reactive forms for building complex forms.

●Implemented data access layer using Entity Framework, reducing data retrieval and update times by 40% compared to previous methods such as ADO.NET and LINQ queries.

●Written multiple Stored Procedures, Triggers, and functions in SQL Server.

●Used Action Filters for implementing user authentications, authorizations, and role-based security.

●Contributed to QA testing when needed by drafting story test cases in JIRA.

●Used GitHub for version Control and source code maintenance needs.

Environment: Visual Studio 2019/2022, ASP.NET MVC 5/4, Angular 12/13, AngularJS, C#.NET, SQL Server 2016/2019, LINQ, Entity Framework, HTML5, CSS3, JavaScript,ReactJS, Ajax, jQuery, Bootstrap, Azure, GitHub, JIRA, IIS, N-Unit.

Client: Truist Bank - Charlotte, NC Oct 2020 – Apr 2022

Role: .NET developer

Responsibilities:

●Involved in Epic Grooming, Story Refinement, deciding the acceptance criteria along with Product Owner and Quality Analyst before pulling into the sprint.

●Development in Agile-Scrum Methodology to ensure quality in a fast-paced environment.

●Developed the application using C#, ASP.NET Core, HTML, CSS, Angular, Bootstrap and SQL Server in Micro Services Architecture.

●Decoupled application into Microservices using ASP.NET Core, Web API to handle business logic, improved performance, and code maintainability.

●Performed Custom validations of HTTP Requests using delegates.

●Implemented parallel processing concepts as part of developing business logic.

●Employed RESTful architecture in Angular versions 13, integrating Web API for asynchronous data retrieval.

●Implemented interactive and responsive web applications using Blazor, resulting in a 30% increase in user engagement metrics such as time spent on the platform and number of active users.

●Implemented server-side Blazor applications, utilizing the Razor component model to create dynamic and data-driven web pages.

●Extensive experience with C#, .NET, TCP/IP, and a solid understanding of object-oriented design, multi-threading, state-machine, and event-based programming.

●Experience on Deployment Automation & Containerization (Docker, Kubernetes).

●Installed and Configured OKTA LDAP Agent for delegated authentication with okta. Migrated Users from LDAP and Active Directory to OKTA Universal Directory and provided L2 support for LDAP.

●Experience in Mavenizing MuleSoft project and creating builds using Maven build tools for deployment to CloudHub / Mule MMC. Experience working with Agile Methodologies and SCRUM.

●Designed and developed GIS user interface using ArcGIS SilverLight API C.

●Generating New Users using OKTA CV Import feature for Provisioning of new users.

●Integrated Okta SSO to 20+ applications along with enabling MA Confidential Okta tenant & app level.

●Developed user interfaces using popular front-end frameworks like Angular or React with TypeScript, enabling the creation of dynamic and responsive web applications.

●Implemented integration flows using Mule AnyPoint Studio to connect to REST, SOAP service, Oracle Database, and ActiveMQ broker. Developing flows / orchestrations for integrating the components written on top of different internal platforms using Mule ESB and ActiveMQ.

●Experience in integrating Cloud applications like SFDC, Workday & Intact using MuleSoft ESB.6.

●Taking end-to-end responsibility for the designing and ensuring high-quality delivery of multiple customized modules and components developed. Developed ASP.NET Core Web API based on Client Requirements and Specifications. Implemented Convention-based CRUD action like GET, POST, PUT and DELETE.

●Worked Extensively with Angular CLI for creating components, Services, pipes, Directives.

●Experienced with Angular 12/13 controllers, templates, directives, routing, navigation, components, services, and data binding.

●Implemented OAuth Token-Based Authentication and Role-based Authorization, reducing security vulnerabilities by 30% and ensuring the protection of sensitive user data.

●Developed a user-friendly WinForms application that streamlined complex data processing tasks, improving operational efficiency by 40%.

●Used AWS CloudWatch to develop and manage monitoring and alerting for corporate and production servers and storage.

●AWS Security Groups were established as virtual firewalls to regulate traffic that reaches AWS EC2 instances. Using Puppet and Chef configuration management, managed servers on the Amazon Web Services (AWS) platform instances.

●Created many Microservices and APIs for the application and merged pre-existing Microservices from another team, deployed current apps to EC2 instances with each improvement.

●Using numerous EC2 instances, we designed and constructed fault-tolerant websites with auto-scaling, load testing, and Amazon failovers.

●Worked with SQL Server as data Repository, Used LINQ to SQL together with Entity Framework Core.

●Writing data access classes, triggers, created Views and stored procedures.

●Performed code reviews, worked closely with team members to maintain coding standards.

●Ensured application is error free at root level by following TDD pattern using X-Unit framework.

●Implemented a CI/CD pipeline using Azure DevOps and PowerShell scripts, reducing deployment time by 50% compared to the previous manual deployment process.

Environment: Visual Studio 2017/2021, ASP.NET Core 3.1, C#.NET, SQL Server 2016/2019, LINQ, Entity Framework Core, Mule ESB 3.8.2., ionic, OKTA, HTTP/REST Services (Web API), Angular 9/11, HTML5, CSS3, Bootstrap, GIT, AWS, Db Beaver, EC2 Instances, Lambda, Load Balancer, PowerShell, X-Unit, Oracle, Multithreading.

Client: State of New York - New York City, NY Mar 2018 – Sep 2020

Role: .NET developer

Responsibilities:

●Involved in the SDLC of requirement analysis, design, and development of the web-based application in the Fast-paced agile methodology.

●Designed and developed web pages using ASP.NET MVC, WPF, C#.NET, HTML, CSS, JavaScript, jQuery and Bootstrap.

●Efficiently designed Views, Partial Views, View Models and Action Filters in ASP.NET MVC.

●Implemented Web Parts, AJAX, web services and globalization in the project. Database design and development of database objects in SQL Server 2008 using OOP SQL Server Management Studio Express.

●Developed UI with expertise in AJAX, JavaScript, jQuery, HTML5, CSS3.

●Developed the application using MVC, Entity Data Model, RESTful and WCF services.

●Implemented HTML Helper MVC Web Grid with jQuery for boosting the pagination performance and load graphical data with JSON. Also supporting custom searching along with sorting the data with partial views.

●Implemented forms in Blazor, incorporating validation mechanisms to ensure data integrity and provide a smooth user input experience.

●Familiar with ASP.NET MVC routing and the way it is performed in Global.asax Register Routes method.

●Implemented different UI features like Lazy loading, widgets, multiple Views, and partial views.

●Used Angular2 framework where data from backend is stored in model using http and security configurations for authentication and authorization for populated model on to UI.

●Created Typescript reusable components and services to consume REST API's using Component based architecture provided by Angular 2.

●Worked with Azure DevOps for project management and Git for version control purposes.

●NGRX store was used to store results after angular injector observables retrieved the data from backend.

●Developed a WinForms-based inventory management system for a retail client, enabling real-time tracking of stock levels and reducing instances of overstocking by 15%.

●Experience with supporting SQL Server within an Azure PaaS environment.

●Implemented Service layer for the applications using Entity Framework and LINQ to objects.

●Implemented Authentication and Role based Authorization for ASP.NET MVC application.

●Developed Web Application in ASP.NET MVC 4.0 razor view engine, ASP.NET with C# as code behind, is used for client-side validation.

●Written SQL Scripts for creating database tables with foreign key relations in SQL Server using T-SQL.

●Involved in development of several SSRS, Crystal reports for the application.

●Used Azure CI/CD pipelines for application deployment in various environments.

●Used Git, Team Foundation Services for Version Control with Visual Studio 2017.

Environment: Visual Studio 2017/19, ASP.NET MVC 5, C#, SQL Server 2016, LINQ, Entity Framework, Azure, HTML5, CSS3, JavaScript, jQuery, Bootstrap, TFS, JIRA, IIS.

Client: Grapesoft Solutions - Hyderabad, India Aug 2014 – Nov 2017

Role: .NET developer

Responsibilities:

●Involved in designing the layout of User interface using Visio and Class diagrams using UML.

●The Presentation Layer is implemented in ASP.NET, VB.Net with HTML, Cascading Style Sheets (CSS) and Web Controls. The Web Forms are developed utilizing the C#.

●Implemented Data Access Layer using ADO.NET to connect and retrieve or manipulate database information.

●Data grid, Datasets were used extensively to display various MY SQL Server elements and allowed real time updates.

●Gained experience in REST architectural style, worked on CRUD actions. (Get, Post, Put and Delete).

●Created Restful services using ASP.NET Web API for exposing these to mobile device Involved in requirement gathering, analysis and documentation of assigned modules.

●Used AJAX for Partial Page Updating, Invisible Data Retrieval, Constant Updating, Smooth Interfaces, Simplicity and Rich Functionality, facilitating daily scrum meetings, enforcing timeboxes and responding to the impediments, tracking baseline, sprint planning and sprint retrospective.

●Resolved update, merge and password authentication issues in Bamboo and Atlassian suite and kept track of all releases and request of the developers through infrastructure management tool.

●Created T-SQL Stored Procedures, Functions, Triggers, and views in Angular to interact with database.

●Implemented data access layer using Entity Framework, reducing data retrieval and update times by 40% compared to previous methods such as ADO.NET and LINQ queries

●Designing, Implementing, and supporting fully automated Continuous Integration and Continuous Delivery processes using DevOps.

●Designed the complete solution using N-tier Architecture model and design patterns mainly Abstract Factory and Singleton, Using Swagger and POSTMAN to test the Web API RESTFul Service.

●Worked on Agile SDLC, SCRUM Methodology to practice-based methodology for modeling and documentation of software-based systems.

●Implemented features of ASP.NET AJAX such as Calendar Controls, Repeater Control, and Validation controls, Dataset, Security using forms authentication.

●Designed different components using C# language and used Exception handling, Error providers to handle exceptions.

●Designed Master Pages for look, feel and standard behavior to centralize the common functionality of all the web pages.

●Worked in writing DB Connections, DB Queries, Stored Procedures, Triggers, Cursors, Exception Handlers, Crystal Reports, SSIS and SSRS.

●System Administration with ADS, IIS, FTP and Proxy.

●Developed the necessary Stored Procedures and created Complex Views using Joins for robust and fast retrieval of data in SQL Server using T-SQL.

●Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding, interactivity using SSRS.

Environment: .NET Framework 2.0, ASP.NET, C#, VB.NET, ADO.NET, XML, Web services, Microservices, HTML, SQL Server2008, Oracle 10g, Crystal Reports, IIS 6.0, Windows 2000, VSS, SSIS, NUnit, Visual Studio 2005.

Contact this candidate