Octavian Golea

Technical Analyst

Avatar placeholder
Vienna, Romania

Experience

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.

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

ISTQB Certified Tester, Foundation Level

Professional Scrum Product Owner I

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Mihai Anghel
Mihai Anghel

Senior ETL Developer | Team Lead

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Ovidiu daniel Juncanariu
Ovidiu daniel Juncanariu

Senior PHP Developer - Freelance

View Profile
Axel Berron
Axel Berron

Microsoft Fabric & Power BI Developer

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Alex Odesser
Alex Odesser

Contractor

View Profile
Andrei Gaia
Andrei Gaia

Developer, Logistics Consultant

View Profile
János Kurics
János Kurics

Data Engineer Lead

View Profile
Joachim Bleichert
Joachim Bleichert

Oracle consulting and development

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Stefan Wimmer
Stefan Wimmer

Architect/Software Developer/Infrastructure

View Profile
Christian Dröge
Christian Dröge

Requirements Engineer

View Profile
William Nguyen
William Nguyen

Product Owner Frontend

View Profile
Jörg Trappschuh
Jörg Trappschuh

Database Expert and Software Developer

View Profile
Ben Spouse
Ben Spouse

Data Engineer/ ETL Developer

View Profile
Henning Uiterwyk
Henning Uiterwyk

Senior Expert Data Governance, Master Data Quality and Data Migration

View Profile
Eric Bouendeu
Eric Bouendeu

Quality Assurance Manager (QSV)

View Profile
Christoph Wagner
Christoph Wagner

System Architect / System Engineer / Programmer

View Profile
Felix Meermann
Felix Meermann

Business Developer, Product Owner Support

View Profile
Eduard Van kleef
Eduard Van kleef

Workshop Leader 'Introduction to AI Development Tools'

View Profile
Peter Glöckner
Peter Glöckner

Software Developer

View Profile
Kerstin Burgen
Kerstin Burgen

Reporting and Analytics for HR

View Profile
Gerald Gastgeb
Gerald Gastgeb

Data Warehouse Architect and Lead Data Modeler

View Profile
Moez Seyedan
Moez Seyedan

Data Engineer

View Profile
Valentin Marginean
Valentin Marginean

Senior Backend Developer

View Profile
Michael Gonschor
Michael Gonschor

Scrummaster

View Profile
Younes Hadrous
Younes Hadrous

Senior Backend Developer

View Profile
Roland peter Schneider
Roland peter Schneider

Emigration and founding an LLC

View Profile
Christian Mayr
Christian Mayr

Senior Feature Engineer - Banking

View Profile