Post Job Free

Resume

Sign in

Sql Server Asp.Net

Location:
Los Altos, CA
Posted:
September 18, 2023

Contact this candidate

Resume:

Name: Lavanya kumar

Sr .Net Full Stack Developer

Email Id: adzsge@r.postjobfree.com

---

Summary:

• Having 9+ years of experience in developing Web and Client/Server Applications based on Microsoft .NET Technologies and expertise in implementing N-Tier Architecture.

• Designing and developing web based and windows-based applications using ASP.Net, C#.Net, ADO.Net, Web Services, ASP, IIS, JavaScript, HTML, DHTML, CSS, XML and XSL, Net Core.

• Extensive experience in developing Front End with Angular.

• Good experience in developing Back End with Net Core, working with API to use information from the DB to Front End.

• Good experience on DevOps essential tools like Docker, Kubernetes, GIT, Jenkins,

• Experience in developing N - tier applications using ASP.NET, C#, VB .NET, Windows Forms, Visual Studio.NET (2005/2003), ADO.NET, XML, Web Services, Java Script and VB Script.

• In-depth understanding and experience in building server applications using C#, ASP.Net, ADO.Net, XML Web Services, HTTP modules and handlers based on .Net Framework 4.5/4.0/ 3.5 / 3.0 / 2.0.

• Developed GUI (Graphical User Interfaces) using C# Win Forms and ASP.Net Web Forms.

• Experience in Database Design, Database Management and Data Migration using SQL Server.

• Experience in working with Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF) and Windows Workflow Foundation (WWF) in .Net Framework 4.0/3.5/3.0 and Language Integrated Query (LINQ) in .Net Framework 3.5.

• Extensively developed applications in Win Forms, Web Forms, MVC, MVVM and Single Page Application Architectural patterns.

• Experienced in Version control systems (SVN management), feature and issue tracking

(JIRA), Linux terminal/command line & Debugging issues.

• Implemented client-side Interface using React JS. Build stable React components and stand-alone functions to be added to any future pages. Used React-Router to turn application into Single Page Application

• Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, Abstraction and Abstract factory.

• Developed and integrated SSRS reports into .Net Web application pages.

• Expertise in creating and scheduling complex SSIS packages for transferring data from multiple sources into SQL Server, Access and Excel by using SSIS and DTS of SQL Server.

• Worked with Reactive Form Angular.

• Documented Functional design documents such as Documents migration.

• Experience in Bootstrap 5/4/3.

• Worked with login JWT in Webmail.

• Developing PowerShell Script files to Automate office 365.

• Experience in SQL Server database design, creating tables, views, stored procedures and functions.

• Knowledge Object Oriented Language Principles (C#, VB).

• Experience with SQL Azure databases.

• Expertise in generating reports using SQL Server Reporting Services (SSRS),

• Worked with Gitkraken, Git Board to work with Repos.

• Worked in the Analysis Design, Development and Implementation of cloud-based architecture in migrating existing systems on to cloud using Azure.

• Documented Functional design documents such as Documents migration.

• Good hands on knowledge of OOPS (Object Oriented Programming Structure) and Agile / scrum methodology.

• Experience in developing reports using SQL Server Reporting Services (SSRS).

• Experience using dev. express controls.

• Experience in SQL Server Integration Services (SSIS).

• Experience in working on Visual Studio 2019/2017/2015/2012/2010.

• Have used J-Query/JSON for retrieving data.

• Used Business Intelligence Development Studio to develop and deploy SQL Server Analysis Services (SSAS) projects.

• Install, Manage and create SharePoint Server farms.

• Analysed and designed new WPF application using MVVM and Repository pattern, from design to completion.

• Experience in designing and developing Databases in SQL Server 2000/2005/2008/2012/2014/ 2017.

• Worked with SAP GUI.

• Extract information from SAP database to bulk in SQL.

• Experience using BAPI SAP.

• 3 Years of experience doing BI Reports using Qlikview and QlikSense.

• Effective team player with excellent problem solving abilities, a willing and quick learner with strong technical skills.

• Excellent communication & interpersonal skills with proven abilities in resolving complex software issues.

Technical Skills:

Project Experience:

Client: QuickTrip,Tulsa,Ok.(Remote)

Jan 2021 - Present

Role: Senior .Net Developer

Roles and Responsibilities:

• Involved in gathering the requirements, analysis, design & development of the project.

• Developed Agile/Scrum Software Development methodologies to enable efficient and effective high-quality software development.

• Graphical User Interface (GUI) was designed using ASP.Net and Net Core and the business logic was coded in C#, Vb.netManaged Kubernetes charts using Helm. Created reproducible builds of the Kubernetes applications, managed Kubernetes manifest files and Managed releases of Helm packages.

• Used Windows Communication Foundation (WCF) to connect the front end to the database. Operating Systems Windows Server 2019, Windows Server 2012, Windows Server 2008, Windows 10, Windows 7, Linux

Languages C#.Net (4.5+/4.0/3.5/3.0), T-SQL, JavaScript, PL/SQL, VB.NET, VBA, Dart.

Web Technologies ASP.NET 4.5+/4.0/3.5/3.0/2.0, ASP.NET MVC 5/4.0/3.0, jQuery. Asp.Net Core, ANGULAR, typescript.

Xml Technologies XAML, XML

UI Technologies Razor, Web form, jQuery, Win Forms, WPF. IDE Tools Visual Studio 2019/2012/2010/2008/2005, SQL Server Management Studio 2000/2005/2008/2012/2017, Visual Studio Code

.Net Frameworks .NET CORE, .Net Framework 4.5+/4.0/3.5/3.0/2.0, Flutter. Databases MS SQL SERVER 2019/2016/2012/2008/2005, SSIS Data Technologies Entity Framework, LINQ

Reporting Tool SQL Server Reporting Services (SSRS 2016, 2008/2005), Qlikview, QlikSense.

Modelling Tools UML, Class Diagrams

Version Control Tool Gitkraken

Middleware WCF, ADO.NET 4.0/3.5/3.0/2.0, Web Services, Enterprise Library 4.0/3.0 Servers Windows Server 2019/2012/2008, Microsoft IIS. Additional Software Office, Project, Google Suite, SAP, SharePoint, Qlikview, QlikSense

• Used the Node.js, Angular.js, backbone.js and Require.js MVC Frameworks in the development of the web applications.

• Developed and Enhanced Various Audit, Firm and Client Screens using Prede Ned React JS Components.

• Involved in complete application stack in Amazon Web Services (AWS) like EC2, S3 Bucket.

• 3-Tier Application Architecture to ensure flexible and reusability of the application.

• Resolved issues, defects and bugs by proper troubleshooting, tracking.

• Used LINQ to build set of operations, parameters and expression during execution a set of data from SQL Server.

• Performed Unit Testing for all units in developed pages using NUnit Tool.

• Used Kafka for message streaming. Connected to Kafka topics using various topics, brokers related information.

• Optimized services using NodeJS, ES6 as interface to Cassandra NoSQL database and programmed and prepared code for interfacing with Apache Tomcat systems.

• Responsible for maintaining and expanding AWS (Cloud Services) S3 infrastructure using AWS (SNS, SQS).

• Developed SSRS reports.

• Providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages

• Developed SSIS packages and scheduled jobs running SSIS packages using SQL Server to perform several scheduled tasks and workflows.

• Designed Http Headers for validating all the XML requests before passing through the Windows Application Firewall (WAF).

• Ran Bower and Grunt components and wrote the scripting using NodeJS.

• Deploy in Azure, IIS, and AWS.

• Automated couple of workflows using PowerShell. Involved in writing background jobs using PowerShell.

• Generated various Monthly, Quarterly, and Bi - Yearly, Yearly reports by different type of reports using SSRS.

• Designed and developed SQL Server Reporting Services (SSRS) SQL Server.

• Developed data ingestion modules (both real time and batch data load) to data into various layers in S3, Redshift and Snowflake using AWS Kinesis, AWS Glue, AWS Lambda and AWS Step Functions

• Created Integration Services SSIS package to import raw data from MS Excel to the SQL Server.

• Extensively involved in developing components for Business Layer and Data Layer.

• Implemented Azure DevOps Services for project management tasks, source code repository, continuous integration and deployment.

• Optimizing processes with software developments.

• Optimizing SAP processes. Involved in configuring CI/CD with Docker and Kubernetes.

• Worked on SQL Server Agent, scheduled SQL JOBS and automated SSIS packages execution on daily basis and implemented logging framework.

• Involved in Report writing according to business requirement using SSRS Reports.

• Used Angular 8 to 12 to separate data from its presentation and offer you data binding.

• Used Net Core to separate data from Presentation.

• Design, Creating and Programing SAP System.

• Developed Software in Flutter for Android Application and IOS to register assorted products.

• Publish Application using XCODE to App Store.

• Creating APK to Install in Android Mobile.

• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

• Create the application UI using client – side technologies like HTML5, CSS3, and JavaScript.

• Responsible for end to end program development and execution, schedule tracking and delivery software development in .Net.

• Worked in SQL SERVER Management Studio for DML queries, query optimization and performance tuning.

• Involved in development of Web Forms, classes using ASP.NET that incorporates both N- Tier Architecture, and Database Connectivity.

• Extended the intranet application to an extranet application using SharePoint.

• Implemented Server and Client-side validations using ASP.NET validation controls and JavaScript.

• Used jQuery to validate user controls and web forms.

• Created and deployed Web Services using ASP.NET, SOAP and XML for Pulling Customer Service Records.

• Modified Web Services to interact with the other applications and exposed them using SOAP and HTTP.

• Used WCF for developing and deploying services on windows in line with the Service Oriented Architecture (SOA).

• Deployment of SSRS reports to report manager.

• Setup of report server and report chief planning for SQL Server Reporting Services (SSRS).

• Worked on development of a Content Management System, developed Web Parts, user controls, custom controls in ASP.NET and C#.Net

• Followed TDD(Test Driven Development) using MOQ and XUnit Testing Frameworks

• Developed SSIS packages to export and import test data from search core engine of internal database.

• Written several transformations, sorting, PIVOTS, SCRIPT TASK, SQL COMMAND, SQL tasks using SSIS.

• Experience on Entity-Framework for Object-Relational Mapping (ORM).

• Used LINQ to build set of operations, parameters and expression during execution a set of data from SQL Server.

• Worked on Entity Framework, generated POCO objects and entity classes which connect to SQL Server.

• Created Integration Services SSIS package to import raw data from MS Excel to the SQL Server.

• Involved in executing SSIS packages, PowerShell scripts, Console Apps, Command Line scripts and stored procedures. Used Kubernetes to deploy scale, load balance and manage Docker containers with multiple name spaced versions.

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

• Developed many T-SQL queries to fetch data as per the business requirements with proper tuning techniques.

• Enhanced the applications performance by constantly monitoring the queries by running Execution plans and query optimization techniques in SQL server.

• Extensive Node JS experience.

• Evaluated Apache Mesos and Kubernetes for Docker Container Orchestration.

• Experience in writing VB scripts for user defines functions in SSRS.

• Used Git Kraken for Version Control, Team build, Project Management, Data Collection and Reporting.

• Developed Business reports using QlikSense, Qlikview, and Reporting Services.

• Worked with testing team to fix the bugs as part of Bug life cycle and Production support. Environment: C#.Net, MVC, Visual Studio 2019, Azure DevOps, Command Line scripts, ASP.NET 4.0, JavaScript, Azure Devops (Boards, Pipelines, Etc), AJAX, JQuery, React JS, Step Functions, Angular JS, Angular 9 to 12, HTML 5, WCF, IIS, XML, SQL Server, SSIS, SSRS, LINQ, TFS, .NET Framework 4.0/4.5, ASP.Net, C#, Vb.bet, MVVM, Web Services (WCF), Ajax Toolkit, MVC 4.0, JavaScript, jQuery, JSON, Web Services, Agile/Scrum, XHTML, HTML / HTML5, CSS / CSS3, Entity Framework 5, T-SQL, Bootstrap, .Net Core, SAP, Qlik Sense, Qlik View, Dart, Flutter.

Client: WI Department Of Revenue,MadisonWI.

Mar 2019– Dec 2020

Role: Sr. Net Developer

Roles and Responsibilities:

• Analysed, Designed and Developed a new Software to manage the company distribution using C# MVC 5, JavaScript, jQuery, Bootstrap 3, CSS3, HTML5, JSON, AJAX, and SQL Server (stored procedures, functions, views, jobs).

• Developed SSIS packages and scheduled jobs running SSIS packages using SQL Server to perform several scheduled tasks and workflows.

• Used Azure DevOps Services for source code repository and to build project artifacts.

• Worked on Angular 8.

• Design and develop application component using react JS.

• Experience in developing unit tests using Microsoft Unit Test Framework and mocking library like MOQ.

• Development of Step functions and Lambdas in AWS cloud environment.

• Developed Web API with .NET Core 2.2 with Visual Studio 2019 for Mac. Deployed .NET Core 2.2 Web API Lambda code on AWS with Server less deployment platform. Wrote single page apps with Angular 8, with a common code base with Native Script for mobile apps served by AWS Mobile back end technologies.

• Creating Windows Services.

• Create PowerShell scripts for server Installs/ad-hoc business reports. Developed various complex modules using ASP .NET, AJAX and C#.

• Create ETL and SSRS reports to automate the adhoc reporting.

• Analysed, Designed and developed a new application using C# ASP.Net Web API, jQuery, Bootstrap 4, SQL Server 2014, Html5, CSS3, and JSON.

• Prepared Documentation for Migration and Development work with BizTalk.

• Working with Google API to use tools in our system like Drive, Calendar, etc.

• Troubleshooting.

• Expertise in using NUnit/XUnit/Testing frameworks, Nant/MS Build as project building tool and Jenkins for continuous integration.

• Used Spring Kafka API calls to process the messages smoothly on Kafka Cluster setup.

• Designed and Developed Kafka Message Consumer using Node.JS, to capture updates to profiles and update braze accordingly.

• Developed various operational Drill-through and Drill-down custom reports using .Net framework within SSRS.

• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.

• Used SQL Server Integration Services (SSIS) 2012 / (Visual Studio/SQL Server Data Tools) to create a process to extract information from different sources (Main SAP)

• Design, creating and programing satellite SAP system.

• Creating SSIS Packages using different type’s task and with Error Handling.

• Participate in Scrum/Agile meetings to update the status of application development.

• Developing a HTTP caching strategy to solve some performance issues

• Handled SQL Server DB (stored procedures, functions, data types, queries, Indexes, triggers, views, Performance Tuning, Query Optimization, CTE, and User-Defined Types) and Database Backups. Participating in DB optimization at development level

(Indexing and Queries optimization) and solving design problems, using normalization as the primarily approach.

• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS).

• Used GIT Kraken for version control.

• Design/code involving large volumes of data PowerShell ASP.NET/ Web API.

• Written several packages using SSIS for data migration and ETL process.

• Worked in advanced MVC architecture for front end and used REST Web API as a service layer with Entity Framework as an ORM technology connecting to back end SQL Server database.

• Used AWS to deploy to different environments.

• Involve in all the phases of Software Development Life Cycle (SDLC) including Analysis, Design, Programming, Testing and Deployment.

• Used Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages

• Management Farm, account from SharePoint.

Environment: ASP.NET, Reporting Services, SQL Server, SSIS, SSRS, Bootstrap, jQuery, AWS, Gitkraken (Repos, Boards, Etc), ASP NET Web API, REST, Windows Services, and WCF, SAP, SharePoint.

Client: Safeway Inc,Pleasanto,CA Feb

2018 – Feb 2019

Role: .Net Developer

Roles and Responsibilities:

• Create the application in .NET framework 4.5 and implement logic using C#, VB.NET and OOPS concepts.

• Involve in all the phases of Software Development Life Cycle (SDLC) including Analysis, Design, Programming, Testing and Deployment.

• Analysed, Designed and Developed a new Web Portal as Supplies Chain, working with Vendors, Digital sign, Document Tracking, Offshore (oil and gas) Work Management, IVR Systems.

• Used C#, VB, JavaScript, jQuery, CS S3, HTML5, AJAX, SQL Server 2012 (stored procedures, queries, functions, views, Jobs.

• Wrote data access layer with Unit of Work and Repository pattern for AWS DynomoDB Wrote a L2 Cache with Elastic Cache for AWS API Gateway, to cache API payloads. Intergard D2L LMS into salesforce. Set up IAM roles and permissions from scratch.

• Create the application in .NET framework 3.5 and implement logic using C# and OOPS concepts.

• Create the application UI using client-side technologies like Java Script, jQuery, Angular, CS S3, HTML5 and AJAX.

• Use ASP.NET Web API as the platform for building Restful applications on the .NET Framework.

• Design & Develop Web Portal with Dev Express Controls.

• Participate in Scrum/Agile meetings to update the status of application development.

• Developed and implemented the multi-threaded Web forms, win forms GUI design by using

.NET framework, Visual Studio.

• Changing processes and migrations from XML to systems.

• Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent as parameter to the stored procedures.

• Interact with the database using Entity Framework to have object-relational mapping and use LINQ to query the DB.

• Unit test the modules of code developed and participate in integration and user acceptance testing.

• Creating Sites and web using SharePoint 2008 environment. Environment: C#.Net, vb.net, Visual Studio 2012, ASP.NET 3.5, JavaScript, HTML 5, IIS, XML, SQL Server 2014, .NET Framework 3.0/3.5, ASP.Net, C#, Agile/Scrum, XHTML, HTML / HTML5, CSS / CS, S3, SharePoint 2008.

Client: PNC Bank,Greewich,CT

Apr 2014 – Jan 2018

Role: .Net Developer

Roles and Responsibilities:

• Implemented Data Access layer, Caching Application block, Application validation, Exception handling and logging components using Microsoft Enterprise Library 4.1 Application Blocks.

• Developed and used various Web forms, Custom Controls and User controls using ASP.NET, C# and JavaScript.

• Extensively used LINQ to Objects to query the objects based on requirement.

• Used ASP.NET 3.5 Server controls, User Controls and HTML controls.

• Developed applications using Team foundation server 4.5 and entity framework in the project.

• Designed pages using Ajax.

• Good knowledge on Micro services, AWS (Amazon Web Services), working with EC2, RDS, Dynamo DB, S3, Cloud watch and Docker.

• Using MVC 5 architectures to developed web-based applications.

• Utilized ASP.NET, C#, Service Oriented Architecture (SOA), Windows Communication Foundation (WCF).

• Writing Complex Stored Procedures in SQL to pull data from DB2 and Oracle.

• Involved in Database Designing, Views and Stored Procedures in SQL Server.

• Involved in Unit testing and Integration testing with other modules.

• Creating reports using the Crystal Report for the report needed by Middle Office, Back Office users.

• Developed Web pages with ASP.NET using JavaScript, Client-Side Validation, Server controls, HTML5 Controls, jQuery, and CSS.Implementing the Object Relational Mapping using hibernate.

• Accessed and developed custom lists, Pages, Page layouts, Document Libraries using SharePoint object model.

Environment: C# 3.0, ASP.NET 3.5, MVC 5, XAML, Visual Studio 2010, ETL, ADO.NET, Js, HTML, DHTML, XML, XSL, XSD, SOAP, Web Services, jQuery, hibernate, Ajax, Oracle, SQL Server

Client: Systrack solution,inc Hyderabad India May 2013 – Mar 2014

Role: Junior .Net Developer

Roles and Responsibilities:

• Analysed the requirements and prepared the analysis report.

• Designed and developed the User Interface using Win-forms.

• Source Code implemented using C#.Net.

• Designed and developed business components and data components using C# and ADO.NET.

• Developed Win Forms and integrated these forms with Windows Services.

• Developing User Control for Common Functionality in the ASP.NET.

• Involved in using all the best features of ASP.NET including Data Set, Data View and Data Adapter.

• Performed validations using Validation Controls.

• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter.

• Involved in Writing, modifying complex Queries, Stored Procedures and Triggers Designed and developed applications using VB.NET, ASP.NET with ADO.NET.

• Familiar with several design patterns such as Iterator, Single Responsibility, Dependency Injection,

Environment: C#.Net, VisualStudio.Net, ASP.Net, SQL Server, MVC, HTML, CSS, JavaScript & XML.



Contact this candidate