Sql Server Stack Developer

Senior .Net Full Stack Developer

Santhosam Anvesh

Phone: +1-302-***-****

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

PROFESSIONAL SUMMARY:

Over 9+ years of experience in developing, implementing Web Applications, Window Applications and products using visual studio 2017/2015/2013, C#, ASP.NET, Dot NET Framework, Team Foundation Server, IIS web servers and data bases like SQL Server 2012 / 2008.

Design, Develop and Implement Web Applications using .NET Framework Architecture including C# .NET, Win Forms, ASP.NET, AJAX, WCF, WPF Web Services, ADO.NET, Data Entity Framework, XML, IIS and Visual Studio.

Expertise with application development using Object Oriented Analysis & Design techniques (OOAD).

Experience with designing and development of applications using MVC, MVVM design patterns.

Expertise in implementation of optimized, secured WCF Services by using Service, Operation, Data, Fault and Message Contracts.

Extensive experience in Core C#, ASP.Net MVC 5.0, WCF, Web services, front-end technologies like HTML5, CSS3, JavaScript, AJAX, JSP, JSTL, JQuery, Kendo UI controls, and other JavaScript libraries (jQuery, Angular 8, Angular Js, Bootstrap and DOJO).

Experience in Microsoft Dynamic CRM 2016, Dynamics 365 Customer Engagement (8.X) and Dynamics 365 (9.X) on Unified Interface customization and integration with MS SharePoint 2010 and MS Outlook.

Proficient in customizing Unified Service Desktop client (4.0) for Microsoft Dynamics 365 CE.

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

Worked on different modules like Sales, Service, Marketing, Project Service Automation in Microsoft Dynamics CRM.

Experience in developing User Interface (UI), Business Logic and Data Access components to meet user requirements.

Experience in Developing XML Web Services Publishing and consuming them.

Possess in-depth knowledge in SQL Server 2017, SQL Server 2012/SQL Server 2008, with technologies such as Stored Procedures, Views, Triggers, Transact SQL.

Hands on experience in developing applications to access data and data services in ADO.NET.

Extensively & efficiently used Data Reader and Datasets in ADO.Net to retrieve, display, edit and update data in the database.

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

Hands on experience writing Scope Scripts for Cosmos (Big Data) Azure Services and cloud services

Sound knowledge in C# .Net, WCF, WPF, LINQ, Entity Framework, ADO.Net, WinForms, and several design patterns.

Solid Experience of C/C++ /VC++ development

Experience in developing micro services using ASP.NET core

Experience working with .NET features like Events & Delegates, Generics & Collections, Multi-Threading, Exception Handling, Serialization, LINQ.

Hands-on experience in Azure Cloud services such as PaaS, SaaS and IaaS. Ex: WebApps, WebJobs, Functions, SQLAzure, CosmosDB, Service Fabric, Docker and Kubernetes.

Experience with Microsoft Azure, Azure Resource Management templates, Virtual Networks, Storage, Virtual Machines, and Azure Active Directory.

Experience in Creating Azure SQL database performed monitoring and restoring of Azure SQL database.

Performed migration of Microsoft SQL Server to Azure SQL database.

Experience on Windows Communication Foundation (WCF).

Experience working with Azure components (Azure Blob, storage, containers, keyvault)

Deep understanding of WPF and related concepts, including data binding, Data Templates, Control Templates, MVVM

Experienced with using Source Code Version Control Systems like MS Visual Source Safe (VSS) and TFS (Team- Foundation Server).

Knowledge on developing Reports using SQL Server Reporting Services (SSRS).

Exclusively developing and deploying Web Services using WSDL, UDDI and SOAP.

Proven ability to analyze problems, root causes and develop innovative solutions to business challenges and streamlining operations

TECHNICAL SKILLS:

Programming Languages

C#, .Net, Java, C++

Web Technologies

ASP.NET, HTML, HTML5, AJAX, Web-Services, JSON, AWS.

Scripting Language

XML, CSS, Java Script, AngularJS, React JS, JQuery, Bootstrap, WSDL, XSD

Technology

MSFT.Net Framework 1.1/2.0/3.0/3.5/4.0, ADO.NET, WCF, WPF ADO.Net Entity framework

Microsoft Technologies

Microsoft Dynamics CRM 2016,Dynamics365 CE(On-Premise and Online)

Database

SQL Server-2008/2012/2017, MS-Access, Oracle 10g

Development Tools

Microsoft Visual Studio .NET 2008/2010/2012/2013/2015/2017, XCode, Eclipse

Web Server

IIS5.1, IIS 6.0 and IIS 7.0

Operating Systems

Windows XP/Vista, Windows 7/8/10, Mac OS X

Versioning Tool

Team Foundation server, Rational Clear case

PROFESSIONAL EXPERIENCE:

Northern Trust Chicago, Illinois May 2022 – Present

Senior .Net Full Stack Developer

Responsibilities:

Gathering requirements from business line users and creating action plans based on the business logic.

Extensively involved in developing components for Business Logic and Data tier using C#, ASP.NET MVC, and ADO.NET.

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

Responsible for developing the reusable Components on UI (Razor Views) by developing the Partial Views, View starts, and reusable components for implementing the business rules with C# and OOPS Concepts.

Implemented AJAX controls for partial page updates and to decrease the response time on the pages.

Extensively worked on developing the front end with a rich User Interface for the application.

Used Entity Framework for SQL Server database access from the data source.

Working with the client-side technologies Java Script, jQuery, HTML5, CSS3, and Bootstrap

Worked on enhancements to the project using Microservices, SQL Server, .Net Core 3.1.

Developed in Agile\Scrum atmosphere.

Worked on creating new components and enhancing existing components using Angular.

Created Services to consume REST API's and to communicate between components using Dependency Injection.

Designed and Consumed XML Webservices using Microservices.

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

Implemented authorization, authentication, and extensive exception handling.

Implemented LINQ Query operations like Grouping, Ordering and Filtering operations.

Created RESTFUL services using WebAPI, built HTTP services and formatted responses using web API media type formatter to JSON.

Responsible for front-end Ul development using HTML5, SCSS, Typescript, PrimeNG, Angular 12, and RxJS.

Wrote Unit Testing for all methods in different layers using NUnit.

Experience in designing and implementing infrastructure as code and CI/CD pipeline for deployments of large-scale web applications.

Created Angular 12 components, implemented Interpolation, Input Variables, Bootstrapping, NgFor, Nglf, Router Outlet, event binding, and decorators.

Imported data from flat files to SQL Server database using SIS Also used Azure for Scaling and checking the reliability of the applications which were developed during the project.

Working on Azure for highly available customer facing B2B and B2C applications

Created a database known as SQL AZURE database, which integrates with Active directory and Hadoop.

Deployed and Maintained windows phone applications on Azure cloud technologies.

Diagnose production issues and determine the needed fix. Determine a corrective action plan in order to get the production environment accurate.

Used GIT for version Controlling and source code sharing and used MSBuild.

Developed Server-side validations using Validate framework and client-side validations using Javascript.

Scanning the code by using vulnerability tools like SonarQube, Fortify, and Blackduck and remediating the vulnerabilities before the target date.

Working on an integration project with both bi-directional and uni-directional integration between two different systems.

Developed and maintained CI/CD pipelines for continuous integration and deployment using CloudBees Jenkins.

Implemented and managed JFrog Artifactory as a centralized repository for storing, versioning, and distributing software artifacts.

Involved in onsite interactions on a daily/weekly basis in getting clarifications on requirements.

Participated in code reviews, planning, estimation, and daily scrum meetings.

Environment: Visual Studio 2019/2017, C# 4.0, Visual Studio Code, Azure, Java Script, Entity Framework 4.0, MVC 5, AJAX, jQuery,PowerShell,.NET Core 3.1, JavaScript

Molina Healthcare Bothell, WA April 2020 – April 2022

Senior .Net Full Stack Developer

Responsibilities:

Involved in planning and implementing sprints along with project management team.

Worked on JIRA for tracking user stories and HP ALM QC for Defect’s tracking.

Responsible for making AJAX Calls for the UI Interactions to the Controller Actions using Angular JS

Data back as JSON and parsing it onto UI. Utilized the features of Angular 8 to present effective web design

Customizing and configuring of Microsoft Dynamics 365 service and Unified Service Desk Modules Using OOB features and Custom JavaScript’s.

Test the APIs using swagger and postman

Developed localization API s which stores the translated data in Azure and Sql tables and Deploy WCF services on Azure cloud

Built Angular 8 components, UI services to consume rest services using Component architecture of Angular 8. Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).

Worked on SLA management, UII framework for customizing USD components.

Worked on Hosted Controls, Actions, Events, Agent scripting, Windows navigation rules etc in USD.

Effectively involved in various stages of development of the project starting from the project planning until production and maintenance using agile methodology.

Worked on the Business Logic for all the modules in a separate Business Layer in C# and this was implemented using WCF.

Used Model View Controller (MVC 5) architectural Design Patterns for the development of the product

Designed, developed and trouble-shoot the application using advanced Microsoft technologies such as ASP.NET MVC 5, JQuery, HTML5, XML, WCF, and CSS3 using Agile development practices

Developed Single page application and dynamic responsive web applications with Angular 10

Created and consumed Web API Restful services to consume full Http features like URI’s, request/response headers, caching, versioning and various content formats

Test the APIs using swagger and postman

Created res-usable components, custom modules, custom directives, pipes, services in Angular 10

Used Postman tool to test the web API for performance improvements based on configuration changes

Worked on tools like Fiddler, Soap UI.

Testing and deployment of different versions of the application to different environments like DEV, QC, Staging & Production, bug-fixing based on the issues reported in UAT issue tracker.

Used .NET object oriented features(C#), event handling, error handling, caching and security feature

Performing detailed root cause analysis for problems in addition to providing quick fixes to address immediate symptoms.

Used Postman tool to test the web API for performance improvements based on configuration changes in azure portal for load balancing and other performance improvement settings in Azure SQL DB

Worked on tools like Fiddler, Soap UI, XrmToolBox, Plugin Registration Tool.

Worked on writing JavaScript’s, Business Rules, Plugins, Workflows and Ribbon customizations

Improved application performance using Azure Search and SQL query optimization.

Designed and Developed WebApi's for Microservices.

Implemented Azure Application Insights to store user activities and error logging.

Worked on Dynamics 365 CE version 8.2 upgrade to Dynamics 365 CE version 9.0.

Knowledge on in configuring AppDynamics application monitoring tool and Splunk logging tools.

Hands-on on Plugin, JavaScript and USD debugging skills.

Testing and deployment of different versions of the application to different environments like DEV, QC, Staging & Production in azure, bug-fixing based on the issues reported in UAT issue tracker.

Performing detailed root cause analysis for problems in addition to providing quick fixes to address immediate symptoms.

Environment: C#, .NET Core, Entity Framework 6.0, HTML5, CSS3, Angular 8, Web API, Agile, Typescript, AJAX, JSON, IIS 7.0, HTML5, CSS3, Azure, S3, SQL Server 2018(T-SQL, PL/SQL, Stored procedures, Triggers).

Liberty Mutual Insurance Boston, MA Jan 2018 – March 2020

.Net Full Stack Developer

Responsibilities

Involved in designing User interface and Prototypes for the application using ASP.NET

Responsible for developing Application using ASP.NETMVC 3.0 and C#.

Involved in design, development and maintenance. Used UML for designing the application.

Designed web forms using different HTML Controls.

Actively involved in coding and designing using C#, XML, ADO.NET,JavaScript, HTML, and Cascading style sheets (CSS).

Experience in VSTO using .NET developing add-in for office application to implement business functionality

Developed background process infrastructure on top of Windows Azure Queues.

Used micro services architecture, based services interacting through a combination of REST and leveraging azure to build, test and deploy Identity micro services.

Developed and maintained Application and eCore logic (using C#, WPF and MVVM) which allows administrators to manage Test results for distributed datalog streams.

Developed .NET Core Function Apps with HTTP Triggers, Azure Service Bus Triggers, Azure Storage Queue Triggers, Timer Triggers

Involved in designing, Coding and documentation of application flows and worked on presentation layer for developing GUI and developed using WPF

Used WPF built-in set of data controls to bind and manipulate data within applications.

Extensively worked on designing, developing WPF application using MVVM and MVP design patterns adapted web application to run in Windows Azure against SQL Azure using Azure Queues for background processing.

Used Validation Controls for corresponding validations required for business logic in the Forms.

Responsible in developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL Server2008.

Worked on building web applications, WCF services and other real-time interfaces to create user experience that meets and exceeds the needs of the client and internal team specifications using agile and scrum methodology.

Used Data Annotation, Partial Views, Layouts, Strongly Typed views in Model View Controller (MVC).

Used Razor Engine for creating web pages.

Worked on Migration asp.net application to MVC 4.0 application.

Coding Extensively in C# to implement business logic and developing interface classes.

Generated Unit Test Cases using Visual Studio 2010.

Optimized the Stored procedures for fast data retrieval.

MSMQ stores messages in memory for increased performance, and a message may be sent and received from a queue without ever having been written to disk.

Extensively worked on MS- SSRS, SSIS and Slowly Changing Dimensions.

Extensively used ADO.NET for database connectivity and transactions. Used Dataset, Data Tables, Data Adapter, Data Reader and other ADO.NET connectivity controls extensively.

Responsible for developing WCF Services using C#. The application extensively absorbs and exposes web services.

Responsible is using JQuery for Client Side Validations, Calling the Controller Actions, and Making calls to the WCF Services.

The project went through full SDLC using Agile. Used UML for designing the application. Used Design Patterns.

Coordinate with the QA Team for Unit Testing and Integration Testing of different modules.

Environment: Visual Studio 2013, ASP.NET MVC 3.0, C#, WCF Services,WPF, Azure, Angular JS, JQuery, Bootstrap, Java Script, JSON,CSS, Design Patterns, Web Forms, ADO.NET, SQL Server 2012, Stored Procedures

Hexaware Hyd,India June 2014 – Sept 2017

.NET Developer

Responsibilities:

Responsible for involving in all phases of Project Development life cycle.

ASP.NET was used to build the Front end user and C# was used for business layer and data layer.

Involved in designing and implementing Project Module, Budget Module.

Analyzed business requirements to evaluate the design of the application.

Designed Web Forms using different ASP.NET Server Controls, Validation Controls, and other third party controls.

Extensively used JavaScript in ASP.NET for developing the Web Pages.

ADO.NET was extensively used by Project module and Budget module. Dataset, Data Adapter, Data Reader and other ADO.NET connectivity controls were extensively used.

Used ASP.NET validation controls for validating the information provided by the user and implemented input validation using the ASP.NET Input Validation Controls.

Heavily used .NET Web Controls, Validation Controls and User Controls.

Wrote SQL Queries, Stored procedures, Joins, Triggers to process large collection of products and used Data Reader, Data Adapter, SQL Command and Dataset for retrieving data from database using SQL Server 2008.

XML Web Services are exposed to provide the Project details to Vendor applications.

“Windows Authentication” was used to authorize users.

Used Web Services for project management, architecture, production, application development and ongoing maintenance throughout the site.

Responsible for developing Stored Procedures, Views, Indexes, Scripts effectively and called from Data Access Layer.

Coordinated with the QA team and make sure all the functionality of the application are tested.

Responsible for maintaining versions of source code using Team Foundation Server (TFS).

Environment: Visual Studio 2008, Web Forms, ASP.NET, C#, ASP.NET Server Controls, Third Party Controls, ADO.NET, XML Web Services, SQL Server 2008

Contact this candidate