Vinod Dhone

• Responsibility :Creating ADF Pipelines ,Stored Procedures ,Views , create, Dimensions Facts.( Microsoft SQL Server 2005/2008/2008R2/2012/2014)

• Involved in requirement analysis, development, Loading data from different on premises server (SQL,Oracle,CSV/Excel),

• Create triggers for Pipelines, auto scaling of compute.
• Responsible for retrieve data requires for management, operations teams on urgent basis with accuracy.
• Performance Tuning of SQL queries etc
• DP-900,DP-203 Certified

•Designing SSAS Cubes.

•Designing Power BI Dashboard/SSRS Reports.

o Upgradation of Database from SQL Server 2000 to 2005 and 2008.
o Team building, mentoring, hiring resources, demands forecasting.
o Closely worked with Solution Architects and sales teams in developing proposals, plans, and communication.
o Involved in creation/review of functional requirement specifications and supporting documents for business systems, in database design process and data modeling process.
o Managing customer issues in On Time, customer issue status communications
o Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
o Supported team in resolving SSIS, T-SQL, logical & design related issues to resolve resolved data conflicts and inappropriate use of data.
o Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements
o Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008 for new ETL Processes
o Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
o Developed & maintained scripts, utility jobs for database maintenance, database automation tasks & product version up gradation.

o Up gradation of Database to SQL Server 2005
o Creating Tables, Stored procedure, functions, triggers
o Database design process and data modeling process.
o Creating index and optimization query
o Scripted Full / Incremental database backup and scheduled a daily backup using SQL Server agent job.

o Maintained POS software , write VB 6/ Dot Net code
o Creating Tables, Stored procedure, functions, triggers
o Database design process and data modeling process.