SQL development professional with solid analytical skills for writing relational database solutions for businesses. A self-starter who is able to work independently .Had a good understanding of business intelligence and analytical tools for analysis of data. Experience in extraction of data(ETL) using SQL Server Integration Services (SSIS) ,maintaining the database using Sql Server Management Studio , implementing, developing, and maintaining SQL Databases
-
Experience
• Developed and modified the triggers, packages, functions, and stored procedures for data conversions and SQL procedures for creation of Database Objects dynamically.
• Migrated the database objects from Oracle environment to SQL Server and vice versa. Coordinated with the front-end developers to provide them necessary stored procedures and insights of the data.
• Developed and deployed the SSIS packages to load the data into the databases depending upon the input file formats.
• Experience in migrating the database scripts from one version to other version and maintaining the migration scripts.
• Developed the SQL programs to retrieve the data using cursors and exception handling.
• Created numerous queries involving joins, correlated sub queries and CTE’s techniques for diverse business requirements.
• Experience in Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Manage database administration assignments for diverse industry clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.
-
Projects
Price Interpretation on Airbnb NYC | Technologies: R, XLMiner, Tableau
• Implemented Predictive Data Analytics on the data using R and XL Miner and Tableau is used for Data Visualization.
• Built models using random forest, Regression and neural network on training data set using XL Miner.
• Evaluated the best model using ROC curve, accuracy and AUC and used the best classification algorithm to illustrate the price range and type of housing provided by Airbnb.