SUMMARY
· Total 3+ years of competitive experience in IT industry using Microsoft Technology (C#, ASP.NET, ASP.NET MVC).
· Experience of working in the complete Software development life cycle involving development, design and maintenance.
· Good work ethics with excellent communication and interpersonal skills.
· Capable to develop into the new leading Technologies.
· Ability to work well in both a team environment and individual environment.
· Good knowledge and experience in C#, ASP.Net, ADO.Net, SQL Server, AJAX, Web Services.
· Excellent code reviews and code debugging skills.
· Strong experience in writing SQL queries.
· Experience on hosting website in IIS and maintenance.
1. GA Digital Word web Pvt. Ltd. (Client-Election Commission of India) JAN 18 to Till Date- Sr. Programmer
ERMS\ERO-NET
Type
Web Based Application
Environment
ASP.NET using C#,ADO.NET,AJAX
Database
MS-SQL Server 2014
Responsibilities:
● Involved in developing UI page
● Involved in business logic code
● Creating table and writing queries
● Fixing the bugs & modifying the DOT NET code
● Involved in hosting website in IIS and maintenance
● As a Team Member, responsible for the timely delivery of different module of the Product
● Involved in Requirement gathering and design document.
● Involved in creation of stored procedures, Triggers and Job Schedule in MS SQL Server 2014 and Later.
● Unit testing module level
● Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
● Worked with developers to tune the SQL queries using SQL Profiler.
● Worked with Analytical services.
● Provided 7 x 24 Production support for the database and application issues.
1. UST GLOBAL (Client- Indigo Airlines Head office) FEB 16 to Dec 17
Assoc. Systems Engineer
Responsibilities:
● Monitoring Production and Development Server and their Utilization.
● Hands-on command on all DDL, DML, DCL, TCL statements in SSQL
● Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and installing to support an organization's application systems.
● Some of the primary responsibilities of this role would include tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with strategic solutions to recurring problems.
● Involved in installation and configuration of SQL server 2000 on Dell Servers. Applied patches and service packs to keep the database at current patch level.
● Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
● Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
● Implemented database standards and naming convention for the database objects.
● Conversion the legacy systems data into MS SQL server using DTS packages.
● Developing SQL scripts for maintaining administration tasks.
● Tuned the SQL queries using SQL profiler. Involved in tuning the database.
● Implementing stand by servers and Log shipping.
● Involved in developing stored procedures, triggers for the application.
● Estimating of Table sizes and Record sizes. Maintaining proper licenses.
● Maintain all the SQL documents includes installation and data conversion Procedures documents.
● Trouble shooting Problems by using SQL server profiler.
● Solved critical production problems and performed point in time recovery plans.
Tools are: C#.net, Asp.net MVC, Visual Studio 2012, SQL Server 2012, HPDP and Remedy