Basanth Kumar Email & Phone Number

Bangalore

Worked in Nextgen Healthcare India (Pvt) Ltd as Database Developer.Expertise in US Healthcare Domain and working with a leading US HealthCare Product Development Company.1. Creating Indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.2. Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost3. Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.4. Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.5. Designed and developed reports using SQL Server Reporting Services (SSRS).6. Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.8. Created report snapshots and cache for better performance.9. Involved in migration of On Premise data to AWS Environment.10. Created EC2 & RDS Instances, effectively managed the production workloads using ELB and Auto Scaling strategies.11. Created Spark jobs using AWS EMR (Elastic Map Reduce).12. Involved in setting up of Hadoop cluster in AWS using Cloudera manager.13. Migrated data from Microsoft SQL Server to HDFS using Sqoop.

Mysuru, Karnataka, India

Mysuru Area, India

1. Table design & development/SP writing /query writing2. Tuning of queries for enhanced performance.3. Monitoring SQL server performance and events using SQL profiler.4. Extracted data from various sources like SQL Server 2008/2012, CSV, Excel and Text file from Client servers and through FTP.6. Developed stored procedures to implement business functionality and enhanced existing code.7. Interacted with Business team to collect data for the conceptual design of the system.9. Database backup, restore and maintenance.