Data Financial

SHIRLEY A. CASTILLO

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

Bound Brook, NJ, 08805

Phone: 732-***-****

Cell Phone: 908-***-****

E-mail: ********@*****.***

OBJECTIVE

To obtain a full time position where I can utilize and challenge my analytical skills and financial knowledge

EDUCATION

SETON HALL UNIVERSITY, STILLMAN SCHOOL OF BUSINESS South Orange, NJ

Bachelor of Science in Business Administration May 2009

Major Concentration in Finance

Seton Hall University Study Abroad Exchange Program:

AR TECHINCAL AND FINANCIAL SOLUTIONS New York, NY

Excel Expert Seminar September 2010

DOING BUSINESS IN LONDON London, England

Studied Business Policy Spring 2007

UNIVERSIDAD DE ALICANTE Alicante, Spain

Studied Spanish Topic/Hispanic Civilization Summer 2004

PROFESSIONAL EXPERIENCE

Van Eck Global New York, NY

Equity Analyst, Portfolio Administrator Assistant

Temporary February 2011–Present

• Assist mutual fund administration

• Assist with oversight price

• Assist in the review/cross footing of the financial statements and footnotes

• Review general ledger report and financial statement

• Create pivot table to identify specific securities traded

• Using macro in excel to identify and reconcile current securities cash activities transaction

• Using If, Vlookup, and sum formula for excel expense model

• Create capital stock activity in excel.

• Compare funds of daily NAV Impact

• Daily reconciliation of positions and balances.

• Reconcile custodian bank to the net asset value (NAV) statement and supporting audit schedules.

• Daily cash reconciliation for mutual funds using Portia

• Researching and resolving cash and portfolio holding differences between prime broker and the funds accounting systems from custodian banks.

• Analyze various transaction queries and report for cash reconciliation

• Prepare financial data for certain SEC filings (N-SAR)

• Prepare financial data for proxies and other ad-hoc financial and analytical reports.

• Gather, analyze, and discuss market trend and data with managers

• Reviewing and reporting of consolidated monthly Expense, Capital Activity and Cash

• Provides analytical support initiatives aimed at reducing costs and budgeted expenses

• Assist in prepare annual and semiannual shareholders reports for all mutual funds

BLOOMBERG L.P. Skillman, NJ

Data Analyst, Contractor October 2009–August 2010

• Managed, maintained, and updated data in regards to the assigned companies on Bloomberg terminal.

• Researched and reconciled issues in performance data

• Data extraction and manipulation into Bloomberg Terminal and Bloomberg website.

• New content extraction

• Debugging and data extraction new content from website to Bloomberg

Research Analyst, Contractor

• Gathered, Analyzed, and calculated London and Spanish companies’ debt obligations

• Determining appropriate corporate structure and capital structure

• Analyzed financial data on assigned industry sectors and companies

• Reconciled debt obligations posted on company’s Bloomberg capital structure profile against current company filings

• Evaluated annual and quarterly financial statements, SEC filings 10K, 10Q, and 8K reports

• Researched company’s prospectus and credit agreement to balance reports

• Daily reconciliation of positions and balances.

• Adjusted London and Spanish companies current net debt obligation

• Determined companies net obligation through financial notes, reports, and interact with specific company

• Computed London and Spanish companies’ loan dual currency bonds and loans with excel formulas

• Research variances and follow up with appropriate parties, such as CEO’s, CFO’s and directors of researched firms to communicate most current debt data

• Reconciled actual results new N-Q reports, and explain variances

• Translated financial statement in Spanish to identify and calculate net obligation

CONNINGTON WEALTH MANAGEMENT Pine Brook, NJ

Wealth Management Assistant January 2009–October 2009

• Researched and reconciled plan contributions, disbursements, and investment management fee activity

• Created updates and set up new clients/funds in investment, accounting, and record keeping systems

• Reviewed and determined client’s portfolios for proper asset allocation

• Managed an updated file of phone calls, meetings, and clients’ information

• Promoted and researched prospective clients

• Propelled stock and bonds to met forecasted numbers to achieve 20% growth

• Implemented variable growth rate model through excel.

• Created pivot table for stock using excel

• Using If, Vlookup, and sum formula for excel model

• Created customized client reports, such as portfolio appraisal

• Communicated with internal and external clients

• Interpreted financial trends

• Drafted PowerPoint presentation to prospective and prepare client-servicing materials.

• Gathered, analyzed, and discuss market trend and date with Financial Advisor

SMITH BARNEY Florham Park, NJ

Finance Intern May 2008-July 2008

• Updated credit ratings through Bloomberg

• Updated investors’ new securities

• Managed files for clients’ securities and funds in excel

• Provided financial statements to financial advisor through Bloomberg

SKILLS

• Fluent in Spanish; Proficient in Microsoft Word, Proficient Excel; (Intermediate VLookup and Pivot Table), and PowerPoint, Outlook, Access, Branchnet applications, Bloomberg, NSAR, Portia, Reuters, E-Signal, SEC (website)Firefox, and ACT

EXTRACURRICULARS & COMMUNITY SERVICE

• Vice President, Treasurer, Community Service Chair, Public Relation, Omega Phi Beta Sorority (2005- 2009)

• Vice President, Treasurer, Multicultural Greek Council(2007-2008)

• Relay for Life Spring 2007, 2008 and 2009

• Garden State Soccer League September 2009- June2010

• Profession Service Group (2010- Present)

Contact this candidate