Amit Dutta

Highly analytical and results-driven SQL Server Developer with over 10 years of experience in analysing complex data sets, designing data models, database tables, stored procedure, functions, developing SQL queries, and creating automated reports. Skilled in data visualization, data mining, and database
administration. Seeking a challenging position in a dynamic organization where I can utilize my expertise and contribute to the growth of the company.

Managing a team of 8 people consisting of 2 software developers, 2 Data entry person, 1 Website Designer, 2 Network engineer and 1 Database administrator in the management and daily operation of
EDP department.
Responsible for development, upgradation and maintenance of In-house developed ERP system used by 100 users.
Working in SQL-Server 2000/2005/2008/2012/2016. Writing various queries, stored procedures to generate various types of MIS reports regularly. Analysis of data using Excel/SQL server
Creating interactive dashboards and reports to provide insights to stakeholders
Co-ordinations with the Data Entry operator & uploading the data in SQL tables and also to ensure from front end applications.
Data extractions from PDF format and transferring data in SQL tables.
Monitoring performance and managing parameters to provide fast query responses to 'front end' users;
Responsible for the performance, integrity, maintenance and security of a database, integrating with front-end application with the help of software developer.
Optimized database performance by analysing query execution plans and implementing index tuning.
Writing database documentation, including data standards, procedures and definitions for the data.
Developing, managing and testing backup and recovery plans; ensuring that storage, archiving, backup and recovery procedures are functioning correctly.
Working closely with IT project managers, database programmers and web developers, communicating regularly with technical, applications and operational staff to ensure database integrity and security.
Commissioning and installing new applications.
Automation of any MIS task as per management requirement.
Migration of database from SQL Server 2000 to SQL Server 2008 and later on to SQL Server 2012.

Masters in Computer Applications (MCA) from Sikkim Manipal University in the year 2015.
DIPLOMA IN ADVANCED PROFESSIONAL SOFTWARE from Impact Project, Jadavpur University in association with CMC Ltd. (Duration: 1.5 Years) in the year 1999.
B.Sc. (Pure) from Calcutta University in the year 1995.
Higher Secondary (WBCHSE) in the year 1993.
I.C.S.E. from St. Thomas School (Kidderpore) in the year 1991.