Octavian Golea

Technical Analyst

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, Bucharest

Masters · International Economics and European Affairs · Bucharest, Romania

Oct 2006 - Jun 2010

The Academy of Economic Studies, Bucharest

Bachelor’s · Economy · Bucharest, Romania

Certifications & licenses

ISTQB Certified Tester, Foundation Level

Professional Scrum Product Owner I