Jayzed Data Models Inc., 657 Stimpson Hill Rd., Whitingham, VT 05361, USA Web: www.jayzed.com E-Mail: jziemer@jayzed.com RESUME (CV): JURGEN ZIEMER Data Architect, 16 years industry experience at leading international institutions and consulting service providers. I have long term development and business experience, communicate well with all stakeholders, optimize objectives, leverage state of the art tools and best practices, integrate into corporate systems and deliver on time. My client gets the best service. Business Analysis Finance - 8 years Capital Markets, Credit, Market & Operational Risk, Merger & Acquisition, Hedging, Trading & Settlement, Securities, FI & FX, Derivatives, Legal & Compliance, Accounting, Business Process Modeling Data Modeling - 7 years Relational (OLTP) and dimensional (BI/ Data Warehouse) Design Tools: ERWIN, Rational Databases: DB2/UDB, Teradata , Oracle, MS-SQLServer, Sybase, Informix Development background - 8 years SQL, Stored Procedures, Triggers, C++, Office/VBA , ODBC, HTML on NT, Unix and Mainframe INDUSTRY EXPERIENCE February 2003 - present: International Consultant for Risk Management and Financial Markets Architecture: November 2003 - present: IBM Software Group - SWG Data Warehouse Architect serving international banks. The IBM Information Framework (IFW) provides the basis of enterprise architecture and model based development. It is a set of Banking Industry specific foundation-, data-, process- and object-models. State Street the world's largest custodian servicing 13 trillion in assets for institutional investors. Leading data modeling for 3000 attribute global corporate data warehouse. Structured business requirements and designed conceptional data model. Calculated efforts and compiled MS-Project plan. Basel II Implementation at Wachovia, 4th largest US bank. Leading a team of 10 Sr. Data Modelers from IBM, Teradata and the bank to design the central Basel II Credit Risk database. Customizing and enhancing Teradata's Financial Services Logical Data Model (FSLDM). Delivered 350 table detailed implementation data model for A-IRB Retail. Basel II data warehouse at Firstbank, China (ROC) Leading team of 15 modelers and mappers designing Banking Data Warehouse (BDW) for Standardized and IRB, corporate and retail exposures. Supported Basel II related implementation, education and sales at banks in North America (Wachovia, Scotia, BMO, NBC, BB&T), Europe (Deutsche, HSBC, SEB, Bank Austria) and Asia (FCB, Kasikorn, KTB, BCA). Participated in high-level meetings and presented to executives (CRO & CIO). Compiled and revised Statements of Work and project plans (MS-Project) for data warehouse implementations. Conducted BDW Education courses and user-workshops for Credit Risk (Basel II), Economic Capital, Market Risk, Operational Risk and Asset/Liability Management. Conducted Process Model education courses Led Data Gap Assessments (DGA) at 3 banks for Credit Risk under Basel II Revised Framework based on IBM's DGA spreadsheet.  Provided guidance and review for IBM product development. New Financial Markets Data Warehouse (FMDW) data model Financial Market Process Models Annual BDW Releases for regulatory compliance Created IBM spreadsheet for Basel II Data Gap Analysis May 2004, 2005: Accenture Project Manager for Basel II delivered functional & technical solution architecture for Credit Risk. The Accenture offering is in cooperation with Mercer Oliver Wyman (MOW), a leader in financial services and risk management consulting. January - March 2005: Korea Development Bank (KDB), government owned bank specialized in commercial & investment banking. March - August 2004: KB Kookmin, Korea's largest retail & commercial bank. Leading a teams of 10 Accenture consultants, working closely with the bank's and MOW risk capital professionals. Presented to executives (CRO) and national banking supervisor (FSS) Developed customized Basel II ERWin relational data model for capital calculation (80 entities) and dimensional model for regulatory reporting (50 entities). Above "Korean" model replaced the standard Accenture Global Asset for Basel II engagements. Migrated initial MS Access based model to ERWin, added Asset Securitization Framework, Credit Risk Mitigation, Internal & External Ratings and Exposure classes. February 2003 – October 2003: JAYZED White paper series for Financial Database design. In-dept study of Credit Risk and the Basel II requirements for banking Capital Adequacy. Short-term project assistance, presentations, training and design. August 1999 – January 2003 Credit Suisse First Boston - CSFB (Investment Banking) Data Architect design and improvement of the bank's global database systems in an environment of over 500 databases and 12000 tables. Personally designed more than 1000 new tables (plus 600 changes to existing tables) 30 new databases of up to 80 tables; implemented redesign/changes/additions on more than 90 existing database systems. Designed operational (normalized) systems as well as DSS reporting systems (Data Warehouse/Star Schema). Analyzed Business in Credit & Operational Risk Management (Basel II database), Financial Control, Legal & Compliance, Investment Banking, Trading/Settlement systems, Securities, Corporate Reference data, Accounting (PeopleSoft/GL), Human Resources (PeopleSoft/HR) Integrated databases in post merger of Donaldson, Lufkin & Jenrette, DLJ. Data Modeled on ERWin Front- and Back-Office databases for MS-SQLServer, Oracle, Sybase and DB2 target systems. Guided development teams from New York, London, Zurich and Hong-Kong. Performed in-depth data mining on Meta- and Business Data. Defined Message Formats to standardize corporate inter-application communication April 1999 – July 1999: JAYZED Web-Site and Intranet development, contract maintenance, MS-FrontPage, MS-Access January 1999 – March 1999: REUTERS/Sailfish (Market Risk Management) Sr. Technical Engineer developed quality assurance database for the KVAR+ Risk Management Data Modeled with ERWin QA tracking for derivative pricing, stored procedures and triggers Created the new 50 table Database on Sybase 11.5, wrote 15 stored procedures Set up HTML Intranet documentation June 1998 – December 1998: German Stock Exchange (Trading) Data Architect in a highly visible Client/Server project to provide Bonds Traders with value adding functionality and a windows front-end for Frankfurt Exchange’s XETRA electronic trading Performed Business Analysis with trading domain experts Data modeled the trading process, referential integrity and security, Silverrun design tool. Created approx. 30 tables, 10 views, 40 stored procedures for Online Transaction Processing, Set-Up, Administrated and tuned MS-SQLServer 6.5 engine, supported the development team with ad-hoc data query and manipulation, Implemented the NT-process programming MFC, ODBC Database classes, DCOM and ported the schema to Oracle 8 / Sun Solaris June 1995 – May 1998: START Amadeus (Online Ticketing) Database Developer developed accounting and statistic programs in largest national booking system for concert tickets and the EXPO 2000. Technical Lead in subprojects. January 1993 - May 1995: Management Data (Computer Aided Radio) Product Manager, Programmer Analyst (Employee) designed automatic music scheduler, now used at major European radio stations; leading a team of 4 Programmer/Analysts. June 1990 - December 1992: gfs (Systems Engineering) Programmer Analyst (Employee) leading a team of 4 and developed a Database-Gateway to connect Gupta SQL-Windows to BS2000 mainframe databases. May 1989 - May 1990: Albis Plastics (Chemical Industry), BP Flussiggas (Petroleum Industry) Programmer developing Spreadsheet interface to Oracle, Freight cost optimization EDUCATION October 1984 - April 1989: University of Hamburg, Major: Computer Science, Minor: Economics July 1983 - September 1984: German Air Force, Military Draft, Private First Class June 83: Gymnasium Uhlenhorst Barmbek, ‘Abitur’ certificate and graduation diploma