Dalia C.
Oracle Developer
Experience
Mar 2019 - Present
6 years 7 monthsOracle Developer
Freelance
- Designed and implemented OCI-based DWH and ETL system to replace legacy mainframe applications.
- Developed database optimization strategy and planned rapid conversion of JCL and COBOL routines to PL/SQL using AI.
- Developed Oracle Apex-based app for internal administration in public sector, covering office equipment management and employee training planning.
- Implemented PL/SQL workflows for approval processes, and used JavaScript and CSS for responsive mobile version.
- Managed backlog and documentation with Azure DevOps and used Git for version control.
- Developed REST interfaces with CRM system.
- Migrated and reprogrammed Oracle Forms screens to Oracle Apex and upgraded to latest Apex versions.
- Designed Git branching strategy and conducted code reviews.
- Maintained and enhanced an EDI-based data exchange system using Oracle Advanced Queuing for Austrian public sector.
- Performed data analysis and charting in Oracle Apex frontend and installed standalone ORDS and Apex 23.1.
- Employed agile methods following the Spotify model.
- Created complex Apex screens based on UX designs using Oracle JET.
- Developed and adapted PL/SQL packages, implemented workarounds for database version differences, and optimized queries.
- Built Apex applications for managing and optimizing Oracle databases in banking environment.
- Integrated SSO-based authorization in Apex using OAuth2 and Keycloak.
- Developed extensive Oracle Apex applications using PL/SQL and JavaScript as part of BI and data mining modernization projects.
- Developed manual and automated projection methods in the front end.
- Executed Oracle database-based data warehousing projects for banking systems in chemical industry.
- Applied Scrum and Kanban methodologies in team-oriented projects.
Aug 2018 - Feb 2019
7 monthsDüsseldorf, Germany
Oracle Developer
Deutsche Apotheker- und Ärztebank
- Trained in the Avaloq core banking system and obtained ACCP Major in Core certification.
Oct 2017 - Oct 2019
2 years 1 monthGlasgow, United Kingdom
Shareholder
Techontrol Automotive Systems Engineering and Racing
- Founded an auto care, service, and repair company.
- Managed capital investment, company website, and software development.
- Developed a vehicle inspection system for used cars based on Oracle PL/SQL and Apex.
Mar 2017 - Jul 2018
1 year 5 monthsUnited Kingdom
Programmer
Scottish Environment Protection Agency
- Focused on information integration and migration of other systems to Oracle.
- Managed ETL interfaces and developed various SOAP and REST web services.
- Performed database tuning and query optimization.
- Designed highly dynamic Apex applications using PL/SQL and JavaScript.
- Maintained and enhanced license management applications based on Oracle Forms.
- Adapted agile methodologies in software development.
Aug 2016 - Dec 2018
2 years 5 monthsHong Kong
Owner
Techontrol Ltd.
- Provided IT consulting services to clients in East Asia.
Aug 2015 - Feb 2017
1 year 7 monthsBucharest, Romania
Software Developer
Accenture
- Served as Oracle Apex expert for Siemens in Munich on two Apex projects.
- Took over a complex Apex application in a short time.
- Used JasperReports for report generation.
- Created a text comparison system based on PL/SQL.
- Developed the migration portal as a control system for the second phase of the data migration project, an Oracle PL/SQL and Apex application with data exchange via SOAP web services.
Nov 2008 - Jul 2015
6 years 9 monthsGalați, Romania
MES Software Developer
ArcelorMittal Galati
- Programmed Oracle production applications using Oracle Forms, PL/SQL, and Pro*C.
- Captured data in production programming, production processes, machine maintenance, and repair using Oracle Forms, Oracle Reports, Pro*C, and Cobol.
- Designed, developed, and maintained interfaces with other systems, especially SAP.
- Created a data monitoring system and a task-oriented reporting system based on PL/SQL and VBS.
- Supported the introduction of a new MES system by optimizing queries in MS SQL Server and programming with C#.
- Generated Broner Metals reports using ASP.NET, VB.NET, and C#.
Sep 2007 - May 2009
1 year 9 monthsRomania
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 monthsHong Kong
Native English and French Teacher
Lernzentren und Schulen
- Taught students of various age groups (2-17 years).
- Developed curricula and created teaching materials.
Sep 2002 - Dec 2006
4 years 4 monthsHong Kong
Teaching Assistant
Hong Kong University of Science and Technology
- Conducted seminars for various courses and participated in student portal administration.
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.
Languages
English
NativeFrench
NativeGerman
AdvancedEducation
Sep 2002 - Jun 2006
Hong Kong University of Science and Technology
Mathematics · Hong Kong
Sep 2000 - Jan 2002
University of Bucharest
M.Sc. · Mathematics · Romania
Sep 1996 - Jun 2000
University of Bucharest
B.Sc. · Mathematics · Romania
Certifications & licenses
ACCP major in core
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.