Data Life Insurance

Igor Royzengurt Staten Island, NY ***** 718-***-**** ****.**********@*****.***

Labor Category: IT Years of Experience: 20+

Experience Summary. 20+ years experience with Enterprise Architecture, Data Governance, MDM, Reference Data, Data Modeling, Performance Management Architecture and Performance Tuning, Database Administration.

EDUCATION/TECHNICAL SKILLS

Education:

M.S. St.Petersburg State University, Electromechanical Engineering 1985

Relevant Technical Skills:

Troux

ERwin/ER Studio/Safyr

Informatica - IPC, ICS, EDC, AXON

DB2 DBA

JIRA, Confluence

Collibra

TIBCO EBX

Mulesoft Anypoint, Dell Boomi

Guardium

ASG Rochade

ServiceNow

IBM Infosphere

Clearance:

Public Trust

Relevant Experience:

Federal Credit Union – Philadelphia, PA

May 2019-Current, Data Governance Architect

Implementation of Data Governance for CCPA.

Write Enterprise policies, standards, principles.

Proof of Concept for Data Catalog.

Define policies/workflows for quality, retention, metadata.

Design Data Registration process.

Define KDE's.

On-board KDE's to Tibco EBX.

Regulation/audit/control requirements according to CCPA.

Map Source System using ERwin Data Mapping.

Set strategic roadmap for Data Governance.

Data classification/tagging.

Create/monitor controls and procedures.

Implement SLA/OLA lifecycle using ServiceNow.

Design KPIs, monitoring, escalation, remediation.

Implement Data Lineage with ASG Rochade.

Design Nomination and Assessment of Authoritative Data Sources.

Participate in ABC framework for Data Lake.

Draft data lineage documentation - framework, guidance, BRD.

Created data lineage business to technical mapping.

Data lineage justificitation for C level - BTB and RTB.

Implement Data Catalog with Informatica EDC.

Setup AXON workflows.

Integrate AXON with EDC.

MUFG – Jersey City, NJ

Sept 2018-May 2019, Data Governance Architect

Implementation of Data Governance as part of digital transformation.

Define Roles and Responsibilities.

Update Enterprise Metadata Repository.

Test Collibra/MuleSoft integration for Data Governance workflows.

Define KDE.

Update Enterprise Portfolio Management Services with Troux.

Support Informatica - IPC, ICS.

Develop business glossary.

Regulation/audit/control requirements according to GLBA/BCBS 239, CCPA.

Develop NPI protection procedures.

Implement data lineage with change management solution.

Develop KPI/KRI.

Implement auditing processes.

Write DG policies/standards/principles - retention, archival, privacy, quality etc.

Define procedures for policies enforcement.

Implement DMBOK data management framework.

Implement Data Quality Controls.

Reference/Master Data management.

Centers for Medicaid and Medicare Services – Baltimore, MD

Apr 2014-July 2018, Enterprise/Data Governance Architect

Implementation of Data Governance.

Define Business Glossary.

Implement Data Analytics for Fraud Prevention.

Update Enterprise Metadata Repository.

Test Collibra/MuleSoft integration for Data Governance workflows.

Define Standard Enterprise Elements.

Update Enterprise Portfolio Management Services with Troux.

Develop employee awareness of the DG program.

Support Informatica Power Center.

Develop business glossary.

Develop expert system for knowledge transfer.

Guidance and assistance to enterprise departments for DG implementation.

Regulation/audit/control requirements according to FISMA/HIPAA.

Run BI processing with Tableau.

PoC for Collibra.

Implement data lineage with change management solution.

Morgan Stanley - New York, NY

2013 – 2014, Database Architect.

Implementation of Data Integration – Federation/Replication/ETL implementation.

Investigate Data Analytics capabilities enhancements to optimize Compute Services Platform and deliver the full benefits of Cloud Computing.

Design data integration process from DB2/z to SQL Server/Teradata.

Regulation requirements according to CCAR.

Prudential – Roseland, NJ

2012 – 2013, Data Governance Architect/DBA

Migration of disability claims management from Sybase to UDB.

Create logical/physical models.

Setup processes monitoring.

Combine OLTP and DSS reporting into Enterprise Data Warehouse.

Implement XML shredding.

Optimize ETL processes.

PoC for Splunk.

Informatica Power Center.

Bank Of America Merrill Lynch - Jersey City/Hopewell, NJ

2010 - 2011, Solution Architect/Data Modeler

Maintenance/redesign/modeling of regulatory, broker-dealer application,

migration of US Trust customers into Merrill Lynch cash management accounts,

Risk Liquidity hierarchical remapping, BofA credit cards processing.

Design conceptual/logical data models.

Identify and document upstream/downstream feeds, fields, mapping.

Reverse engineered databases into ERWIN Data Model for tuning and optimization purposes.

Transform logical models to dimensional star/snowflake schemas and de-normalize selectivity to generate an optimally partitioned physical model and its associated DDL.

Create ETL mapping documents between source systems and the target data warehouse.

Work on design issues with Security Master.

Implement Reference Data framework.

Barclays Capital - Jersey City, NJ

2009 - 2010 Solution Architect, DBA

Lehman Brothers wind-down.

Support data warehouse to keep track of daily and monthly P&L volatility.

Move data from UDB/DB2/Sybase/Oracle to MS SQLServer.

Liaise with Lehman’s subsidiaries to ensure accuracy and timely development to meet Court’s specifications.

Write reports for senior management.

Evaluate and set procedures in compliance with audit requirements.

Optimize/automate ETL workflow with Informatica.

Perform Risk Assessment using various “what if” scenarios.

Deutsche Bank - Jersey City, NJ

1998 - 2009 Database Architect

Enforce Deutsche Bank Corporate Finance online (internet and client/server) application to meet performance requirements, performance evaluation, testing and tuning. Maintain and migrate Deutsche Bank Commercial Loans applications

Evaluate the long running transactions/SQLs/SPs that cannot meet DB requirement.

Identify the root cause for the long running transactions.

Provide suggestion to improve database performance by optimizing ETL work flow, tuning load process, batch process, new tables, indices and materialized views.

Infrastructure implementation for 3-tier LoanIQ application.

Migrate legacy data to AIX.

Perform Vendor Management.

Participate in logical and physical design of commercial loan applications.

Supervise and train onsite and offshore team.

Design logical and physical data warehouse, operational data store and data mart dimensional databases.

Evaluate logical and physical database design.

Evaluate all database configurations, shared/private memory usage.

Set up HADR servers

Evaluate and set archival procedures in compliance with audit requirements

Write, test and participate in DR Exercises.

Participate in successful disaster recovery after September 11.

Conduct Capacity Planning.

Design and maintain security aspects of databases.

Design and implement DB2 security procedures using RC/Secure.

Prudential - Roseland, NJ

Database Architect

Maintenance and upgrade of individual life insurance database.

Provide 24/7 Production support.

Develop Change Management Procedures.

Perform tuning and monitoring.

Implement replication process.

Provide DB2 and Platinum training to technical personnel.

Implement replication process.

Federal Reserve Bank - New York, NY

DBA

Support Bank Supervision unit.

Create RC/Migrator models and strategies.

Create database documentation - Data Dictionary, Data Flow diagrams, end user manuals.

Provide Platinum RC/Migrator training.

Implement production implementations backout procedures.

Participate in developing checkpoint/restart, backup and recovery DB2 standards.

AT&T - Somerset, NJ

DBA

System integration for consumers billing for long distance, credit cards, cellular phones and Internet based on IMS, DB2 and Teradata databases.

Resolve outage issues.

Involve in capacity planning for DB2 applications.

Design databases using ERWIN.

Participate in VLDB project.

Reverse engineer existing databases.

Design/support risk management system on Teradata.

Contact this candidate