Top 5%
Razvan G.
Data Engineer
555 dollar
i
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
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
* 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.
* 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
* 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.
* 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.
* 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.
* 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
Consultez des profils similaires
BORIS M.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 1105$/jour |
| Expérience | 11 ans |
| Localisation | France |
Cláudio D.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 280$/jour |
| Expérience | 17 ans |
| Localisation | Portugal |
Bogdan I.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 335$/jour |
| Expérience | 10 ans |
| Localisation | Roumanie |
TEDDY M.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 690$/jour |
| Expérience | 9 ans |
| Localisation | France |
Alda P.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 690$/jour |
| Expérience | 11 ans |
| Localisation | États-Unis |
Amalia V.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 335$/jour |
| Expérience | 8 ans |
| Localisation | Roumanie |
Ciprian L.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 445$/jour |
| Expérience | 17 ans |
| Localisation | Roumanie |
Colm G.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 460$/jour |
| Expérience | 9 ans |
| Localisation | Royaume-Uni |
Emin T.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 915$/jour |
| Expérience | 16 ans |
| Localisation | Royaume-Uni |
Nour B.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 915$/jour |
| Expérience | 10 ans |
| Localisation | France |
Radu G.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 660$/jour |
| Expérience | 10 ans |
| Localisation | Roumanie |
Amin K.
Data Engineer
| Type de contrat | Freelancers |
|---|---|
| Taux journalier | 915$/jour |
| Expérience | 15 ans |
| Localisation | France |
Partners
