Abnish chandra P.

MS SQL Database architect, database design, asp.net, c# application development, technical support

Delhi , India

Experience: 11 Years

Abnish chandra

Delhi , India

MS SQL Database architect, database design, asp.net, c# application development, technical support

USD / Year

Start Date / Notice Period end date:

11 Years

Now you can Instantly Chat with Abnish chandra!

Chat Now

About Me

Technical Lead with an expertise in engaging, challenging and motivating individuals; track record of ensuring that the team provided a responsive and efficient service to internal and external customers.

...

Experienced in developing, deploying, maintaining, modifying and supporting software applications using .NET Framework Visual Studio, ASP.NET, ADO.NET, C#, MVC, SQL Server, Ajax, JavaScript and Web Services. Ability to adapt to new environment and open to learn and enhance new technologies.

Designed, configured and administered the MS SQL database system ensuring high levels of Database performance, availability, sustainability and security; implemented efficiency improvements

Built stored procedures, functions, sequences, constraints and triggers to maintain data integrity. Applied indexes and partitions to improve performance. Created views for monitoring and SSRS reporting

Skills

Positions

Backend Developers

Full-Stack Developers

Portfolio Projects

Description

The application project is for master data management for their erp system. The application needs to handle the request and approval process of the organisation for their material, customers, vendors and other information. It basically mange and maitain the master data before it gets ready for the transactions in their erp system.

Show More Show Less

providing consultancy in .net application development/sql server management

Description

My role involves leading team developing database system for .net windows/web applications using asp.net/ asp.net MVC technologies.

Followed agile software development methodlogy.

Provided remotesupport in troubleshooting issues related to database performance, security, scalability.

Deployment and configuration of web application on IIS 7.0 server.

Making security policies, creating jobs for automation of various tasks on database server.

Creatingand implementing database backup strategy.

Show More Show Less

https://entrust.niitghana.com

online univarsity erp system developed to manage all transactions and data

Contribute

Analysis, design and development of database system; Contributed in application programming using asp.net, c#, T-SQL; Administered the MS SQL Server database for the duration I was worked with them.

Description

Communicate to users for requirement analysis.

Analysis, design and development of the system database.

Writing procedures and triggers on database

Creating application modules using C# programming on ASP.NET

Implementing Security on database server with the help of encryption, managing user permissions on RDBMS Server.

Implementing SSL encryption for securing the connection on protocol level

Scheduling database backup.

Automating jobs on SQL server for maintenance and performance.

Monitoring the database performance on daily basis.

Writing indexes for increasing the performance.

Configuring Reporting services on SQL Server.

Show More Show Less

Data integration from traditional sources with relational data and development

Description

Integrated data from multiple traditional souces by practicing ETL process using SSIS

Migrated data to a more managed RDMS system

used advanced excel tools/options to work on data formating, type change and compatibility issues

Show More Show Less

worked on a scholarship application developed using .net technology

Contribute

Designed and developed database system on sql server Did application programing in C#, .net, t-sql

Description

An application was developed in order to automate the scholarship examination being held by a leading IT training company every year for more than 10,000 students in the country. Automation involved entering student details in the system, having online scholarship exam, processing the result and giving a grade to the student and based on the grade issuing a scholarship letter with feedback details to the students. This project was also aimed to create a good database of the students for future use.

Show More Show Less