Consultant

• Oct 2022 - Present

BI Business Analyst / Scrum master

• Oct 2015 - Sep 2022

Main activities and responsibilities: - Requirements gathering and formalization, requirements analysis - Identification and implementation of the new requirements (analysis, design, PM activities) - Detailed analysis of ETL transformations, both from technical and business perspective in order to be able to support the requests for clarification from business users and possible optimization - Overtaking, analysis and documentation of existing DWH solutions and stabilization and optimization of the solution - Formalization of mapping documentation and documentation of existing DWH solution - Document the inner structure of the solution and supporting processes (business dictionary, deployment, etc.) - Continuous improvement of the solution to increase sustainability and provide higher business value and lower effort to maintain for support team - Support of business users, increasing transparency of internal processing to business users and support of migration process of data from one source system to another - Team leading (tasks prioritization, organization of the development and support team) - Communication with stakeholders - Definition of a new efficient test approach (the data validation test scripts (SQLs) preparation, scripts execution and analysis of differences in datasets from test scripts and ETL) - Consolidation of user stories and business requirements in JIRA tool, UI - UAT testing Show less

DWH Senior Engineer / Analyst / Solution engineer

• Sep 2013 - Sep 2015

Main activities and responsibilities: Responsibility for DWH deliveries Analytical and Project Management activities Requirements gathering and formalization, requirements analysis Data availability analysis and data interface definition Communication with suppliers, price negotiation/challenging, coordination of suppliers (team leading) Communication with business requester and owners of relevant IT systems DWH migration Data Governance processes implementation in Telco domain, i.e.: - Role of metadata facilitator – business dictionary administration, preparation of documents for business term definition for data steward, realization of facilitated workshops - Business term – methodology creation and formalization (process proposal, internal regulation edition) - Definition of Data quality rules and checks - Reporting process (part of SDLC) incl. report template design Reference manuals publications (access rights requests, order administrations, order accounting, PWD excel import of report template etc.) Show less

Senior Analyst at Business Intelligence Competence Unit

• Oct 2009 - Aug 2013

Master Data ManagementCovering of users and projects requests for MDM (support in for definitions and formalizations of requirements, requirements analyses, analyses and solving of issues in master data reported by projects, review of functional designs, data mapping, testing, etc.).Analyses of products mappings and Dimensions definition for Product Catalogue in MDM System.Maintenance of Organization Chart in MDM System (incl. data mapping, data mastering of organization units, defining relations between organization units and relations to other entities, etc.).Definition of Use Cases for Organizational Chart workflow in MDM System.Maintenance of Referential Code lists in MDM System (incl. data mapping, creating, changing, deleting master data, defining hierarchies and relations between code list, etc.).Participation in introduction of MDM processes (defining, testing of workflow for Referential Code lists in MDM system, preparation of internal regulation).Definitions of test cases and testing of changes in MDM system (structure of tables in MDM model, structure of tables in model of MDM interface to ODS, relations in model, comparison of data model of MDM and MDM application, validation rules, etc.).Documentation review:- Functional specification and Design for Referential Code lists- Manual for Data maintenance in MDM system- MDM model Meta DataDefinition of calculation of approved business term in business dictionary using code lists in MDM systemMaintenance of Report Catalogue – revisions of report requirements defined by business user, adjustments of descriptions to of approved business terms, defining relations to business terms and data dictionary (metadata of enterprise data warehouse). Data Governance DeliveryIntegration of Meta data management process in area of reporting (proposal of process of report requirement creation and formalization within internal regulation)Support in business formalization of report requirements Show less

Senior Data Analyst at Corporate Business Development & Support Dept.

• Dec 2007 - Sep 2009

Analyses of clients' data in terms of sales support of corporate banking products and services.Data mining – analysis and search for data in order to identify business opportunities.Corporate banking CRM model definition.Analyses of technical possibilities of providing product and cooperate in proposing technical improvements of the systems.Analyses of state and performance of corporate products' portfolio prepare product programs and procedures and cooperate in product portfolio management.Provide guidelines for sales network and prepare sales supporting materials.Analyses of segmentation, payments, deposits, acquired and lost customers.Maintenance of Sales Support Application, euro testing of Sales Support Application and Portfolio management application.Monitoring of corporate business activities.Definition of business requirements for EDW and ODS. Show less

Analyst of Credit Portfolio at Policy & Methodology Dept.

• Jun 2005 - Dec 2007

Reporting – methodology, preparation and automation of reports, implementations of proposals and change requests in structure of regular and ad-hoc reports for a regulator, parent company, bank´s Management Board, and other sub-departments.Maintenance of documentation for regular reports.Reconciliation of reported values with other sub-departments. Checking the quality of data entered and values calculated. Data processing of overdraft product (monitoring of data processing in data warehouse, maintenance of marketing campaigns, methodology modification, business and IT requirements preparation, testing). Show less