Dalia Cananau
Oracle Developer
Experience
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
Oracle Developer
German Pharmacists and Physicians Bank
- Trained in the Avaloq core banking system and certified ACCP major in core
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
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
Owner
Techontrol Ltd.
- Provided IT consulting for clients in East Asia
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
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#
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
Native English and French Teacher
Lernzentren und Schulen
- Taught students aged 2 to 17 years
- Responsible for curriculum development and creating teaching materials
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).
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).
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
Education
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
University of Bucharest
Major in Analytic Functions · Mathematics · Bucharest, Romania
University of Bucharest
Qualified teacher in Mathematics at the secondary level · Mathematics · Bucharest, Romania
Certifications & licenses
ACCP Major In Core
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Dalia based?
What languages does Dalia speak?
How many years of experience does Dalia have?
What roles would Dalia be best suited for?
What is Dalia's latest experience?
What companies has Dalia worked for in recent years?
Which industries is Dalia most experienced in?
Which business areas is Dalia most experienced in?
Which industries has Dalia worked in recently?
Which business areas has Dalia worked in recently?
What is Dalia's education?
Does Dalia have any certificates?
What is the availability of Dalia?
What is the rate of Dalia?
How to hire Dalia?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Oracle Developer
Nearby freelancers
Professionals working in or nearby Korschenbroich, Germany