Post Job Free

Resume

Sign in

C# Sql Server

Location:
Dublin, OH
Posted:
July 25, 2023

Contact this candidate

Resume:

Anurag K

.Net Developer

EmailId: adyihq@r.postjobfree.com

Direct: +1-614-***-****

PROFESSIONAL SUMMARY:

Around 9+ Years of experience in IT Designing and Developing Web Applications, Windows n-Tier architecture development usingObject Oriented Analysis and Design OOAD using Microsoft Technologies and.NET Framework (4.6/4.5/4.0/3.5).

Extensive experience of designing and developing software applications with the C#.NET /VB.NET, ASP.NET Web Forms, ASP.NETMVC, ADO.NET, AJAX, WCF, Web Services, SOAP and RESTFUL Services, Visual Studio 2010/2012/2013/2015/2017,2019.

Experience in Agile software development methodology and Test-driven development (TDD) including SCRUM Framework.

Good knowledge with the latest industry trends in UI design, Responsive Web Design, Bootstrap.

Extensively used HTML5, BOOTSTRAP, ANGULAR JS and jQuery and created Single Page Applications (SPA).

Design, develop and test HTML5, CSS3, Bootstrap, JavaScript, jQuery and React.JS that meets accessibility and web browser standards for website.

UI Frameworks like Angular JS 1.X, Angular 8/9/10 and React JS.

Hands-on experience in Azure cloud worked on Azure web application, App services, Azure SQL Database, Azure Blob storage, Azure Functions, Virtual machines, Fabric controller, Azure AD, Azure Data Factory, Azure Service Bus, and notification hub. Proficient in using Azure service fabric to package, deploy, manage scalable and reliable micro services and containers.

Created and maintained various DevOps related tools for the team such as provisioning scripts.

Used Azure analysis services to monitor failures in systems.

Experience in moving data between GCP and Azure using Azure Data factor.

Experience working for Spark clusters in Azure cloud and working with ADLS.

Created different SSIS packages to load data to the new environment from external data sources like oracle, flat files, and csv files.

Good experience on creating Use Case specifications for Service- Oriented Architecture (SOA) services.

Expertise in ASP.NET MVC (5.2/4.0) and developed the features Views, Partial Views, Strongly Typed Views, Sections, Areas etc. and implemented Controllers and Controller Actions, Filters, Routing.

Extensive experience of web services, rest API testing using SoapUI, Rest, Restful API, Swagger and Postman.

Building React JS applications using Typescript and SPA frameworks. Worked on functional components and react web hooks as using React JS.

Designed, Architected, and coded an end-to-end working Chatbot that includes RESTful Web API service in .Net Core, Angular based UI with Angular Material controls and Python based Data Science Layer.

Used various Angular custom directives and developed reusable components and templates that can be re-used at various places in the application.

Experience in working on Kafka, RabbitMQ, Azure Event Hubs,

Experience in using Web Server IIS 7.5/7.0/6.0 during application deployment.

Extensive Experience with ORM technologies like Entity Framework Database Model first and Code First approaches and performance tuning in Entity Framework 6.0.

Strong experience in server-side technology like .Net Core and Standard framework to design and create RESTful based Web API services.

TECHNICAL SKILLS:

.NET Technologies

.NET Framework (6/5.0/4.5/4.0/3.5), ASP.NET, ADO.Net, WPF, WCF, MVC (5.0/4.0/3.0/2.0)

Languages

C# (4.0/3.0/2.0). NET, LINQ, Entity Framework, JavaScript, AJAX, VBScript, jQuery

Development Environment

Visual Studio 2017/2015/2013/2010/2008

Web Technologies

HTML, XML, XSLT, XPATH, XSL, IIS (7.0/6.0/5.0), CSS, SOAP, WSDL, UDDI, XML Web Services, Bootstrap.

Database

MS SQL Server 2008/2012/2017, Oracle 9i/10g/11g, MS Access.

Web / Application Server

IIS 6.0/7.0

Operating System

Windows 10/8/7, Vista, Windows XP/NT/2000, Linux

Integration Services

SQL Server Integration Services (SSIS).

Reporting Tools

SQL Server Reporting Services (SSRS), Crystal Reports

Version Control Tools

TFS and GIT

PROFESSIONAL EXPERIENCE:

Client: State of Ohio Aging Columbus, OH. July’2022 -Till Date.

Role: .Net Full stack Developer.

Responsibilities:

CCC (Covid Care Centre) is a public portal build in angular 11 and dot net core framework to help monitor and distribute support to reduce COVID 19 impact. This portal is used by resident care facility, intermediate care facility, skilled nurse facility, pharmacist, ODH and ODA employees.

This application is consisting by facility, testing program selection, vaccine program selection, reporting tool, Crisis staffing report module. User can access different screens and modules based on their roles and user types. Application also has built in notifications with emails and text messages.

Worked on the MVC architecture of Angular 11 in developing the apps, controllers and directives which are totally customized to meet the needs of the application.

Used SQL Developer Oracle to Write Queries and stored Procedures.

Experience in all phases of SDLC including Architecture, analysis, design, coding, testing, and deployment for N - tier client/browser-server applications using .NET Framework technologies-ASP.NET, C#, ADO.NET, VB.NET, jQuery, JavaScript, Angular 11, LINQ, AJAX, WPF, WCF, Web Service and IIS7/6.

Developed technical documentation to define the system components, development environment and implementation planning/strategies.

Experience to automate Excel, create Excel solutions, and understand globalization issues specific to Excel.

Understand QNXT data table and Schema definitions. Validate data housed on DBs, ensure adherence to business and system requirements.

B2B Architecture and REST APIs using .Net Core, WEB API, Angular 11 SPA.

Responsible for maintenance of applications with technologies such as .NET C#/Oracle/jQuery/HTML5/JavaScript/Angular/Bootstrap.

Designed and developed web pages usingAsp.net, MVC3.0, C#, Entity Framework, JSON, HTML 5, CSS3 and jQuery.

Developed and maintained CI/CD pipelines using Azure DevOps and GitLab, resulting in faster and more reliable deployments.

Created managed code with Office solutions, including how to customize the Office user interface, work with data, and troubleshoot problems.

Used SQL Developer Oracle to Write Queries and stored Procedures.

Created Angular Components to Display API Data.

Environment: .NET Framework 4.8, Visual Studio 2019, MVC 3.0, C # 6.0, Entity Framework, AJAX, jQuery, JSON, XML, XSLT, JavaScript, SQL Developer, SQL Server Management studio2019, GIT, IIS, HTML 5, CSS, Angular 11.

Client: VERIZON, Hilliard, OH. Oct’21-June’22

Role: Net Full stack Developer.

Responsibilities:

Implemented the project according to the Software Development Life Cycle SDLC and programming by using fast paced agile methodology, involving task completion, user stories, and iterations.

Implemented abstract, sealed classes, interfaces, and classes to construct the business and data tier using C#, Asp .net and Entity Framework.

Used React Router for client-side routing and Axios for making asynchronous HTTP requests.

B2B Architecture and REST APIs using .Net Core, WEB API, ReactJS SPA.

Created custom filter in React.JS in the application.

Utilized the features of Angular 11 to present effective web design.

Worked with Azure Service Fabric to create distributed systems platform to deploy package and manage scalable and reliable microservices and containers.

Created a web API with ASP.NET Core and MongoDB.

Extensively used Asynchronous JavaScript Calls to do data processing.

Worked on .NET Security features such as Authentication Authorization, Forms-based Authentication, Authorizing Users, Roles and User Account Impersonation, tracing.

Used SSRS for developing reports for analysing the inflow and outflow of different documents, tickets.

Used Bootstrap CSS model adaptability framework for styling the application.

Created a backend REST Web API backend service .Net Core and Code First Entity Framework Sql.

Experience in working Azure Message Queuing.

Worked on Team City and octopus to Implement CI/CD

Written SQL Scripts, for creating database tables with foreign key relations in SQL Server 2008/2012 using T-SQL.

Working and Knowledge on Understanding Protocols using TCP/IP.

Designed and developed several SQL Server Stored Procedures, User defined Functions, Triggers and Views for all the DML functionality of the application.

Created User Interface pages with Razor views and partial views.

Experience With Embedded Hardware Checking PC Routers Connections.

Environment: .NET Framework 4.8, Visual Studio 2019,2022, Asp.net, MVC 3.0, C # 6.0, Entity Framework, AJAX, jQuery, JSON, XML, XSLT, JavaScript, SQL Server 2008, SQL Server Management studio 2012/2014, LINQ, T-SQL, WCF, IIS, Angular 11, HTML 5, CSS.

Client: GCR Inc, Columbus, OH Aug’19-SEP’21

Role: .Net Developer

Responsibilities:

Building and implementing software for the Florida Secretary of State form filings for use by internal staff through a Cenuity in-house application and by the public sector through Cenuity on-line portal.

Agile development with issue tracking and documentation via TFS and SharePoint.

understand Client Requirements provided by BA team and Developed Web Applications.

Experience in working with concepts of OOPS with C# 4.5.

Successfully utilized code-first approach to design the database in the .NET environment by using FC# in the ASP.net MVC5 environment.

Worked on Visual Studio 2015/ .Net CORE 1.0 Framework to implement Business Logic.

Involved in Debugging C# and JavaScript code using Visual studio 2017.

Used HTML4, CSS3, Bootstrap, AJAX toolkit and JavaScript to design a user-friendly, responsive UI and achieve the consistent look and feel of the website.

Worked in using React JS components, Forms, Events, Keys, Router, Animations and Flux concept.

Enhanced application performance by Angular 6 Component based development in view of future Angular framework transitions.

Build a Cassandra app with .NET Core and Azure Cosmos DB.

Used jQuery to bring dynamic behaviour to the web page, and for AJAX calls to the MVC controller to output JSON result.

Experience with various Azure data storage solutions such as Azure Cosmos DB, Azure Data Lake Storage, and Azure Blob Storage.

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 AngularJS.

Involved in designing templates using Rich Text Editor.

Experience on knockout.js

Environment: C#, ASP.net MVC, Visual studio 2017, .NET Framework 4.6/EF Core 2.0, SQL Server 2014, LINQ, IIS Express, Webapi2.0, TFS, Angular 6, SharePoint, SQL Server Management studio2014,

Client: City National Bank, Los Angeles, CA Aug’17 – Jul’19

Role: .Net Developer

Responsibilities:

Agile development with issue tracking and documentation via JIRA and SharePoint.

API and .NET MVC website development and deployment via IIS and Visual Studio.

Exposure to current .NET development trends such as software architectural design patterns and SOLID design principles.

Design and Developing Microservices, mock creation using N-Unit Test Cases.

Developed RESTful web services using Web API for getting Sales History with JSON as the data exchange format.

Implemented an asynchronous Blazor Web Assembly UI for visualizing the authentication process and keeping track of steps between integrated APIs.

Source control using GitHub Enterprise and a feature, develop, and master Git branching strategy.

Experience working with (consuming) REST or GraphQL APIs via client-side JavaScript or server side via NodeJS.

Hands on experience with IoT PaaS Azure-IoT.

Wrote SQL scripts and extensively designed and developed Stored Procedures, Functions and Packages in SQL Server 2012 to execute various database routines.

Increased team productivity and automated repetitive tasks by using batch files, Power Shell.

Worked with SSIS to convert Database views from one database to Tables in other DB’s.

Created SQL Queries for the SSRS Reports, Crystal Reports and Improved the performance of queries by applying indexing on them.

Strong understanding of Debit and Credit processing at Mobile Point of Sale including PIN debit, Chip and Pin/EMV processing worldwide

Created custom fully automated solution using Windows PowerShell to export individual mailboxes from the Exchange environment and save them as separate PST files.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions, packages for moving the data from staging area to data mart.

Environment: C#, ASP.net MVC, VS 2017, Source Tree, GIT, RESTFUL services, .NET Framework 4.6/EF Core 2.0, LINQ, IIS Express, SharePoint, SQL Server Management studio2012.

Client: CGIT, HYD-INDIA. May ‘12–Nov ‘15

Role: .Net Developer

Responsibilities:

Implemented business logic using C#.

Implemented TDD, Unit Testing, Integration Testing and System Testing using NUNIT.

Modified and designed existing features and display them in the contacts tab of competition in WPF Application using XAML, C#, Win Forms and Entity Framework.

Experience with migrating code from Development through Production while creating customization web parts and Workflows.

Work closely with architect and clients to define and prioritize their use cases and iteratively develop APIs and architecture.

Created essential components for windows-based applications using WPF.

Involved in unit testing, integration testing and deployment of the application.

Software processes Implementation through SVN (SDLC &Agile (Scrum, Kanban).

Understanding the functionality and business requirements of the project.

Creating UI screens using XAML, interacting with various layers using MVVM and MVP Design pattern.

Developing utility in Agile Environment, involved in daily stand-up meetings.

Encrypting and Compression the data to be written to Image file using third party libraries.

Implemented Template Columns for Custom Nested Grid Views, creating print labels using ZPL commands.

involved in the support and maintenance of the application during production phase.

Creating unit test cases for the presenter and Model using NUnit.

Run common user workflows to detect memory leaks.

Communicating to QA team regarding latest releases, test cases and fixes.

Refactoring code based upon code review meetings.

Environment: Visual Studio 2013, Entity Framework, C#, LINQ, SVN, WPF, MVVM, Windows 7, NUNIT, Asp.net.

EDUCATION DETAILS:

Bachelors in CS from JNTUH College Hyderabad (2012).

Masters in CS From Virginia international University (2017).



Contact this candidate