Project Manager Sales

HIGHLIGHTS

. Goal-oriented MBA in Finance professional with Computer Science

background

. Good knowledge of financial analysis, reporting techniques and

accounting principles and practices including establishing

financial metrics and interpretation of results

. Well-versed in large financial data handling and presenting in

Excel with an attention to detail

. Strong analytical skills, good at integrating cross functional

information and knowledge

. Quick learning curve, excellent verbal and written communication

skills

. Good interpersonal skills and achievement-driven team player

EXPERIENCE

2009, Financial Analyst, Sealy Corporation, High Point, NC

. Prepared monthly analysis of financial results comparing against

plan, forecast and prior periods

. Coordinated with Finance function and Sales operations to provide

clear, concise and insightful analysis of variances, identified and

elevated significant shifts in trends

. Prepared monthly Financial and Business Overview presentation,

prepared written commentary of the month and year to date results

versus budget based on discussions and analysis

. Leaded, coordinated and executed the quarterly forecasting process

and sensitivity analysis, developed and maintain the models and

methodology by focusing on key business drivers

. Consolidated forecast results and explained variance to budget

including a range of risks and opportunities

. Provided support in execution of the annual operating planning

process

. Developed and maintained various budget templates using Microsoft

Excel and Hyperion Essbase

. Performed ad-hoc data analysis as assigned by the Director of

Financial Planning & Analysis, VP of FP&A, and CFO

. Established financial models with calculations designed to

determine whether a financial benefit could be realized from

targeted plant closures

. Developed exponential smoothing revenue forecasting models,

improved company's current forecasting accuracy by 33%

2008, Financial Analyst, AIG United Guaranty Corporation, Greensboro, NC

. Performed calculation of commissions for sales representatives and

managers to ensure compliance with approved contractual obligations

. Reconciled commissions on detailed level to ensure accurate

percentages and splits

. Coordinated and resolved commissions' issues and discrepancies,

notified and corrected inconsistent data and information for the

relevant departments

. Assisted with supervisor to respond to inquiries from all levels of

employees including sales operations, field sales force, field

finance and payroll

. Distributed reports to managers, payroll and sales operations

. Proved Negative Equity as a primary factor for default behavior

among borrowers

- Programmed SAS code adapting the data to investigate the

correlation between Housing Downturn & Mortgages

- Found out that the default group has an increasingly higher

percentage of negative equity than those of the portfolio group

. Tracked interest rate resets of Adjustable-Rate-Mortgages,

uncovered ARM Reset as another default reason for borrowers who

have ARM loans

. Captured the complete attributes of borrowers' debt burdens based

on Equifax Credit Data

. Presented periodic results to CFO and CRO, substantially improved

presentation skills

. Concluded that there has not been a paradigm shift in borrower

behavior within the company

2004-2007, Project Manager Application Development, MAGICTIMES Interactive

Ltd., Shanghai, China

. Directed the elaborations of 2 principal products: Online College

City and Official Website

- Online College City Network Application: initiated the new

product proposal, analyzed consumer market, determined

functionalities and features, budgeted project costs and revenues,

selected team members, and controlled the flow of development

- Official Website (www.magictimes.com.cn): wrote the content,

consulted with Senior Network Architect to determine the site

structure and implementation techniques, designed flash

applications, and led the website release

. Resolved issues such as inconsistency of scope, time frame, and

functionalities between client and team, maintained collaborative

relationships

SKILLS

. Proficiency in Microsoft Excel (Pivot Tables, Lookup, Data Analysis

& Charting, Statistical Tools, Macros, Simulation, Optimization)

. Microsoft PowerPoint, Access, Word, Project, and Visio

. Oracle ERP Finance modules (AP, AR, FA, Inventory, GL, etc.)

. OLAP Tool - Hyperion Essbase

. SQL, SAS

EDUCATION

Master of Business Administration, Finance Concentration

The University of North Carolina at Greensboro, Bryan School of Business

and Economics

. Member of Beta Gamma Sigma - the highest recognition of business

scholastic achievement

Bachelor of Science in Computer Science

East China University of Science and Technology, Shanghai, China

LANGUAGES

Fluent English, Chinese Mandarin

Contact this candidate