Billie Khan

EXPERIENCE Sep 2013 to Current Consultant Paradigm Consulting Services, Toronto, ON:  Lobbied the funding for Monetary support with the IMF for the principal client to bridge the current account deficit  Lobbied the World Bank for the approval of the infrastructure projects for the developing countries, and on the same time resolve the corruption. Infrastructure investment should not be halted if there is systemic corruption but rather both events should be handled independently.  Lobbied the Asian Development Bank to intiate the smart city; smart Towns, and smart village and leverage the technology to facilitate daily lives and business across villages; towns and the cities.  Lobbied for the rights of the women and asked the stakeholders to exert their influence in provisioning the rights of the women.  Lobbied for the additional damage compensation funding for the countries, which are victims in the war on terror  Lobbied for strengthening the democratic institutions across the globe, including Saudi Arabia; Pakistan; UAE and Qatar.  Formulated and executed credit, market and operational data standardization and agregation using large scale data sets  eCommerce OTC Pharma, and health care products solution development and launch  Real Estate Trading website development and launch - wordpress  Small to Medium Sized Business consulting & Financing  Setup & run a small sized hedge funds  Evaluated and created the derivative exchange model  Trading of Residential and Commercial Real Estate  Evaluated and created the last mile delivery business models  Plans route, delivery and customer services to Last Mile delivery customers Jan. 2013 to Aug. 2013 Sr. Consultant Liquidity Infrastructure, JP Morgan Chase Manhattan, NY:  Mapped data feeds from autonomous Product Processors (OPICS/IDDA/TSSMM/SCPP/NAPOLI) to Liquidity Measurement Data Engine.  Created the ODS Transformation Specs, related metadata, source/staging data quality package, and ODS data validation plans and scripts.  Executed data validation plan for Oracle DB solution, and created validated test release.  Contributed on reengineering of the common framework and staging data hubs.  Worked on snapshots for the Fed 4G Reporting, Basel LCR/NSF Reporting, and Liquidity statement construction/sources and uses of funds, Maturity ladder construction, and source and uses of cash.  Consulted on Stress Testing in liquidity risk for Deposits; Cash; Borrowings, structured notes, covered bonds, FHLB Advances.  Created artifacts in a strategic initiative to deliver metrics for the global strategic measurement and analytics reporting, then leverage the solution to support managers in all aspects of MIS reporting. February 2011 to December 2012 Sr. Consultant, Data Services, CitiBank, NY Delivered globally strategic business intelligence solutions which measured and improved operational performance, increase productivity and reduce exposure.  Created artifacts in a strategic initiative to deliver metrics for the global strategic measurement and analytics reporting, then leverage the solution to support managers in all aspects of MIS reporting.  Created all the SDLC artifacts e.g. Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) for using and integrating data from CORONA; SMART Stream/ReconFrontier; QuickRec; Reconportal; DBS.  Documented and communicated architectural technical standards  Improved the SMC, PMC, SECURE, HAMPER MTM and FX feeds usage  Created and launched global multi tier application portfolio for the Reconciliation Efficiency (Automatched, manual matched and Unmatched items)  Created the application for the Balance Sheet Exposure Reporting; Topside Reporting  Created comprehensive Use Cases to syndicate master data to the various internal clients.  Created comprehensive plans to de-duplicate and integrate the operational data.  Consulted on the pricing model for fixed income, equity, and options  Performed data profiling analysis on datasets to determine their quality, coverage, complexity and usability  Conducted JAD sessions to deliver business concepts and expected functional behavior to Developers  Created Feed specs/mapping, Data Analysis documentation, and ETL specs  Consulted on Legal Entity Key Design to enrich Global Breaks data with the Legal entity ID and Legal entity name  Consulted on strategic organizational and location changes to dramatically lower the cost of operations.  Consulted on strategic value driven integrated risk management; Global Legal Entity Design and Implementation; Pre-settlement trades/Fails/Depot & Cash breaks reporting and Intercompany trades/breaks reporting; Global Suspense Account Reporting; Global Payable and Receivable Reporting December 2009 to January 2011 Sr. BSA/Trading Subject Matter Expert, RBC:  Create Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) for using and integrating data from Bloomberg, Markit, and Reuters  Created comprehensive Use Cases to syndicate security master data to the trading applications.  Created comprehensive plans to de-duplicate and integrate the security reference data.  Created the pricing model, and integrated the pricing model with the security reference data  Performed analysis on datasets to determine their quality, coverage, complexity  Communicated business concepts and expected functional behavior to Developers  Communicated with downstream data consumers and upstream data providers (IT, Business and Operations) to determine objectives including requirements, issue resolution, solutions  Created Feed specs, Data Analysis documentation, and ETL specs  Developed Software/system Architecture diagrams, Application Use-Case diagrams, Enterprise Manageability diagrams and Process/Application Realization diagrams for the DEV/UAT/Prod Environments Jul 2009 – Nov 2009 Business Analyst, Risk Technology, Bank of America & Merril Lynch Responsibilities and accomplishments include,  Developed SQL Server stored procedures to report on trade modifications (Amendments, Cancels, Corrections) and P&L so that errors could be reported/charted, with the purpose of reducing costly trade breaks and smoothing P&L variance  Monitored Feeds quality and worked with Data Stewards, Front Office, Middle Office, to provide higher quality, more timely feeds.  Monitored the quality of reference data about trading books and supported process around creation and maintenance of that data.  Rolled-out and controled metadata tool (MetaData Mgr) to include training and procedures  Achieved Metadata Maturity Level 3  Assisted in ensuring lineage and key business elements are documented May 2005 to July 2009 Sr. BSA/Trading Subject Matter Expert, RBC:  Strategic consulting on improving time to market, and reducing order latency.  Delivered the solution on Option Symbology Project.  Delivered solution on fixed income product master, and fixed income pricing master.  Delivered fixed income trading solution TOM, a Bloomberg Offering.  Delivered the Investment Management Solution using the Prudential Solution.  Delivered the Institutional Trading & Compliance Solution using Charles River Trading  Delivered the Phase IV solution for integrating the Broadridge Brokerage services with Middle office applications of the RBC.  Developed Architectural Roadmaps which list the phases of work that need to be completed in order to take a Base Architecture to a Target Architecture  Delivered the installation of the FIX Messaging Engine for the Wealth Management Solution, interfacing with Prudential Wealth Management Services  Designed and installed FIX Messaging solution as part of the Fidessa Execution System Installation.  Designed, tested and install compliance solution on Charles River Platform. Delivered the global aggregated security position data for the clients.  Migrated the trading messaging platform from ISO15022 to FIX Engine  Interface directly with key business stakeholders across the investment/trading services business and translate the needs of the business back to the technology division.  Key BA functions include Requirements gathering (BRD), specification writing (FRD & SRD), testing and UAT  Defined the project scope for a range of global initiatives, defining project strategy for development, deployment and integration, and took ownership for delivery of functionality for the various applications.  Liaised directly with key stakeholders throughout Trading Services Equities, Operations, Finance, Compliance, and Technology. Aug 2004 to May 2005, Sr. Consultant Capital Market Technology, BearingPoint Inc.:  Consulted on business systems relating to order management, trade capture and allocation, portfolio modeling, real-time portfolio management and P&L tracking, and a multi-level, strategy-based hierarchy. May 2004-August 2004 Consultant, TD Securities Toronto  Worked with Bloomberg, Reuters, and Markit price feeds to enrich the security master for trading application, and position management.  Delivered Reference Data table schema design and  Engineered and executed testing of security master/ product master, and price master  Queried data using the SQL statements on Oracle platform; analysed data to create FSD; and prepare data mapping plans.  Normalized security master data using the Rules Manager  Participated as a member of the Architecture Governance Board, to define application principles which assisted in the development of well defined and actionable governance policies October 2003-April 2004 Consultant, CIBC, Toronto  Modeled data aggregation and warehousing, position and trade reconciliation, and on-line data analysis and reporting tools for centralized firm-wide data management and custom reporting.  Modeled the system to centralized terms and conditions repository and distribution engine with multi-vendor arbitration model, OTC support, real-time corporate action alerts, and daily event tracking.  Analysed and suggested processes for automated collection, storage and analysis of prices and market data, customizable pricing rules, and comprehensive audit and compliance reporting.  Worked on business process documentation for global portfolio accounting including general ledger reporting, performance measurement, and portfolio management.  Designed interface for data feed of daily market information.  Designed the reports for Peer group benchmarking, portfolio evaluation and relationship-based for hedge fund clients. January 2002 till October 2003 Business Analyst, AGF Management Inc. Toronto  Linked trading and order-routing systems to maximise automated trading.  Provided business requirements for Collateral management for cash and non-cash collateral.  Model the fee and commission system to generate detailed (and summary) fee statement, plus management of fee collection cycle.  Tested the systems in the areas of Loanet Automated Marks (LAMS) to automate daily mark-to-market.  Tested the systems in the area of Automated Recalls (ARMS) and Automated Returns (LARS) to automate recalls and intra-day loan returns.  Tested Risk management with the help of credit limits, concentration limits, mark-to-market reports and a variety of DTCC balancing tools.  Worked collaboratively with all stakeholders, including: users, IT Support and Project Manager. The individual will liaise between the client and our development toward translating requirements.  Independently led user training sessions and assisted users in a smooth transition to the new system.  Presented new functionalities, assisting in Client validation and testing. Participated in the preparation of Client testing catalogues.  Compiled gaps and reported/ followed up/ communicated these in the appropriate fashion within all levels and audiences August 1999 till September 2001, BPR & CI Consultant Burgan Bank, Safat, Kuwait  Implementation of the Symbols system (Acquired by Sungard, and branded as Ambit) across various verticals of the Bank.  Integration and Implementation of the eCommerce Application for the Bank with existing legacy systems.  Prepared and implemented cash management forecasting models on MS Excel spreadsheet using time series analysis;  Conducted the Quality Assessment Reviews of the entire bank;  Designed the business processes for internet banking (the BankWorld) and documented procedures/work instructions for internet banking and other Banking processes;  Established the optimum staffing model (Capacity Plan) for the various depts. of the bank;  Established and monitored service quality standards (through SLAs) for the entire bank;  Established & operated a Complaints management unit for the bank  Setting up the Quality Management System for the launch of ISO9000 Certification of the Bank January 1999-August 1999, Quality Assurance Manager, Commercial Bank of Qatar, Doha Qatar  Implementation of the Quality Management systems (ISO 9000 series) across the Operations Group of the Bank  Consulted on Functional requirements specification documents.  Reviewed all levels of data analysis, including data mappings, data feeds, data models, and data transformation as related to an Enterprise Environment  Consulted on logical and physical data models  Consulted on business practices, procedures, requirements, risk management and process improvements  Liaised with development team to plan and execute requirements  Consulted on Reference Data Domain on Equities/Fixed Income/Derivative asset classes December 1995 - January 1999, Business Analyst, MashreqBank, Dubai, UAE  Implementation of the automated Clearing Systems.  Implementation of the Interbank Settlement System using SWIFT Payment Messages  Decentralization of the Central Bank Payments, and installing Funding Infrastructure  Implementation of Globus Temenos systems across the global branch network.  General Ledger Data Mapping between the legacy system and the Globus Temenos application  General Ledger data conversion from the legacy to the Globus Temenos Banking System.  Prepared and implemented cash management forecasting models on MS Excel spreadsheet using time series analysis;  Developed, documented, reviewed and updated the quality system document for Cards Center and 11 branches  Strategic consulting and implementation of system and operations integration.  Enterprise level Policy development; Procedure development; and Work instructions development.  Strategic use of Robohelp in Process Documentation and documentation delivery to the end users  Up skilled end-users in the use of Banking System (Globus), with an end to end process perspective- in Banking Operations including; Trade Finance; Remittances; Treasury Operations; Customer and Account maintenance; Credit Administration; Term Deposits; Standing Orders etc. July 1992 - December 1995, Business Analyst, MC Bank  Verified and Investigated reconciliation results and provide detailed impact assessment of the breaks  Analyzed the break data to determine root cause and co-ordinate short and long term remediation with FO, MO, Credit Risk, Collateral Ops, CVA etc.  Collected statistics on issues and their root causes, and provided metric reporting to the management, in order to help identify systemic improvements and raising organization's efficiency  Worked with Technology team in documenting the necessary requirements/enhancements for the recons, user interface and automated reports  Performed and support foreign currency position valuation  Prepared all the required reporting and journal entries to support cash movement  Reconciled nostro accounts of the bank with correspondent banks, and recover USD 30 Million in wrongful, duplicate, and fraudulent payments.  Researched various entries in nostro account statements.  Performed audit checks on payments made by branch network.  Handled all regular interaction with assigned clients ensuring service level agreement requirements are fulfilled.  Participated in the internal and external audits of nostro accounts reconciliation.  Worked with Correspondent Banking Vendors like CitiBank NY; Chase JP Morgan; ABN Amro Bank; and American Express Bank.  Consulted in SWIFT system implementation across the Bank branch network and the headoffice. August 1990- July 1992 Freelance Treasury/Pricing Analyst, ANZ Grindlays Bank  Prepared Fixed income pricing and valuation Model for the trading of fixed income products in the primary and secondary market.  Constructed Interest Pricing Model, using Black Scholes/Merton Model as the base model.  Prepared strategy and implementation plan for launch of Investment Banking Operations and Products for the Bank  Strategise on the Textile Industry key market players, credit assessment  Prepared and implemented cash management forecasting models on MS Excel spreadsheet;  Perform and supported foreign currency pricing; mark to market valuation; and Profit & Loss Calculation  Liquidity Risk Modelling and Reporting Special Projects  Prepared Industry & Strategy Analysis on the Textile Sector (Spinning & Weaving) to support the Credit/Lending Straetgy for the American Express Bank  Designed and implemented Liquidity and Cashflow forecasting Model for the National Development Finance Corporation  Strategise on creation and development of Interest Rate Options Market for the fixed income securities ANZ Grindlays Bank  Model the Integrated Settlement System Using the SWIFT Category 5 Message and the FIX Protocol to Western Assets Management EDUCATION 1) MBA, IBA (affiliated with Wharton School of Business University of Pennsylvania) (MBA) Banking & Finance 2) BS, University of Karachi 3) Certificate in Information Systems Management, Ryerson University 4) Certified Management Accountant (CMA) and Certified Financial Manager (CFM), USA 5) Diploma in Banking & Finance from Institute of Bankers 6) Strategic Decision & Risk Management, Stanford University USA (OG) Core Skill set: Project Management/SDLC: Worked on all phases of SDLC, Requirement Engineering; Change Management, Knowledge Management; Requirement/testing Documentation, System conversion, System testing, Configuration management, External design, User/system interfaces design. Framework: COSO , COBIT, COCO Methodologies: Structured SDLC; Agile/Scrum; RUP/UML Data Modelling Tool:Erwin. Data Profiling Tool: DataCentrist Query Languages: AS400 Query; ANSI SQL; MS Query; Access Query; Tandem Query Rules Manager Expertise: Jrule, an IBM product SAP: SAP Financial; BW/BI; Business Object; Crystal Report; Xelsius; WEBI Rich Client; Information View; Business Object Designer; Deski; Sybase iSQL; Sybase IQ Reporting Tools: Actuate; Cognos; Hyperion; Microstrategy Broadridge ApplicationSuite: BPS; BPSA; Gloss; Name and Address application; NEWB; Phase IV; OMS; Broadridge Intact Message creation and Intact Message Mapping. Data Analysis: Data Integration; Data Profiling; Data Quality Management; Data Clansing; TOAD Quest; Data Warehousing: Operational Data Store (ODS); Subject/Topical Data store for Legal Entity Identifier, Dodd Frank; Volker Rule, and Regulatory Reporting, BPSA Cash Breaks Products/Depots Reconciliation Product: StreetSmart; intelliMatch; CORONA; TLM; Recon Frontier, Recon Trade, Quickrec; Reconportal; Settlement Systems: IOWA, DOGS, ATLAS, Broadridge, GCS, iBroker, COPES, KOSMOS, MatchBook, NOVA, Powerbase, Quantum, RADAR, Sonoma. OASSY OMGEO Investment Management Products: Berton; Messaging Service; FIX Protocol; SWIFT Share Transfer Application: Unitrax Capital Market Systems: Fidessa Execution System; Summit; Wall Street; Murex; RBC Accel Risk Systems: Experience in Risk Systems like Oracle OFSAA, Algorithmics, Adaptive, J-Risk DataBase Technologies: MSSQL; SSAS; Oracle 11g; DB2; Data Viusalization: Oracle, Cognos, DataStage, Tableau, Business Objects; Informatica; Goldensource; Asset Control; Talend Bloomberg Product: TOM; NOW Testing Applications: JIRA; HP Mercury Quality Center; QTP Project Management: Primavera; MS Project Reference Data Products Worked: Thompson Reuters (Price feed); Bloomberg (Price feed); IDC; OCC (Options Clearing Corp, Derivative Pricing; Option Symbology [OCC]; Broadridge (security master, MSD); Markit; Security Master Data from Eagle Investments/BONY Mellon; CUSIP Symbology; ISIN Symbology; SEDOL Symbology; Goldensource; Asset Control; SMC/PMC Reference Data Analysis & Design; Reference Data Domain Expert on Equities/Fixed Income/Derivative asset classes; Knowledge/experience of working on Enterprise wide Reference Data Systems; SMC; PMC; HAMPER; SECURE Asset Tracker/Escheatment; Dodd & Frank Act; Sarbanes Oxley; Basel II & III; Anti Money Laundering & TF ISO Standards: ISO 9000 series, ISO 15022, ISO 17442 Risk Measurement: Equity Factor Models, Stress Tests and Performance Analysis, , Market VAR, Credit VAR, Potential Future Exposure; Counter party Risk Measurement & Reporting; Liquidity Risk Measurement and Reporting SS&C Application Suite;RiskWatch, SAP, PSGL, Global Fixed Income, Opentext, sharepoint, Merva, Murex, Solomon. Fixed Income Offering and Syndication Application, and application design for Front Office, Middle Office, and Back Office Process. Equity applications for offering, syndication, execution, middle office, and back office. Derivative applications for offering, execution, middle office, and back office. Basle Capital Accord: Basle I; Basle II; and Basle III Capital Accord Asset Classes/Product Expertise: Equities; Options; SWAPS; Fixed income; Credit derivatives; Treasuries; Mortgage Backed Securities; Assets Backed Securities; FX Spot/Forward/Futures; Commodity Trading; Indexes; Hedge Funds; Mutual Funds; Repo/Reverse Repo; Receivable Securitization; CDS Options: Put, Call, LEAP, ELX, Flex. Auxiliary Skill Set: Languages Worked: Visual Basic/VBA; ANSI C; C++; JAVA; Visaul Basic; SQL; HTML; XML SQL, PL/SQL, SQL Forms, SQL ReportWriter; Transact-SQL (Tables, Stored procedures, Views, Functions) Oracle Products: Oracle 11g; SQL Developer; Oracle Plus; Flexcube; Hyperion; Investment Management Products: Charles River; SIMCORP: Prudential; Portia Statistical Packages: SAS; R; S; Matlab EAI Products Knowhow: STPIP Business Ware; Vitria; TIBCO Environments Worked: UNIX, Linux, Windows NT, 2000, XP, Tandem; HP Nonstop Architectural Framework: Zachman; TOGAF; MODAF; Archimate