• 8 Years of IT Experience in SQL server 2005/2008, SQL, T-SQL.
• Experience in Web application Software customization and Design Database on MSSQL.
• Have expertise of working on SQL.
• Experience of Store Procedures to User Defined Functions which formed part of a data warehouse, creating considerable number of User Defined Functions which were required for the data warehouse.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning.
• Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Created and maintained database, tables, views, indexes, and constraints to implement business rules by SQL Server Management Studio.
• Thorough knowledge on working of indexes, types of indexes, and indexing algorithms.
• Ability to create and maintain SSIS packages.
• Business Intelligence experience.
• Extensive work on Control M- batch scheduling jobs to automate the application execution.
• Worked on ETL process consisting of data transformation/migration, data sourcing, mapping, conversion and loading, data testing and validation against staging database.
• Expertise in report writing according to business requirement in SSRS.
• Expert in creating SQL Server Reports using SSRS 2008 in designing stylish report layout.
• Knowledge of druid 0.9.0 (Nosql), Pivot (druid data visualizer).
Attachments (Click to Preview)
-
-