Akansh Katyayan

Data Solutions Engineer @Chubb

Develop large-scale data structures and pipelines using Python, SQL, and Spark to organize, collect and standardize data that helps generate insights and addresses reporting needs. • Integrate data from various sources (10+ vendors), assuring that they adhere to data quality and accessibility standards. • Performed extensive text analysis and developed a data model to identify companies involved in Climate Change. • PySpark ETL to identify over 50K companies across the UK, Ireland, Australia, and Canada having a total of $1T in revenue which can be potential clients to Chubb • External vendors API integration and transformation of firmographic data from multiple vendors to support underwriters and risk analysts. skills - PySpark · Apache Spark · Python · Extract, Transform, Load (ETL) · Big Data · Hadoop · SQL · Azure Databricks · Web Scraping · Imputation Models · REST APIs · Data Ingestion Pipelines