Praveen Sachdeva Email & Phone Number

Los Ang

Santa Monica, Ca

• Managing 20+ SQL Servers, from 10gb to 750gb database servers• Setup and Installation of SQL server 2014, 2012, 2008, 2005.• Numerous Successful and seamless migrations from older SQL Server versions to the newer ones.• Set up SQL Server Failover Clustering on top of Windows 2012 Cluster on SAN infrastructure to minimize down time and data loss.• Responsible for disaster recovery planning for SQL Servers. Implemented SQL Server Log Shipping and Replication for high availability of member accounts.• Setting up of Database Mirroring and Manual Failover plan.• Development of SQL stored procedures, Triggers, Views. SQL Server Replication setup.• Rewriting and tuning long-running SQL queries to cut execution time, ease database load and improve scalability.• Reviewed and optimized SQL queries, stored procedures, views and triggers from application developers to achieve maximum efficiency and scalability.• Monitor SQL Server Profiler on regular basis to optimize slow running queries and stored procedures and debug issues. Performance Tuning of SQL Server, Tuning of the database involves checking of system resource usage using the performance monitor, SQL Server Profiler, choosing efficient indexes, optimizing queries etc.• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS and SSIS packages.• Creation of SSIS packages for importing data from flat files to the SQL Server database and creating Zip files and Exporting files using File Transfer utility in SSIS.• Monitoring and automations of daily tasks through SQL Server jobs.• Created company intranet for SQL Server Reporting, MIS, fulfillment, tracking, data Entry

CitiAlert is typically a web based messaging system developed by Citibank Development Center, LA which provides timely alerts for Citibank customers on critical events on their banking relationship and for everyone on general purpose alerts like Product Information, upcoming events and promotions etc. The system will provide these alerts via e-mail or through Short Messages (SMS) on GSM Phones or both. The system has been enhanced to interface with several other systems for generating number of alerts for all different kinds of activities of the customers with banking systems.• Database designing in SQL server 2000.• Monitoring and giving 24x7 support for DTS packages and incremental load.• Optimizing the slow running DTS packages/queries.• Generated various ad-hoc reports for claim analysis using MS Reporting Services.• Performance Tuning of SQL Server, Tuning of the database involves checking of system resource usage using the performance monitor, choosing efficient indexes, optimizing queries etc.• Development of SQL stored procedures, Triggers, Views. SQL Server Replication setup.• Responsible for disaster recovery planning for SQL Servers. Implemented SQL Server Replication for constant availability of customers accounts.• Preparation and reviews of functional specifications, technical specifications, various interface specification documents.• Developing various middle tier components, front End GUI for the CitiAlert application. • Involved in development, deployment and support of CitiAlert application for US businesses.• Preparation of SIT test plans and conducting the SIT for the product for various businesses. • Preparation of critical documents like the Installation documents, Interface specification documents, User manuals & guides, Release notes, etc.• Setting up of Windows 2000 Domain Controllers, ADS setup, ADS replication setup.• Good communication skills

Bachelor, Computer Science

Education record