Summary
Overview
Work History
Education
Skills
Additional Information
Languages
Timeline

Sovik GUHA BISWAS

Kolkata

Summary

Profile Summary Data Engineer with over 7 years of experience in cutting edge data engineering technologies and ex SAP HANA and BODS consultant. Proven track record of successful projects and the ability to work with large datasets in a variety of environments, including Google Dataproc, Google Big Query, Databricks and Cloudera. Proficient in Python, SQL, HDFS, pandas, and Spark. Skilled in designing, implementing, and optimizing data processing pipelines and ETL workflows to deliver actionable insights. Dynamic Data Engineer committed to optimizing systems performance for reduced operational costs and streamlined workflows. Performs timely software installations and tests alongside routine troubleshooting to facilitate system transitions and minimize downtime. Simplifies complex topics and processes to make technical interactions less intimidating for average users.

Overview

8
8
years of professional experience

Work History

IT Analyst

Tata Consultancy Services (TCS)
08.2018 - Current
  • Worked extensively with Spark, PySpark
  • Dataproc, BigQuery, and GCP Cloud Storage, catering to client needs and streamlining data pipelines by 40%
  • Created and managed cron jobs for ETL processes using Shell script wrappers, improving job scheduling efficiency by 30%
  • Collaborated with Functional Consultants and developers to design data pipelines, resulting in a 25% reduction in pipeline errors and a increase in data processing speed
  • Successfully transitioned from SAP HANA and
  • BODS to a Data Engineering role, contributing to a 20% increase in team productivity and project delivery speed
  • Optimized data workflows to handle over 10TB of data daily, ensuring data integrity and
  • Social links https://www.linkedin.com/i n/sovik-guha-biswas-9a7 enhancing performance.

IT Executive

Orbital Software Development Pvt Ltd
04.2016 - 08.2018
  • Worked as a HANA DB administrator and
  • HANA DB instructor for the organization as per project requirement
  • Participated in HANA upgrade and installation, performance tuning and auditing measures for the client

Education

MCA - Computer Application

Meghnad Saha Institute of Technology
05.2015

GPA: 8.82/10

B.Sc - Computer Science

New Alipore College
05.2012

GPA: 65.38%

  • Honours

Skills

  • Python
  • Apache-Spark
  • HiveQL
  • Dataproc
  • HDFS
  • Linux
  • SQL
  • ETL
  • AWS Glue
  • Databricks
  • Data Engineering
  • SAP HANA and BODS

Additional Information

  • ETL Tool Spark Python SQL Hive Queries Shell Scripting Dataproc Data Flow Bigquery Postgresql Data Ingestion SQL Scripting SQL Queries Cloud Sql SAP HANA
  • Led the design of Databricks and Spark-based data processing pipeline, resulting in a 30% increase in data processing efficiency.
  • Utilized Google DataProc, Dataflow, BigQuery, and HDFS for the storage and processing of large datasets, reducing data retrieval times by 40%. Developed Dataproc workflows with Python and SQL, enabling the processing of over 10TB of data daily.
  • Orchestrated the transformation of 5 million legacy orders for SAP migration, achieving a 90.9% data accuracy rate and a 50% reduction in processing time. Collaborated with Analytics Consultants and BODS developers, streamlining workflows and reducing data pipeline errors by 25%.
  • Proficient in Databricks and AWS Glue, optimizing ETL processes and reducing runtime by 35%.
  • Seamlessly transitioned from HANA DB admin to Data Engineer role, contributing to a 20% increase in overall team productivity within the first six months.
  • Managed and optimized SAP HANA databases, ensuring high availability and performance for business-critical applications.
  • Participated in HANA DB migration Conducted performance tuning and troubleshooting for databases, queries, and data integration processes.
  • Implemented data security measures and access controls to protect sensitive information.

Languages

English
Bilingual or Proficient (C2)
Hindi
Upper intermediate (B2)
Bengali
Bilingual or Proficient (C2)
French
Beginner (A1)

Timeline

IT Analyst - Tata Consultancy Services (TCS)
08.2018 - Current
IT Executive - Orbital Software Development Pvt Ltd
04.2016 - 08.2018
Meghnad Saha Institute of Technology - MCA, Computer Application
New Alipore College - B.Sc, Computer Science

Similar Profiles

CREATE PROFILE
Sovik GUHA BISWAS