1 / 9

Database Management & Data Transformation Solutions

Database Management & Data Transformation Solutions. by Database Management Department Welltitled Computer Systems Co., Ltd. Company Background. Backed by a group of overseas investors from the US and the UK.

tommy
Download Presentation

Database Management & Data Transformation Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Management & Data Transformation Solutions by Database Management Department Welltitled Computer Systems Co., Ltd

  2. Company Background • Backed by a group of overseas investors from the US and the UK. • Each member of the Management Team has over 10 years of relevant management and / or technical experiences in industries such as software development, hardware engineering, database development and management consulting. All have extensive experience working for large corporations, including Intel, Guangdong CITS, Worldspan, British Airways, Dell (EMEA) and Channel Four. • Team Mission: to utilise state-of-the-art technology and best-in-class methodologies to provide our clients with customised database management solutions, which, in turn, ultimately enhances their operational efficiencies and market competitiveness.

  3. Our Solutions • Database management, and data transformation, warehousing and mining services for the financial markets (Mortgage / Asset-Backed Securities). • Marketing Process Management system – an industry-leading database marketing, customer service and questionnaire management system for FMGC businesses. • Development and implementation of industry-specific database management systems and related analytical tools. • Consulting – devising and implementing database marketing strategies.

  4. Our Clients • Several leading financial services consultancies in the US, including a US$10billion, NASDAQ-listed financial data provider; • MedJohnson China Ltd; • Torado (Tianjin) Ltd., China; • MengNiu Ltd., China (2319:HK)

  5. Job Sample

  6. MBS & ABS Data Analytics • Extensive experience in the acquisition of Static / At Issue and monthly Remittance Loan-level data for the top US servicers, including Wells Fargo, JPMorgan Chase, Countrywide, Deutsche Bank, Citi, Aurora, Bank of New York and GMAC RFC. • Streamlining and normalisation of Loan-level and Deal-level data from various data sources / servicers, who all provide widely different raw data formats, into one single coherent format, as specified by the client. • Data aggregation – bucketing Loan-level information based on Loan Programs (HELOCs, HE, ALT A, Jumbo / Prime, Subprime, etc.) , Loan types / categories (Fixed, ARMs, Hybrids, Convertibles, Balloons, Interest Only, Pay Option ARMs, etc.) and Lien Positions. • Data mining and analysis – Payment History, prepayment indicators, Negative Amortisation indicators, Delinquency status indicators, Default Loss analysis, LTV analysis, etc. • Statistical analysis – an overview of the Loan-level data based on Loan Programs, Loan Types and Lien Positions. • Tying in Loan-level reports with Deal-level reports to corroborate Loan counts, Balance at origination, Collateral Descriptions, Asset Classes, etc.

  7. Data Processing – Master Table

  8. Data Processing – History Table

  9. We look forward to working with you soon!

More Related