Omkar Deshpande

Experience

• 

  Wipro

  Feb 2004 - May 2005

  Database Administrator

  Worked as a SQL Server DBA/Systems Administrator for Microsoft in a CRM Project called Clarify. I was responsible for complete handling of the Clarify production and related applications’ support issues and work along with the other Teams at Australia / New Zealand, China, Singapore, Korea and Japan .The Main responsibility involved is handling of daily critical issues related to all Clarify environment servers which are spread across many regions. The job was very critical and strictly based on SLA Norms. The job requires very quick decision making skills that can effect the whole production environment. Show less

• 

  Tech Mahindra (formerly Mahindra Satyam)

  May 2005 - Mar 2006

  Sr SQL Developer

  Worked on EPL project for Client - Checkfree Investment Services (CIS), to develop a Portfolio Management Product, called Enhanced Portfolio Lifecycle (EPL) for use of Financial Institutions (FI) that deals with Separately Managed Accounts (SMA) in USA.Responsibilities:Designed the scalable Infrastructure architecture that supported various disaster recovery scenarios to ensure zero data loss in case of major disaster.Actively Participated in writing documents like Backup Strategy, Disaster Scenarios and recovery, Replication Scenarios, database designing guidelines, Naming Convention to be used.Preparation of Logical Database design based on the Client Inputs and System Requirements.Optimization and fine-tuning of the stored procedures / functions / triggers to enhance database performance.Performance Testing of Database and Database objects using the SQL Profiler and Query Analyzer.Worked with Microsoft Visual Source Safe for Version Control of all documentation and source code(stored procedures / function / trigger) Show less

• 

  Mphasis

  Mar 2006 - May 2021

  Database Administrator

  Current working with TD Ameritrade client as BI Expert and Database Architect. Current responsibilities as below:Analysis on SQL 2005 to SQL 2012 migration Coordinate with business analysts and understand migration roadblocks.SSIS migration from SSIS 2005 to SSIS 2012 Analysis, requirement gathering and POC on new features – TVP, Filestream, Data EncryptionPerformance analysis and tuning for long running queriesRedesign long running SSIS packages.Integrate Pragmatic BI xPress utility with development environment. Show less