Jigar Rana
Passaic, NJ *****
Tel: 201-***-****
E-mail: **********@*****.***
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