analyst

SHIQI(Isabela) YANG

903-***-**** • ***********@*******.*** • LinkedIn

EDUCATION

University of Pittsburgh, Joseph M. Katz Graduate School of Business Pittsburgh, PA M.S. in Marketing Science & Business Analytics (STEM Designated) Sep 2022 - June 2024 Sichuan International Studies University (SISU) Chongqing, China Dual Degree: B.S. in Finance and B.A. in Spanish Sep 2016 - June 2021 SKILLS

Certification: Tableau Desktop Specialist, Microsoft Access Expert, Microsoft Office Specialist: Expert (Office 2019), Google Analytics, Social Media Marketing, Google Ads Search Technical: R, MySQL, SPSS, Infegy, Excel including PivotTables, PHStat, Solver, Adobe Suite(Illustrator, Photoshop, InDesign, Adobe Analytics), Tableau, Access

Other: INSIDE LVMH, Jewellery: Gemstones, Metal, Fashion, Film and Objects, Winner of logo design competition from Universities Studies Abroad Consortium in Madrid, Volunteer at the Sichuan Bifeng Gorge Panda Base, Henry E. Haller Jr. Global EBL Travel Award($1000)

EXPERIENCE

PNC Supply Chain Management Development Program Pittsburgh, PA Analyst (Xmind,Tableau Prep, Excel pivot table, R, Tableau, PowerPoint ) Sep 2023 - Dec 2023

Enhanced process efficiency by building supply chain flow charts to identify segments opportunity.

Conducted qualitative analysis by interviewing 21 supply chain team members to find more details in financial supply chain.

Managed 20,000-row, 400-column datasets with Tableau Prep and Excel, quantifying step times to optimize operational analytics.

Built a classification tree in R to identify key time drains with, anticipated savings of up to 6000 hours.

Created a Tableau dashboard to visualize supply chain system problems, reporting a three-year descriptive analysis to management.

Nollapelli Pittsburgh, PA

Marketing Analyst (Google Analytics, Shopify Analytics June 2023 - July 2023

Conducted a competitive analysis of the textile market competition utilizing Statista data to inform marketing strategy.

Used Google Analytics to track ad effectiveness and online customer behaviors, achieving a 20% reduction in bounce rate.

Integrated Instagram data and company data to identify key engagemernt drivers and enhance client acquisition on social media.

Optimized web content and style via Shopify analytics, increasing brand visibility by 20% and reducing excess inventory by 30%. Deloitte GDC Global Delivery Center Chongqing, China Auditor Intern Mar 2022 - April 2022

Reconcile company financial data using excel models, ensuring breakdown balancing for audit compliance.

Verified financial data and reporting accuracy by performing account settlements.

Deployed standardized sampling as part of audits, enhancing procedural consistency. ICBC-AXA Life Insurance Group Insurance Sale Department Chongqing, China Group Insurance Sale Department Intern Jan 2022 - Feb 2022

Marketed insurance products to over 10000 prospective clients by HR in person.

Created marketing proposals by reviewing proposal criteria, gathering data and developing content.

Responded to customer questions on coverage and policy details. Clients include Fortune 500 companies. Industrial and Commercial Bank of China Chongqing, China Rotational Internship Aug 2019 - Oct 2019

Educated customers on the benefits of mobile banking and increased adoption of electronic banking services.

Analyzed mobile app reviews, researched competitor offerings, and presented findings to management team.

Persuaded manager in marketing loan product to real estate companies by researching client fit for product.

Investigated corporation status and identified problematic companies for additional risk review.

Contact this candidate