Stack Overflow
Stack Overflow

Shakti Singh Chauhan
530
reputation
5
15
  • India
  • Member since April 14 2015
  • 60 profile views
  • Last seen Feb 24 '23 at 10:31
  1. Over 7 years of working experience in Development and Production Support using SQL Server, SSIS,SSRS,Qlikview and C# ASP.Net.
  2. Almost 2 years of experience in Qlikview BI dashboard.
  3. Microsoft Business Intelligence Solutions certified.
  4. Strong Experience in consolidating Distributed database into single Database.
  5. Exposure in HR,Systems and Finance domain.
  6. Experience in project estimation and leading the team.
  7. Troubleshooting the website using developer tool,SQL Profiler,ELMAH,log4net.
  8. Proficient in designing Data Mart out of data warehouse.
  9. Hands on experience in model, design and development of database systems using SQL Server.
  10. Hands on experience in implementing Check Points, Package Configurations and Package Deployment for the SSIS Packages.
  11. Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, Sort,data Conversion, Union All, Merge Join, SCD to load data into SQL Server destination.
  12. Troubleshooting performance issues and fine-tuning Queries and Stored Procedures. Having good experience on Stored Procedures, Views, Indexes, User Defined Functions and Triggers in T-SQL.
  13. Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, SQL Profiler, Execution Plans Database Tuning Advisor, SQL Server Agent, SSIS and SSRS.
  14. Created SSRS reports as per client’s requirements in the form of table, matrix, Chart and list.