| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate SUMMARY: Information Architecture, BA, Warehouse Development, BI MS in CS, MBA Data Architecture, Requirements, BA, PM, BIM, MDM, ETL, SQL, Oracle, DB, Big DataMajor 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 productsAnalytical & 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 BISOFTWARE: 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 review11/2020 09/2021 Honor Vet Tech consulting for Marsh & McLennan (MMC) internal project Oracle Data Architect for Sales Force integration, reporting in Power BI08/2020 11/2020 Virtusa Inc. for Sirius XM Lead Consultant Data Models / Architecture Erwin Modeling, Standard, Data Catalog; migration in AWS Teradata/Redshift02/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 map10/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/lineage02/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 data12/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, etc02/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 planning09/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 control03/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 management10/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, NDSMultiple 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 MarketsMy 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-toolsAs 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, NYAccredited BS in Physics and BS in Computer Science, Ukraine, Polytechnic University |
