Menu

Welcome to my Blog

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.

Address

:

Pune, India.

Email

:

dev.dey009@gmail.com

My SQL
75%
T-SQL
85%
Python
75%
Mongo DB
90%
Machine Learning
75%
Tableau
85%

My Resume

My keen curiosity and experience in data wrangling, mining data and gathering
meaningful information will be treasured for the job.

Professional Experience:

05/2016 - Present

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

Bentley Systems,
Pune 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

Internship
Bentley Systems, Pune

Vulnerability Testing on the IMS website in QA environment.
• Database optimization of IMS.
• Database Developer.

Professional Education:

2011-2013

MTech (CSE)
  • Kalinga Institute of Industrial Technology (KIIT)
  • CGPA : 8.56

2011

BTech (CSE)
  • Kalinga Institute of Industrial Technology (KIIT)
  • CGPA : 7.15

2005-2007

Higher Secondary Education
  • Royal College of Science and Technology(RCST)
  • PERCENTAGE : 63.33%

2005

Secondary Education
  • St Vincent’s Convent School
  • PERCENTAGE : 74%

My Work

Contact Us

Email

dev.dey009@gmail.com.

Please Fill up this Enquiry Form...