Designed and developed Oracle Forms and Reports to manage hospital IT systems, generating up to 60 reports
Automated daily ETL operations and database maintenance through PL/SQL scripts, using SQL*Loader, UTL_FILE, DBMS_SQL, collections and bulk binding for daily data loads
Created dynamic SQL queries for reporting and data extraction, and wrote PL/SQL programs, triggers and stored procedures for data conversions, integration and real time validation
Responsibilities
Designed and developed Oracle Forms and Reports to manage hospital IT systems, generating up to 60 reports
Automated daily ETL operations and database maintenance through PL/SQL scripts, using SQL*Loader, UTL_FILE, DBMS_SQL, collections and bulk binding for daily data loads
Created dynamic SQL queries for reporting and data extraction, and wrote PL/SQL programs, triggers and stored procedures for data conversions, integration and real time validation
Linked-in
Google