About Me
- 11+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008, 2005 and 2000.
- Experience in Database Administration on Production Servers with se...
- Experience in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
- Expertise in SQL Script for writing stored procedures, triggers and functions.
- Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
- Implemented the new SQL Server 2012 mechanisms like data compression, indexing, Contained Databases, security principals and AAG.
- Worked on logical and physical data base modeling with UML tools.
- Experience in using DMV and dynamic management functions for finding out long running queries.
- Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
- Hands on experience in DR processes including Log Shipping and Database Mirroring.
- Worked on configuring SQL Server with minimum privileged access.
- Troubleshoot performance problems, fine-tuning of databases and index Analysis.
- Worked on SQL Server 2012 migration from SQL Server 2008 / 2005 and SQL Server 2000 into SQL Server 2005.
- Worked on migration of SQL Server 2000 instances into the 2005 SAN server.
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
- Working knowledge in Reporting Services (SSRS).
- Knowledge on NoSQL Database (Mongo Database).
- Worked on WCF, Rest API services
Skills
Web Development
Database
Development Tools
Programming Language
Software Engineering
Software Testing
Operating System
Others
Positions
Portfolio Projects
Company
AN360 Cloud app for Home security system
Role
Backend Developer
Description
An360 is composed of different modules to provide the functionalities like account management, hardware configuration application, communication server and so on. The web portal is created for providing the better way for device configuration and management. This involves dealer account creation, customer account creation, device communication and various operation. The device operation can be performed by dealer remotely. The device communication with ValueNet was accomplished using webAPI and websocket server.
Show More Show LessCompany
TSSCDOWNLOADER
Description
TSSCDownloader is composed of different modules for managing account, configuring Honeywell product, device enrolment, and device operation remotely. TSSC downloader was basically developed to support low end security devices with various security feature which are used in residential premises. TSSCDownloader is security device configuration which provide support to dealer to configure and monitor the devices remotely.
Show More Show LessCompany
Ticketing Cloud app
Description
This application is used to raise employees concern as tickets. Tickets will automatically get assign to respective agent for resolution.
Portal has three modules:
- Employee:
Employee module will help the employee to raise their concerns.
- Agent Module:
Agent module will help the agent to resolve the tickets .The tickets will be assigned to particular agent based on location, Category, Service window and Sla.
- Admin module:
Admin module helps for configuration and administration.
Show More Show LessCompany
Outbound customer call app
Description
This is an outbound campaign of Bank of America. This Project is used to take up the call made to the customers of BOA and giving them the details about the Product offers. Once customer will show interest about the product offered, Associates will collect the required details through phone. This Application is combination of Windows and Web parts. The login and getting the call is in windows part and collecting the details and closing the call through Web part. When the data is filled up in the web part same time it will be post back to the client’s URL through intranet .The URL post the data which consist of the data binded into XML strings.
Show More Show Less