Arkajit D.

Database Developer

140 dollar
Freelancer
4 years
Kolkata, INDIA

My experience

More

ProcentrisJuly 2018 - Present

Responsibilities:
* Decreased monthly server log error rates to an all-time low (0.14%).
* Extensively worked on the tuning of SQL query, batch jobs, optimizing the batch process as well as tuning various complex and time-consuming queries.
* Real-time monitored 6 Live Server with 32 different Agencies using SQL Sentry.
* Ensured client satisfaction level at its best by providing accurate and concise resolution and showing a high level of expertise from the technical aspect.
* Handled over 65 different types of invoices, E-Billing reports more than 1000 ad-hoc and standard report formats in SSRS.
* Identified and Worked with Parameters, Multi-Value Parameters for Parameterized reports in SSRS.
* Worked on various T-SQL queries, complex stored procedures, user-defined functions, triggers huge datasets optimization in SQL.
* Handled different replications -a snapshot, merge and transactional.
* Worked with the QA team on various data related assignments and observations.
* Provided client ad-hoc queries as per requirement. Worked with clients and provided resolution via FogBugz project management and issue tracking software.
* Worked on version controlling using Team foundation server(TFS) and maintained hierarchical

structure for the same.
Analyst

My stack

Business Intelligence

SQL Server Reporting Services

Databases

Microsoft SQL Server, Database and SQL tuning

Environment of Development

SQL Developer

Other

Seagate Crystal Reports, Microsoft Office, Microsoft .NET Technology, Data Mart, industry~it, Microsoft Windows 7, Microsoft Visual Studio, Microsoft Team Foundation Server, Report development, Microsoft Windows 10, Associate lead, Bachelors Degree > Bachelors Degree Computer Application, EPIC Certification, Microsoft Transact-SQL, operating systems, Diploma, EPIC Clarity Report Certification, certified Reporting Analyst and Database Administrator

Languages

SQL

My education and trainings

Bachelors Degree, Computer Application - West Bengal University of Technology2013 - 2016

- Youth Computer Training Centre2009 - 2011