
GUOJUAN LI
ABOUT ME
EDUCATION
Baruch College, Zicklin School of Business, MS in Accountancy, GPA 3.42 05/21
New York, NY
-
Relevant Coursework: Advanced Financial Accounting; Managerial Accounting; Financial Reporting and Analysis; Taxation of Business Entities; Federal Income Taxation Theory and Practices; Auditing; Auditing and Accounting Information Systems
The University of Mississippi, School of Journalism and New Media, MA in Journalism, GPA: 3.66 05/16
Oxford, MS
-
Graduate Assistant (08/14 – 05/16)
-
Documentary “Waiting for the Dawn: LGBT Culture in China” (Producer, Videographer and Editor)
-
Documentary “Casinos in Mississippi: Worth the Gamble?” (Videographer and Assistant Editor)
Hong Kong Baptist University, BA in International Journalism 06/13 Hong Kong, China
-
Honors: Dean’s List
-
Study Abroad: Hamline University, School of Business (06/11 – 08/11)
EXPERIENCE
Brigade Capital Management LP, Tax Intern 12/20 - Present
New York, NY
-
Review Schedule K-1s, tax returns and tax allocations
-
Calculate monthly tax estimates, foreign tax accruals, and reconcile internal automated financial product information to in-house and external tax calculations
-
Prepare and Review Form SS-4, 8832, W-8/W-9, FBAR, IT-204-LL, 1099
-
Assist in FATCA/CRS fillings, NYC UBT estimate calculation and fillings, quarterly CRT and Sales & Use tax returns
-
Prepare tax workpapers for SPVs, including blocker corporations and partnerships
-
Maintain internal tax calendar and reply to federal, state and local tax notices
Magnum Real Estate Group, Accounting Assistant 05/19 – 11/20
New York, NY
-
Managed account receivables and accounts payable through Yardi System
-
Conducted monthly bank reconciliation for 180+ bank accounts
-
Generated cash flow reports and prepare monthly financial packages for rental buildings
-
Assisted with process regular and payroll checks, invoices and recording into the general ledger
-
Maintained and file all invoices and financial records
Bitpush.news, Media Specialist 05/18 – 04/19
New York, NY
-
Conducted interviews with industry experts and reported on industry conferences
-
Pitched story ideas on a daily basis; researched and wrote articles of trending topics on international cryptocurrencies, blockchain industry and policies
-
Maintained websites and social media
Wall Street Talks, Inc., Media Production Manager 01/17 – 07/18
New York, NY
-
Lead production team, developed and executed media production strategies, plans, budget, and procedures
-
Set interviews with fund managers, real estate brokers on selected investment topics; and set interviews with attorneys on selected immigration topics such as EB2, EB5, and etc.
-
Produced audio lectures on US Corporation Tax, asset allocation in US and wrote scripts for financial news on Sino-American companies’ mergers and acquisitions
-
Maintained the flow of post-production processed from setting lights, shooting, editing video and audio clips
-
Managed 15 US and Chinese social media platforms including Tencent and YouTube; produced content to media partners such as Youku Finance
The 4th Row Films, Post-Production Intern 09/16 – 01/17
New York, NY
-
Responsible for organizing, logging video footage and editing long-format documentaries
-
Developed digital marketing strategies and introduced video and social media channels to the market
-
Worked with creative team to assist in researching image and background files
HONORS
DOCUMENTARY “CASINOS IN MISSISSIPPI: WORTH THE GAMBLE?”
Jackson, MS, Apr.2015
-
Aired on Mississippi statewide public television
-
The first place in the Mississippi Associated Press Awards category for Best Student Documentary
SKILLS
-
Software: Strong proficiency in Microsoft Suite (PivotTable, VLOOKUP); CCH Axcess; Adobe Suite (Premiere Pro, After Effects, Photoshop, Audition, In-Design), Founder and Audacity Portable
-
Languages: Chinese (Native)
VOLUNTEER EXPERIENCE
GLOBAL AMBASSADOR PROGRAM: Global ambassador Aug.2014~ Dec.2014
University, MS
-
Prepared events between international students and American students twice a week
UNITED INNOVATION CHARITY CLUB: Volunteer Teacher Aug.2009~ May.2010
Zhuhai, China
-
Taught children of migrant workers on Mathematics and English 6 hours per week