Jira
Rakesh Pradhan
Service Analyst
Bengaluru
Summary
Oracle Retail Consultant with 2+ years of experience supporting and enhancing Oracle Retail applications including RMS, SIM, SIOCS, ReIM, and IMCS. Experienced in PL/SQL development, Unix shell scripting, Java customization, system integrations, and production support. Skilled in analyzing business requirements, troubleshooting complex issues, automating business processes, and developing XML/SFTP-based integrations. Proven ability to collaborate with business stakeholders and cross-functional teams to support store operations, invoice matching, inventory management, stock counts, month-end activities, and new store onboarding. Strong analytical, problem-solving, and technical support skills with a focus on delivering reliable retail solutions.
Overview
3
3
Languages
1
1
Certification
2
2
years of professional experience
Work History
Service Analyst
OLR
04.2024 - Current
• Worked on Oracle Retail applications including RMS, SIM, SIOCS, ReIM, and IMCS, supporting retail business operations and production issues.
• Collaborated with business users and Oracle teams to analyze requirements, troubleshoot issues, and deliver solutions.
• Developed and maintained PL/SQL packages, procedures, functions, and database objects for business enhancements and support.
• Automated invoice resolution processes in ReIM, reducing manual effort and improving operational efficiency.
• Supported new store setup and configuration activities in RMS to facilitate store openings.
• Supported month-end business activities and inventory processes by coordinating with stakeholders and resolving critical issues.
• Assisted in stock count execution, reconciliation, and inventory validation activities across retail stores.
• Developed Excel reports and performed data analysis to support business operations and issue resolution.
Coordinated month-end business activities and inventory processes with stakeholders.
• Created and maintained Unix shell scripts for batch automation, file processing, and monitoring activities.
• Worked on Java-based customizations and troubleshooting of Oracle Retail applications.
• Developed XML-based integrations and automated file transfers through SFTP to external systems.
• Participated in application upgrades, patch testing, and post-deployment validation activities.
Education
Bachelor of Technology - Computer Science
Synergy Institute of Technology
Bhubaneswar 04.2001 -
Skills
Oracle Retail RMS, SIM, SIOCS, ReIM, IMCS
PL/SQL SQL Unix Shell Scripting
Data Analysis
Network troubleshooting
User acceptance testing
Application support
Incident management
Oracle Database Excel Production Support
Retail Operations
Software
SQL Developer
J Developer
Putty
Eclipse
Certification
Oracle Apex professional Certification
Timeline
Service Analyst
OLR
04.2024 - Current
Bachelor of Technology - Computer Science
Synergy Institute of Technology
04.2001 -