Manager Sales

Mohan Jhand MST

Phone 248-***-**** Email: ***********@*****.***

EDUCATION:

Mar 2008 Walsh College

Master in Taxation

April 1993 H.P University, Shimla, India

Master of Commerce and Information Technology

April 1990 M.COM; I.C.M.A

Institute of Cost & Management Accountant of India.

April 1986 G.N.D University, Amritsar, Punjab, India

Bachelor in Accounting & Financial Management

Current Appearing for CPA exams.

COMPUTER EXPERIENCE

Tax Software: InSource, Corptax, Vertex, ProTax, Tax stream, Cross Border

Solution, Fixes Assets System.

Languages: MDX Queries, VBA, SQL, SQL*Plus, DHTML, XML, XSLT.

BPM Software: Mapics, PM 10, SAP, Outlook Soft Everest 4.2, EAP 3.0,

Hyperion 5.0, 9.0, Business Objects

Database Knowledge: SQL Server, Analysis Services, Oracle 6.0/7.x,

8.x, 9i, Sybase.

LANGUAGES

Can speak five Indian languages besides English

PROFESSIONAL EXPERIENCE:

XRite, Grand Rapids, Michigan, 06/09 – Present

• Presently working in preparing federal returns for year 2009 and support work papers including collection of

information from different foreign controllers. Designed templates to collect information from foreign controllers

to file 5471, 5472, 1118 forms with Vertex software system. Elimination of inter-company transactions,

apportioning foreign branches using headcount for apportionment, analysis of entities and their filing

requirements. Review of paperwork of foreign entities to make sure, controllers submitted correct information.

Reconciliation with trial balances to file correct foreign tax calculations like intercompany transition, realized and

unrealized foreign exchange gain/losses, amortization of goodwill and other related expenses to calculate E&P.

Other support to tax department in review of consolidated federal tax returns, calculation of enacted tax rates,

provision and research work as required. Working in FAS 109 quarterly provisions and year end report.

• Installed, configured Tax Stream software application system and converted quarterly provision reports from

manual excel spread sheet into Tax Stream software. Company is using FAS 109/FIN 48 provision reports from

Tax Stream System which includes installation, mapping, conversion of trial balances into tax stream system,

calculation of deferred tax assets and liabilities, permanent and temporary differences and several other tax stream

Page 1 of 4

load, conversion, bridge mapping support. Support in federal and state tax returns and helping to IRS auditor in

providing information.

(Solomon Edwards) Astellas Pharma US, Inc. Chicago, IL 12/08 – 05/09

International Tax Analyst

• Support to tax department in preparation & review of federal, state, excise tax returns, quarterly provisions and

apportionment reports for corporation. Calculation of Book to Tax adjustments as required in Schedule M-1’s and

preparation of year end tax packages.

• Calculation of Foreign Tax Credits, Deferred Taxes of domestic and non US entities. Responsible for calculation

of foreign insurance premium, fuel tax credit to file quarterly excise 720 tax returns, payments, and preparation

of Forms 5471, 5472, 1118, 8858, 8865 for foreign corporations.

• Working with IRS audit, writing IDR for all quarries of IRS, research work, collection of information from all

entities for tax purposes, calculation of R&D tax credit, excise tax credit and Assistance in tax saving planning

projects

• Track, gather, analyze, prepare and record the transfer pricing information for use in the Transfer Pricing Studies

prepared by our outside domestic and international consults. Arranging information to complete APA agreements,

Transfer pricing documentation compliance according to IRC 1.6662(e) and Section 482 of IRC. Providing data to

present in agreement as required for compliance and make sure agreements are as per prescribed guidelines and

compliance of IRS.

• Installation and upload data in Tax Steam software for provision. Train users to use Tax Stream software.

Magna Services of America, Troy, MI 05/08 - 10/08

Tax Analyst

Federal and Foreign Taxes:

• Review of Transfer Pricing Agreement, Advance pricing agreement with IRS, prepare several data report to

present in TP documentation. Worked with E&Y consultant to make sure compliance of International Transfer

pricing policies are applied to set inter company prices.

• Support to tax department in preparation of consolidated tax returns, quarterly provisions and apportionment

reports for corporation. Calculation of Book to Tax adjustments as required in Schedule M-1’s and preparation of

year end tax packages.

• The Global Tax Footnote prepared in accordance with FASB 109, APB 23 and FIN 48 which includes recognition

of deferred tax assets and liabilities, calculation of temporary and permanent differences, Tax credit carry forward

and determination of allowances, intra period tax allocations.

• Made standard procedures to support documentation control to bring in house tax return work papers and review

tax compliance documentation and record keeping policies and procedures.

• Quarterly tax provisions and estimates. Calculations of quarterly tax estimated payments to maximize tax savings

and minimize outwards cash flow provision and journal entries.

State :

• Calculate and prepare state income tax returns oversee and coordinate with state apportionment binders / files and

assist with State notices and responses.

• Helps to International Tax manager in preparation of Forms 5471, 1118, 8858, 8865 for foreign corporations.

• Reconciled Currency Tax credit for company's different foreign entities having destination sales and services in

USA for International Tax purposes.

• Supported all documentation for SOX purposes for city, state and municipal tax returns to support company's

position and analysis comparison with prior year sales, property, wages and rent.

• As company is trying to prepare in house federal and state tax returns and bringing in house work from outsource

agencies, generated several standard support work papers to support tax returns for audit purpose and SOX

purposes.

Misc. Tax jobs:

2

• Set up of Fixed Assets software restored backup files received from agencies for prior years to calculate

depreciation. Converted data from several different sources into FAS system to generate depreciation reports and

forms. Calculated depreciation for federal, state, AMT, ACE in one system (FAS) for all.

Trimas Corp., Bloomfield Hills, MI 08/04 – 04/08

System/Tax Analyst

Worked as Tax Analyst for Trimas Corporation supporting Tax, Finance and Treasury departments. I was responsible to

manage tax related activities.

• Support to tax department in preparation of federal, state, SALT, franchise & use and city tax returns. Help to

International Manager in Transfer Pricing documentation and APA compliance.

• Information provided to outsource agencies to prepare tax returns. Review of Federal Tax return.

• Calculation of Foreign Tax Credits, Deferred Taxes of domestic and non US entities.

• Consolidation of tax returns for the company and reconciliation of financials and tax related figures for quarterly

and yearly statements.

• Support in preparing SFAS 109/FIN 48 requirement for the corporation which include misc. reports like:

o Reconciliation of Temporary difference of deferred tax liabilities assets.

o Calculation of tax benefits operation losses carry forward or carry back and calculation of interest and

penalties - SFAS 109

o Deferred Tax expenses and inter period tax allocation and tax allocation for continue operations.

o Subsequent recognition and measurement and change in judgment - FIN 48

o Tax research on various issues like sales tax, deferred tax credit by using variety of sources.

• Preparation of actual, budgets variance analysis reports to support target results and changes in EBITA (Earning

before and earning after Taxes) on entity level and consolidated reports and results with impact of tax.

• Misc. assistance in research work, calculation of carry forward losses, GAAP application report.

• Documentation on internal control procedures as required by SOX.

• Other research project assigned by Tax director and their implementations in the systems.

• Preparation and reporting of data, foot notes, internal edhoc reports and correctness and consistent data analysis

reports and several research projects related with Taxes.

Accenture Solutions, Southfield, MI 01/02 - 07/04

Dow Alliance - Business Analyst

• Project leader in implementation of financial system with team of five members. Intermediate between

Finance/TAX and IT Team in collection of user requirements, test cases, testing of final tax report to ensure

application tax related rules and calculations are implemented correctly in the reporting system.

• Responsible for implementation of changes, update, new rules of tax and finance related issue in the system and

update documentation required for SOX purpose to ensure internal sufficient security controls have been

implemented. Production support and integration of financial systems.

• Successfully implemented financial system as per company’s requirements and tested 100% system before launch

in production to ensure all bugs were fixed and documented all test cases required for SOX purposes.

Compuware Corp., Dearborn, MI 12/00 - 01/02

Ford Motor Company (Professional Consultant)

• Responsible to support financial system in calculation of EBITDA reports, estimates, budgets and forecasts

reports for company.

• Involved in preparation of Q10. Other misc. roll in collection of customer requirements, analysis, design and

development reports and templates.

• Obtained customer requirements, performed analysis, designed and developed customer specifications, created

prototype, and obtained approval of project. Support to SAP team on modules and system level testing.

Page 3 of 4

4

Contact this candidate