Senior Business Analyst Capital Markets, Derivatives and Commodities and Energy Openlink Endur and Energy Trading Risk Management
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, 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
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.
Openlink Endur Clients (NDA confidential) – 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, 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
• 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.
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, 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
Energy Trading Risk Management (ETRM)
Setting up Endur Instrument types
Openlink Endur testing with Quality Test Center (Mercury Test Director)
Endur End-of-day calculations
Reconciliation of PnL between FO, MO and Back Office
Endur SQL and reports
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 upgrade to newer versions
Endur deal templates
Endur pricing & valuation
Endur volumetic exposure
Endur integration with gMotion, cMotion, Nucleus, SAP, Allegro, Triple Point, Entegrate
Business Process Modeling
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
United States Marine Corps
Navy Achievement Medal
Marine Embassy Duty – U.S. Department of State