Home

Sampath - DOT NET Developer

[email protected]

Location: Dallas, Texas, USA

Relocation:

Visa:

Sampath Bandari Technical Lead - DotNet Full Stack LinkedIn: www.linkedin.com/in/sampath-bandari TECHNICAL SUMMARY Around 13+ Years of proven IT experience in Designing, Developing and Delivering high quality software solutions using Microsoft .Net, Microsoft Azure / DevOps technologies along with Angular framework. Having 4 Years of professional experience as a Technical Lead. Having functional domain experience in Retail, Healthcare, Insurance, Banking, Entertainment, Logistics and Supply Chain Management System. Experience in using Microsoft Technologies, such as .NET Framework, C#, .NET Core, Microservices, MVC, ASP.NET, Web API, Web Services, WCF, SOA, SOAP, Entity Framework Core, LINQ, ADO.Net, Microsoft SQL Server, Oracle, MSBI Suite (SSIS, SSRS), Crystal Reports, Power BI. Working experience in deploying CI/CD pipelines using Azure DevOps on Jenkins, Kubernetes and Docker container defining YAML configurations. Experience in implementing front-end development using Angular, NodeJS, TypeScript, JavaScript, jQuery, Bootstrap, JSON, XML, HTML5 and CSS. Provided Architectural Solutions for designing and developing enterprise applications using MVC (Model View Controller) architecture and N-Tire architecture. Prepared extensive Electronic / Written Documentation that includes functional specifications, technical design documents, installation and testing guides. Exceptional skills of creating Activity diagrams based on UML Methodology and Flowchart diagrams using Microsoft Visio. Experienced working with Agile Scrum and heavy involvement in all phases of SDLC. Hand-full experience on SOLID principles, GoF Design patterns and Dependency Injection. Strong knowledge and experience on Object Oriented Programming (OOPs). Experience in .NET Core including MVC architecture, middleware pipeline, and routing. Built HTTP s RESTful services using WebApi and formatted the responses to JSON. Implemented token-based authentication using JWT, OAuth to secure Web API. Used .NET CORE s inbuilt logging functionality Serilog to log all the audit and exception messages and push it to various configurable available. Expert in creating Summary reports, Drill-down reports, Dynamic grouping/filtering reports, Graphical reports using SSRS and Crystal Reports for various departments within the organization. Experience in using iText Library for generating PDF document dynamically. Extensive experience in utilizing JIRA as an issue tracking and project management tool for efficient software development processes. Experience in Performance Tuning and Query Optimization by creating and modifying Indexes, setting transaction isolation level to avoid Deadlocks situations. Proficient in writing test cases and performed unit testing using NUnit in Test Driven Development (TDD) Environment. Working Experience in establishing continuous integration / deployment services using TFS and GIT. Performing code reviews, developing and adhering to coding standards. Coordinating with Offshore team, like discussing issues in weekly meeting, project decision making. Knowledge in Azure Cloud Hosting Services (PaaS & IaaS), Active Directory and Key Vault. CERTIFICATIONS Exam Code: AZ-204 - Microsoft Developing Solutions for Microsoft Azure. Exam Code: 70-463 - Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012. TECHNICAL SKILLS Category Tools Architecture MVC, SOA, N-tier, 3-tier Design Pattern Dependency Injection, Singleton, Lazy Loading, Solid Principles Front-end Technologies Angular 5/9/16 Web Technologies .Net Core 3.1/6.0, MVC 3.5/4.0/5.0, WCF, WebApi, SOA, SOAP Programming Languages C#, VB.Net Scripting Languages TypeScript, Bootstrap, JQuery, JavaScript Mark-up Languages HTML, XML, CSS Development IDE Visual Studio 2010/2013/2019/2022, VS Code, Data Tools, SSMS, NUnit Tool ORM Tools ADO.NET, Entity Framework Core 2.0/7.0 Databases MS SQL Server 2008/2012/2019/2022, Oracle 11g, MySQL Methodologies Agile, Waterfall Cloud Services Microsoft Azure / DevOps Unit Test Framework NUnit, TDD Design Tools Microsoft VISIO Issue Trackers JIRA Reporting Tools SQL Server Reporting Service (SSRS), Crystal Reports, Power BI Debugging Tools Postman, Fiddler, GraphQL Version Control Tools GIT, Team Foundation Server (TFS), Tortoise SVN PROJECT DESCRIPTION Client: Verizon New York, USA July 2023 Till Date Role: Technical Lead Roles & Responsibilities: Successfully managed multiple .NET projects from initiation to completion, ensuring on-time delivery, within budget, and meeting or exceeding client expectations. Involved in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Implementation, Testing and Maintenance. Involved in agile methodology with Scrum meetings. Completing the tasks in timely fashion with respect to each individual Sprint. Developed ASP.NET Core Web API based on departmental requirements and specifications. Implemented JWT Token based authentication to secure the ASP.NET Core Web API and provide authorization to different users. Expertise in implementing Web API, REST services which enable data exchange in XML and JSON formats. Worked with advanced concepts of ASP.NET Core MVC such as Models and Providers, Filters used for developing backend technology. Orchestrates the application's workflow by managing interactions between the MVC model and view components. Implemented convention-based CRUD actions like GET, POST, PUT and DELETE. Maintained the Web UI compatibility in all major Browsers (IE7 and above, Firefox and chrome). Used client-side technologies like HTML, CSS and JavaScript for designing pages and validations as per business requirements. Designed and created models, components, modules, and services to apply client-side logic and dependency injection using Angular. Implemented Client-side validation using Angular 16 Custom Form Validation with ng-show and ng-hide. Created strongly typed Typescript reusable services using Angular. Implemented a CI/CD pipeline with Docker, Jenkins and Azure Container Service. Whenever a new GitHub branch gets started our Continuous Integration (CI) server, automatically attempts to build a new Docker container from it. Worked on Setting up the build and deployment automation using Kubernetes. Extensively wrote and used Stored Procedures, Database Triggers, Functions, and Indexes in SQL Server. Performed unit testingwithin Test driven development by analyzing and writing test cases and fixing bugs. Worked on distributed version control system/Subversion called GIT and comfortable with feature branches and merging. Sync up with offshore team and onsite stakeholders. Customized Jira workflows, issue types, and custom fields to align with the project development processes. Implemented Design with enforced to use UML diagrams. Environments: .NET Core 6.0, Visual Studio 2022, Azure DevOps, ASP.NET, C#, .NET Core, MVC 5.0, Web API, Entity Framework Core 7.0, LINQ, Angular 9/16, TypeScript, SQL Server 2019/2022, TFS, GIT. Client: Prime Healthcare California, USA July 2016 June 2023 Role: Technical Lead Roles & Responsibilities: Involved in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Implementation, Testing and Maintenance. Involved in agile methodology with Scrum meetings. Completing the tasks in timely fashion with respect to each individual Sprint. Created database design, preparing entity relations diagrams, UML case diagrams using Visio tool. Worked with daily claim processing and uploading EDI files, HL 7 Files into database Used HIPAA EDI 837, 835 to generate and translate EDI files with data from SQL database using C#. Developed BizTalk maps to process HIPAA and EDI data. Managed offshore development team to complete BizTalk development for HIPAA and HL7 healthcare transactions. Created RESTful services using WebApi and formatted responses to JSON. Implemented JWT Token based authentication to secure the WebApi and provide authorization to different users. Created Model classes in MVC to encapsulate all models used on the different views. Used MVC Razor View Engine to develop views with scaffolding templates and implemented controllers to transfer data between Views and Models. Designed Layout page in MVC as a template for each View and used Partial View to reuse the code. Used View Bag to transfer data between controllers and view in MVC. Implemented server-side validations by using Data Annotations in MVC. Designed the Entity Framework Core using Code-First approach. Responsible for using LINQ and Lambda expressions while writing the code. Implemented LINQ Query operations like Grouping, Ordering and Filtering operations to access the DB. Developed the data access layer using ADO.NET to connect to database and fetch data. Implemented ADO.NET objects like Dataset, Data Reader and the Data Adapter for manipulating, storing and displaying the data from the database. Implemented a CI/CD pipeline with Docker, Jenkins and Azure Container Service. Whenever a new GitHub branch gets started our Continuous Integration (CI) server, automatically attempts to build a new Docker container from it. Worked on Setting up the build and deployment automation using Kubernetes. Developed custom directives and components in Angular for streamlined user interactions and enhanced data visualization Created Angular Components, Directives and Services to collect the inputs from the User. Designed Modules and Controllers using different directives like ngShow, ngRepeat, ngApp, ngController and many more using Angular. Created strongly typed Typescript reusable services using Angular. Created SSIS packages to extract, transfer and load data into the Database. Created ETL packages in SQL Integration services (SSIS) for various data loads and extracts from different types of sources like SQL Server, Text, CSV flat files, Excel. Created and managed reports using SQL Server Reporting Services (SSRS) to provide data insights to stakeholders. Extensively wrote and used Stored Procedures, Database Triggers, Functions, and Indexes in SQL Server and in Oracle. Experience in writing Common Table Expression (CTE) to replace complexities of sub queries and enhanced query execution time successfully in SQL Server. Performed unit testingwithin Test driven development by analyzing and writing test cases and fixing bugs. Worked on distributed version control system/Subversion called GIT and comfortable with feature branches and merging. Provided technical guidance and helping the team solving complex problems. Environments: .NET Core 3.1, Visual Studio 2019, Azure DevOps, ASP.NET, C#, MVC 4.0, WCF, SOA, SOAP, Web API, Entity Framework Core 2.0, LINQ, ADO.Net, SSIS, SSRS, Angular 9, TypeScript, jQuery, CSS, HTML, SQL Server 2019, Oracle 11g, TFS, GIT. Client: Xappie Community Hyderabad, INDIA Feb 2016 Jul 2016 Role: Senior DotNet Developer Roles & Responsibilities: Working closely with Business team and developing web applications using latest .NET technologies like MVC and .NET framework 4.5, with Entity Framework. Implemented various Design Patterns like Factory Pattern, IOC, Singleton and etc. Created View Models to encapsulate all models and classes used on the different views for more stable, organized and clean code to reuse in Views. Used Razor View Engine to develop views with scaffolding templates and implemented controllers to transfer data between Views and Models. Designed Layout page as a template for each View and used Partial View to reuse the code. Implemented Forms based Authentication and role-based Authorization for web application security. Implemented business logic using MVC authorization filters, action filters and Exception filters. Implemented MVC Routing using convention based and attribute-based routing. Developed Web API as a service to provide data from database and consume using jQuery/AJAX. Used Bootstrap to help the responsiveness of webpage and design with Custom CSS style sheet on elements. Worked on JQuery Library for Client-side validations and Ajax calls. Using JQuery JSON for dynamic User Interface, retrieval and posting of data. Designed the Entity Framework using Database-First approach. Generated the Entity Data model (.EDMX) and associating the entity Objects with Entity Framework. Developed and deployed SSIS packages, configuration files and schedules job to run the packages. Developed reports using SSRS that could be used to send information to Clients, and managers. Implemented the Content Security Policy (CSP) to enforce strict security policies, controlling resource loading and execution to mitigate XSS vulnerabilities effectively. Hands on experience working with Stored Procedures, Functions, Queries, Triggers and Views in SQL Server. Used N-Unit to implement Unit, Integration and Regression Testing for performance issues. Used Team Foundation Server (TFS) for all the source code maintenance needs. Environments: .NET Framework 4.5, Visual Studio 2013, ASP.NET, C#, MVC, Web API, Entity Framework, LINQ, ADO.Net, SSIS, JavaScript, jQuery, AJAX, CSS, HTML, SQL Server 2012,NUnit, TFS. Client: National Road Fund Agency (NRFA) Hyderabad, INDIA Sep 2015 Feb 2016 Role: DotNet Developer Roles & Responsibilities: Involved in re-designing and developing the web applications based on the existing portals. Involved in Requirement Gathering, Analysis, Design & development of various modules and various applications. Implemented Design with enforced to use UML. Involved in architecture design, high-level and low-level design discussions. Create ASP.Net MVC application and added Controllers, Views and Models. Created Controllers to handle URLs to the Home page of the site and for browsing its main functionality. Created Views to customize the content displayed along with its style. Add Model classes to contain and manage data and domain logic. Used Entity Framework and LINQ to Entities to connect to the Database and perform database transactions. Used REST methodology using HTTP Handlers in developing Web API replication interface for setting up data feeds for content transportation in XML and JSON formats. Used Stimulated Reports in order to format data and integrate the content into reporting application. Creating Packages on SSIS by using Different Transformations like Derived Column, Lookup, Sort and OLEDB command to Load Data into Destination. Using Script Task, created a package to send auto emails. Deployed SSIS packages containing daily jobs which send the detailed data from production server to other servers on daily basis. Performed Unit Testing by using automated testing framework NUnit. Prepared daily and weekly status reports and collaborated with other team members. Environments: .NET Framework 4.5, Visual Studio 2013,ASP.NET, C#, MVC, Web API, Entity Framework, LINQ, ADO.Net, SSIS, JavaScript, jQuery, AJAX, CSS, XML, HTML, SQL Server 2012, TFS. Client: Malaysia Marines & Heavy Engineering Johor, MALAYSIA Jun 2013 Dec 2014 Role: DotNet Developer Roles & Responsibilities: Implemented the project according to the Software Development Life Cycle (SDLC) and involved in agile methodology, task completion and user stories. Followed MVC Architecture and implemented View Models, Razor Views and Partial Views in Web Forms. Designed and developed rich and enhanced web pages using ASP.NET MVC 4. Involved in maintenance of the existing project on VB.Net. Worked with Cascading Style Sheets (CSS) to present the View Pages. Created a Controller and Models for the business logic and data manipulations. Used Temp Data variables to transfer data between controllers and View Data variables to transfer data from controllers and view. Developed modules containing Forms based Authentication of a User Login, Forgot password, and Change password. Wrote business logic and created encryption/decryption methods. Implemented role-based Authorization for web application security. Implemented Validation by using Data Annotation for server side and jQuery for the client side. Created Service Oriented Architecture (SOA) for Web forms applications for linking the service consumers. Implemented WCF service consumed the web services in the application as well as to communicate with different layers. Developed WCF services to get the information from the database. Worked on ServiceContract, OperationContract, DataContract and Endpoints. Implemented XML based SOAP protocols extensively for data transfers. Integrated Application to MOL Pay (3rd party Online Payment). Developed the modules for sending money with MOL Pay through which user can send money. Involved in development of Pending Payment module which keeps track of all the pending payments. Created a Transaction Processing which used iText DLL library and generated the Receipt in PDF format. Used ADO.Net to store, manipulation and retrieve data from SQL Server database. Implemented database transactions through Dataset, Data Reader and Data Adapter in ADO.Net. Created SQL scripts in SQL Server and implemented complex logic in queries and stored procedures. Used Team Foundation Server (TFS) for version control and source code maintenance needs. Environments: .NET Framework 4.0, Visual Studio 2010,ASP.NET, C#, VB.Net ,MVC 4, WCF, SOA, SOAP, iText, MOL Payment Gateway, JavaScript, jQuery, AJAX, CSS, XML, HTML, SQL Server 2008,TFS. Client: Ken Blanchard Companies California, USA Jan 2011 Mar 2013 Role: Software Engineer Roles & Responsibilities: Involved in requirement gathering and developed new functionalities /enhancements, as per the client. Involved in writing business logic using N-Tier Architecture to separate the application & database. Written C# code, where in extensively implemented the Object-Oriented Programming (OOPs) concepts. Good command in the OOPS concepts such as Inheritance, Polymorphism, Abstraction and Interfaces. Used Cookies, Sessions and Application objects for State Management at client side and server side. Designed Web Pages using ASP.NET Server Controls and validated at client side using JavaScript. Used ASP.NET validation controls like required field validator, regular expression validator, compare validator and range validator. Created user interfaces using ASP.NET Web forms controls. Navigation menus were implemented in Master Pages using Tree and Menu Controls and Custom/User Controls in ASP. NET. Effectively used various state management techniques offered by ASP.NET. Utilized Session Objects and Cookies in ASP.NET to store the application state. Experience in creating Web Forms, User Controls, and Custom Controls using C# and ASP.NET. Developed Cascading style sheets CSS for consistent look and feel of the website. Used AJAX Toolkit controls like Script Manager, Update Panel and Modal Popup without reloading the complete page. Used Telerik Controls for rich data visualization while developing applications. Used ADO.NET such as Data Adapter, Data Reader and Data Set for consistent data access. Involved in Database diagram design and Tables design in SQL Server Created Tables, Views and Stored Procedures in the database SQL Server. Used Crystal reports from the database to generate reports based on viewer customization. Involved in Unit testing and effectively coordinated with other team members and testers. Used Tortoise SVN for file repository and version control for source code maintenance. Environments:.NET Framework 3.5, Visual Studio 2010,ASP.NET, C#, JavaScript, AJAX, CSS, HTML, Telerik Controls, SQL Server 2008, Crystal Reports, Tortoise SVN. EDUCATION DETAILS Amina Institute of Technology (Affiliated to JNTU University) June 2005 - May 2009 Telangana, India. Computer Science Engineering (Bachelor's Degree) 2024 Sampath Bandari Keywords: csharp continuous integration continuous deployment user interface business intelligence database information technology microsoft Arizona