ORLANDO C. VAZQUEZ email: *******.*.*******@*****.*** phone:732-***-****
PROFESSIONAL EXPERIENCE
Business Project Manager, AVP
Credit Suisse America, Private Banking & Wealth Management, New York, NY April 2013 to Present
Meet with Chairman’s and President’s Club Relationship Managers to gather requirements for customized Performance Reports, discerning user needs, collecting, clarifying, and translating business requirements to deliver Security level, Sector Level and Asset Class Performance Reports for Fixed Income, Alternatives, Equity, Cash Equivalents (all currencies).
Developed Excel ODBC links automating Custom Reporting Process – achieving +100% efficiency gains in scale.
Traveled to Mumbai, India to train team in Client Reporting and Consolidated Client Reporting operations.
Analyze and respond to questions regarding kinds of Rates of Return, Gain/Losses, Indices, Valuations, and calculations.
Gather functional requirements and remediate database inconsistencies using Oracle SQL queries.
Performance Analyst
Hamilton & Company, Princeton, NJ May 2007 to October 2012
Analyzed process and designed MS Excel workbooks for ETL (extracting, transforming, loading) benchmark rates of return for comparison with security and account level investment performance returns, graphing asset attribution (attribution analysis) and analyzing portfolio data from multiple data sources.
Designed Benchmark Index reporting tools for annualized, cumulative point-to-point rates of return.
Tracked and analyzed all Private Equity data including Capital Account Summaries, Capital Calls, Carried Interest and Income Distribution and Fee documentation for accuracy.
Charted Risk/Return for Fixed Income (all types), equity and cash via Mean Absolute Deviation.
Utilized Bloomberg links and downloads to load, run, extract and compare data optimizing reporting accuracy.
Run various Advent Axys Reports in following categories:
Bank of New York Mellon, New York, NY November 2000 to December 2006
Performance Analyst / Senior Custody Accountant / Funds Transfer CSR
Analyzed and liaised User to Technical Requirements designing Alternative Investments tracking facility for tracking over $1 trillion in Committed Alternative investments funds for ultra-high net worth clients, corporations, etc.
Maintained Access database +$48 billion portfolio activity including currency discrepancies, price ratio and identifier conversion and other corporate actions discrepancies.
Analyzed Capital Account Summaries, Capital Calls, Carried Interest and Fee documentation for accuracy.
Designed special Bloomberg/Excel tool for stress-testing and flagging Fixed Income Compliance violations related to interest rate sensitivity rules and non-compliant mortgage backed securities.
Tested bond pricing sources for improved accuracy of market value reporting.
Operations Specialist / Senior Pricing Analyst
JPMorgan Chase, New York, NY May 1993 to November 2000
Created security pricing inquiry tool for client’s dispute of sensitive security valuation issues.
Analyze sensitive mortgage backed securities for pre-payment speeds, ratings and alternative pricing.
Assisted implementation of new SunGard Custody Accounting system, checked for outliers, related functional requirements.
Created interactive desktop system for streamlining the acceptance and processing of security price challenges.
Analyzed and corrected interbank short term trade breaks, Funds Transfers, DDA, FedWire, Swift, CHIPS transfers.
Synchronized and tested vendor data files with existing system and suggested solutions.
VARIOUS PROJECTS:
Oversaw Mumbai team’s training in the creation, analysis and delivery of Custom Investment Performance Reports. (CS)
Designed Excel based Benchmark Index reporting tools for annualized and cumulative rates of return. (multiple)
Designed security Price Inquiry Tool for automated dispute of sensitive security prices. (JPMChase)
Authored Bank’s documentation of global securities pricing procedures. (JPMChase)
Built Excel based Bloomberg workbook tool for stress-testing Bonds regarding Compliance violations. (BNYMellon)
Project team member for multiple data consistency projects related to mergers and system upgrades. (BNYMellon)
EDUCATION A.A.S Business, 9/2009; Columbia Southern University