Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
Manhattan, NY, 10007
Posted:
November 17, 2023

Contact this candidate

Resume:

JAYAVARDHAN

Email: ad08pf@r.postjobfree.com PH: 989-***-****

Full Stack.NET Developer

Professional Summary

9+ years of experience in the areas of application programming, system design, development, deployment, execution, testing and Implementation of business applications.

Had a career growth spanning several roles including developer and Lead role.

Experience working on NET 5.0/4.0/3.5/2.0, C#, VB.NET, ASP.NET, XML, XSLT, XAML, DHTML, DTD, ADO.NET, Web Services, WCF, WPF, LINQ, Generics, JavaScript, AJAX, OOPS, HTML, CSS, IIS, Entity Framework, Win Forms, Web Application, Visual Studio 2017/2015/2010/2008/2005/2003, SQL Server 2008R2/2008/2005/2000, Oracle 11i.

Strong in the complete Software Development Life Cycle (SDLC) including requirements definition, design, programming / testing and implementation of major systems.

Hands on experience in requirement gathering, analysis, system modeling, design and development of 3 Tier, N-tier distributed architectures and MVC architecture.

Experiences working with WCF, WPF, Web forms, Win forms.

Experience in working with WCF Services and XML Web Services using SOAP and WSDL following SOA in a distributed environment.

Strong relational database background in SQL Server, Oracle 9i with extensive knowledge in writing the PL/SQL, T-SQL scripts, Stored procedure, Triggers, Views, Database designing and Maintenance.

Experience in Telerik RAD controls for ASP.Net AJAX and Infragistics Controls.

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

In-depth experience of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

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

Experience using AJAX, HTML, CSS, JavaScript to enhance the performance, looks and features of the website.

Experience in deployment using IIS Application Servers.

Working experience in agile methodology using Rally dev tool and scrum methodology using scrum works protocol.

Hands on experience on Test driven development (TDD) and production support activities.

Experience in Version controlling tools VSS, TFS, GIT, and SVN.

Expertise in Maintaining, supporting and troubleshooting applications and fixing bugs.

Experience working using Angular JS, Angular 2 and sound knowledge on Angular 4, 5, 6.

Excellent Interpersonal and Communication skills coupled with strong technical and problem-solving capabilities.

Exceptional ability to quickly master new concepts and a proactive team player.

Professional Experience

Full Stack.NET Developer

Molina healthcare, Bothell, WA June 2022 to Present

Responsibilities:

Involved in SDLC phase of requirement analysis, design, and development of the web application using .NET Core and C#. Development involved 35% front-end Angular 2,4,6,7 work with 65% middle-tier/back-end .Net Web API & SQL Server tasks.

Developing the project using agile methodology with daily (SCRUM) paired programming using TDD (test driven development) and continuous integration/ deployment (CI/CD) using SDLC process.

Developed the application using ASP.NET, C#. NET, AJAX, jQuery, JSON, HTML5, JavaScript, TypeScript, Angular 2,4,6,7, CSS3, RESTful.

Developed ASP.NET Web customs controls, user controls, Data controls like Data Grid, Rich UI with extensive use of C#, ASP.NET AJAX, Node JS, Angular 2,4,6,7, Bootstrap.

Implemented C#. NET, MVC and Object-Oriented Programming concepts and created general Class library, Partial Class, Generics Using C#. NET.

Implemented client and server-side validations using ASP.NET validations controls and JavaScript.

Used RESTful in the Angular 2,4,6,7 page with Web API and implemented Angular 2,4,6,7 Controllers to maintain each view data and Used Restful services using Web API to get data from server asynchronously.

Worked on developing a different module with Angular 2,4,6,7 which will be run on Node JS server.

Design and developed web site (GUI) Screens using ASP.NET MVC 5, C# .NET, User controls, JavaScript and Data Controls.

Integrated Azure Cosmos DB with Azure Functions for serverless, event-driven architecture, automating data processing tasks and reducing operational overhead.

Utilized Azure Kubernetes Service (AKS) for orchestrating containerized microservices, ensuring seamless scalability and high availability.

Implemented CI/CD pipelines using Azure DevOps, automating the build and deployment process, thus accelerating time-to-market.

Architected and led the migration from .NET Framework to .NET Core, enhancing application performance, reducing costs, and enabling cross-platform compatibility.

Spearheaded microservices architecture using .NET Core, adopting Docker containers and Kubernetes for seamless scaling and high availability.

Integrated .NET Core Identity with OAuth2 and JWT for secure, scalable authentication and authorization mechanisms in RESTful APIs.

Utilized Entity Framework Core for database operations, implementing code-first migrations and optimizing data access layers for high-performance applications.

Leveraged Azure SQL Database for cloud-based relational data storage, implementing geo-replication and failover groups for high availability and disaster recovery.

Developed stored procedures, functions, and triggers using SQL and T-SQL in MS SQL Server for fetching the data and binding and used LINQ to SQL to query database.

Employed the Aggregation Framework in MongoDB to perform complex data transformations and computations, optimizing application logic and reducing server load.

Used Entity Framework to create Models and used tools to explore REST API. Used NuGet package manager to pack and use the updates versions of browser control.

Resolved critical production issues related to memory leaks and high CPU utilization, implementing fixes to the .NET application stack and improving system stability as a production support.

Spearheaded the production support efforts in rollbacks and hotfixes, ensuring zero downtime during the update process of business-critical applications.

Conducted root-cause analysis for recurring production issues, optimizing .NET codebase and SQL queries to mitigate future incidents.

Involves Unit Testing, Integration Testing and Regression Testing in a regular basis to improve the performance of the application.

Implements software Configuration Management, setting up company version policies utilizing TFS.

Environment: .Net Framework, .Net Core, ASP.NET MVC 5, IIS, C#. Net, Visual Studio, Web API 2.0, SQL Server, WCF, Entity Framework, LINQ, Cosmos DB, Git, MongoDB, AJAX, Angular 2,4,6,7, CSS, Entity Framework, Typescript, JavaScript, Bootstrap, jQuery, ADO. NET, Azure, Agile Methodology.

Full Stack.NET Developer

Global Atlantic financial group, Indianapolis, IN Jan 2020 to May 2022

Responsibilities:

Build the application is based on Ionic framework with angular modules DB calls are happened through Web API.

UI is built on Bootstrap and HTMLS, Ionic, Type Script and SCSS

Develop user interface by using Telerik Kendo UI

Created Design Documents and wireframes based on team requirements.

Created payment mechanism using third party modules like clover mechanism to transections in iPad.

Routing the application based on requirements like URL or path.

Implemented Client-side validations in I App

Most of the UI related components are build based on Ionic framework.

Worked on Visual Studio code / .Net CORE 2.1 Framework N tiered application with an Angular and SPA front end.

Led DevOps initiatives, implemented CI/CD pipelines via Azure DevOps, enhancing code quality and speeding up the deployment phase in SDLC.

Specialized in RESTful API design using ASP.NET, ensuring seamless data exchange and integration throughout the SDLC.

Collaborated with the DevOps team in monitoring .NET applications, setting up automated alerts and logging mechanisms for proactive issue detection in production environments as part of production support..

Managed database backup and restoration tasks in production support, ensuring data integrity and availability for enterprise-level .NET applications.

Led the migration from ASP.NET MVC to ASP.NET Core, leveraging its cross-platform capabilities and improved performance, thus optimizing the application's scalability and resource utilization.

Expertise in developing RESTful APIs using ASP.NET Core, implementing JWT-based authentication and OAuth2 for secure data exchange in microservices architectures.

Utilized RESTful API versioning strategies to maintain backward compatibility and support multiple versions of the application simultaneously.

Using Angular component and model structure builds the application along with Typescript language.

In jQuery Created DOM objects to call and implementing user methods.

Followed TDD Test Driven Development+23 and developed test cases by using N Unit for unit testing for each and every module developed.

Experience in creating configuration files to deploy the SSIS packages across all environments.

Bootstrap used to create templates and forms, textboxes and dropdown's all UI tools and Navigations bars.

UI and database operations are handled by Components and model's approach.

Ajax Calls used in CSHTML files for fast performances.

Wrote Azure Functions for long running Tasks.

Configured the Azure Application Insights for Application performance management.

Implemented data partitioning strategies in Cosmos DB to distribute data across multiple physical partitions for improved performance and scalability.

Experience in design and developing Application leveraging MongoDB.

Creation of database objects like tables, views, procedures and packages using oracle tools like PL/SQL Developer and SQL* plus.

Testing is done using UNIT Testing

Visual Studio code tool is used to build the application.

Completed tasks based on sprint wise and participated Sprint review meetings and used Agile methodologies.

Using Git, done Code management and branching in Visual Studio

Bit bucket is used to merging the current branch to master and master to local branch.

Environment: Ionic Framework, Angular, Telerik Kendo UI, SCSS, MongoDB, TFS, ASP.Net, Git, .Net Core2.1, Type Script, Bootstrap, HTML 5.0, CSS, Visual Studio Code, TDD, Unit testing, Bit Bucket, PL/SQL, Cosmos DB, Oracle, Azure, Source tree, MVC Web API.

.NET Developer

Chewy Dania Beach, FL Oct 2017 to Dec 2019

Responsibilities:

Designing and developing new presentations of data within the Enterprise Allegations Platform.

Developed new data feeds and extend existing feeds via Soap API services and PL/SQL.

Extensively worked on Oracle PL/SQL writing complex queries, stored procedures, views to manipulate, arrange and organize the data needed for the application.

Integrated third-party SOAP services using .NET's native libraries, facilitating seamless data exchange with enterprise-level applications.

Worked on unit testing, bug fixes, code reviews, and documentation.

Extensively worked with TFS as source control for code management

Worked on Scrum and agile methodology and followed one-week sprints for delivering user stories using JIRA board.

Worked closely with QA testers and business analysts for story acceptance.

Extensively worked on SQL Server 2014, writing complex queries, stored procedures, views, LINQ.

Implemented multi-layer MOQ based unit testing, worked on bug fixes and the production support.

Worked on a console app for automating the test cases for different flows.

Implemented Redux Thunk middleware to handle asynchronous actions in the React-Redux architecture, enhancing the application's capability to interact with APIs seamlessly.

Utilized Redux DevTools for real-time debugging and state inspection, improving traceability and facilitating easier debugging within the React-Redux ecosystem.

Integrated AWS API Gateway for creating, deploying, and managing APIs, facilitating secure and scalable data exchange between front-end and back-end systems.

Implemented AWS Lambda for serverless computing, running code in response to triggers such as changes in data, shifts in system state, or user actions.

Configured Amazon (AWS) RDS for SQL Server, ensuring high availability and fault tolerance for database-driven applications.

Utilized Amazon S3 (AWS) for scalable storage solutions, implementing versioning and lifecycle policies for effective data management.

Implemented DynamoDB Streams for real-time data processing and synchronization, integrating with AWS Lambda to execute custom logic in response to database changes.

Implemented dynamic user interfaces utilizing React v16, incorporating features like Hooks and Context API for improved state management in complex applications.

Spearheaded the design and implementation of complex business applications using the ASP.NET MVC framework, ensuring a clean separation of concerns through the Model-View-Controller (MVC) architecture.

Leveraged Razor View Engine for dynamic HTML generation, improving front-end performance and enhancing user experience in MVC-based applications.

Utilized ASP.NET Core's built-in Dependency Injection and Middleware features to create loosely coupled, testable, and maintainable code, enhancing the application's resilience and ease of updates.

Worked closely with QA testers and business analysts for each sprint story acceptance.

Environment: .NET Framework 4.5, Web API, HTML, CSS, Typescript, React JS, ASP.Net MVC, Razor, Kendo UI, LINQ, SOAP UI, Bootstrap, Visual Studio 2015, C#, SQL Server 2014, PL/SQL, AWS Cloud, Services, Agile, TFS, Oracle SQL Developer, DynamoDB, TFS, SoapUI.

.NET Developer

Couth Infotech Pvt. Ltd, Hyderabad, India October 2015 to July 2017

Responsibilities:

Interacted with end users and Business Analyst to create low level technical design document.

Involved in Database Design, System Analysis, design and development.

Used the ADO.NET for the Data Access from the Database.

Created UI screens using ASP.NET web forms and user controls.

Created the Queries to access the data from the SQL server as the backend.

Coordinated with offshore for the multiple version releases for this product.

Created the Patch (C#) for the unsupported product errors. Fixed three main production bugs using this patch.

Wrote PL-SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Indexes using T-SQL and LINQ using Oracle.

Interacted with the client-Support team and clarified their queries about the product.

Created the FAQ document for the client support team.

Involved in the Install shield Creation and fixed the production issues.

Responsible for the Deployment and Delivery of the product in the client environment. Contributed in design and development of database.

Created ASP.NET User Controls and Components to reduce the complexity of user interface design.

Configured global. Sax and Web.Config for setting the Application and Session variables.

Created security features for this application using windows-based authentication.

Used agile development methodology by welcoming changes even late in the development cycle.

Environment: C# .NET, ASP.NET, WEB API, JavaScript, jQuery AJAX, SQL Server, ADO.Net, MySQL.

.NET Developer

Maisa Solutions Private Limited Hyderabad, India June 2014 to September 2015

Responsibilities:

As a developer involved in design and developing Web forms using ASP.NET and C#.

All the user interface layers, web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.NET User Controls, Web Server Controls and ADO.NET.

Used built-in validation controls and custom validation controls for front-end validations.

Created Tables, Indexes, Triggers and Views in Microsoft SQL Server 2008.

Used cookies and sessions with the time out features.

Created and maintained database objects.

Extensively used ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object to access the data in database.

Designed and implemented database using SQL Server 2005.

Created user defined stored procedures and functions using SQL Server 2005.

Developed server-side PL/SQL Packages, procedures and functions that are used in.

Assisted in writing and optimizing complex SQL Queries.

Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.

Developed reusable control using ASP.NET and C#

Followed Agile Methodology with scrum meetings.

Environment: C# .NET, ASP.NET, WEB API, JavaScript, jQuery AJAX, SQL Server, PL/SQL, ADO.Net, MySQL.

Technical Skills:

Programming Languages: ASP.Net, C#.Net, VB .Net (Framework 2.0, 3.5, 4.0, 4.5, 5.0)

Design Pattern: MVC3, MVC 4.0, MVC 5, MVVM

Design and Modelling tools: Enterprise Architect (EA), Microsoft Visio, Entity Framework

Reporting Tools: SQL Server Reporting Services (SSRS) 2008, 2008 R2

RDBMS: MS SQL Server 2008/2012/2014/2016, MS-Access

ETL: SSIS 2008/2012

Web Services: WCF, REST, SOAPUI, TCP/IP, WEB API

Development tools: Visual studio 2017/2015/2013/2010/2008/2005/2003

Version control: Visual Source Safe, Team Foundation Server, GIT, SVN

Web Development: HTML, VB Script, JavaScript, CSS, AJAX control toolkit, jQuery, Win Forms, and Web Forms, Angular JS, Type Script, ReactJS, and Log4Net, Telerik/Infragistics.

Others: n Unit Testing, MS TESTING, Agile (Scrum), Waterfall

Operating Systems: Windows 9x/NT/XP, Windows 7, MS-DOS, UNIX



Contact this candidate