Arpan Biswas
Raipur,CT
Summary
Experienced data engineer adept at developing data solutions to address modern-day business problems. Possesses proven knowledge of Snowflake, Python, SQL, databases, and data warehousing concepts, along with expertise in data ingestion and transformation. Skilled in handling large datasets, developing data pipelines, and designing visualizations in Tableau to provide insights crucial for informed decision-making.
Overview
3
3
years of professional experience
4
4
Certification
Work History
Data Engineer
Visual BI Solutions Pvt. Ltd., An ATOS Company
09.2023 - Current
- Migrated tables from SAP BW to Snowflake for the APAC region using ADF as the primary ETL tool.
- Developed and optimized SAP BW queries as views in Snowflake using SQL, incorporating logic from SAP HANA Studio and BeX Query Designer.
- Validated data integrity and accuracy with Analysis for Microsoft Excel before passing it to the reporting team.
- Created UDTF and dynamic tables in Snowflake to meet business requirements.
- Enhanced DBT workflows and SQL scripts through performance tuning to improve data processing speed and scalability.
- Developed and maintained ETL processes, ensuring efficient data extraction, transformation, and loading.
- Implemented data quality and validation checks to ensure data accuracy and completeness.
- Collaborated with business stakeholders to translate reporting requirements into Snowflake-compatible data models and queries.
Associate Data Engineer
Useready Technology Pvt. Ltd.
04.2022 - 09.2023
- Completed a Tableau capstone project during intensive bootcamp training
- Utilized SQL, Alteryx, web scraping techniques, Snowflake, and Tableau
- Analyzed data to derive insights and facilitate informed decision-making
- Presented findings and actionable recommendations through visually compelling Tableau dashboards
- Worked on the development of a data warehouse infrastructure for a prominent healthcare company
- Developed the framework from scratch, leveraging Snowflake, Matillion, and Microsoft Azure
- Developed data pipelines to transfer data into Snowflake using Matillion
- Created views in snowflake for the BI reporting team
- Ensured seamless data flow and accessibility for stakeholders across the organization.
Data Science Intern
Fliprobo Technologies
09.2021 - 03.2022
- Skilled in Python, SQL, exploratory data analysis (EDA), data cleansing, Pandas, feature engineering, and other data science toolkits
- Developed various machine learning (ML) models for diverse applications
- Conducted web scraping to gather data on different car models from various websites
- Implemented preprocessing techniques including handling missing values, text cleaning, and algorithm development to prepare the scraped data for analysis
- Gained valuable insights into the intricacies of building a successful startup
- Engaged in various aspects of startup operations, contributing to a comprehensive understanding of entrepreneurship and business development.
Education
PG Program in Data Science, Machine Learning and Neural Networks, In Collaboration With IBM -
Datatrained
03.2022
Bachelor Of Engineering: Electrical and Electronics - undefined
Sir M. Visvesvaraya Institute of Technology
01.2021
Skills
- Snowflake
- Matillion
- Microsoft Azure
- SQL
- Python
- AI / ML / NLP
- Web scraping
- MYSQL
- SSMS
- SAP BW
- BeX Query designer
- Analysis for Microsoft excel
- SAP HANA Studio
- ETL development
Certification
- Snowflake SnowPro Core Certified, 09/2022 - 09/2024
- Matillion Associate Certified, 05/2023 - 05/2026
- Microsoft Certified: Azure Data Fundamentals
- Databricks Data Engineer Associate, 07/2024 - 07/2027
Timeline
Data Engineer
Visual BI Solutions Pvt. Ltd., An ATOS Company
09.2023 - Current
Associate Data Engineer
Useready Technology Pvt. Ltd.
04.2022 - 09.2023
Data Science Intern
Fliprobo Technologies
09.2021 - 03.2022
PG Program in Data Science, Machine Learning and Neural Networks, In Collaboration With IBM -
Datatrained
Bachelor Of Engineering: Electrical and Electronics - undefined
Sir M. Visvesvaraya Institute of Technology
- Snowflake SnowPro Core Certified, 09/2022 - 09/2024
- Matillion Associate Certified, 05/2023 - 05/2026
- Microsoft Certified: Azure Data Fundamentals
- Databricks Data Engineer Associate, 07/2024 - 07/2027
Similar Profiles
Arpan BiswasArpan Biswas
Data Engineer at Visual BI Solutions Pvt. Ltd., an ATOS companyData Engineer at Visual BI Solutions Pvt. Ltd., an ATOS company
Kunjal MeshramKunjal Meshram
INCIDENT MANAGER-CONSULTANT at ATOS Global IT solutions and Services Pvt. LtdINCIDENT MANAGER-CONSULTANT at ATOS Global IT solutions and Services Pvt. Ltd
RAJESH SESHAIAHRAJESH SESHAIAH
VMware and Windows Administrator at ATOS Global IT Solutions and Services Pvt LtdVMware and Windows Administrator at ATOS Global IT Solutions and Services Pvt Ltd