Vice President, Lead Data Architect Resume
New York, NY
SUMMARY:
Driven, results - oriented, IT professional with strong business analysis and business re-engineering focus in the state of the art technical environment in the financial services industry. Demonstrated skills in Project Life Cycle Methodologies, Data Governance, Metadata Management, Master Data Management, Information Systems Security, and Data Base Architecture. Excellent analytical and technical skills.
AREAS OF EXPERTISE:
- Business Analysis
- Data Base Administration
- Data Governance Policies and Standards
- Relational Data Modeling
- Enterprise Master Data Management
- Service Oriented Architecture
- Dimensional Data Modeling
- Enterprise Data Warehouse
- Project Management Office
- Metadata Management
- Target Operating Model
- Data Base Design
- Machine Learning
- Data Quality Standards
SOFTWARE:
- Confidential Data Modeler Workgroup Edition
- Informatica Meta Data Manager
- Semarchy xDM
- Python
- Hadoop
- TensorFlow
- Tableau
- Swift/Xcode
- Java
- Oracle Data Modeler
- Oracle SQL Developer
- Oracle SQL Advisor
- DB2
- SQL Server
- ER/Studio
- Informatica Power Center
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Vice President, Lead Data Architect
Responsibilities:
- Leadership Role in Business Requirements Analysis, Data Quality Analysis, PMO, Data Modeling, and Data Base Design.
- Leadership Role in Design and Implementation of Counterparty EDW
- Leadership Role in Design and Implementation of Confidential for Data Quality Rules Violations
- Leadership Role in Design and Implementation of Customized OFSAA Data Model
- Leadership Role in Customization of Moody’s Risk Authority/Analytics Model
- Designed and implemented Data Model for Canadian Regulatory Reporting
Confidential, New York, NY
Technical Advisor
Responsibilities:
- Business Requirements Gathering and Analysis, Data Modeling, Software Design, Software Development, Data Base Design and Data Base Administration.
- Responsible for creation logical and physical models using Confidential and ER/Studio data modeling tools.
- Responsible for integration of CMMI with the Risk Assessment methodologies.
- Conduct and perform analytical studies of data content and create data quality Tableau dashboards.
Confidential, New York, NY
Data Architect
Responsibilities:
- Performed data profiling and analysis using SQL Server Integration Services.
- Created logical and physical models for Enterprise Data Warehouse using ER/Studio.
- Determined root cause for data quality errors and made recommendations for solutions.
- Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation using Informatica.
- Designed OLAP cubes using SQL Server Analysis Services.
- Developed data governance framework, clearly identifying roles and responsibilities of technology and business teams.
- Served as central 'source of truth' for data definitions at data element and entity levels.
- Hands on experience of using various analytical, development, business intelligence, and performance assessment tools for effective review of estimates and risk.
Sr Business Analyst/Data Modeler
Confidential
Responsibilities:
- Led a major effort to assess the existing trading applications and provided re-engineering recommendations. Collaborated with business managers and applications teams in re-design and re-engineering of existing Broker-Dealer applications including business requirements gathering and analysis.
- Collaborated with business managers and application teams to architect, design, and develop logical and physical data models.
- Captured, documented and maintained Metadata.
- Served as primary liaison between application development teams and other organizational units to ensure timely flow of accurate information.
- Re-engineered and migrated a major trading system from Confidential to DB2
- Participated in Strategic Planning, Enterprise Data Architecture Standards Development, and evaluation of new Data Base Technologies.
- Researched and recommended CASE Tools.
- Re-engineered and migrated Confidential system from Confidential to DB2
- Designed, launched and maintained DB2 Department’s Website.