Arpan Biswas

Migration Project:

• Led the migration of tables from SAP BW to Snowflake for the APAC region, leveraging ADF as the primary ETL tool.
• Created views within Snowflake using DBT.
• Developed and optimized SAP BW queries using BeX Query Designer, incorporating logic from SAP HANA Studio into Snowflake using SQL.
• Validated data integrity and accuracy using Analysis for Microsoft Excel before providing it to the reporting team.

Capstone Project:

• 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.

Data Warehouse Setup and Data Extraction:

• Led the development of a data warehouse infrastructure for a prominent healthcare company.
• Established the framework from scratch, leveraging Snowflake, Matillion, and Microsoft Azure.
• Implemented robust data extraction processes from multiple sources into Snowflake using Matillion.
• Created views in snowflake for the BI reporting team.
• Ensured seamless data flow and accessibility for stakeholders across the organization.

• 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.