.Net Developer Sql Server

Raveendranatha Reddy Gorantla

Mobile: +1-336-***-****

Email Id: **************.*@*****.***

LinkedIn Id: www.linkedin.com/in/RaveendranathaGorantla

SUMMARY:

A quality conscious Full Stack Lead Developer with over 12+ years of experience in Microsoft .Net and azure technologies. My mission is to leverage my technical skills and domain expertise to create innovative and efficient solutions that solve complex problems and add value to the organization and the customers. I am passionate about learning new technologies and enhancing my professional development.

TECHNICAL SKILLS:

Expertise in Microsoft Technologies like .NET Framework 3.5/4.0/4.5.2/4.6, 4.7.2,4.8, .NET CORE 3.1, .NET 6, .NET 8, MS SQL Server 2005/2008 R2/2012/2016/2023, Azure Data Studio, Visual Studio 2010/2012/2015/2017/2019/2022, IIS 6/7.5/8.0/10.0, IIS Express, Windows 7/8.1/10

Working experience in programming languages C#.Net, VB.Net, ASP.Net, Asp.Net MVC 4/5.2.7, Asp.Net Core, ADO.NET, T-SQL, PL-SQL, LINQ.

Hands on experience in SDLC of Analysis /Design /Develop /Testing /Implementation /Documentation /Maintenance various applications like Windows Forms/Web Applications/Windows Services/Web Services etc.

Experience in creating Azure Web Apps, Logic Apps, Function Apps, AKV, Storage Accounts, Blobs, Azure Event Grid, Resource Groups, Azure SQL, Azure APIM and Azure Service bus.

Working experience in creating RESTful services using WEB API.

Experience in communicating data between Client and Server using WCF, SOAP messages.

Experience in Client-side technologies JavaScript, jQuery, Typescript, Node, Angular, React JS.

Working Experience on development Tools like SOAPUI, Postman, Fiddler.

Expertise in creating classes using ADO.Net for accessing and modifying data in databases.

Working Experience on ORM tools such as Entity Framework, Entity Framework Core, Dapper.

Having AZ-204 Azure Developer Associate & Microsoft SQL Server certification from Intellipaat.

Good Experience in Agile Scrum development model.

Expertise in N-Tier/Layer Client/Server development architecture, MVP, MVC and MVVM model.

Experience in OOPs, OOAD, Design Patterns, SOLID principles, UML and Software Architecture.

Experience in Migration of Azure logic apps from ASE to ISE V3 Migration.

Expertise in Markup Languages like HTML5, XML, CSS, CSS3.

Experience working in an Azure environment including CI/CD, ADF & ASW Pipelines, AKS.

Experience in SQL, T-SQL, PL-SQL, stored procedures, functions, triggers, views, joins in SQL Server, MySQL, SQL Developer, Oracle, SSIS and SSRS.

Experience in building the ETL processes using SSIS, Azure Batch, Multithreading.

Extensive experience of Enterprise Services with Insurance, Banking, and Utility Domains.

Experience in leading and coordinating the offshore team from onsite client locations.

Expertise in Task Monitoring tools such as JIRA, My Service, Service Now, Azure DevOps.

Having knowledge on AWS, MongoDB, Kafka, Microservices, Vue.JS, Blazor.

Extensive experience in deployment of tools such as TeamCity, ACDC, Octopus.

Hands on experience in Source Controls such as STASH, GitHub, TFS, Tortoise SVN, Azure.

Responsible to create Detail Design, Impact Analysis, Technical Runsheet documents.

Strong Analytical, Communication Skills and troubleshooting capabilities /Problem Solving Skills.

EDUCATION:

Master’s degree in computer science from Vinayaka Missions University, Salem, INDIA – 2010

Bachelor’s degree in mathematics from Sri Krishnadevaraya University, Anantapur, INDIA – 2007

PROFESSIONAL EXPERIENCE:

Client: Stake Center Locating (SCL) – Greensboro, NC Aug 2020 – Present

Role: Full Stack .Net/Azure Lead Developer

Project Name: SCL Ticket Management System

Project Description:

Ticket Management System (TMS), all tickets are coming from 811 call centers and IRTH across all states in U.S. for locating Fiber/Gas/Electric etc. by locators. Managers/Administrators can have access to create users in managerial website, so that the users/locators are able to login the locating website using their credentials. Based on polygon coordinates tickets are assigned to locators. Locators will work based on priority of the ticket in the current work queue and close the tickets by uploading the images and selecting work and billing details. Locator can see all billed/closed tickets in previous work queue tab. Locator have the access to update/modify ticket billing details in this tab. Managers are able to close the screened tickets and reassign or splits tickets to other locators. Managers can generate reports for ticket flow of each state and pulling damage tickets etc. Excavators can dig the field based on locator instructions. Watch Email & Send Response are windows services for a complete ticket management system

Responsibilities:

Requirement gathering from stakeholders and project managers.

Business requirement analysis and preparing high level solution document.

Attending daily Agile/Scrum meetings with team to update the progress of the work.

Designed application using Asp.Net Core MVC, C#.Net, HTML5, CSS3.

Building Azure Web Apps, Function Apps, AKV, Storage Accounts, Azure Event Grid, Blobs, Resource Groups, Azure SQL, Azure Logic apps and Azure Service bus.

Implemented process to deploy the apps using Azure devops CI/CD pipelines.

Building processes using Logic Apps, Function Apps. Batch processes using Azure.

Written complex queries, table design, DB administration, stored procedures, functions, performance optimization, profiler utilization using SQL Server RDB.

Developed C#.Net code using MVC to pull the data from relational database and returned as a JSON.

Built the App Service Environment using v3 resource. Configured infrastructure and connected resources to work with the new environment. Deploying apps into the new Azure Service Environment.

Building business functionality using Web API http methods.

Built the code using JavaScript / jQuery / React JS for designing the user interface.

Deploy the sprint work items into the Test Environment for UAT verification and signoff.

Production deployment and support of the applications.

Environment: .Net 6, Visual Studio 2022, Asp.Net Core, Azure, C#.Net, HTML5, CSS3, Web API, React JS, SQL Server, Windows 10, Azure DevOps, GitHub, Entity Framework Core, Teams, Postman.

Project #2: SCL Operations Goals & Safety Notifications

Project Description:

Operation managers can login to the portal using Azure AD single sign-on mechanism, to set up goals for all locators under him. All operations managers must meet their average MPH goals. The leadership team has assigned an average MPH budget to each operation manager. Manager can view and edit the goal for each locator based on MPH budget.

The risk management team must send safety notifications to all internal SCL users of the operations group and corporate group daily. Application would allow you to select either single or both groups to receive safety notification. They can choose to schedule the notification when to deliver to the locators or corporate users.

Responsibilities:

Requirement gathering from stakeholders and project managers.

Attending daily Agile/Scrum meetings with team to update the progress of the work.

Designed application using Asp.Net Core MVC, C#.Net, HTML5, CSS3.

Building Azure Web Apps, Function Apps, AKV, Storage Accounts, Blobs, Azure Event Grid, Resource Groups, Azure SQL, Azure Logic apps and Azure Service bus.

Implemented process to deploy the apps using Azure devops CI/CD pipelines.

Migration of Azure logic apps from ASE to ISE V3 Migration.

Created ADF/ASW pipelines from source to destination.

Building processes using Logic Apps, Function Apps. Batch processes using Azure.

Buit Azure Function Apps with various events, such as HTTP Requests, Timers, changes in Storage.

Written complex queries, table design, DB administration, stored procedures, functions, performance optimization, profiler utilization using SQL Server RDB.

Developed C#.Net code using MVC pattern to pull the data from relational database and returned as a JSON format.

Buit Azure Functions as a Serverless Compute service without need of managing Infrastructure.

Created Azure functions are used to scale the load for allowing to manage workloads without manual intervention.

Used Kudu for managing and deploying Azure Functions.

Built the code using JavaScript / jQuery / Angular for designing the user interface.

Building business functionality using Web API http methods.

Deploy the sprint work items into the Test Environment for UAT verification and signoff.

Setting up the Environment Variables in Azure Web App to run the application up and running.

Built the App Service Environment using v3 resource. Configured infrastructure and connected resources to work with the new environment. Deploying apps into the new Azure Service Environment.

Flexible to switch the environment from Dev to Prod and maintain the error logs.

Production deployment and managing the containerized applications using Azure Kubernetes.

Environment: .Net 8, Visual Studio 2022, Asp.Net Core, Azure, C#.Net, HTML5, CSS3, Web API, Angular 17, jQuery, SQL Server, Windows 10, Azure DevOps, GitHub, Entity Framework Core, Teams, Postman, Azure AD, SSO, Microsoft Entra, PowerShell.

Client: Commonwealth Bank of Australia (CBA) - Australia Oct 2015 – Feb 2020

Role: Senior .Net Developer

Project Name: Fee Disclosure Statements (FDS), Salesforce Reflow to ARDB

Project Description:

FDS – Fee Disclosure Statements Tool which is used by Financial Advisers for generating the Ongoing Service (OGS) to their clients. FDS system mainly used by 4 dealer groups, those are Commonwealth Financial Planning (CFP), Financial Wisdom Limited (FWL), Commonwealth Financial Planning – Pathways and Bank west (BWFA).

ARDB - Case officer creates customer case information along with account, payment, contact, third party provider, record type, compensation calculation, source system etc. in Salesforce. That information must flow into the ARDB database.

Responsibilities:

Requirement gathering from stakeholders.

Business requirement analysis and preparing high level solution document.

Responsible for attending daily Agile/Scrum meetings with team to update the progress of the work.

Co-ordinate with the client, Business Analyst, to get the requirement clarification and documentation for the application changes.

Download the source code from Azure DevOps by creating a branch version for every change to build the new code changes.

Application deployment on Development, Testing and production environments and following change and release management process.

Gathered functional, business, and technical requirements and prepared the requirements document.

Actively Involved in coding activities in C# and ASP.NET MVC, Web API and Used LINQ to SQL in Business Logic Layer.

Its web-based N-Tier application developed using SQL Server as Data Repository Tier, Web API Services (Data Access Layer) as Business Service Tier and MVC as Presentation Tier.

Efficiently used object-oriented programming to achieve the functionality for the application.

Developed Web API services to communicate with the Data Access Layer.

Created SSIS Package to call Web API and load the data into ARDB database.

Extensively used Entity Framework to connect SQL Server database with Data Access Layer.

Created new tables and mapping of Entity Relationship of fields in SQL Server 2016.

Written complex queries, table design, DB administration, stored procedures, functions, performance optimization, profiler utilization using SQL Server RDB.

Deploy the code into Test Environment, multiple team coordination.

Supporting to Quality Analyst for test execution.

Preparing technical run sheets, handover documents.

Responsible for change management coordination.

Environment: .Net Core 3.1, Angular 7.0, WCF, HTML, CSS, Java-Scripts, ASP.Net MVC, LINQ, NHibernate, SQL Server 2016, Windows 8.1, SSIS 15, JIRA, Octopus, Postman SOAP UI, NLOG, Web API2, Azure DevOps GitHub Enterprise, Visual Studio 2017 with C#, IIS7.5, TeamCity, ACDC, My Service, Confluence, Documentum.

Client: AVANT Mutual Group (AVANT) – India Jun 2012 – Aug 2015

Role: .Net Developer

Project Name: Aurora Claims, Workflows & Fulfillment

Project Description:

Aurora Claims is a web based internal application of AVANT. This was used to handle the claim details of the practitioners. Practitioners are medical professionals, dentists, doctors, and this system is to safeguard them against any case filed by the patients. When the patient intimates a claim, the existence of the similar case is checked. If a similar case is not present, then a new case is created. The Advisory Support team is responsible in claim creation process. A Claim Manager is allotted to each claim who updates the details in the system. Also, it has supporting applications Fulfillment and Workflows.

Responsibilities:

Responsible for attending the sprint meeting with onsite scrum master.

Responsible for analyzing the sprint stories and finding the impact of the story and providing the total estimation hours.

Involved in technical discussions with team members for clarifications.

Responsible for screen design using ASP.Net controls and User controls with CSS styles.

Built the code using C#.Net and VB.Net, Asp.Net to develop the business logic.

Written complex queries, table design, DB administration, stored procedures, functions, performance optimization, profiler utilization using SQL Server RDB.

Responsible for helping team members if any technical clarifications are also responsible for reviewing the code developed by juniors.

Involved in code check in and check out using the SVN source version control, taking new branch version for each user story before writing the code.

Responsible for doing unit testing using N-Unit to meet the business requirements with all scenarios. Also deploying the source code in QA environment for tester verification.

Responsible for coordinating with the testing team and involved in bug fixing.

Environment: Microsoft Visual Studio Tool, ASP.Net, C#.Net, VB.Net, HTML, CSS, JavaScript, WCF, N Unit, IIS, SVN, SQL Server, Oracle.

Contact this candidate