| Philip's profileDerivatives Trading DeskPhotosBlogLists | Help |
|
October 25 Capital Markets, Openlink Endur, Calypso, Murex, Sophis Business Analyst
PHILIP GREENCapital Markets Senior Business Analyst Project Manager Derivatives, Commodities, Credit Default Swaps, Openlink Endur, ETRM, energy trading risk management, Murex, Calypso, DTCC DerivServ, Advent Geneva, Sophis Risque, TriplePoint, Sol Arc, Allegro, Zainet, Wall Street Systems, Bloomberg POMS, Advent Geneva, Eagle, TradeFlow, Sungard, Latent Zero, Swapswire, HeliographBusiness Analysis, Requirements Gathering, SDLC, RUP, UML, documentation, eliciting business requirements, business rules, processeds and procedures and developing to business specifications, Mortgage-Backed Securities, Equity, Debt, FX, Swaps, Interest Rate Derivatives, Credit Derivatives, Equity Derivatives, Money Markets, Structured Products, Capital Markets, Fixed Income, Futures, Options. futures, forwards exotic options, specifications, ERCOT, AML, Currency, Foreign Exchange, Portia, Eagle, PACE, Charles River, Compliance, trade blotter, FAS 133, mark-to-market, hedge effectiveness, testing, UAT. - PROFESSIONAL EXPERIENCE Fortis Investments Brussels, Belgium January 2008 - current Project Lead/Senior Business Analyst Contractor/Consultant Calypso intergration, Fortis Netherlands, ABN-AMRO. OTC and Listed ETD Derivatives Project - Derivatives platform Implementation of vendor solution, short-listed to Murex and Calypso. Upstream and downstream interface documentation for all Sophis products, Sophis, Swapswires, T-Zero, Decalog and FIBIS (Structured products (primarily Equity options) Fortis Investments Brussels, Belgium January 2008 - current Project Lead/Senior Business Analyst Contractor/Consultant Calypso intergration, Fortis Netherlands, ABN-AMRO. OTC and Listed ETD Derivatives Project - Derivatives platform Implementation of vendor solution, short-listed to Murex and Calypso. Upstream and downstream interface documentation for all Sophis products, Sophis, Swapswires, T-Zero, Decalog and FIBIS (Structured products (primarily Equity options) Openlink Endur Senior Business Analyst Zurich, Switzerland (Derivatives Trading Desk) Energy trading risk management Openlink Endur Energy Trading Risk Management (ETRM) Futures Options Swaps Commodity Derivatives Carbon CO2 Emissions trading EUA-CER Financia Green's Certificates EUA-CER Physical deals Metals Structured transactions Trade capture and risk management system (Openlink Endur) as the system of record for Natural Gas financial and physical trading. The physical gas trading consisted of transport and storage deals. gMotion utilized for maintaining Natural Gas deals. Created custom "end of day" calculations in the simulation framework, and modified canned calculations in Endur for M-T-M, Cash Month, P&L granularity required by trading and risk control analysts. Created custom instrument types in Endur in the user-defined interface which allows for separation of similar deal types. This allowed for an ENGY-SWAP to be traded execution venue agnostic, OTC or through ICE. Experience with Forecasting, Scheduling, Nominations, Bookouts, Actualization, Volumetric Exposure, EaR, vaR. Understanding of the Physical Operations of Oil companies products, and inventory tracking. Very analytical and creative in solving data problems (i.e., data mappings techniques, standardizations, cross referencing approaches, etc.). Very strong interpersonal skills and ability to interact and with business users. Analyze trade processing revaluation and post cash flow to Fortis position-keeping systems for Inflation Swaps, Volume Swaps, Loans CDX, Interest Rate Swaps, Credit Default Swaps, Swaptions, Cross-Currency Swaps and gather historical market data for end-of-day positions, vaR calculations and out of the box Calypso reporting (delta buckets, Vega buckets. Connecting Calypso to all Fortis upstream and downstream systems, designing, implementing interfaces from a business analysis requirements perspective, to include ThinkFolio for swaps (CDS, IRS, CCS and Total Return Swaps, Minerva (Latent Zero) for bonds, equities and FX. Define risk management: mainly Market Risk functionality for initial phase, then Credit Risk as currently company wide credit risk done in a separate database aggregating various systems output. Define workflow for all products for daily trading in Calypso and Decalog (Portfolio Management System), ThinkFolio (OMS) and DTCC (matching). Integrate Calypso and Murex to T-Zero and SwapsWire to be used for trade pre-matching. Define specifications for Calypso/Murex slice of Fortis production database for demo and "proof of concept" at the operational view. Ensure that work with counterparty and novational fail process remains intact with integration with Calypso and Murex and that the original trade remains, that new deals, and unwinds have operational transparency. Approach: Detailed gap analysis undertaken to determine where Calypso and Murex vendor "implementation templates" failed to meet the growing needs of Fortis Investments for TRS, IRS, CDS, and CCX front, middle and back office specific. Authored detailed business requirements for Sophis equities, Sophis credit derivatives, Sophis Risque, Base Metals, Sophis for equity derivatives, commodities module of Sophis for futures and options deals and Structured Products. Write Detailed Business requirements documents (BRD) and assessment of current OTC derivatives instruction trade management processes for front, middle and back office, reference data, data attributes and security master database. Asset classes covered include exchanged-traded and OTC Interest Rate Derivatives, OPUS derivatives pricing, Equity Swaps, Interest Rate Derivatives, Interest Rate Swaps, Credit Default Swaps, Foreign Exchange Swaps, Equity options, Swaptions, Foreign Exchange Options and Equity/Index Derivatives and Structured Credit Derivatives. Authored "road-map" and assessment and integration requirements with Swapswire, DTCC, DerivServ and Bloomberg pricing data. Implementation project plans and business requirements, configuration and trade blotter for Calypso, Murex, Sophis Risque, Sophis Value for Risk utilizing SQL for Toolkit. Workflow documentation for downstream systems Decalog, Heliograph, Corona, ThinkFolio, T-Zero and Bloomberg. Developed and maintained testing scenarios and scripts. Recommend strategic initiatives and analyze OTC derivatives protocols and practices around DTCC, and Advent Geneva Global Portfolio Accounting System's RSL reports and instrument coverage including cliquets, CFD's and first to default for Fortis Bank, SWIFT, Swapswire, FpML, DerivServ, and ISDA. Shell Trading Houston, TX Senior Business Analyst Contractor /Consultant Openlink Endur v. 8.x Apr 2007 - Jan 2008 Business requirements and assessment of current Openlink Endur v.5 to implementation of Endur v.8 and integration with AcuRisk, Nucleus, Triple Point, Advanced Analytics, performance evaluation for remote locations, Cash Month Position Management, tactical tradebook, SENA, TPORT, Endur center of excellence workflow requirements, Commodities: Crude oil, Natural Gas, LNG, heating oil, Naptha, Distillates, Natural gas liquids. Includes ethane, propane, butane and condensate. Cash Month PnL Reporting, assessment of Openlink replacing DealView, meet with OLF developers for review sessions, integrate Nucleus into Endur and write extraction requirements; review dBase logic and Endur GUI. gMotion, Deal management, Deal Entry, Deal Capture and Deal modeling and transaction history, power, gas, scheduling, front office and mid-back operations experience. Daily Volume cuts and Price Changes, position monitoring, scheduling, tactical tradebook. Write short charter for financial reconciliations and build roadmap for Openlink Endur 8.x implementation, testing and extraction of Nucleus archived and real-time data. Supported a highly diverse portfolio of applications including: electric wholesale and retail trading, scheduling, risk management, settlement and accounting. Documented business and technical requirements, along with developing design specifications, test plans, and use cases for business requirements. Experience supporting Openlink's Endur application (version 8.0) Working knowledge of Openlink Endur base simulations (e.g., P&L), and the ability to create and debug user defined simulations. Ability to create and modify deal entry templates and deal skins. Ability to create and modify Endur reports using SQL, Business Objects and Crystal. Supported Endur ICE, Power Market Gateway and pMotion power scheduling interfaces. Experience supporting Endur in an electricity and power generation market environment. I have strong SQL and relational database skills, using SQL Server 2005 or Oracle 10. Great interpersonal skills and the ability to deal with all levels of business users and management. Very good Analytical skills, which have been demonstrated in a business environment. Knowledge of electricity markets and operations and ISO, PMJ, FERC. Bank of New York One Wall Street, New York City, NY Jan 2006 - Apr 2007 Project Lead/Senior Business Analyst Contractor OTC Derivatives project Business requirements and assessment of current OTC derivatives instruction trade management processes, reference data, data attributes and security master database. Asset classes covered include Interest Rate Derivatives, OPUS derivatives pricing, Equity Swaps, Interest Rate Swaps, Credit Default Swaps, Foreign Exchange Swaps, and Equity options, Swaptions, Foreign Exchange Options and Equity/Index Derivatives. Recommend strategic initiatives and analyze OTC derivatives protocols and practices around DTCC, SWIFT, Swapswire, Wall Street Systems for treasury and asset management documentation; FpML, Advent Geneva Global Portfolio Accounting System, DerivServ, and ISDA. Wachovia Bank/Evergreen Investments Charlotte, NC Jun 2005 - Jan 2006 Senior Business Analyst -- Contractor Long/Short Hedge Fund Derivatives Senior Business Analyst Wrote business requirements and interviewed portfolio managers and traders to implement a new International Small Cap Long/Short Hedge Fund. The hedge fund seeks to take long positions in undervalued and under-followed international equities. BA responsibility is to map and test data requirements for futures, options and other derivative instruments into existing trade order management system and back-office accounting. Documented pricing methodologies for the funds unitization including fixed unit allocation, fluctuating unit allocation, cost distribution and daily balance method with back-office accounting for NAV, Pnl and reporting. Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes on commodity futures, i.e., the Goldman Sachs Commodity Index (GSCI) and the Dow Jones Commodity Index (DJ-AIGCI) and non-dollar Bond transactions on SimCorp Dimension's investment management software; diagram swap accruals, payment cash flows, and settlement scenarios to show gains and losses of hedge. Documented how the following applications will be used in the hedge fund initiative: Fact Set, Derivative Solutions, Thomson PORTIA, Macgregor Fixed Income Order Management and DTCC (Depository Trust Clearing Corporation). JP Morgan Chase Columbus, OH Dec 2004 - Jun 2005 Senior Business Analyst -- Contractor Latent Zero Implementation Project Manager/Senior Business Analyst Tasked with documentation deliverables for the Latent Zero asset management front office trade order management system. Integration documentation for JP Morgan and Salerio stock trading algorithm tools for both asset and funding desk. Created test cases, test plans for Charles River compliance rules for the algorithm tools. Documenting all asset classes and instruments that portfolio managers and trade desks will be trading. Reconciliation from trade order management system to portfolio accounting system Advent Geneva. Implementing interfacing to DSTi's HiPortfolio and Check Free Trade Flow to clients, SWIFT and Accounting systems Latent Zero Capstone suite consisted of Sentinel, Minerva and Tesseract. This application was complemented by Yield Book, CMS Bond Edge and Salerio and CheckFree Trade Flow. Documented trade order lifecycle for all instruments: equities, equity options, structured products, equity derivatives, Fixed Income, treasury bonds, Auction Rate securities including corporate and municipal bond debt instruments, Variable rate Demand and Preferred, Dutch Auction Securities, OTC derivatives, energy derivatives, Structured products, Money Market instruments, FX, mortgage-backed securities, Asset-backed securities, alternatives investments, Collateralized Debt Obligations and the agencies (e.g., FNMA, GNMA, and FHLMC). BP (British Petroleum) Naperville, IL Apr 2004 - Dec 2004 Senior Business Analyst (Contractor) APR Project (Automated Positions Reporting) Requirements gathering with trade control analysts and traders to consolidate data repository for reporting BPs crude oil and products Futures & Options, hedges, swaps and Volumetric Exposure on the New York Mercantile Exchange up to regulatory bodies (NYMEX trade regulators and FERC (Federal Energy Regulatory Commission) regulators. Reconciling positions in IST Trade Control for APR (Automated Positions Reporting) for market and supply crude (WTI, Brent, others), heating oil (HO) and unleaded gasoline (UNL). Data, futures, options positions, EFP and Swap deals data from MOFT, US Crude Supply Exposure Model and US Product Supply exposure Model, Cantera, Camera (Houston), aggregate exposure Excel sheets from Calgary and Crude Excel sheets from La Palma. Business Objects, MOBO, MOFT (Middle Office Fast Track - position and pricing aggregator for Wet Deals), GlobalView external price feeds vendor for NYMEX, Platt's and OPIS.,Clearvision, Openlink Endur v5, v8, Allegro, Entegrate, Wall Street Systems (primarily responsible for specifications in Treasury for Credit Default Swaps booked outside of the APR project for hedge compliance) Triple Point (for deal valuation and calculation of OTC options); and PAWS (Petroleum Analysis Work Station used by the traders for M-T-M accounts, and SAP 4.6 (for operational and accounting system), and Zai*Net power trade capture system. Responsible for business user review sessions, requirements gathering, UAT test scripts, gap analysis, data consolidation, benchmarks, metrics and attributes for Automated Positions Reporting. Responsible for writing specifications to build data store, data assumptions, Dimensions, data fields specific to entity (hedge group), deal information fields (Market vs. Supply, Deal type: Wet, Paper, EFP, Swap); future specific and Option specific data(NYMEX open interest, IPE, OTC, option delta), and EFP specific, Swap, Market, Supply Crude (crude grade, WTI, Brent, Dubai, EOR, WOR crude categories) and product specific requirements. Fifth Third Bank Cincinnati, Ohio Dec 2002 - Apr 2004 Project Manager/Senior Business Analyst -- Capital Markets Requirements gathering and project lead on initiatives to implement Straight-through processing (STP) for the Asset and Funding Trading Desks integrating Bloomberg Gateway and Bloomberg Portfolio Order Management System for data mapping trade tickets on securities and derivatives on the asset and funding desk to SunGard Middle Office Manager and SunGard InTrader and Wall Street Systems applications. Charles River (CRD) gap analysis review sessions for order management selection. Charles River compliance module for Money Market fund and Rule 2a-7, eligible securities, ratings and alerts, warnings and exceptions documentation. Managed project from initiation to close. SME for bank-traded Fixed Income products including Mortgage-backed securities, Asset-backed Securities, Equity options, Interest-rate and Credit swaps, structured products, TBAs, new issues, CMOs, agencies (FNMA, GNMA and FHLMC), Foreign Exchange and Interest-rate Swaps. Effectively use PMO (Project Management Office) methodology to initiate, design, build, test, implement and close on capital budget expenditure projects, successfully and on time, while analyzing risk and issue impact on the project. Straight-through processing project on Asset and Funding Desks. Requirements gathering. Lead review sessions. Instruments: Equities, fixed income, mortgage-backed securities (MBS), asset-backed securities (ABS), CMOs, CDO and the agencies FNMA, GNMA and Freddie Mac. Reference data workflows, FAS 133 for Hedge effectiveness testing, securitization and structured products and Derivatives Solution. Credit derivatives, commodities, futures, options, FX. Primarily responsible for the configuration design of solutions on the Wall Street Systems Suite application solution for straight-through-processing platform for FX, Money Markets, Emerging Markets and the upstream and downstream interfaces. Engagement manager heavily interfacing with the functional design and run teams as well as with the Wall Street System vendor to provide application configuration solutions which fulfill the front - to back office trade processing and settlement. Delivered BRD and FRD specifications tailored to business requirements for Wall Street Systems business functions and processes as well as testing and performing "proof of concepts" on WSS application functionality and capability across instrument types and sectors. Delivered "road map" and future state project initiation plans for the configuration of the application platform as well as design of any new configuration to fulfill the business requirements. Detailed requirements for Wall Street Systems treasury functions and front/middle/back office standards for trade capture, pricing, valuation, risk, trade confirmation and settlement. Functional Wall Street Systems documentation for asset classes IR and IR Derivatives (including bonds, Credit derivatives, Interest Rate derivatives) and FX and Commodities. Mapped data and conceptual business requirements into business rules configurable and to be captured within the designated Wall Street Systems parameters/procedures, particularly for the front office Reuters data feeds. Sungard InTrader, Wall Street Systems, Advent Geneva, Bloomberg TOMS, Bloomberg POMS, Reuters interface to WSS for data mapping; QRM (Quantitative Risk Management), Charles River Trader, Charles River Manager, Charles River compliance. RFP author for Charles River OMS evaluation. Fuji Bank of Japan, Chicago, IL FX Trading Desk Sr Business Analyst Jan 1999 - Jan 2002 Developed applications to track risk exposure, trading positions, algorithmic models designed to capture best execution; and Monte Carlo simulations, arbitrage, and spreads and due diligence for traders on the Foreign Exchange trading desk. Utilized Excel spreadsheets and real-time trading floor applications such as Devon, Sun-Gard, DTN, Bloomberg and Reuters to manage risk exposure for the foreign currency trading room. Client/server transactional platforms utilized. Responsible for analysis of derivatives, futures & options, foreign exchange and securities risk management. Communicated with trading partners through e-mail and spreadsheet reports for trade reconciliation. Remitted S.W.I.F.T. data for trade balancing. Developed reports and Excel queries of Fixed Income securities trading and processing with emphasis on US Government securities (both outright and Repo) for bank management. Responsible for P&L reporting, confirmation with trading partners, and end-of-day reporting of positions. Performed analysis on historical trade position data, trading trends and tendencies and opposing trade positions for fraud detection and trading limit violations. Reconcile F/X, wholesale, spot, ask and bid, cash and Euro positions. Clarified the responsibilities of both dealers and brokers regarding collateral substitutions in Repo transactions and promoted best practices in the Repo markets for the bank. Chicago Mercantile Exchange Chicago, IL Apr 1994 - Jan 1999 Senior Business Analyst, Exchange-traded Derivatives, EuroDollar, S&P, IMM and Agriculture Futures and Options pits Trading Floor Project Manager Successfully led and managed included extensive report creation of out-trades, trading and security violations. Responsible for investigative reporting, trading floor access and security, creation of passwords and security profiles. Analyst responsible for client/server and transactional processing. Led team of enforcement and risk personnel. Created applications to link databases and trading floor applications through Reuters, Devon, Dow- Jones Telerate, GMI, DTCC, NSCC and GSCC for real-time trade matching, Bloomberg and SunGard for real-time views of ETD's, commodities, futures & options, precious metals, Eurodollar, Interest rate, S&P 500 Index and Commodity Index futures and options; Treasury Bonds futures, Treasury Bill futures, Grains and Agricultural commodities, foreign exchange and derivatives for trading floor enforcement and operations. BRD specs for Globes 24-hour Asian and European markets. Developed applications to track risk exposure, trading positions, arbitrage, and spreads and due diligence for traders on the Foreign Exchange trading desk. EDUCATION and CERTIFICATES B.A., Communications Studies (Incl) University of Detroit-Mercy, Detroit, MI Computer Science Certificate Program, Roosevelt University, Chicago, IL De Paul University College of Commerce -- Certificate, Financial Markets & Trading, Futures and Options Program, 1995 Series 3, (Commodities Brokers Futures Exam) National Association of Securities Dealers (NASD), 1995 Six Sigma Green Belt, 2005 Charles River Development, Charles River Investment Management System compliance certification, Burlington, MA 2005 Project Management Institute (PMI), Dayton, OH chapter, 2005 - EDUCATION AND AWARDS De Paul University, Chicago, IL, 1993 - 1995 Certificate in Financial Markets and Trading in Finance - College of Commerce, 4.0 Grade Point Average - EDUCATION De Paul University, Chicago, IL, 1993 - 1995 Certificate in Financial Markets and Trading in Finance - College of Commerce, 4.0 Grade Point Average - Energy Trading Risk Management Business Analysis Senior Business Analyst Capital Markets, Derivatives and Commodities and Energy Openlink Endur and Energy Trading Risk Management Project Manager Derivatives, Commodities, Credit Default Swaps, Openlink Endur, Murex, Calypso, Advent Geneva, Sophis Risque, Triple Point, Sungard, Latent Zero, Swapswire, Heliograph, Sophis value, Capital Markets, Fixed Income, Futures, Options. Business Analysis, Requirements Gathering, Money Markets, Mortgage-Backed Securities, Equity, Debt, FX, Swaps, Interest Rate Derivatives, Securities Master, Data and Pricing product control, Credit Derivatives, Wall Street Systems, Sungard, Triple Point, Allegro, Energy Trading Risk Management, documentation, FERC, SAP, specifications, ERCOT, AML, Currency, Foreign Exchange, Portia, Eagle, PACE, Charles River, Compliance, trade blotter, FAS 133, mark-to-market, hedge effectiveness, testing, UAT. Deliverables, methodology, functional requirements, business processes, business analyst, lifecycle, repository, user acceptance testing, project planning, project scope, project team, reengineering, business needs, project life cycle, requirements gathering, workplans, business process reengineering, best practices - Openlink Endur, Commodities, Energy Derivatives Senior Business Analyst and Project Manager - Derivatives, Securities, Fixed Income, Hedge Funds, Risk management, Capital Markets, Energy trading, FX, Futures, Options, Commodities, Debt, Equity and Structured Products Portfolio and Investment Management trading and order management systems, OpenLink Endur, gMotion, Allegro, Zai*Net, Triple Point, energy trading risk management systems Senior Business Analyst. Sophis, Murex, Calypso, Charles River, Wall Street Systems, Trema, SAP accounting, SunGard, Latent Zero and Advent Geneva. Commodities, Futures, options, CDO, CDS, CMO, CCS, MBS, Base Metals, Precious Metals, Interest Rate Swaps, Credit Derivatives, Credit Default Swaps, vaR, Swaps, Bonds, Equity Swaps, Capital Markets, Fixed Income, Structured Products, FX and Treasury. Derivatives Trading Desk (Openlink Endur Senior Business Analyst) - Zurich, Switzerland and London, UK January 2008 -- current d/b/a Derivatives Trading Desk, LLC Project Lead/Senior Business Analyst Contractor/Consultant -- ETRM and Openlink Endur Senior Business Analyst Carbon Credits, Emissions, CO2, EUA-CER green certificates, precious metals (silver, gold, palladium, platinum), gas physical deals, gas Swaps, long-term power deals, day-ahead gas deals in Openlink Endur trading manager module and settlements desktop for invoicing and settlement of energy transactions; working with Commodities ops team for booking forwards, futures, swaps, power term forwards, energy options, calendar strips, cascading futures in Openlink Endur. Requirements specifications of all aspects from market data, account master and product and pricing configuration, online reconciliation reports, EOD processing scripts, trade modeling, deal modeling, risk process, settlement's desktop, accounting manager, and trader desktop. Using Endur Instrument types COMM-SWAPS, COMM-PHYS, COMM-EXCH. Business Analyst Responsible for Openlink Endur functional specifications for: • New functionality analysis for Reconciliations, Reference, Ops Manager in Endur v8 • Trader desktop implementation for Endur deal templates in Trade Blotter • Endur settlements Desktop for invoicing and generating cash and physical payments. Prcing indexes and volatility, risk, forward curves and simulations. • Endur Accounting Manager module analysis for Nostro accounts • New functionality analysis for gMotion and pMotion enhancements to Endur • Metals migration and new Instruments (Carbon Credits, emissions, “green” certificates for CO2) • Openlink Endur accounting, PnL, deviations, accruals, realized and unrealized gains, standard costs, fees, VAT, nostro and vostro accounting • Power and Gas confirmations downstream to SAP from Endur • Endur autosys for EOD Metals booked automatically • Swaps, plain vanilla, Strips, Spread options, Swaptions, extendible swaps, Swing options for volumes on options, Barrier knock-in and knock-out options, interruptible power embedded swing options, and basis swing options cross-region. Fortis Investments Brussels, Belgium January 2008 - current Project Lead/Senior Business Analyst Contractor/Consultant OTC Derivatives Project - Derivatives platform Implementation of vendor solution, short-listed to Murex and Calypso Write Detailed Business requirements documents (BRD) and assessment of current OTC derivatives instruction trade management processes for front, middle and back office, reference data, data attributes and security master database. Asset classes covered include Interest Rate Derivatives, OPUS derivatives pricing, Equity Swaps, Interest Rate Swaps, Credit Default Swaps, Foreign Exchange Swaps, Equity options, Swaptions, Foreign Exchange Options and Equity/Index Derivatives and Structured Credit Derivatives. Authored "road-map" and assessment and integration requirements with Swapswire, DTCC, DerivServ and Bloomberg pricing data. Implementation project plans and business requirements, configuration and trade blotter for Calypso, Murex, Sophis Risque, Sophis Value. Workflow documentation for downstream systems Decalog, Heliograph, Corona, ThinkFolio, T-Zero and Bloomberg. Developed and maintained testing scenarios and scripts. Recommend strategic initiatives and analyze OTC derivatives protocols and practices around DTCC, and Advent Geneva Global Portfolio Accounting System's RSL reports and instrument coverage including cliquets, CFD's and first to default for Fortis Bank, SWIFT, Swapswire, FpML, DerivServ, and ISDA. Shell Trading Houston, TX Senior Business Analyst Contractor /Consultant Openlink Endur v. 8.x Apr 2007 - Jan 2008 Business requirements and assessment of current Openlink Endur v.5 to implementation of Endur v.8 and integration with AcuRisk, Nucleus, Triple Point, Advanced Analytics, performance evaluation for remote locations, Cash Month Position Management, tactical tradebook, SENA, TPORT, Endur center of excellence workflow requirements, Commodities: Crude oil, Natural Gas, LNG, heating oil, Naptha, Distillates, Natural gas liquids. Includes ethane, propane, butane and condensate. Cash Month PnL Reporting, assessment of Openlink replacing DealView, meet with OLF developers for review sessions, integrate Nucleus into Endur and write extraction requirements; review dBase logic and Endur GUI. gMotion, Deal management, Deal Entry, Deal Capture and Deal modeling and transaction history, power, gas, scheduling, front office and mid-back operations experience. Daily Volume cuts and Price Changes, position monitoring, scheduling, tactical tradebook. Write short charter for financial reconciliations and build roadmap for Openlink Endur 8.x implementation, testing and extraction of Nucleus archived and real-time data. Supported a highly diverse portfolio of applications including: electric wholesale and retail trading, scheduling, risk management, settlement and accounting. Documented business and technical requirements, along with developing design specifications, test plans, and use cases for business requirements. Experience supporting Openlink's Endur application (version 8.0) Working knowledge of Openlink Endur base simulations (e.g., P&L), and the ability to create and debug user defined simulations. Ability to create and modify deal entry templates and deal skins. Ability to create and modify Endur reports using SQL, Business Objects and Crystal. Supported Endur ICE, Power Market Gateway and pMotion power scheduling interfaces. Experience supporting Endur in an electricity and power generation market environment. Strong SQL and relational database skills, using SQL Server 2005 or Oracle 10. Great interpersonal skills and the ability to deal with all levels of business users and management. Very good Analytical skills, which have been demonstrated in a business environment. Extensive knowledge of electricity markets and operations and ISO, PMJ, FERC. Bank of New York One Wall Street, New York City, NY Jan 2006 - Apr 2007 Project Lead/Senior Business Analyst Contractor OTC Derivatives project Business requirements and assessment of current OTC derivatives instruction trade management processes, reference data, data attributes and security master database. Asset classes covered include Interest Rate Derivatives, OPUS derivatives pricing, Equity Swaps, Interest Rate Swaps, Credit Default Swaps, Foreign Exchange Swaps, and Equity options, Swaptions, Foreign Exchange Options and Equity/Index Derivatives. Recommend strategic initiatives and analyze OTC derivatives protocols and practices around DTCC, SWIFT, Swapswire, FpML, Advent Geneva Global Portfolio Accounting System, DerivServ, and ISDA. Wachovia Bank/Evergreen Investments Charlotte, NC Jun 2005 - Jan 2006 Senior Business Analyst -- Contractor Long/Short Hedge Fund Derivatives Senior Business Analyst Wrote business requirements and interviewed portfolio managers and traders to implement a new International Small Cap Long/Short Hedge Fund. The hedge fund seeks to take long positions in undervalued and under-followed international equities. BA responsibility is to map and test data requirements for futures, options and other derivative instruments into existing trade order management system and back-office accounting. Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes on commodity futures, i.e., the Goldman Sachs Commodity Index (GSCI) and the Dow Jones Commodity Index (DJ-AIGCI); diagram swap accruals, payment cash flows, and settlement scenarios to show gains and losses of hedge. Documented how the following applications will be used in the hedge fund initiative: Fact Set, Derivative Solutions, Thomson PORTIA, Macgregor Fixed Income Order Management and DTCC (Depository Trust Clearing Corporation). JPMorgan Chase Columbus, OH Dec 2004 - Jun 2005 Senior Business Analyst -- Contractor Latent Zero Implementation Project Manager/Senior Business Analyst Tasked with documentation deliverables for the Latent Zero asset management front office trade order management system. Integration documentation for JP Morgan and Salerio stock trading algorithm tools for both asset and funding desk. Created test cases, test plans for Charles River compliance rules for the algorithm tools. Documenting all asset classes and instruments that portfolio managers and trade desks will be trading. Reconciliation from trade order management system to portfolio accounting system Advent Geneva. Implementing interfacing Check Free Trade Flow to clients, SWIFT and Accounting systems Latent Zero Capstone suite consisted of Sentinel, Minerva and Tesseract. This application was complemented by Yield Book, CMS Bond Edge and Salerio and CheckFree Trade Flow. Documented trade order lifecycle for all instruments: equities, equity options, structured products, equity derivatives, Fixed Income, treasury bonds, Auction Rate securities including corporate and municipal bond debt instruments, Variable rate Demand and Preferred, Dutch Auction Securities, OTC derivatives, energy derivatives, Structured products, Money Market instruments, FX, mortgage-backed securities, Asset-backed securities, alternatives investments, Collateralized Debt Obligations and the agencies (e.g., FNMA, GNMA, and FHLMC). BP (British Petroleum) Naperville, IL Apr 2004 - Dec 2004 Senior Business Analyst (Contractor) APR Project (Automated Positions Reporting) Requirements gathering with trade control analysts and traders to consolidate data repository for reporting BPs crude oil and products Futures & Options, hedges, swaps and Volumetric Exposure on the New York Mercantile Exchange up to regulatory bodies (NYMEX trade regulators and FERC (Federal Energy Regulatory Commission) regulators. Reconciling positions in IST Trade Control for APR (Automated Positions Reporting) for market and supply crude (WTI, Brent, others), heating oil (HO) and unleaded gasoline (UNL). Data, futures, options positions, EFP and Swap deals data from MOFT, US Crude Supply Exposure Model and US Product Supply exposure Model, Cantera, Camera (Houston), aggregate exposure Excel sheets from Calgary and Crude Excel sheets from La Palma. Business Objects, MOBO, MOFT (Middle Office Fast Track - position and pricing aggregator for Wet Deals), GlobalView external price feeds vendor for NYMEX, Platt's and OPIS.,Clearvision, Openlink Endur v5, v8, Allegro, Entegrate, Triple Point (for deal valuation and calculation of OTC options); and PAWS (Petroleum Analysis Work Station used by the traders for M-T-M accounts, and SAP 4.6 (for operational and accounting system), and Zai*Net power trade capture system. Responsible for business user review sessions, requirements gathering, UAT test scripts, gap analysis, data consolidation, benchmarks, metrics and attributes for Automated Positions Reporting. Responsible for writing specifications to build data store, data assumptions, Dimensions, data fields specific to entity (hedge group), deal information fields (Market vs. Supply, Deal type: Wet, Paper, EFP, Swap); future specific and Option specific data(NYMEX open interest, IPE, OTC, option delta), and EFP specific, Swap, Market, Supply Crude (crude grade, WTI, Brent, Dubai, EOR, WOR crude categories) and product specific requirements. Fifth Third Bank Cincinnati, Ohio Dec 2002 - Apr 2004 Project Manager/Senior Business Analyst -- Capital Markets Requirements gathering and project lead on initiatives to implement Straight-through processing (STP) for the Asset and Funding Trading Desks integrating Bloomberg Gateway and Bloomberg Portfolio Order Management System for trade tickets on securities and derivatives on the asset and funding desk to SunGard Middle Office Manager and SunGard InTrader applications. Charles River (CRD) gap analysis review sessions for order management selection. Charles River compliance module for Money Market fund and Rule 2a-7, eligible securities, ratings and alerts, warnings and exceptions documentation. Managed project from initiation to close. SME for bank-traded Fixed Income products including Mortgage-backed securities, Asset-backed Securities, Equity options, Interest-rate and Credit swaps, structured products, TBAs, new issues, CMOs, agencies (FNMA, GNMA and FHLMC), Foreign Exchange and Interest-rate Swaps. Effectively use PMO (Project Management Office) methodology to initiate, design, build, test, implement and close on capital budget expenditure projects, successfully and on time, while analyzing risk and issue impact on the project. Straight-through processing project on Asset and Funding Desks. Requirements gathering. Lead review sessions. Instruments: Equities, fixed income, mortgage-backed securities (MBS), asset-backed securities (ABS), CMOs, CDO and the agencies FNMA, GNMA and Freddie Mac. Reference data workflows, FAS 133 for Hedge effectiveness testing, securitization and structured products and Derivatives Solution. Cedit derivatives, commodities, futures, options, FX. Sungard InTrader, Wall Street Systems, Bloomberg TOMS, Bloomberg POMS, Reuters, QRM (Quantitative Risk Management), Charles River Trader, Charles River Manager, Charles River compliance. RFP author for Charles River OMS evaluation. Fuji Bank of Japan, Chicago, IL FX Trading Desk Sr Business Analyst Jan 1999 - Jan 2002 Developed applications to track risk exposure, trading positions, algorithmic models designed to capture best execution; and Monte Carlo simulations, arbitrage, and spreads and due diligence for traders on the Foreign Exchange trading desk. Utilized Excel spreadsheets and real-time trading floor applications such as Devon, Sun-Gard, DTN, Bloomberg and Reuters to manage risk exposure for the foreign currency trading room. Client/server transactional platforms utilized. Responsible for analysis of derivatives, futures & options, foreign exchange and securities risk management. Communicated with trading partners through e-mail and spreadsheet reports for trade reconciliation. Remitted S.W.I.F.T. data for trade balancing. Developed reports and Excel queries of Fixed Income securities trading and processing with emphasis on US Government securities (both outright and Repo) for bank management. Responsible for P&L reporting, confirmation with trading partners, and end-of-day reporting of positions. Performed analysis on historical trade position data, trading trends and tendencies and opposing trade positions for fraud detection and trading limit violations. Reconcile F/X, wholesale, spot, ask and bid, cash and Euro positions. Clarified the responsibilities of both dealers and brokers regarding collateral substitutions in Repo transactions and promoted best practices in the Repo markets for the bank. Chicago Mercantile Exchange Chicago, IL Apr 1994 - Jan 1999 Senior Business Analyst, EuroDollar, S&P, IMM and Agriculture Futures and Options pits Trading Floor Project Manager Successfully led and managed included extensive report creation of out-trades, trading and security violations. Responsible for investigative reporting, trading floor access and security, creation of passwords and security profiles. Analyst responsible for client/server and transactional processing. Led team of enforcement and risk personnel. Created applications to link databases and trading floor applications through Reuters, Devon, Dow- Jones Telerate, Bloomberg and Sun-Gard for real-time views of commodities, futures & options, precious metals, Eurodollar, Interest rate, S&P 500 Index and Commodity Index futures and options; Treasury Bonds futures, Treasury Bill futures, Grains and Agricultural commodities, foreign exchange and derivatives for trading floor enforcement and operations. Developed applications to track risk exposure, trading positions, arbitrage, and spreads and due diligence for traders on the Foreign Exchange trading desk. EDUCATION and CERTIFICATES B.A., Communications Studies (Incl) University of Detroit-Mercy, Detroit, MI Computer Science Certificate Program, Roosevelt University, Chicago, IL De Paul University College of Commerce -- Certificate, Financial Markets & Trading, Futures and Options Program, 1995 Series 3, (Commodities Brokers Futures Exam) National Association of Securities Dealers (NASD), 1995 Six Sigma Green Belt, 2005 Charles River Development, Charles River Investment Management System compliance certification, Burlington, MA 2005 Project Management Institute (PMI), Dayton, OH chapter, 2005 - EDUCATION AND AWARDS De Paul University, Chicago, IL, 1993 - 1995 Certificate in Financial Markets and Trading in Finance - College of Commerce, 4.0 Grade Point Average - BUSINESS ANALYSIS SUMMARY Energy trading risk management Endur Energy Trading Risk Management (ETRM) Futures Options Swaps Commodity Derivatives Carbon CO2 Emissions trading EUA-CER Financia Green's Certificates EUA-CER Physical deals Metals Trading module Accounting module Settlements Risk module Operations manager Setting up Endur Instrument types COMM-PHYS COMM-SWAP COMM-EXCH COMM-FEE PWR-FEE CASH FX PWR-PHYS PWR-SWAP-FTR PSWR-TR-SPREAD ENGY-B-SWAP ENGY-SWAP PWR-SWAP COMM-TRANS PWR-CAP EO-CALL/PUT PO-CALL/PUT-FIN-S PO-GEN-CALL-D ENGY-EXCH-FUT ENGY-EXCH-OPT COMM-STOR COMM-EXCH Gas Storage Exchanges Openlink Endur testing with Quality Test Center (Mercury Test Director) Endur End-of-day calculations MTM Reconciliation of PnL between FO, MO and Back Office Endur SQL and reports Emissions Power Gas Endur FX issues Endur accounting issues Endur accounting treatment of fees and costs Endur deals and trading books Endur cross commodity and cross-border trading Endur implementation Endur upgrade to newer versions Endur deal templates Endur pricing & valuation Endur volumetic exposure Endur simulations Endur integration with gMotion, cMotion, Nucleus, SAP, Allegro, Triple Point, Entegrate Structured transactions Business Analysis Requirements gatherings Business Process Modeling Requirements Specifications Trade order management system work flow Full trade lifecycle knowledge, particularly client-facing with Front Office, Middle Office and Operations, and Back Office accounting. Strong record of project delivery. Extensive experience of writing detailed business requirements. Ability to bridge the gap between the business teams and IT, Development teams. Excellent problem solving, communication and writing skills. Experience of managing and coordinating multi-work streams, multi-team projects. Trade capture and risk management system (Openlink Endur) as the system of record for Natural Gas financial and physical trading. The physical gas trading consisted of transport and storage deals. gMotion utilized for maintaining Natural Gas deals. Created custom "end of day" calculations inthe simulation framework, and modified canned calculations in Endur for M-T-M, Cash Month, P&L granularity required by trading and risk control analysts. Created custom instrument types in Endur in the user-defined interface which allows for separation of similar deal types. This allowed for an ENGY-SWAP to be traded execution venue agnostic, OTC or through ICE. Experience with Forecasting, Scheduling, Nominations, Bookouts, Actualization, Volumetric Exposure, EaR, VaR. Extensive data mapping and configuration for exchanges and exchange platofrms ICE, LCH, NYMEX, CME, EEX, ENDEX, NORDPOOL, NYMEX Clearport OTC, SGX ASIA CLEAR, ECX, Trayport, WEBICE for crude oil, petroleum products, carbon emissions, FFA freight, UK electricity, coal, tolling agreements, gas storage, forward spot (day-ahead and hour ahead) capacity and ancillary services. Brent and West Texas Intermediate Crude, natural gas, Heating Oil, gasoline propane, Nordic power, ERCOT, ISO's and PJM. Understanding of the Physical Operations of Oil companies products, and inventory tracking. Very analytical and creative in solving data problems (i.e., data mappings techniques, standardizations, cross referencing approaches, etc.). Very strong interpersonal skills and ability to interact and with business users. International experience and Emerging markets Sao Paulo, Brazil Brussels London Zurich Amsterdam Frankfurt United States Marine Corps Navy Achievement Medal Case Study -- Shell Trading, Openlink Endur v5 to v8 Upgrade and Conversion Project Issue: Current implementation of Endur no longer supporting business volume and complexity. Growing support costs to handle systems outages and user change requests. Excessive timescale and cost for suggested remediation programme. Approach: Detailed gap analysis undertaken to determine where Shell's current Endur and Nucleus5.3 failed to meet the growing needs of Shell for trading Crude Oil, Middle Distillates, LPG, Gas and Power and Equity Crude on both "spot" and "term" bases (Endur was three versions behind current version). Recommended upgrade to allow Shell to take advantage of newer technologies & functionality available in Endur 8.x. Recommended Shell migrate Endur database platform from Sybase 12.5 to Oracle 10g (the Shell standard database platform). Developed project "roadmap" for most efficient method to upgrade and convert the Endur database & application., including a curve restructure requested by Risk Control requested curve restructure, and leveraging the new functionality of v8.x, with the least amount of project risks. Result: Reduced 2-year upgrade and support budget from 6.4 million dollars to under 4.6 million, and provided a roadmap for quicker delivery of the expected benefits to the business. Case Study -- BP, APR Project (Automated Positions Reporting) Issue: Business lacked transparency over consolidated postions, entailing significant manual effort and restricting ability to apply adequate analyses and risk controls. Approach: Business analysis undertaken with BP trade control analysts and traders to consolidate data repository for real-time and ad-hoc reporting of BPs crude oil and products Futures & Options, hedges, swaps positions and Volumetric Exposure on the New York Mercantile Exchange up to regulatory bodies (NYMEX trade regulators and FERC (Federal Energy Regulatory Commission) regulators. Reconciling positions in BP IST Trade Control for APR (Automated Positions Reporting) for market and supply crude (WTI, Brent, others), heating oil (HO) and unleaded gasoline (UNL). Data, futures, options positions, EFP and aggregated Swap deals data from BP internal positions-keeping system MOFT. Built interfaces to consolidate view of BP's US Crude Supply Exposure Model and US Product Supply exposure Model, Cantera, Camera (Houston), aggregate exposure Excel sheets from Calgary and Crude Excel sheets from La Palma. Business Objects, MOBO, MOFT (Middle Office Fast Track - position and pricing aggregator for Wet Deals). Result: Automated Positions Reporting portal greatly reduced 'time to reporting" and gave BP traders better transparency and visibility into positions and market factors, supply and volumetric exposure, thereby mitigating risk and maximizing revenue potential for BP trading desks globally. - EDUCATION and CERTIFICATES B.A., Communications Studies (Incl) University of Detroit-Mercy, Detroit, MI Computer Science Certificate Program, Roosevelt University, Chicago, IL De Paul University College of Commerce -- Certificate, Financial Markets & Trading, Futures and Options Program, 1995 Series 3, (Commodities Brokers Futures Exam) National Association of Securities Dealers (NASD), 1995 Six Sigma Green Belt, 2005 Charles River Development, Charles River Investment Management System compliance certification, Burlington, MA 2005 Project Management Institute (PMI), Dayton, OH chapter, 2005 - EDUCATION AND AWARDS De Paul University, Chicago, IL, 1993 - 1995 Certificate in Financial Markets and Trading in Finance - College of Commerce, 4.0 Grade Point Average
TrackbacksThe trackback URL for this entry is: http://acheive.spaces.live.com/blog/cns!62C34948137DE9C1!989.trak Weblogs that reference this entry
|
|||||||||||||
|
|