Oracle Retail Techno-Functional Consultant
NILA.S.R
Mobile: +91-893*******
Email:ac7dps@r.postjobfree.com.
CAREER OBJECTIVE:
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.
SUMMARY
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.
CORE COMPETANCY
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.
PROFESSIONAL EXPERIENCE
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
(v14.1.0)
Sep 2016 – Sep 2017
Client: Confidential
Project: Development/Implementation and post go-live support
(v14.1.0)
Sep 2016 – Sep 2017
Client: Confidential
Project: Development/Implementation and post go-live support
(v14.1.0)
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
Oracle SQL/PLSQL
Redhat Linux administration.
DECLARATION
I hereby declare that above mentioned statements are true to best of my knowledge. Date:
Place: (Nila.S.R)