Mr. Debadutta Dey
I'm a Professional SQL Developer having Years Of Experience
A MSSQL programmer with newly attained skills, an extreme intellectual curiosity, and the ability to mine hidden treasures sited within enormous sets of structured, semi-structured and unstructured data and ability to leverage a substantial dose of mathematics and applied statistics with visualization and a strong sense of exploration.
My keen curiosity and experience in data wrangling, mining data and gathering
meaningful information will be treasured for the job.
05/2016 - Present
Sr. Software Analyst
Yardi Systems Pvt. Ltd., Pune
- Developed SQL Server Stored Procedures, developed User Defined Functions and created Views.
- Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production.
- Designing, Developing or Modifying reports upon end users request using SSRS and in-house reports.
- Handled Null values and and aggregated data based on report requirement.
- Reviewed existing business procedures and recommended and implemented changes.
- Creating and automating the regular Jobs.
02/2014 - 05/2016
Associate Database Developer
- Interacted with Team and Analysed, Design and Develop database using ER Diagram, Normalizationand relational database concept. Involved in Design, Development and testing of the system.
- Involved in performing data conversions from excel sheet and other sources into a normalized databasestructure.
- Performed Extraction, Transformation and Loading of data into SQL server from various sources.1
- Designed and developed physical data models and created DDL scripts to create database schema anddatabase objects, SQL Server Stored Procedures, Tuned and optimized SQL Queries (using Indexes,Execution Plan and Profiler), User Defined Functions and created Views.
- Reviewed existing business procedures and recommended and implemented changes and responsiblefor setting preferences for various ad-hoc requests.
- Created and automated the regular Jobs, involved in performing database Backup and Recovery.• Tested and identified vulnerabilities in different web applications posing a high risk to industry andcommunicated them to responsible developer for remediation and provided solutions to the developersto mitigate the vulnerabilities.
10/2013 - 02/2014
Bentley Systems, Pune
Vulnerability Testing on the IMS website in QA environment.
• Database optimization of IMS.
• Database Developer.