SUMMARY:

• Information Architecture, BA, Warehouse Development, BI MS in CS, MBA Data Architecture, Requirements, BA, PM, BIM, MDM, ETL, SQL, Oracle, DB, Big Data
• 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 Lineage, Data Profiling, Logical & Physical design
• Capital Market, Trade Control/Middle office Confidential ; Investment Banking at GS, AML, FRB
• Master degree in Computer Science, e - MBA in Finance & Accounting, understand Financial products

TECHNICAL SKILLS:

Analytical & presentation software & experience: Erwin, Embarcadero, Power Designer, Catalogs, Oracle, DB2, Azure SQL/DW, Access, Visio, IDQ, SQL, PL/SQL, T-SQL, SPSS, UNIX/shell, Hive/Hadoop, Exadata, Crystal report, MSRS, Teradata, 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, Java, MS Office, VISIO, DBeaver, GIT, batch, PVCS, SVN, Collabra, Collibra

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

EXPERIENCE:

Confidential

Data/ETL Architect

Responsibilities:

• Requirements, System & Process analysis and resolution; Data Lineage
• 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;
• Separate Semantic Data layer for user self-service and Catalog Taxonomy map

Big Data Architect & Data Modeling

Confidential, NJ

Responsibilities:

• 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.

Confidential

Sr. Data Architect

Responsibilities:

• 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)

Sr. Information Architect

Confidential, New York, NY

Responsibilities:

• 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

Confidential, NJ

Risk Data Warehouse

Responsibilities:

• 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

Confidential, New York, NY

Data Warehousing Sr. Data Architect/BA

Environment: Erwin, Oracle, SQL, DB2, Sybase; UNIX, WINDOWS

Responsibilities:

• 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

Confidential, NY

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

Responsibilities:

• 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, Confidential, 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, Confidential, etc

Confidential

Sr. Data Analyst/BA

Responsibilities:

• 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)

Confidential, NY

Business Intelligence Analyst & Data Modeling/DBA

Responsibilities:

• 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

Confidential

QA/Data Analyst

Responsibilities:

• Designed QA test cases and performed testing for AML and Settlement control
• 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

Confidential

Sr./Pr Consultant

Responsibilities:

• 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)