Stack Developer Sql Server

.Net Full Stack Developer

Name: Hitesh K

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

Phone: +1-501-***-****

PROFESSIONAL SUMMARY:

• As a .NET Full stack developer with 5 years of experience, adept in developing web-based, client/server, n-tier distributed, and object- oriented applications using Microsoft technologies.

• Successfully meets technical challenges and business needs through client interaction, leveraging Agile SCRUM methodology and Waterfall for new product development.

• Developed and maintained interactive web applications using Blazor and .NET, creating seamless, single-page applications with improved user experiences and responsive interfaces.

• Skilled in Unified Modeling Language (UML) standards and documentation with tools like Microsoft Visio, covering Use Case Diagrams, Class Diagrams, Sequence Diagrams, and Activity Diagrams.

• Extensive experience in .NET Core, Microservices, C#.NET, ASP.NET, MVC, ADO.NET, Entity Framework, AJAX, JavaScript, J Query, WCF, XML Web Services, LINQ, and Web Api.

• Implemented data ingestion and transformation pipelines with PySpark/Scala on Databricks, enabling the seamless movement and processing of data from sources like AWS S3, Azure Blob Storage.

• Created applications in ASP.NET Core, C#, Web Services, Ajax, ADO.NET, and SQL Server.

• Strong understanding of Relational Database Management Systems (RDMS) such as Oracle and SQL Server, including knowledge of Microsoft’s Data Warehousing Tools: SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).

• Proficient with version control tools: VSS, SVN, TFS, and GIT. Education:

Masters in Computer Science, [ University of Central Oklahoma], Edmond, OK, USA Bachelor of Engineering in ECE, [Mahatma Gandhi Institute of technology], Hyderabad, India TECHNICAL SKILLS:

Languages and Scripting C#, T-SQL, PL/SQL, Node.js, Java, Python, C++, SQL, NoSQL, VB6, JavaScript, VB.NET, jQuery, jQuery UI, PowerShell, Jira

.NET Technologies ASP.NET (2.0-4.0, MVC 3.0-5.2, Core 2.1-7.0), .NET Framework (4.0-7.0), ADO.NET 4.6, WCF, Entity Framework (Core 3.0-7.0)

Web Technologies Angular (JS, 8, 9, 15), React (15+), HTML5, DHTML, CSS3, XML, XSLT, Bootstrap, AJAX, IIS (5.0-9.0), Blazor

Databases SQL Server (2005-2019), PostgreSQL, Oracle, MongoDB, Cosmos DB Web Servers and Services IIS (5.0-9.0), Azure API Gateway, AWS API Gateway, REST, SOAP, Web API, XML Web Services, Docker

Testing Frameworks X unit (3.0-3.9), Karma, Jasmine, SOAP UI, N Unit, SonarQube, and Selenium Version Control Tools Git (Git Flow), TFS (2018), SVN, Visual SourceSafe, Bit Bucket Methodologies Agile (Scrum), Waterfall SDLC

Cloud Technologies Azure (Cloud App Services, Integration Services, Functions, Cosmos DB), AWS

(Lambda, RDS, DynamoDB, CloudFormation, CloudWatch, CLI), CI/CD using Jenkins/AWS Code Pipeline, Databricks, Spark

Application Design/IDE Microsoft Visual Studio (2008-2022), GIT, TFS, SVN, Visual SourceSafe Operating Systems Windows (Vista, XP, Server 2003-2008, NT 2000, 8, 10, 11), Unix, Linux Reporting Tools and

Others

SSRS (2005-2019), SSIS, MS Dynamics CRM (2011-2015), AJAX Control Toolkit, Telerik, Microsoft Visio

PROFESSIONAL EXPERIENCE:

U.S. Bank - Minneapolis, Minnesota July 23 to Present

.Net full stack Developer

Responsibilities:

• Actively participated in Agile daily stand-ups, sprint planning, reviews, and retrospectives, fostering continuous improvement and collaboration.

• Convert Sybase Stored Procedures / VB6 Inline SQL & Business Logic / Rules into Stored Procedures Using T-SQL.

• Integrated REST APIs with Blazor applications, enabling real-time data synchronization and seamless communication with backend services.

• Designed and developed ETL workflows using Databricks and Apache Spark to process and transform large-scale data from multiple sources, improving data quality and accessibility.

• Developing Ontology application XQuery library for AWS based Mark Logic 9 cluster backend for NodeJS based front end application for allowing internal researchers to research chemical compounds.

• Designed custom solutions and enhancements using ASP.NET Core 7.0, Micro services and Fabric services.

• Optimized data access performance by implementing strategies such as eager loading, lazy loading, and query splitting in Entity Framework Core 7.0.

• Utilized JSON as the primary data format for efficient and standardized data exchange in RESTful Web APIs created with ASP.NET Core Web API and Angular 16 for seamless client-server communication.

• Performed validations on Web Forms using ASP.NET Core 7.0 Validation Controls and Client-Side Validation using Angular 16.

• Architected and deployed serverless solutions utilizing AWS Lambda, API Gateway, and DynamoDB, reducing operational overhead and improving scalability.

• Utilized .NET Core and Entity Framework to connect Blazor applications to databases, allowing for efficient data handling and persistence within applications.

• Responsible for designing the ASP.NET authentication using .NET Framework 2022, C#.NET, Model View Controller (MVC) 5.2.9.

• Worked on designing the architecture of API’S 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 8/9/10

• Worked on single page applications in MVVM way using AngularJS6.0, BackboneJS. Created different views for the screens in HTML 5. Created controllers to use in angular 8/9/10 views, created angular8/9/10 based http services to consume Web API& also used jQuery-based Ajax

• Ensured cross-browser compatibility of HTML 5 and CSS3 using progressive enhancement and graceful degradation techniques, while managing responsive web application behaviors with JavaScript events.

• Developed complex SQL queries, stored procedures, and views in SQL Server 16.0 for efficient data manipulation and optimized database performance. Created logical and physical data models with SQL Server Data (SSDT) or ERDs, ensuring alignment with business requirements.

• Configured CI/CD pipelines in Azure DevOps to automate build, test, and deployment processes for .NET 7, ensuring consistent and reliable software delivery.

• Involved in complete application stack in Amazon Web Services (AWS) like EC2, S3 Bucket. Environment Angular 16, HTML5, CSS3, JavaScript, jQuery, ASP.NET Core 7.0, Microservices, Node.js, ASP.NET Core Web API, OAuth2, SQL Server 2016, SSDT, ERDs, Azure API Gateway, JSON, CI/CD pipelines, Azure services (Storage, Cosmos DB, Service Bus), Docker, Azure Data Factory, SSIS, Git, jQuery, Razor engine, C#, VB.NET, Visual Studio 2022 Texas Medicaid & health care Partnership - Austin, TX Sep 2022 to June 2023

.Net Full Stack Developer

Responsibilities:

• Utilized Entity Framework 6.0 to call stored procedures and functions, combining the power of database capabilities with ORM flexibility.

• Implemented client-side JSON operations using JavaScript frameworks like Angular 14 enabling dynamic and interactive user interfaces.

• Utilized action filters and custom attributes in ASP.NET MVC 5.2 controllers to implement cross-cutting concerns such as logging, authentication, authorization, and exception handling.

• Maintained data pipeline reliability and quality through comprehensive testing, monitoring, and logging, leveraging Databricks native monitoring tools and Spark’s structured logging.

• Developed responsive and dynamic user interfaces using React 17, integrating seamlessly with .NET back-end services to provide a rich, single-page application experience.

• Designed and produced rich UI screens with HTML5, CSS3, and Microsoft Silverlight.

• Seamlessly RESTful APIs integrated with the React frontend, resulting in an improved user experience and a 50% cutback in load time. The optimized performance manifested in a 20% boost in user engagement.

• Developed serverless applications with AWS Lambda, integrating with services like S3, DynamoDB, and SNS to automate workflows and reduce costs.

• Implemented agile methodologies to design and develop software using ASP.NET; achieved a 50% reduction in software bugs and bettered overall system stability, resulting in increased user engagement and retention.

• Orchestrated regular feedback sessions with the UI team, incorporating user insights resulting in a 50% reduction in user complaints and a 20% increase in customer retention rates.

• Monitored SQL Server 14.0 performance metrics, diagnosed database issues, and implemented corrective actions using SQL Server Profiler and Dynamic Management Views (DMVs).

• Implemented performance tests using X unit 3.7 and benchmarking libraries (like Benchmark Dot Net) to measure and optimize code performance in .NET applications.

Environment: ASP.NET, .NET Framework, C#.NET, MVC, RESTful APIs, Web Sockets, Entity Framework Core 6.0, JavaScript frameworks (Angular 14), HTML5, CSS3, Bootstrap, JavaScript, jQuery, Ajax, SQL Server 2014, SQL Server Profiler, Dynamic Management Views (DMVs), X unit 3.7, TFS 2018.

Capgemini, Mumbai, India June 2018 – Aug 2021

.Net full stack Developer

Responsibilities:

• Designed ASP.NET Core 7.0 using Onion Architecture principles to achieve modular, maintainable, and scalable software solutions by separating core business logic from infrastructure and presentation layers.

• Integrated Entity Framework Core 7.0 (EF Core) as the ORM framework of choice for .NET 7.0, facilitating object-relational mapping between .NET 7.0 objects (entities) and relational database tables.

• Skilled in optimizing Spark performance through partitioning, caching, and tuning Spark configurations, leading to significant improvements in processing speed and resource utilization.

• Integrated Angular 15 with RESTful services using Http Client Module for data retrieval and manipulation, while designing a component- based architecture to enhance code reusability & maintainability in Angular 15.

• Designed user-friendly HTML 5, CSS3 forms with validation, utilizing Bootstrap for consistent UI design and responsiveness. Implemented async/await in JavaScript for efficient handling of asynchronous operations, enhancing application performance.

• Developed Razor views with strongly typed view models and helpers and partial views using ASP.NET Core MVC5, HTML5, CSS3, and Angular, C

# and Telerik controls.

• Implemented database backup, recovery strategies, and security measures in SQL Server 15.0 using tools like SQL Server Agent for ensuring data availability, disaster recovery, and protecting sensitive data through roles, permissions, and encryption.

• Creating a web 1.0 version on AWS to generate front end and backend boiler plate code and implementing the business logic into these objects. Completed a functioning prototype in Google App Script, App Sheet, & Google Sheets.

• Worked in configuring alerting methods via ansible playbooks for machineconfigs, PV, PVC and all the OpenShift 4.x components to alert support teams.

• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding, interactivity using SSRS.

• Resolve Defects to existing VB6 Application by Referencing detailed requirements to Identify the cause of the defect.

• Effectively used jQuery/jQuery UI to enhance the web application's user interface and coded efficiently in C#.NET, applying .NET 7.0 techniques such as lazy loading and reflection.

Environment Agile, ASP.NET Core 7.0, ASP.NET Core Web API, Entity Framework Core 7.0, OAuth2, Angular 15, HTML5, CSS3, Bootstrap, JavaScript, SQL Server 15.0, RabbitMQ, X unit 3.9, Karma, Jasmine, SOAP, Git, Azure DevOps, Azure Functions, Azure services (Storage, Cosmos DB, Service Bus), Docker, Azure Storage SDKs (Blobs, Queues). jQuery, C#.NET.

Contact this candidate