Senior Database Developer
Current- GoSaaS Migrator: Created efficient scripts and set of Stored Procedures in PL/SQL to automate the data extraction from Oracle AgilePLM without having to write separate scripts for each customer. With these scripts the.
- GoSaaS Archiver Portal: Designed the database of a product that stores historical data and created ETL scripts in PL/SQL and PL/pgSQL to extract, transform and load data from Oracle AgilePLM to GoSaaS Archiver Portal.
- Worked on multiple ETL projects to load data from Oracle AgilePLM to Oracle Fusion Cloud
- Interacted with Customers and business analysts for requirement gathering and estimations.
- Created Dashboards, Data Models and Reports using Oracle OTBI and BI Publisher.
- Tuned existing SQL scripts and reports.