Octavian Golea - DWH Technical Analyst

Q: Where is Octavian based?

Octavian is based in Vienna, Austria and can operate in on-site , hybrid , and remote work models.

Q: What languages does Octavian speak?

Octavian speaks the following languages: Romanian (Native), English (Advanced), German (Intermediate) .

Q: How many years of experience does Octavian have?

Octavian has at least 14 years of experience. During this time, Octavian has worked in at least 13 different roles and for 10 different companies . The average length of individual experience is 1 year . Note that Octavian may not have shared all experience and actually has more experience.

Q: What is Octavian's latest experience?

Octavian's most recent position is Oracle DWH Analyst at Infomotion Gmbh .

Q: What companies has Octavian worked for in recent years?

In recent years, Octavian has worked for Infomotion Gmbh , DHL IT Services , Cembra Money Bank , Unicredit Services GmbH , and E.ON .

Q: Which industries is Octavian most experienced in?

Octavian is most experienced in industries like Banking and Finance , Information Technology (IT) , and Transportation and Logistics . Octavian also has some experience in Energy and Telecommunication .

Q: Which business areas is Octavian most experienced in?

Octavian is most experienced in business areas like Business Intelligence , Information Technology (IT) , and Quality Assurance (QA) . Octavian also has some experience in Operations , Sales , and Supply Chain Management .

Q: Which industries has Octavian worked in recently?

Octavian has recently worked in industries like Banking and Finance , Transportation and Logistics , and Energy .

Q: Which business areas has Octavian worked in recently?

Octavian has recently worked in business areas like Business Intelligence , Information Technology (IT) , and Quality Assurance (QA) .

Recommended expert

Vienna, Austria

Experience

May 2025 - Nov 2025

7 months

Bucharest, Romania

Remote

Oracle DWH Analyst

Infomotion Gmbh

Oracle PL/SQL, Oracle SQL, ITIL

Nov 2024 - Present

1 year 4 months

Prague, Czech Republic

Remote

DWH Developer

DHL IT Services

Teradata BTEQ, Wherescape RED ETL, Unix Scripting, GIT, Confluence

Apr 2024 - Aug 2024

5 months

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 - Mar 2024

3 years 2 months

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 - Dec 2021

1 year 2 months

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 months

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 ).

Mar 2018 - Jan 2020

1 year 11 months

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 - Mar 2018

8 months

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 months

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.

May 2016 - Nov 2016

7 months

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.

May 2015 - May 2016

1 year 1 month

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/SQLscripts 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 - May 2015

5 months

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 years 1 month

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.

Dec 2011 - Dec 2013

2 years 1 month

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.

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Banking and Finance (8 years), Information Technology (4 years), Transportation (1.5 years), Energy (1 year), and Telecommunication (1 year).

Banking and Finance

Information Technology

Transportation

Energy

Telecommunication

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Business Intelligence (12.5 years), Information Technology (10 years), Quality Assurance (5 years), Operations (3.5 years), Sales (3 years), and Supply Chain Management (0.5 years).

Business Intelligence

Information Technology

Quality Assurance

Operations

Sales

Supply Chain Management

Languages

Romanian

Native

English

Advanced

German

Intermediate

Education

Oct 2010 - Jun 2012

The Academy of Economic Studies

Masters, International Economics and European Affairs · International Economics and European Affairs · Bucharest, Romania

Oct 2006 - Jun 2010

The Academy of Economic Studies

Bachelor’s in economy · Economy · Bucharest, Romania

Certifications & licenses

Oracle SQL Certified Associate

Oracle

ISTQB Certified Tester, Foundation Level

Professional Scrum Product Owner I

Azure Data Fundamentals

Microsoft

ITIL v4 Foundation Level

ITIL

Profile

Created

December 2024

Last Update

January 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Octavian based?

Octavian is based in Vienna, Austria and can operate in on-site, hybrid, and remote work models.

What languages does Octavian speak?

Octavian speaks the following languages: Romanian (Native), English (Advanced), German (Intermediate).

How many years of experience does Octavian have?

Octavian has at least 14 years of experience. During this time, Octavian has worked in at least 13 different roles and for 10 different companies. The average length of individual experience is 1 year. Note that Octavian may not have shared all experience and actually has more experience.

What roles would Octavian be best suited for?

Based on recent experience, Octavian would be well-suited for roles such as: Oracle DWH Analyst, DWH Developer, Technical Analyst.

What is Octavian's latest experience?

Octavian's most recent position is Oracle DWH Analyst at Infomotion Gmbh.

What companies has Octavian worked for in recent years?

In recent years, Octavian has worked for Infomotion Gmbh, DHL IT Services, Cembra Money Bank, Unicredit Services GmbH, and E.ON.

Which industries is Octavian most experienced in?

Octavian is most experienced in industries like Banking and Finance, Information Technology (IT), and Transportation and Logistics. Octavian also has some experience in Energy and Telecommunication.

Which business areas is Octavian most experienced in?

Octavian is most experienced in business areas like Business Intelligence, Information Technology (IT), and Quality Assurance (QA). Octavian also has some experience in Operations, Sales, and Supply Chain Management.

Which industries has Octavian worked in recently?

Octavian has recently worked in industries like Banking and Finance, Transportation and Logistics, and Energy.

Which business areas has Octavian worked in recently?

Octavian has recently worked in business areas like Business Intelligence, Information Technology (IT), and Quality Assurance (QA).

What is Octavian's education?

Octavian holds a Master in International Economics and European Affairs from The Academy of Economic Studies and a Bachelor in Economy from The Academy of Economic Studies.

Does Octavian have any certificates?

Octavian has 5 certificates. Among them, these include: Oracle SQL Certified Associate, ISTQB Certified Tester, Foundation Level, and Professional Scrum Product Owner I.

What is the availability of Octavian?

Octavian is immediately available full-time for suitable projects.

What is the rate of Octavian?

Octavian's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.