EDUCATION

STEPHEN M. ROSS SCHOOL OF BUSINESS, UNIVERSITY OF MICHIGAN - ANN ARBOR

BACHELOR OF BUSINESS ADMINISTRATION

SEP 2015 - MAY 2019

Concentrations: Marketing, Technology & Operations

MINOR IN WRITING, SWEETLAND WRITING PROGRAM

MINOR IN APPLIED STATISTICS

COMPETENCIES

  • 9-time book publisher/designer/art and fiction writing contributor, including official creative anthology, "Confined Connections", purchasable on Amazon

  • Designed Snapchat filter for Fortune 500 company Cummins Inc, with 5.2k+ views in under 2 days

  • 17 years of drawing, graphic design, animation, publication, traditional Chinese painting, digital painting (Adobe products, Procreate) and user experience, viewable through portfolio site and freelancing for organizations

  • Self-taught Adobe Creative Cloud products and other design software since age 12

    • Adobe Certified Professional in Visual Design: focuses in Photoshop, InDesign​

  • Certified in all 5 Oracle NetSuite Tech Certifications (SuiteFoundations, Financial User, SuiteAnalytics, Administrator, and ERP Consultant)

  • Proficient in C++, Python, R, Microsoft Office products, HTML, Microsoft AzureML

  • Fluent in Mandarin Chinese, Shanghai Chinese, and self-learned basic spoken Japanese

  • Yearly Juror for Scholastic Writing Awards: Northeast Indiana and Northwest Ohio Division Grades 7-12

CERTIFICATIONS

  • Adobe Certified Associate in Print & Digital Publication Using Adobe InDesign

  • Adobe Certified Associate in Visual Design Using Adobe Photoshop

  • Adobe Certified Professional in Visual Design

  • Oracle NetSuite SuiteFoundations Certification

  • Oracle NetSuite Financial User Certification

  • Oracle NetSuite SuiteAnalytics Certification

  • Oracle NetSuite Administrator Certification

  • Oracle NetSuite ERP Consultant Certification

EXPERIENCE

ORACLE AMERICA INC. | NETSUITE

Staff Technology Consultant

OCT 2020 - PRESENT

CUMMINS INC.

Product Management Intern, Engine Business Unit

MAY 2018 - AUG 2018

  • Instituted business unit-wide cross-functional market evaluation of North America Heavy-Duty Truck Market from all stages of market strategies by creating 100+ slides and accompanying files’ worth of market intel and recommendations, whose framework is now adopted by entire Product Management team of 60+ employees to update yearly for continuous improvement of Cummins’ market business strategy in their leading market

  • Evaluated financial data for company's leading three engine products using Excel and ThinkCell software to create profitability review that analyzed profit margins and gave cross-functional action items for teams to improve future performance, and expanded into full practice of regular quarterly profitability reviews within business unit

  • Synthesized Voice of Customer and promotion material and facilitated communications between Australia, Mexico, and England offices to create new product introduction review for upcoming 2020 engine, supporting company's large-scale overseas product release

HARRIS FRASER GROUP 晉裕集團 - HONG KONG

Financial Analyst Intern

MAY 2017 - JUL 2017

  • Researched market impact of recent international current events including UK election, Brexit negotiations, and Indian and Indonesian economies to produce research material and recommendations that was used in managers’ market reports and client presentations

  • Analyzed over 300 fund statistics and their risk tolerance to apprise company's activities and maintain company's good relations standing with financial regulations, enabling successful due diligence and streamlining of company’s data for sound investment decisions

  • Communicated internship in secondary language Mandarin to further integrate into co-workers' natural environment, team collaboration, and culture

BLUEPRINT LITERARY MAGAZINE, UNIVERSITY OF MICHIGAN

Editor in Chief // President

SEP 2017 - MAY 2019

  • Pioneered and oversaw campus-wide art gallery exhibitions, collaborative writing workshops, and high-quality book publications for U-M campus, increasing popularity and current year's club membership by 300% and raising over $700 total in sales

  • Single-handedly taught Adobe InDesign under one week's deadline and limited staffing during journal and campaign design to club members that averted production failure and increased magazine release attendance from previous years by 200%

  • Revitalized organization through rebuilding finance, marketing, public relations, and creative design sub-functions with board members to reinstate organization as one of the most well-known student journals across UM, and dominant journal within UM Engineering

  • Links: http://www.blueprintlm.com/; https://issuu.com/blueprintlm

Managing Editor // Vice President

SEP 2016 - AUG 2017

  • Led cross-functional team of 15 through club activities and magazine production process to create successful team management, given club members' varied creative and academic backgrounds, and substantial magazine popularity around campus, enabling improved club unity and satisfying completion of club deliverables

  • Coordinated sub-team of 6 through most labor-intensive layout design aspect of magazine production while coordinating with editing and advertising teams under tight deadlines, strengthening inter-club communications and spearheaded completion of publication

  • Administered magazine sales and hosted accompanying art gallery exhibition at release, increasing popularity and current year's club membership by 300%

Layout Design Consultant

JAN 2016 - AUG 2016

  • Redesigned entire magazine layout for two consecutive years and structure of arts and literary material under limited staffing and remaining staff's limited knowledge of technical design skills, enhancing aesthetic showcase of works

  • Manage members in club activities to promote for creative submissions through flyers, social media, and campus outreach, resulting in greater magazine publicity

ASIAN CONSORTIUM FOR ECONOMIC DEVELOPMENT, UNIVERSITY OF MICHIGAN

Senior Marketing Designer

SEP 2015 - MAY 2019

  • Designed flyer and advertisements for four consecutive years of ACED’s campus-wide event WassUp China to target audience interested in Asian culture, economic current events, and business, increasing event and guest speaker attendance

  • Spearheaded advertising strategy for campus-wide events, increasing club popularity and sustaining club's purpose of economic current events awareness

LLOYD HALL SCHOLARS PROGRAM, UNIVERSITY OF MICHIGAN

Online Journal Initiative Founder / Website Designer

SEP 2017 - FEB 2019

  • Helmed website project for Lloyd Hall Scholars Program's Arts & Literary Journal to create new online channel for journal publicity, expecting to expand visibility for program and number of open-source creative outlets for UM students

  • Initiated production of official artistic promotional stickers, added to community's brand presence and recognition

Student Assistant

SEP 2016 - APRIL 2017

  • Mentored 150 first-year students of residential arts & writing community in transitioning into college academic and residential life through advising on academics, events, and opportunities offered by LHSP and U-M, encouraging active club and campus integration

  • Founded new digital media club to teach 15 members technical design software and marketing skills, heightening entire community's online media presence and public image

  • Recorded aspects of community's daily residential life and notable events for U-M-wide Michigan Learning Community promotional video, expecting to increase program's public image to prospective high school applicants

Student Recruiter

JAN 2016 - APRIL 2016

  • Introduced program requirements and extracurricular involvement through promotional speeches and email correspondence under tight deadlines to prospective U-M applicants encouraging interest of joining the LHSP community

  • Promoted Lloyd Hall Scholars Program by advertising at campus orientations and giving informational tours of residential building and facilities, enabling improved insight into college residential life and community atmosphere to incoming students

MAIZE & BLUE CUPBOARD, UNIVERSITY OF MICHIGAN

Vice President of Finance

JAN 2016 - APRIL 2017

  • Manage banking accounts for certified non-profit food distribution club, ensuring successful club and distribution function for over 260 distribution customers

  • Direct finance team in organizing fundraising events and investigated grant petitions to fund promotional events and supplies for successful distribution function, supporting increase of distribution participation up by 600%

MICHIGAN PHOTOGRAPHY, UNIVERSITY OF MICHIGAN

Exhibition Committee

JAN 2016 - APRIL 2016

  • Investigated funding opportunities to support successful host of campus-wide club photography exhibition, resulting in substantial location and amenities for displaying the featured photographs

  • Designed promotional flyers flyers for advertising photo exhibition showcase, resulting in successful club's first exhibition to date with high visitor turnout

  • Coordinated club logo competition within club members under tight deadline in time for upcoming exhibition event, supporting executive board initiatives to promote club growth

ARTS AT MICHIGAN, UNIVERSITY OF MICHIGAN

Arts Ambassador

SEP 2015 - APRIL 2016

  • Planned, hosted, and led arts-related campus-wide events with the goal of fun, relaxing, and educational for any individuals with creative minds

  • Advertise creativity-based events and activities such as theatre shows, concerts, and exhibitions sponsored by other programs or by the parent program Arts at Michigan across campus

  • Technology Implementation & Business Consulting for ERP systems at Oracle | NetSuite - for Software, Advertising, Media, and Publishing Industries

  • Certified in all 5 Oracle NetSuite Tech Certifications (SuiteFoundations, Financial User, SuiteAnalytics, Administrator, and ERP Consultant)

Associate Technology Consultant

JUL 2019 - SEP 2020

 

© 2020 KATHERINE QIAO

@truestofmyths

Artist | Writer | Publisher

Business | Marketing | Consulting

Technology | Design

  • LinkedIn Social Icon
  • Instagram
  • Adobe Behance Logo