Luyi Dai Email & Phone Number

New York, NY, US

• Involving requirements gathering, analysis, design, development, and testing production of an application using the Agile model.
• Using packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low graphs to identify the relationship between different variables.
• Develop a manager dashboard of call center metrics and KPIs to analyze the team performance using Tableau.
• Utilizing technology such as Excel PowerPivot to query test data and customize end-user requests.
• Outstanding data analysis skills including data extraction from MS SQL database, data mapping from source to target schemas, and data cleansing and preparation.
• Understanding of Data Modelling, Data Collection, Data Cleansing, Data Warehouse, and Client/Server applications.

• Implemented the project using the Waterfall Methodology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC).
• Worked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts.
• Executed data validation, data profiling, data defects cleanup, data improvement initiatives, and data quality monitoring reports.
• Involved in Data Analysis, Profiling, and Assessment to evaluate data for accuracy and quality using Python and libraries SciPy, NumPy, and Pandas.
• Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data.
• Worked with the Data Warehouse team in developing Dimensional Model and analyzing the ER-Diagrams.

Master'S Degree, Applied Statistics

Bachelor'S Degree, Mathematics