• Processing research papers submitted to Kilts Center for review, making sure that the researchers abide by the data policies strictly• Managing the Kilts Center research database

• Developed daily & weekly dashboards with quantifiable business metrics, driving data-driven insights for over 20 stakeholders• Pioneered the design, implementation, and maintenance Looker features, such as upgrading Looker versions, creating curated explores for deep dive analysis, and importing and surfacing data metrics from a third-party platform• Partnered with Product Managers to develop KPIs, assess trade-offs between approaches, and deliver actionable recommendations for monthly app release• Designed dimensional models & optimized existing models in dbt or MySQL• Evangelized best practices in analytics by cultivating stakeholder relationships and creating end user resources such as weekly Looker training and self-served training slides

• Helping people across the company design effective analytics metrics• Translating real-world questions into database queries• Collaborating with a diverse team across engineering, care operations, product management, sales and marketing, and more• Building reports and dashboards through Looker that provide insight into the company's operations

• Cleaning up and organizing the reports created on the BI platform DOMO as well as maintaining data consistency between system and DOMO to ensure each department can efficiently find the reports to meet their current and future needs• Managing warehouse space planning files to include seasonality, expected Inbound/Outbound orders, channels, and any other factors. Making sure they are accurate and updated, displaying a transparent flow of inventory for both Inbound and Outbound. Communicating with directors involved with inventory control and space planning to standardize and optimize the process. • Creating ad-hoc reports using Microsoft Access as well as DOMO to meet different departments’ needs and requests• Analyzing the tracking status of current purchase orders to identify problems related to warehouse operation or shipping agents.

• Leading the initiation and development of the company’s market in China through market research and advertisement testing analysis on Weibo and WeChat to deliver the best marketing strategies• Designing and running queries on MySQL to generate daily application status and user profile reports to manage and support the Sales Department’s projects and meet different requirements• Communicating with students via phone and e-mail to track their application process and conduct interviews• Running ad-hoc analyses and data manipulation based on the company’s priorities• Learning Salesforce platform in order to engage with clients and manage projects more efficiently

• Worked closely with the sales department to perform both company and industry market research for over 100 companies• Created 7 sales dashboard reports by conducting product sales data analysis filtered by product types, sales regions, and time periods, using Excel Pivot Tables, vlookups, functions, and charts from over 30,000 sales records monthly under minimal supervision• Gave presentations to board members based on sales reports to assist in future business strategies• Analyzed and improved company database stored in Zoho CRM• Proposed goals and business plans for client-facing sales teams, and maintained market research data

• Answered questions for students from their homework and lectures• Helped students to clarify important concepts and to prepare for exams• Provided counseling for study strategies

• Performed donor research for different projects and created consolidated donor email lists• Collected and organized clients profile using Microsoft Excel and FileMaker Pro for a database of 3,000 clients• Updated database to fulfill ad-hoc requests and strategic projects for management• Assisted in the development and execution of campaigns for clients