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.

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.

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.

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

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.