Jigar Rana
Passaic, NJ *****
Tel: 201-***-****
E-mail: abmq4a@r.postjobfree.com
Objective:
To obtain a full-time position in the finance sector that will
help me develop and enhance my career.
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 include Balance Sheet Report, As
of Adjustment Report, Focus Report, and Weekly Management Report.
Reports are distributed to Upper Management and Regulatory on a
monthly basis.
Main Point of contact for any FINRA, Chicago Merchantile Exchange,
and internal Audit Request. 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.
Reached out to reconcilers to have all open items adjusted within
five business days.
Review of 3R's Accounts- (Reconcile, Review, and Report). Review
of Taps, Margins and Balance Sheet accounts prior to sign off to
ensure accuracy of report related accounts versus the Bank Account
Profile. Assist 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 including the ability to manage multiple
projects and adhere to deadlines.
MORGAN STANLEY
10/07 - 9/08 New York, NY
Reconciliation Analyst
Compile and analyze financial statements to prepare for
reconciliation on a daily basis. Reconcile high volume accounts
for AAA Check Settlement using MS Excel and in-house data base
system (Mainframe).
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.
Review of daily reports that include duplicate checks, cash
summary for invalid accounts, reporting zero balance transfers,
and investigate 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.
Preparing 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
Power Point and MS 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
Honors:
Dean List: Fall 2001 - Fall 2004
Deans Award Program
Edward J Bloustein Scholar
Rutgers Outstanding Scholar
Leadership & ASSOCIATION OF INDIANS AT RUTGERS UNIVERSITY
Activities:
Public Relations - Executive Board
Organize and promote various events to fundraise for numerous
charities such as MANAVI, ASHA, and IMANI.
Coordinate a semi-annual show that showcases Indian culture to a
diverse crowd of Rutgers students. Over 150 Rutgers students
participate and over a 1000 people attend.
RANA SAMAJ
Vice President - Executive Board
Organized various cultural events for the community both social
and charitable.
Managed committee members in carrying out operations and
activities.
MINORITY BUSINESS STUDENT ASSOCIATION - Member
Qualification Applications: Proficient in Microsoft Windows, Word, Power-point,
s: Access, Excel, Office, Basic, and Internet Explorer
Skills: Excellent analytical and communication skills with a
strong desire to learn.