Arkajit D.

Database Developer

140 dollar
Freelancer
3 ans
Kolkata, INDE

Mon expérience

Voir plus

ProcentrisJuly 2018 - Présent

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

Mes compétences

Environment of Development

SQL Developer

Business Intelligence

SQL Server Reporting Services

Other

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

Languages

SQL

Databases

Database and SQL tuning, Microsoft SQL Server

Mes études et formations

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

- Youth Computer Training Centre2009 - 2011