Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Shik Shashavali

Shik Shashavali

Summary

I am a dedicated and results-oriented professional with nearly three years of hands-on experience in SQL queries and a specialization in developing Oracle BIP reports within the Oracle Cloud Fusion environment. My proficiency includes debugging reports, resolving bugs, troubleshooting, and optimizing performance to ensure seamless operations. I am skilled in working with REST and SOAP APIs for data retrieval and manipulation tasks. My expertise extends to leveraging Groovy scripts to enhance functionalities within the order management module and actively participating in item data load activities to support the product hub module. Currently, I am expanding my knowledge in Oracle Integration Cloud (OIC) and Visual Builder Cloud Service (VBCS) modules, reflecting my commitment to continuous learning and professional growth.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Oracle Application Developer

IBM
06.2022 - Current


  • I developed BIP reports to support daily business activities, enabling data extraction in various formats as needed for business operations.
  • Enhanced the Shipping Execution to permit shipping based on the scheduled ship date and shipping methods with the help scale the system (WMS).
  • Customized the sophisticated AR Invoice report to produce outputs based on country-specific templates, ensuring the data is displayed clearly and understandably in PDF format through the RTF template.
  • By fine-tuning the execution process of multiple BIP reports, I managed to reduce their runtime, enabling quicker access to results from the Oracle Analytics UI, SOAP API, or any external systems. This enhancement greatly improves overall system responsiveness and user experience.
  • I developed notification triggers to alert the relevant teams whenever a job or program is running for an extended period, potentially causing performance issues in the system. This enables the team to promptly investigate the job and take any necessary action.
  • Delivered comprehensive Technical Design documentation for the project, including specifications for VBCS page creation, OIC integration, and BIP report setup. Throughout, I maintained alignment with Agile Methodology practices, ensuring timely delivery and meeting all project specifications.
  • Providing close support to business users, assisting them in overcoming challenges, and collaborating with functional consultants to ensure thorough testing of implemented solutions.
  • Engaged in addressing Incidents and Jira cards aimed at resolving the bug and improving the current functionality.

Oracle Technical Consultant

IBM
08.2021 - 05.2022


  • Offering support and implementing enhancements for Oracle technical components, including BIP reports, during the post-production phase.
  • Proactively identify the potential issues with the business process and system and provide the most efficient and timely remedies to handle the issues.
  • Analyze the issues raised by the end users , Identify the root causes and consistently reduced the number of issues drastically ensuring smooth functioning of the application.
  • Developed a robust Groovy script in our order management system to derive the shipping method based on attributes of product hub items. This initiative has greatly improved the accuracy and safety of item shipments, providing substantial support to our business in meeting operational goals.
  • Engaged in the development of RICE objects and ensuring timely delivery of assigned tasks.
  • In the early days of my assignment, I participated in tasks related to loading item data into the system.

Education

Bachelor of Technology - Electronics and Communications Engineering

Gates Institute of Technology
Atamakur, Andhra Pradesh
04.2019

Skills

  • Oracle BIP Reports, Data Modeling
  • Templates (rtf,excel, xpt)
  • OIC
  • Groovy Script
  • Performance Tuning
  • Oracle PL/ SQL
  • Debugging/ Troubleshooting
  • Oracle Integrations

Certification

  • Oracle Cloud Data Management 2023 Certified Foundations Associate
  • Oracle Cloud Infrastructure 2023 Certified Application Integration Professional

Timeline

Oracle Application Developer

IBM
06.2022 - Current

Oracle Technical Consultant

IBM
08.2021 - 05.2022

Bachelor of Technology - Electronics and Communications Engineering

Gates Institute of Technology
Shik Shashavali