RAVIKANTH NERADI

Provide operational support for all deployed Oracle HCM Cloud modules globally.
Troubleshoot issues to isolate root cause and recommend or implement fixes.
Manage application setup and configuration for enhancements delivering added functionality.

• Implemented quality control measures for analytical processes, maintaining high standards.
• Mentored junior analysts, providing guidance and support to foster professional development.

• Write complex SQL, PL/SQL functions, procedures, and packages.
• Develop stored procedures, database triggers, and Oracle packages.
• Design technical database structures against business requirements.
• Create Oracle objects including tables, materialized views, triggers, and synonyms.
• Analyse performance bottlenecks and tune queries for SLA targets.
• Supported backend storage through Unix and SQL design changes to enhance system performance.
• Create Unix shell scripts for parameter files and FTP workflows.
• Build reusable components for error handling, audit tracking, and control processes.
• Monitored daily job reports to ensure expected processing behaviour and identify issues proactively.
• Coordinate UAT with business teams and manage defects in Jira.
• Prepare SDLC artefacts such as RTM, LLD, HLD, and unit tests.
• Gathered requirements with the team and initiated assignments promptly.
• Analyse warranty and post-warranty issues and provide short-term remedies.
• Define long-term solutions after root-cause analysis for warranty issues.

• Writing Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Development of stored procedures, database triggers & database packages on oracle.
• Development of PI/Sql code and golden gate scripts to move the data from source to destination.
• Analysed performance bottlenecks and optimised stored procedures and database queries to ensure compliance with SLA requirements.
• Data warehousing & Business Intelligence programming using Oracle Golden Gate, ODI, OBIEE and Dimensional data modelling.
• Collaborated with users to gather requirements for data and object migration functionality.
• Produce technical database designs in response to business requirements.
• Designing the architecture for reverse migration.
• Work on UNIX and SQL design to maintain the backend application and storage.
• Development of UNIX shell scripts to pre-process and post-process activities such as parameter file creation, FTP source & target files, archiving, sending email notifications etc.
• Product backlog grooming and sprint planning meetings and assigning sprint tasks to the team.
• Developed reusable components for error handling, audit tracking, and process control, enhancing system reliability.
• Preparation of project artifacts such as Requirements Traceability Matrix, Low Level Design, High Level Design, and Unit Test Results etc. involved at all phases of SDLC.
• Mentored team members on best practices and project requirements., performing code reviews, conducting brainstorming sessions, performing technical interviews, mentoring new members and bringing them up to speed per the project needs.
• Environment: Oracle 12c, PLSQL, UNIX, SQL Developer Modeler, SVN, Tivoli & Rally, Jenkins

• Designing the architecture for reverse migration.
• Collaborated with users to gather requirements for functionality to migrate data and objects.
• Produce technical database designs in response to business requirements.
• Data warehousing & Business Intelligence programming using Oracle Golden Gate, ODI, OBIEE and Dimensional data modelling.
• Project release management using Agile (Scrum), waterfall and spiral methodologies of software development process.
• Writing Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Work on UNIX and SQL design to maintain the backend application and storage.
• Product backlog grooming and sprint planning meetings and assigning sprint tasks to the team.
• Development of PI/Sql code and golden gate scripts to move the data from source to destination.
• Development of stored procedures, database triggers & database packages on oracle.
• Development of UNIX shell scripts to pre-process and post-process activities such as parameter file creation, FTP source & target files, archiving, sending email notifications etc.
• Analysis of performance bottlenecks and tuning of the stored procedures & database queries to meet the SLA requirements.
• Coordinated user acceptance testing sessions, ensuring functionality met user requirements, while managing business and defect tracking using Rally tool and facilitating defect fixes and approvals for production deployment.
• Guided team members through code reviews, brainstorming sessions, technical interviews, and mentoring new members to align with project needs.
• Environment: Oracle 12c, PLSQL, UNIX, SQL Developer Modeler, SVN, Tivoli & Rally, Jenkins

• Development of stored procedures, database triggers & database packages on oracle.
• Analysis of performance bottlenecks and tuning of the stored procedures & database queries to meet the SLA requirements.
• Developed software enhancements and new features to enhance user experience.
• Developed reusable software components for improved efficiency. for error handling, audit tracking & process controlling.
• Development of UNIX shell scripts to pre-process and post-process activities such as parameter file creation, FTP source & target files, archiving, sending email notifications etc.
• Coordinated with upstream and downstream systems to implement business changes across the organisation.
• Guided team members through technical challenges, conducted code reviews, and provided mentoring to new members to ensure project alignment.
• Coordinated User Acceptance Testing with stakeholders to ensure requirements were met. with business and defect tracking using Rally tool. Defect fixes, support and follow up on necessary approvals for production deployment
• Preparation of project artifacts such as Requirements Traceability Matrix, Low Level Design, High Level Design, Unit Test Results etc. involved at all phases of SDLC.
• Product backlog grooming and sprint planning meetings and assigning sprint tasks to the team.
• Environment: Oracle 12c, PLSQL, UNIX, SQL Developer Modeler, SVN, Tivoli & Rally, Jenkins

• Responsible for logical and physical database design, implementation, transforming logical data Models into physical databases, and defining strategies for database implementation, high performance.
• Created and managed database objects including tables, indexes, partitioned tables, and views to support application functionality.
• Created materialized views and partitioned the Oracle tables to improve reporting performance.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Optimised SQL and database performance through analysis of AWR, TKPROF Reports, Statspack, and Explain Plans, monitoring performance daily.
• Worked on import/export, data pump and SQL
• Loader.
• Created and managed users, roles, privileges, profiles, schemas using Oracle Enterprise Manager.
• Worked on import/export, data pump and SQL Loader.
• Sizing the databases for future growth.
• Maintenance of security administration of DB2 databases including instance/database level authorities.
• Conducted DB2 to Oracle migration activities.
• Collaborate with senior system architects to pin down detailed server requirements when being migrated from DB2-Oracle.
• Analyze differences between DB2 and ORACLE systems to list and automate the migration. Evaluated the tools used for migration, Oracle SQL developer migration wizard, Swiss SQL (for PL/SQL migration), Oracle migration workbench.
• Evaluation of multiple migration tools Oracle Golden Gate for online data migration between DB2 to Oracle.
• Automated DDL and data migration from DB2 to Oracle using shell scripts, enabling parallel execution to enhance production migration efficiency.
• Designed the process for DBCR implementation for both DB2 and Oracle systems of VPLAN.
• Designed the process for DBCR implementation for both DB2 and Oracle systems of VPLAN.

• Primary responsibilities include writing complex SQL queries and PL/SQL procedures.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database.
• Developed PL/SQL scripts to extract data from an operational database into flat text files, streamlining data access for reporting.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Extensively involved in using hints to direct the optimiser to choose an optimum query execution plan.
• Performed tuning and maintenance of databases using Automatic Workload.
• Managed database space and resolved deadlock issues, improving overall database performance and stability.
• Optimised processes for Oracle database installations, upgrades, space management, and disaster recovery, enhancing system reliability and performance.
• Collaborated with other leads on designing and implementation of ALMS to Verizon engineers.
• Formulated an abstraction strategy in designing and implementing LP system using PL/SQL functions to provide PRS access to vendors.
• Designed the process for DBCR implementation in PRS.
• Automated the data merge between multiple schemas for Web migration of PRS.

• Coding Client Side and Database PL/SQL Procedures, Functions and Packages.
• Conducted unit testing to ensure software functionality and reliability.
• Resolved client-reported issues to improve customer satisfaction.
• Developed user-friendly forms to enhance data collection efficiency.
• Produced comprehensive reports to identify project outcomes and trends.
• Preparation of Technical Documentation.
• Environment: Oracle 10g, PLSQL, SQL, UNIX, Oracle Enterprise Manager Database Control, SQL Developer, Toad.

• Developed PL/SQL stored procedures, functions, and packages to enhance database functionality.
• Resolving Production Issues.
• Conducted unit testing on software components to ensure functionality.
• Managed client change requests for forms and reports to ensure requirements were met.
• Logged and reported software bugs for resolution by the development team.
• Created technical documents based on specifications to support development and maintenance processes.