K J Hanil Kumar Email and Phone Number

A seasoned professional with over 20+ years of commendable success in IT industry in the HCM domain which includes in System Analysis and Design, Development & Support of MS SQL Servers. Experience in Software Analysis, Data Modelling, Design, Development, Testing, Implementation and Production support of SQL Server 2005 TO 2016. Expertise in Microsoft Business Intelligence technologies like SSRS and SSIS, Performance tuning and Database administration.Experienced in client Requirement Analysis, Development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server. Experience in Data Modelling (logical and physical modelling), Entity relationship diagram (ERD) development/normalization and physical database schema design using Erwin.Expertise in performance tuning, optimization, data integrity and statistics by using SQL Profiler. Managed indexes, statistics and optimized queries by using execution plan for tuning the database. Responsible for performance tuning and optimization of stored procedures using SQL Profiler and Database tuning wizard.Specialized in creating several SSRS reports such as drill down reports, parameterized reports, linked reports, sub reports, matrix reports, and charts reports. Hands on experience in Extract, Transform and Load (ETL) development using SQL server integration services (SSIS) that extracts data from different OLTP databases like Sql server and other data sources like access, csv, xml, excel and flat file to data warehousing environment for analysis and reporting purposes.Worked on Exception Handling and resolving locking/deadlocks. Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas.Having hands on experience in DR processes including Always On High Availability, Replication, Log Shipping and Database Mirroring.