← Back to list
senior
Registration: 08.08.2022

Oleg Karabet

Portfolio

Tata Consultancy Services

Senior Consultant. Information Architect

Bank of America, Strategy Support Group Charlotte, NC

VP, Solution Architect

Wells Fargo Bank Diversified Products Group, San Francisco, CA

Lead BI Architect

Skills

AIX
C
Greenplum
HP-UX
IBM DB2 UDB
Linux
Oracle
Perl
PL/SQL
PostgreSQL
Python
SQL Server
Sun Solaris
Teradata
T-SQL
Windows

Work experience

Senior Consultant. Information Architect
12.2011 - 06.2022 |Tata Consultancy Services
Summary: Based on analysis of business directions, processes, system dependencies and data flows create enterprise data transformations strategies and roadmaps, conceptual bases and technical implementation plans for Data Integration and Business Intelligence projects. Lead data modeling and MDM efforts for various engagements at financial, retail, manufacturing and health science institutions. Manage on- and offshore execution team technical efforts. Main Projects: • R&D Data Modeling implementations at GSK • Enterprise Logical Data Model at Walmart • Data Lake Customer and Event Data Integration at Walmart • Enterprise Integration Layer design and implementation at JPMorgan Chase • Customer Data Mart Integration and Semantic layer design at JPMorgan Chase • Credit Card Data Mart Integration Layer design at JPMorgan Chase • Enterprise Data Warehouse and Business Intelligence Strategy at First Niagara • Data Intake Framework Implementation at Moody’s • Domain Blueprint and Data Implementation Strategy at Bank of America • Wholesale Credit Canonical Data Model Foundation at Bank of America • Data Lake Design and implementation at Walmart • Digital Transformation Strategy and Implementation at ADM Achievements: • Created and implemented Data Modeling Framework - set of the best practices for the logical and physical data modeling, including key implementation, indexing, partition and compression strategy, ETL development efforts • Designed Customer subject area for Walmart Enterprise Data Lake • Created conceptual, logical and physical data models for 2 cornerstone parts of the JPMorgan Chase Enterprise Data Warehouse using agile project methodology • Analyzed existing team and technical environments and created strategy for the data warehouse and business intelligence domain advance at First Niagara Bank Corp. • Analyzed existing business requirements, engage stakeholders, development and architecture teams, created functional and non-functional requirements
VP, Solution Architect
12.2008 - 12.2011 |Bank of America, Strategy Support Group Charlotte, NC
Summary: Analyzed bank collection management systems, gather requirements, planned data warehouse and data marts implementations using Inmon and Star Schema concepts. Created development strategy, design and code Loss Mitigation Data mart for Home Equity line of business, supporting “Make Home Affordable” program. Lead database design of IBM Banking Data Warehouse model for an Event subject area in the line of business environment. Tune SQL stored procedures. Design and produce reports using SQL Server BI Studio (SSRS). Actively participated in data federation project. Defined procedures for the data processing, ensuring compliance with main data governance drivers Main Projects: • Loss Mitigation data mart • Reporting systems for the “Make Home Affordable” program • IBM BDW design for Events Subject Area • Use Data Federation tool for reporting
Lead BI Architect
08.2002 - 07.2008 |Wells Fargo Bank Diversified Products Group, San Francisco, CA
Summary: Created BI solutions using Business Objects, OBIEE, Cognos and SQL Server BI Studio. Pioneered introduction of data governance into business cycle through analysis and implementation of changes in data-related business processes to improve work efficiency, cut costs and optimize data flows for sales, underwriting, and retention teams. Acted as a project manager assigning and keeping track of the projects in the team Main Projects: • Sales, Risk, Marketing and Retention Data Marts • Creating comprehensive view of the organization (canned reports, dashboards, OLAP, BO universes, ad-hoc environments) • Optimization of sales team productivity based on application cycle time analysis. • Marketing campaigns setup and analysis. • Portfolio segmentation and correlation analysis of credit risks • Setting data transfers between bank divisions to promote cross-sell • Improving customer experience through application status notifications (XML/WML messaging solutions) • Customer relationship analysis for retention business Achievements: • Developed conceptual bases, designed and coded various subject areas of Group data warehouses and marts, customized for monthly, weekly and daily reporting to help manage more than $80 bln. portfolio business • Designed and participated in development of Business Object Universes • Participated in creation of XML-based bank referral system • Created XML and WML based reporting solutions delivering daily reports to company sales force • Analyze main acquisition and retention metrics to rationalize work flows and increase customer board ratios as well as sales team productivity.
Senior Database Developer
06.1999 - 07.2002 |Wells Fargo Bank, Auto Finance Group, Walnut Creek, CA
Summary: Worked as a team lead data architect in a database support group. As a part of a larger team created group data warehouse. Created database solution enabled used cars sales over the Internet. Tuned queries and databases for optimal performance. Conducted batch management to feed and send data between several bank systems using Oracle packages and UNIX scripts Main Projects: • Auto Finance Group Data Warehouse • Used cars sales over the Internet • 7x24 Database support of Auto Customer Service Application • Auto Dealers performance reporting • Inter and Intra-bank data transfers • Performed Object Oriented Design, create class code and interface functions using SQL/Windows suite of tools for Auto Customer Service Application Achievements: • Conducted physical database design activities for Auto Finance Group data warehouse • Created database solution allowing to implement used cars sales over the Internet with more than $275,000 in annual revenue • 7x24 Database support of Auto Customer Service Application
Programmer/Analyst
02.1997 - 05.1999 |Chevron Corporation, San Francisco, CA
Summary: Participated in creation the Vessel Supplies Database Management system. Conducted logical and physical database design. Created SQL Scripts and stored procedures for an application back-end. Developed and coded user interfaces and reports using Oracle Developer/2000 Suite of tools. Performed end-user database support Main Projects: • Vessel Supply Chain database management system based on Oracle Developer/2000 in-house application • 7x24 Database support
Research Fellow
05.1987 - 04.1996 |Dnepropetrovsk Metallurgical Institute, Dnepropetrovsk, USSR/Ukraine
Summary: • Studied mechanisms of hot deformation, created and implemented new technology of cooling for hot rolled wire • As a part of the team participated in various research activities for hot and cold rolled wire • Along with group of colleagues created 2 patents for thermo-mechanical treatment of hot and cold rolled steel

Educational background

Course Study in Data Mining
Till 2002
Golden Gate University, San Francisco
Course Study in Oracle Data Warehousing
Till 1995
University of California at Berkeley
MS in Physical Metallurgy
Till 1986
Dnepropetrovsk Metallurgical Institute

Languages

EnglishProficient