Experience

• 

  Lakeshore Learning Materials

  • Carson, California, United States

  • Data Analyst

    • Sep 2022 - Present
    • Carson, California, United States

• 

  Dunn-Edwards Corporation

  • United States
  • Chemical Manufacturing
  • 700 & Above Employee

  • Sales Data Analyst 1

    • Jan 2021 - Sep 2022

    - Create SQO1 and BW queries to retrieve source data from SAP.- Retrieve data from Postgres database- Load raw data into Power Query and transform data for processing.- Formulate growth measures and update parameters.- Create Pivot tables for data visualization.- Create ad-hoc SQVI queries aiding Sales, Marketing and Finance teams.- Build uploading portal and simplify contracts filing process via Microsoft Forms and Power Automate.- Build auto-distributed daily/ weekly reports to Marketing department and Sales Team via SAP-SQ01 queries and Power Automate.- Build weekly reminders for Sales Reps to turn in New Account applications via Power Automate.- Build sales dashboard via Power BI.- Track monthly sales, growth trends, budget attainments, district and sales employee rankings.- Create and manage departmental Sharepoint’s contents. - Administer incentive program for 1,000+ professionals and provide quarterly updates to sales team.- Assist VP of Sales in reviewing incentive agreements and update incentive payout status on internal site.- Collaborate with Credit, Customer Service, Account Payables, Account Receivables, and Sales teams to deliver incentive payouts within promised timeframes.- Maintain data integrity and update sales force records in mySQL.

  • Sales Administrative Support

    • Jan 2020 - Jan 2021

    - Set up 1,500+ new accounts and updated customer data.- Composed training materials in writing via OneNotes and PowerPoint and visuals via Microsoft Streams.- Conducted virtual trainings for team members and cross-departments members via Microsoft Teams.

• 

  Kaiser Permanente

  • Mail Order Processing Center

  • Pharmacy Assistant

    • Sep 2015 - Jan 2020
    • Mail Order Processing Center

    - Sent refill requests to doctors’ office to obtain refill authorization for patients- Created, updated list of inactive physicians, and communicated changes to team to ensure refill requests were sent to correct physicians- Provided pharmaceutical care for patients in answering phone calls regarding ordering/refilling prescriptions, members’ benefits, billing issues, shipment statuses, refunds, etc.- Entered orders into secured database and maintain integrity of data entries.- Assisted pharmacists and supervisors with other assigned tasks.

• 

  Underwater World Enterprises

  • Los Angles, California

  • New Account/ Administration Support

    • Jun 2014 - Sep 2015
    • Los Angles, California

    - Reviewed about 20 new account applications monthly and monitor new account purchases.- Assisted sales representatives in setting sales targets and developing strategies to meet goals.- Supervised new hire training and development.- Multitasked office duties: screening phone calls, declaring custom entries for imports and exports, administering aquarium light repairs, preparing invoices and shipping documents, dispatching drivers, tracking shipments and communicating with customers, and generating weekly reports.

• 

  Daiso USA

  • Artesia, California

  • Cashier/ Leader Assistant

    • Aug 2013 - Aug 2014
    • Artesia, California

    - Helped customers locate items and effectively communicated additional product information to customers.- Assisted store manager and store lead in scheduling staff members, reporting absences, designing signs, recording weekly invoices, maintaining store’s neatness, and generating daily sales reports.- Collaborated with floor staffs to display merchandise, procure and optimize store inventory levels.- Trained and evaluated new employees.- Performed administrative functions: answering phones, replying emails, posting announcements, opening and closing duties.

• 

  Society for Advancement of Management

  • Society for Advancement of Management at California State University, Long Beach

  • Operations and Supply Chain Management Chair

    • Aug 2013 - May 2014
    • Society for Advancement of Management at California State University, Long Beach

    - Collaborated with Supply Chain Management department chair and corporate representatives from Toyota and Boeing to host the annual Operations and Supply Chain Management Speaker Panel.- Organized and oversaw various fundraising events.- Designed event flyers and admission tickets.

• 

  Long Beach City College

  • United States
  • Higher Education
  • 700 & Above Employee

  • Math Tutor

    • Jan 2010 - Dec 2013

    - Assisted approximately 90 students per week from pre-algebra to statistics classes.- Participated in training meetings to enhance tutoring and interacting skills with students.

  • Staff Writer

    • Aug 2011 - May 2012

    - Researched on chosen topics from the internet and other resources.- Conducted e-mail, phone, and in-person interviews to obtain information.- Traveled to assigned locations to gather news.- Wrote articles, took photographs, and produced videos about news, city styles, sports, and editorials regarding issues on campus.

  • Student Assistant

    • Jun 2010 - May 2012

    - Filed and updated roughly 100 application statuses for admission per semester.- Scheduled weekly appointments for students with immigration advisers.- Responded to local and international phone calls and email inquiries.- Trained new employees on office related tasks.- Represented international students to share opinions and proposed petition in the Board of Trustees meetings.