Sales Sql Server

objective

Obtain a challenging role in business operations as a

professional finance member and give an efficient and

effective solution to the top management that would help

the organization to achieve the business and financial

goals

Professional

Experience

09/2008 - Sr. Accountant, BCN Telecom Corp. Bedminster, NJ

present Prepare US GAAP month end close in timely manner; prepare

financial statements and reports using FRx financial

report tool; consolidate financial statement

Inter-company transaction reconciliations; capital asset

maintain and analysis

Analyze and reconcile 50 states Sales Tax with the

monthly tax liability reports from the external sales tax

compliance firm; Deferred Tax analysis

Assist in year end audits, annual income tax filing,

annual sales tax filing

Involved in several business acquisition and purchase

projects (an acquisition of a local large communication

company in WI in 2008; a customer list purchase from a

company in MA in 2008; one business unit purchase from a

company in IL in 2009) with controller CFO and other

upper management to develop and analyze the financial

feasibility of acquisition/purchase, revenue forecast,

cost budget and receivable forecast etc

Assist CFO in setting up the annual budget for general

administration cost and capital asset spending,

depreciation and intangible amortization cost

Prepare scheduled and ad-hoc financial analysis and

summary reports

12/2006 - General Accountant, Kilian Manufacturing Corp.

08/2008 (Subsidiary of Altra Holding, NasdaqGM: AIMC) Syracuse,

NY

Prepare month end close, journal entries, draft financial

reports

Inter-company reconciliations for the US and Canadian

factories

Daily treasury report and cash forecast, multi-currency

involved

Audit month end physical inventory of US factory

Prepare Canadian payrolls, Canadian payroll taxes and GST

filing etc.

Prepare consolidated corporate reports for Kilian and

other subsidiaries in US, Canada and Europe to comply

with Altra quarterly and annual SEC Filing compliance

Assist year end internal and external audit, Sarbanes

Oxley compliance, and ISO9001/TS1469 internal audit

Worked with IT to develop Sales Report System on Access

Database from scratch. This Database report system has

the ability to generate different sales and price

analysis report by date, by customer, by product, by

territory and by SIC etc

Assist the controller in manufacturing overhead cost

analysis and budgets, effectively controlled the overhead

cost

Developed productivity analysis report to help the plant

manager in periodically monitoring the efficiency of

production lines

Automated payroll raw data to various practical earning

analysis reports by using Report Smith and Excel; largely

reduced the work load of the entire payroll processing

07/2006 - Financial Assistant (Financial Analyst), Vera House Inc.

11/2006 Syracuse, NY

Analyze, monitor monthly payrolls, spending and

additional program costs to make sure the government

grants and contracts are properly allocated for various

domestic violence programs through Hyperion

Assist in budgeting and planning for government contracts

02/2002 - Staff Accountant, MCAP Real Estate Finance Group

12/2005 (Subsidiary of MCAP - TSX:MKP) Edmonton, AB, Canada

Prepare Canadian GAAP month end close, journal entries,

balance sheet account reconciliations and corporate

reports

Worked close with IT department and developed the more

efficient Production Database on MS SQL Server

Maintain Production Database on MS SQL Server; Provided

various management reports, including Commercial Loan by

Broker, Commercial Loan by Region, Commercial Loan by

Loan Type and Top Brokers Report

Education

2005 BS of Business Management, University of Lethbridge,

Edmonton AB Canada

Overall GPA 3.8/4 Major GPA 3.8/4

Graduated with great distinguish

1996 BS of Finance, Suzhou University, Suzhou Jiangsu China

Overall GPA 88.39% Major GPA 89.9%

Computer

Skills

Advanced in MS Office tools namely Access (Query, form,

report); Excel (Pivotable, Vlookup, Sumif, Macro etc)

Outlook, PowerPoint and Word

Knowledge of MS Dynamic FRx, Business

Object/intelligence, MS SQL Server and Crystal report

System

Familiar with various ERP Systems, including Mapics, MS

Dynamic GP and Hyperion

Professional

Skills

Strong international company work experience

Multi-currency exchange experience, including CAD, Euro,

RMB, Korea Won and GPB, etc.

Excellent written and oral communication skill in English

and Mandarin

Efficient, detail-oriented, highly organized and strong

team player

Strong analytical, problem solving, multi-task and

interpersonal skills

Awards and

Honors

Jason Lang Scholarship winner 2005

University of Lethbridge Scholarship winner 2005

John Williams Scholarship winner 2004

Dean's Honor List 2003, 2004 & 2005

References

References

Up on request

Contact this candidate