C# Sql Server

Anil Karuturi

Ph: +1-214-***-****

Email: ad7xjk@r.postjobfree.com

Professional Summary:

* + Years of Experience in the IT industry, involved in Software Development Life Cycle (SDLC) including design, development, implementation, testing, integration, deployment, documentation and maintenance of Web and desktop applications using Microsoft .NET Technologies

Strong Experience in C# and ASP.NET focusing on creating web-forms

Hands on experience in working with different OOPS Techniques and Microsoft’s ASP.NET MVC 4, MVC 5.

Experience in advanced subjects like Entity Framework, LINQ and Windows communication foundation (WCF).

Experience with Web Service, WCF (Windows Communication Foundation) and ASP.NET Web API.

Strong knowledge of various procedural and object-oriented programming languages such as C#

Extensively worked on Bootstrap using CSS, HTML and JS framework.

Experience in using .NET Server Controls, Web User Controls, Data Grid, Web-Control, and Form Validation Controls

Worked Extensively in developing web forms using jQuery, HTML and CSS, Angular6.

Worked with both SQL Server and Oracle as backend and used ADO.NET to access them

Extensively worked on SQL server integration service (SSIS).

Have hands on experience followed on Factory and Dependency injection design patterns

Experience in writing complex Functions, Triggers, SQL Queries and Views using SQL Server 2008,2012,2016

Broad understanding and implementation of AGILE methodology for system design and development

Experience using Microsoft Team Foundation Server (TFS) for version Control

Experienced in Design patterns like Singleton Pattern, Abstract Factory Pattern

Developed Web API using Swagger tools and used for testing.

Good understanding of Micro services Architecture.

Commitment and conformance to delivering quality applications adhering to deadlines

Hardworking, enthusiastic and highly committed to the growth and success of the organization

Good analytical and communication skills and ability to effectively communicate with all levels of management

Education:

Master’s in Computer Science from Southern Arkansas University, USA in 2023.

Bachelors in Civil Engineering, JNTU Kakinada in 2013.

Technical Skills:

Programming Languages:

C#, Python

.NET Technologies

Angular 6.0, Angular 4.0, ASP.NET 2.0, 3.0, 3.5, 4.0, 4.5, ADO.NET, .Net Core 2.0, 3.0,

LINQ, Web services, Web API, Entity Framework

IDE’s & Utilities:

Visual Studio.NET 2005, 2008, 2010, Crystal Reports XI, Microsoft .NET Framework 2.0, 3.0, 3.5, 4.0.

Web Development Tools:

XML, CSS, HTML, Javascript, TypeScript, Ajax, Angular js, Angular

Scripting Languages:

Python

Operating Systems:

Windows 2008, 2003 (Server), Vista, Win7, XP

Web Servers:

IIS 6.0, 7.0

RDBMS:

SQL Server 2015, 2019, 2022

CI/CD

Azure DEVops

Version Control Tools:

Team Foundation Server (TFS)

Key Responsibilities Handled:

Developed Data table using Angular js

Developed Excel Sheet Engine report using C# code to download reports

Developed .net Utilities to call different team web services inside AA.

Developed Python scripts to support Dashboard & Linux server.

Helped Devops team to change pipeline in AA.

Trained team members of 16 to use Dashboard with new features.

Professional Experience

Project: American Airlines, Fort Worth, TX August ‘23 – Till date

.Net Full Stack Developer

Description: Workflow Management System is a ticket management solution designed to streamline and automate the process of issuing laptops to new employees. It facilitates a structured workflow to ensure a smooth and efficient experience for both new joiners and IT administrators. The system tracks each step of the laptop issuance process, from the initial request to the final delivery, while providing transparency and accountability.

Responsibilities:

Collaborate with stakeholders, including HR, IT, and procurement teams, to gather and analyze requirements for the laptop issuance workflow. Understand business needs, user roles, and system integrations to inform software design and development.

Design the architecture and database schema for the ticket management system using .NET technologies such as ASP.NET MVC or ASP.NET Core. Determine the optimal structure for storing ticket data, user roles and permissions, approval workflows, and integration points with other systems.

Write clean, maintainable code in C# using the .NET Framework or .NET Core, adhering to coding standards and best practices. Implement the backend logic for ticket creation, approval routing, inventory tracking, delivery coordination, and reporting features.

Design and develop user-friendly interfaces using ASP.NET Razor Pages, HTML, CSS, and typescript frameworks such Angular. Implement responsive design principles to ensure compatibility across devices and browsers.

Use technologies like Web APIs for seamless data exchange between UI and sql server.

Used Dapper to connect to database.

Used Angular Google maps to get all google addresses inside USA.

Environment: .Net Framework 4.5, Visual Studio 2022, MVC5,Web API, Swagger, SOAP UI, Angular 6, Entity Framework to support oracle in visual studio, REST API,Excel report Engine, Nunit testing, Nuget packages, LINQ, Bootstrap, Type Script, .Net core API, Angular Material.

Kofax, India July’20 – Apr’22

Role: Developer

Description: The Total agility Platform is a BPM suite that provides an integrated set of components to enable you to redesign, automate and optimize your key business processes. The goal of the installation and application development team at Kofax is to implement product installation and adding new features in product installation, deploying product build in cloud (Azure) and developed new features in product. Our KTA product is implemented using lightweight framework MVC, Silverlight, Angular JS and WCF services

Responsibilities:

Design the application architecture based on MVC principles, ensuring scalability, maintainability, and performance. Define models, views, and controllers to implement the business logic, user interface, and application flow.

Write clean, modular, and well-documented code using C# and ASP.NET MVC framework. Implement controllers to handle user requests, models to manage data, and views to render user interfaces. Utilize HTML, CSS, JavaScript, and client-side frameworks (like jQuery) for front-end development.

Integrate with databases by writing SQL queries, stored procedures, and using ORMs (Object-Relational Mapping) like Entity Framework. Implement data access logic within the models to perform CRUD operations and maintain data consistency.

Implement server-side and client-side validation to ensure data integrity and prevent security vulnerabilities such as SQL injection and cross-site scripting (XSS). Apply authentication and authorization mechanisms (e.g., Forms Authentication, ASP.NET Identity) to secure the application's resources.

Write unit tests and integration tests to verify the functionality of controllers, models, and other components. Use testing frameworks like NUnit or MSTest for unit testing

Configure routing rules to map URLs to appropriate controllers and actions. Define custom routes to support friendly URLs and SEO optimization.

Worked on calling various APIS using jquery.

Worked on JAVASCRIPT to populate user interface controls such as drop-down list and generate warning messages to enhance overall UI experience

Developed smart table to display the data based on search functionality using Angular smart table

Used MICROSOFT PATTERNS - Abstract factory Pattern

Used SQL SERVER 2016 to store the data related to product.

Environment: Visual Studio 2016, Microsoft .Net 4.0, ASP.Net 4.0, C#,WCF, IIS, Web services, REST, SOAP, SQL, CSS,MVC5, SQL Server 2016, Entity Framework, JavaScript, Microsoft Windows 7, Agile Methodology, Team Foundation Server(TFS).

Client: Tata Consultancy Services, Nov’14 - Jun’20

Project: Microsoft Subscription Management

Role: Developer

Description: This subscription management will be used by Microsoft users who are subscribed monthly released product papers. The system automates the sales and billing products and services on recurring bases. It also has access management.

Responsibilities:

Utilized .NET technologies such as ASP.NET Web API or WCF to integrate with Microsoft Subscription Management APIs securely. Develop custom libraries or wrappers using .NET languages C# to interact with subscription data.

Implemented authentication and authorization mechanisms using .NET technologies such as ASP.NET Identity or Windows Identity Foundation (WIF) to securely access subscription data.

Developed .NET applications to manage the lifecycle of subscriptions, including provisioning, upgrading/downgrading subscriptions, renewing subscriptions, and handling cancellations. Utilize Entity Framework or ADO.NET for data access and business logic.

Implemented features in .NET using ASP.NET MVC or Web Forms to monitor and track subscription usage metrics. Utilize libraries like Microsoft Chart Controls for ASP.NET to visualize subscription usage data in reports and dashboards.

Developed .NET applications to handle billing and invoicing processes for subscription services. Utilize .NET technologies such as ASP.NET Web Forms for front-end development and SQL Server for backend data storage and processing.

Implemented user management features using .NET technologies like ASP.NET Identity or Membership Provider to manage users and access rights within subscription services.

Developed custom administration panels or user interfaces using ASP.NET Web Forms.

Developed complex queries, views, CTE in sql server to retrieve data from database.

Used TFS as version control to maintain code in repositories.

Environment: Visual Studio 2010, Microsoft .Net 3.0/3.5MVC 5.0,C#, ASP.Net 3.0/3.5, ADO.NET, MSTest, WCF, CSS, HTML, IIS, SQL Database, Entity framework, chart controls, ADO.Net, MS Test, NUnit, TFS.

Contact this candidate