Yichen Fu Email & Phone Number

• Cleaned data and processed third-party spending data into maneuverable deliverables within a specific format with Excel macros and python libraries such as NumPy, SQLAlchemy, and matplotlib.• Created action filters, parameters, and calculated sets to prepare Tableau dashboards and worksheets. • Prepared Dashboards using calculations, parameters in Tableau.• Used advanced Excel functions to generate spreadsheets and create dashboards in Excel for data reporting. • Utilized spark SQL to load data from AWS S3 to snowflake tables using data bricks.• Implemented Data Exploration to analyze patterns and to select features using Python SciPy.

• Performed Data Cleaning, features scaling, features engineering using SciPy, Pandas, NumPy, Matplotlib packages in Python.• Embedded Power BI reports to internal Portal to manage access of reports and data for the individual user using based on roles. • Performed data analysis and maintenance on information stored in MySQL database. • Developed Airflow Dags to automate the batch data load process in AWS Data Lake.• Designed, developed, and implemented Power BI Dashboards, Scorecards & KPI Reports.• Worked on data that was a combination of unstructured and structured data from multiple sources and automatic cleaning using Python scripts.

Master'S Degree, Data Analytics

Bachelor'S Degree, Biology/Biological Sciences, General