Gloria Yu

815-***-**** ad08r3@r.postjobfree.com Naperville, IL

Business Analyst / Data Analyst / Business Intelligence Specialist Results-oriented data analyst with a wealth of experience in data analytics. Proficient in SQL, PowerBI, SAS, advanced Excel, and other Microsoft tools. Fueled by a passion for uncovering data patterns and translating complex insights into clear and concise communication. A rapid learner and adept multitasker.

Skills: SQL, Power BI, Tableau, SAS (Certified), Advanced Excel,,statistical analysis, PowerPoint PROFESSIONAL EXPERIENCE

Tony’s Fresh Market November 2022 - Present Business Analyst

● Proficient in writing intricate SQL queries, automating reports, optimizing reporting performance, and analyzing large data sets to extract actionable insights to senior management for data-driven decision-making.

● Proactively analyzed suspicious transactions/payments patterns, provided valuable fraud risk reports to the Loss Prevention team to reduce shrink on cash equivalents such as price modifications, refunds etc.

● Leveraged PowerBI to enhance E-commerce reporting; established key metrics for loyalty programs and drove penetration; delivered digital coupon recap insights.

● Conducted in-depth promotion analysis, assessed advertising effectiveness, and generated forecasting through statistical analysis.

● Identified and reconciled a $130k coupon expense on the Profit and Loss statement. Tsalach Corporate Finance December 2015 - October 2016 Research Analyst

● Conducted industrial research, created 8,800 email marketing lists utilizing SQL & CRM tools.

● Resolved database issues such as data loading and migration. Edenred April 2011 - September 2011 Marketing and Data Analyst

● Grew customer base via multi-channels including paid media, emails, call center, with coverage of 100,000 target customers.

● Collaborated with internal and external partners and provided sales enablement.

● Expanded product line from 6 to 12 including e-gift cards, coupon, and redemption projects. Top Group September 2008 - March 2011 Product Specialist

● Analyzed complex large sales data set with advanced Excel and initiated campaigns accordingly.

● Led new SKU development and launching, built positioning strategy and marketing mix.

● Conducted quantitative and qualitative analysis and consumer survey.

● Drafted and executed marketing planning for 10 products, set segmentation, targeting, & Positioning.

EDUCATION BACKGROUND

Northern Illinois University, DeKalb, IL M.B.A

East China University of Technology Bachelor of Economics, Economics and Trade