Client Microsoft; Team Size Project : Module : EnvironmentSoftwareLanguages : Database : SQL Server 2005/2008 O/s : Windows 2003; ContributionSupport on Production SQL Server 2005/2008 Installation, Hot fixes and IPAK update.Upgrade the database from SQL Server 2000/2005 to SQL Server 2005/2008 on cluster box.Work with Microsoft team for regression testing on migration of SQL Server 2005 to SQL Server 2008.Support and coordination with client.Performance and troubleshoot as per the need.Monitoring and troubleshooting.High availability using log shipping, clustering, replication.Projects Profile

Team Size Project : Module : Environment(with skill versions) SoftwareLanguages : Database : SQL Server 2000/2005Tools : Red Gate O/s : Windows 2003 Hardware HP Itenium, SAN (EVA 5000); Project Description He worked and maintained large subscriber's data for the Client Dishtv in providing solutions to the issues related to the dishtv subscriber's services for renewal, activation. We used Power Builder ASP, ASP.NET and VB for Web based application and windows based application as front end and SQL SERVER as Backend.ContributionSupport on Production SQL Server 2000/2005 (64 bit) of database Size 350+ GB Installation & service Pack update.Upgrade the SQL Server 2000 32 bit to SQL Server 2000 64 bit on cluster box.Backup and restore.Monitor the performance and troubleshoot as per the need.Security.Implement/troubleshoot of replication & log shipping.Create database objectsDTS and Jobs define as per the need.Documentation for the database policy.Database Archive plan and Implementation.Monitoring and troubleshooting.High availability.Projects Profile3. Project Name : Web based CRM for Ecommerce

Team Size Project : Module : Environment(with skill versions) SoftwareLanguages : Database : SQL Server 2000Tools : O/s : Windows 2003; Project Description He worked on the Technical/Functional issues on the web based CRM and e-commerce portals for Order-Capture, Payment gateway, Inventory, Sales and Support, and Help-Desk etc. Issues related to the Performance of the Database, which were resolved by changing the schema of Database or by tuning the SQL Queries.ContributionRemote Support on Production SQL Server 2000 Create/Alter database design.Create/alter database objects like table, procedure, view, triggers and user define functions.Maintenance plan for backup/restore.Migration of database (DTS).Performance tuning including add/defrag indexSecurity including define Users and their Roles.Monitoring and troubleshooting.High availability.He managed database of; 2. Project Name : RMS(Repair maintenance and service)

Team Size Project : Module : Environment(with skill versions) SoftwareLanguages : ASPDatabase : SQL Server 2000O/s : Windows 2000; Project Description He worked for client Teleplan in complex repair and failure analysis on multi-layer networking products. It was intranet based application and support projects to optimize the system for the better report generation and enhancements in exiting system.ContributionSupport on development SQL Server database To define query and stored proceduresMigration of data from production database to development database.Monitor the performance and result set and troubleshoot as per the need.Projects Profile1. Project Name : Freedom Finance Client Freedom Finance

Team Size Project : Module : Environment(with skill versions) SoftwareLanguages : Database : SQL Server 2000O/s : Windows 2000; Project Description He worked on the online process for the loan/mortgage for client Freedom Finance. This is online application in six step filled by either agent or by directly. After submitting the application details, its goes through the back office process like supervisor, advisor, processor, auditor, and administrator before forwarding the details of customer to bank.ContributionDesign of database objects.Documentation of database.Coordinated with development team for database related issues.Migration of data from production database to development database.Monitor the performance and result set and troubleshoot as per the need.

Team Size Project : Module : Environment SoftwareLanguages : Database : SQL Server 2005 O/s : Windows 2003; ContributionSupport on Production SQL Server 2005 Installation & service Pack update.Database migration from SQL Server 2000 to 2005Monitor the performance and troubleshoot as per the need.Security.Backup and restore.Documentation for the database policy.Database Archive plan and Implementation.Monitoring and troubleshooting.High availability.Projects Profile4. Project Name : DishTv Broadcast Service Client DishTv