Operation Manager

YIQI OU

*** ***** **** ******, *** Angeles CA ***55 (607) 216 - 7221 *****@*******.***

EDUCATION

CORNELL UNIVERSITY, Ithaca, New York 08/2014 – 08/2016 Master of Science – Regional Economics Core Course GPA: 3.72/4.0 Honors: 2016 Harvard Asian International Relationship delegate; 2016 Cornell Contemporary China Symposium(CCCI) moderator ; Cornell Alumni Admissions Ambassador

SUN YAT-SEN UNIVERSITY (SYSU), Canton, China 09/2010 – 06/2014 Bachelor of Arts – Communication and Design Core Course GPA: 4.0/4.0 Honors: First scholarship for academic excellence; Ranked 1st in the JNJ Tomorrow Leader School (TSL) Plan Contest PROFESSIONAL EXPERIENCE

Operation Manager, Dafang USA LLC, Los Angeles 07/2017 – present

• Managed and directed all departments in establishing organizational and systematic approaches to their goals; boosted efficiency and acted as problem solver to ensure the operation running smoothly between Dafang USA LLC and its headquarter in China

• Developed and outsourced business cooperation with other logistics companies; assisted president to conduct business negotiation with potential clients

• Traced and monitored KPIs by analyzing operational data and generating reports; promoted marketing channels and managed client relationships between China and US

Data Research Analyst, GROUP NINE MEDIA, New York 04/2017 – 07/2017

• Conducted media market research and analyze ROI for both competitors and company’s own brands

• Corrected and updated over 1000 Historical Data Reports as a result of extensive research and uncovering of data reporting errors by using Excel and Tableau

• Assisted higher management in the creation of KPI to better estimate company’s performance and develop future strategies Business Operation Associate/Consultant, MINTY MENTORS, New York 02/2017 – 03/2017

• Developed and executed marketing campaign; outsourced and developed cooperation with different investment banking and management consulting companies like State Street, Goldman Sachs, McKinsey; developed promotion channels (B2C business)

• Conducted conversion analysis based on the active users and affected revenue; managed official WeChat account and promoted activities on the account

Research Assistant, CORNELL UNIVERSITY, Ithaca 09/2016 – 11/2016

• Sourcing and mining the database for research using SQL and R; helped to collect and arrange the reference articles Market Assistant, MAGIC TRADE SHOW, Las Vegas 08/2016 – 08/2016

• Developed and sustained strong partner relationships by providing market insights, consultation, revenue management advice and marketing opportunities; successfully attracted 13 new clients to cooperate on the spot

• Finalized a 15,000 unit order with Bristmfg Co. on the spot during the trade show and brought revenue up to $255,000

• Liaised with and facilitated communication between clients from all over the countries and manufactory manager in China to convert business requirements into technical standard for machining operation Business Analyst, IBM GLOBAL BUSINESS SERVICE, China 07/2015 – 08/2015

• Participated in a project helping Honda expand its production line in China, collaborating with multidisciplinary team to create business strategy for client by performing SPAP and SWOT analysis

• Prepared data driven insights and recommendations through quantitative analysis to help strategic decision making; analyzed and linked multiple sets of data in spreadsheets (sales, inventory, location etc.); used various software package to conduct optimization analysis (linear programming) and price-based cost estimation

• Communicated efficiently with internal and external colleagues, using Tableau to generate impactful, interactive visualizations in the presentation and reports for client and associates Associate Project Manager, LEMON CULTURE COMMUNICATION CO. LTD., China 04/2013 – 07/2013

• Key contributor in strategic consulting; analyzed potential customer group and developed end-to-end communication strategies that capitalized on digital technologies by conducting market research; developed social media strategy to attract new target market segment and drive up engagement rate for China Unicom (No.1 telecommunication company in China), increasing estimated sales revenue by 30% (2.2 million RMB) per month

• Coordinated with C-suit of China Unicom and Project manager to develop impactful strategies, positioning and messaging to perpetuate essence of corporate brand

• Assisted in designing an alternative advertising and promotion campaign under time constraint; ensured the execution of campaign

• Prepared presentation as well as data visualization materials by using PowerPoint and Prezi for clients and manager; diligent adherence to complex, internal and external deliverables ensuring accuracy and timely delivery SKILLS

Data Analysis/Processing

STATA Matlab Office Suites Excel VBA SQL Python MySQL Teradata RDMS

• Master Thesis Correlation between Interprovincial Migration and Cites’ Economic Development in China: constructed dynamic simultaneous equations model; collected provincial and city-level data from different data sources; connected spreadsheets in Excel to STATA and R; estimated model with 3SLS in STATA and R; conducted data analysis based on the results and generated data-driven insight into report and posting report to my advisors and other audiences.

• Financial Model Construction Asset Allocation Model based on Markoviz Model: established quantitative risk measurement; applied Markoviz Model into quantitative analysis and measurement of the asset allocation for various type of people; constructed automatic user-friendly self-asset allocation calculation model by using Advanced Excel Tools

(using IF, Pivot Table, Conditional formatting, VLookup functions) and VBA.

• SQL Final Project Business Analysis for Dognition Website: constructed business plan using SPAP to help Dognition Website increasing its subscription numbers; used SQL to write complex queries and manage database in MySQL in order to analyze and solve the business problem.

Data Visualization

Adobe PS Adobe AE Adobe Illustrator Excel Tableau GIS

• GIS Final Project Estimation on Hi-Tech Industry Distribution in Ithaca: collected county and village level data sets from county governmental website and US Census Bureau; chose and matched coordinate systems for data; changed the XY data into point shape files and joined the attribute table and calculated; used different estimation tools (Buffer, Multiple Ring Buffer) in GIS to visualize different study aspects of these Hi-Tech companies’ distribution and constructed maps; gave suggestion based on the maps.

• Tableau Project US Data-Related Job Market Analysis for Non-US Citizen: collected and manipulated 200 thousand data in Tableau; conducting data analysis by using trend line, formula calculation, filter, histogram and line graph; understood the ranking of salary among different job categories and the differences in salary for each job categories among different states based on the analysis result; generated results into report and posted it on the website. Financial Modelling

Excel VBA

Business Modelling

Excel VBA STATA CFA Operation Forecasting Optimization Statistical Modelling/Econometrics Modelling

Excel Stata Tableau Multivariate Experiment Linear/Nonlinear Statistical modelling Willing to relocate for right position, H1-B Transfer required

Contact this candidate