.Net Developer Sql Server

Pravalika Pasham

Full Stack .Net Developer

LinkedIn: https://www.linkedin.com/in/pravalika1

Phone: +1-516-***-**** Email: **********.*******@*****.***

PROFESSIONAL SUMMARY:

Innovative Professional with 10+ years of progressive software engineering experience.

Exceptional background in programming, design and implementation.

Experienced in all phases of software design, development, and testing of business applications using Visual Studio.NET, C#, VB.NET, ASP.NET MVC, ASP.NET WEB API, .Net Core, HTML, Angular. JS, JAVA Script, CSS, and SQL Server.

Extensive knowledge on Agile methodologies as software development approach throughout my career for project management services.

Experience in working with IIS, creating and configuring the virtual directions map them to physical folders.

Works on SQL server; Wrote complex SQL queries, Stored Procedures, Functions, Views and Triggers.

Flexible and open-minded, with the ability to quickly adapt to changing needs, excellent troubleshooting Techniques.

Proficient knowledge in Cloud services like Google Cloud and Amazon AWS Services.

Works well with clients and can quickly learn domain knowledge and deliver solutions that fit their needs.

Good working knowledge on Bootstrap, jQuery and involved in automation scripting using Coded UI, C#, MTM.

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

Experience with Object Oriented Programming such as collections API, threads, Multithreading, Data Structures, Algorithms, and JDBC.

Developed MVC web user interfaces, complete with validation and verification using Data Annotations.

Good experience with ServiceNow tool in handling Service Requests, Cases and Incidents with

actively tracking and updating work notes.

Good experience in developing Configured and Consumed Restful Web Services using Windows

Communication foundation (WCF).

Technical expertise in Microsoft Technologies, such as. NET Framework (2.0-4.8), ASP.NET Web Forms, ASP.NET MVC 4.0/3.0, C#, VB.NET, Web Services, RESTful Services, Web API, WCF, WPF, Entity Framework, Silverlight 4.0/3.0, LINQ, IIS 8.0/7.0/6.0, SOAP, XML, DOM, XSL, XSLT, .NET REMOTING, HTML 5, Java Script, jQuery, AngularJS, NodeJS, CSS3, HTML5, VB Script, Visual Studio.Net 2005-2022, AJAX, ADO.NET, XML.

Experience in reports development using SQL Server Reporting Service (SSRS) and experience in developing integration packages using SQL Server Integration Service (SSIS).

Experience with SQL Server, Oracle 8i/9i and MS Access Database development, Ajax controls.

Proficient in T-SQL Queries, Views, Joins, Functions, SQL Stored Procedures, Database Triggers and Cursors and PL/SQL.

Performed a wide variety of programming assignments of newly developed software applications, enhancements to existing applications, and other revisions to the product.

DevelopedtheapplicationwithAngular8withMVCframeworkandcheckwhiledevelopingwhethertheservicesareready, if ready consume the services by configuring the endpoint URL’S and writing service calls, and integrate the application with services, which are made on REST

Created Typescript reusable components and services to consume REST API's using Component based architectureprovidedbyAngular8.WorkedonresolvingUserInterfaceissuesusingvariousfront-endtechnologiessuchasHTML, CSS, Bootstrap, AJAX.

WorkedwithAngular8frameworktorunthebootstrapmethodagainstTypescriptfileswhicharerelatedtoapplicationmodule.

EDUCATION DETAILS:

Bachelor of Information Technology SK University, Anantapur, India.

TECHNICAL SKILLS:

Languages

C#.NET, VB.NET, C, Visual C++, Visual Basic 6.0, PL/SQL.

Web Technologies

ASP.Net, JavaScript, WPF, WCF, HTML, XML, XSL, jQuery and IIS. Site Core.

Business & Portal Technologies

WSS 3.0, SharePoint Server 2007, MS Office 2007.

Databases

MS-SQL Server 7.0/2000/2005/2008, Oracle 10g, PL/SQL, MS Access, MySQL.

Middle Ware

COM, DCOM, ActiveX, Remoting.

Internet Technologies

VB Script, JavaScript, HTML, DHTML, Front Page, VB InterDev, CSS, and XML, XSL, XHTML, Microsoft AJAX and XSD.

IDE

Visual Studio.Net, Visual Studio 6.0, Visual InterDev 6.

Reporting Tools

Crystal Reports 9.0/11.0, SQL Reporting services 2005(SSRS), Ad Hoc Reporting Model, Dundas Chart.

Version Control

MS Visual Source Safe 6.0, Team Foundation Server.

Networking Protocols

SOAP, HTTP and TCP/IP.

Design Tools

VisualStudio.Net, Microsoft Visio.

Operating Systems

Windows 98/2000/XP/7/2003 Server.

PROFESSIONAL EXPERIENCE:

Client: Bank Of America, Charlotte, NC Jan 2023 to till now

Role: Full stack .NET Developer

Responsibilities:

Participated in daily SCRUM with Product owner, Project manager and Team Lead to discuss the progress.

Used agile methodology for the project which involved daily scrums meeting, defects discussion and Sprint Planning.

Active participant in development efforts, design and implementing platform architecture, and managing other engineering team members.

Experience on application support Incident/Investigation of issue, Bug Investigation, Root cause analysis.

Prepare the documentation of Incident/Investigation of issue and close as per Service Level Agreement (SLA).

Work in Test Driven Development environment, leveraging QA automation test suite to provide unit tests and integration tests for all new functionality

Creating Technical and Low Approach document, High level document -level document.

Designed responsive master pages and page layouts using HTML5, ASP.NET, CSS3 and JavaScript for SharePoint 2013 environment using SharePoint Designer.

Used Windows-UI (XAML, HTML) to enterprise, modernize & mobilize WinForms applications.

Developed HTML prototype of the web pages and WinForms using CSS, per client specifications.

Involved in designing and developing different modules using C#.NET, ASP.NET. Type script.

Involved with the client team to design and develop the application according to client requirement using ASP.NET 4.5, Web API, and SQL Server 2014 with the business logic implemented using C#.

Used ASP.NET Validation controls for client-side validation of Server Controls.

Have been involved in project migration from ASP .Net to MCV 5

Worked on MVC test Project to create automated test for simple test cases and for input validation.

Involved in UI Designing, Development and Testing of Web Forms using ASP.NET, Vb.NET,

XML/XSD ADO.NET and .NET Framework.

Built front-end SPA using HTML5, Angular and Bootstrap and backend server using ASP.NET Web API.

Implemented Microservices to integrate with angular front-end and Back-end

Developed enterprise applications based on Angular, Typescript, Microservices

Working in a microservice architecture and various authentication implementations such as SAML, JWT, and OAuth

Worked on Angular Reactive forms to implement complex forms and performed the validations using Form Builder both in Angular.

Content management with SharePoint, ERP tool for MS CRM

Use Azure Kubernetes Service (AKS) to simplify the deployment and management of microservices.

Implemented images stored into the Azure BLOB.

Using Azure CI/CD for deployment and Integration.

Implemented Automation test using Selenium, Core Java

Environment: Azure Cloud, ASP.NET, ASP.NET Core 2.2/3.0/3.1/3.3, ASP.NET Web API, VB.NET, C#.NET, Entity Framework, Visual Studio 2017/19, Jasmine, Angular9, Typescript, jQuery, JSON, XML, XSL, SQL Server 2016, SSRS, SSIS, Telerik Fiddler, Post Man, SOAP UI, SharePoint, WCF, Web Services, HTML, CSS, Ag Studio

Client: State of Texas, Austin, TX Feb 2020 to Jan 2023

Role: Full stack .NET Developer

Responsibilities:

Participated in daily SCRUM with Product owner, Project manager and Team Lead to discuss the progress.

Used agile methodology for the project which involved daily scrums meeting, defects discussion and Sprint Planning.

Active participant in development efforts, design and implementing platform architecture, and managing other engineering team members.

Work in Test Driven Development environment, leveraging QA automation test suite to provide unit tests and integration tests for all new functionalities.

Creating Technical and Low Approach document, High level document -level document.

Contributed to company-wide resource planning, hiring, performance reviews, client-facing business development.

Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.

Using front end tech with Jasmine, Angular Material, Angular CLI, HTML, CSS, jQuery, JavaScript, CSS and Google Maps, DECK.GL, Heat Maps.

Built front-end SPA using HTML5, Angular and Bootstrap and backend server using ASP.NET Web API.

Implemented Microservices to integrate with angular front-end and Back-end

Developed enterprise applications based on Angular, Typescript, Microservices

Working in a microservice architecture and various authentication implementations such as SAML, JWT, and OAuth

Worked on Angular Reactive forms to implement complex forms and performed the validations using Form Builder both in Angular.

Designed responsive master pages and page layouts using HTML5, ASP.NET, CSS3 and JavaScript for SharePoint 2013 environment using SharePoint Designer.

Used Windows-UI (XAML, HTML) to enterprise, modernize & mobilize WinForms applications.

Developed HTML prototype of the web pages and WinForms using CSS, per client specifications.

Involved in designing and developing different modules using C#.NET, ASP.NET. Type script.

Involved with the client team to design and develop the application according to client requirement using ASP.NET 4.5, Web API, and SQL Server 2014 with the business logic implemented using C#.

Used ASP.NET Validation controls for client-side validation of Server Controls.

Have been involved in project migration from ASP .Net to MCV 5

Worked on MVC test Project to create automated test for simple test cases and for input validation.

Involved in UI Designing, Development and Testing of Web Forms using ASP.NET, Vb.NET,

XML/XSD ADO.NET and .NET Framework.

Performed unit testing on every new version before sending it for User Acceptance Test UAT.

Performed Unit Testing with the testing tool NUnit and involved in Unit test case, code review checklist preparation and validation.

Content management with SharePoint, ERP tool for MS CRM

Use Azure Kubernetes Service (AKS) to simplify the deployment and management of microservices.

Implemented images stored into the Azure BLOB.

Using Azure CI/CD for deployment and Integration.

Implemented Automation test using Selenium, Core Java.

Environment: Azure Cloud, ASP.NET, ASP.NET Core 2.2/3.0/3.1/3.3, ASP.NET Web API, VB.NET, C#.NET, Entity Framework, Visual Studio 2017/19, Jasmine, Angular9, Typescript, jQuery, JSON, XML, XSL, SQL Server 2016, SSRS, SSIS, Telerik Fiddler, Post Man, SOAP UI, SharePoint, WCF, Web Services, HTML, CSS, Ag Studio

Client: AT&T, Jersey City, New Jersey May 2018 to Jan 2020

Role: Full stack .NET Developer

Responsibilities:

Analysis of the legacy code that was written in ASP.Net, C#.Net.

Complete rewrite of the existing application to single page application using Angular, Bootstrap.

Created Angular custom directives to follow the reusable component development approach.

Created separate Angular Modules for each section of menu and injected in the common application modules to achieve the modularity of the code.

Worked on CI/CD pipelines with Jenkins on the Kubernetes environment, used Kubernetes and Docker to create, test and deploy a CI/CD system runtime environment, used build tools like IntelliJ.

Worked on DevOps platform, created build/releases, unit testing continuous integration/continuous delivery using Azure DevOps.

Worked in Agile Scrum development methodology to ensure delivery of high-quality work with monthly iteration, also involved in Sprint planning and retrospectives.

Worked as a Developer in the team for designing and developing the application using Microsoft technologies C#, ASP.NET 4.5, SQL Server 2017.

Used Model View Controller (MVC) design pattern to develop a complex web application, ASP.NET Web API with C# as code behind.

Used NPM for installing required node modules and other published Angular NPM modules.

Angular 2.0 is a Component Driven Architecture.

Working knowledge on Azure cloud IaaS and PaaS Services.

Experience in implementing Azure DevOps including creating builds, workflows, notifications, and security tools integration.

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

Updated the application with new features of Angular 4.

Construction of ASP.NET Web API 2 RESTful Services using GET, PUT, POST, DELETE verbs to consume it from MVC.

Worked on developing JMS modules with JMS (java messaging service) for asynchronous communication.

Skilled in writing complex queries and aggregation pipelines to retrieve and analyze data from NoSQL MongoDB collections.

Used ASP.NET Web API framework to support the use of Dependency Injection to inject objects into a class instead of relying on the class to create the object itself.

Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

Building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Developed Json Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the Cosmos Activity.

Implemented OLAP multi-dimensional cube functionality using Azure Terraform.

Complete end-to-end design of Apache Knife to get connected from ETL Server to HDFS and store the final output in HDFS using processors.

Ingest data from upstream systems using NiFi into Hive. Create base line tables for trending in HBase using Spark batch process in Scala.

Environment: C#, .NET Framework 4.5, ASP.NET, XML, Web Services, .Net Core, JMS, Angular, Node, Java Script, CSS, ADO.NET, IIS 6.0, HTML, MS Excel, SQL Server Visual Studio.

Client: Molina Health Care, Long Beach, CA. May 2016 to May 2018

Role: Full stack .NET Developer

Responsibilities:

Developed application UI pages using AngularJS, HTML5, CSS, Bootstrap, JavaScript, jQuery, AJAX and JSON.

Created a custom, single-page, responsive web application using Angular JS and jQuery to replace a legacy line-of-business web application.

Used JSON and Angular JS to effectively improve the performance with less coding effort and achieved many client-side validations to block unauthorized or malicious content in application forms.

Developed UI Router to create different hierarchy structure in single page application.

Implemented language Integration to application using Angular JS.

Worked on Web API for interacting the Angular App to the business logic layer of MVC.

Designed Graphical User Interface using ASP.NET MVC and the business logic was coded in C# (MVC controllers).

Worked on .NET web forms and .NET web services using Visual Studio.Net 2013, .NET Framework 4.5.1.

Developed complete Data Access Layer (DAL) Component using C#.

Developed rich user interfaces using Silverlight 5.

Developed ASP.Net pages using ASP.NET, web form controls, Custom user Controls, HTML server controls in C#.

Created event driven Web Forms using ASP.NET and implemented form validation using Validation controls using both Custom validation and Angular JS was written for Client-side validations and used the new validation controls in VS 2013.

Developed XML Web Services and WCF services common for various applications using .NET Framework.

Used Visual Studio.NET 2013 IDE to design the forms, develop and debug the application.

Extensively used ADO.NET, XML in Order to get the high-level performance for the web controls.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL-SQL in Development and Production environment for SQL 2012.

Worked on creating the database and developed multiple T-Sql Procedures, Functions and Sql Queries that can handle the business rules.

Used Entity framework to connect the web forms to data sources such as MS SQL Server for manipulating data in database.

Experience working in SQL Server Integration Services (SSIS) packages to extract, transform and load (ETL) data from different databases.

Proficient in creating SQL Server Reports, handling sub reports, writing stored procedures and queries for generating drill down reports using SSRS.

Created reports using Crystal Reports for intranet applications.

Developed SQL queries, T-SQL procedures, Functions, triggers to handle the business rules data integrity and for various data transactions.

Team Foundation Server (TFS) was used to maintain the version and source control.

Environment: ASP.NET 3.0/3.5, Visual Studio .NET 2013, MS Expressions 2008 TS, .Net Framework3.0/ 3.5, MVC, Web Forms, AJAX, XML, XSLT, .NET Architecture Design patterns, Windows 2008, IIS 7.0, SSIS, Crystal Reports, HTML5, CSS, Bootstrap, Silverlight 5.0, Angular JS, Java Script, jQuery, SQL Server 2012, T-SQL/PLSQL, UML, MS TFS.

Client: Hudda Infotech Private Limited Hyderabad, India July 2014 to Feb 2015

Role: .NET Developer

Responsibilities:

Used Model View Controller (MVC) design pattern to develop a complex web application, ASP.NET Web API with C# as code behind.

Worked on developing JMS modules with JMS (java messaging service) for asynchronous communication.

Used ASP.NET Web API framework to support the use of Dependency Injection to inject objects into a class instead of relying on the class to create the object itself.

Involved in Bug Fixing, Handling the Service request from the customer and addressing them in a timely manner.

Worked as developer in the team for design and development of application using Microsoft Visual studio with the ASP.Net 4.0, SQL Server 2012.

Implemented the forms authentication for the application. Used jQuery for client-side validations.

Developed the UI (user interface) using ASP.NET MVC 4.0, Knockout JS, HTML5, CSS 3, Bootstrap, Ajax.

Developed WCF services to support service-oriented architecture, configured WCF services in IIS.

Developed custom HTML Helpers and custom Action Filters for the application.

Used Enterprise Library 5.0 for error logging and database activities.

Involved in writing SQL statements, stored procedures, User Defined Functions, Complex Triggers. Actively worked on Performance Tuning in Application servers, Database Servers.

Implemented SSIS packages to update SQL data tables from oracle server.

Created and deployed SSIS packages to production, scheduled them to run on routine basis and monitor log for errors.

Proven ability to troubleshoot and optimize NoSQL MongoDB performance issues, including database schema design, query optimization, and indexing strategies.

Used Postman -Google Chrome extension for Web API service testing and debugging.

Implemented Dependency Injection using Unity framework for decoupling of each layer and easily enables unit testing capability.

Used LINQ to manipulate and fetch the data from database.

Used Chrome Developer Tools, to locate and edit CSS, JQuery & JavaScript within web project.

Worked on PHP5 and MYSQL, HTML5, Ajax, JavaScript, CSS3 and WordPress.

Designed and developed Intranet web application in MVC 5.0 framework with AngularJS.

Environment: ASP.Net MVC, JavaScript, NET Framework 4.5, MVC 4.0, MS Visual Studio 2008, JSON, ASP.Net, C#, JavaScript, jQuery, HTML5, CSS3, Bootstrap, Entity Framework, SSIS, AJAX, Ajax Control Toolkit, XML, Restful, SQL Server 2008, ADO.Net, JIRA.

Contact this candidate