Lead Data Modeler Resume
New York, NY
SUMMARY
- I will drive profitability, improve service and increase customer satisfaction by eliminating the overhead associated with inconsistent and redundant data.
TECHNICAL SKILLS
- Erwin
- ER Studio
- InfoSphere Data Architect
- Enterprise Architect
- Oracle Data Modeler
- BDW
- Zachman
- TOGAF
- FEAF
- FIBO
- DB2
- Sybase
- SQL Server
- Teradata
- Cassandra
- Informatica
- MongoDB
- UML
PROFESSIONAL EXPERIENCE
Confidential, New York, NY
Lead Data Modeler
Responsibilities:
- Extended the Enterprise Data Model by designing the Residential Mortgage component.
Confidential, New York, NY
Enterprise Information Architect
Responsibilities:
- For Account Master Central, Confidential ’s new centralized data warehouse and system of record for involved party and account information, created the data model, designed the database, and provided the ETL mappings.
- For Security Master Central, Confidential 's global financial instrument reference database, provided production database models and recommedations for structural improvements to improve efficiency and reduce redundancy.
- Enhanced the Enterprise Data Model (CRDM), Confidential ’s enterprise data model and data dictionary, by aligning it with Confidential ’s critical business data elements (CDEs) and Confidential ’s key systems - Account Master Central, Security Master Central, Legal Entity Reference Database, Compliance, AML and Human Resources.
- For Data Governance, synchronized the Confidential Data Standards with the Enterprise Data Model.
- Formulated a method for integrating relational and NoSQL data structures using metadata integration bridges combined with RDBMS and Big Data Modeling.
Confidential New York, NY
Data Architect
Responsibilities:
- For the Service Oriented Architecture (SOA) initiative of one of the world’s largest law firms, built data models of the critical systems and a virtualization layer model based on data structure, location, completeness and complexity.
Confidential, New York, NY
Lead Data Modeler
Responsibilities:
- Designed the Doing Business with Confidential Database, Mayor Bloomberg’s campaign finance reform data warehouse.
Confidential, New York, NY
Data Architect
Responsibilities:
- Created an Enterprise Data Model and system data models for USA's largest music licensing agency.
Confidential, Jersey City, NJ
Enterprise Data Modeler
Responsibilities:
- Devised a metadata integration strategy for the Enterprise Data Standards initiative.
- Organized all existing data models, data flows and data dictionaries into a MetaData Repository.
- Created physical data models of all databases and logical data models of strategic customer and product databases. Designed a Corporate Conceptual Model as an architecture migration target.
- Redesigned the key structures of Merrill’s central Institutional Client Database.
Confidential, San Franciso, CA
Enterprise Data Architect
Responsibilities:
- Designed a comprehensive IT Asset Data Model and system xref to facilitate development of Confidential ’s Enterprise Architecture Repository and provide an analysis of system information redundancy and deficiency.
Confidential, New York, NY
Lead Data Modeler
Responsibilities:
- Built an information model for transformation of the traditional credit product infrastructure.
- Confidential Office of Payroll Administration New York, NY (2003-2003) Data Architect
- Provided recommendations to improve database integrity and performance.
Confidential, Jersey City, NJ
Lead Data Modeler
Responsibilities:
- Reversed engineered the key production databases and developed data models for customer, account, branch administration, marketing, bookkeeping, fulfillment, and relationship management..
- Provided inter-company data mappings and data dictionaries to faciliate their merger with a day trading firm.
Confidential, New York, NY
Data Architect
Responsibilities:
- Developed a logical data model and physical database design for the Commercial Mortgage Loan System.
Confidential, New York, NY
Lead Data Modeler
Responsibilities:
- Provided data models, database designs and ETL mappings for the Internet Data Aggregation project
Confidential, New York, NY
Database Designer
Responsibilities:
- Created the data model and database design for an OLTP B2B trading system designed to help major financial institutions trade complex investment instruments such as futures, options, swaps and other derivatives.
Confidential, New York, NY
Lead Data Modeler
Responsibilities:- Designed the Enterprise Data Model, the Corporate Data Warehouse and the Investnent Management Database.
- Created the data model for VISTA Funds Management Information System (assets over $25 billion).
- Reversed engineered and provided data models of all key investment and relationship management (CRM) systems. Designed a Metadata Management (MDM) data model and database used for the Chase and JP Morgan merger.