Director, Data Architecture Resume Hartford, CT - Hire IT People

SUMMARY:

Demonstrated Success in Design and Delivery of Security/Pricing Master & Data Warehouse Projects, Design and Delivery of Data Warehouse in the Fixed Income Space, Product Development
Data Architecture Roadmap, Data Architecture Framework for Transition from Current to Future State, Data Model Design and Data Analysis, Design and Delivery of Customer
Master Data Solutions and Management of On - shore/Off-Shore Teams for Product Design and Delivery
Data Warehouse Design/Architecture, Dimensional Modeling, ODS Modeling, Star Schema,

TECHNICAL SKILLS:

Business Intelligence Tools: Microstrategy 9

Data Modeling Tools: ERWIN All Fusion r7.2, ER Studio 8, Visio

ETL Tools: Informatica 5.x and 6.x, Abinitio GDE 1.14.33/2.14.102Relational Databases SQL Server 2000/2005/2008/2016, SQL Agent, Oracle 8.i & 9.i, 10G, Toad 11

Data Warehousing Methodologies: Kimball, Bill Inmon Evaluated Multiple Security Master Products such as, Markit’s EDM, AIM GAIN, Black Mountain

Statistical Software: SAS, SPSS

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Director, Data Architecture

Responsibilities:

Security Master and Data Warehouse Product Selection/Current Vs Future States
Analyzed the Current Master Data Architecture and Identified the GAPs
Developed Data Architecture Roadmap for Master and Data Warehouse Implementation for the Replacement of the Current Architecture

Confidential, New York City/Wilton, CT

Data Architect Manager

Responsibilities:

Design & Architecture of Confidential Finance Pricing Data Mart
Designed and Architected a Star Schema for Confidential ’s Pricing Data Mart
Designed a Staging, an ODS and Data Mart Architecture for the Pricing data Mart
Designed and Architected Various Daily, Monthly and Quarterly Reports that were Created from this Data Mart
Designed Fact-Less Fact Tables and Integrated Degenerate Dimensions into the Fact Table for Quick Reporting and Analysis
Daily Trade Blotter Report Design, Architecture and Development
Designed and Architected and Implemented in SQL Server 2008 an Automated Daily Trade Blotter Report for Post Trade Compliance Purposes
The Blotter Report Compared the Golden Copy Price to the Trade Execution Price to Look for Exceptions
Designed and Integrated Complex Rules for Structured Products such as CMBS, RMBS and CLOs and Back Dated Trades
Data Integration, Transformation and Standardization for Valuation Architecture for the Data Mart
Developed and Designed Data Integration & Transformation Architecture Among Various Data Sources - such as the Security Master, the Pricing Master Data, Several Other Pricing Databases
Designed and Developed Multiple Pricing Reports with Complex Business Rules and Pricing Hierarchy Based on Various Pricing Vendors such as - Markit, IDC, Lehman and Bloomberg Using the Pricing Data Mart
Balance Sheet Reconciliation, Data Audit & Controls
Multifaceted/Multilevel 10K/10Q Reconciliations by Asset Class: Created a Multi-Step Process that Reconciled the Marked to Market Fixed Income and Equity Securities from an Unadjusted Month End Market Value to the Adjusted Market Value that Reconciles to the 10k/10Q Market Value
Market Value Reconciliation: Identified the Factors needed (in addition to Price and Notional) to Validate the Market Values in the Data Warehouse.
Sovereign Short-Term Bonds Analysis & Price Derivation
Identified the Short Term Corporate and Emerging Market Bonds that might have had an Out of Tolerance Price

Confidential, Hartford, CT

Information/Data Architect

Responsibilities:

Designed Staging Area, ODS, Data Warehouse, Data Mart for State Reporting
Created Data Warehouse Architecture containing Dimensions, Facts, Fact-Less Facts & Degenerate Dimensions
Designed and ODS architecture that is more normalized that enables us to store detailed member information
Designed a “Switch Table” technique to Convert Source Data into a Star Schema
Designed a normalized (Snow Flake) member dimension

Confidential

Data Architect Consultant

Responsibilities:

Worked on Various Projects as a Data Architect. Architected, Designed and Implemented Multiple Data Warehouse for Various Clients Such as Eaton Vance Funds Management, Pitney Bowes, Analysis Group, RBS, Barclay’s, Manulife, Teach for America and United Technologies

Confidential, Billerica, MA

Senior Product Architect/Technical Engagement Manager

Responsibilities:

Managed a Team of 9 developers - 3 On-Shore and 6 Off-Shore
Designed Rules for Customer/Company Data Management at Multiple Levels Implemented Through Trillium - Company, Contacts with a company etc.
Used SQL server 2000 as the Database to Host Business Rules Engine

We provide IT Staff Augmentation Services!

Director, Data Architecture Resume

Hartford, CT

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship