Recommended expert

Dalia Cananau

Oracle Developer

Dalia Cananau
Korschenbroich, Germany

Experience

Mar 2019 - Present
7 years

Oracle Developer

Freelance

  • Design and implementation of an OCI-based data warehouse and ETL system to replace legacy mainframe applications
  • Developed a database optimization strategy and planned the rapid conversion of JCL and COBOL routines to PL/SQL using AI
  • Developed an Oracle Apex-based app for internal administrative processes in the public sector (office equipment, staff training)
  • Implemented PL/SQL workflows for approval processes and created a responsive mobile version with JavaScript and CSS
  • Used Azure DevOps for backlog management and documentation, and Git for version control
  • Developed REST interfaces to CRM systems
  • Replaced and reprogrammed Oracle Forms screens with Oracle Apex and updated to the latest Apex versions
  • Designed a Git branching strategy and conducted code reviews
  • Maintained and further developed an EDI-based data exchange system based on Oracle Advanced Queuing for the public sector in Austria
  • Performed data analysis and created charts in the Oracle Apex frontend; installed standalone ORDS and Apex 23.1
  • Worked agile using the Spotify model; developed complex Apex pages with support from Oracle JET
  • Rebuilt and customized existing PL/SQL packages, created workarounds for database version differences, and optimized queries
  • Developed Apex applications for broker pools to manage and optimize Oracle databases in the banking environment, including SSO-based authorization systems with OAuth2 and Keycloak
  • Built extensive Oracle Apex applications for BI and data mining modernization projects and developed manual and automated projection methods in the frontend
  • Carried out data warehousing projects in the banking sector and used Scrum and Kanban in team projects
Aug 2018 - Feb 2019
7 months
Düsseldorf, Germany

Oracle Developer

German Pharmacists and Physicians Bank

  • Trained in the Avaloq core banking system and certified ACCP major in core
Oct 2017 - Oct 2019
2 years 1 month
Glasgow, United Kingdom

Shareholder

Techontrol Automotive Systems Engineering and Racing

  • Founded a car care, service, and repair company
  • Invested capital and developed the company website and software
  • Created an inspection system for used cars based on Oracle PL/SQL and Apex
Mar 2017 - Jul 2018
1 year 5 months
United Kingdom

Programmer

Scottish Environment Protection Agency

  • Project-driven data integration and migration from other systems to Oracle
  • Managed ETL interfaces and developed SOAP and REST web services
  • Performed database tuning and query optimization
  • Designed highly dynamic Apex applications using PL/SQL and JavaScript
  • Managed and enhanced license management applications based on Oracle Forms
  • Adapted agile methods in software development
Aug 2016 - Dec 2018
2 years 5 months
Hong Kong

Owner

Techontrol Ltd.

  • Provided IT consulting for clients in East Asia
Aug 2015 - Feb 2017
1 year 7 months
Bucharest, Romania

Software Developer

Accenture

  • Technical expert in Oracle Apex for Siemens in Munich
  • Provided consulting for two Apex projects and took over a complex Apex application in a short time
  • Created reports using JasperReports
  • Developed a text comparison system based on PL/SQL
  • Developed a migration portal as a control system for the second phase of a data migration project, based on Oracle PL/SQL and Apex with data exchange via SOAP web services
Nov 2008 - Jul 2015
6 years 9 months
Galați, Romania

MES Software Developer

ArcelorMittal Galati

  • Programmed Oracle production applications with Oracle Forms, PL/SQL, and Pro*C
  • Collected data for production programming, production processes, and machine maintenance and repair using Oracle Forms, Oracle Reports, Pro*C, and COBOL
  • Designed, developed, and maintained interfaces to other systems, especially SAP
  • Developed a data monitoring system and a task-based reporting system using PL/SQL and VBS
  • Supported the implementation of a new MES system by optimizing queries on MS SQL Server and programming with C#
  • Created reports for Broner Metals using ASP.NET, VB.NET, and C#
Sep 2007 - May 2009
1 year 9 months
Romania

Owner

CYI cadouri si inventii SRL

  • Sole distributor and partner of the American company CYI Inc.
  • Designed and developed the company website using PHP, JavaScript, and MySQL
Feb 2006 - Aug 2007
1 year 7 months
Hong Kong

Native English and French Teacher

Lernzentren und Schulen

  • Taught students aged 2 to 17 years
  • Responsible for curriculum development and creating teaching materials
Sep 2002 - Dec 2006
4 years 4 months
Hong Kong

Teaching Assistant

Hong Kong University of Science and Technology

  • Conducted seminars for various mathematics courses
  • Participated in managing the student portal

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Government and Administration (8.5 years), Banking and Finance (7.5 years), Metals and Mining (6.5 years), Education (5 years), Information Technology (4 years), and Automotive (2 years).

Government and Administration
Banking and Finance
Metals and Mining
Education
Information Technology
Automotive

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (22.5 years), Business Intelligence (7 years), Production (6.5 years), Product Development (5 years), and Operations (4.5 years).

Information Technology
Business Intelligence
Production
Product Development
Operations

Summary

Many years of expertise in database development, data modeling, PL/SQL, Apex, and JavaScript.

Several years of experience with data warehousing, database replication and migration, data analysis, and forecasting using ML and AI.

Commercial and freelance project experience in Europe and Asia.

Skills

  • Programming Languages: Sql, Pl/sql, Javascript, Oracle Jet, Jquery, Ajax, Html, Css
  • Databases: Oracle 8i, 10g, 11g, 12c, 18c, 19c, 23ai
  • Software: Pl/sql Developer, Sql Developer, Toad, Sql*plus, Git, Jira, Confluence, Tfs, Bitbucket, Docker, Jenkins, Visual Studio Code Editor, Oracle Forms
  • Framework: Oracle Application Express 4.2-24.2
  • Operating Systems: Unix (Hp-ux), Linux, Windows Xp, Windows 7, Windows 10
  • Cloud: Oci, Aws, Azure
  • Ml/ai: Oml Notebooks, Oci Gen-ai

Languages

English
Native
French
Native
German
Advanced

Education

Sep 2002 - Jun 2006

Department of Mathematics, Hong Kong University of Science and Technology

PhD candidate, credit requirements met with GPA of 10.08 (A-) · Mathematics · Hong Kong · 10.08

Sep 2000 - Jan 2002

University of Bucharest

Major in Analytic Functions · Mathematics · Bucharest, Romania

Sep 1996 - Jun 2000

University of Bucharest

Qualified teacher in Mathematics at the secondary level · Mathematics · Bucharest, Romania

Certifications & licenses

ACCP Major In Core

Profile

Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Dalia based?

Dalia is based in Korschenbroich, Germany.

What languages does Dalia speak?

Dalia speaks the following languages: English (Native), French (Native), German (Advanced).

How many years of experience does Dalia have?

Dalia has at least 23 years of experience. During this time, Dalia has worked in at least 8 different roles and for 10 different companies. The average length of individual experience is 2 years and 4 months. Note that Dalia may not have shared all experience and actually has more experience.

What roles would Dalia be best suited for?

Based on recent experience, Dalia would be well-suited for roles such as: Oracle Developer, Shareholder, Programmer.

What is Dalia's latest experience?

Dalia's most recent position is Oracle Developer at Freelance.

What companies has Dalia worked for in recent years?

In recent years, Dalia has worked for Freelance.

Which industries is Dalia most experienced in?

Dalia is most experienced in industries like Government and Public Administration, Banking and Finance, and Metals and Mining. Dalia also has some experience in Education, Information Technology (IT), and Automotive.

Which business areas is Dalia most experienced in?

Dalia is most experienced in business areas like Information Technology (IT), Business Intelligence, and Production/Manufacturing. Dalia also has some experience in Product Development and Operations.

Which industries has Dalia worked in recently?

Dalia has recently worked in industries like Banking and Finance and Government and Public Administration.

Which business areas has Dalia worked in recently?

Dalia has recently worked in business areas like Business Intelligence and Information Technology (IT).

What is Dalia's education?

Dalia holds a Doctorate in Mathematics from Department of Mathematics, Hong Kong University of Science and Technology, a Master in Mathematics from University of Bucharest and a Bachelor in Mathematics from University of Bucharest.

Does Dalia have any certificates?

Dalia has 1 certificate: ACCP Major In Core.

What is the availability of Dalia?

Dalia is immediately available for suitable projects.

What is the rate of Dalia?

Dalia's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Dalia?

To hire Dalia, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 860-1020 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.