Resume

Sign in

Data Modeler

Location:
New York City, New York, United States
Posted:
March 11, 2019

Contact this candidate

Resume:

CLAIRE L. FRANKEL

** ****** ***** *****, #**

New York, N.Y. 10022

917-***-**** cell

ac8q1n@r.postjobfree.com

SENIOR DATA ARCHITECT

Accomplished in delivering highly complex and competitive banking, investment and risk database designs.

Ms. Frankel has a mastery of tactical and strategic Data Architecture in data modeling, database design and data administration for relational databases including Risk, Regulatory Compliance, Client Masterfile, Securities Masterfiles, Reference Data and Exchanges. This mastery has been gained through hands-on experience. She is also very experienced in Data Governance development, Data Lineage and related fields.

Ms. Frankel delivers Forward Engineering of conceptual, logical and physical data models, and ddl production, of relational and non-relational databases. This includes, but is not limited to regulatory requirement/ databases, including the GDPR, BCBS 239, Dodd-Frank, Sarbanes-Oxley (SOX) and Basel. She also delivers Reverse Engineered models from any relational database with evaluation and improvement (forensic database investigations) and extensive data mapping to meet compliance requirements. Areas of expertise:

GDPR, CCAR & BCBS 239 Reference Data Models & Databases

Data Governance AML - Anti Money Laundering Data Analysis RDBMS Data Modeling Standards & Guidelines

Regulatory Compliance Security Industry Operations

Data Warehouse & Business Intelligence Design Master Data Management

Business Planning, Analysis and Modeling Securities Industry Data Models (ERDs)

SWIFT and Internal Messaging Risk Measurement Databases

Erwin DM tool/ ETL/ELT designs Data Dictionaries, Big Data

Data & Metadata Management Oracle, Oracle CDM, DB2, Sybase, SQL

PROFESSIONAL HISTORY

U.S. Government (confidential) Sept 2018 – Present

Senior Consultant

Winter Wyman, New York, N.Y. Dec 2017 – June 2018

Senior Consultant, GDPR

Consultant to the Institute for International Education (IIE) for GDPR compliance. Identified all PII (Personal Identifiable Information of Clients) fields in CRM, the Grantee Masterfile, wrote robust definitions for the PII fields and chaired the committee which reviewed the definitions. Then, identified PII in 2 feeder systems to the CRM, mapped them to CRM and also mapped Slate standard fields (the replacement for CRM) to CRM. Staff reference person for CCAR and GDPR.

Civicor, Inc., New York, N.Y. May 2017 – August 2018

Chief Information Officer & Head of Data Architecture

Civicor was a start-up company, specializing in automation products for the Financial Services industry. Responsibilities included Data Architecture, Data Governance & Regulatory Compliance for Blockchain applications. My role included advising the CEO, providing advice on U.S. and European regulations such as GDPR, CCAR, Basil, etc., and providing database designs, including ETL/ELT recommendations for the relational /cloud database. This organization has shut down due to lack of Round A financing.

JP Morgan Chase & Co., New York July 2012 – May 2017

Executive Director, Risk and Control Systems Technology

For Corporate Oversight & Controls (O&C - Risk Measurement,) managed the Center of Excellence for Data Modeling, a successful group of Business/ Data Analysts, Data Modelers and Database Engineers. Oracle platform. Delivered :

2 major Risk database designs – Phoenix replacement (FORCE) and Controls Room

6 evaluations of critical physical data model designs (via reverse engineering) for interdependent systems, including Client Master and Instrument Master, and wrote recommendations for repair

Conceptual, Logical and Physical Data Models, including ERDs, Data Dictionaries and DDL for Risk, Regulatory Oversight, Controls, SOX and Basel mappings, Third Party Oversight and User Tools Databases

Created Data Lineage mapping for BCBS239. Reviewed CCAR and GDPR rules for compliance.

Compiled project data glossaries, data hierarchies, and Logical Data Models for Legal Obligations, Consumer Risk and Client Master Data links to Risk. Organized SMEs to address data issues.

Published and maintain Standards and Guidelines for Data Modeling, Class Words, and Naming Standards. Established Standards for Model Governance, using Erwin’s ModelMart.

Brought User Tool Inventory data models up to current Production level, from 3 versions behind

Target databases: Oracle, SQL, DB2, Teradata

Attracted and retain top talent: hired staff of Senior and Junior Data Modelers to create the Data Modeling Group for Controls Systems Technology

For Compliance, compiled project data dictionaries and logical data models for Control Room, Legal Obligations, Anti Money Laundering and Consumer Risk Basel Reporting,

Morgan Stanley, New York, N.Y. April 2010 - July 2012

Vice President, Enterprise Data Group (EDG)

The Enterprise Data Group (EDG) was a 600-person global organization within Morgan Stanley Institutional Management, responsible for the collection, refinement, and distribution of Instrument, Client, Account and Industry-standard reference data.

Delivered Conceptual and Logical Data Model Framework for all of Securities Reference Data. Supervised development of the Logical Model for listed derivatives and fixed income products at the granular and at the set level.

Reviewed all EDG logical and physical data models

Led Standards development, including bitemporality, versioning and namespaces

Led Project management, budget, staffing and mentoring for reverse engineering 38 physical data models and data dictionaries across 6 EDG Practice Areas

Established Standards for Reference Data Model Governance, including Client Master Data Management, using Erwin’s ModelMart

Evaluated the “Proof of Concept” activities of 2 metadata repository vendors for the benefit of the Enterprise Data Group

Designed ‘Anti Money Laundering’ section of new client intake database

Provided a lower cost alternative to a $2 M IBM/DB2 data model, reference data model mentoring and the selection of training content and instructors for internal data modeling classes – U.S., Canada, U.K., and Shanghai. Wrote the data model requirements for a metadata repository to be purchased from a vendor.

Managed a group of 19 IT Officers who wrote and edited EDG Standards. Delivered 4 Relational Data Modeling/ Data Dictionary Standards, and 2 sets of SWIFT Data Rules.

Teradata, Inc. New York, N.Y. 6/2008 to 4/2010

Senior Capital Markets Officer, North East USA & Europe

Teradata is the leading data warehouse technology vendor, worldwide (Gartner Industry Reports) The FS-LDM is Teradata’s normalized Financial Services Logical Data Model, with detailed subject areas for credit cards, asset-backed securities, retail and investment banking, risk, and regulatory requirements.

Managed all technological and business aspects of sales, not attended to by the Sales Executives, including relations with officers at clients and potential clients and communication between clients and Teradata’s R&D department

Applied the Teradata Financial Services Logical Data Model to clients’ projects

Created and presented technical topics; wrote white papers.

Responsible for $1M of business results.

For Standard & Poor’s: redesigned a domestic database for global application.

For Credit Suisse: modeled global trades, risk exposure, trade posting, and trade settlement using Teradata’s Financial Services Data Model

Augmented the Derivatives subject area of the FS-LDM and it was adopted by Teradata

Odyssey Financial Technologies, Inc., New York, N.Y. 9/2005 to 6/2008

North American Pre-Sales and Post-Sales Database Manager

Provided technical expertise for Odyssey’s Securities Reference Database and Market Data Cleansing system in the Americas. Expertise centered around Odyssey’s sophisticated proprietary securities reference database, in tandem with an algorithymic-driven filtering cleansing and comparison Market Data subsystem for Bloomberg, Reuters, Telekurs, and generic source market data. Responsibilities included:

Presentations and demonstrations to clients; RFP responses

Data Modeling Lead Engineer

Development and presentation of technical courses to clients and internal staff

Mapping and testing client securities data

Computer Sciences Corporation, New York, N.Y. 3/2004 to 9/2005

Senior Principle Consultant – Securities Reference Warehouse

For Nationwide, advised IT Senior Management on the selection of a new Securities Reference Database package; candidates were DST, FTI and Eagle/Pace.

Advised Management on all installation issues of the selected package, Eagle/Pace

Wrote the specification for the DMO (Data Management Office). Identified (1) all securities masterfile data in current systems, and (2) all performance monitoring and attribution data in current systems, in preparation to map both to Eagle/Pace

Goldman, Sachs & Co., Inc., New York, N.Y. 9/1999 to 03/2004 Senior Data Architect, Financial Information Architecture

Provided logical and physical data models (and DDL) for CPDB (Client Profile Database) for the Private Wealth Management Division. This GS Division has over $1 B in AUM. Recruited by Goldman.com in 2000 to transition the theoretical PWM data model to a populated operational structure. Responsible for data dictionary, modeling and testing within the overall database development framework of Sybase. Delivered:

Financial business analysis – worked with Users and Development Management to translate securities requirements and user experience into site structures, ERDs and star schema for client applications

Rewrote all equity product, and client-oriented business definitions in the Global Business Model to conform to SEC definitions; wrote scripts for versioning the db deployment on multi-tier PWM/ Asset Management architecture

Recruited internally, in 2002, to Cross-Divisional Projects and Architecture Division. Completely overhauled Goldman’s internal SWIFT-based messaging structure for distributed equity, fixed income, options and derivatives factories and subledgers, by negotiating common metadata/ messaging standards. As GDR product manager, saved the Firm $1.5 M in re-testing and re-writing costs for U.S. Treasuries and Mortgages factories.

IBM Corporation, New York, NY

8/1996 to 9/1999

Executive Information Consultant, Financial Data Architecture

Designed front to back DB2 Information Architecture for a Global Money Market application.

Created an STP solution for a large correspondent clearing firm. Developed plan to upgrade 10 systems, to DB2 using IE Development Methodology and Zachman framework. Led data-centric evaluation and presented findings and plan to executive management

National Securities Clearing Corporation (NSCC), New York, NY

5/1991 to 7/1996

Vice President, Database Engineering

Established the Database Administration and Design practice. Established James Martin’s Information Engineering methodology practices, database modeling (ERDs), and the enterprise-wide data design for equity and fixed income settlement Applications included: Money Settlement, Real-time Equity Trade Matching, Aggregated Order Management, Fixed Income Settlement, Billing, ACAT, Cross-Collateralization and FundSERV. Directly managed staff of 10 and managed, dotted line, an additional 8 staff at SIAC. $5 Million Budget responsibility.

Established assembly line procedures for rapidly rolling out new DB2 and Sybase databases – requirements gathering, data analysis, ERD, database design and extensive implementation procedures.

Established database subject areas on distributed servers which served as masterfiles, including ‘Client,’ ‘ Product,’ and ‘Security.’

Supported applications from business and database points of view, including requirements definitions, JAD sessions, prototyping, database design, systems development, testing and staged migrations

Served as a U.S. Brokerage Industry delegate to SWIFT, ANSI x9D and ISO Data Dictionary Standards Committees.

PROFESSIONAL DEVELOPMENT

Education: B.A. in Physics/Mathematics, State University of New York at Albany 1976

Graduate courses in Computer Engineering

Affiliations: Data Administrator’s Management Association (DAMA)

Enterprise Data Management (EDM) Council

Wall Street Technology Association (WSTA)

Author: White Papers on FAS-157 and SEC144A.

“Handbook of Investment Technology” Chapter 11: Electronic Messaging Standards and Standards Development Organizations



Contact this candidate