Claire Yang Email & Phone Number

Menlo Park, CA, US

Chicago, Illinois, US

Worldwide, OO

• Used SQL to identify risk indicators for suspicious activities in credit cards approvals by querying through demographic information of bankers and clients, and performing exploratory data analysis
• Automated processes with Python scripts for a top Pharmaceutical Company with over a million rows of excel sheets and reduce processing time by 70%
• Performed cost allocation analysis for a major Spinoff process by using revenue, manufacturing site, or market drivers, and create ad-hoc financial reports
• Created data visualizations using Tableau dashboards to track progress of team projects and KPIs
• Kept projects on path, clear blockers, and provide updates between management and consultants

Austin, Texas, US

• Constructed pricing valuation model for single family houses with data extracted over half a million rows of real estate market information from 2015 to 2017 in the Dallas Fort Worth Area from MLS Oracle Database
• Cleansed data, performed exploratory data analysis, and built statistical modeling such as random forest and linear regression to improve valuation accuracy
• Outperformed the company’s existing model’s prediction accuracy by 20%
• Demonstrated results using heatmap and word cloud visualizations using Tableau and Python

Worldwide, OO

• Prepared tax paperwork, allocations, K-1s, and tax returns for pass-through entities and trusts
• Automated excel reports updating process and reduced time by over 60%
• Communicated to the team and clients regarding project status, missing information, and discrepancies
• Conducted regulation researches to determine the correct tax treatment of transactions

Chicago, IL, US

• Created customized SharePoint User Guides for Restricted Accounting team and presented Introduction to SharePoint to restricted accounting team with department manager. Assisted with SP troubleshooting.
• Prepared Process Documentation on various topics for internal users and auditors.
• Using PeopleSoft, prepared for general ledger journal entries and budget change entries.
• Assisted with grant billing process, reconciliation, salary reallocation, benefit adjustment and reports, along with audit responses and compliance.
• Using ImageNow software, captured and maintained electronic files, and engage in special projects.

Chicago, IL, US

• Facilitated the Common Hour curriculum for freshmen weekly; mentored new students in their transitions to college through Explore Chicago course, and helped students with academic, extracurricular activities and.
• Provided guidance to new students about exploring the city of Chicago and shared insights about DePaul’s Vincentian value.

Chicago, IL, US

• Collaborated on ISEE events for over 200 members, served as the primary public speaker and photographer and assisted with marketing for ISEE program
• Oversaw the budget of ISEE and represented ISEE at Student Involvement Fair and other school events.
• Administered procedures for recruiting new mentors and mentees, and conducted interviews
• Responsible for program communication, and maintenance of members database

Worldwide, OO

• Prepared 40+ inpatriate and expatriate Federal and State tax returns and extensions.
• Assisted with hypothetical tax, payments and withholding calculations.
• Participated in client orientation meetings, helping them gain understanding of inpatriate/expatriate tax implications and compliance.

• Engaged in workshops and activities that emphasize on leadership, team-building, interpersonal and negotiation skills, and gained better understanding of diversity, community involvement, client value and integrity.
• Participated in Junior Achievement Day and taught 5th grade students on the topic “Our Nation.”
• Explored Deloitte with staff professionals from Tax and Audit service lines.

Master Of Science, Business Analytics

Bachelor Of Science (Bs), Honors Accounting And Finance