Octavian Golea
Data Engineer
Erfahrungen
Apr. 2024 - Aug. 2024
5 Monaten Zürich, Switzerland
Technical Analyst
Cembra Money Bank
- Analyzing STMs - source to target mappings and provide best implementation path for change in the Entity relationship data model.
- Identifying gaps in the Entity Relationship data model and mapping new entities, attributes and relationships.
- Reaching stakeholders to clarify business requirements and establish common ground in delivering suited reports.
- Supporting in building comprehensive visualization in SAP BO Business Intelligence.
- Analyzing ETL workflows in Informatica PowerCenter.
- Analyzing time frames for possibility of providing requested information.
- Analyzing the structure for newly requested reports over core or data mart data layers.
- Providing guidance in implementation of changes over the data model by writing SQL queries to retrieve data samples.
- Understanding reporting needs coming from business and translating it in technical requirements.
Feb. 2021 - März 2024
3 Jahren 2 Monaten Austria
Teradata Developer
Unicredit Services Gmbh
- Business meetings for better understanding the business area.
- Technical Analysis: Unix Files, Sources, Access rights, Dependencies, Delivery Time etc.
- Building STM technical mappings upon Business Data Elements description.
- Identifying gaps in the dimensional data model and mapping new dimensional attributes, bridge tables, dimensions and fac tables.
- Implementing data base structures via SQL/BTEQ (tables, views, metadata, surrogate keys)
- Deploying and testing SQL(BTEQ) scripts
- Conducting Unit Testing, System Test and System Integration Test
- Supporting User Acceptance Testing activities and bug fixing
- Mentoring new colleagues with their projects, splitting work between us, and tracking work progress
Nov. 2020 - Dez. 2021
1 Jahr 2 Monaten Romania
Technical Analyst
E.ON
- Analyzing STMs - source to target mappings and provide best implementation path for change in the Entity relationship data model.
- Identifying gaps in the Entity Relationship data model and mapping new entities, attributes and relationships.
- Reaching stakeholders to clarify business requirements and establish common ground in delivering suited reports.
- Supporting in building comprehensive visualization in POWER BI.
- Analyzing time frames for possibility of providing requested information.
- Analyzing the structure for newly requested reports over core or data mart data layers.
- Providing guidance in implementation of changes over the data model by writing SQL queries to retrieve data samples.
- Understanding reporting needs coming from business and translating it in technical requirements.
Feb. 2020 - Aug. 2020
7 Monaten Austria
Oracle SQL and PL/SQL Developer
Erste Group IT International
- Supporting ALMM and Liquidity reporting process.
- Analyzing business requirements and creating solution design.
- Solution implementation in SQL, dynamic SQL, and PL/SQL code.
- Debugging code.
- Tracing issues raised by business on top of data.
- Writing custom and reusable pl/sql procedures to meet one-time requirements (ex: changing columns data type, managing table partitions, managing table tablespace etc ).
März 2018 - Jan. 2020
1 Jahr 11 Monaten Austria
Data Quality Oracle SQL Developer
Erste Group IT International
- Analyzing business requirements and translating logical mapping to physical mapping.
- Writing custom SQL scripts following business requirements mapped in Ab Initio Mhub.
- Implementing through SQL complex logic to deliver multiple aggregation levels to match business requirements.
- Implementing Data Quality Indicators using Ab Initio Mhub and Express-It.
- Testing implementation outcome against business expectations on number of lines and relations between entities.
- Ab Initio framework testing of data processing implementation in AB Initio GDE.
- Testing logic behind Ab Initio Metadata hub reports as well as testing Mhub GUI.
- Providing custom reporting in Jira tracking testing progress.
- Participating in daily scrum meetings to present progress and future planned activities.
Aug. 2017 - März 2018
8 Monaten Austria
Testing Analyst Data Warehouse
Erste Group IT International
- Create an end-to-end flow as a proof of concept for the further framework implementation in the countries (from different source systems up to data marts, including mappings, surrogation, ETL development, model changes, metadata repository, deployment).
- Installing metadata packages in ODI to run new mappings.
- Testing metadata driven ELT mappings in ODI and Power Designer.
- Testing each new developed change and functionality ex: surrogation mechanism, complex mappings which transport data from base layer to stage layer, changes related to data model etc.
- Test new framework releases per layer according to the testing strategies in tight collaboration with the customer.
- Creating test plan and test cases based on requirements.
- Maintaining and executing manual test cases.
- Creating and delivering testing status reports to the project team.
- Creating custom SQL scripts and PL/SQL procedures to test various aspects of the database implementation ex. partitioning standards, various checks upon data, smoke tests, integrity tests.
- Smoke test upon tables (Data profiling, plausibility, comparison, record counts).
Nov. 2016 - Aug. 2017
10 Monaten Romania
Data Warehouse Developer
UniCredit Business Integrated Solutions
- Develop ETL programs with an enterprise-grade tool (DataStage).
- Contributes substantially to the Data Warehouse ETL development lifecycle.
- Hands-on database development with SQL and stored procedures.
- Develops data transformations involving SQL, data-type conversions, joins filters, translations, aggregation, de-/normalization, and custom database stored procedures.
Mai 2016 - Nov. 2016
7 Monaten Romania
Data Warehouse Testing Analyst
BCR
- Create test plan and test cases based on requirements.
- Maintain and execute test automation scripts.
- Maintain and execute manual test cases.
- Create and deliver testing status reports to the project team.
- Collaborate with software engineering as needed, to resolve problems and identify root cause of product defects.
- Creating custom SQL scripts and PL/SQL procedures to test various aspects of the database implementation: partitioning standards, various checks upon data, smoke tests, integrity tests.
- Assist developers with debugging defects\Prod tickets by reproducing them in the Test Environment.
- Implement and maintain regression test bed of test requirements, labs, and cases.
- Review and define acceptance criteria based on the business unit requirements.
- Collaborate in augmenting the testing team documentation/knowledge base structure.
Mai 2015 - Mai 2016
1 Jahr 1 Monate Romania
BI & ERP Data Warehouse Testing Analyst
Vodafone
- Work constantly with third party teams: business and IT analysts, developers, managers, and support engineers.
- Installing deliverables as Informatica, Oracle objects and Unix scripts on informatica and oracle environments.
- Building test plans and test cases to cover the testing needs for all the newly installed objects: data types, data mapping, oracle objects, informatica objects, Unix scripts.
- Prepare the Acceptance Test Plan document.
- Identify prerequisites before proceeding to testing analyze impacted systems, tables synchronization, partitioning, access right's needs and systems configuration.
- Perform white box testing upon Unix, SQL and PL/SQL scripts behind the objects installed and apply functional, non-functional, regression, performance, stress, and negative testing strategies.
- Documentation analysis for omitted information in documents as IA, SIA, DD's, TR's, and BR's. Preparing deployment documentation as ATPR's and TR's.
- Working daily with Informatica Power Center ETL tool and PL/SQL Developer, plus other tools that help in organizing daily tasks and unexpected tasks.
Jan. 2015 - Mai 2015
5 Monaten Romania
PPS Enterprise Sales Demand Planner
Hewlett Packard
- Analyzing and planning the customer needs to improve the customer experience and revenue predictability while optimizing the supply chain cost.
- Contributing to the demand forecast for the product line based on inputs from HP internal systems, order history analysis, supply chain constraints and product marketing road maps.
- Monitoring the actual orders and comparing with demand plan to spot gaps and build an action plan for improvement.
- Anticipating demand evolution, platform shift, business seasonality and market trends.
- Communication with external teams, sales reps, supply chain, category teams.
Jan. 2013 - Jan. 2015
2 Jahren 1 Monate Romania
PPS EnS Global Sales Support Specialist
Hewlett Packard
- Business analysis for top 100 EMEA and Global Accounts using SFDC and Sales Customer sales methodology.
- Process owner for metrics definition on global sales team performance
- Working closely with the global sales managers for process deployment and data accuracy. Support the global opportunity management process using a wide range of HP internal systems. Quality improvement ownership for all business intelligence data for global sales.
- Recognition for developing data quality metric to prevent missing data.
Dez. 2011 - Dez. 2013
2 Jahren 1 Monate Romania
PPS Promo Special pricing EMEA Specialist
Hewlett Packard
- Act as single point of contact for all EMEA Sales Operations requests. owning special pricing guidelines process and improving sales awareness.
- Well informed of the promotions, discounts and other information which are necessary for handling special pricing process, making sure that the prices, discounts, and other data are correct.
- Submits and processes requests that come from clients, partners, sales representatives and/or commercial groups ensuring the agreed time frame.
- Deliver reports and memos regarding the processed requests, orders, and transactions.
Zusammenfassung
Experienced Data Engineer with over 10 years of expertise in Data Integration, Data Transformation, and application development within data warehousing environments.
Proficient in designing efficient data pipelines, creating scalable solutions for complex datasets, and enabling robust analytics and reporting systems.
Skilled in SQL Development, Technical Analysis, Source-to-Target Mappings, Solution Proposals and Data Warehouse Application System Design.
Demonstrated ability to deliver high-quality results in dynamic, collaborative settings.
Experienced in Agile methodologies and passionate about transforming data into actionable insights to drive informed business decisions.
Sprachen
Rumänisch
Muttersprache
Englisch
Verhandlungssicher
Deutsch
Fortgeschritten
Ausbildung
Okt. 2010 - Juni 2012
The Academy of Economic Studies
Masters · International Economics and European Affairs · Bucharest, Romania
Okt. 2006 - Juni 2010