Post Job Free

Resume

Sign in

.Net Core Sql Server

Location:
Edison, NJ
Posted:
March 20, 2024

Contact this candidate

Resume:

Name: Akhil

Call: 484-***-****

E-Mail: ad4gpj@r.postjobfree.com

Professional summary:

* ***** ** ********** ** the design, development, implementation, testing and maintenance of complex Software and Database applications.

Experience in all the phases of System Development Life Cycle (SDLC) such as strategy and analyzing, designing, building (coding), testing and documentation of software products.

Proficiency in Architecture, Administration, Development, Testing and Deployment.

Worked extensively with Iterative Agile Methodologies, Waterfall methodologies and Test-Driven Development.

Expertise in setting up Developers Virtual machine and QA machine to be production like for agile testing.

Solid understanding of newly introduced features in .NET 4.7/4.6.1/4.5/4.0/3.5/3.0 like WCF (Windows Communication Foundation) and LINQ (Language Integrated Query Language).

Experience in working with Content Management Systems like Sitecore.

Significant experience in the Database design and development of Stored Procedures, Functions, and Triggers for the implementation of data integrity using T-SQL and PL/SQL.

Experienced in developing web applications using MVC4/MVC3 ASP.NET, ASP.NET 3.5/3.0/2.0/1.1, .Net Core, AJAX, VB.NET, C#, ADO.NET, SQL Server 2015/2012/2008R2/2008/2005 and Oracle 9i/10g, Entity Framework.

Extensive experience in handling Internet Information Server (IIS), Creating and configuring the virtual directories, map them to physical folders and configuration of the applications for domain authentication, Data Transformation Services (DTS) in SQL Server 2008R2/2008/2005.

Experience in developing the business reports using SSRS, SSIS and developing SSIS packages.

Supported Extract, Transfer, Load (ETL) efforts using Integration Services tools. Created, configured, modified and tuned SSIS packages.

Experience in developing Restful services using REST, SOAP and ASP.NET Web API’s. Also performed Crud operations such as POST, GET, PUT, PATCH and DELETE.

Expertise in writing unit tests and integration tests using N-Unit framework.

Experience in software Analysis, Design, Development, Testing, Implementation and production, support of Client/Server and Web based applications.

Professional experience in designing UI web applications using front-end technologies like HTML/HTML5, CSS/CSS3, JavaScript, TypeScript, SCSS, XML, DHTML, jQuery, AJAX, JSON, AngularJS, Angular10/11/12, ReactJS, BootStrap4.

Expertise in performance tuning SQL Stored Procedures.

Experience in designing and developing Microservices for the business components using .NET framework.

Designed and implemented the application using Microservice Architecture for its various distinct advantages like loose coupling and design patterns.

Design, develop, test, maintain web applications using Blazor and also leverage Blazor components to build interactive and responsive user interfaces.

Good experience with Microservices, AWS (Amazon Web Services) working with EC2, S3, EBS, Kubernetes, docker.

Good experience with Azure Active Directory.

Experience on different version control systems like MS Visual Studio TFS, Git, SVN

Experience in creating CI/CD release pipelines using Jenkins/GitLab.

Deployed the applications to Microsoft Azure cloud environments and configured CI build jobs.

Experience in building Continuous Integration (CI) & Continuous Deployment/Delivery (CD) pipeline as an iterative process using Azure CICD Pipelines.

Implement and maintain Azure Active Directory.

Experience with container-based development using docker.

Experience working with JIRA, TFS, DevOps ADO and Confluence.

Followed best practice development processes including rapid sprints, Kanban, Agile SCRUM methodologies.

Knowledge in maintaining user interfaces using React.js.

Technical Skills:

Languages

C#, .NET, VB6, VB.NET, C, C++, SQL, PL/SQL, and T-SQL.

.NET Technologies

.NET Core 3.1, .NET Core 5, Angular with NgRx, ASP.NET, VB.NET, C#, ADO.NET, MVC, MVVM, MVP,WCF, WPF, Entity Framework, SiteCore, LINQ, RESTful, SOAP, Microservices, Web API, Mobile Apps, N-Unit.

Web Technologies

HTML5, DHTML, XML, CSS3, JavaScript, Power Shell Scripting, XML, XHTML, DHTML, XSL, SOAP, Web Services, Web Services, REST, jQuery, Bootstrap, React, Blazor, PrimeNG, KendoUI, AngularJS, AJAX, Ajax, FullStack, Java, Python, Powershell, Ruby, Perl, Bash/Shell, Groovy, YAML.

CMS

Sitecore 7.5,8.2, SharePoint Enterprise Content Management.

Database

MySQL, SQL, Oracle 9i/10g/11g, DB2, NoSQL (MongoDB, DynamoDB), PostgreSQL, Cassandra, Microsoft SQL Server, KAFKA

Development Tools and IDE

Visual Source Sage, Jira, Source Tree, Visual Studio, Android Studio, Visual Studio Code, Eclipse IDE, NetBeans

Middleware

Web services, WCF Services, TOAD, SQL Server Integration Services.

Web Servers

Internet Information Server (IIS 6.0/7.0/8.0), TFS Server, GitHub.

Reporting Tools

SSIS, SSRS

Operating Systems

Windows 10/8/7 Windows Server 2008/2012.

Testing

Smoke Test, N Unit test, Test cases.

Message Queues

Rabbit MQ, Active MQ.

.Net Frameworks

4.7/4.6.1/4.5/4.0/3.5/3.0

Version Control Tools

SVN, Team Foundation Server 2010/2008, Azure DevOps, Github, Bitbucket, CVS

CI\CD Tools

Jenkins, Hudson, Bamboo, Nexus, Artifactory, SonarQube

Professional experience:

Client: Optum, TX Jan 2022 to Till now

Role: FullStack .Net Developer

Responsibilities:

•Actively participated in daily SCRUM meetings.

•Involved in all stages of the Software Development Life Cycle (SDLC).

•Implemented the VCCD application using .NET technologies and followed Agile methodologies.

•Conducted meetings with business stakeholders to gather sprint requirements, collaborating with QA and IT teams for story pointing and understanding user stories.

•Participated in sprint retrospective meetings to assess what went well and areas for improvement.

•Addressed and resolved issues reported by agents across UHG and Optum using the VCCD tool and Service Now incidents.

•Coordinated with the business team to align changing requirements with project goals.

•Collaborated with multiple teams to support and resolve agent issues.

•Participated in weekly PROD control meetings discussing deployment-related changes.

•Managed incidents and change requests using ServiceNow (SNOW).

•Proficient in deploying and managing AWS services such as VPC, Route 53, ELB, EBS, EC2, and S3.

•Integrated the Front-End web interface with Angular 11, JSP, HTML, and CSS.

•Developed continuous integration and deployment pipelines using VSTS/TFS/Bamboo on Azure DevOps.

•Utilized Microsoft Visual Studio 2017 and 2019 for VCCD application development using VB.Net.

•Employed Object-Oriented methodology in VB.Net and developed Restful API Webservices for Outlook using EWS Library.

•Designed, developed, and maintained the VCCD windows application using .NET technologies such as VB.Net, ASP.Net, WCF, WPF, C#, .Net framework, and .Net core.

•Implemented robust error handling with try-catch blocks and extensively used .Net base classes.

•Designed and developed enterprise POC web applications using MVC5, C#, REST API’s, MVC, HTML5, CSS3, JavaScript, and AngularJS.

•Created reusable user controls in VB.Net.

•Developed supporting applications like Media Management and TFN DB for Business users.

•Worked on the VCCD admin tool, responsible for managing agents from different business units.

•Utilized GitHub for source version control.

•Managed SQL Server 2016 for all database activities, creating stored procedures, views, and triggers.

•Involved in unit testing and created test cases using N-Unit.

•Used SPLUNK to check application logs and server failures, and created dashboards for server health and stats.

•Implemented alerts and notifications on TEST, Stage, and PROD servers using DYNATRACE.

•Used SONARQUBE for bug tracking, code quality, and application security.

•Utilized RALLY for user stories, bug tracking, and maintaining the sprint board.

•Created RDX files to keep servers updated and used RESTful API services like Dropwizard framework.

•Collaborated with application teams to understand current applications and make migration recommendations in AWS.

•Used Remote Desktop Connection Manager to access servers.

•Utilized IIS10 to build and manage applications in test, stage, and prod servers.

•Conducted smoke testing after every deployment to ensure application functionality.

•Used XML in SOAP for data transfer and XSLT for transformations.

•Provided 24*7 application support, joining war rooms to address high-priority issues.

•Worked on new features of Angular 11, such as new if-else syntax, ng-templates, and form validators.

•Participated in war rooms to address issues on a high priority basis.

Environment: Visual Studio 2017& 2019, .Net Framework 4.8, .Net core 2.0, Internet Information services 10, VB.net, C#, HTML5, CSS3, JavaScript, Angular JS, Bootstrap, jQuery, ASP.NET4.5, ASP.NET Core, WPF, Github, NUGET package manager, SPLUNK, SONARQUBE, Rally, Dynatrace, SQL Server 2016, Azure ADO, Kendo UI, Bootstrap, Sitecore, KAFKA, React.js, REST, Microservices.

Client: Cisco, TX March 2019 to Dec 2021

Role: Sr. .Net Developer

Responsibilities:

•Actively participate in daily SCRUM meetings.

•Implement Agile/Scrum software development methodology.

•Participate in story grooming sessions with the development team, QA, and product owners for upcoming sprints.

•Engage in retrospective meetings after each sprint to discuss successes and areas for improvement.

•Utilize Microsoft Visual Studio Enterprise 2017 for daily development activities, specifically for the Dunkin mobile application.

•Implement REST APIs with microservices using ASP.NET Core.

•Design and develop microservices for business components using the .NET framework.

•Develop enterprise applications using .NET framework, SQL Server, MVC5, C#, REST APIs, MVC, MVVM, and .Net Core APIs.

•Create RESTful and SOAP Web API services using C#.NET to generate data consumed by AngularJS.

•Modify and write enterprise services in C# to interact with other applications and expose them using SOAP and HTTP protocols.

•Use ASP.NET Web Service to leverage RESTful Web services and implement N-tier architecture.

•Develop ERP solutions using the Microservices architecture.

•Experience in migrating data between different TFS platforms and managing code and version control with Git and GitHub.

•Conceive software design, including microservices, and contribute significantly to coding.

•Assist the team in creating data flow diagrams and class diagrams for all APIs.

•Implement CRUD operations using $http service and test APIs using Postman.

•Work with web APIs for GET, PUT, POST, and DELETE operations, ensuring proper functionality.

•Utilize Git and GitHub for code management and version control, maintaining a branch strategy for development.

•Experience with project management tools such as Team Foundation Server, JIRA, and GIT.

•Use various sources to pull data into Power BI, scheduling automatic refresh in Power BI service.

•Create, modify, and alter database components using SQL Yog, MySQL Workbench, and SQL Server.

•Engage in report development for QNXT and custom SSRS reporting.

•Coordinate custom web application database schema, involving tables, relationships, stored procedures, queries, and views interacting with QNXT.

•Implement deployments using TeamCity, running build, promote, and deploy jobs after each code commit.

•Use Microservice architecture with AWS for testing, building, and deploying identity microservices.

•Manage the complete application stack in AWS, including EC2 and S3 buckets.

•Work with AWS services such as EC2, S3 buckets, and Route 53.

•Update web configs post-sprint based on code changes, uploading to S3, and deploying using TeamCity.

•Upload asset changes to S3 and perform Elastic search and Logstash performance tuning.

•Utilize X-pack for monitoring and security on Elastic search 5.6.4 cluster.

•Provide global search functionality with Elastic Search.

•Conduct debugging sessions to solve bugs and issues.

•Design, develop, test, maintain web applications using Blazor and also leverage Blazor components to build interactive and responsive user interfaces.

•Use SPLUNK to check error logs across production, QA, and dev environments.

•Employ FIDDLER for web debugging and recording HTTP/HTTPS traffic.

•Utilize SONARQUBE for tracking bugs, security vulnerabilities, code reliability, application security, and technical debt.

Environment: ASP.NET4.5, Visual Studio 2015, Blazor, VS 2017, SSDT 2017, Internet Information services 10 (IIS10), MVC 5, MVVM, C#.Net, DHTML, SQL Server 2014, Microservices Architecture, SQL server 2016, JIRA, Confluence, Git, GitHub, SourceTree, AWS, Microservices, Amazon S3, AWS EC2, Elastic search TeamCity, Postman, Fiddler, HTML5, CSS3, JavaScript, JSON, SQL Yog, MY SQL workbench, React, REST, VB.NET, Angular 5, PHP, Bootstrap, CSS, HTML.

Client: National Life Group, Montpelier VT Jan 2018 to March 2019

Role: Sr. .Net Developer

Responsibilities:

•Actively participate in daily SCRUM meetings.

•Analyse business requirements from clients.

•Manage incidents related to National Life's public portal using SNOW (Service Now).

•Track and resolve incidents on the public portal based on incident priority.

•Support daily operations of the website, including break fixes and enhancements to the Sitecore platform.

•Utilize Microsoft Visual Studio 2017 and 2015 Professional, as well as SQL Server 2016, for necessary business enhancements.

•Employ Microsoft Team Foundation Server (TFS) and GIT for version control and file sharing.

•Use monitoring tools such as New Relic APM, Google Analytics, and a custom monitoring tool for application monitoring and issue resolution.

•Maintain the Sitecore application using Sitecore 8.2, implementing content changes based on business requirements.

•Use View Renderings and Controller Renderings extensively in Sitecore.

•Implement Sitecore MVC design pattern for web application development and leverage Sitecore CMS for responsive HTML5 and CSS3 websites.

•Use Unicorn, an open-source tool, for managing Sitecore content and performing unicorn Sync when needed.

•Utilize Sitecore API for various tasks and create a Sitecore Helper class for common Sitecore operations.

•Make extensive use of the glass mapper ORM.

•Implement Sitecore content using WEB API and consume it with Angular JS on the front end.

•Implement Sitecore publish/sync mechanism for publishing changes in different environments.

•Stay current with industry trends to create Sitecore CMS websites.

•Utilize NUGET for server-side libraries and Bower for client-side libraries.

•Code and create Stored Procedures for repetitive tasks using SQL Server 2012 database.

•Use SONARQUBE to fix bugs and increase code coverage.

•Track user stories and bugs using JIRA.

•Monitor web server logs using SPLUNK.

•Configure and manage Azure Active Directory connect, Azure AD Health, and Microsoft Azure Active Directory.

•Use Azure as part of the CI/CD pipeline.

•Host and manage application and database servers in Azure.

•Configure Azure cloud service for endpoint deployment.

•Use Log Analytics service in Azure to monitor the cloud environment for availability and performance.

•Create Azure dashboards to monitor health and metrics of application and database servers.

•Have hands-on experience in IAM requirement analysis, implementing Access Gateways, SAML, OAuth, based integrations, and web access management.

•Be familiar with Azure Service Bus and Service Bus triggers.

•Implement Azure Logic Apps, Azure Functions, Azure Storage, and Service Bus queues for large enterprise-level ERP integration systems.

•Perform SSO connections in Azure technology standards with SAML 2.0.

•Work on application Gateway while integrating SSO to Azure Portal.

•Collaborate with project teams on implementing defined business roles within Access & Identity Management.

•Perform failback procedures from PROD to DR and DR to PROD servers in case of server downtime.

•Install DIGICERT certificates in various PROD and UAT servers, replacing existing Symantec certificates.

•Maintain Development, Staging, and Production (load-balanced) servers, providing 24/7 support to ensure no downtime.

•Monitor and provide front-line support for daily processes.

•Plan, design, and implement application database code objects, such as stored procedures and views.

•Design, develop, test, maintain web applications using Blazor .

•Analyse existing SQL queries for performance improvements and develop procedures and scripts for data migration.

•Ensure best practices are applied, and data integrity is maintained through security, documentation, and change management.

Environment: Sitecore 8.2, ASP.NET4.5, Visual Studio 2015, VS 2017,SSDT 2017,Internet Information services 10 (IIS10), MVC 5, MVVM, C#.Net DHTML, AJAX, SSRS, Blazor, React, SSIS, SQL Server, WWF,WCF, SSRS, TFS, HTML5, CSS3, JavaScript, Bootstrap, jQuery, angular.js, JSON, SNOW, SharePoint, Azure, JIRA, KAFKA.

Client: SVB, CA Dec 2016 to Nov 2017

Role: .Net Developer

Responsibilities:

· Design and develop various abstract classes, interfaces, and classes to construct the business logic using C#, and ADO.NET.

· Worked as a .Net Developer as part of the team in designing and developing the applications using Visual Studio 2015 .Net Framework 4.6.2, C#.NET, ASP.NET MVC 5 with Entity Framework 6, SQL Server 2015, and LINQ.

· Followed Agile Methodology which involves daily Scrum meetings and Sprint meetings (planning, Review, Retro) to meet deadlines and expectations.

· Design develops and unit test the application and assist in maintaining program libraries, user manuals and technical documentation using various programming languages as per the needs of the project which include ASP.NET, C#, J Query, Visual Studio 2015, MVC 5 Framework, Razor View Engine, WCF, Microsoft SQL 2012, OOAD, Entity Framework, LINQ, AngularJS, HTML, CSS.

· Developed WCF services for both Desktop and mobile applications.

· Azure Cognitive Services using Azure Machine Learning and HDInsight.

· Experienced with common tools like GitBash, Git Extensions, Source Tree, Visual Studio 2015, Visual Source Safe, and TFS

· Write functionality using observable patterns and models in Angular 8.

· Experience with ASP.Net MVC by Using the Razor View Engine, JavaScript, HTML5, CSS3, Bootstrap, Triggers, Views, and Stored Procedures.

· Extensively worked in Entity Data Model for implementing Business logic and Data Layer using Entity Framework 6.0.

· Designed and Developed dynamic webpages using Bootstrap, JavaScript, and JQuery.

· Implemented AngularJS Controllers to maintain each view data.

· Experience with Agile Methodology and Test Driven Development

· Developed UI using ASP.NET AJAX, ASP.NET 4.6, HTML5, CSS3, and JavaScript

· Worked extensively on TELERIK UI (Kendo UI) controls. Implemented bootstrap menus, buttons, and various other controls.

· Developed single-page applications using Angular 2 and TypeScript.

· Development experience in C#, XAML for Silverlight applications, and web applications for Microsoft SQL Server.

· Responsible for code merging using Microsoft Team Foundation Server (TFS) and for other source code maintenance needs.

· Used Team Foundation Server (TFS) for version control of the source code along with the maintenance of the builds and the relevant documents of the same.

· Migrated the application from Infrastructure as a Service (IaaS ) to Platform as a Service ( PaaS ) by converting the existing solution to Windows Azure Worker Role

· Integrate Azure Cloud PaaS Application server for running scheduler task

· Developed views using Razor view engine, HTML5, CSS3, and jQuery.

· Developed Restful web services using Windows Communication Foundation and Web API.

· Implemented the Dependency Injection for unit testing and reusable components.

· Entities in the Data Layer using the Entity framework

· Creating, and modifying SQL queries, Stored Procedures, Functions, Views, and CTE to handle the data integrity for various data transactions in SQL Server 2015.

· Created Indexes, Stored Procedures, Triggers, and Views using SQL Server 2015.

· Used Microsoft Team Foundation Server as a repository for source control of applications.

· Fixing production defects and regress testing the system.

· Involved in Debugging and Supporting the application and Performed Unit Testing (using N-Unit and MS-Unit).

Environment: .Net Framework 4.5/4.7, C#, ASP.NET MVC, ADO.NET, Entity Framework, Azure, LINQ, Angular 8, JavaScript, Ajax.Net, JQuery, Web-API, WCF, SOA, Classic ASP, HTML, SQL Server 2014/2016/2018, Azure, Web Services, MS Excel.

Environment: ASP.NET4.5, Visual Studio 2013, IIS8, MVC 5, MVVM, C#.Net DHTML, AJAX, Rest, SOAP 5.0, SSIS, SQL Server 2012, WWF, WCF, SQL Server Reporting Services (SSRS), Facets, HTML5, CSS3, JavaScript, Bootstrap, jQuery, angular.js, JSON, Azure.

Client: XILINX, CA Dec 2015 to Nov 2016

Role: .Net Developer

Responsibilities:

· Analyzed the requirements and prepared the analysis report.

· 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 the User Interface using Win-forms.

· Source Code implemented using C#.NET

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

· Developing User Control for Common Functionality in ASP.NET.

· Performed validations using Validation Controls.

· Created Unit Tests for testing the developed services and ensured the code was developed according to the client coding standards.

Environment: C#, .NET Framework 3.5, ASP.NET, MVC 4.0, MS Visual Studio 2012, XML, Supply Chain domains, Visual Source Safe (VSS), ADO.NET, HTML 4/5, T-SQL, MySQL, WEB API, Web Services, reverse engineering, XML, JavaScript, AJAX, XSLT, IIS, LINQ, WCF, T-SQL, SQL Server.

Client: Grape Soft – Hyderabad, India June 2013 to June 2014

Role: .Net Developer

Responsibilities:

•Extensive experience in developing applications using Visual Studio .NET technologies such as C#, ASP.NET, ASP, ADO.NET, XML, Web Services, Silver Light, WCF, WPF, WWF, MVC, and MVVM.

•Developed DL/BL classes using C#, .NET, ADO.NET, and SQL Server within the context of MVC 4.0.

•Gathered user requirements and designed the framework using UML, including identifying use cases, drawing use case diagrams, identifying classes, and creating class diagrams and sequence diagrams.

•Reported bugs through email notifications to developers using TFS.

•Worked on SQL Queries, Triggers, Backup and Restore Database, defining roles, creating database users, and assigning roles to users using SQL Server 2005.

•Created queries and stored procedures for efficient database access.

•Implemented extensive try-catch blocks throughout the development cycle to ensure proper exception handling and logging.

•Created a Setup Package (.msi) and compiled applications in debug and release modes using Visual Studio .NET 2005.

•Participated in the full software development lifecycle.

•Prepared project plans using Microsoft Project.

•Conducted unit testing, integration testing, and regression testing.

•Called and/or participated in periodic meetings with the project manager to assess and identify main risks to the release items and implement processes to minimize them.

•Implemented the code behind in C#.NET.

Environment: C#, .Net, ADO.Net, VisualStudio2008, SQL Server 2005, WCF, WWF, TFS, JavaScript, .Net Remoting, Microsoft Project, MVC 4, Entity Framework, Sitecore, React, HTML, CSS, jQuery, Angular JS, JavaScript, RESTful & LINQ.



Contact this candidate