Top 5%
Razvan G.

Data Engineer

555 dollar
Freelancer
11 ans
Bucarest, ROUMANIE
i

Why I'm Top 5%

  • 11 years of industry experience
Learn how we hire

Mon expérience

Voir plus

Freelance ProfessionalSeptember 2015 - Présent

"Knowledge is a weapon. I intend to be formidably armed.” ―Terry Goodkind

My duties as a contractor (with different clients like : Raiffeisen Bank, Deutsche Bank, Paddy Power Betfair, Vauban) consisted of helping with:

- migrating on-premises datawarehouse to Cloud (Amazon S3, Amazon Redshift, Talend, Oracle, MySQL, SQL Server, Kafka, PostgreSQL)

- constructing a data lake and reporting services on it - using Cloudera Hadoop distribution

- constructing models in order to predict different aspects related to anti-financial crime

- improving performance on Oracle databases

- setting data pipelines on-premises (ODI, Apex, Cognos)

- implementing database code business logic (mainly using PL/SQL)

- touching domains like credit risk, market risk, audit, anti-financial crime, betting
Voir plus

Deutsche BankJanuary 2014 - October 2015

****************
* About me : *
****************

Defining and building the strategic data architecture for Credit Risk

Overseeing, governing and guiding all data related activity of Credit Risk

Designing and developing new projects and enhancements for Credit Risk systems with respect to data

Participating and leading design workshops

Coding reviews and reviews of technical documentation

Defining data storage and maintenance at a technical level
Assuring performance and scalability of data related components
Ensuring correct strategy around data environments

Interacting with Credit Risk clients to design and implement appropriate solutions


***********************
* About the company : *
***********************
Deutsche Bank AG (literally "German Bank"; pronounced [ˈdɔʏtʃə ˈbaŋk]) is a German global banking and financial services company with its headquarters in the Deutsche Bank Twin Towers in Frankfurt.
It has more than 100,000 employees in over 70 countries, and has a large presence in Europe, the Americas, Asia-Pacific and the emerging markets.
In 2009, Deutsche Bank was the largest foreign exchange dealer in the world with a market share of 21 percent
Voir plus

PropertyShark.comMay 2012 - September 2013

****************
* About me : *
****************

Heavy Database Administration in Oracle Production Databases ( 11g ) : Security, Space, Tuning , Access Issues

Replication between different databases using SharePlex

• Oracle RAC installation & configuration

Backup and recovery strategies : RMAN

Oracle Automatic Storage Management

Design and Development of Database Schemas and Objects : Views/Tables/Materialized Views/Indexes/Triggers

• Hold technical presentations ( Oracle architecture & SQL/PL-SQL )

***********************
* About the company : *
***********************
PropertyShark.com
aggregates real estate data and listings from hundreds of public and
proprietary sources into an easy-to-use yet comprehensive property
research website covering a dozen major markets.
PropertyShark.com
now provides Property Reports, Pre-Foreclosure and Foreclosure Listings,
Sales Comparables, Maps, Building Photos, For Sale Listings, and For
Lease Listings. The company now has 50 full time employees and has been
profitable since day one, growing even during one of the worst economic
downturns in U.S. history in 2008.
Voir plus

BetfairFebruary 2012 - May 2012

****************
* About me : *
****************

• Oracle 10g/11g Cost Based Query Transformation tuning / Cardinality feedback

Explain Plan evaluation

SQL plan management Profiles/Outlines


Defined Indexing strategies for DW systems (Global partitioned Index,
Reverse Key indexes,Local indexes,Function Based Indexes)

Define and test (from a performance point of view) the migration process from Oracle 10g to Oracle 11g

Analyze Data Warehouse partitioning strategies

Assisting users and providing guidance for writing optimal queries

Using Oracle Wait Interface / AWR / ASH to monitor the system performance

Data Warehouse ETL and Reports tuning

• Hold technical presentations on SQL Tuning topics

Support developers in tuning DB and apps for optimal performance
Voir plus

BetfairAugust 2011 - February 2012

****************
* About me : *
****************
Work on a very large Oracle Database (approximately 50TB) with a 4 nodes RAC architecture.

Develop procedures and functions to enhance the Data Warehouse’s department activity

Support for the existing applications: day-to-day running, troubleshooting, end user query support.

Write queries that extract data from Data Warehouse for both audit and business purposes

Provide guidance for other team members or other departments onto how to get the desired results from the Data Warehouse

Exposure to different areas of the betting industry -> Data Warehouse system contains multiple databases replicated in real-time from the source system

• Hold technical presentations on Oracle/Data Warehousing

• Provide 24/7 Data Warehouse support (third line support )

DBA support for Data Warehouse.

***********************
* About the company : *
***********************
Betfair is the world’s biggest betting community having pioneered the betting exchange in 2000.
Betfair has twice been named the UK’s ‘Company of the Year’ by the Confederation of British Industry and has won two prestigious Queen’s Awards for Enterprise, being recognised for Innovation in 2003 and most recently for International Trade in 2008.
Voir plus

iQuest TechnologiesFebruary 2011 - August 2011

****************
* About me : *
****************

Design and develop a based Oracle database solution for one of the largest telecommunications company ( Vodafone Germany )

Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.

Worked with product managers to give work estimates

Coded and implemented PL/SQL packages, procedures and unit tests

Documented business rules, functional and technical designs, test cases, and user guides.

Optimized and modified the triggers, complex store functions

***********************
* About the company : *
***********************
iQuest is an IT solution provider…and a lot more besides.
The
iQuest mission is to provide information technology services, software
development, systems integration and consultancy to empower your
business strategy: locally, nationally, and globally.
iQuest creates
customised systems configurations based on rigorous and detailed
assessments of what makes your business tick, and what it needs to help
it grow.
Voir plus

ISDCJuly 2010 - August 2010

****************
* About me : *
****************

Develop a complete business intelligence solution

Model Data Vault ( as Data Warehouse staging area )

Choose KPIs to demonstrate the work quality in the company


Use Oracle tools like OWB - Oracle Warehouse Builder , Oracle SQL
Developer , Oracle Data Modeler , Oracle Integration Services , Oracle
Presentation Services
Creating scorecards/dashboards with reporting purposes for business users


DWH implementation: development of high performance SQL and PL/SQL
procedures; development of ETL mapping/jobs; ODBC connectivity;
implementation and configuration of the front end tool to give data
access to the end users

DWH system design: logical and physical database design, front end application design, ETL design

***********************
* About the company : *
***********************
ISDC
is a European IT Services Company that operates on the European market,
mainly Dutch, for already 20 years. As a pioneer in ICT nearshoring,
ISDC has moved from being a supplier of pure technology to a responsive
partner for businesses that need ICT solutions and services.

Mes compétences

Analysis methods and tools

Scrum

Other

gcp

Others

Data Migration, Database Design, Data Science, Technical Design, Troubleshooting, Artificial Intelligence, Performance tuning

Languages

ODBC, Python, PL/SQL, Oracle PL/SQL, SQL, Java

Software testing

Debugging, Test Cases, Unit testing

Databases

Oracle, MongoDB, Oracle 11g, Oracle 10g, MySQL, PostGreSQL, Database Administration, Database and SQL tuning, Microsoft SQL Server, Oracle tools, Shareplex

Big Data

Apache Kafka

Technologies

Software Development, Machine Learning, AWS

IT Infrastructure

Google Cloud Platform (GCP)

Business Intelligence

SQL Server Integration Services, Business Intelligence, ETL, Data Warehouse, Cognos Impromptu, Oracle Data Integrator, Oracle Warehouse Builder

Mes études et formations

Google Cloud Certified Professional Data Engineer - Google2020 - 2020

MongoDB for DBAs - 10gen2013 - 2013

Oracle Advanced PL/SQL Developer Certified Professional (OCP) - Oracle2011 - 2011

Bachelor's Degree, Computer Science - Technical University of Cluj-Napoca2007 - 2011