Vinesh Patel

About Vinesh Patel

Are you looking for an SQL Server Specialist or Developer or Power BI Developer- I can…

Experience

1. Database Developer Database Specialist

   Responscity Systems

   Oct 2015 — Present · Surat, IN

   Design and develop databases to store and organize large amounts of data• Designed and implemented various types of tables, T-SQL, stored procedures, views, functions, triggers and other application database code objects.• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Monitor database performance and troubleshoot any issues• Monitor database usage and optimize queries for better performance• Writing complex queries.• Used Power BI to analyze and monitor large-scale citizen service delivery data• Built dashboards for real-time tracking of departmental KPIs and SLA compliance• Integrated Power BI with e-Governance databases (SQL Server/MySQL) for automated reporting• Developed role-based dashboards for Government officials at State, District, and Taluka levels• Implemented Power BI reports for grievance redressel tracking and service turnaround-time monitoring• Enabled data-driven decision-making through interactive drill-down reports and insights Performed quality testing and assurance for SQL servers.• Worked with stake holder’s developers and production teams across units to identify business needs and solution options.• Ensured best practice application to maintain security and integrity of data.• Recommended resolution ensuring optimal performance• Automated database tasks (Created Jobs, Alerts and Schedules for database maintenance tasks)• Research and evaluate new database technologies and tools• Designed normalized and optimized database schemas, ER diagrams, and data models for applications.• Implemented ETL processes for data migration and analytics, enabling interoperability with Aadhaar, GIS, and payment gateways.• Applied data encryption, role-based access controls, and compliance measures in line with NIC and CERT-In guidelines.• Improved database performance by optimizing indexing, queries, and execution plans, reducing query times by up to 40%.

Education

• Bangalore University

  Master's degree

Skills

• C#
• .net
• Technical Architecture
• Wcf
• Oracle
• Web Services
• Javascript
• Microsoft Sql Server
• Xml
• Software Development
• Sql
• Asp.net
• Ajax
• Pl/Sql
• Software Project Management