John Walter Taylor

PO Box 237202, New York, NY 10023

SUMMARY

Project Manager/Business Analyst, with more than 20 years experience in the financial services arena. Started in this business by measuring the profitability of a vast number of financial products (Commodities, Fixed Income, Equity, and a wide range of derivative products). This built a foundation which enabled me to deliver technology solutions in the Front, Middle and Back-Office, in some of Wall Streets most prestigious firms, over the past 10 years.

DISCIPLINES: Project Management, Business Analysis, Functional Architecture, Process Analysis, Process Reengineering, Re-Securitization. (Conversion of MBS pass-though pools into: REMIC/CMO) Data Mapping, Data Modeling, Merger experience Accounting (Trade & Settlement Date Daily P&L), Reference Data, Expense Management, Change Management, Trainer, Requirements Gathering, Functional Specification Design, Testing (Test Cases/ Test Scripts) (Manual Testing & Automated Testing tools), Quality Assurance (QA), Documenting Process Flow, Process Re-Engineering, Re-Valuation (Pricing / Mark to Market), Business Modeling, Data modeling, Process Mapping, Mutual Funds (12b-1 Processing) and Consolidation of Systems (Merger Related), Business Contingency/ Business Continuity Planning (BCP), Disaster Recovery (DR), GAP Analysis, Prime Brokerage, Software Development Life Cycle (SDLC) and Financial Products Management.

FINANCIAL PRODUCTS: Equity: Exchange Traded Equities and Options, in 40+ countries, American Depository Receipts (ADR), Contract for Different (CFD), International Order Book (IOB) and Global Depository Receipts (GDR), Index Futures, Options on Index Futures. Fixed Income: Treasury (Bonds, Notes, Bill), Mortgaged Backed Securities (MBS), Mortgage Revenue Bonds (MRB - Municipal Bonds), Discount Multifamily (DMBS), Real Estate Mortgage Investment Conduit (REMIC - aka Collateralized Mortgage Obligation (CMO)), Mega Pools (MEGA), Whole Loans, Swap/DWAC (Deposit/Withdrawal at Custodian), Insurance Wrap (Credit Derivative), Asset Backed Securities (ABS), MBS Futures, Options on MBS, Whole Loans, Interest Only (IO), Principal Only (PO), Interest Rate Derivatives (Caps, Collar, Floors), Municipal Bonds, Corporate Bonds, Junk Bonds, Commercial Paper, Credit Hedges, and Convertible Bonds. Commodities: Metals (Gold, Silver, Platinum, Palladium, Copper), Agricultural (Corn, Soybeans, Soybean Meal, Soybean Oil, Wheat, Coffee) and Oil (Heating Oil, Unleaded Gasoline, Natural Gas, Crude Light Oil) Commodities (Cash & Forward), Options on Commodities. Banking Products: Commercial Loans, Trade Finance (Letters of Credit) Insurance Products: Guaranteed Investment Contracts (GIC) and Synthetic GIC.

VENDOR PRODUCTS: Automated Data Processing (ADP) (BIS, Cage III, Impact, MBS Expert), Aurora (WinFITS), Kestrel: RAPTr and Karousel, SUNGARD: Global Plus, Martini, Brass (Brokerage Real Time Application Support System), Brut (Order Management) and Phase3

COMPUTER SOFTWARE (User): Excel, Excel Macros, MS Word, MS Windows, XP, MS Access, SQL, UML, DB-Visualizer, Mercury Quality Center (Test Director), ClearQuest (Rational), BusinessObjects (BOXI) Use Cases, HTML, FrontPage 2003, Netscape Navigator, Oracle, Oracle Accounts Payable, Microsoft Project 98, Microsoft Project 2003, Microsoft Sharepoint, Project Workbench, On-Time, Power Point, Lotus 1-2-3, Lotus Notes, Accounting Plus, Word Perfect, Phase3, Spreadlyze, McCormick & Dodge - CTS Millennium General Ledger, Futrack, Globeman, Tadia, Computer Associates (CA) Fixed Assets, Novell, SQL, ABC Flowcharting, and Visio.

FINANCIAL SERVICES DISCIPLINES: Front Office Trading, Broker/Dealer (Sell Side), Investment Management (Buy Side), Treasury (AFS- Available for Sale), Capital Markets, & Commercial Banking.

ACCOUNTING DISCIPLINES: FAS 91 (Amortization), FAS 140 (Re-Securitizations), FAS 115 (Mark-to-Market & Impairment), FAS 133 (Securities Accounting), FAS 65 (LOCOM - lower cost or market), FIN 46 (Security Consolidation), Financial/Accounting Re-Statement, Security Cost Basis and Tax Lot Accounting.

TECHNICAL SKILLS: Excel (Excel Macros, Vlookup, Pivot tables, Concatenate, and Data Management/Cleansing Skills), MS Access, SQL Queries.

EDUCATION - Long Island University, B.S., Business Administration, 1987

Professional Experience

Fixed Income Software Development & Consulting Firm-New York, NY (September 2007 to Present) (Consulting) Director of Operations: Responsible for: Managing day-to-day operations as well as planning for strategic growth; creation and upkeep of complex documents such as Service Level Agreements (SLA), Software Licenses & Service Agreements; supervised and mentored 10 direct reporting professionals; implementation of new corporate policies such as Change Management, Corporate Best Practices, Security Polices and Disaster Recovery Plan. Created an operational risk assessment report, to determine possible points of failure within the organization and how to mitigate that risk. Project Manager: Experienced with managing multiple complex projects (i.e., several interfaces; traditional and Citrex hosted solutions, various clients) utilizing a strong understanding of the Software Development Life Cycle process (SDLC). Conducted weekly status meetings to review project timelines, budgets, risks and artifacts; red flags and possible delays where escalated senior management. Updated Use Cases, user manuals, business requirements, project plans, as well as technical documentation. Utilized Saleforce.com, Microsoft Excel and Project for the development of projects plans, schedules, and dependencies.

SetClear - New York, NY (March 2007 to September 2007) Senior Business Analyst/Project Manager (Consulting) - Responsible for the creation of requirements (functional, business, UML system process flows, data models, screen mock-ups and prototypes) for a web-based, start-up middle/back office system, which cleared Exchange Traded Equities and Options, in 40+ countries. The financial product makeup also included American Depository Receipts (ADR), Contract for Different (CFD) and Foreign Exchange (FX), cash transactions. The individual documents produced included: Client Administration, User Administration, Validation, Aggregation/ Blocking, Allocation, and Confirmation. Other documents included Cross Border Settlements, International Order Book (IOB) and Global Depository Receipts (GDR)

JP Morgan Chase - Jersey City, NJ (September 2006 to February 2007) Project Manager (Consulting) Responsible for creating project plans in Microsoft Project 2000, for the migration of OPICS (Capital Markets Settlement System), Advantage (Private Banking System), Sierra ( Futures, Options and Credit Derivatives Vendor Application) and its internal accounting application (GLAS) to SAP. Managed the components (development, reference data, business requirements, configuration, design, test execution, implantation, PMO office and SAP Team) required to participate in a integrated system test. Reported weekly status to senior management committee.

Fannie Mae - Herndon, Virginia (November 2005 - June 2006) Project Manager/Business Analyst (Consulting) Project Title: Re-Statement; Responsible for the creation and execution of complex test cases, for a portfolio which contains various types of Mortgage Backed Securities (MBS). Used DB-Visualizer, along with SQL (Standard Query Language) queries, to verify the results of these test scenarios. Used testing tools including Mercury Quality Center (Test Director) and ClearQuest (Rational) for the management of test cases/scenarios, the management of defects and automated testing tools. These test cases, where from the Investment Accounting perspective, with sub-topics which included: FAS 91 (Amortization), FAS 140 (Re-Securitizations), FAS 115 (Mark-to-Market & Impairment), FAS 133 (Securities Accounting), FAS 65 (LOCOM - lower cost of market), FIN 46 (Security Consolidation), Security Cost Basis and Tax Lot Accounting. Used Business Objects (BOXI) for the creation of canned and ad hoc reporting requirements. Owned the responsibility for writing Business Requirements Document (BRD) for Re-Securitization Processing, Validation and Customized Reporting. Project Manager: Responsible for leading a team of professionals in the validation (relief & execution) effort of Two Major Work-Streams (Sales & Re-Securitization), of the restatement project. Created a customized methodology (document) to identify and mitigate risk, along with a validation approach procedure, which included Reports and detailed SQL Queries. Interacted with Executive Management Committees and External Public Accounting/Audit firm, in the reporting of results. Product Portfolio Included: Mortgage Revenue Bonds (MRB - Municipal Bonds), Discount Multifamily (DMBS), Real Estate Mortgage Investment Conduit (REMIC - aka Collateralized Mortgage Obligation (CMO)), Mega Pools (MEGA), Interest Only Securities (IO), Principal Only (IO) Securities, Strips, Whole Loans, Swap/DWAC (Deposit/Withdrawal at Custodian) and Insurance Wrap (Credit Derivative)

Sourced Solutions Group, Minneapolis MN & New York, NY (February 2005 to September 2005) Project Manager (Consulting) Responsible for creating project plans in Microsoft Project 2000, to consolidate two Brokers-Dealers into one from a (a) Compliance / Regulatory perspective (b) Fixed Income perspective and (c) Global Firm perspective. Was also a Mortgaged Backed Securities (MBS), Subject Matter Expert (SME), who was responsible for overseeing the conversion from Beta to MBS Expert (MBSE) and created detailed test cases/scripts for MBSE.

UBS (April 2004 - July 2004) (Consulting) Senior Business Analyst - Responsible for gathering requirements, from users (Traders & Risk Professionals) based in London, Zurich and New York, writing functional & technical specifications, for: (1) an in-house front office, trading application (GABS) whose main products are related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages; (2) Risk Management Systems, which supplies users with intra-day and end-of-day speeds, status of modeled bonds, as well as market and credit risk (delta) information. Also responsible for data mapping of feeds from several reference data systems, including Bloomberg, to a number of in-house applications

JP Morgan Chase (July 2003 - February 2004) (Consulting) Senior Business Analyst - Responsible for gathering requirements writing functional specifications, writing use cases and creating screen prototypes for several projects related to a MBS (Mortgaged Back Securities) Front Office Trading (Trade Capture & Execution) Application & Back-Office System (Allocations). These projects included conversion of internal back-office system to ICI/ADP's Impact, Position Financing (Repo, Reverses, Dollar Roll & $Roll), Real-Time Trade Matching (RTTM), creating of a user manual and the conversion of a Sell Side Allocation System to a Buy Side Treasury Allocation Application, which is governed by FASB 115 rules, AFS (Available for Sale), HTM (Held to Maturity) and MTM (Market-to-Market) Portfolio Types.

MTM Partners: (January 2002 - June 2003) (Consulting) Technology Consultant (a) Gathered requirements, created functional specifications and implemented the designed strategy for an Access database, for a large domestic plastics manufacture. Used advanced functions in Excel to create custom made solutions. (b) Created, developed and executed a QA testing plan, for a specialized web based women's clothing manufacture. (c) Developed a full business plan (Financials, Budgets, Definition of Market Place and Competition) for a Juniors women's clothing manufacturer.(d) Created a business plan for a 'Bankruptcy Liquidator' to identify existing companies who have the potential of going into bankruptcy in 90 days or less. (e) Educated consumers in the use of technology devices (MP3 Players, iPods, Palm Pilot, Digital Camera)

JP Morgan Chase (June 2001 - November 2001) (Consulting) Project Manager / Senior Business Analyst - Day 2 Project (Merger between JP Morgan & Chase Manhattan) Created a more effective reporting method, for a risk mitigation process, that allowed senior management to reduce the time spent on this function, by about 75%. Manage project deliverables and progress through regular meeting with Senior Management. Monitor deliverables, activities, risks, jeopardizes and dependencies. Verified that the individual production pre-merger month-end financial reporting information from both JP Morgan and Chase Manhattan equaled, within an allowed variance, the consolidated global test information for JP Morgan Chase's Income Statements and Balance Sheets. Created data-mapping tables that mapped financial accounts from a pre-merger organizational unit to a post-merger consolidate account number (account conversion processing). With the help of Excel, Macros, Access, PRF (Profitability Reporting Facility) and Oracle Sales Analyzer 6.3 (Oracle Financial Analyzer), I was able to create ad hoc reports and reconciliation tools, that assisted in this process. Also used the VLOOKUP & Pivot Tables function to consolidated information from several different sources.

Deutsche Bank (Buy Side) (October 2000 - April 2001) (Consulting) Senior Business Analyst / Tester - Responsible for the creation, modification, execution and tracking of test cases for an Investment Management software package called Global Plus, a SUNGARD product. Also responsible for meeting with the department heads of Stock Loan, Security Master File, Corporate Actions, Global and Domestic Re-Valuation (Pricing / Mark to Market), and Fixed Income Derivatives Desk (MBS, CMO, Swaps, Interest Rate Products, Options & Futures) to create test scenarios. Documented workflow/ process from front to back office, using Visio. Used Visio & UML to create the data model, then built the Database in Microsoft Access Database to supply the development test environment with Reference Data that included: security set up information, mark to market pricing, factors, variable rates, foreign exchange rates and other corporate action data. Assisted in the manual input of security & account information into a Global Plus test environment, so that parallel testing could be completed.

Additional Professional Experience Available Upon Request