Senior ETL & Data warehouse consultant - Intelligence Act - Bucharest
(2018-11)
Contractor role serving multiple customers in complex ETL workflow development and data management.
- BRD Romania (May 2019 - to date): development of complex ETL workflows within various banking projects; data anonymization of multiple environments using PowerCenter Test Data Management (TDM) tool
- UBISOFT (Nov 2018 - May 2019): implementation of various business requests into the company's ETL ecosystem
- Technologies: ETL tools: PowerCenter Informatica suite, PowerCenter Test Data Management (TDM); DB systems: Teradata, Oracle/Exadata, SQL Server, Informix etc; UNIX scripting
Senior BI & Data warehouse consultant - New Business Dimensions
(2017-10 - 2018-10)
Contractor role working with Alpha Bank Romania on major core banking system integration project.
- Major project of integration of the new /upgraded version of core banking system ("FlexCube") with the exiting data warehouse & reporting system
- Conducted tasks implied extensive analysis of the AS-IS / TO-BE artefacts (source tables definitions: new / modified / obsolete as well as remapping / updating of the ETL flows objects - tables, views, functions, procedures, etc.- which were using those source tables)
- Elaborate analysis document (as requested deliverable) –standing also for technical specifications for the development
- Technologies: ORACLE & Microsoft technologies
Managing consultant on Data Warehouse/ Data Marts implementation project - Capgemini Romania - Romania
(2016-10 - 2017-10)
Contractor managing Data Warehouse/Data Marts implementation at ING Bank Romania.
- Elaborate architecture for ETL processing flows as well as for Data Quality processes meant to be integrated with the ETL solution
- Design and development of the local Data Quality system (implementation of technical checks meant to prevent ETL failures due to errors coming from various source systems) integrated with the ETL DataStage flows designed for loading data into various processing layers. Local implementation of DQ components was based on both ORACLE and IBM DataStage technologies.
- Development of other DataStage ETL flows of high complexity – in order to implement the customer requirements (based on technical specifications issued by business / technical analysts)
- Technologies: ETL tools: IBM InfoSphere Information Server suite (containing IBM DataStage Designer / Administrator / Director etc.); DB systems: Oracle/Exadata
Senior BI & Data warehouse consultant - New Business Dimensions (new frontier group)
(2016-01 - 2016-10)
Developed BI reports for banking customers and optimized reporting systems and ETL flows.
- Development of BI reports upon customers (banks) requests based on ORACLE technology
- Optimization of various reports / flows – performance wise
- Major contribution to implementation of a new ING Bank's project (initiated due to a new to EU Comission requirement) - computing of Interchange fees for payments made with electronic cards
- Technologies: Oracle SQL / PL-SQL
ETL Ab Initio developer - IBM - Romania - Romania
(2012-07 - 2015-12)
Developed ETL solutions using AbInitio for banking projects.
- BNP Paribas project (Mar 2015-Dec 2015): Implementation of business requirements issued by the customer within the "AbInitio" projects by development of new AbInitio graphs / modification of existing ones in order to integrate the new requirements / change requests within the BI & data warehouse integration project.
- Technologies: ETL tool "AbInitio"
Team leader / Data specialist – ETL Data Stage & Netezza developer - IBM - Romania - Romania
(2013-12 - 2015-02)
Team lead on major ETL/Netezza project for Alpha Bank Greece, working on-site with international team. Responsible for development of ETL artifacts and served as designated dev team analyst to clarify business specifications.
- Build an ETL DataStage / Netezza ecosystem to integrate all bank's source systems (~16 source systems) in order to load the newly created data warehouse & data marts (project started from zero)
- Development of necessary artefacts (IBM DataStage objects: parallel jobs and sequences, IBM Netezza objects: stored procedures, tables etc.) for assembling the ETL needed mechanism
- Due to extensive previous banking experience as programmer analyst, acted as "designated dev team analyst" to clarify the business specifications, especially in the early stages of the project (even created VBA based code to transpose those specifications layout and to identify the changes – since ~ 100 specs versions were issued in the first year alone)
- Support UAT testing and issues fixing
- Support Production issues fixing
- Assimilate new technologies (IBM DataStage, IBM Netezza) and methodologies (ETL framework – an IBM asset which sets the standard for ETL implementations, IBM Banking Industry Data Model etc.)
- Gain significant experience during implementation of a project having high complexity: best practices, improve the ability to overcome various challenges occurred on the way, expect the unexpected etc.
- Major contribution to the technical solution (from design to development): by developing highly flexible ETL flows and very performant Netezza code, resulting a highly performant solution for loading the bank's data warehouse and one of the bank's data mart (e.g. at some point, due to increased volume of data in some rejection tables, the combined ETL-Netezza solution was able to process ~ 1 billion records in ~ 1 hour – which alone stood as a confirmation of the extremely high processing power
- Set programing standards proven to be highly effective during the solution design
- Code optimization - from the highest level (solution architecture - e.g. implementation of 2 DELTA layers : one source-oriented and the other target-oriented in order to minimize the number of the records being loaded into data warehouse) to the lowest level (objects development - e.g. managed to optimize Netezza stored procedures to compute DELTA – the image containing only modified records - on more than 80 Millions rows coming from source, in less than five minutes, etc.)
- Successfully coordinated the IBM Romania development team to meet the projects milestones by actively participation at project planning meetings, assignation of development tasks (resulted after new requirements analysis) in concordance with each man's experience and coding abilities, organize the UAT and especially PRODUCTION support activity which had to be covered 24/7 on customer site in Pireus, Greece for a period of almost 8 months when data for 2 and a half years up to date had to be proc
Programmer Analyst (BI Team) - Asseco SEE - Romania - Romania
(2012-04 - 2012-06)
Developed and optimized BI reports for banking customers.
- Reports development upon customers (banks) requests, based on ORACLE technology
- Development of various reports (e.g. "Liquidity and repricing", "Customer insolvency", "Blue book" etc)
- Redesign and optimization for some of the existing reports
IT Analyst (BI Team) - BCR Romania, member of ERSTE Group - Romania
(2011-06 - 2012-03)
Analyzed business requirements and oversaw technical solution implementation in BI and data warehouse environments.
- Analysis of business requirements and issuing of technical specifications used in solution development and testing process as well as supervision and providing support along the solution implementation process
- Major contribution to the successfull implementation of IFRS LLP (Loan Loss Provisions) application (SAS platfom) with the data warehouse (Oracle platform) involving the design of data structures along with implementation of an automatic checks mechanism (for data integrity and consistency) as well as integration with the signaling mechanism between source system (SAS) and the different layers of data warehouse
- Major contribution to integration of IFRS provisions into existing monthly reporting system to Vienna
Application Developer / Programmer analyst - Raiffeisen BANK S.A. - Romania
(2003-12 - 2011-05)
Developed applications and reports based on Oracle data warehouse for various banking departments. Analyzed business requirements across different banking zones and integrated various requests into reporting systems.
- Project Office & Solution Development Directorate, Data Management Department
- Applications development based on ORACLE data warehouse in order to provide internal customers with periodical or on-demand reports
- Business analysis on different banking zones (risk, controlling, sales, accounting etc) and applications redesign with the purpose of integration of various requests in the existing reporting system
- Main contribution to important projects such as: Implementation of National Bank reporting data mart; Overdue exposures monitoring project; Implementation of anti money laundering project; Profitability measurement project; Providing maintenance and customization for the existing applications or reports
- Good knowledge of banking business
- Development of a consistent set of applications meant to provide different banking zones with reports regarding: Risk; RAS and IFRS provisioning (for retail and corporate customers); Basel II reporting; Controlling and accounting reporting; Sales etc
- Development of an application for automatic reconciliation of transactions from general ledger (GL) accounts subsystem
- Development of commissioning system applications for sales force
- Development of PL-SQL procedures which implemented the business algorithms used for data extraction from data warehouse in order to supply the needed input
