RESUME (CV): JURGEN ZIEMER

Data Architect, 18 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.

• Business Analysis Finance - 10 years
  Capital Markets, Credit, Market & Operational Risk, Merger & Acquisition, Hedging, Trading & Settlement, Securities, FI & FX, Derivatives, Legal & Compliance, Accounting, Business Process Modeling
• Data Modeling - 10 years
  Relational (OLTP) and dimensional (BI/ Data Warehouse)
  Design Tools: ERWIN, RDA/EME 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 Banking and Financial Markets Data Architecture

November 2003 - present: IBM Software Group - SWG
Data Warehouse Architect serving international financial institutions.
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 Global Performance Analytics Security Master model.
  • Structured business requirements and designed 120 entity conceptual data model
  • Calculated efforts and compiled MS-Project plan, staffing org-chart.
• 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 Implementation, education and sales at banks in North America (Wachovia, Scotia, BMO, NBC, BB&T), Europe (Deutsche, HSBC, SEB, Bank Austria, Russian Central Bank) 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)
  • Conducted IFW Education courses and user-workshops for Process and Data Modeling in Credit Risk (Basel II), Economic Capital, Market Risk, Operational Risk and Asset/Liability Management.
  • Led Basel II Data Gap Assessments (DGA) at 3 banks for Credit Risk
•  Provided guidance and review for IBM IFW product development.
  • Financial Market Process Models and new Financial Markets Data Warehouse (FMDW) data model
  • Annual BDW/FMDW 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