Sagnik Chowdhury

Data Engineer

Kolkata, West Bengal, India5 yrs 7 mos experience
Most Likely To SwitchAI Enabled

Key Highlights

  • Strong expertise in Data Engineering and Business Intelligence.
  • Proven track record in Java development and Big Data solutions.
  • Effective communicator with a consultative approach to problem-solving.
Stackforce AI infers this person is a Data Engineer with strong capabilities in Business Intelligence and Java development.

Contact

Skills

Core Skills

Data EngineeringBusiness IntelligenceJava DevelopmentBig Data SolutionsTest Automation

Other Skills

Agile MethodologiesAmazon Web Services (AWS)Apache KafkaArtificial Intelligence (AI)Artificial Intelligence for BusinessAutomationAzureAzure Cosmos DBAzure Data FactoryAzure DatabricksAzure DevOpsAzure DevOps ServicesAzure FunctionsAzure SQLBusiness Analysis

About

Hey there, Sagnik believes there is always something to learn and with digital media's rapid pace, there's always something new. He strives to build his reputation at work by keeping the open lines of communication with the teammates and colleagues in different functional roles to discover what they know and how the best to work with them. He uses positivity to make work a pleasant place to be, building an atmosphere of fun. He always tries to take a consultative approach towards solving any problem and tend to flex to fit others' communication styles as a means to be more effective in fast-paced environments with cross-functioning teams. He loves to work in challenging environments because adversities bring the best out of him. Herewith some key highlights of his professional experience: • Always highly interested in learning and understanding the business requirements, its values as well as new methods and ideas and putting them into the daily practice. • Has good communication and articulation skills. • Always interested in end-to-end functionality. • Experienced in gathering requirements definitions, ensuring quality deliverables, coordinating UAT with the clients and ensuring the successful implementation of the project as per the timelines. • Possesses good implementation knowledge in Agile-Scrum, CI/CD and DevOps methodologies ensuring higher level of productivity and involve in code review to make sure coding standards are being followed. • Experienced in developing Java applications with big data technologies and implementing the business logics based on the new business requirements ensuring the quality, performance and maintainability of the applications. • Experienced in creating the deployment builds, putting them into the artifactory, unit testing and debugging or fixing the bugs (if any) in the code. Some of his technical skills are: Java, JEE, Microservices, Spring boot, Python, C, C++, Maven, SQL, Oracle, Junit, REST, SOAP, Azure DevOps, Selenium, Postman, TestNG, Apache Kafka, Cucumber.

Experience

Dxc technology

3 roles

Analyst 1 Data Engineer - Data & AI

Jul 2024Present · 1 yr 8 mos · Kolkata, West Bengal, India · Remote

Analyst 2 Data Engineer - Data & AI

Nov 2023Jul 2024 · 8 mos · Kolkata, West Bengal, India · Remote

Associate Professional Data Analyst - Analytics & Engineering

Sep 2022Nov 2023 · 1 yr 2 mos · Kolkata, West Bengal, India · Remote

  • ✓ Designed, built and optimized the infrastructure required for the optimal extraction of the data pipelines, transformation and loading of data from a wide variety of data sources to Azure.
  • ✓ Provisioned the resources on Azure keeping the data secured across the end-to-end solutions and improved the existing data analytics solutions.
  • ✓ Set up the clusters and the workspaces on Azure Databricks to achieve transformations and codes were written in PySpark and SQL to transform the validated files on Azure Databricks notebooks.
  • ✓ Mounted the database and created the JDBC connection on the notebook to migrate the processed file to Azure SQL DB.
  • ✓ Responsible for the development and enhancement of the semantic models on Azure Analysis Services, configured and scheduled the runbooks to refresh the data as per requirements.
  • ✓ Developed interactive and dynamic dashboards on Power BI and solicited business requirements from the stakeholders.
  • ✓ Experienced with working in on all types of data connections i.e., Import, Direct Query, and Live Connections.
  • ✓ Worked with various data sources and performed data transformations using Power Query Editor to support the needs of the analysis.
  • ✓ Responsible for maintaining consistency across multiple dashboards and designed, developed, tested, and deployed Power BI scripts and performed detailed analytics.
  • ✓ Designed flows using Microsoft Power Automate that trigger email alerts to the stakeholders whenever there is a change in the dashboard.
  • ✓ Performed DAX queries and functions in Power BI and analyzed the current ETL processes, defined and designed new solutions.
  • ✓ Worked on Power BI Service for Gateways and workspaces management with respective data sets.
  • ✓ Worked with the stakeholders at all levels for performance improvements and suggestions.
AzurePower BISQLPySparkData TransformationMicrosoft Power Automate+2

Cognizant

2 roles

Programmer Analyst - Java Big Data Developer for ING Bank, Netherlands

Aug 2021Sep 2022 · 1 yr 1 mo

  • ✓ Worked as a Java Big Data Developer in a DevOps squad of ING Bank, Netherlands that is responsible for masking the sensitive data of GDPR customers and offers DBaaS (Database as a Service) solutions to other squads within the bank.
  • ✓ Responsible for masking the sensitive data of GDPR customers.
  • ✓ Collaborated with the onsite team from the Netherlands and the Continental Europe, following Agile-Scrum Methodologies in the onsite-offshore model that accomplish our objectives to boost performance and enhance the customer experiences in the best possible way.
  • ✓ Worked with technologies like Java, Spring boot, Azure DevOps, Apache Kafka, Cucumber, Maven, Linux, Bash Scripting, AWK Scripting, Git, Oracle SQL, ServiceNow, Grafana and so on.
  • ✓ Designed and orchestrated a Java application that validates the active customer records from the masked MDM files based on the requirements, transforms and integrates them to a single large file and finally migrates it to a data warehouse. This process used to be executed earlier by AWK scripting (Linux) which used to take almost a day to get completed whereas the new Java solution takes around 3-4 hours only in the production environment.
  • ✓ Worked on the enhancement of the monitoring services of late for the DBaaS solutions of the squad and came up with a successful implementation of the logics in Java that get the details of the customers from the database and trigger emails and alerts to the intended recipients to notify them whenever the status changes. This used to be a manual process earlier whereas the new version is an end-to-end automated solution.
  • ✓ Besides, learnt and mastered various essential skills and technologies required not only in the field of Banking and Financial Services but also in other fields as well in the digital world today.
JavaSpring BootAzure DevOpsApache KafkaCucumberJava Development+1

Programmer Analyst Trainee - ING Bank, Netherlands

Aug 2020Aug 2021 · 1 yr

  • Automated and tested the common functionalities by writing the test automation scripts using Selenium to automate different websites.
  • Created layered and structured automation layer using POM or Page Factory as a design pattern with a generic method to invoke a browser and navigate to a URL.
  • Added logic to create the wrapper methods to perform user actions.
  • Used XPaths for locating dynamic web elements that interact with web elements like text box, dropdown select, buttons, lists and prepared logic to implement the reusable components and utilities and reading configurations from the properties file.
  • Automated the scroll up/down operations using Mouse operations (Action Class), JavaScript via Selenium.
  • Automated the DELite-MR Application and performed Category Count Verification (Category Details Screen) from FRS screen, mandate checks, enters values against the mandate fields and verifies the entered values in expansion mode and findings and captures the description verification.
  • Executed the test cases from the test layer via TestNG XML file.
  • Implemented logic that generates interactive reports and logs. Besides, takes screenshots of the failed scenarios and attaches to the report for the detailed analysis.
SeleniumTestNGJavaTest Automation

Highradius

Business Project Intern (Marketing, Sales and Consulting)

May 2019Jun 2019 · 1 mo · Bhubaneswar, Odisha, India

  • Executed different assessments and case studies related to marketing, sales and consulting.

Airtel

Network Engineer

May 2018Jun 2018 · 1 mo · Kolkata, West Bengal, India

  • During this period of Internship learnt about Telecommunication Network Operations, 2G, 3G, 4G LTE, SRAN and Pre-Readiness of 5G Technology.

Electrosteel group

Quality Assurance (TPM, Six Sigma and Kaizen)

Jan 2018Jan 2018 · 0 mo · Khardah, Kolkata, India

  • During this period of Internship I have learnt about Total Preventive Maintenance (TPM) and Inside Plant Operations.

Education

Amity University

Master of Business Administration - MBA — Data Science

Oct 2024Oct 2026

Kalinga Institute of Industrial Technology, Bhubaneswar

Bachelor of Technology - BTech — Electronics and Telecommunication Engineering

Jan 2016Jan 2020

National Chung Cheng University

B.Tech (Exchange Student) — Computer Science and Information Engineering

Jan 2018Jan 2019

Nanhua University

Bachelor of Technology - B.Tech (Exchange Student) — Computer Science and Information Engineering

Jan 2018Jan 2019

Barrackpore Government High School

12th — Science (PCMB)

Jan 2014Jan 2016

Ramakrishna Mission Vidyalaya

10th

Jan 2004Jan 2014

Stackforce found 100+ more professionals with Data Engineering & Business Intelligence

Explore similar profiles based on matching skills and experience