Work Preference
Summary
Overview
Work History
Education
Skills
Certification
Timeline
SoftwareEngineer
Gourav Bose

Gourav Bose

Data Analyst And Engineer
Uithoorn,,NH

Work Preference

Work Type

Full Time

Location Preference

RemoteHybrid
Open to relocation: No

Important To Me

Career advancementWork-life balanceCompany CultureFlexible work hoursPersonal development programsHealthcare benefitsWork from home optionPaid time off

Summary

With more than seven years of experience in Data Engineering and Analytics, I focus on developing robust and scalable data driven solutions. Experienced in end-to-end delivery of big data analytics projects - from conceptualization to execution - across the SDLC, including requirement gathering, documentation, and maintenance. Demonstrated proficiency in designing robust ETL processes and maintaining high standards of data integrity to deliver actionable business insights. Possesses strong analytical skills, excellent problem-solving abilities and extensive experience with Python, PySpark, SQL, and Azure data services. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Overview

7
7
years of professional experience
9
9
Certificates
3
3
Languages

Work History

Internal Audit Data Analytics Manager

JT International Holding B.V.
01.2023 - Current
  • Skill Set : PySpark, SQL, Spark SQL, Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Azure DevOps
  • Key Achievement Areas:
  • Designed and implemented robust and scalable analytical solutions that enabled the audit team to gain faster insights, detect anomalies, and identify control gaps in a timely manner.
  • Created refined data visualizations to effectively communicate analysis outcomes to the auditors.
  • Delivered prompt and comprehensive assistance to the auditors regarding data inquiries during the audit assignments.
  • Performed audits on inventory and spare parts management independently, further strengthening my functional knowledge in these areas.
  • Implemented an automated feedback system for the data analytics team, enabling efficient capture of user feedback and requests while streamlining progress tracking.
  • Developed a portfolio of published automations (automation hub) for the Internal Audit Team, leading to enhanced visibility and re-usability of the automated solutions.
  • Fine-tuned query performance and optimized ETL workloads for faster, more accurate data retrieval and reporting.
  • Established reliable monitoring mechanism to detect data anomalies.
  • Collaborated with cross-functional teams for developing seamless data integrations and high-quality data solutions.
  • Conducted DA coaching sessions for the auditors and technical training sessions, fostering a collaborative learning environment

Sr. Associate

Affine Analytics
05.2021 - 12.2022
  • Project: Vehicle Mart
  • Description: The purpose of this project is to gather pricing data from various sources and summarize the listed price and odometer reading by Vehicle Identification Number (VIN) and calendar month. This data is then utilized by Sonic's Data Analytics team as an input to their pricing applications to determine the best market value for the used and new cars
  • Skill Set: SQL, SSIS, Azure Data Factory, Azure Synapse Analytics, PySpark
  • Key Result Areas:
  • Developed scalable ETL pipelines to extract data from on-premises, SFTP, and cloud storage solutions.
  • Developed robust and efficient data models to facilitate business intelligence initiatives and meet reporting requirements
  • Conducted several proof-of-concept (POC) projects to transition the legacy ETL solution to a cloud-based platform, assessed both benefits and drawbacks, and helped the team in choosing the optimal approach for final implementation.
  • Optimized existing solutions as when needed and provided fixes for critical data issues in a timely manner.
  • Increased client satisfaction through delivering high-quality data solutions.
  • Led technical sessions across the organization, conducted internal team workshops, and assisted with taking technical interviews for hiring.

Data Engineer

Alumus Software Ltd.
12.2019 - 05.2021
  • Project: Market Performance Program
  • Description: Digital data team at JTI (Japan Tobacco International) has instituted a mechanism to generate and socialize multiple reports for different internal stakeholders with varying cadence to understand ecommerce performance and social presence metrics
  • Skill Set: Dataiku, Python, PySpark, Azure Databricks, Azure Data Factory, Azure Data Lake Gen2, Azure CosmosDB, REST API
  • Key Result Areas
  • Performed requirement analysis and solution outlining for the project
  • Designed and defined the end-to-end data architecture
  • Developed highly scalable and automated data pipelines for data ingestion from diverse data sources, applied business rules to refine and transform the data and made it available to cater various reporting needs
  • Reviewed Functional and Technical design documents
  • Played a key role in the overall development of the solution
  • Project: Standard Analytics
  • Description: Japan Tobacco International (JTI), a leading multinational company uses SAP as their ERP tool to store all their business-related information. As a part of migrating the workloads from SAP ECC to SAP S4 HANA, they also need to redesign their entire analytical platform which could be used by the auditors to perform effective data driven audit for different entities
  • Skill Set: Dataiku, Python, PySpark, Spark SQL, Azure Databricks, Azure Data Lake Gen2
  • Key Result Areas
  • Rendered assistance to IAD team in transitioning and redesigning the entire analytical platform to perform effective data driven audit for different entities
  • Developed different audit objects out of the SAP data stored in ADLS Gen2 under different business processes present like P2P, O2C, F2S which are utilized by the downstream applications to perform different test cases
  • Designed and developed data flows for different test cases (data driven audit processes) in Dataiku
  • Provided solution to recurring issues and customer required solution in a timely manner

SAP Associate Consultant

Wipro Technologies
06.2019 - 12.2019
  • Project: Quantum- Implement myWipro
  • Description: Internal project, improvement of an existing company portal by migrating the existing workload from ECC to SAP S4 HANA
  • Key Result Areas
  • Gained technical exposure on SAP ABAP and SAP MM Module

Education

B. Tech. - Information Technology

RCC Institute of Information Technology
Kolkata
01-2019

Skills

Pyspark / Python

SQL

ETL

Data Warehousing

Azure Databricks

Azure Synapse Analytics

Azure Data Factory

SSIS

Power BI

Cosmos DB

Azure DevOps

Git/GitHub

Power Automate

Certification

Databricks Certified Data Engineer Associate

Timeline

Internal Audit Data Analytics Manager

JT International Holding B.V.
01.2023 - Current

Sr. Associate

Affine Analytics
05.2021 - 12.2022

Data Engineer

Alumus Software Ltd.
12.2019 - 05.2021

SAP Associate Consultant

Wipro Technologies
06.2019 - 12.2019

B. Tech. - Information Technology

RCC Institute of Information Technology
Gourav BoseData Analyst And Engineer