Sharat Kumar Gupta

I am a B.Tech from IIT, Delhi with an experience of more than 16 years in top notch organizations like Microsoft, GE, Sigma, RTS. Posses deep understanding and knowledge of all spheres on SQL Server administration, design and development. Unmatched problem solving and logical abilities.• Extensive experience in designing database schema based on business requirements in form of use cases, user stories and screens. • Extensive experience in writing complex database queries, views, stored procedures, triggers and user defined functions by using T-SQL. Expert in writing DDL. Vast experience in debugging SQL code. • Expertise in Business Intelligence (SSIS, SSRS). Experienced in developing SSIS packages to extract, transform and load bulk data into database from various heterogeneous databases like Excel, SQL Server and Flat files. Comfortable with various tasks like Data flow/SQL Task/Script Task/DQS. Programmed script tasks to communicate with external systems to exchange data. • Experienced in performance tuning of SQL Code through restructuring code and analyzing Query plan output, analyzing profiler traces and executing DTA. • Hands on experience in Log Shipping, Replication, Database Mirroring, Database Mail, SQL Agent jobs creation and deployment and administration. • Expert at Backup/Restore/Attach/Detach/Maintenance Plans/Import data/Export data. DOMAIN--
• Pharmaceutical campaigns.
• Air Passenger Inventory and Supply Management, Air Cargo Revenue Management.
• Retail.