Financial Analyst

Yuling Sun Phone: 206-***-****

Email:***********@*****.***

Summary:

Business/Finance Analyst with accounting experience in global and domestic financial operations for more than 9 years. I have an extensive background in accounting and finance, a deep knowledge of Excel, analysis skills. I speak 3 different languages and deal with finance/accounting issues on an international scale. I am a proactive, hard worker, team oriented, paying attention to detail, and accuracy person. Also, I can effectively manage multiple projects.

Skills:

Applications: SAP (multiple roles), QuickBooks, Microsoft Word, Excel, PowerPoint, FrontPage, Outlook, BWB (Budget Workbench and Budget Restatement tool), MS PlanCast, MS sales, Access, Calypo, MS invoice, MS Inquire, Alfred, pivot tables, power pivot, financial modeling, data queries, Mercury, SQL, currently using Office 2010 products, MS Sharepoint, OneNote.

Work Experience:

Microsoft Corporation (Contractor) 11/2016- current

Financial Advisor

Develop and provide subject matter expertise on management reporting, segment reporting, and external reporting.

Drive high quality financial hierarchy and restatement processes, partner with financial hierarchy owners, and be on point to approve changes that can impact overall P&L results, forecast and budget

Work closely with FP&A team members to interpret and adapt changes to the business organization, financial hierarchies and external financial reporting requirements

Thoroughly understand Microsoft Corporate Finance reporting criteria and facilitate consistency and alignment between Corporate and Finance reports. Partner with key stakeholders and team members to design enhancement and advancement of the existing as well as new ad-hoc reports.

Serve as subject matter expert on hierarchies, restatements, allocations and overall Revenue, COGS, GM and OPEX reporting packages

Partner with team members to produce required standard reports, perspectives and flash reports

Partner with MCI team and Revenue team to meet central reporting requirements, and consistency in product allocations.

Microsoft Corporation (Contractor) 4/2016- 9/2016

Finance Manager

Building and maintaining close/budget/forecast reports using Mercury and MS Sales

Variances analysis to support close, budget and forecast

Supporting driving budget and forecast process

Microsoft Corporation (Contractor) 2014 – 10/2015

Reporting Analyst

Competitive information gathering.

Self-help/self-start and ramp up quickly on reporting tools/data sources and existing reports.

Prepare documents and calculate quarterly GP margins and analyze main drivers.

Validate/reconcile numbers and using data to analysis cause and effect.

Interface and communicate effectively with internal and external partners.

Prepare monthly/quarterly management reports, perform variance and trend analyses, and investigate variances versus expectations.

Work on multiple projects and deliver in tight timelines.

Strong strategic analytical skills and pay attention to detail.

Demonstrated expertise in reporting, data management, financial analysis, as well as project management.

Excellent organization skills to manage work flow and timeline and other teams supporting the reporting process.

Flexibility with reporting timelines in some hours during month ends, quarter ends.

Strong ability to gather information from/work with cross collaboration groups/stakeholders

Able to influence and lead decisions across various levels.

Build and maintain financial models to support business.

Works as a team member or runs individual projects and is responsible for completing projects within allotted timeline and budget.

Microsoft Corporation, Redmond, WA 2008 - 2013

Sr. Business Analyst

Strong Excel skills and responsible for over $70 M in payments for multiple Microsoft products including MSN and Windows.

Prepare month-end journal entries, accruals, reconciliations, scorecard, analytical reporting.

Reconcile balance sheet accounts and do oral presentations in the MBR meeting.

Managing 19 international vendors (EMEA, Asia, Latam), 24 invoice templates in 8 company codes.

Perform a variety of accounting functions and implement process improvements that increase efficiency and accuracy.

Excellent relationships with departments and understanding of processes to efficiently manage people, accounts, accomplish tasks and resolves issues on a global bases.

Support ad hoc reporting requests for various/multiple customers.

Successfully solve challenging business issues, operate under tight deadlines with frequently changing work environments.

Proactivity review and analyze monthly vendor spending reports, addressing any variances and issues.

Directed ROB process and activities management, including long term forecast, budget, MBR, QBR, MYR and R&O’s

Successful record developing and communication for high performance business operations.

Leading, through example, guidelines and being available for questions to ensure a productive work environment.

Interpersonal and communicate effectively with a variety of levels of personnel on a global basis.

Drove performance improvement through improved end-to-end process design and management

Analyze and understand the key trends that drive the business.

Responsible for processing payments, preparing and entering journal entries for monthly cash transactions.

Working closely with internal partners and vendors to verify financial data is entered correctly to manage revenue for online programs.

Created and maintaining the change management documentation project.

Training new partners, vendors and contingency staff on the processes and procedures to ensure a productive work environment.

Team player able to effectively interact with internal and business partners across the company.

Financial Analyst (Contractor) 2006-2008

Created and Maintained ad-hoc reports by building queries and utilizing pivot tables

Established Billing and A/R processes and procedures for multiple departments

Ensured accurate cash application in the SAP system

Acting liaison between Microsoft and a large VAR for “Bill on Behalf” project

Reconciled weekly bank activity

Proactively contacted customers regarding billing issues.

Organized and tracked vendor invoices, bank statements and customer communications.

Imported, validated and posted lockbox data from Bank of America.

Verified invoices prior to sending them to customers

Education:

MBA in Finance, City University, Seattle, WA

Bachelor of Arts in Business Administration, Washington State University, Pullman, WA.

Contact this candidate