Jigar Rana

** ***** ******

Passaic, NJ *****

Tel: 201-***-****

E-mail: h305nf@r.postjobfree.com

Skills:

Microsoft Windows, MS Basic, MS Office (Word, PowerPoint, Access, Excel)

Experience:

MORGAN STANLEY 9/08 – 5/10 New York, NY

Control Analyst Reconciliation Group

• Responsible for completing all Management Reporting for Cash Reconciliation Accounts; reports included: Balance Sheet Report, As of Adjustment Report, Focus Report, and Weekly Management Report; reports were distributed to Upper Management and Regulatory on a monthly basis.

• Served as primary point of contact for any FINRA, Chicago Mercantile Exchange, and Internal Audit requests.

• Ensured all documents had correct balances and dates before providing Auditors with their request.

• Prepared open items report for Upper Management on a daily basis.

• Liaised with reconcilers to have all open items adjusted within five business days.

• Reviewed 3R’s Accounts (Reconcile, Review, and Report).

• Reviewed Taps, Margins and Balance Sheet accounts prior to sign off to ensure accuracy of report related accounts versus the Bank Account Profile.

• Assisted reconcilers with any 3R’s related issues.

• Maintained and updated Bank Account Profile, which includes over 900 Accounts. Added new accounts and deleted closed accounts in the Mainframe system.

• Worked closely with Information Technology group to ensure all accounts are in balance on a daily basis.

• Updated and maintained SOX website for any new request for the Cash Reconciliation Group.

• Worked directly with manager on preparing new projects and ensuring the IT group completes them with accuracy.

• Tested and signed off on all new projects once completed.

• Project management skills included the ability to manage multiple projects and adhere to deadlines.

MORGAN STANLEY 10/07 – 9/08 New York, NY

Reconciliation Analyst

• Timely and accurate completion of the monthly closing process including bank reconciliations, preparation of adjusting journal entries, analysis of account balances, and reconciliation of high volume accounts.

• Compiled and analyzed financial statements to prepare for reconciliation on a daily basis

• Review and verify the accuracy of journal entries for the reconciliation process.

• Reconciled high volume accounts for Cash Control team using MS Excel and in-house data base system (Mainframe).

• Reviewed daily reports that include duplicate checks, cash summary for invalid accounts, reported zero balance transfers, and investigated open items detail report for all accounts, etc.

ADMINISTRATION FOR CHILDREN’S SERVICE 2/06 – 9/07 New York, NY

Audit/Budget

• Reported directly to the Assistant Director of Budget. Served as liaison between ACS Financial Services and contract agencies.

• Work with ACS Program staff and Contract Agency Staff. Accurately maintained internal agency budget documents that reflect the allocation of resources by program area and reporting structure.

• Prepared claims for qualifying agency expenditures for State and Federal reimbursements on a monthly and quarterly basis; expenditures included both administrative and programmatic payments.

CLEAR WATER CAPITAL PARTNERS 9/05 – 11/05 New York, NY

Performance Analyst

• Assisted in preparation of annual meeting presentation utilizing PowerPoint and Excel (V-lookup and pivot tables).

• Monitored the performance of various funds by analyzing their current values including underlying asset market value, and exchange rates in financial models.

• Developed cash flow statements for pools of assets that included loans, bonds, and equities

NYLIFE 1/05 – 7/05 Parsippany, NJ

Jr. Accountant, Accounting/Finance

• Assisted VP of Finance in creating models utilizing MS excel, highlighting profits, loss and NAV for the mainstay mutual fund family.

• Assisted in preparation of monthly liability reports, highlighting commission fees for each individual dealer.

• Prepared daily, weekly and monthly reports focused on market activity of each individual mutual fund.

• Performed treasury reconciliations on existing mutual fund accounts on a weekly basis.

Education: RUTGERS UNIVERSITY

Bachelor in Economics: Special Options in Finance GPA: 3.5/4.0 Graduation: May 2004

Contact this candidate