SUMMARY

• Having 12+ yrs. of Experience in Oracle Retail Applications systems. Techno - functional consultant. Having experience in below mentioned Oracle Retail modules.
• Extensive Functional Knowledge in Oracle Inventory, Purchasing, Order management item, Shipment & Bills of Materials.
• Developed Interface for Loading data into master system from external system using PL/SQL Shell and Perl script. Real time interfaces like reading sales data and generating transaction log files.
• Developing a process in PL/SQL and Shell for conversion from legacy stores to real stores.
• Worked developing an automated PTL (put to light system) in PLSQL and shell to ship products from DC to Store.
• Developed various automated BI publisher reports fore flash sales, comp sales, real time transactions at store.
• New FTP processed in shell to read multiple files at a time and send to the remote server.
• Expertise in Upgrade/Rollout and Production Support Projects.
• Extensive experience in developing SQL*Loader/External Table control programs and PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Expertise of integration of ORPOS with Oracle retail V13. Recently worked at mills for integration of Oracle retail v13 integration with ORPOS and was involved in the successful go live of this.
• Extensive working experience in Supplier, POs and Item Data Conversions.
• Extensive knowledge of supporting Oracle retail V12 and V13 for implementation and support.

PROFESSIONAL EXPERIENCE

Oracle retail Consultant

Confidential

Responsibilities:

• Associated with major technical/functional enhancements in Oracle Retail suite over the past 2 years.
• Integration of RMS and new Assortment Planning system.
• Development and support of new PTL system for DC integrations
• New Consignment vendor Integration development
• Working in a 24/7 support environment with endless responsibilities.
• Responsible for close monitoring of the Production system. Continuously monitoring the custom jobs and base job.
• Issue analysis, identification of the root causes and resolution.
• Business interaction on issues clarifications, requirements gathering and offshore onsite sync up.
• Regular case follow up, status reporting to all the stake holders.
• Responsible for development of the technical custom objects that comes through CRs.
• Code deployment, Unit testing, Test cycles support and bug fixing.
• Transition activities, Release support.
• Working as a 24/7 support resource in the team with endless responsibilities.
• Involved in looking into the batch issues.
• Working on the critical Tickets related to the various modules like RMS, RPM WMS
• Provide data fix or code fix for the issues arising out of the Batch run
• Working on the various Enhancements.
• Working any new enhancements or change requests.
• Developing new BI reports to integrate with Oracle Retail V13.
• Involved in solving technical/ functional issues, working on major Enhancements.

Oracle retail Consultant

Confidential

Responsibilities:

• Working in a 24/7 support environment with endless responsibilities.
• Responsible for close monitoring of the Production system. Continuously monitoring the custom jobs.
• Issue analysis, identification of the root causes and resolution.
• Business interaction on issues clarifications, requirements gathering and offshore onsite sync up.
• Regular case follow up, status reporting to all the stake holders.
• Responsible for development of the technical custom objects that comes through CRs.
• Code deployment, Unit testing, Test cycles support and bug fixing.
• Transition activities, Release support.
• Working as a 24/7 support resource in the team with endless responsibilities.
• Involved in looking into the batch issues.
• Working on the critical Tickets related to the various modules like RMS, RPM WMS
• Provide data fix or code fix for the issues arising out of the Batch run
• Working on the various Enhancements.
• Working any new enhancements or change requests.
• Developing new BI reports to integrate with Oracle Retail V13.
• Involved in solving technical/ functional issues, working on major Enhancements.

Package Solution Consultant

Confidential

Responsibilities:

• Associated with major technical/functional enhancements in Oracle Retail suite over the past 4 years.
• Worked on developing real time Oracle BI publisher reports (Front end operations/Loss Prevention) integrated the same with ORPOS.
• Involved in developing Packages, Functions, Procedures, Database Triggers, Collections And Record Objects at the back end level using SQL, PL/SQL
• Worked on developing a custom module in Oracle Forms for Mills advertising logos and promotions that involved development of 10-15 Oracle forms. It involves technologies’ like Oracle Forms,Pl/sql,shell script and Proc*C and BI.
• Involved in creating PL/SQL Packages, Functions, Procedures, and Database triggers at The front-end level.
• Working in a 24/7 support environment with endless responsibilities.
• Responsible for close monitoring of the Production system. Continuously monitoring the custom jobs.
• Issue analysis, identification of the root causes and resolution.
• Business interaction on issues clarifications, requirements gathering and offshore onsite sync up.
• Regular case follow up, status reporting to all the stake holders.
• Responsible for development of the technical custom objects that comes through CRs.
• Code deployment, Unit testing, Test cycles support and bug fixing.
• Transition activities, Release support.
• Working as a 24/7 support resource in the team with endless responsibilities.
• Involved in looking into the batch issues.
• Working on the critical Tickets related to the various modules like RMS, RPM WMS
• Provide data fix or code fix for the issues arising out of the Batch run
• Working on the various Enhancements.
• Working any new enhancements or change requests.
• Developing new BI reports to integrate with Oracle Retail V13.
• Involved in solving technical/ functional issues, working on major Enhancements.