Profileimage by Octavian Golea Data Warehosue Technical Analyst,  DWH Oracle SQL Developer, DWH Teradata SQL Developer from Bucharest

Octavian Golea

available

Last update: 11.10.2022

Data Warehosue Technical Analyst, DWH Oracle SQL Developer,DWH Teradata SQL Developer

Company: Data Brains Consulting SRL
Graduation: Bachelor Degree in Economics and Master Degree
Hourly-/Daily rates: show
Languages: German (Limited professional) | English (Full Professional) | French (Elementary) | Romanian (Native or Bilingual)

Keywords

PL-SQL SQL Databases Oracle SQL Developer Unix Extract Transform Load (ETL) Data Quality Oracle Applications Ab Initio JIRA Test Automation + 22 more keywords

Attachments

CV Octavian Golea doc (2).pdf

Skills

Teradata, Unix, SQL/BTEQ, metadata, SQL, bug fixing, data layers, data model, SQL queries, Oracle SQL, PL/SQL Developer, dynamic SQL, PL/SQL code, Debugging, Data Quality, Oracle, SQL scripts, Ab Initio Mhub, Express-It, data processing, AB Initio GDE, GUI, Jira, scrum, Data Warehouse, ETL, metadata repository, testing strategies, Spring, E2E testing, test automation, PL, database, DataStage, stored procedures, PL/SQL, ERP, Informatica, Oracle objects, Unix scripts, data mapping, informatica objects, white box testing, PL/SQL scripts, ETL tool, SFDC

Project history

02/2021 - Present
Teradata Developer
Unicredit Bank AG (Banks and financial services)

-  Business meetings for better understanding the business area
- Technical Analysis: Mainframe/Unix Files, Sources, Access rights, Dependencies, Delivery Time,ETL Jobs parametrization etc.
- Building technical mappings upon Business Data Elements description
- Writing Technical Specification over implementation strategy
- Implementing data base structures via SQL/BTEQ (tables, views, metadata, surrogate keys)
- Deploying and testing SQL(BTEQ) scripts
- Conducting System Integration Test
- Supporting User Acceptance Testing activities and bug fixing

11/2020 - 12/2021
Technical Analyst
E. ON Romania

- Analyzing source to target mappings to provide best implementation path for change in the data
model.
- Reaching to stakeholders to clarify requirements and establish common ground in delivering suited
reports.
- Analyzing time frames for possibility of providing requested information.
- Analyzing the structure for new 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 translate it in technical requirements.

03/2018 - 10/2020
Data Quality Oracle SQL Developer
Erste Group IT International

- Analyzing business requirements and translate logical mapping to physical mapping.
- Writing custom SQL scripts following business requirements mapped in Ab Initio Mhub.
- Implementing thru SQL complex logic in order to deliver multiple aggregation levels in order 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.

02/2020 - 08/2020
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 ).

08/2017 - 03/2018
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).
- Testing metadata driven ETL 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.
- Supporting Spring E2E testing activities as well as framework.
- Creating test plan and test cases based on requirements.
- Maintaining and executing test automation scripts.
- Maintaining and executing manual test cases.
- Creating and delivering testing status reports to the project team.
- Collaboration with software engineering as needed to resolve problems and identify root cause of
product defects.
- Assisting developers with debugging defects\Prod tickets by reproducing them in the Test
Environment.
- 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 ) .

11/2016 - 08/2017
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.

05/2016 - 11/2016
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 project team.
- Collaborate with software engineering as needed, to resolved problems and identify root
cause of product defects.
- Creating custom SQL scripts and PL/SQL procedures in order to test various aspects of the
database implementation: ex.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.

05/2015 - 05/2016
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 new 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.

01/2015 - 05/2015
PPS Enterprise Sales Demand Planner
Hewlett Packard

- Analyzing and plan 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 compare 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.

01/2013 - 01/2015
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 wide range of HP internal
systems. Quality improvement ownership for all business intelligence data for global sales.
- Recognition for developing data quality metric in order to prevent missing data.

12/2011 - 12/2013
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's which are necessary for
handling special pricing process, making sure that the prices, discounts and other data are
correct.
- Submits and processes requests that are coming 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.

Local Availability

Only available in these countries: Romania
Very rarelly I am willing to travel to the customer , mainly I work remote.
Profileimage by Octavian Golea Data Warehosue Technical Analyst,  DWH Oracle SQL Developer, DWH Teradata SQL Developer from Bucharest Data Warehosue Technical Analyst, DWH Oracle SQL Developer,DWH Teradata SQL Developer
Register