Sign in

Oracle Plsql, SQL, Unix shell scripting, Oracle retail

Chennai, Tamil Nadu, India
October 14, 2018

Contact this candidate


Oracle Retail Techno-Functional Consultant


Mobile: +91-893*******


To get a challenging position in an organization where I can effectively contribute my skills and develop my career by continuously upgrading myself with latest technologies to meet new challenges.


Over 3 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Experience with Oracle retail store inventory management (ORSIM), Oracle Retail Merchandising System (RMS) and Retail Price Management (RPM) and Oracle Retail Sales Audit (ReSA) as a functional consultant.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Expertise in Client-Server application development using Oracle 12c/11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Strong Functional Expertise on ORMS, RPM, ORSIM, ReSA and its integral impact across all the impacted modules (Foundation Set up, Requirement mapping, Workaround, integration, Extensive QA, Raising and Handling Oracle SRs for Base Issues across modules-ORSIM / RMS)

Versions handled ORSIM, ORMS, RPM, ReSA (v14.x).

Have experience in Post Go-Live Implementation support for Oracle Retail Products and its interface with Legacy Applications.

Developed web service API methods using PL/SQL, SQL/XML and XML to enable conferencing resellers to write their own clients to interface with our web conferencing platform.

Strong knowledge on Unix shell scripting and Automic/UC4 batch scripting. Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.


Excellent expertise in Shell and Unix programming

Sound programming skills

Exceptional understanding of inheriting casting and converting PL/SQL objects

High proficiency in developing Oracle PL/SQL packages

Superior knowledge of front-end reporting tools

Expertise on Oracle retail applications (RMS, RPM, SIM and ReSA)

Environment: Oracle 11g/12c, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, XML, Pro*C, Java and Python.


Organization - Logic Information Systems (India) Private Limited, Chennai. Client: Confidential

Project: Upgrade from 14.1.0 to 14.1.3 Oct 2017 – Present

Worked in the End-To-End life cycle of the version upgrade from 14.1.0 to 14.1.3

Performed complete testing on all the defect raised on the PLSQL/SQL packages for the lower version.

Performed End-To-End functional/integration testing with the retails modules RMS, SIM, RPM, ReSA and RIB.

Development/Implementation of custom changes with respect to the upgraded 14.1.3 version using PLSQL and Unix shell scripts.

Prepared test case documents on all tested scenarios and presented a complete End- To-End DEMO to the client on the all the modules RMS, RPM, ReSA, SIM and BIP.

Requirement gathering from the business Users and preparation of High/Low Level designs.

Impact Analysis document preparation and client communication for all the enhancements.

Developed PL/SQL block for Oracle Reports with respect to gathered requirements.

Development of shell script to automate hourly reporting.

Development of Stored Procedure/Standalone functions to meet up the changes suggested by the Client.

Development of Automic/UC4 scripting to support the automations and customizations requested by the client.

Impact Analysis document preparation and client communication for all the enhancements.

Participation in Code Review & Unit Testing and supported UAT.

Worked on RPM complex promotions implementation and tested the complex promotion scenarios requested by the Business.

Worked with Oracle on defects and performed code retrofits to achieve the business scenarios in complex promotions.

Worked on the Performance issue of the RPM batches.

Worked on Stock count process Automation/implementation and provided post go- live support.

Worked on Automating Sales reports generation from BIP.

Worked on Implementation and support of the Oracle Retail modules. Client: Confidential

Project: Development/Implementation and post go-live support


Sep 2016 – Sep 2017

Client: Confidential

Project: Development/Implementation and post go-live support


Sep 2016 – Sep 2017

Client: Confidential

Project: Development/Implementation and post go-live support


Jun 2015 – Sep 2016

Worked on Enhancements and requirement gathering for the Store Rollout customization in RMS.

Worked on automating SIM application user creation module.

Worked on ORSIM – ORMS integration testing.

Involved in End-To-End business cycle testing and implementation for Item Maintenance.

Worked with team to prepare the schedules Oracle BI-reports. EDUCATION

Bachelor of Engineering, from Arignar Anna Institute of science and Technology India. TRAINING / CERTIFICATIONS


Redhat Linux administration.


I hereby declare that above mentioned statements are true to best of my knowledge. Date:

Place: (Nila.S.R)

Contact this candidate