Jiahui Fan Email & Phone Number

• Gathered data of different clients from codify/pace database and contractor according to the requirement of manager. Pulling out report from SSRS, comparing with the feedback data from third-party.• Clean, analyzed data, and generated dashboards in Tableau, Excel, and SSRS to provide the management group with the most straightforward business and process intelligence. • Involved in the BI team’s project, helping them to understand and code the coding logic.• Based on the report and dashboard, provide processing improvement strategies. Contact with our contractor company, help them to achieve improvements.

3120 Scott Blvd, Suite 301 ∙ Santa Clara, Ca

• Used Data Scraper collected 20,000 rows of data for Japan Online Shopping Project and Talent Research Project.• Used Tableau Prep to do data wrangling including understanding the data structure, trimming outliers, remove non-values.• Created two huge dashboards for the two projects above and presented them to our client and my supervisor.

Jiangsu, China

• Analyzed the market and consumer data using Excel, SQL, and Tableau. The target was to increase our competitiveness so that we can provide better service and effect collaboration with our clients.• Established a database, including more than 10,000 rows of data like daily sales, product unit price, net profit, etc. Generated dashboards for the project above and find stories hidden in those data.• Based on market-related data, using the Monte Carlo simulation, found that the price in 80 RMB-100 RMB per square meter will make the profit increase 15%, and proposed to expand the market.

Jiangsu, China

• Cleaned the construction material data using Excel and combine multiple Excel sheets into one. • Used Excel to analyze the market of building material include the region, season, type of material, discount, etc., to help the company find the best cooperator to reduce the purchase cost by 15%.• Manipulated more than 30,000 rows of material data using MySQL, write queries to show useful information.• Used advanced Excel skills to generate reports and charts and presented them to my supervisor.

Master'S Degree, Ba

Bachelor'S Degree, Accounting And Finance