Financial Management

Jinping Guo, MBA

*** ******** **, *** *, Salinas CA 93901 * 831-***-**** *

**********@*****.***

PROFILE

MBA & CFA with over 10+ years experience in FP&A (Financial Planning &

Analysis), Management Reporting and financial modeling

. Strong financial statement analysis (US GAAP & IFRS) skills

. Advanced modeling, analytical, problem solving and research skills

. High proficiency in Hyperion Enterprise and HFM, Essbase, TM1, Cognos,

Advanced Excel Macro

. Fluent in English and Mandarin Chinese (US Permanent Resident)

PROFESSIONAL EXPERIENCE

Senior Financial Analyst

HSBC North America, Mettawa, IL

2004 - 2010

- Provided analytical and project management support for quarterly forecast

and annual Operating Plan. Consolidated P&L and Balance sheet submissions

from Business Units/Regions to Group headquarter

- Developed critical analysis on revenue and operating expenses using

multiple information platforms and analytical tools to identify trend,

address issues and reconcile variances

- Developed and maintained financial models, managed the production of

formal reports to monitor monthly operating results and Key Performance

Indicators (KPI)

- Prepared written commentary for Executive Leadership Team highlighting

business metrics and financial results for various customer segments to

explain variances, identify drivers as well as risks & opportunities

- Assisted in business initiatives and projects. Led and participated cross

functional teams in the development of new reports, and testing of new

systems and or processes to ensure accuracy and completeness

- Documented, maintained and updated various processes in order to adhere

to internal organizational control requirements and SOX purpose

- Assisted Controller and CFO in producing quarterly and annual SEC filings

(10-K & 10-Qs) and conference call scripts for operating results and

other financial related press releases

- Prepared reports, research and analytical findings in written, numerical

and graphical form to be presented to senior management and board of

director's meetings, investor and credit ratings agencies conferences and

for other audiences

Senior Financial Analyst

All Stream Inc (formerly AT&T Canada), Toronto, Canada

2001 - 2004

- Developed comprehensive valuation and financial models, including present

and forecasted net income, return on equity, cash flow, market share,

sales, gross margin, working capital, investment, and other key measures

of financial and business performance

- Partner with BUs in the development of financial plan, annual operating

budget as well as quarterly forecast

- Developed detailed financial models and valuation scenarios for potential

transactions. Prepared reports, graphs and charts of data developed in

support of Senior Management and Investor presentations

- Reviewed and evaluated financial results in relationship to planned and

long-range objectives, analyzed trends and provides forecasts for

operating results as appropriate. Summarized critical information in

actionable for senior executives

Senior Business Analyst

Rogers Communications, Toronto, Canada

1998 - 2001

- Created comprehensive Business Plan for a number of information

technology and telecommunications projects

- Documented business requirements, coordinated the implementation of

Amdocs integrated customer care & billing system.

- Performed profitability analysis, cash projections, discounted cash flow

analysis, NPV, IRR and other key financial calculations. Made

recommendations as to project viability.

PROFESSIONAL CERTIFICATE

Charted Financial Analyst

Canadian Securities Course Certificate

EDUCATION

M.B.A. - FINANCE

McGill University, Montreal, Canada

B. A. - INTERNATIONAL RELATIONS

Peking University, P.R. China

SKILLS

Excel VBA, Hyperion, TM1, MS Project, Word, PowerPoint, People Soft,

English, Mandarin Chinese

Contact this candidate