Dilip Patil

  • Surat Gujarat

SQL Server Developer

Work History

Work History
May 2012 - Feb 2015

SSRS Developer

Banthia Consultancy

● There is Web based  ERP software developed to Maintain Loan and Subsidy Files system. It has also integrated with attendance punching system for Company's HR module, Task Mgt. System etc. There are 200+ active reports running on company's server which are made for analytical profiles and decision makers. 

SQL Server Reporting Service

Implementation of SSRS I have fully knowledge of implementing SQL Server reporting service in new environment.

● All types of Reports using SSRS

●-Visual Eye Candy Reports using charts Graphs, indicators and more.

●-Complex Reports using Drill through, Drill Down functionality, Query string URL handling, Sub reports, Cascading Parameters etc.

Dashboard: Report Uses Statistics dashboard This dashboard is for reports maintenance purpose which helps me to get idea about reports executions.

I will clear with the below points by using this dashboard:

1] No. of Total Reports with the report server link.

2] Which are used between given periods and which are not used?

3] Which user is using which user?(Not windows user, actual end user who is using this report)

4] Frequency of Report uses.

5] top used reports.

Auto Email Configuration:

Setting IIS for email delivery Email regarding client file status, Imporatant daily status to BOD,Birthday wishes to employees and much more.

SQL Server 2008 r2

I believe in writing a good SQL Code.

I am having 2+ years hands on experience in SQL server 2008 r2

Able to code SQL Store Procedure, Functions, View, Indexes, Trigger, Cursors, CTE's, SQL Bulk insert And more. And good in T-SQL programming skills.

Extensive Knowledge of advance query concepts(e.g. group by, having clause, union so on).

A good problem solving attitude and analytical skills.

SQL Server query optimization using

  • Database Consistency Checker(DBCC Commands)
  • SQL Profiler
  • Query execution plans
  • Database engine Tuning advisor and Needy Optimization Techniques.
  • Index maintenance and SQL Server Statistics to improve Database performance. Exposure to Data Warehousing, Analysis Cubes, Import export of data within servers and Crystal Reports

Education

Education
Feb 2010 - Feb 2012

B.C.A

Veer Narmad South Gujarat University

First Class

Skills

Skills

SSRS

Proficient skill in SQL Reporting Service from the development to deployment. 

SQL SERVER 2008

Able to code SQL Store Procedure, Functions, View, Indexes, Trigger, Cursors, CTE's, SQL Bulk insert And more. And good in T-SQL programming skills.