Summary
Overview
Work History
Education
Skills
Languages
Accomplishments
Certification
Timeline
Generic
Avik Sarkar

Avik Sarkar

Bengaluru

Summary

Logical Data Analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with 8 years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.

Comprehensive SQL Developer accomplished at leading database projects for customers and completing each project on time and under budget. Exceptionally skilled in designing and maintaining SQL scripts and providing technical support and guidance to staff and clients.

Hardworking and reliable with strong ability in any task. Highly organized, proactive and punctual with team-oriented mentality.

Ambitious, career-focused job seeker, anxious to obtain an Azure Data Engineer certification to help launch career while achieving company goals.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Specialist Data Engineer

LTIMindtree Ltd (Project - Microsoft Bing)
Bengaluru
01.2022 - Current
  • Created stored procedures, triggers, tables, views and functions using T-SQL.
  • Optimized existing queries to improve performance of the system.
  • Monitored database performance and provided troubleshooting for any issues or errors encountered.
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.
  • Developed dashboards with PowerBI to monitor key performance indicators.
  • Extracted data using Scope Script in COSMOS DB.
  • Defined KPIs based on collected data sources.
  • Utilized advanced analytics tools such as SSAS, Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.

Senior SQL Developer

Crafi Silicon Pvt Ltd
Bengaluru
06.2021 - 01.2022
  • Developed and implemented complex SQL queries to extract data from multiple databases.
  • Created stored procedures, functions, views, triggers and indexes for efficient data manipulation.
  • Optimized existing queries by analyzing query plans and execution times.
  • Performed database tuning activities such as indexing, partitioning and performance monitoring.
  • Provided technical support to users in resolving database related issues and errors.

Senior Database Developer

Empulse Global Pvt Ltd
Bengaluru
11.2020 - 06.2021
  • Developed and maintained stored procedures, functions, triggers, views and indexes for MS SQL Server databases.
  • Created database objects such as tables, views, stored procedures and triggers to support application development.
  • Implemented data migration from legacy systems into the new SQL Server environment.
  • Provided technical guidance and advice to other developers in developing complex queries and troubleshooting issues related to T-SQL programming.
  • Designed backup strategies for all production databases in order to ensure business continuity during disaster recovery scenarios.
  • Tuned T-SQL queries for better performance by analyzing execution plans and modifying query structure or adding appropriate indexes where needed.

SQL Developer

Atyati Technologies
Kolkata
08.2018 - 10.2020
  • Performed backup and recovery of databases on a regular basis.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
  • Provided technical assistance in the form of SQL coding advice to other team members.
  • Analyzed business requirements and translated them into logical data models.
  • Resolved customer service requests related to database errors or performance issues quickly and efficiently.
  • Used T-SQL scripting language for creating stored procedures, functions, triggers.
  • Integrated multiple data sources into one unified view using views or joins in SQL queries.
  • Generated ad hoc reports upon request from stakeholders utilizing Microsoft Excel Pivot Tables or Access Queries.

Software Engineer

Sysfo Software Solutions Pvt Ltd
Kolkata
06.2015 - 08.2018
  • Analyzed user requirements to develop software solutions and created technical specifications.
  • Provided technical support to customers regarding product usage and troubleshooting issues.
  • Analyzed solutions and coding fixes for software problems.
  • Conducted full lifecycle software development from planning to deployment and maintenance.
  • Documented technical specifications and project testing methods for future reference.
  • Introduced automation tools to enhance workflow.
  • Scheduled ongoing performance quality assurance checks for software applications and automated performance test scripts.
  • Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.

Education

Master of Computer Applications - Computer Engineering

Techno India
Kolkata
08-2014

Skills

  • MS Sql Server
  • Power BI
  • Advanced Excel
  • Scope Script
  • Azure Databricks
  • Data Migration
  • Database Design
  • Performance Tuning
  • Database Development

Languages

Bengali
First Language
English
Advanced (C1)
C1
Hindi
Upper Intermediate (B2)
B2

Accomplishments

  • Star Crew Award
  • Hi-Five Award
  • Star Award

Certification

  • Microsoft Bing Ad Certification.
  • Azure Data Engineer(DP-203)(Pursing)
  • Internal Fabric Certification.

Timeline

Specialist Data Engineer

LTIMindtree Ltd (Project - Microsoft Bing)
01.2022 - Current

Senior SQL Developer

Crafi Silicon Pvt Ltd
06.2021 - 01.2022

Senior Database Developer

Empulse Global Pvt Ltd
11.2020 - 06.2021

SQL Developer

Atyati Technologies
08.2018 - 10.2020

Software Engineer

Sysfo Software Solutions Pvt Ltd
06.2015 - 08.2018

Master of Computer Applications - Computer Engineering

Techno India

Similar Profiles

CREATE PROFILE
Avik Sarkar