Hi,
I performed database related jobs using SQL queries explained below.
- Cognos Project
- Oracle Financials (Oracle EBS) Project
- Oracle Transportation Management (OTM) Project
- Siber Logistics Software Project
For the above projects:
- I performed data cleansing, uploading cleaned data.
- I wrote queries running automatically and sending alert messages to users automatically (say about missing customer/supplier data)
- I wrote Oracle packages to send automatic emails (Arrival Notice messages, Cargo Spec messages, Invoices, Reconciliation Letters) to customers at predefined time intervals.
- I developed reports or enhanced performance of queries in the reports using Oracle Reports, Oracle BI reports, Oracle SQL, Stored Procedures/Functions, and packages.
For a financial institution where reports were written in VBA with Oracle Database behind, I did performance improvement for many SQLs in the reports.
Shortly I have the following experience:
• 10-year experience of Oracle database programming (SQL)
• 5-year experience of BI report development in Oracle Financials
• 5-year experience of BI report development in Oracle EBS (GL, AR, AP, CM, FA)
So I can write your queries without any issues.
Regards
Huseyin