![sostatus tech sostatus tech](https://suemtravels.files.wordpress.com/2013/03/agean-sea.jpg)
Data reconciliation between RMS and external systems.
#SOSTATUS TECH FULL#
Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.Hands on experience with EDI ISA and GS segments, VAN/FTP/SFTP/AS2 connections and EDI providers.Developed custom package to process Ship from Store (SFS) and Buy Online Pick UP In Store (BOPIS) order requests in RMS.Hands on experience with Electronic Data Interchange documents EDI850, EDI860, EDI846, EDI810, EDI810, EDI855, EDI997, EDI852 documents.Hands on experience in U.S Customs and Border Protection HTS yearly upload into RMS.Have Worked with Oracle Retail Sales Audit ( ReSA), Oracle Retail Price Management ( RPM) and Oracle Retail Invoice Matching ( ReIM) teams and their corresponding integrations.Monitored the production logs during the warranty period and took care of fixing the high severity issues in the expected SLA.Reviewed and provided feedback to offshore team on their developments and enforced Coding standards.Cut over design, planning and coordination to ensure very minimal impact to business operations.Involved in continuous enhancements and fixing of production issues.Developed PLSQL scripts using Pragma Autonomous Transaction to avoid mutating problem in database trigger.Experience in application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.Developed PLSQL scripts using Bulk Collections for easy retrieval of data, by reducing context switching between SQL and PL/SQL.Developed several UNIX shell Scripts to call SQL Loader to load data from flat files into DB according to project and client requirements.Identified integration gaps between systems and provided solutions.Developed technical and functional design documents according to client needs.Direct communication with business team to gather client requirements.Software: Oracle Forms Builder, UC4, SVN, Microsoft Office, Putty, WINSCP, TOAD, IBM Inflight Scripting Languages: Unix shell Scripting, Java Script, HTML, XML Languages: Pro*C, SQL, PLSQL, Python, C++, C Expertise in RMS forms security, New User creation, New Role creation, Role assignment, Security user group Maintenance and User Attribute Maintenance.Īpplications: Oracle Retail Merchandising System, Oracle Retail Integration Bus, BI Publisher, Electronic Data Interchange.Experience in Stock Ledger, Inventory adjustment, Stock Count, Wholesale order creation and Future cost process.Expertise in Custom flex attribute setup (CFAS).Experience in foundation data modules like Org Hierarchy, Merch Hierarchy, Item, Supplier, Store, Warehouse, Location list, Item list, User defined attributes, Cost change.Experience in Purchasing, Shipping, Transfers and Receiving modules.Expertise in developing forms using Oracle Forms Builder.Experience in creating Pro*C scripts to call Database Objects according to the needs of the project.Experience in creating Shell Scripts to invoke SQL scripts and schedule them using Crontab.Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
![sostatus tech sostatus tech](https://images.fineartamerica.com/images-medium-large-5/pharos-of-alexandria-constructed-mary-evans-picture-library.jpg)