Srinu Narra

About Srinu Narra

Techno consultant in Oracle Retail having experience in solving client queries related to Retek Merchandising System (RMS). Strong technical knowledge in SQL, PL/SQL, Shell Scripting, Pro*C, Hold a Master of Science (M.Sc.) degree in Computer Science from Acharya Nagarjuna University.Key Roles:Work on Retail Functional Modules like Merchandising Foundation Data, Transfers, Allocation, Purchase Order, Replenishment, ReSA, Stock Count and Stock Ledger, and solved business incidents by directly communicating with client and business users.

Experience

1. Technical Consultant

   EY

   Mar 2023 — Present · Bengaluru, IN

   Strong technical knowledge in Oracle SQL, PL/SQL, and shell scripting->Experienced in understanding and managing data flow between the Oracle Retail Merchandising System (ORMS) and the Retail Integration Bus (RIB)->Experienced in UC4 and AutoSys batch Monitoring->Implemented SQL and PL/SQL logic to generate commissions in the Insurance domain, including AUM-based commissions for agents and leaders, as well as FYC (First Year Commission) calculations for both positive and reversal commissions->understanding of the commission flow throughout the AUM-based agent and leader hierarchy, as well as the standard FYC (First Year Commission) lifecycle in the life insurance domain->Developed one of the commission types, DSF PTE (Part-Time Agent), which includes commission calculations at various DSF-PTE levels such as Agent, SM (Sales Manager), and RM (Regional Manager), along with the hierarchy for generating both positive commissions and reversal amounts-> Developed new scripts for setting up products based on user-defined functionality in the Life Insurance domain->Identified scenarios where positive and negative commissions were not flowing correctly due to validation failures in policy conditions->RCA for commission disconnection for agents and implementing fixes->Performing hypercare support for cases where agent commissions were not generated->Developing patch scripts to regenerate commissions for specific cases where they were not processed correctly->Performed sanity and unit testing before code deployment->After deployment, validated that the values and entries were correctly populated->Used the debugger in SQL Developer whenever needed to identify the root cause (RCA) for commission disconnection or commission not being generated for agents->Basic knowledge of core Java.

Education

• Acharya Nagarjuna University

  Master's degree

  2021 — 2023

• Acharya Nagarjuna University

  Bachelor's degree

  2015 — 2018