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 fulfilling client needs.● 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 Successfully reduced time to resolve requests by 50%, from 2h per ticket to 1h.● 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. ●A contributor over the years on processes like Thirdparty Data Billing rules and Platform Support’s old dynamic creative rule process, Followed these both closely and worked with engineering until these were built into the UI.

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• QA Testing and Validation• Support for application issues; ensuring that incidents within our platform ortools are addressed within established SLAs• Responsible for owning incidents, including escalating to other technical teams• Contribute to the company’s Knowledge Base by the creation of new Articlesand updating existing ones• Provide training and mentoring to new hires•Coordinate in-depth training on support-related tools and processes• Propose and plan process improvements

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 Excel, MS SQL and Power BI)• 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, Tableau, and 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• 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 population forecast to identify potentialopportunities regarding new products and new branch locations• 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 • Implemented various budget strategies for different events to ensure financial efficiencyChinese Students and Scholars Association at Pepperdine University is a non-profit, non-political, and unreligious organization on campus. It is a social, cultural, and service-orientated organization that strives to promote the Chinese American culture throughout the Pepperdine community.Pepperdine-CSSA is the only student body in Pepperdine that is authorized by the Education Department of the Chinese Embassy. CSSA is operated by its executive committee, including the president, vice president, career development department, finance department, public relations department, social media department, activity and event department, and IT support department. CSSA grows rapidly with the help of Chinese students and scholars, as well as the Pepperdine community. CSSA becomes the most reliable home for all of the Chinese students and scholars at Pepperdine. It is a bridge that connects the cultures between China and the United States.CSSA offers events such as career advising, alumni speeches, internships, social meetings, which allows our members to improve leadership and communication skills. CSSA also events including the Chinese Spring Festival Gala, night market and so on to enrich Chinese students’ life at Pepperdine University.

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