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 total data extraction time reduced drastically.• 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.