Software Development Sql Server

Suresh BG

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

Phone: 272-***-****

LinkedIn - SureshBG LinkedIn

SUMMARY

** ***** ** *********** ********** and responsibility with documented success in the areas of Software Development and Software Engineering with Microsoft Technologies at various organizational levels.

Worked extensively in ASP.Net MVC,.NetCore 6,.Net 6,WebAPI, C#. Net,AZURE, WebAPI, ReactJS,WCF,WebService,JQuery and well versed with RDBMS like MS-SQL server

Experience in Micro services, N-Tier, WebAPI, SOA, API, MVC and full life cycle software Development in which includes requirement & Object-oriented analysis, design, development and testing.

Experienced in Problem Solving & Troubleshooting in Store procedures. (Debugging using SQL Profiler and Execute Plan) MS-SQL server and OS concepts

Experience with using Version Control systems such as GitHub, AzureDevops.

Good Experience on Devops Pipeline, Git, Docker and Azure Concepts.

Well versed with software development life cycle models.ie Agile, Waterfall.

Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) to deliver customized data reports and data conversion.

Experience in Angular 14/16 by implementing routing, components, services and directives on the User Interface development.

Worked with ASP.Net, MVC Frameworks 6.0/5.0 and implemented controller actions and Views, Partial Views, Areas, Sections, Strongly Typed Views and View Models with State Management, Security, OAuth, caching features and configuring optimizations etc.

In-depth knowledge & experience of software Design Patterns including Singleton, Prototype, Factory, and Unit of Work & Repository Pattern.

Proficiency in Service-Oriented Architecture (SOA), MVC, N-Tier Architecture, and Relational Database Design. Proficiency in developing web applications using Web Forms and MVC.

Managing and scheduling pods. Facilitating communication between services.

Scaling applications based on demand. Managing configurations for containerized applications.

Expertise on building UI using ReactJS, Angular, AJAX, jQuery, Java Script, HTML, CSS, JSON.

Monitoring and logging for applications and the cluster. Ensuring the security of the Kubernetes cluster.

Good hands-on experience in T-SQL, SSRS, SSIS, Reporting, Analytics RDBMS concepts and data models.

Experience in Database programming using Oracle, TSQL, NoSQL, Toad.

Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) to deliver customized data reports and data conversion.

Experienced in SQL Server Reporting Services (SSRS) and Crystal Reports for report generation, integration into .NET applications and created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers

•Experience in Single Sign-On (SSO) integration with REST-based APIs, hands-on experience with leading Identity and Access Management (IAM) providers, including Ping Identity, and Okta.

•

•Have good experience in developing applications using Design Patterns and various architectures.

•Worked As Tech Lead and Associate Architect of Application Development

Experience in design and implement of Relational Database including Normalization, Stored Procedures, Triggers, Views, User Define Functions, SSIS Packages and SSRS Packages in MS SQL Server.

Have good experience in developing Ocelot Gateway, APIM.

Proficiency in Object-Relational Mapping (ORM) using ADO.NET, Entity Framework,EF Core, Dapper LINQ and Lambda expression. In-depth experience in Web Services, WCF and Web API development.

Experience with unit testing frameworks such as XUnit.

Worked On Azure Paas Service.

Developed the API’s using .net7 and Microservice architecture.

ability to lead and execute the implementation of iPipeline's IFS platform, ensuring seamless integration with existing business systems

Experienced in developing Service Oriented Architecture (SOA) using .Net services, SOAP, Windows Communication Foundation (WCF).

Experienced with Software Configuration Management, Source Control, and Version Control using Team Foundation Server (TFS), Git and JIRA.

Good problem-solving skills with a strong technical background and good interpersonal skills

CORE COMPETENCIES

Core/Business Technology

Asp.Net, C#, .Net Framework 7.0, WCF, ADO.Net, jQuery, WebAPI, NETCore7.0,Azure Paas, MVC,Oracle, Postgres, Angular,Ado.net

Microservices, .Net6,ReactJS,Angular Js,Sql,Mongo DB.,Dapper

Methodology

Agile, Waterfall, Kanban

Framework/Web Technology

Asp.Net,C# Web services, .Net 5,WCF,ADO.Net, Ajax, jQuery, LINQ, Design Patterns, ASP.NET MVC,Twilio,Kuberneetes, Docker, EFCore

NetCore,Microservices, WebApi, Azure, ServiceBus, Dapper,

Azure Paas, WebApps, Functionapps, Aks, AzureServiceBus, Cosmos,

ReactJS, Angular, postgres

RDBMS

SQL Server 2022,Oracle,Postgres

Cloud Technologies

Microsoft Azure, Azure DevOps, AWS

IDE & Tools

Microsoft Visio, TFS, AzureDevops, Git, PostMan, Twilio, SendGrid,

VSO Tool, VS2022.

Testing

Unit Testing, Analyzing and preparing Test plans, Test cases, Test documents, Integration Testing, Automated Website Testing, TDD, Specflow, Nunit, XUnit, MSTest

PROFESSIONAL QUALIFICATIONS

B.Tech (Computer Science) From Jawaharlal Nehru Technological University .

Certifications:

Scaled Agile (Safe 5) Certified Practitioner (Cer id: 659*****-****).

Azure Developer Associate (Credential ID: CF5B572537410D24).

PROJECTS:

Client: VANQUIS MOBILE APPLICATION, PA Jan 2023 – Till Date

.Net Lead

Responsibilities:

Developed BFF Layer (entry point of all other Api’s)

Developed the Various APIS Using Microservice Architecture.

Developed FiservLib. (Which will used to access Fiserv API, this library used to centralize for all Fiserv Access logic and reusable in various APIs.

Developed Mobile Status Api(App maintenance)

Developed Coverlet package for code coverage and written test cases in all API.

Involved in Devops Support. (config, pipelines)

Used Azure Paas Services (WebApps, AppInsights,StorageUnits,ServiceBus,Cosmos)

Thorough understanding of the fundamentals of software design principles, patterns, and practices.

Participate in technical requirements gathering, technology selection, data modelling, Azure infrastructure design, and DevOps & CI/CD process design with guidance from our technical and architecture leadership.

Used EF Core to Connect Database.

Used React for UI Development and integrated with Apis

configuring and customizing the IFS platform to meet specific business requirements.

Proactively involved in wiki creation AzureDevops, Documentation and support activities.

Used POSTMAN/Swagger to test the Web API and Wrote LINQ queries and lambda expressions to perform CRUD operations.

Writing unit test cases using Xunit.

Environment & Tools: C#.Net, ASP.Net Core 6, Typescript, React JS, Visual Studio 2022, SQL Server 2022, Mongo DB, Fiddler, Swagger, HTML5, CSS3, Web API, J-Query, GIT, LINQ, Mock Framework, Azure, Auto Mapper, xUnit, Cosmos DB, ServiceBus, ReSharper, Design Patterns,, Git Bash, CI/CD Pipeline, Microservices.

Client: PPL IVR Application, RI Dec 2020 – Nov 2022

.Net Lead

Responsibilities:

Developed IVR LG Files

Worked On BOT Framework.

Developed the component which will interact IVR Chat BOT and Twilio Services

Used to Az-FunApp used to send Alerts.

Created Unit Testcases

Worked on Az Services.

Writing unit test cases using Xunit.

Thorough understanding of the fundamentals of software design principles, patterns, and practices.

Solid understanding of relational database concepts, data modeling, and design.

Participate in technical requirements gathering, technology selection, data modeling, Azure infrastructure design, and DevOps & CI/CD process design with guidance from our technical and architecture leadership.

Developed and maintained stored procedures, User Defined Functions, Indexes, Views, Tables, and Relationships on SQL Server database.

Environment & Tools: C#.Net, ASP.Net Core 6, Typescript, React JS, Visual Studio 2022, SQL Server 2022, Mongo DB, Fiddler, Swagger, HTML5, CSS3, Bootstrap, Web API, J-Query, GIT, LINQ, Mock Framework, Azure, Auto Mapper, xUnit, Cosmos DB, Protractor, Karma, Jenkins, ReSharper, Design Patterns, GIT Lab, Git Bash, CI/CD Pipeline, Microservices.

Client: Microsoft, Redmond WA Feb 2019 – Nov 2020

Senior Software Engineer

Responsibilities:

•Implemented web application design and development using .Net Core with C#, ASP.Net Core, Entity Framework and REST Services.

•Created Angular service and integration with Restful APIs.

•Built Framework and .NET Core business blocks and connecting to API's using C#, reviewing developer check-ins, supporting infrastructure, making development recommendations, managing data in DynamoDB and AWS (S3).

•Designed, planned, and carried out installation, upgrade, configuration, and maintenance of Veritas NetBackup 5.1 and 4.5 for Solaris and Linux.

•Used ALM to track and report system defects and bug fixes.

•Implemented data models and databases to store and manage sensitive child welfare information securely.

•Source control using GitHub Enterprise and a feature, develop, and master Git branching strategy.

•Involved in Unit testing with MOQ framework.

•Developed, maintained, and executed load and stress test with JMeter.

•Developed many applications using ASP.NET (Visual C#, Visual Basic, Visual Studio 10,11) and back-end as Microsoft SQL Server 2008.

•Installed and configured SUN Solaris 9, 10 on sun servers using Jumpstart installation and also manually.

•Experience in creating CI/CD pipeline using Team City and azure DevOps CI/CD, azure containers, and Azure Kubernetes Services (AKS).

•Worked in Setting up development environment using latest Blazor.Net with Asp.Net Core 6.0.

•Designed and developed the application using Angular 14 framework along with HTML5, CSS3, Type Script, JavaScript, Bootstrap, Node.JS, and NPM.

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

•Contributed to project repositories to utilize serverless technologies, services and container technologies (Docker, Kubernetes etc.) for CI/CD integration and project onboarding.

•Created and maintained Unit Tests using N-Unit frame works for assuring the correct functionality of the projects.

•Integration with SailPoint to provide functionality for Identity Governance.

•Knowledge of using Continuous Integration / Continuous Deployment (CI-CD) tools as Jenkins.

•Designed and developed web various business component, extensions and conversion objects to meet project requirements using C# and ASP.NET with Core and Micro-services.

•Developed solutions for diverse programming scenarios in C#, employing Object Oriented Programming (OOP) concepts such as: encapsulation, inheritance, polymorphism, and abstraction.

•Leveraged Angular sources for data access and created custom directives, factories, and services for the reusable components

•Build Data Contract and Design Pub/Sub architecture for managing data queues using Kafka.

•User Authentication and Authorization using OAuth and .Net Core Filters.

•Utilize programming languages like Java, Python, SQL, Node, and Scala, Open-Source Platforms and NoSQL databases, Container Orchestration services including Docker and Kubernetes, and a variety of AWS tools and services.

•Implemented Moq framework for server side functionality testing.

•Designed the applications using ASP.Net, CSLA, Page Flow, VB.Net, WCF and ASP.Net MVC 4, Entity framework and SharePoint.

•Work with client to understand new Duck creek product adapted by Confidential.

•Experience in building and operating applications running on public cloud environments (AWS, Azure, and GCP) including DevOps practices.

•Wrote complex Stored Procedures, Functions, Triggers, SQL Queries and Views using SQL Server.

•Worked on fine tuning complex SQL queries, improve performance to meet project NFR (non- functional requirements).

Environment & Tools: C#.Net, WebAPI, ASP.NET MVC 6.0, Angular 14, Typescript, Visual Studio 2018, SQL Server 2016, Mongo DB, Fiddler, Swagger, HTML5, CSS3, Bootstrap, Web API, J-Query, GIT, LINQ, Node JS, TDD, Nunit, Mock Framework, Azure, Auto Mapper, NUnit, CosmosDB, Protractor, ReSharper, Design Patterns, GIT Lab, GCP, Git Bash, CI/CD Pipeline Deployments, Jarvis, Geneva, Microservices, Grafana, React JS, Protractor, Kusto Query Language, Jarvis, OAuth.

Client: Kimberly-Clark Jan 2014 – Nov 2018

Senior Software Engineer

Responsibilities:

•Involved in business analysis, gathering and elicitation of requirements and specifications, project planning and ensuring a smooth release implementation.

•Used Object Oriented Programming concepts and Object-Oriented Design Patterns while building the common libraries.

•Generation of Bug (Defect) Reports, tracking the status of each defect (Open, fixed and New) and analyzing the bugs using ALM.

•Executed JMeter Scenarios to perform performance testing of web application and Rest API’s. Also executed Stress and scalability.

•Agile development with issue tracking and documentation via JIRA and SharePoint.

•Used UML for creating several types of diagrams such as use case, activity, sequence, class, and deployment diagrams.

•Used Dapper ORM used to connect Database Operations.

•Developed the application’s Web layer with ASP.Net, Business layer with VB.Net, and Data Access Layer with ADO.NET advanced functionality.

•Applied Master pages, CSS, Navigation Controls, and HTML for a consistent look and feel for page designing.

•Developed Task Assignment application by implementing the Single Page application template using AngularJS Route Providers.

•Performed client-side validations using jQuery and ASP.NET MVC validation implemented at Controller level.

•Performed load and stress testing using rendezvous points and recording transactions in LoadRunner, to pinpoint potential problem areas and bottlenecks.

•Worked in using React JS components, Forms, Events, Keys, Router, Animations and Flux concept.

•Implemented an asynchronous Blazor Web Assembly UI for visualizing the authentication process and keeping track of steps between integrated APIs.

•Programmed ADO.NET for communication between application and database, used Data Grid, Data Set, Data Table, Data Adapter and Data Readers.

•Established communication between apps running on different platforms with WCF.

•Consumed RESTful resources using AJAX calls and processed JSON responses to get required data for asynchronous data transfer between the app and server.

•Performed database queries using LINQ to SQL and queries to XML files using LINQ to XML.

•Involved in XML parsing & XSLT and used web services to interact with the data layer to access data from the database.

•Extracted data and created test datasets from sources like Oracle database, Excel and flat files using Import techniques.

•Developed code in PL/SQL to run batch jobs for Oracle database.

•Processed data in SQL Table by running multiple SQL scripts & Stored Procedure.

•

•Worked on the Microsoft Azure services for developing and deploying applications and maintaining data through Azure SQL and Azure Table Storage.

•Used VSS for version control and file sharing. Involved in testing modules using N-Unit and fixing bugs.

•

Environment & Tools: .Net Framework 4.5, HTML, jQuery, WCF, SQL Server 2012, Asp.Net MVC,Ado.net,

ASP.Net, MVC, C#, LINQ, Lambda expression, Entity framework, Webservices

Client: Honeywell Home-TITAN Jan 2011 – Dec 2013

Software Engineer

Responsibilities:

•Validations using jQuery.

•As per requirement all the User Interface screen has been developed in HTML

•Using jQuery Controls for Data Representation.

•Using jQuery and AJAX, the JSON based services are called

•Develop MVC Controller, View Models and Helper methods linked to backend database.

•Ado.net framework used for database connectivity.

•Developing business logic under WCF Service based on the requirement.

•Preparation of Sp's for the respective Services.

•Implementing Code and Unit Testing.

•

Environment & Tools: .Net Framework 4.5, HTML, jQuery, WCF, SQL Server 2012, Asp.Net MVC,Ado.net,

ASP.Net, MVC, C#, LINQ, Lambda expression, Entity framework, Webservices

Contact this candidate