Weiling Sun Email & Phone Number

• Generated invoices for both transient and charter aircraft, and P&L reports for each job using QuickBooks.
• Verified fuel receipts and calculated the correct fuel charge based on daily jet fuel spot price.
• Processed payments and recorded daily deposits using QuickBooks.
• Initiated collection process for past due accounts by identifying accounts, resending invoices and following up with email.
• Ensured the accuracy of the financial data by reconciling AR accounts during month-end.
• Assisted AP staff and the accounting manager with ad hoc projects such as expense reports, catering recipes, credit card receipts, and bank statements reconciliation.

Portland, Oregon Area

• Researched utility and municipal partnership in deploying distributed sensor network.
• Collected and analyzed smart city projects and current utility sensor use cases by researching online and interviewing industry experts, project managers and vendors.
• Produced a white paper and presented research findings to internal departments.

• Researched the industry trends and collected primary information on researched companies in order to make well-informed recommendations to the portfolio manager
• Closely followed the news on covered stocks and presented weekly findings to the portfolio manager

Portland, Oregon Area

• Managed invoice processing for 6 offices by following both scheduled and on-demand deadlines.
• Processed event reservation payments from external clients using EMS, Banner and Cashnet.
• Researched billing discrepancies that surfaced during work and took the initiative to resolve issues with vendors.
• Ensured exceptional client service by promptly and efficiently resolving inquiries via email and phone.
• Ensured the accuracy and completeness of monthly ageing reports; monitored customer account details for non-payments, delayed payments and initiated the collection process.

• Analyzed and co-managed energy sector investments for School of Business’s student-run long-only value fund benchmarked to the S&P 500 with AUM of $450K. Responsible for $32K of energy sector stocks.
• Performed industry analysis based on knowledge gained from collecting current news and researching databases.
• Produced screening report and Marathon Petroleum Corporation (MPC) buy report by analyzing industry trend, company’s business, SWOT analysis, Porter’s Five Forces, financial analysis, and DCF analysis.

Portland, Oregon Area

• Created daily journal vouchers on Banner and submitting daily operations to Cashnet.
• Performed daily till counts to ensure the front desk agent’s tills are balanced and performed adjustments for out of balance as needed.
• Performed reconciliation for travel agencies, vendor invoices, daily operations of cash and deposit forms, third party billing, credit card authorization and reservations on Oracle Opera.
• Researched and resolved invoice discrepancies on charges of commissions and room rates for guests and travel agency reservations on company websites and Oracle Opera.

Portland, Oregon Area

• Assist with planning and coordination of program activities, such as field trips, local site visits, cultural/recreational events, picnics, etc.
• Independently facilitate on-site logistics on assigned excursions/ field trips to run the program smoothly.

Master Of Science - Ms

Bachelor Of Arts (B.A.)