Big Data Architect

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, Cloud, Enterprise

-Conceptual, Logical, Physical models design; SQL/ETL development on Primacies, in Cloud, Big data

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

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

-Capital Market, Trade Control/Middle office Credit Suisse; Investment Banking at GS, AML, FRB

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

Analytical & presentation software & experience:

-Erwin, ER/Studio, Power Designer, Catalogs, Oracle, DB2, Azure SQL/DW, Snowflake, Visio, IDQ

-SQL, PL/SQL, T-SQL, SPSS, UNIX/shell, Hive/Hadoop, Exadata, MSRS, Teradata, Data catalogue

-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, Tableau, MongoDB, Talend, Hadoop, SSIS, UNIX, VB, HTML, JSP, PERL, C, XML, MS Office, VISIO, DBeaver, GIT, batch, PVCS, SVN, GitHub, Collibra, Azure, Athena

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

EXPERIENCE:

09/2021 – Present Manpower Group consulting for NY City Enterprise Data Architect, BI Reporting

Conceptual, Logical and Physical data models design; Erwin as the major tool

Data Governance & Standards development, Data Dictionary; REF & Master data

Requirements gathering: System Integration data & process architecture

Data and ETL Architecture for SEO DWH, Mart, Integration and Reporting

Target and Roadmap suggestion development and presentation with Power BI

Data Quality schema and rules enforcement, Best Practices for Analytics and BI

Support current practice, data modeling needs and code review

11/2020 – 09/2021 Honor Vet Tech consulting for Marsh & McLennan (MMC) internal project

Oracle Data Architect for Sales Force integration, reporting in Power BI

08/2020 – 11/2020 Virtusa Inc. for Sirius XM Lead Consultant Data Models / Architecture

Erwin Modeling, Standard, Data Catalog; migration in AWS Teradata/Redshift

02/2020 – 07/2020 AIT Consulting for Swiss RE Data/Cloud Architecture Solution & BI

Azure SQL DW/Lake; Standards; Snowflake, Clover, Data Catalogs (Collibra/Alation)

Requirements, System & Process analysis & resolution; Data Lineage; ER/Studio

Data Architecture, Standards support of Data Governance P&P, Taxonomy, 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; Collibra vs Alation evaluation

Separate Semantic Data layer for user self-service and Catalog Taxonomy map

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

Data Modeling and Pipeline for RDBMS/Hadoop/Hive for Analytics, MDM & OLTP

Integration/Data lineage, Semantic Layer design, Big Data migration, Informatica DQ

(semi-structured data, HQL; review Java/Python; SSIS, Power BI, Collibra, ER/Studio)

03/2018-09/2018: Aggrego Consulting for MetLife, NJ Investments Refactoring Data Architect, Analytics Data Warehouse for Investment and CFO/Managerial reporting. ER/Studio

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 based on common Taxonomy, Semantic layer, Model

Collaborate with other teams to provide flexible but robust solutions.

Semantic level design integration with Enterprise Architecture and Governance.

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

Sr. Data Architect on multiple projects: ER/Studio 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 & modeling for Semantic layer; balance relational & DIM 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, Erwin

Information Architect refactoring Customer/Investment Management App BIM

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

Data Modeling & Data Architecture, Data Lineage control; SSIS review/lineage

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 (Erwin/ Informatica); Data Lineage

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

“Spotfire” BI implementation project on Oracle 11g; Teradata option analysis

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