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.• Performed data analysis and data profiling using complex SQL queries on various source systems including SQL Server.• Worked with Data Cleaning, Wrangling, Data Analytics, Integration, Critical Thinking, Problem-Solving, Communication, and Presentation Skills.

Master'S Degree, Applied Statistics

Bachelor'S Degree, Mathematics