Shiva Shankar Pagidala Email & Phone Number

11+ years of experience in design, development and maintenance of Oracle Database back-end applications for supporting Telecom, Banking & Financial, Retail and Health care domain requirements.Have recent experience working in Big Data hadoop platform. Worked on migrating Teradata Datawarehouse process to AWS EMR. Worked on creating pyspark programs and HiveQL queries, Hive tables and views etc.,Extensive experience in Oracle SQL, PL/SQL Programing, and Import / Export Utilities and UNIX shell scripting.Experience in preparing table design as per the requirements specification by applying normalization techniques. Created normalized and de-normalized tables as applicable. Experience in adhering to naming and coding standards while developing application and create required documentation for future reference.Experience in end-to-end database application development and maintenance involving in Requirements discussions, database design, implementation, code review and data modelling etc.,Expert level experience on PL/SQL that includes Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Objects, Collections, Partitioned Tables, Triggers, Materialized view, Oracle Domain text index and Object oriented programming.Experience in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER , External table.Extensive experience in improving the performance of Query by minimizing the number of context switches between the PL/SQL and SQL engines Using TYPES, Collections, Arrays, BULK COLLECT etc.,6+ years of extensive experience in supporting Large production databasesProficient in using UNIX Shell Script and Perl script.Experience in scheduling UNIX cronjobs, Oracle Scheduler jobs. Proficient in using several data loading methods like SQL Loader, Export/Import and Datapump methods.

Listed skills include Teradata, Requirements Analysis, Sdlc, Sql Loader, and 15 others.

• 

  Ssj Engineering College

  Electrical And Electronics Engineering