Octavian Golea
Technical Analyst
Erfahrungen
Apr. 2024 - Aug. 2024
5 Monaten Zürich, Schweiz
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 - März 2024
3 Jahren 2 Monaten Österreich
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 - Dez. 2021
1 Jahr 2 Monaten Rumänien
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 Monaten Österreich
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 ).
März 2018 - Jan. 2020
1 Jahr 11 Monaten Österreich
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 - März 2018
8 Monaten Österreich
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 Monaten Rumänien
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.
Mai 2016 - Nov. 2016
7 Monaten Rumänien
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.
Mai 2015 - Mai 2016
1 Jahr 1 Monate Rumänien
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 - Mai 2015
5 Monaten Rumänien
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 Jahren 1 Monate Rumänien
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.
Dez. 2011 - Dez. 2013
2 Jahren 1 Monate Rumänien
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.
Sprachen
Rumänisch
Muttersprache
Englisch
Verhandlungssicher
Deutsch
Fortgeschritten
Ausbildung
Okt. 2010 - Juni 2012
The Academy of Economic Studies, Bucharest
Masters · International Economics and European Affairs · Bukarest, Rumänien
Okt. 2006 - Juni 2010
The Academy of Economic Studies, Bucharest
Bachelor’s · Economy · Bukarest, Rumänien
Zertifikate & Bescheinigungen
ISTQB Certified Tester, Foundation Level
Professional Scrum Product Owner I
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.