**Designed a database model for real estate company** * Analyzed business process, created a Relational Data Model for the real estate company, including all Entities, Attributes, Data Relationships, Primary and Foreign key Structures. * Developed database tables for each of these entities in the model using SQL statements, and utilized SQL queries to retrieve and analyze data. * Created reports and forms using MS Access. **Analyzed the medical insurance cost using** **Tableau and R programming** * Used the boxplot to analyze the medical expenses against other categorical factors. * Applied Multiple Linear Regression Model to build a regression model and evaluate it. * Generated and improved model to analyze the relationship between medical insurance cost and other variables. **Implemented funnel analysis for an e-commerce website using Tableau and Python programming** * Segmented data by device, gender and the day of the week. * Calculated the lead-to-customer conversion rate and customer retention rate. * Built dashboards, drawn meaningful insights and made recommendations based on the descriptive modeling. **Performed the bank marketing analysis using Tableau and Python programming** * Used Python to retrieve data and clean data from structured data files. * Utilized Tableau and Seaborn package in Python to make data visualization. * Split the dataset into validation data and training data by portion 30%: 70%. * Performed forecasting using Naïve Bayes algorithm and Random Forest algorithm in repaying loan.

· Developed and maintained relational databases to record transactions of the company. · Wrote SQL queries to extract data from MySQL relational databases, and then provided custom reports to supervisor. · Constructed dashboards using Microsoft Excel to track seasonality including key insights such as monthly active user (MAU), retention rate and revenue. · Built optimization models and applied them to coal cleaning processes, which improved the revenue by 13%.

· Prepared and delivered lectures for 24 classes of roughly 900 students. · Utilized Excel to visualize student test score data via pivot table and clustered column charts. · Calculated the successful rate of each question in examinations and built the dashboards.

· Collected and cleaned data with Excel, and then analyzed data using Pivot Tables and charts. · Used Origin software to create scientific graphs and make model. · Assisted with duties related to the production of academic journals.