Shiyi G.

• 5 years of Years of professional experience working with large data sets across multiple domains including commercial, financial, industrial products and services sector. • Proficient in gathering business requirements and handling requirements management, and Implementation of Enterprise Data Warehousing and Data ETL and Visualization. • Strong hands-on experience in On-premises databases (Oracle, MySQL, SQL server, DB2, PostgreSQL), and cloud database (AWS S3,EC2,RDS Azure Database, snowflake, Azure Cosmos DB) • Hands on experience working Amazon Web Services (AWS) using Elastic Map Reduce (EMR), Redshift, and EC2 for data processing. • Hands on experience in SQL and NOSQL database such as Snowflake and MongoDB. • Hands on experience in setting up workflow using Apache Airflow engine for managing and scheduling ETL jobs. • Proficient in ETL operations with application (MS SQL Server, SSIS, informatica, DBT, ADF) • Proficient in data mining, data modeling, data integration, data visualization, reporting, and data analytic using BI tools and dashboards (PowerBI, SSAS, SSIS, SSRS, Tableau, Excel with macros by VBA). • Strong program in python Data manipulation for loading and extraction, data pre-process with python (libraries: NumPy and Pandas, matplotlib, Keras , PyTorch ,etc)