Solution Architect | Developer | Data engineer| Business Analyst

Development of the regulatory Bail-in resolution tool for recapitalizing a failing bank 
- Defining the implementation roadmap for the cross-functional project to integrate multiple data sources and build the solution ready to report within 24 hours all the bank liabilities with a 24 hours timeliness  
- Requirements analysis, solution design, and solution implementation in an Agile setup
- Infrastructure setup: Database, ODI, repository, CI/CD pipelines
- Database development: data model design, stored procedure development
- ODI ETL jobs design and development
- Conducting dry runs in collaboration with the regulating entity and other stakeholders.




Implementing regulatory Valuation tool to be used by independent valuators for assesing a  failing bank
- Defining the roadmap for the cross-functional project to integrate multiple data sources 
- Requirements analysis, solution design, and solution implementation in an Agile setup
- Database development: data model design, stored procedure development

Skills:  Data architecture · Requirements Engineering · Database design · Database development · Extract, transform, load (ETL) · Datawarehouse · ODI · Teradata · Agile

New JIRA data reporting service with custom reporting capabilities, enabling users to access and analyze data from over 2500 projects and 2 million+ objects.

- Explore Business Intelligence (BI) and data analysis tools to identify the most appropriate options for the project
- Designed and developed the technical solution from scratch, including infrastructure creation, Data Warehousing (DWH) model from landing zone to semantic layer, ETL, Azure cloud and PowerBI reporting.
- Infrastructure setup: DB, FTPs, Azure, PowerBI
- Database development: data model design, stored procedure development
- ETL implementation using SAP Data Services
- Azure solution configuration
- PowerBI report development

Skills:  Data architecture · Requirements Engineering · Database design · Database development · Extract, transform, load (ETL) · Business Intelligence Azure Cloud · Azure Synapse Analytics · PL/SQL · SQL · Oracle · PostgreSQL · SAP Data Services · PowerBI

---

Enhanced reporting capabilities on the Commission's budgeting tool: Multi Annual Panning
- Partnered with business stakeholders to understand their BI needs and define and deliver metrics that align with their strategic priorities.
- Collected and challenged business requirements for designated areas. Understand and translate business needs into technical specifications
- Technical solution development, database development, ETL development in SAP Dataservices and report development using SAP Business Objects
- Migrated the reporting offering from SAP Business Objects to Qliksense

Skills: Data Architecture · Requirements Engineering · Database Design Database Development · Extras, Transform, Load (ETL) · Business Intelligence · PL/SQL · SQL Database · Oracle · SAP Data Services · Qliksense

- Part of the agile delivery team implementing a new group-wide on-premise data warehouse for Erste Bank Group, involved in all major phases of the project: data generation, core DWH and downstream solution layer creation
- ODI ETL development
- Developed automated testing tools and reports in PL/SQL and Python, including metadata-driven checks on the Group DWH, model change impact, data migration, testing coverage and test case parsers for automatic execution.
- Conducted testing of the main functional areas of the Group DWH, which included local entities and group data integration, surrogation of keys, historization of data, Business Rules engine, business calculations, data exposure to downstream solutions and business keys migration.
- Led a team of 4 to identify potential DWH model gaps through Completeness tests on approximately 3000 tables and 5000 data items.


Skills:   Data architecture · Requirements engineering· Database design · Database development · Extract, transform, load (ETL) · Business Intelligence · Data Vault IBM Banking Data Warehouse ( BDW) · PL/SQL · SQL · Oracle · Python · Power Designer · Jira · Automated testing · Metadata-driven testing · Agile