Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vaibhav Desai

Ahmedabad

Summary

Enthusiastic technical professional with complete understanding of entire software development lifecycle. Highly trained in MSSQL and SQL database and known for having talents in developer and

administrator

Overview

10
10
years of professional experience

Work History

Sr. Data Analyst

Techanzo Private Ltd
Ahmedabad
03.2021 - Current
  • Investigated root causes of anomalies in datasets using exploratory data analysis.
  • Provided data-driven recommendations for marketing campaigns and product development initiatives.
  • Utilized machine learning algorithms to predict customer behavior based on past interactions.
  • Maintained accuracy of datasets by performing regular quality assurance checks.
  • Performed statistical analysis on customer data to identify patterns and correlations.
  • Developed dashboards in PowerBI to provide real-time business intelligence insights.
  • Established KPI metrics and monitored performance of data analysis projects.

Junior SQL Developer

Guhilot Enterprise Pvt Ltd
Ahmedabad
08.2016 - Current
  • Configured, Installed, and Maintained SQL Server 2000 & 2008 in development, test, and production environment
  • Installed and Configured Operating Systems, Windows Server (2000 & 2003)
  • Installed and Configured SQL Server Reporting Services (SSRS)
  • Configured and Maintained Replications, Log Shipping
  • Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment
  • Applied SP (Service Pack) and patches on SQL Server 2008, 2012, Windows Server 2008 r2 Enterprise Edition
  • Expertise in database Performance tuning
  • Writing T-SQL and Stored-Procedures
  • Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
  • Data Modeling, developing E-R Diagram using ERWin and SQL Server Data Diagram
  • Backward & Forward Engineering with data modeling tools mentioned above
  • Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP
  • Working experience in Database Backup, Restore and Point-in-Time Recovery
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
  • Developed Different Maintenance Plans for database monitoring
  • Monitor Server Activity, Error Log, space usage, and solving problem as needed

Software Developer

Futurenet Krishna Softech Pvt Ltd
Ahmedabad
08.2014 - 08.2016
  • Support and troubleshoot the existing webform-based system using C#/ASP.Net, VS 2016, SQL Server 2014
  • Design and development web pages using ASP.Net
  • Develop controls such as user-controls, listviews, editing and validation, modal popups and Ajax extenders, dropdown lists, file uploaders, query strings, SQL Datasource
  • Experience in SSRS/SSIS and other related SQL Server related tasks
  • Analyze, develop and test new systems using MVC 5 with C#/ASP.Net.
  • Used SSIS to export and import data
  • Create SQL Server databases, tables, views, stored procedures and database backups using SQL Server Management Studio
  • Write WCF Service and Operations Contracts to be utilized by tablets.
  • Change settings in web.config file according to application needs
  • Interface with user to ascertain their requirements
  • Implement new business logic

Education

BE (Bachelor of Engineering) - Information Technology

R C Patel Insuite Of Technology
Shirpur
6 2013

Skills

  • Development of high quality database solutions
  • Develop, implement and optimize stored procedures and functions using T-SQL
  • Review and interpret ongoing business report requirements
  • Research required data
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Timeline

Sr. Data Analyst

Techanzo Private Ltd
03.2021 - Current

Junior SQL Developer

Guhilot Enterprise Pvt Ltd
08.2016 - Current

Software Developer

Futurenet Krishna Softech Pvt Ltd
08.2014 - 08.2016

BE (Bachelor of Engineering) - Information Technology

R C Patel Insuite Of Technology

Similar Profiles

  • Priya Samarasinghe

    Priya SamarasinghePriya Samarasinghe

    General Surgeon (VMO) at Westmead Private Hospital, Norwest Private Hospital, Nepean Private Hospital, Nowra Private HospitalGeneral Surgeon (VMO) at Westmead Private Hospital, Norwest Private Hospital, Nepean Private Hospital, Nowra Private Hospital

  • INDRANIL SENGUPTA

    INDRANIL SENGUPTAINDRANIL SENGUPTA

    Tax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private LimitedTax Manager at RSM US Integrated Services India Private Limited (formerly Known as RSM Delivery Center (India) Private Limited

  • Arjit Adaval

    Arjit AdavalArjit Adaval

    LEGAL COUNSEL at MATI Carbon India Private Limited; Swaniti Initiative & Stratengage Private LimitedLEGAL COUNSEL at MATI Carbon India Private Limited; Swaniti Initiative & Stratengage Private Limited

  • AKASH SINGH

    AKASH SINGHAKASH SINGH

    Fenergo Developer (US Bank) at Amiseq India Private LimitedFenergo Developer (US Bank) at Amiseq India Private Limited

  • Pritesh Patel

    Pritesh PatelPritesh Patel

    Duty Security Supervisor Grade O2 at Etihad AirwaysDuty Security Supervisor Grade O2 at Etihad Airways

CREATE PROFILE
Vaibhav Desai