.Net Core Sql Server

Manjusha Sanagala

Ph.: 516-***-****

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

LinkedIn: https://www.linkedin.com/in/manjusha-sanagala-780a9015a/.

Professional Summary:

8+ years of IT experience in Analysis, Design, Development, Implementation, and Testing of Web-Based, Client-Server and N-tier Architectures.

Experience encompassing a wide range of Microsoft C#.Net, Microsoft ASP .NET, Angular, React.js, Webmail, Microsoft .NET MVC, Web API, Postman, Developing Microsoft Azure and Web Services, Microsoft SQL Server, Microsoft .Net Core, Core Azure with DevOps and Cloud technologies (AWS, MS Azure).

Experience in all phases of Software Development Life Cycle (SDLC) – Agile/ Scrum such as planning, analysis, design, implementation, testing, and maintenance.

Hands-on experience in design using Object Oriented Programming Principles like Inheritance, Polymorphism, and Design patterns like Abstract factory, and Singleton.

Extensive experience working with ASP.NET MVC 4 and ASP.NET MVC 5, Web API, RESTful APIs, Angular, Bootstrap, Entity Framework, LINQ, SQL Server Architecture, User Interface Design, client-side development, middle tier, and back-end development.

Developed web-based applications using ASP.Net, C#.Net, .net core 3.1, Entity framework Core, ADO.Net, Web API’s, IIS, Java Script, LINQ, HTML, XML

Experience in working with Web Forms, User Controls, and Web Controls using HTML5, DHTML, CSS3, XML, JavaScript, jQuery, JSON, and Visual Studio

Experience in creating interactive web applications and single page applications (SPA) using AngularJS, Angular 2/4/6/8/12, TypeScript, Angular Material, and Angular CLI.

Experience deploying the application to Microsoft Azure Cloud as a part of cloud deployments to Private and Public cloud environments.

Experience in Azure Cloud, Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure Analytical services, Azure Cosmos NO SQL DB, and Data bricks

Work experience on Windows Azure, Azure Active Directory, and SQL Azure, creating resource groups, and subscriptions, build definitions, and release definitions.

Work experience with Web User Controls, Grid View Controls, Form Validation Controls, and Custom Controls.

Experience in Azure for system Deploying, Operating and Maintaining compute, network, and storage in the Microsoft Azure environment using Microsoft Technologies

Orchestrated data integration pipelines in ADF using various Activities like Get Metadata, Lookup, For Each, Wait, Execute Pipeline, Set Variable, Filter, until, etc.

Experience in Configuring Virtual machines used for SharePoint Sites, SQL Server, and Azure directory in Microsoft Azure.

Expertise in Microsoft Azure Cloud Services (PaaS & IaaS), Application Insights, Document DB, Azure Monitoring, Key Vault, Visual Studio Online (VSO), and SQL Azure.

Expertise in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object, and Data Adapter Object.

Experience in Azure Cloud, Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure Analytical services, Azure Cosmos NO SQL DB, and Data bricks

Extensive working experience on Apache Kafka, Confluent Kafka, Kafka Streaming using KStream, KTable, K Grouped Stream, KSQL

Hands-on experience in using Custom Controls, Master Pages, Themes, and Validation Controls.

Experience in using ASP.NET AJAX framework for quickly creating efficient and interactive Web applications that work across all popular browsers.

Experience in N-Tier Architectures such as MVC (Model View Controller), and MVVM (Model View, View Model).

Participate in the development of roadmaps and participate in the standards process for Identity and Access Management (IAM) solutions

Extensive Experience with ORM technologies like Entity Framework Database First, Code First, and performance tuning in EF.

Experience in Data Modeling, Designing, and Creating Tables, Views, Stored Procedures, and Triggers against MS SQL Server, and T-SQL relational databases.

Experience in using build/deploy tools such as Jenkins, Docker, and OpenShift for Continuous Integration & Deployment for Microservices.

Experienced in database designing with SQL Server, writing database queries using joins, indices, views, stored procedures, triggers, normalization, functions, T-SQL, PL/SQL, and query optimization techniques.

Very good working knowledge of Control Center and Kafka monitoring

Experience in performing Unit Testing (using N-Unit), Integration Testing, and Performance Testing.

Excellent analytical and interpersonal skills. Quick learner and good performer both in team and independent job environments.

Technical Skills:

Methodologies

Agile, Scrum, Waterfall.

Languages

.NET, PL/ SQL.

.NET Technologies

C#, ASP.NET, MVC, ASP.NET Core, ADO.NET, .NET Core, WCF, WPF, ASP.NET MVC 5, Razor View Engine, VB.NET, SOAP, SOA, LINQ, Web Services, WEB API, ASP.Net Web API Core

Web Technologies

HTML5, CSS3, XML, XSLT, XSD Bootstrap, JavaScript, jQuery, AJAX, Vue.JS, React JS, Redux, Flux, Angular 2/4/6/8/10/12, Typescript, Kafka Angular Material, Angular CLI, SharePoint.

Databases

SQL Server, Oracle, MS Access

ORM

Entity Framework Core, Entity Framework Code First/ Data First, LINQ to SQL, NHibernate

Version Control

VSS, Sub Version, TFS, SVN, Azure DevOps

IDE & Other

Visual Studio, SQL Server Management Studio, Expression Blend, IIS, Fiddler, MS Office.

N-Tier Architectures

MVC (Model View Controller), MVVM (Model View, View Model)

Design Patterns

Repository, Dependency Injection, Singleton, Factory.

Cloud Technologies

Amazon Web Services (AWS), MS Azure

AWS

AWS, EC2, R53, S3, RDS, Dynamo DB, SQS, IAM, EMR, EBS, ELB, Cloud Watch

MS Azure

MS Azure, Service Bus, Azure SQL, Redis, Message Queue, Azure Portal, Azure Virtual Networks (VNETs), Storage Containers, Load balancers, Active Directory

Testing

xUnit, NUnit, MS Unit, Swagger, Postman

Professional Experience:

Client: Quotient- Mountain View, CA April 2022 – Present

Role: Full Stack .NET Developer

Responsibilities:

Followed Agile Scrum methodologies & followed Test Driven Design patterns.

Designing, developing, and modifying software applications utilizing ASP.NET Core Web API.

Developed a complete internal front-end application using Angular 12, Ajax controls, CSS Bootstrap, and HTML5 communicating with the backend APIs.

Used Azure components like Service Bus to implement a communication system between mutually interacting software applications, Message Queues, and Redis Cache to support data structures such as strings, hashes, lists, sets, and sorted sets with range queries.

Utilized MVVM Light to streamline MVVM development and provide additional features such as dependency injection and navigation.

Worked on Angular 12 concepts like building the components, Data binding, Property Binding, Event Binding, and Two-way Data binding (with the help of Forms Module).

Developed views using XAML markup to define the layout and appearance of the user interface.

Used Spring config server for centralized configuration and Splunk for centralized logging. Used Concourse and Jenkins for Microservices deployment

Developed some dynamic dictionaries using C#.net, and .Net Core 3.1 for easy lookups of item dimensions values which results in faster performance.

Created layouts and arranged UI elements using WPF layout containers such as Grid, StackPanel, and DockPanel.

Identified weaknesses in QA Processes and web testing and executed Selenium Automation to suggest and implement improvements

Configured Selenium Web Driver, and TestNG, and created Selenium automation scripts in Java using TestNG before agile release.

Analyzed and performed Azure data integration using Talend open integration suite.

Written Unit Test cases for Web APIs and Azure Functions

Designed and developed web forms using ASP.NET 2.0 and C# .NET

Developed web applications using MongoDB, Express, React / Redux, Node JS, and GraphQL.

Migrate the ETL logic, which was currently running in SSIS and MS Access, by Azure Pipeline in Azure data factory without any change in business logic

Installed and administered various tools like Jenkins, BitBucket, Chef, and Jfrog Artifactory and executed maintenance tasks such as creating users and groups.

Assisted in designing & developing data lake and ETL using Python and Hadoop ecosystem

Supporting and enhancing the complete confluent Kafka cluster on Kubernetes

Developed ASP.NET Core Web API based on departmental requirements and specifications.

Implement ad-hoc analysis solutions using Azure Data Lake Analytics/Store, HDInsight/Databricks

Implemented Encrypting password feature using AES Encryption method adding Random string and removing from Decryption using C# cryptography.

Deployed Spring Boot-based microservices in Docker and Amazon EC2 container using Jenkins

Written Kafka streams application using Kafka streams library and KSQL queries.

Developed real-time tracking of class schedules using NodeJS (ExpressJS framework) involved in developing thread-safe blocks for multi-thread access and distributed transaction management.

Closely worked with Applications using React.JS and Node.js libraries NPM, gulp directories to generate desired view and flux to root the URLs properly.

Responsible for performance optimization and normalization of the database, tuning and optimizing queries and indexes, Job, Scheduling, batch, alert and E-mail notification setting, and monitoring SQL Server log files.

Implemented Client-side validation using Angular Custom Form Validation with ng-show and ng-hide.

Created a database known as SQL AZURE database, which integrates with Active Directory.

Designed and created models, components, modules, and services to apply client-side logic and dependency injection using Angular 12.

Expert in Azure Integration Runtime (IR) Configurations and Data Integration Units DIUs

Developing ASP.Net Core Web API controllers that involve the implementation of service layer components.

Worked on Single Page Application (SPA) using Angular with Typescripts.

Involved in the development of applications on Azure server by creating packages through Visual Studio, and Azure Portal.

Implemented Angular Controllers to maintain each view data. Implemented Angular Service calls using Angular Factory.

Developed high-performant data ingestion pipelines from multiple sources using Azure Data Factory and Azure Databricks.

Created and managed Azure Virtual Networks (VNETs), Storage Containers and Load balancers.

Developed the profile page, sign-up page, and player matchup pages using computer programming languages Asp.Net, and C# with SQL Server.

Implemented a CI/CD pipeline involving BitBucket, Jenkins, Chef, Jfrog Artifactory, Docker, and Selenium to complete the automation from commit to Deployment.

Created GraphQL schema and queries to interact with the Mongo DB database.

Involved in executing all Selenium test scripts on the different browsers and checked for compatibility.

Used Angular Material for all the elements to achieve the material-themed look and feel of the application.

Created Service Layer using C#. Used Generics, Lambda Expressions, Extension Methods, LINQ to SQL, LINQ to Objects & Implemented LINQ for querying, sorting, and filtering complex objects.

Designing, implementing, and supporting fully automated Continuous Integration and Continuous Delivery processes using Azure DevOps

Working with CICD teams to create Build and Deployment Pipelines in GitHub and TFS

Used JSON objects for better data transfer from Azure Table Storage to the on-premise environment. Developed web services using ASP.Net and hosted them in IIS.

Developed Azure function apps as API services to communicate DB2

Assigning the task to the team, working with and guiding the team for any technical, process, or functional help. Implementing the application logic, writing Unit tests using NUnit, MS Test, etc. with Mock objects to ensure higher code coverage.

Implemented Unit Testing, Integration Testing, and System Testing using xUnit.

Environment: Agile, Scrum, Angular 12, Angular Material, Angular CLI, TypeScript, HTML5, CSS3, AJAX, Bootstrap, jQuery, ASP.Net Web API Core, Visual Studio, MS Azure, Service Bus, Azure SQL, microservices Azure Portal, VNETs, Azure Databases, Storage Containers, Load balancers, AD, Entity Framework, Jenkins, Docker, SQS, SNS, Git, TFS, IIS, SQL Server, T-SQL, xUnit.

Client: Calpine - Houston, Texas Feb 2019 – Mar 2022

Role: Full Stack .NET Developer

Responsibilities:

Developed the front-end of the web application using React.JS, HTML5, CSS3, AJAX, Bootstrap and jQuery.

Developed ASP.NET Core Web API based on departmental requirements and specifications.

Designed components using JSX and reducers and actions using React.js, Flux, and Redux using the latest version of JavaScript.

Worked on React JS Forms, Events, Keys, Router, components, Animations, and Flux concepts to develop the application.

Design, develop, and build applications using React consuming the payloads received from the ASP. NET Web API Core.

Designed and implemented user interfaces using XAML markup and WPF controls.

Implemented getter and setter methods to provide controlled access to encapsulated data, enforcing data integrity and security.

Used React JS for templating for faster compilation and developing reusable components.

Implemented the Drag and Drop functionality using React-Draggable.

Working with Azure BLOB and Data Lake storage for loading data into Azure SQL Synapse (DW).

Experience working with Confluent Kafka event streaming platform version 4. x, 5. x

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

Working on C#, Asp.Net Core 3.1, Web API, Entity Framework, LINQ, SQL server, Single Page Application framework (SPA), Angular 6, Typescript, CSS, VSTS, GIT, Bootstrap, JavaScript, JSON, HTML, Db Up, Postman, NGRX store, RXJS, Redux, Augury and Bootstrap.

Implemented an express-graphql library to mount a GraphQL API server on the user-configured HTTP endpoint.

Developed Azure function apps as API services to communicate DB

Used Azure Functions triggered by Power Automate to perform real-time data updates and notifications.

Created Azure Data Factory Pipeline to load data from on-premises SQL Server to Azure Data Lake store.

Responsible to Interact with the cross-functional teams to understand the business requirements and document into Visual Studio.

Responsible for developing the Data Access Layer (Model) using ADO.NET Entity Framework Model, LINQ to Entities, UNIX, Linux, and C#.

Design, develop, and build applications using React and Redux consuming the payloads received from the ASP.NET Web API Core.

Used Sauce labs to execute Selenium automation suites on different platforms and performed browser Combinations in parallel

Extensive programming experience in ASP.NET 2.0/3.0/3.5, ADO.NET, C#, VB.NET.

Job, Scheduling, batch, alert, and E-mail notification setting.

Involved in coding with ASP.NET and JavaScript to add functionalities and effects like Accordion, Infinite Scroll bar, Slider bar, Draggle/ Droppable, Resizable, and Progress bar.

Used React-Router to turn application into Single Page Application (SPA)

Implemented stable React components and stand-alone functions to be added to any future pages.

Used Entity Framework and LINQ to access the two databases so the user could create, edit, display, and delete data from the application’s UI.

Responsible for developing a front-end application using React JS and FLUX architecture for internal teams' productivity use.

Worked with Version control tools such as GIT.

Used Microsoft Team Foundation Server (TFS) for integration and source control.

Involved in deploying the application on the IIS Server.

Implemented react JS code to handle cross-browser compatibility issues in Mozilla, IE, Safari, and FF.

Used NUnit Testing Framework and MS Unit Test for Unit Test cases.

Environment: Agile, Scrum, React.JS, HTML5, CSS3, AJAX, Bootstrap, jQuery, EC2, R53, S3, RDS, Dynamo DB, SQS, IAM, EMR, Flux, Redux, ASP.Net Web API Core, microservices Lambda, Code Commit, RDS, Visual Studio, Entity Framework, Jenkins, Docker, SQS, SNS, ADO.NET, Git, TFS, IIS, NUnit.

Client: State of CA, SFO, CA Oct 2016 – Dec 2018

Role: Full Stack .NET Developer

Responsibilities:

Worked in an agile team of .NET developers for a fast-paced software development firm.

Designed and developed various Web forms using HTML5, CSS3, Bootstrap and JavaScript, and Angular 6.

Participated in daily stand-up meetings to give project progress updates to the business team and the owner.

Involved in the analysis, design, and development of the application.

Created internal Power Apps for financial advisors to manage client portfolios and track investments.

Developed single-page applications (SPAs) using Angular 6 and Implementation of enterprise applications with Angular 6.

Configure Azure cloud service for end-point deployment. Created Azure Web Application projects, updated and deployed ASP.NET Web apps, and Web Jobs using Visual Studio, GitHub, and Azure Resource Manager.

Applied Angular 6 for designing the front end and for getting data from Web services and WEB API which acts as a middle-tier and data access using Entity Framework.

Developed ASP.NET Core Web API based on departmental requirements and specifications.

Worked with advanced concepts of ASP.NET Core MVC such as Models Providers and Filters used for developing backend technology.

Designed the user interface using Angular 6 with the help of Web API.

Worked on creating Azure Blob for storing unstructured data in the cloud as blobs.

Developed localization API s which stores the translated data in Azure and SQL tables Deploy Confidential services on Azure cloud.

Worked on designing the architecture of API and created a RESTful Web API service using ASP.NET Web API to generate data for the EMS which was then consumed in the front-end by Angular 6.

Integrated disparate technologies with Microsoft Power Shell - Entity Framework, Mongo DB, ASP.NET Membership, SQLite, etc.

Hands-on technology experience in designing and developing software applications with Microsoft .NET Framework using C#, ASP.NET, and ADO.Net.

Worked on migrating ASP.NET application to ASP.NET Core application.

Used Team Foundation Server (TFS) and GIT for check-in and checkout of code.

Used Angular 6, and Bootstrap for rich user interface and faster performance.

Developed a security module that deals with validating users, changing passwords, and restricting access to users for specific features like enrolment and search for customers based on their roles and rights using ASP.NET Form-based, and Role-based authentication.

Created and maintained database objects like complex Stored Procedures, Cursors, Tables, Views, and User Defined Functions, in SQL Server for inserting / Updating / Deleting the data into the relational tables.

Designing, implementing, and supporting fully automated Continuous Integration and Continuous Delivery processes using Azure DevOps.

Involved in Unit testing (NUnit) and Integration testing. Handling production support and responsible for web application security.

Environment: Agile Scrum, HTML5, CSS3, .Net, ASP.NET Core Web API, MS Azure, Azure Blob, Azure Resource Manager, Azure DevOps, Visual Studio, .Net Framework, ASP. NET, ADO.NET, T-SQL, C#.Net, Angular 6, TypeScript, Angular Material, Microsoft IIS, Entity Framework, MS Active Directory, Dependency Injection, TFS, Git, Kendo UI, WCF, WPF, Bootstrap, SQL Server, NUnit.

Client: Lululemon- Dallas, TX August 2015- August 2016

Role: .NET Developer

Responsibilities:

Involved in developing the application using Agile Methodologies.

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

Developed the functionalities using Microsoft ASP.Net MVC-Model-View-Controller Architecture and rich user responsive technics using HTML5, Angular, Bootstrap, jQuery, CSS.

Used Bootstrap to achieve the responsiveness of the application.

Implementation of Single page application (SPA) with Angular 4.

Worked on Angular controllers, directives, components, factory and service resources, routings, and events.

Created Web Forms using C#.Net and ASP.NET with Visual Studio.

Integrated Power Apps with backend systems using .NET APIs for real-time data access.

Used the Object Oriented Programming (OOP) techniques and created classes (in C#.NET) for database access.

Used Angular, and JavaScript to develop templates, controllers, and directives.

Designed Power Automate flows to automate order processing and shipment tracking.

Integrated AWS S3 for storing and retrieving product images, customer data, and other static assets, improving data accessibility and security.

Published Web services using C#.NET to interact with the other applications and exposed them using SOAP and HTTP.

Created tables and indexes and wrote Stored Procedures, Functions, and Triggers in SQL Server.

Migrated and managed relational databases using AWS RDS, ensuring high availability and automated backups for critical data.

Created Service Layer using C#. Used Generics, Lambda Expressions, Extension Methods, LINQ to SQL, LINQ to Objects, and implemented LINQ for querying, sorting, and filtering complex objects.

Developed Stored Procedures, Triggers, and Views in SQL Server for accessing the database.

Used Model View Controller (MVC) architectural Design Patterns for the development of the product and IIS Management.

Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering, and paging with Entity framework in MVC.

Developed controller and service methods using TDD methodology and developed unit and integration tests.

Implemented Unit Testing, Integration Testing, and System Testing using NUnit.

Environment: Agile, Scrum, MS Visio, UML, ASP.NET MVC, HTML5, Angular 4, Bootstrap, jQuery, CSS, C#.NET, ASP.NET, C#, Entity Framework, VNet, SOAP, AWS,C#.NET, Restful, Web API, SQL Server, LINQ, TDD, NUnit.

Role: Application Developer Oct 2014 - May 2015

Client: HSBC Bank, India

Responsibilities:

Used Agile Methodology to review the progress of the project in monthly sprints.

Weekly attended conference calls with clients for the project progress.

Implementation of Single page application (SPA) with Angular 2 and Bootstrap.

Worked on the front end to develop streamlined web applications using C#, and ASP.NET with the necessary CSS, and HTML5.

Designed the application as N-tier architecture with extensive use of Object-Oriented programming techniques.

Used Angular 2 to create better, faster, and more user-friendly web applications.

Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, and Data View for consistent access to MS SQL Server data sources.

Used C#.NET to develop code for business and repository layer.

Created a custom, single-page, responsive web application to replace a legacy line-of-business web application with Angular 2.

Created the Controllers and Controller Actions, Filters, and Routing using ASP.NET MVC.

Used ADO.NET framework to connect to databases.

Have used Service Oriented Architecture (SOA) to develop web services.

Wrote many complicated Stored Procedures, Triggers, User defined functions.

Created different kinds of Indexes on the tables to improve performance and fixed many bugs in the Queries and sub-queries.

Interacted with SQL Server Management Studio in fetching the required data using join queries.

Environment: Agile, Scrum, ASP.NET MVC, C#, ASP Web forms, ADO.NET, VS.NET, Bootstrap, ASP.NET MVC, Razor View Engine, T- SQL, NHibernate, SQL Server, SOAP, LINQ, jQuery, ORM, Angular 2, HTML5, CSS3, JavaScript, NUnit, TFS, Entity Framework, LINQ, NUnit.

Education: Bachelor of Technology in Information Technology.

Contact this candidate