Sophia (Sijia) Wang Email & Phone Number

Ventura, California, United States

• Utilizing my troubleshooting skills as a subject matter expert unblocking over $100M amount in reported client spend block during the 2023 fiscal year.
• Actively participating in client meetings, MQ (market quality) team meetings, Walmart meetings, Engineer meetings and collabewat by effectively communicating solutions, setting expectations, identifying gaps, and.
• Leading the Marketplace Quality taskforce, build new processes and relationships across teams globally.
• Built great working relationships with the Walmart team and is a key contributor on Walmart taskforce.o Administer trainings detailing the discrepancy troubleshot and Market Quality initial troubleshot process.o.
• Mentor and guide multiple new hires, instilling best practices in alignment with Support standards. Provide onboarding trainings and team mentorship to both irvine team and ventura team.
• Elevated the team’s Knowledge Base by creating and updating articles, becoming a go-to resource for the NAMER region.

Ventura County, California, United States

• Troubleshoot HTML, JavaScript, API, XML
• Maintain the company’s ticketing system; answer, troubleshoot, and resolvevarious technical issues related to The Trade Desk’s trading platform
• SQL, JIRA, databrick
• Problem-solving and issue troubleshooting
• Issue escalation tracking and response management
• Answer, troubleshoot, and resolve technical issues related to the platform

City Of Industry, California, United States

• Conducted data model, data visualizations, reports from MS SQL Server, Power BI and Sage.
• Developed Predictive Model for the inventory re-order point and forecasting sales using Python, R and MS Excel
• Identified, analyzed, cleaned, and interpreted trends or patterns in data sets, filtered and cleaned data by reviewing datasets and performance indicators to locate and correct data and code problems (Mainly used MS.
• Conducted market research for potential domestic or international vendors
• Transformed data into information to help the organization with decision-making

Irvine, California, United States

• Performed data analytics on customer segmentation based on reseller's purchase history and identify the 'Diamonds in the Rough' (--- i.e., undervalued superstar customers that need more attention.) using R, Python.
• Identified, analyzed, cleaned, and interpreted trends or patterns in data sets, filtered and cleaned data by reviewing datasets and performance indicators to locate and correct data and code problems
• Explored and analyzed web scraped data of resellers and their purchase history in the form of anonymized variables
• Developed ML model to identify undervalued customer segments, providing business insights and recommendation for each identified segment to increase revenue stream from those customers
• Used insights from data exploration to build comprehensive findings with advanced and effective visualizations (using Tableau and Python) and insights

42 N Chestnut St, Ventura, CA 93001

• Performed day-to-day financial transactions including classifying,computing and posting revenue data by using Excel Vlookup, Pivot table,and Macro functions
• Verified billing accounts with accounts receivable ledger to ensure that allprepayments are accounted for and properly applied to the invoices
• Conducted monthly statistical analysis and predictive models on differentAccount Receivable categories using Excel

388 East Valley Blvd, Alhambra, CA 91801

• Researched bank’s internal databases to provide bank's overalldemographics breakdown, wealth concentration breakdown, comparedbank's demographics with LA County open datasets and the SCAG’s2017 Southern California.
• Congregated customers’ needs by correlating different customer datasets(e.g. Savings, CDs, Mortgages (Trust Deeds), and Business Accounts) toidentify opportunities to sell new products to specific customers
• Conducted financial modeling, risk assessment, and other analysis aswarranted, arranged related documentation for commercial transactions
• Mainly used MS Excel, SAS, Python, and SQL Database

Malibu

• Leading the largest multicultural association of Pepperdine University
• Bridging the gap between the Chinese and Western world through 40+ annual career, social, educational, and cultural events
• Organized public fundraise and relationship maintaining with sponsors
• Ensuring our members a homely community that prepares them for their future career
• Hosted events including academic study, social networking, job hunting, seminars, Spring Festival Gala, and outside activities
• Developed and maintained public relationships and networks with universities’ associations

California, United States

• Manage the west coast team, recruited qualified student ambassador and trainees for the company
• Introduced the benefits of taking the course in international summer school and attracted new members by effective market strategies, in order to increase the customer conversion rate
• Acquired the skills to work closely as a group via the online instrument(Mainly using Skype and YY Voice)

Malibu, California, United States

• Greeted and directed customers, assist library patron at the circulation desk
• Answered multiple telephone lines, make referrals and taking messages as appropriate
• Updated library materials and assist with any library projects
• Maintained records as required by Library protocol

Santa Monica, California, United States

• Assisted in the facilitation of education seminars to clients about the purpose and details of financial products, services and strategies
• Built and maintain client base, keep client plans up-to-date, and provide excellent service
• Worked as a team to analyze financial information obtained from clients to determine strategies, products and services to help clients meet their financial objectives

Master Of Science - Ms, Business Analytics, 3.80

Bachelor'S Degree, Bachelor Of Accounting; Bachelor Of Business Administration; Minor In Applied Mathematics

Activities and Societies: Career Planning Boot Camp, Chinese-American Elected Officials, Chinese-American Engineers and Scientists.

High School