SUMMARY: Information Architecture, BA, Warehouse Development, BI MS in CS, MBA

Data Architecture, Requirements, BA, PM, BIM, MDM, ETL, SQL, Oracle, DB, Big Data

Major relevant qualifications

-Data Warehouse Architect, Data Strategy & Governance, BI, MDM, Big Data, SOA, Enterprise, MDM

-Legacy migration, Project Management, Data & Business Analysis, Requirements gathering, QA, LE

-Taxonomy, QA, ETL & Data Pipeline, Data Profiling, settlement reporting, Logical & Physical design

-Credit Suisse Trade Control/Middle office/DW; Investment Banking at Goldman Sachs, AML, FRB

-Master degree in Computer Science, e-MBA in Finance & Accounting, understand Financial products

Analytical & presentation software & experience:

-Erwin, Embarcadero, Power Designer, Catalogs, Oracle, DB2, Azure SQL/DW, Access, Visio, IDQ

-SQL, SQL Loader, PL/SQL, T-SQL, SPSS, UNIX/shell, Hive/Hadoop, Exadata, Crystal report, MSRS

-Excel, Analytics, Spotfire, Toad, Informatica, MDM, Tableau, TOGAF, Casandra, AWS, Power BI

SOFTWARE: Oracle, DB2/UDB, SQL,Sybase, Informatica, Erwin, ER Studio, IDA, Power Designer, T/PL/SQL, Tableau, MongoDB, Talend, Hadoop, SSIS, UNIX, VB, HTML, JSP, PERL, C, XML, Java, MS Office, VISIO, DBeaver, GIT, batch, PVCS, SVN, Collabra

Environment: SVN, CVS and GIT; JIRA, Confluence; DevOps BP; UNIX, Windows, Hive/Hadoop

EXPERIENCE:

02/2020 – Present AIT Consulting for Swiss RE Data/ETL Architecture Solution & Analysis

Azure SQL DW/Lake; Data Management Standards; Data Catalogs (Collibra/Alation)

Requirements, System & Process analysis and resolution;

Data Architecture, Standards in support of Data Governance P&P, IDQ and DD

Data Visualization and Row-Level Security architecture and solution; ETL issues

Cloud data consistency and performance issues analysis (NoSQL/MongoDB)

Data Catalogue recommendation based on analysis of ETL Mapping needs and functionality needed for Data Governance oversite and troubleshooting

10/2018 – 11/2019 Big Data Architect & Data Modeling Data Architect consulting, Geisinger

Data Modeling and Pipeline for RDBMS/Hadoop/Hive environment for Analytics

Integration Layer Architecture, migration into Big Data; data lineage, Informatica DQ

(semi/unstructured data, use mostly HQL; understanding of Java / Python helps)

03/2018-09/2018: MetLife, NJ Investments Refactoring Data Architect, AggregoConsulting Analytics Data Warehouse for Investment trades and CFO/Managerial reporting.

Make design choices on Database, ETL Critical Path, Micro services over SOA

Data Modeling and Data Profiling for Insurance Investment, Hedging activities, GL & Accounting, GAAP / STAT /NAIC reporting, plan & projection analytics.

Legacy systems integration, utilize SQL, scripting, Erwin, Databases, Excel.

Collaborate with other teams to provide flexible but robust solutions.

Account for integration with Enterprise Architecture and Big Data.

09/2016 – 01/2018 Federal Reserve Bank of NY, Statistics &Markets Sr. Data Architect, consultant

Sr. Data Architect on multiple projects Oracle,SQL, MongoDB Hadoop

, Data Modeling & Data Management solutions (BIM, ETL, data structures, QA)

Data Architect for LEI MDM (Legal Entities, financials); FR2420 and REPO

Data Governance (Quality, Standards, Footprints, Lineage, Accessibility, Retention)

Data standards & policies development; balance relational & dimensional design

Suggested beneficial use-cases for Big Data integration pipeline (for business)

10/2015 – 08/2016 Sr. Information Architect, New York, NY TRS, consultant ExecuSearch

DW, 3NF design, AWS Cloud, Taxonomy Oracle, Sybase, MS SQL, Azure

Information Architect refactoring Customer/Investment Management App BIM

Data Governance and DA for legacy Mainframe system; Power BI evaluation

Data Modeling & Data Architecture

02/2015 – 09/2015 Consulting for TD Bank, NJ USA Risk Data Warehouse

Data Architecture: Kimball / Inman, standards (Credit, BA, etc.); market risks

Data Warehouse for Transaction control (hybrid, Oracle, DB2/IDA)

Oracle Exadata – Data Models recommendations for solid Big Data platform

12/2013 – 2/2015 Consulting for Guardian Life, New York, NY Data Warehousing

Sr. Data Architect/BA (Erwin, Oracle, SQL, DB2, Sybase; UNIX, WINDOWS)

Data Architect for Subject Area in 3NF & Data Mart: concept, logical, physical

Compensation/Customer/Investment Management: BIM, Data profiling, ETL

Muster Data Standards, QA/ETL design Data Governance in Distribution IT

Review Hadoop/AWS solutions for Data Warehouses with unstructured data

12/11 – 12/2013 Consulting for Credit Suisse, NY, for CFO & PC IT group; Oracle, DB2, MS SQL

Data Architect / Data & Business Analysis Erwin, Informatica, SQL

Data Flow & Architecture, BRD, Requirements negotiation, Standards and Data Model for DW Kimball Refactoring and QA project (Erwin/ Informatica)

Taxonomy; Refactoring Data model Capital markets, Loans, TRS, Equities, swaps (trading, reconciliation & portfolio control at CFO Product Control);

Dimensional Models, 3NF; Business Analysis for FOBO, ODS; OLTP Trade

Date Governance (set Standards & Process); BIM, OBIEE middle-layer model

Front-to-Back Office data flow integrity control for trade intraday adjustments;

Integrated Variety of financial products: Equity, Swap, Fixed Income, TRS, etc

02/11 – 11/11 Morgan Stanley Sr. Data Analyst/BA, SME for Legal and Compliance Data Team

Information Architecture, BA, Data Modeling &Profiling,DB2, Sybase; Erwin

Data Architecture and Data Modeling Standards: Kimball, design & maintain

Tech Lead for PWM (Wealth Management) platforms integration project

Project planning, Requirements negotiation & review, Functional Specification

Data Flow design for AML & Capital Market accounts, Informatica ETL maps

Integration of Institutional and Retail systems at OLTP ( fast transactions)

11/10 – 02/11 Consulting for FRB NY; Business Intelligence Analyst & Data Modeling/DBA

Big Data “Spotfire” BI implementation project on Oracle 11g

Wide spectrum of BI implementation activities (all in RUP/Agile), such as:

-Reference data (MDM) and Repository databases; specific QA tests

-Adjusted Database / BI policies and standards; rollout planning

09/10 – 11/10 ESPUSA, Consulting assignment at Barclays Capital (Compliance, QA/Data Analyst)

QA plan, Integrity, 3NF (Kimball) & Data Marts; Informatica/Actimize/DB2

Designed QA test cases and performed testing for AML and Settlement control

03/08 – 06/10 Carver Federal Savings Bank, NY; DW Development, DW/BI Sr. Data Analyst

Data Architecture, Data Warehouse planning, Data Governance; AML setup

QA policies, MDM, Data Standards, ETL development (SQL, PLSQL, T-SQL, ETL ) for reporting, statistical analysis and other Data Warehouse needs; BIM

BI tools evaluation and selection per business needs, changing strategy and budget limitations (Cognos, Microstrategy, Oracle 11g and 10g, Teradata)

Development, Analysis & data mining in Oracle 11g and MS SQL databases

Financial reporting with SQL tools, ETL /PLSQL processes, AS, MSRS, etc.

Database planning for growth and performance; physical and logical design

Cross-functional Business Requirements gathering and Analysis; RUP/Agile

Batch scripting, job scheduling, SQL Loader, automation of file management

10/06 - 03/08 Keane Inc., employee, Sr./Pr Consultant assignment at Goldman Sachs, NY;

GS Investment Banking Division: IBD Reporting and Data Warehousing

DW (Kimball & Inmon) Migration Project Management (worldwide locations)

Technical Lead, Data Modeling, implementation plan and back-step strategy

Stored procedure development, adjustment and validation per database changes

Planning IBD DW changes in code & database objects for multiple world-wide teams of developers, business users, DBAs, Data Owners and Reporting teams

Reports Data & Process analysis; SQL, PLSQL, T-SQL development & tuning

Database objects Development, Data Analysis & Architecture: Crystal Reports, MS SQL, Oracle 10g/9, Cubes (AS), SQL/PLSQL, DTS, SSIS, Erwin, etc.

Master Data Management/Architecture, Data Flow design; ETL performance

Variety of applications (Capital Markets, Investment Management, Portfolios)

07/03 - 07/06 Novantas, NY; acquired the Performance Metrics, Old Greenwich, CT (employee)

12/05–07/06 Responsibilities at Novantas: DBA, Data Warehousing, processing, Data Analysis

Data Warehouse design, ETL/SQL / PLSQL & performance tuning Ora 11g/10

Modeling (Kimball & Inmon), QA design; specifications, Business Analysis

Requirements gathering, R-analysis; Dimensional Models; DW/Power Center

Process Development for new data mining models and financial / stat analysis

07/03–11/05 Performance Metrics: DBA, Data Warehouse development, Business Analyst

Software: Erwin, Unix shell, Oracle 9i/10g, PL/SQL Developer, MS Office, Visio, VB

Financial Information services for Banking and Insurance. My responsibilities include:

BA, Data Warehouse & applications design (logical, physical, business model)

Data and Business Model Analysis, development and conversion for DM&DW

BA, set Data Standards & Governance, QA design for entire PLC; R-analysis

Stored procedures development (PLSQL), SQL Loader and shell scripting

Estimation of the workload, timelines, preparation of Model diagrams, reports

DBA responsibilities: database creation, copying, backup, tuning, recovery, etc

03/98–12/02 JP Morgan Chase & Co., New York, NY (employee)

06/00-12/02 Position : Senior Technical Officer Small Business; Retail & Middle Market

03/98–06/00 Position : Technical Officer Retail & Middle Market Financial Services

Software: Oracle 7.3/8i, Erwin, OEM, Cognos Cubes & Power Play, Impromptu, VB, HTML, JSP, Java Beans, Java, Load Runner, Hummingbird, Sun Packaging, Unix shell, PL/SQL, Windows batch scripts, IBM job scheduling, NDS

Multiple projects in customer relations, Data Warehousing, Web and Mainframe:

ID (Integrated Database) Customer MIP (Marketing Information & Processing)

CVM (Value Management) IDE (Intranet Decision Engine), Capita Markets

My responsibilities included development of 1-Terabyte Data Warehouse with few Data Marts; Kimball approach, multiple data feeds including Mainframe, Web, Access, SQL server, and applications: Web, VB applications, Cognos, SAS (SQL), SQL-tools

As the team lead I implemented 80% cost reduction using a Uniform data processing in databases and in OS, reduced development time from few weeks to days; QA - by 30%. My responsibilities included logical and physical design, GUI and Web development:

Data Analysis, Data Modeling, Integration and Unification of data processing

Development of specifications, requirements and production documents

Oracle database Logical and Physical design, DBA functions and reporting

Evaluation of Web-enabling and data mining tools, Web-site development.

Application development with Visual Basic, performance Tuning for Cognos

EDUCATION:

2004 MBA degree with Honors (Finance & Accounting, external), Regis University, Tampa, FL

2002 JPM Chase Training: Project Management, Warehouse, JB, Web, Oracle/UNIX Admin

1997 MS degree in Computer Science, NYU Tandon School of Engineering, NY

Accredited BS in Physics and BS in Computer Science, Ukraine, Polytechnic University

Contact this candidate