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