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.