Cristian Gherghel

Data & Analytics Platform Modernization – Data Architect (Nov 2022 – Present)  Key contributor to the SGI Azure Data & Analytics Platform design and implementation  Planned, sized and coordinated the data architecture and modelling activities  Created Conceptual, Logical, Physical Data Models  Designed Data Flows and created STMs (Source To Target Mapping) documents.  Coordinated (MDM) Master Data Management activities, refence data consolidation / integration. Environment: SAP Power Designer, MS Azure, Synapse Analytics, Azure Data Factory, PowerBI, Microstrategy, Python, Ataccama, GuideWire, SpeedVault, Databricks

‘Credit Risk Data Marts Modernization – AWS Cloud Migration’ Project:  Lead the BSA/TSBI Team assigned to the project  Created detail assessment of the existing data systems and processes  Participated in the planning and effort sizing  Participated in the requirements gathering and documentation (HLRD)  Participated in the AWS services evaluation and Solution Architecture and Design  Created Presentations/Summaries for the T&O and Business Executives Environment:

‘Model Data Repository (MDR)’ Project:  Provided Technical Leadership for this massive data integration project meant to build a highly efficient Risk Model Data Repository  Participated in the business requirements gathering and Detailed Requirements Specifications  Reversed Engineering SAS code  Participated in the detailed planning and coordinate the effort sizing  Responsible for Data Architecture and new Data Flows Design  Led the BSA/TSBI Team to write detailed ETL technical specification documents and ‘source to target’ data mapping, and the reviews/sign-off with the business reps  Provided support for other SDLC activities (DEV, QA, UAT, Production Implementation)

 Participated in the business requirements gathering (HLRD, DRS, CR documents)  Wrote detailed ETL technical specification documents and ‘source to target’ data mapping  Designed new ETL processes and enhanced the existing processes  Participated into Data architecture and Data Modelling activities  Supported the Business Users for the UAT (User Acceptance Testing) and the ‘Parallel Production Run’ activities

 Created Data Models (Conceptual and Logical level), Data Flow and defined the Data Exchange formats for the Business Markets Transformation Strategy Project (BMTS)  Provided guidelines with regards to the impact of the BMTS project on other Enterprise Data Architecture areas  Worked on the integration of the Home and Auto Insurance Party data into the Insurance Common Client (ICC)  Worked with the Business Analysts on the source data analysis  Provided data architecture recommendations and provided support for the source-target mapping definition  Reverse engineered and documented the data models for Travel Insurance and Home and Auto Insurance legacy applications  Worked with the Enterprise Information Planner to prepare presentations and guidelines for different projects and enterprise initiatives as AML (Anti Money Laundering), IDM (Insurance Data Mart) improvements or ICC (Leveraging Insurance Common Client Profile)

 Design and implement a fully automated solution for the CKBD User Area database objects migration into the Re-hosting server  Update ETL processes for the Re-hosting server

 Design the changes of the ETL processes required to accommodate the addition of new data elements into the TREAD-CI Data Mart (Transportation Recall Enhancement Accountability and Documentation – Comprehensive Inquiries)  Update the existing data models

‘Credit Risk and Financial Reporting (KARMA) Data Mart’ Project:  KARMA Project had the goal to consolidate the multiple siloed risk / financial data marts to create the main data source for credit risk analysis and financial reports  Designed and Implemented a fully automated metadata driven data loading process of the Source System data into the Staging Area  Created the data model for the metadata control tables and temporary tables required by the ETL processes  Designed and developed various Data Transformation processes using Informatica and UNIX (AIX) shell scripting  Tuned the performance of Informatica mappings and SQL queries

‘Data Quality Pilot’ Project:  Evaluated Data Quality and Analysis software (Informatica IDQ and IDE)  Created an IDQ process prototype including Data Quality Dashboards  Presented various data quality aspects and solutions and how they could be integrated into the existing ETL processes to the Deutsche Bank Executives

‘Insight’, ‘CVM’, ‘Harris Basel DM’ Projects:  “Insight” Financial project is designed to deliver a new multi-dimensional profitability measurement and reporting solution  “CVM” Customer Value Management project is designed to refine data, adding new models and analytical capabilities, as well as new tools for sales and service staff  “Harris Basel Retail” as part of the implementation of BASELII (New Basel Capital Accord)  Designed and implemented various ETL processes using AbInitio on UNIX (AIX) platform and DB2 database  Developed and integrated generic parameterized AbInitio graphs (templates) for different ETL functions like Surrogate Keys assignment, Error Event handling, Slowly Changing Dimension processing  Developed Perl and KSH scripts for data parsing, reconciliation, archive/cleanup utility and process sequence control  Implemented C table functions in DB2 to support direct SQL queries of the AbInitio mfiles  Wrote code documentation and provide technical support for the Business Analyst team  Contributed to the successful implementation and maintenance of the following three largest data warehouse projects of the bank

Data File Management Application:  Designed, developed, and documented a Data File Management Application using Oracle9i Database Server, Oracle Developer 6i and Twain32 driver  Installed, configured Oracle9i Database Server and Ricoh IS450 SCSI scanner  Developed the application interface with Oracle Forms 6i, integrated with batch scanning, image conversion and resizing functions  Created powerful reports using Oracle Reports6i, that allow users to display, print, save or e-mail the stored documents in a wide range of formats (HTML, PDF, RTF, EPS, XML)  Designed the application security, developed backup, recovery procedures and document statistics