Xiao Zhang Email & Phone Number

Indianapolis, Indiana, United States

Madison, Wisconsin, United States

• Developing 200+ tables and BI dashboards using SQL and Power BI to showcase insurance & finance operating trends and define 4 industry growth KPIs for stakeholders and clients across the US, leading to an 8% rise in.
• Identifying 3 compliance risk levels by performing A/B Testing and statistical analysis on 165+ companies’ data using R.
• Applying Python and R to execute Hazard & Gamma models and risk analytics on multiple insurance lines. Creating 40+ BI dashboards to track the risk vulnerabilities and defect correlations; proposed 3 insurance process.
• Implementing AWS S3 to Databricks BI data pipeline with ELT, boosting business data transmission efficiency by 150%.

Madison, Wisconsin, United States

• Industrial business intelligence consulting practicum project sponsored by Microsoft Corporation and Wisconsin School of Business.
• Extracted the top 10k cloud-based companies from 300 million domains using random forest models by Python. Utilized R and SQL to generate 35+ tables for exploratory data analysis and 6 cloud platforms’ competitor.
• Developed 5 Power BI interactive dashboards for screening unicorn companies and high-density cloud-based domains. Collaborated with the Azure Business Director on testing key attributes, optimizing target.
• Led the business analyst team in digesting 4 prototypical companies’ profiles and cloud infrastructure trends using SQL.
• Created Tableau stories incorporating 16 identified key features focused on cloud platforms, cloud spending & density, and regions across 6 industries; proposed a marketing strategy aimed at enhancing Azure’s.

716 Langdon Street 217 Red Gym Madison, Wisconsin, 53706

• Offering consulting services to 9,000+ international students on basic immigration guidance, academic success referrals, and resources for transition, health, safety, and well-being from the point of admission to.
• Utilized Terra Dotta Microsoft SQL platform to manage an information and immigration status database for 20,000+ students, reducing database errors and misruns by 15%. Merged 600+ monthly immigration documents and data.
• Incorporating Python to develop an interactive information guidebook, increasing 40% consultation response efficiency.
• Serving as a Terra Dotta SEVIS Assistant to review student immigration document updates before ISS advisor processing.
• Organizing, implementing, and facilitating student engagement opportunities in collaboration with the ISS advisor and academic department. ISS student engagement supports social justice education, leadership.
• Drafted and deployed 6 service expansion plans by discovering service demand focus with Excel pivot tables and V-Lookup.

Houston, Texas, United States

• Evaluated 2022 CaseCTRL's business model, financial report, and growth by MySQL and R Studio. Improved and optimized financial models, financial ratio analysis accuracy, and enterprise value assumption for seed round.
• Established data warehouse of surgical scheduling beta test, drugs usage and surgery types on GCP BigQuery, enabled a BI data pipeline using Google Looker Studio. Enhanced a 200% in business intelligence information.
• Created and presented 10+ BI dashboards for potential clinic clients, led a 20% increase of product beta testing customers.
• Formulated marketing strategy and plan, focusing on marketing efforts for upcoming healthcare conferences. Generating marketing plan and strategic formulation, social media management, copywriting, and copyediting.

Dekalb, Illinois, United States

• Assisted in operating and managing over 30 NCAA sports events for 7 different sports, including FBS football and Division I M/W basketball. The total number of spectators exceeds 100,000.
• Organized and supervise over 300 staff to ensure the smooth running of all aspects of events.
• Coordinated with various campus departments and companies to organize and operate monthly activities, such as cheerleading competitions, band competitions, high school football matches.
• Assisted NIU athletic department ticket office to carry out the daily ticket sorting work. Assist in making NIU annual ticket plan in Men Basketball and Women Basketball.

Rochester Hills, Michigan, United States

• Researched on latest Tik Tok trends on sports and generates Tik Tok promotion plan with community relations manager for 2021 season, including content idea, event promotion plan, and fans interaction.
• Analyzed and integrates kids’ club and community event plans information of 120 MiLB teams and develops USPBL 2021 season kids’ club marketing and community promotion plan.
• Extracted clips from over 150 videos from season 2018 and 2019 to provide abundant edited highlights as source materials for 2021 season promotional videos and social media.

Madison, Wisconsin, United States

• Coordinated in daily inventory management, road-sign marketing, training day setting up, equipment preparation, and operational work during the youth summer baseball & soccer clinic for about 60 kids in Madison, WI area.
• Developed and guided safety and health guidelines for summer clinics regarding the COVID-19 pandemic to ensure the health and safety of staff, youth players, and parents.
• Achieved experiences in marketing and sports event operation including planning, event preparation, execution, and security & safety management.

Remote

• Help the company do the promotion work in the youth football program.
• In the 3 months internship, I successfully promote our product to about 1000 youth football programs in MI, IL, OH, WI, IN, PA, and TX.

Shoreline, Washington, United States

• Cooperated with 7 other peer mentors to plan and operate seven large-scale events with a total of participants reaching 2,000. All the events received over 95% of positive ratings.
• Communicated and coordinated with over 20 campus departments, 30 student organizations, and 10 companies to facilitate quarterly week-long student orientation with over 1,000 new students.
• Managed and guided over 120 volunteers in various events and student orientation such that the group is highly efficient and created a great working environment for all volunteers.
• Assisted in the international education office daily operation, communicated with visitors and students, and assisted academic advisers in planning the curriculum for international students.

Master Of Science - Ms, Business Analytics, 4.0

• Program Excellence Honors Award: Top 5% for excellence in academic performance and extracurricular activities. • Course Highlight.

Bachelor Of Arts - Ba, Sports Management, 3.6

• Honor: 98th James B. Angell Scholar (Two consecutive “A” terms in 2020); Three terms University Honors. • Course Highlights: Principles.

Associate Of Arts - Aa, Business Administration And Management, 3.7